eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_DATA_SEC_APIS_PKG

Line 1: PACKAGE BODY IGS_SC_DATA_SEC_APIS_PKG AS

1: PACKAGE BODY IGS_SC_DATA_SEC_APIS_PKG AS
2: /* $Header: IGSSC02B.pls 120.12 2006/04/19 02:13:02 gmaheswa ship $ */
3:
4: /******************************************************************
5:

Line 39: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_SC_DATA_SEC_APIS_PKG';

35:
36: -- -----------------------------------------------------------------
37: -- Define the global variables to be used in this package.
38: -- -----------------------------------------------------------------
39: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_SC_DATA_SEC_APIS_PKG';
40: g_upgrade_mode VARCHAR2(1) := 'N';
41:
42: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_sc_data_sec_apis_pkg';
43: l_label VARCHAR2(4000);

Line 42: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_sc_data_sec_apis_pkg';

38: -- -----------------------------------------------------------------
39: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_SC_DATA_SEC_APIS_PKG';
40: g_upgrade_mode VARCHAR2(1) := 'N';
41:
42: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_sc_data_sec_apis_pkg';
43: l_label VARCHAR2(4000);
44: l_debug_str VARCHAR2(32000);
45:
46: -- -----------------------------------------------------------------

Line 157: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant';

153: l_user_group_id wf_local_roles.orig_system_id%TYPE;
154:
155: BEGIN
156: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
157: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant';
158: l_debug_str := 'Grant ID: '||p_grant_id||','||'Role ID: '||','||p_user_group_id||','||' Object Group ID: '||p_obj_group_id
159: ||','||' Grant Name: '||p_grant_name||','||' Grant Text: '||p_grant_text||','||'Select Flag: '||p_grant_select_flag
160: ||','||' Insert Flag: '||p_grant_insert_flag||','||' Update Flag: '||p_grant_update_flag||','||' Delete Flag: '||p_grant_delete_flag;
161: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 303: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant.Ex_UN';

299: p_count => l_message_count,
300: p_data => x_return_message);
301: ROLLBACK TO Insert_Grant_SP;
302: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
303: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant.Ex_UN';
304: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||','||' Grant Name: '||p_grant_name||','||'Error Message: '||x_return_message;
305: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
306: END IF;
307:

Line 316: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant.Ex_error';

312: p_count => l_message_count,
313: p_data => x_return_message);
314: ROLLBACK TO Insert_Grant_SP;
315: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
316: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant.Ex_error';
317: l_debug_str := 'Handled Exception: Grant ID: '||p_grant_id||','||' Grant Name: '||p_grant_name||','||'Error Message: '||x_return_message;
318: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
319: END IF;
320:

Line 332: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant.Ex_others';

328: p_data => x_return_message);
329: ROLLBACK TO Insert_Grant_SP;
330:
331: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
332: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant.Ex_others';
333: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||','||' Grant Name: '||p_grant_name||','||'Error Message: '||x_return_message;
334: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
335: END IF;
336:

Line 389: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond';

385: l_grant_id igs_sc_grants.grant_id%TYPE := p_grant_id;
386:
387: BEGIN
388: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
389: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond';
390: l_debug_str := 'Grant ID: '||p_grant_id||','||' Object Attribute ID: '||p_obj_attrib_id||','||'User Attribute ID: '||p_user_attrib_id
391: ||','||'Condition: '||p_condition||','||' Text Value: '||p_text_value||','||'Grant Cond Number: '||p_grant_cond_num;
392: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
393: END IF;

Line 512: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond.Ex_error';

508: p_data => x_return_message);
509: ROLLBACK TO Insert_Grant_Cond_SP;
510:
511: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
512: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond.Ex_error';
513: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||','||' Condtion Number: '||p_grant_cond_num||','||'Error Message: '||x_return_message;
514: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
515: END IF;
516:

Line 526: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond.Ex_un';

522: p_data => x_return_message);
523: ROLLBACK TO Insert_Grant_Cond_SP;
524:
525: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
526: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond.Ex_un';
527: l_debug_str := 'Handled Exception: Grant ID: '||p_grant_id||','||' Condtion Number: '||p_grant_cond_num||','||'Error Message: '||x_return_message;
528: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
529: END IF;
530:

Line 542: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond.Ex_others';

538: p_data => x_return_message);
539: ROLLBACK TO Insert_Grant_Cond_SP;
540:
541: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
542: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond.Ex_others';
543: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||','||' Condtion Number: '||p_grant_cond_num||','||'Error Message: '||x_return_message;
544: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
545: END IF;
546:

Line 1782: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role';

1778: -- -----------------------------------------------------------------
1779:
1780: BEGIN
1781: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1782: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role';
1783: l_debug_str := 'Role Name: '||p_role_name||','||' Role Display Name: '||p_role_display_name||','||'Role Orig System: '||p_orig_system
1784: ||','||' Role Orig System ID: '||p_orig_system_id;
1785: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1786: END IF;

Line 1849: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role.Ex_UN';

1845: p_count => l_message_count,
1846: p_data => x_return_message);
1847: ROLLBACK TO Insert_Local_Role_SP;
1848: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1849: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role.Ex_UN';
1850: l_debug_str := 'Unhandled Exception: Role Name: '||p_role_name||','||' Error Message: '||x_return_message;
1851: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1852: END IF;
1853: WHEN FND_API.G_EXC_ERROR THEN

Line 1862: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role.Ex_Error';

1858: p_data => x_return_message);
1859: ROLLBACK TO Insert_Local_Role_SP;
1860:
1861: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1862: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role.Ex_Error';
1863: l_debug_str := 'Handled Exception: Role Name: '||p_role_name||','||' Error Message: '||x_return_message;
1864: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1865: END IF;
1866:

Line 1878: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role.Ex_others';

1874: p_data => x_return_message);
1875: ROLLBACK TO Insert_Local_Role_SP;
1876:
1877: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1878: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_Role.Ex_others';
1879: l_debug_str := 'Other Exception: Role Name: '||p_role_name||','||' Error Message: '||x_return_message;
1880: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1881: END IF;
1882:

Line 1944: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role';

1940:
1941: BEGIN
1942:
1943: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1944: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role';
1945: l_debug_str := 'Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||'Role Orig System: '||p_role_orig_system
1946: ||','||' Role Orig System ID: '||p_role_orig_system_id||'User Orig System: '||p_user_orig_system
1947: ||','||' User Orig System ID: '||p_user_orig_system_id;
1948: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 2035: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role.Ex_UN';

2031: p_data => x_return_message);
2032: ROLLBACK TO Insert_Local_User_Role_SP;
2033:
2034: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2035: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role.Ex_UN';
2036: l_debug_str := 'Other Exception: Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||' Error Message: '||x_return_message;
2037: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2038: END IF;
2039:

Line 2049: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role.Ex_error';

2045: p_data => x_return_message);
2046: ROLLBACK TO Insert_Local_User_Role_SP;
2047:
2048: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2049: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role.Ex_error';
2050: l_debug_str := 'Other Exception: Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||' Error Message: '||x_return_message;
2051: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2052: END IF;
2053:

Line 2065: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role.Ex_others';

2061: p_data => x_return_message);
2062: ROLLBACK TO Insert_Local_User_Role_SP;
2063:
2064: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2065: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Local_User_Role.Ex_others';
2066: l_debug_str := 'Other Exception: Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||' Error Message: '||x_return_message;
2067: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2068: END IF;
2069:

Line 2334: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role';

2330: -- -----------------------------------------------------------------
2331:
2332: BEGIN
2333: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2334: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role';
2335: l_debug_str := 'Role Name: '||p_role_name||','||' Role Display Name: '||p_role_display_name||','||'Role Orig System: '||p_orig_system
2336: ||','||' Role Orig System ID: '||p_orig_system_id;
2337: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2338: END IF;

Line 2402: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role.Ex_error';

2398: p_data => x_return_message);
2399: ROLLBACK TO Update_Local_Roles_SP;
2400:
2401: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2402: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role.Ex_error';
2403: l_debug_str := 'Unhandled Exception: Role Name: '||p_role_name||','||' Error Message: '||x_return_message;
2404: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2405: END IF;
2406:

Line 2416: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role.Ex_un';

2412: p_data => x_return_message);
2413: ROLLBACK TO Update_Local_Roles_SP;
2414:
2415: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2416: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role.Ex_un';
2417: l_debug_str := 'handled Exception: Role Name: '||p_role_name||','||' Error Message: '||x_return_message;
2418: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2419: END IF;
2420:

Line 2432: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role.Ex_others';

2428: p_data => x_return_message);
2429: ROLLBACK TO Update_Local_Roles_SP;
2430:
2431: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2432: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_Role.Ex_others';
2433: l_debug_str := 'Other Exception: Role Name: '||p_role_name||','||' Error Message: '||x_return_message;
2434: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2435: END IF;
2436:

Line 2488: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role';

2484: -- -----------------------------------------------------------------
2485:
2486: BEGIN
2487: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2488: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role';
2489: l_debug_str := 'Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||'Role Orig System: '||p_role_orig_system
2490: ||','||' Role Orig System ID: '||p_role_orig_system_id||'User Orig System: '||p_user_orig_system
2491: ||','||' User Orig System ID: '||p_user_orig_system_id;
2492: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 2549: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role.Ex_un';

2545: p_data => x_return_message);
2546: ROLLBACK TO Update_Local_User_Roles_SP;
2547:
2548: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2549: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role.Ex_un';
2550: l_debug_str := 'Unhandled Exception: Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||' Error Message: '||x_return_message;
2551: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2552: END IF;
2553:

Line 2563: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role.Ex_error';

2559: p_data => x_return_message);
2560: ROLLBACK TO Update_Local_User_Roles_SP;
2561:
2562: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2563: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role.Ex_error';
2564: l_debug_str := 'Handled Exception: Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||' Error Message: '||x_return_message;
2565: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2566: END IF;
2567:

Line 2579: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role.Ex_others';

2575: p_data => x_return_message);
2576: ROLLBACK TO Update_Local_User_Roles_SP;
2577:
2578: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2579: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Local_User_Role.Ex_others';
2580: l_debug_str := 'Other Exception: Role Name: '||p_role_name||','||' User Name: '||p_user_name||','||' Error Message: '||x_return_message;
2581: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2582: END IF;
2583:

Line 2658: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant';

2654:
2655: BEGIN
2656:
2657: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2658: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant';
2659: l_debug_str := 'Grant ID: '||p_grant_id||','||'Role ID: '||','||p_user_group_id
2660: ||','||' Grant Name: '||p_grant_name||','||' Grant Text: '||p_grant_text||','||'Select Flag: '||p_grant_select_flag
2661: ||','||' Insert Flag: '||p_grant_insert_flag||','||' Update Flag: '||p_grant_update_flag||','||' Delete Flag: '||p_grant_delete_flag;
2662: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 2795: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant.Ex_error';

2791: p_data => x_return_message);
2792: ROLLBACK TO Update_Grant_SP;
2793:
2794: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2795: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant.Ex_error';
2796: l_debug_str := 'Handled Exception: Grant ID: '||p_grant_id||','||' Grant Name: '||p_grant_name||','||'Error Message: '||x_return_message;
2797: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2798: END IF;
2799:

Line 2812: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant.Ex_un';

2808: p_data => x_return_message);
2809: ROLLBACK TO Update_Grant_SP;
2810:
2811: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2812: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant.Ex_un';
2813: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||','||' Grant Name: '||p_grant_name||','||'Error Message: '||x_return_message;
2814: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2815: END IF;
2816:

Line 2831: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant.Ex_others';

2827: p_data => x_return_message);
2828: ROLLBACK TO Update_Grant_SP;
2829:
2830: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2831: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant.Ex_others';
2832: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||','||' Grant Name: '||p_grant_name||','||'Error Message: '||x_return_message;
2833: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2834: END IF;
2835:

Line 2905: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond';

2901:
2902: BEGIN
2903:
2904: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2905: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond';
2906: l_debug_str := 'Grant ID: '||p_grant_id||','||' Object Attribute ID: '||p_obj_attrib_id||','||'User Attribute ID: '||p_user_attrib_id
2907: ||','||'Condition: '||p_condition||','||' Text Value: '||p_text_value||','||'Grant Cond Number: '||p_grant_cond_num;
2908: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2909: END IF;

Line 3026: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond.Ex_un';

3022: p_data => x_return_message);
3023: ROLLBACK TO Update_Grant_Cond_SP;
3024:
3025: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
3026: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond.Ex_un';
3027: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||','||' Condtion Number: '||p_grant_cond_num||','||'Error Message: '||x_return_message;
3028: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3029: END IF;
3030:

Line 3043: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond.Ex_error';

3039: p_data => x_return_message);
3040: ROLLBACK TO Update_Grant_Cond_SP;
3041:
3042: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
3043: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond.Ex_error';
3044: l_debug_str := 'Handled Exception: Grant ID: '||p_grant_id||','||' Condtion Number: '||p_grant_cond_num||','||'Error Message: '||x_return_message;
3045: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3046: END IF;
3047:

Line 3062: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond.Ex_others';

3058: p_data => x_return_message);
3059: ROLLBACK TO Update_Grant_Cond_SP;
3060:
3061: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
3062: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Update_Grant_Cond.Ex_others';
3063: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||','||' Condtion Number: '||p_grant_cond_num||','||'Error Message: '||x_return_message;
3064: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3065: END IF;
3066:

Line 5680: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant';

5676:
5677: BEGIN
5678:
5679: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5680: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant';
5681: l_debug_str := 'Grant ID: '||p_grant_id;
5682: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5683: END IF;
5684:

Line 5793: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant.Ex_error';

5789: p_data => x_return_message);
5790: ROLLBACK TO Delete_Grant_SP;
5791:
5792: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5793: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant.Ex_error';
5794: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||','||' Error Message: '||x_return_message;
5795: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5796: END IF;
5797:

Line 5813: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant.Ex_un';

5809: p_data => x_return_message);
5810: ROLLBACK TO Delete_Grant_SP;
5811:
5812: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5813: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant.Ex_un';
5814: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||','||' Error Message: '||x_return_message;
5815: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5816: END IF;
5817:

Line 5835: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant.Ex_others';

5831: p_data => x_return_message);
5832: ROLLBACK TO Delete_Grant_SP;
5833:
5834: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5835: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant.Ex_others';
5836: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||','||' Error Message: '||x_return_message;
5837: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5838: END IF;
5839:

Line 5895: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond';

5891:
5892: BEGIN
5893:
5894: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5895: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond';
5896: l_debug_str := 'Grant ID: '||p_grant_id||','||'Grant Cond Number: '||p_grant_cond_num;
5897: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5898: END IF;
5899:

Line 5977: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond.Ex_un';

5973: p_data => x_return_message);
5974: ROLLBACK TO Delete_Grant_Cond_SP;
5975:
5976: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5977: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond.Ex_un';
5978: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||','||'Grant Cond Number: '||p_grant_cond_num||'Error Message: '||x_return_message;
5979: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5980: END IF;
5981:

Line 5995: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond.Ex_error';

5991: p_data => x_return_message);
5992: ROLLBACK TO Delete_Grant_Cond_SP;
5993:
5994: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5995: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond.Ex_error';
5996: l_debug_str := 'Handled Exception: Grant ID: '||p_grant_id||','||'Grant Cond Number: '||p_grant_cond_num||'Error Message: '||x_return_message;
5997: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5998: END IF;
5999:

Line 6014: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond.Ex_others';

6010: p_data => x_return_message);
6011: ROLLBACK TO Delete_Grant_Cond_SP;
6012:
6013: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6014: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Delete_Grant_Cond.Ex_others';
6015: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||','||'Grant Cond Number: '||p_grant_cond_num||'Error Message: '||x_return_message;
6016: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6017: END IF;
6018:

Line 6337: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';

6333:
6334: BEGIN
6335:
6336: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6337: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';
6338: l_debug_str := 'Grant ID: '||p_grant_id;
6339: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6340: END IF;
6341:

Line 6430: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';

6426: p_data => x_return_message);
6427: ROLLBACK TO Lock_Grant_SP;
6428:
6429: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6430: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';
6431: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||'Error Message: '||x_return_message;
6432: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6433: END IF;
6434:

Line 6447: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';

6443: p_data => x_return_message);
6444: ROLLBACK TO Lock_Grant_SP;
6445:
6446: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6447: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';
6448: l_debug_str := 'Handled Exception: Grant ID: '||p_grant_id||'Error Message: '||x_return_message;
6449: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6450: END IF;
6451:

Line 6466: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';

6462: p_data => x_return_message);
6463: ROLLBACK TO Lock_Grant_SP;
6464:
6465: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6466: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_Grant';
6467: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||'Error Message: '||x_return_message;
6468: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6469: END IF;
6470:

Line 6517: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';

6513:
6514: BEGIN
6515:
6516: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6517: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';
6518: l_debug_str := 'Grant ID: '||p_grant_id;
6519: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6520: END IF;
6521:

Line 6599: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';

6595: p_data => x_return_message);
6596: ROLLBACK TO Unlock_Grant_SP;
6597:
6598: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6599: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';
6600: l_debug_str := 'Unhandled Exception: Grant ID: '||p_grant_id||'Error Message: '||x_return_message;
6601: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6602: END IF;
6603:

Line 6616: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';

6612: p_data => x_return_message);
6613: ROLLBACK TO Unlock_Grant_SP;
6614:
6615: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6616: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';
6617: l_debug_str := 'Handled Exception: Grant ID: '||p_grant_id||'Error Message: '||x_return_message;
6618: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6619: END IF;
6620:

Line 6634: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';

6630: p_data => x_return_message);
6631: ROLLBACK TO Unlock_Grant_SP;
6632:
6633: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
6634: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_Grant';
6635: l_debug_str := 'Other Exception: Grant ID: '||p_grant_id||'Error Message: '||x_return_message;
6636: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6637: END IF;
6638:

Line 7353: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_All_Grants';

7349: l_return_status VARCHAR2(30);
7350:
7351: BEGIN
7352: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
7353: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Unlock_All_Grants';
7354: l_debug_str := 'Object Group ID: '||p_obj_group_id;
7355: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7356: END IF;
7357: -- Just call the procedure

Line 7411: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_All_Grants';

7407:
7408: BEGIN
7409:
7410: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
7411: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Lock_All_Grants';
7412: l_debug_str := 'Object Group ID: '||p_obj_group_id;
7413: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7414: END IF;
7415:

Line 8247: l_col_name := 'IGS_SC_DATA_SEC_APIS_PKG.get_obj_name('||c_cols_rec.column_name||')';

8243:
8244: FOR c_cols_rec IN c_cols LOOP
8245:
8246: IF c_cols_rec.column_name = 'OBJECT_ID' THEN
8247: l_col_name := 'IGS_SC_DATA_SEC_APIS_PKG.get_obj_name('||c_cols_rec.column_name||')';
8248: l_object_num :=1;
8249: ELSE
8250: l_col_name := c_cols_rec.column_name;
8251: END IF;

Line 8615: END IGS_SC_DATA_SEC_APIS_PKG;

8611: END IF;
8612:
8613: END Generate_SQL_file;
8614:
8615: END IGS_SC_DATA_SEC_APIS_PKG;