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 FND_LOG

Line 31: gmaheswa 26-Jul-2005 Fnd Logging

27: mmkumar 28-Jun-2005 Bug 4431768 : Added a paqrameter for overwrite
28: Inside Update_Grant_Cond, removed code for cursor c_get_grant_cond.
29: prbhardw 18-Jul-2005 Inside Update_Grant_Cond, modified code to update condition number
30: mmkumar 21-JUL-2005 Closed the cursors whereever appropriate
31: gmaheswa 26-Jul-2005 Fnd Logging
32: pkpatel 10-Mar-2006 Bug 5081932 (Used wf_local_synch instead of private API wf_directory)
33: gmaheswa 19-Apr-2006 Bug: 4587521: Modified Modify_Policy to add long_predicate parameter to add_policy. this parameter allows max predicate where clause lenght to 32K
34: ******************************************************************/
35:

Line 156: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

152: l_obj_group_id igs_sc_objects.object_id%TYPE;
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;

Line 161: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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);
162: END IF;
163:
164: SAVEPOINT Insert_Grant_SP;
165:

Line 302: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

298: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
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;

Line 305: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
308: WHEN FND_API.G_EXC_ERROR THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;

Line 315: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

311: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
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;

Line 318: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
321: WHEN OTHERS THEN
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 331: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

327: p_count => l_message_count,
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;

Line 334: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
337: IF g_upgrade_mode = 'Y' THEN
338: RAISE;

Line 388: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

384: l_obj_attr_id igs_sc_obj_attribs.obj_attrib_id%TYPE := p_obj_attrib_id;
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);

Line 392: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
394:
395: SAVEPOINT Insert_Grant_Cond_SP;
396:

Line 511: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

507: p_count => l_message_count,
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;

Line 514: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
517: WHEN FND_API.G_EXC_ERROR THEN
518: x_return_status := FND_API.G_RET_STS_ERROR;

Line 525: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

521: p_count => l_message_count,
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;

Line 528: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
531: WHEN OTHERS THEN
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 541: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

537: p_count => l_message_count,
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;

Line 544: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
547: IF g_upgrade_mode = 'Y' THEN
548: RAISE;

Line 1781: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1777: -- Define the cursors to be used in procedure.
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);

Line 1785: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
1787:
1788: SAVEPOINT Insert_Local_Role_SP;
1789:

Line 1848: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1844: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
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;

Line 1851: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855:

Line 1861: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1857: p_count => l_message_count,
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;

Line 1864: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
1867: WHEN OTHERS THEN
1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1877: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1873: p_count => l_message_count,
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;

Line 1880: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
1883: IF g_upgrade_mode = 'Y' THEN
1884: RAISE;

Line 1943: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1939: AND user_id = p_user_orig_system_id;
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;

Line 1948: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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);
1949: END IF;
1950:
1951: SAVEPOINT Insert_Local_User_Role_SP;
1952:

Line 2034: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2030: p_count => l_message_count,
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;

Line 2037: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2040: WHEN FND_API.G_EXC_ERROR THEN
2041: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2048: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2044: p_count => l_message_count,
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;

Line 2051: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2054: WHEN OTHERS THEN
2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2064: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2060: p_count => l_message_count,
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;

Line 2067: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2070: IF g_upgrade_mode = 'Y' THEN
2071: RAISE;

Line 2333: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2329: -- Define the cursors to be used in procedure.
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);

Line 2337: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2339:
2340: SAVEPOINT Update_Local_Roles_SP;
2341:

Line 2401: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2397: p_count => l_message_count,
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;

Line 2404: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2407: WHEN FND_API.G_EXC_ERROR THEN
2408: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2415: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2411: p_count => l_message_count,
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;

Line 2418: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2421: WHEN OTHERS THEN
2422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2431: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2427: p_count => l_message_count,
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;

Line 2434: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2437: IF g_upgrade_mode = 'Y' THEN
2438: RAISE;

Line 2487: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2483: -- Define the cursors to be used in procedure.
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;

Line 2492: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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);
2493: END IF;
2494:
2495: SAVEPOINT Update_Local_User_Roles_SP;
2496:

Line 2548: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2544: p_count => l_message_count,
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;

Line 2551: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2554: WHEN FND_API.G_EXC_ERROR THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2562: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2558: p_count => l_message_count,
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;

Line 2565: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2568: WHEN OTHERS THEN
2569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2578: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2574: p_count => l_message_count,
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;

Line 2581: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2584: IF g_upgrade_mode = 'Y' THEN
2585: RAISE;

Line 2657: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2653: WHERE grant_id = p_grant_id;
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;

Line 2662: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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);
2663: END IF;
2664:
2665: SAVEPOINT Update_Grant_SP;
2666:

Line 2794: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2790: p_count => l_message_count,
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;

Line 2797: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2800: WHEN FND_API.G_EXC_ERROR THEN
2801: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2811: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2807: p_count => l_message_count,
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;

Line 2814: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2817: WHEN OTHERS THEN
2818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2830: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2826: p_count => l_message_count,
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;

Line 2833: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
2836: IF g_upgrade_mode = 'Y' THEN
2837: RAISE;

Line 2904: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2900: WHERE grt.grant_id = p_grant_id;
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);

Line 2908: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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;
2910:
2911: SAVEPOINT Update_Grant_Cond_SP;
2912: IF p_old_grant_cond_num <> 0 THEN

Line 3025: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

3021: p_count => l_message_count,
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;

Line 3028: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
3031: WHEN FND_API.G_EXC_ERROR THEN
3032: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3042: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

3038: p_count => l_message_count,
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;

Line 3045: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
3048: WHEN OTHERS THEN
3049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3061: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

3057: p_count => l_message_count,
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;

Line 3064: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
3067: IF g_upgrade_mode = 'Y' THEN
3068: RAISE;

Line 5679: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5675: WHERE grts.grant_id = p_grant_id;
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;

Line 5682: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
5685: SAVEPOINT Delete_Grant_SP;
5686:

Line 5792: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5788: p_count => l_message_count,
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;

Line 5795: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
5798: WHEN FND_API.G_EXC_ERROR THEN
5799: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5812: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5808: p_count => l_message_count,
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;

Line 5815: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
5818: WHEN OTHERS THEN
5819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5834: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5830: p_count => l_message_count,
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;

Line 5837: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
5840: IF g_upgrade_mode = 'Y' THEN
5841: RAISE;

Line 5894: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5890: WHERE grts.grant_id = p_grant_id;
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;

Line 5897: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
5900: SAVEPOINT Delete_Grant_Cond_SP;
5901:

Line 5976: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5972: p_count => l_message_count,
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;

Line 5979: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
5982:
5983: WHEN FND_API.G_EXC_ERROR THEN

Line 5994: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5990: p_count => l_message_count,
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;

Line 5997: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6000: WHEN OTHERS THEN
6001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6013: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6009: p_count => l_message_count,
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;

Line 6016: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6019: IF g_upgrade_mode = 'Y' THEN
6020: RAISE;

Line 6336: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6332: WHERE grts.grant_id = p_grant_id;
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;

Line 6339: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6342: SAVEPOINT Lock_Grant_SP;
6343:

Line 6429: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6425: p_count => l_message_count,
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;

Line 6432: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6435: WHEN FND_API.G_EXC_ERROR THEN
6436: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6446: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6442: p_count => l_message_count,
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;

Line 6449: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6452: WHEN OTHERS THEN
6453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6465: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6461: p_count => l_message_count,
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;

Line 6468: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6471: END Lock_Grant;
6472:

Line 6516: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6512: WHERE grts.grant_id = p_grant_id;
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;

Line 6519: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6522: SAVEPOINT Unlock_Grant_SP;
6523:

Line 6598: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6594: p_count => l_message_count,
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;

Line 6601: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6604: WHEN FND_API.G_EXC_ERROR THEN
6605: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6615: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6611: p_count => l_message_count,
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;

Line 6618: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6621: WHEN OTHERS THEN
6622: IF (c_check_grant%ISOPEN) THEN

Line 6633: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

6629: p_count => l_message_count,
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;

Line 6636: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
6639: END Unlock_Grant;
6640:

Line 7352: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

7348: l_msg_count NUMBER(15);
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;

Line 7355: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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
7358: SAVEPOINT Unlock_All_Grants;
7359:

Line 7410: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

7406: l_return_status VARCHAR2(30);
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;

Line 7413: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

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:
7416: -- Just call the procedure
7417: SAVEPOINT Lock_All_Grants;