APPS.IGI_ITR_APPROVAL_PKG dependencies on FND_LOG

Line 5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY IGI_ITR_APPROVAL_PKG AS
2: -- $Header: igiitrwb.pls 120.10.12000000.2 2007/09/17 16:35:44 smannava ship $
3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 6: l_state_level number := FND_LOG.LEVEL_STATEMENT;

2: -- $Header: igiitrwb.pls 120.10.12000000.2 2007/09/17 16:35:44 smannava ship $
3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 8: l_event_level number := FND_LOG.LEVEL_EVENT;

4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path VARCHAR2(50) := 'IGI.PLSQL.igiitrwb.IGI_ITR_APPROVAL_PKG.';

Line 9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path VARCHAR2(50) := 'IGI.PLSQL.igiitrwb.IGI_ITR_APPROVAL_PKG.';
13:

Line 10: l_error_level number := FND_LOG.LEVEL_ERROR;

6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path VARCHAR2(50) := 'IGI.PLSQL.igiitrwb.IGI_ITR_APPROVAL_PKG.';
13:
14:

Line 11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path VARCHAR2(50) := 'IGI.PLSQL.igiitrwb.IGI_ITR_APPROVAL_PKG.';
13:
14:
15: -- ****************************************************************************

Line 21: FND_LOG.STRING (p_level , l_path || p_path , p_mesg );

17: -- ****************************************************************************
18: PROCEDURE diagn_msg (p_level IN NUMBER, p_path IN VARCHAR2, p_mesg IN VARCHAR2) IS
19: BEGIN
20: IF (p_level >= l_debug_level ) THEN
21: FND_LOG.STRING (p_level , l_path || p_path , p_mesg );
22: END IF;
23:
24: END ;
25:

Line 54: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.get_authorization_limit',TRUE);

50: IF ( l_unexp_level >= l_debug_level) THEN
51: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
52: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
53: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
54: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.get_authorization_limit',TRUE);
55: END IF;
56: raise;
57: END get_authorization_limit;
58:

Line 265: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.start_approval_workflow',TRUE);

261: IF ( l_unexp_level >= l_debug_level) THEN
262: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
263: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
264: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
265: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.start_approval_workflow',TRUE);
266: END IF;
267: raise;
268:
269: END start_approval_workflow;

Line 384: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.get_sob_attributes',TRUE);

380: IF ( l_unexp_level >= l_debug_level) THEN
381: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
382: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
383: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
384: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.get_sob_attributes',TRUE);
385: END IF;
386: raise;
387: END get_sob_attributes;
388:

Line 499: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.get_cc_attributes',TRUE);

495: IF ( l_unexp_level >= l_debug_level) THEN
496: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
497: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
498: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
499: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.get_cc_attributes',TRUE);
500: END IF;
501: raise;
502:
503: END get_cc_attributes;

Line 543: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.did_preparer_approve',TRUE);

539: IF ( l_unexp_level >= l_debug_level) THEN
540: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
541: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
542: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
543: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.did_preparer_approve',TRUE);
544: END IF;
545: raise;
546: END did_preparer_approve;
547:

Line 598: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_approver_name_to_prep',TRUE);

594: IF ( l_unexp_level >= l_debug_level) THEN
595: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
596: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
597: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
598: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_approver_name_to_prep',TRUE);
599: END IF;
600: raise;
601: END set_approver_name_to_prep;
602:

Line 641: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.secondary_approver_selected',TRUE);

637: IF ( l_unexp_level >= l_debug_level) THEN
638: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
639: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
640: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
641: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.secondary_approver_selected',TRUE);
642: END IF;
643: raise;
644: END secondary_approver_selected;
645:

Line 696: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_approver_name_to_sec_app',TRUE);

692: IF ( l_unexp_level >= l_debug_level) THEN
693: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
694: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
695: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
696: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_approver_name_to_sec_app',TRUE);
697: END IF;
698: raise;
699: END set_approver_name_to_sec_app;
700:

Line 778: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.maintain_history',TRUE);

774: IF ( l_unexp_level >= l_debug_level) THEN
775: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
776: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
777: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
778: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.maintain_history',TRUE);
779: END IF;
780: raise;
781: END maintain_history;
782:

Line 834: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.submit_cc_line',TRUE);

830: IF ( l_unexp_level >= l_debug_level) THEN
831: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
832: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
833: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
834: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.submit_cc_line',TRUE);
835: END IF;
836: raise;
837: END submit_cc_line;
838:

Line 888: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.no_submit_cc_line',TRUE);

884: IF ( l_unexp_level >= l_debug_level) THEN
885: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
886: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
887: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
888: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.no_submit_cc_line',TRUE);
889: END IF;
890: raise;
891: END no_submit_cc_line;
892:

Line 1006: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.find_cc_receiver',TRUE);

1002: IF ( l_unexp_level >= l_debug_level) THEN
1003: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1004: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1005: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1006: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.find_cc_receiver',TRUE);
1007: END IF;
1008: raise;
1009: END find_cc_receiver;
1010:

Line 1060: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.set_approver_name_to_rec',TRUE);

1056: IF ( l_unexp_level >= l_debug_level) THEN
1057: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1058: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1059: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1060: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.set_approver_name_to_rec',TRUE);
1061: END IF;
1062: raise;
1063: END set_approver_name_to_rec;
1064:

Line 1114: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.double_timeout',TRUE);

1110: IF ( l_unexp_level >= l_debug_level) THEN
1111: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1112: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1113: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1114: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.double_timeout',TRUE);
1115: END IF;
1116: raise;
1117: END double_timeout;
1118:

Line 1171: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.final_approver',TRUE);

1167: IF ( l_unexp_level >= l_debug_level) THEN
1168: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1169: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1170: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1171: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.final_approver',TRUE);
1172: END IF;
1173: raise;
1174: END final_approver;
1175:

Line 1219: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.is_receiver_final_approver',TRUE);

1215: IF ( l_unexp_level >= l_debug_level) THEN
1216: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1217: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1218: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1219: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.is_receiver_final_approver',TRUE);
1220: END IF;
1221: raise;
1222: END is_receiver_final_approver;
1223:

Line 1273: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.verify_authority',TRUE);

1269: IF ( l_unexp_level >= l_debug_level) THEN
1270: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1271: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1272: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1273: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.verify_authority',TRUE);
1274: END IF;
1275: raise;
1276: END verify_authority;
1277:

Line 1335: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.approve_cc_line',TRUE);

1331: IF ( l_unexp_level >= l_debug_level) THEN
1332: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1333: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1334: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1335: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.approve_cc_line',TRUE);
1336: END IF;
1337: raise;
1338: END approve_cc_line;
1339:

Line 1383: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.reject_cc_line',TRUE);

1379: IF ( l_unexp_level >= l_debug_level) THEN
1380: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1381: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1382: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1383: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.reject_cc_line',TRUE);
1384: END IF;
1385: raise;
1386: END reject_cc_line;
1387:

Line 1418: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getmanager',TRUE);

1414: IF ( l_unexp_level >= l_debug_level) THEN
1415: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1416: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1417: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1418: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getmanager',TRUE);
1419: END IF;
1420: raise;
1421: END getmanager;
1422:

Line 1492: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.setpersonas',TRUE);

1488: IF ( l_unexp_level >= l_debug_level) THEN
1489: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1490: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1491: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1492: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.setpersonas',TRUE);
1493: END IF;
1494: raise;
1495: END setpersonas;
1496:

Line 1549: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getfinalapprover',TRUE);

1545: IF ( l_unexp_level >= l_debug_level) THEN
1546: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1547: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1548: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1549: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getfinalapprover',TRUE);
1550: END IF;
1551: raise;
1552: END getfinalapprover;
1553:

Line 1621: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg1', FALSE);

1617: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_APPROVER_METHOD');
1618: l_error_message := FND_MESSAGE.Get;
1619:
1620: IF( l_error_level >= l_debug_level) THEN
1621: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg1', FALSE);
1622: END IF;
1623: wf_engine.SetItemAttrText( item_type,
1624: item_key,
1625: 'ERROR_MESSAGE',

Line 1640: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg2',TRUE);

1636: IF ( l_unexp_level >= l_debug_level) THEN
1637: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1638: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1639: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1640: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg2',TRUE);
1641: END IF;
1642: raise;
1643: END getapprover;
1644:

Line 1723: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg1', FALSE);

1719: ELSE
1720: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_MANAGER');
1721: l_error_message := FND_MESSAGE.Get;
1722: IF( l_error_level >= l_debug_level) THEN
1723: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg1', FALSE);
1724: END IF;
1725: wf_engine.SetItemAttrText( item_type,
1726: item_key,
1727: 'ERROR_MESSAGE',

Line 1755: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg2', FALSE);

1751: IF (l_next_approver_id IS NULL) THEN
1752: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_APPROVER');
1753: l_error_message := FND_MESSAGE.Get;
1754: IF( l_error_level >= l_debug_level) THEN
1755: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg2', FALSE);
1756: END IF;
1757: WF_ENGINE.SetItemAttrText( item_type,
1758: item_key,
1759: 'ERROR_MESSAGE',

Line 1793: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.find_approver',TRUE);

1789: IF ( l_unexp_level >= l_debug_level) THEN
1790: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1791: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1792: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1793: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.find_approver',TRUE);
1794: END IF;
1795: raise;
1796:
1797: END find_approver;

Line 1856: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.record_forward_from_info',TRUE);

1852: IF ( l_unexp_level >= l_debug_level) THEN
1853: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1854: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1855: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1856: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.record_forward_from_info',TRUE);
1857: END IF;
1858: raise;
1859: END record_forward_from_info;
1860:

Line 1906: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.mgr_equalto_aprv',TRUE);

1902: IF ( l_unexp_level >= l_debug_level) THEN
1903: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1904: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1905: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1906: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.mgr_equalto_aprv',TRUE);
1907: END IF;
1908: raise;
1909: END mgr_equalto_aprv;
1910:

Line 1960: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.first_approver',TRUE);

1956: IF ( l_unexp_level >= l_debug_level) THEN
1957: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1958: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1959: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1960: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.first_approver',TRUE);
1961: END IF;
1962: raise;
1963: END first_approver;
1964:

Line 2014: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_employee_name_to_prep',TRUE);

2010: IF ( l_unexp_level >= l_debug_level) THEN
2011: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
2012: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2013: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2014: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_employee_name_to_prep',TRUE);
2015: END IF;
2016: raise;
2017: END set_employee_name_to_prep;
2018:

Line 2068: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_employee_name_to_rec',TRUE);

2064: IF ( l_unexp_level >= l_debug_level) THEN
2065: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
2066: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2067: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2068: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.set_employee_name_to_rec',TRUE);
2069: END IF;
2070: raise;
2071: END set_employee_name_to_rec;
2072:

Line 2149: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.reset_approval_attributes',TRUE);

2145: IF ( l_unexp_level >= l_debug_level) THEN
2146: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
2147: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2148: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2149: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.reset_approval_attributes',TRUE);
2150: END IF;
2151: raise;
2152: END reset_approval_attributes;
2153: