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.IGI_ITR_APPROVAL_PKG dependencies on FND_MESSAGE

Line 51: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

47: WHEN OTHERS THEN
48: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_authorization_limit',
49: null, null, null );
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;

Line 52: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

48: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_authorization_limit',
49: null, null, null );
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;

Line 53: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

49: null, null, null );
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;

Line 262: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

258: EXCEPTION
259: WHEN OTHERS THEN
260: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'start_approval_workflow', l_itemtype, l_itemkey);
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;

Line 263: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

259: WHEN OTHERS THEN
260: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'start_approval_workflow', l_itemtype, l_itemkey);
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;

Line 264: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

260: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'start_approval_workflow', l_itemtype, l_itemkey);
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:

Line 381: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

377: EXCEPTION
378: WHEN OTHERS THEN
379: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_sob_attributes', itemtype, itemkey);
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;

Line 382: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

378: WHEN OTHERS THEN
379: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_sob_attributes', itemtype, itemkey);
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;

Line 383: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

379: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_sob_attributes', itemtype, itemkey);
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;

Line 496: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

492: EXCEPTION
493: WHEN OTHERS THEN
494: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_cc_attributes', itemtype, itemkey);
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;

Line 497: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

493: WHEN OTHERS THEN
494: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_cc_attributes', itemtype, itemkey);
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;

Line 498: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

494: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_cc_attributes', itemtype, itemkey);
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:

Line 540: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

536: EXCEPTION
537: WHEN OTHERS THEN
538: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'did_preparer_approve', itemtype, itemkey);
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;

Line 541: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

537: WHEN OTHERS THEN
538: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'did_preparer_approve', itemtype, itemkey);
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;

Line 542: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

538: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'did_preparer_approve', itemtype, itemkey);
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;

Line 595: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

591: EXCEPTION
592: WHEN OTHERS THEN
593: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_prep', itemtype, itemkey);
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;

Line 596: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

592: WHEN OTHERS THEN
593: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_prep', itemtype, itemkey);
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;

Line 597: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

593: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_prep', itemtype, itemkey);
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;

Line 638: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

634: EXCEPTION
635: WHEN OTHERS THEN
636: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'secondary_approver_selected', itemtype, itemkey);
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;

Line 639: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

635: WHEN OTHERS THEN
636: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'secondary_approver_selected', itemtype, itemkey);
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;

Line 640: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

636: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'secondary_approver_selected', itemtype, itemkey);
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;

Line 693: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

689: EXCEPTION
690: WHEN OTHERS THEN
691: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_sec_app', itemtype, itemkey);
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;

Line 694: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

690: WHEN OTHERS THEN
691: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_sec_app', itemtype, itemkey);
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;

Line 695: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

691: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_sec_app', itemtype, itemkey);
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;

Line 775: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

771: EXCEPTION
772: WHEN OTHERS THEN
773: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'maintain_history', itemtype, itemkey);
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;

Line 776: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

772: WHEN OTHERS THEN
773: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'maintain_history', itemtype, itemkey);
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;

Line 777: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

773: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'maintain_history', itemtype, itemkey);
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;

Line 831: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

827: EXCEPTION
828: WHEN OTHERS THEN
829: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'submit_cc_line', itemtype, itemkey);
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;

Line 832: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

828: WHEN OTHERS THEN
829: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'submit_cc_line', itemtype, itemkey);
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;

Line 833: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

829: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'submit_cc_line', itemtype, itemkey);
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;

Line 885: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

881: EXCEPTION
882: WHEN OTHERS THEN
883: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'no_submit_cc_line', itemtype, itemkey);
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;

Line 886: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

882: WHEN OTHERS THEN
883: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'no_submit_cc_line', itemtype, itemkey);
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;

Line 887: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

883: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'no_submit_cc_line', itemtype, itemkey);
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;

Line 1003: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

999: EXCEPTION
1000: WHEN OTHERS THEN
1001: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'find_cc_receiver', itemtype, itemkey);
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;

Line 1004: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1000: WHEN OTHERS THEN
1001: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'find_cc_receiver', itemtype, itemkey);
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;

Line 1005: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1001: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'find_cc_receiver', itemtype, itemkey);
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;

Line 1057: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_rec', itemtype, itemkey);
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;

Line 1058: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1054: WHEN OTHERS THEN
1055: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_rec', itemtype, itemkey);
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;

Line 1059: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1055: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_rec', itemtype, itemkey);
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;

Line 1111: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1107: EXCEPTION
1108: WHEN OTHERS THEN
1109: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'double_timeout', itemtype, itemkey);
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;

Line 1112: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1108: WHEN OTHERS THEN
1109: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'double_timeout', itemtype, itemkey);
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;

Line 1113: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1109: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'double_timeout', itemtype, itemkey);
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;

Line 1168: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'final_approver', itemtype, itemkey);
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;

Line 1169: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1165: WHEN OTHERS THEN
1166: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'final_approver', itemtype, itemkey);
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;

Line 1170: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1166: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'final_approver', itemtype, itemkey);
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;

Line 1216: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'is_receiver_final_approver', itemtype, itemkey);
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;

Line 1217: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1213: WHEN OTHERS THEN
1214: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'is_receiver_final_approver', itemtype, itemkey);
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;

Line 1218: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1214: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'is_receiver_final_approver', itemtype, itemkey);
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;

Line 1270: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1266: EXCEPTION
1267: WHEN OTHERS THEN
1268: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'verify_authority', itemtype, itemkey);
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;

Line 1271: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1267: WHEN OTHERS THEN
1268: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'verify_authority', itemtype, itemkey);
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;

Line 1272: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1268: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'verify_authority', itemtype, itemkey);
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;

Line 1332: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1328: EXCEPTION
1329: WHEN OTHERS THEN
1330: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'approve_cc_line', itemtype, itemkey);
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;

Line 1333: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1329: WHEN OTHERS THEN
1330: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'approve_cc_line', itemtype, itemkey);
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;

Line 1334: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1330: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'approve_cc_line', itemtype, itemkey);
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;

Line 1380: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reject_cc_line', itemtype, itemkey);
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;

Line 1381: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1377: WHEN OTHERS THEN
1378: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reject_cc_line', itemtype, itemkey);
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;

Line 1382: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1378: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reject_cc_line', itemtype, itemkey);
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;

Line 1415: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1411: WHEN OTHERS THEN
1412: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getmanager',
1413: null, null, null );
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;

Line 1416: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1412: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getmanager',
1413: null, null, null );
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;

Line 1417: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1413: null, null, null );
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;

Line 1489: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1485: WHEN OTHERS THEN
1486: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'setpersonas',
1487: item_type, item_key, null );
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;

Line 1490: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1486: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'setpersonas',
1487: item_type, item_key, null );
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;

Line 1491: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1487: item_type, item_key, null );
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;

Line 1546: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1542: WHEN OTHERS THEN
1543: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getfinalapprover',
1544: p_item_type, null, null );
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;

Line 1547: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1543: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getfinalapprover',
1544: p_item_type, null, null );
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;

Line 1548: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1544: p_item_type, null, null );
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;

Line 1617: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_APPROVER_METHOD');

1613: item_type,
1614: next_approver_id);
1615: END IF;
1616: ELSE
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);

Line 1618: l_error_message := FND_MESSAGE.Get;

1614: next_approver_id);
1615: END IF;
1616: ELSE
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;

Line 1637: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1633: next_approver_id := l_next_approver_id_old;
1634: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getapprover',
1635: null, null, null );
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;

Line 1638: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1634: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getapprover',
1635: null, null, null );
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;

Line 1639: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1635: null, null, null );
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;

Line 1720: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_MANAGER');

1716:
1717: IF (l_dir_manager_id IS NOT NULL) THEN
1718: l_next_approver_id := l_dir_manager_id;
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;

Line 1721: l_error_message := FND_MESSAGE.Get;

1717: IF (l_dir_manager_id IS NOT NULL) THEN
1718: l_next_approver_id := l_dir_manager_id;
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,

Line 1752: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_APPROVER');

1748:
1749: END IF;
1750:
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;

Line 1753: l_error_message := FND_MESSAGE.Get;

1749: END IF;
1750:
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,

Line 1790: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1786: result := NULL;
1787: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'Find_Approver',
1788: item_type, item_key, null );
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;

Line 1791: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1787: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'Find_Approver',
1788: item_type, item_key, null );
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;

Line 1792: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1788: item_type, item_key, null );
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:

Line 1853: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1849: WHEN OTHERS THEN
1850: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'record_forward_from_info',
1851: p_item_type, p_item_key, to_char(p_actid) );
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;

Line 1854: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1850: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'record_forward_from_info',
1851: p_item_type, p_item_key, to_char(p_actid) );
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;

Line 1855: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1851: p_item_type, p_item_key, to_char(p_actid) );
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;

Line 1903: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1899: p_result := NULL;
1900: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'mgr_equalto_aprv',
1901: p_item_type, p_item_key, to_char(p_actid));
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;

Line 1904: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1900: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'mgr_equalto_aprv',
1901: p_item_type, p_item_key, to_char(p_actid));
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;

Line 1905: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1901: p_item_type, p_item_key, to_char(p_actid));
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;

Line 1957: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1953: p_result := NULL;
1954: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'first_approver',
1955: p_item_type, p_item_key, to_char(p_actid));
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;

Line 1958: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1954: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'first_approver',
1955: p_item_type, p_item_key, to_char(p_actid));
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;

Line 1959: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1955: p_item_type, p_item_key, to_char(p_actid));
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;

Line 2011: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_prep', itemtype, itemkey);
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;

Line 2012: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

2008: WHEN OTHERS THEN
2009: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_prep', itemtype, itemkey);
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;

Line 2013: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

2009: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_prep', itemtype, itemkey);
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;

Line 2065: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_rec', itemtype, itemkey);
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;

Line 2066: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

2062: WHEN OTHERS THEN
2063: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_rec', itemtype, itemkey);
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;

Line 2067: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

2063: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_rec', itemtype, itemkey);
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;

Line 2146: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reset_approval_attributes', itemtype, itemkey);
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;

Line 2147: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

2143: WHEN OTHERS THEN
2144: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reset_approval_attributes', itemtype, itemkey);
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;

Line 2148: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

2144: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reset_approval_attributes', itemtype, itemkey);
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;