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.AMW_VIOLATION_PUB dependencies on FND_LOG

Line 5: l_curr_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: package body AMW_VIOLATION_PUB as
2: /* $Header: amwvpubb.pls 120.9 2008/02/18 09:23:59 ptulasi ship $ */
3:
4:
5: l_curr_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_log_stmt_level number := FND_LOG.LEVEL_STATEMENT;
7: g_menu_id_list G_NUMBER_TABLE;
8: g_function_id_list G_NUMBER_TABLE;
9: g_menu_function_id_list G_NUMBER_TABLE;

Line 6: l_log_stmt_level number := FND_LOG.LEVEL_STATEMENT;

2: /* $Header: amwvpubb.pls 120.9 2008/02/18 09:23:59 ptulasi ship $ */
3:
4:
5: l_curr_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_log_stmt_level number := FND_LOG.LEVEL_STATEMENT;
7: g_menu_id_list G_NUMBER_TABLE;
8: g_function_id_list G_NUMBER_TABLE;
9: g_menu_function_id_list G_NUMBER_TABLE;
10:

Line 393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations Start');

389:
390: BEGIN
391:
392: IF( l_log_stmt_level >= l_curr_log_level ) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations Start');
394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );
395: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);
396: END IF;
397:

Line 394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );

390: BEGIN
391:
392: IF( l_log_stmt_level >= l_curr_log_level ) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations Start');
394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );
395: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);
396: END IF;
397:
398: -- default to 'N', which means user doesn't have violations

Line 395: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);

391:
392: IF( l_log_stmt_level >= l_curr_log_level ) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations Start');
394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );
395: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);
396: END IF;
397:
398: -- default to 'N', which means user doesn't have violations
399: has_violation := 'N';

Line 584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_resp_access_count = '|| l_resp_access_count );

580: CLOSE resp_acess_count_c;
581:
582:
583: IF( l_log_stmt_level >= l_curr_log_level ) THEN
584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_resp_access_count = '|| l_resp_access_count );
585: END IF;
586:
587: -- in ME type: if user can access at least two entries of this constraint,
588: -- he violates this constraint

Line 595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','has_violation = '|| has_violation );

591: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - ME = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
592: has_violation := 'Y';
593:
594: IF( l_log_stmt_level >= l_curr_log_level ) THEN
595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','has_violation = '|| has_violation );
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');
597: END IF;
598:
599: return has_violation;

Line 596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');

592: has_violation := 'Y';
593:
594: IF( l_log_stmt_level >= l_curr_log_level ) THEN
595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','has_violation = '|| has_violation );
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');
597: END IF;
598:
599: return has_violation;
600: END IF;

Line 636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Last has_violation = '|| has_violation );

632:
633: END IF; -- end of if: p_user_id IS NOT NULL AND p_responsibility_id IS NOT NULL
634:
635: IF( l_log_stmt_level >= l_curr_log_level ) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Last has_violation = '|| has_violation );
637: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');
638: END IF;
639:
640: return has_violation;

Line 637: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');

633: END IF; -- end of if: p_user_id IS NOT NULL AND p_responsibility_id IS NOT NULL
634:
635: IF( l_log_stmt_level >= l_curr_log_level ) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Last has_violation = '|| has_violation );
637: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');
638: END IF;
639:
640: return has_violation;
641:

Line 645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

641:
642: EXCEPTION
643: WHEN OTHERS THEN
644: IF( l_log_stmt_level >= l_curr_log_level ) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');
647: END IF;
648: RAISE;
649:

Line 646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');

642: EXCEPTION
643: WHEN OTHERS THEN
644: IF( l_log_stmt_level >= l_curr_log_level ) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Check_Resp_Violations End');
647: END IF;
648: RAISE;
649:
650: END Check_Resp_Violations;

Line 901: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details Start');

897:
898:
899: BEGIN
900: IF( l_log_stmt_level >= l_curr_log_level ) THEN
901: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details Start');
902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );
903: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);
904: END IF;
905:

Line 902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );

898:
899: BEGIN
900: IF( l_log_stmt_level >= l_curr_log_level ) THEN
901: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details Start');
902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );
903: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);
904: END IF;
905:
906: -- default to 'N', which means user doesn't have violations

Line 903: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);

899: BEGIN
900: IF( l_log_stmt_level >= l_curr_log_level ) THEN
901: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details Start');
902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_user_id = '|| p_user_id );
903: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','p_responsibility_id = '|| p_responsibility_id);
904: END IF;
905:
906: -- default to 'N', which means user doesn't have violations
907: has_violation := 'N';

Line 1235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_resp_access_count = '|| l_resp_access_count );

1231: FETCH resp_acess_count_c INTO l_resp_access_count;
1232: CLOSE resp_acess_count_c;
1233:
1234: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_resp_access_count = '|| l_resp_access_count );
1236: END IF;
1237:
1238:
1239: -- in ME type: if user can access at least two entries of this constraint,

Line 1258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_new_resp = '|| l_violat_new_resp );

1254: p_constraint_rev_id => l_all_valid_constraints.constraint_rev_id,
1255: p_constraint_type_code => l_all_valid_constraints.type_code);
1256:
1257: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_new_resp = '|| l_violat_new_resp );
1259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_resp = '|| l_violat_existing_resp );
1260: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_role = '|| l_violat_existing_role );
1261: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_menu = '|| l_violat_existing_menu );
1262: END IF;

Line 1259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_resp = '|| l_violat_existing_resp );

1255: p_constraint_type_code => l_all_valid_constraints.type_code);
1256:
1257: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_new_resp = '|| l_violat_new_resp );
1259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_resp = '|| l_violat_existing_resp );
1260: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_role = '|| l_violat_existing_role );
1261: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_menu = '|| l_violat_existing_menu );
1262: END IF;
1263:

Line 1260: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_role = '|| l_violat_existing_role );

1256:
1257: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_new_resp = '|| l_violat_new_resp );
1259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_resp = '|| l_violat_existing_resp );
1260: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_role = '|| l_violat_existing_role );
1261: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_menu = '|| l_violat_existing_menu );
1262: END IF;
1263:
1264: -- concatinate return result(Violation Details)

Line 1261: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_menu = '|| l_violat_existing_menu );

1257: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_new_resp = '|| l_violat_new_resp );
1259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_resp = '|| l_violat_existing_resp );
1260: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_role = '|| l_violat_existing_role );
1261: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','l_violat_existing_menu = '|| l_violat_existing_menu );
1262: END IF;
1263:
1264: -- concatinate return result(Violation Details)
1265: has_violation := l_violat_new_resp;

Line 1291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');

1287: fnd_message.set_token('CONST_DETAILS', has_violation);
1288:
1289:
1290: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');
1292: END IF;
1293:
1294: return substrb((FND_MESSAGE.GET), 1, 2000);
1295: END IF; -- end of l_resp_access_count >= 2

Line 1368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Last has_violation '|| has_violation);

1364:
1365: END IF; -- end of if: p_user_id IS NOT NULL AND p_responsibility_id IS NOT NULL
1366:
1367: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Last has_violation '|| has_violation);
1369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');
1370: END IF;
1371:
1372: return has_violation;

Line 1369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');

1365: END IF; -- end of if: p_user_id IS NOT NULL AND p_responsibility_id IS NOT NULL
1366:
1367: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Last has_violation '|| has_violation);
1369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');
1370: END IF;
1371:
1372: return has_violation;
1373:

Line 1377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

1373:
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');
1379: END IF;
1380: RAISE;
1381:

Line 1378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');

1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','User_Resp_Violation_Details End');
1379: END IF;
1380: RAISE;
1381:
1382: END User_Resp_Violation_Details;

Line 1441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Role_List Start');

1437: ||' and ur.role_name = rv.name ';
1438:
1439: BEGIN
1440: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Role_List Start');
1442: END IF;
1443:
1444: l_existing_role_string := NULL;
1445:

Line 1464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Role_List End');

1460:
1461: END IF; --end of if: p_user_id IS NOT NULL AND p_constraint_rev_id IS NOT NULL AND p_constraint_type_code IS NOT NULL
1462:
1463: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Role_List End');
1465: END IF;
1466:
1467: return l_existing_role_string;
1468:

Line 1472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

1468:
1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Role_List End');
1474: END IF;
1475: RAISE;
1476: END Get_Violat_Existing_Role_List;

Line 1473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Role_List End');

1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Role_List End');
1474: END IF;
1475: RAISE;
1476: END Get_Violat_Existing_Role_List;
1477:

Line 1549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Resp_List Start');

1545:
1546: BEGIN
1547:
1548: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Resp_List Start');
1550: END IF;
1551:
1552: l_existing_resp_string := NULL;
1553:

Line 1574: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Resp_List End');

1570:
1571: END IF; --end of if: p_user_id IS NOT NULL AND p_constraint_rev_id IS NOT NULL AND p_constraint_type_code IS NOT NULL
1572:
1573: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1574: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Resp_List End');
1575: END IF;
1576:
1577: return l_existing_resp_string;
1578: EXCEPTION

Line 1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

1577: return l_existing_resp_string;
1578: EXCEPTION
1579: WHEN OTHERS THEN
1580: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Resp_List End');
1583: END IF;
1584: RAISE;
1585:

Line 1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Resp_List End');

1578: EXCEPTION
1579: WHEN OTHERS THEN
1580: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Resp_List End');
1583: END IF;
1584: RAISE;
1585:
1586: END Get_Violat_Existing_Resp_List;

Line 1661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Menu_List Start');

1657:
1658: BEGIN
1659:
1660: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Menu_List Start');
1662: END IF;
1663:
1664: l_existing_menu_string := NULL;
1665:

Line 1685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Menu_List End');

1681:
1682: END IF; --end of if: p_user_id IS NOT NULL AND p_constraint_rev_id IS NOT NULL AND p_constraint_type_code IS NOT NULL
1683:
1684: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Menu_List End');
1686: END IF;
1687:
1688: return l_existing_menu_string;
1689: EXCEPTION

Line 1692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

1688: return l_existing_menu_string;
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1693: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Menu_List End');
1694: END IF;
1695: RAISE;
1696:

Line 1693: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Menu_List End');

1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: IF( l_log_stmt_level >= l_curr_log_level ) THEN
1692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
1693: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','Get_Violat_Existing_Menu_List End');
1694: END IF;
1695: RAISE;
1696:
1697: END Get_Violat_Existing_Menu_List;