DECLARE
g_message VARCHAR2(2000);
BEGIN
DECLARE
p_short_name VARCHAR2(200) := 'Payroll Activity Report'; -- Request Set Short Name
p_application VARCHAR2(200) := 'PAY'; -- Request Set Application Short Name
p_request_group VARCHAR2(200) := 'System Administrator Reports'; -- Request Group Name
p_group_application VARCHAR2(200) := 'FND'; -- Request Group Application Short Name
BEGIN
IF fnd_set.set_in_group ( request_set => p_short_name , set_application => p_application , request_group => p_request_group , group_application => p_group_application ) THEN
fnd_set.remove_set_from_group ( request_set => p_short_name , set_application => p_application , request_group => p_request_group , group_application => p_group_application );
g_message := 'Request Set ' || p_short_name || ' is already in request group ' || p_request_group;
dbms_output.put_line (g_message);
fnd_set.add_set_to_group(request_set => p_short_name, set_application => p_application , request_group => p_request_group , group_application => p_group_application );
g_message := 'Request Set ' || p_short_name || ' is added into request group ' || p_request_group;
dbms_output.put_line (g_message);
ELSE
fnd_set.add_set_to_group (request_set => p_short_name , set_application => p_application , request_group => p_request_group , group_application => p_group_application );
g_message := 'Request Set ' || p_short_name || ' is added into request group ' || p_request_group;
dbms_output.put_line (g_message);
END IF;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line (fnd_program.message);
dbms_output.put_line (SUBSTR (sqlerrm, 1, 100));
END;
END;
g_message VARCHAR2(2000);
BEGIN
DECLARE
p_short_name VARCHAR2(200) := 'Payroll Activity Report'; -- Request Set Short Name
p_application VARCHAR2(200) := 'PAY'; -- Request Set Application Short Name
p_request_group VARCHAR2(200) := 'System Administrator Reports'; -- Request Group Name
p_group_application VARCHAR2(200) := 'FND'; -- Request Group Application Short Name
BEGIN
IF fnd_set.set_in_group ( request_set => p_short_name , set_application => p_application , request_group => p_request_group , group_application => p_group_application ) THEN
fnd_set.remove_set_from_group ( request_set => p_short_name , set_application => p_application , request_group => p_request_group , group_application => p_group_application );
g_message := 'Request Set ' || p_short_name || ' is already in request group ' || p_request_group;
dbms_output.put_line (g_message);
fnd_set.add_set_to_group(request_set => p_short_name, set_application => p_application , request_group => p_request_group , group_application => p_group_application );
g_message := 'Request Set ' || p_short_name || ' is added into request group ' || p_request_group;
dbms_output.put_line (g_message);
ELSE
fnd_set.add_set_to_group (request_set => p_short_name , set_application => p_application , request_group => p_request_group , group_application => p_group_application );
g_message := 'Request Set ' || p_short_name || ' is added into request group ' || p_request_group;
dbms_output.put_line (g_message);
END IF;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line (fnd_program.message);
dbms_output.put_line (SUBSTR (sqlerrm, 1, 100));
END;
END;
No comments:
Post a Comment