API

Standard API of Rice Components

1. FND_PROGRAM.EXECUTABLE();

2. FND_PROGRAM.DELETE_EXECUTABLE();

3. FND_PROGRAM.REGISTER();

4. FND_PROGRAM.DELETE_PROGRAM();

5. FND_PROGRAM.PARAMETER();

6. FND_PROGRAM.DELETE_PARAMETER();

7. FND_PROGRAM.INCOMPATIBILITY();

 

8. FND_PROGRAM.DELETE_INCOMPATIBILITY();

9. FND_PROGRAM.REQUEST_GROUP();

10. FND_PROGRAM.DELETE_GROUP();

11. FND_PROGRAM.ADD_TO_GROUP();

12. FND_PROGRAM.REMOVE_FROM_GROUP();

13. FND_REQUEST.SUBMIT_REQUEST();

14. FND_CONCURRENT.WAIT_FOR_REQUEST();

15. FND_PROFILE.VALUE();

16. FND_PROFILE.SAVE();

17. FND_PROFILE.GET();

18. FND_MESSAGE.SET_NAME();

19. FND_MESSAGE.CLEAR();

20. FND_MESSAGE.GET();

21. FND_MESSAGE.SET_TOKEN();

22. FND_MESSAGE.RAISE_ERROR();

23. FND_MESSAGE.GET_STRING();

24. FND_MESSAGE.SET_NAME();

25. FND_MESSAGE.PUT();

26. FND_GLOBAL.APPS_INITIALIZE()

27. FND_GLOBAL.LOGIN_ID();

28. FND_GLOBAL.APPLICATION_ID();

29. FND_GLOBAL.USER_ID();

30. FND_GLOBAL.ORG_ID();

31. FND_GLOBAL.CONC_PROGRAM_ID();

32. FND_GLOBAL.CONC_REQUEST_ID();

33. FND_USER_PKG.CREATEUSER();

34. FND_USER_PKG.UPDATEUSER();

35. FND_USER_PKG.DISABLEUSER();

Advertisements

Enable/Disable Oracle Application Login User by API

How to Disable(end date) large number of Users in Oracle Apps
How to end date large number of Users – fnd_users in Oracle Apps

To Disable/Enable bulk number of users in oracle Applications, we have a API

apps.fnd_user_pkg.EnableUser =>To Enable Users
apps.fnd_user_pkg.DisableUser =>To Disable Users,

Below is the syntax which can used to Huge number of Users in one GO !!
————————————————————————————-

declare cursor cur1 is
select user_name from apps.fnd_user where LOWER(user_name) Not IN (‘username’,’username’, …….);
begin
for all_user in cur1 loop
apps.fnd_user_pkg.EnableUser(all_user.user_name);
commit;
end loop;
End;

——————————————————————————————-

declare cursor cur1 is
select user_name from apps.fnd_user where LOWER(user_name) Not IN (‘username’,’username’, …….);
begin
for all_user in cur1 loop
apps.fnd_user_pkg.DisableUser(all_user.user_name);
commit;
end loop;
End;

Delete Responsibility From Backend in Oracle Apps

/* Formatted on 2017/04/20 12:15 (Formatter Plus v4.8.8) */
DECLARE
v_user_name VARCHAR2 (100) := ‘SAJAL’;
v_responsibility_name VARCHAR2 (100) := ‘Application Developer’;
v_application_name VARCHAR2 (100) := NULL;
v_responsibility_key VARCHAR2 (100) := NULL;
v_security_group VARCHAR2 (100) := NULL;
BEGIN
SELECT fa.application_short_name, fr.responsibility_key,
frg.security_group_key
INTO v_application_name, v_responsibility_key,
v_security_group
FROM fnd_responsibility fr,
fnd_application fa,
fnd_security_groups frg,
fnd_responsibility_tl frt
WHERE fr.application_id = fa.application_id
AND fr.data_group_id = frg.security_group_id
AND fr.responsibility_id = frt.responsibility_id
AND frt.LANGUAGE = USERENV (‘LANG’)
AND frt.responsibility_name = v_responsibility_name;

fnd_user_pkg.delresp (username => v_user_name,
resp_app => v_application_name,
resp_key => v_responsibility_key,
security_group => v_security_group
);
COMMIT;
DBMS_OUTPUT.put_line ( ‘Responsiblity ‘
|| v_responsibility_name
|| ‘ is removed from the user ‘
|| v_user_name
|| ‘ Successfully’
);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line
( ‘Error encountered while deleting responsibilty from the user and the error is ‘
|| SQLERRM
);
END;
/

Delete Concurrent Program and Executable from Backend in Oracle Apps

DECLARE
l_prog_short_name VARCHAR2 (240);
l_exec_short_name VARCHAR2 (240);
l_appl_full_name VARCHAR2 (240);
l_appl_short_name VARCHAR2 (240);
l_del_prog_flag VARCHAR2 (1) := ‘Y’; –Set flag whether to delete Concurrent program or not
l_del_exec_flag VARCHAR2 (1) := ‘Y’; –Set flag whether to delete executable or not
BEGIN

— set concurrent program and executable short name

l_prog_short_name := ‘XX_TEST_CP’; — Concurrent program short name
l_exec_short_name := ‘XX_TEST_EXEC’; — Executable short name
l_appl_full_name := ‘XX Custom Application’; — Application full name
l_appl_short_name := ‘XXCUST’; — Application Short name


— Check if the program exists. if found, delete the program

IF fnd_program.program_exists (l_prog_short_name, l_appl_short_name)
AND fnd_program.executable_exists (l_exec_short_name, l_appl_short_name)
THEN

IF l_del_prog_flag = ‘Y’
THEN

–API call to delete Concurrent Program

fnd_program.delete_program (l_prog_short_name, l_appl_full_name);

END IF;

IF l_del_exec_flag = ‘Y’
THEN

–API call to delete Executable

fnd_program.delete_executable (l_exec_short_name, l_appl_full_name);

END IF;
COMMIT;

DBMS_OUTPUT.put_line (‘Concurrent Program ‘||l_prog_short_name || ‘ deleted successfully’);
DBMS_OUTPUT.put_line (‘Executable ‘||l_exec_short_name || ‘ deleted successfully’);

— if the program does not exist in the system

ELSE
DBMS_OUTPUT.put_line (l_prog_short_name ||’ or ‘||l_exec_short_name|| ‘ not found’);
END IF;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (‘Error while deleting: ‘ || SQLERRM);
END;