DBA Data[Home] [Help]

APPS.IGI_ITR_APPROVAL_PKG dependencies on WF_CORE

Line 48: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_authorization_limit',

44: WHEN NO_DATA_FOUND THEN
45: l_limit := 0;
46: return (l_limit);
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);

Line 260: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'start_approval_workflow', l_itemtype, l_itemkey);

256: commit;
257:
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);

Line 379: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_sob_attributes', itemtype, itemkey);

375: END IF;
376:
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);

Line 494: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'get_cc_attributes', itemtype, itemkey);

490: END IF;
491:
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);

Line 538: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'did_preparer_approve', itemtype, itemkey);

534: END IF;
535:
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);

Line 593: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_prep', itemtype, itemkey);

589: END IF;
590:
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);

Line 636: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'secondary_approver_selected', itemtype, itemkey);

632: END IF;
633:
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);

Line 691: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_sec_app', itemtype, itemkey);

687: END IF;
688:
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);

Line 773: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'maintain_history', itemtype, itemkey);

769: END IF;
770:
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);

Line 829: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'submit_cc_line', itemtype, itemkey);

825: END IF;
826:
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);

Line 883: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'no_submit_cc_line', itemtype, itemkey);

879: END IF;
880:
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);

Line 1001: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'find_cc_receiver', itemtype, itemkey);

997: END IF;
998:
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);

Line 1055: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_approver_name_to_rec', itemtype, itemkey);

1051: END IF;
1052:
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);

Line 1109: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'double_timeout', itemtype, itemkey);

1105: END IF;
1106:
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);

Line 1166: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'final_approver', itemtype, itemkey);

1162: END IF;
1163:
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);

Line 1214: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'is_receiver_final_approver', itemtype, itemkey);

1210: END IF;
1211:
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);

Line 1268: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'verify_authority', itemtype, itemkey);

1264: END IF;
1265:
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);

Line 1330: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'approve_cc_line', itemtype, itemkey);

1326: END IF;
1327:
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);

Line 1378: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reject_cc_line', itemtype, itemkey);

1374: END IF;
1375:
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);

Line 1412: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getmanager',

1408: EXCEPTION
1409: WHEN NO_DATA_FOUND THEN
1410: manager_id := NULL;
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);

Line 1486: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'setpersonas',

1482: END IF;
1483:
1484: EXCEPTION
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);

Line 1543: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getfinalapprover',

1539: END LOOP;
1540:
1541: EXCEPTION
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);

Line 1634: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'getapprover',

1630:
1631: EXCEPTION
1632: WHEN OTHERS THEN
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);

Line 1787: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'Find_Approver',

1783:
1784: EXCEPTION
1785: WHEN OTHERS THEN
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);

Line 1850: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'record_forward_from_info',

1846: END IF;
1847:
1848: EXCEPTION
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);

Line 1900: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'mgr_equalto_aprv',

1896:
1897: EXCEPTION
1898: WHEN OTHERS THEN
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);

Line 1954: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'first_approver',

1950:
1951: EXCEPTION
1952: WHEN OTHERS THEN
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);

Line 2009: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_prep', itemtype, itemkey);

2005: END IF;
2006:
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);

Line 2063: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'set_employee_name_to_rec', itemtype, itemkey);

2059: END IF;
2060:
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);

Line 2144: Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'reset_approval_attributes', itemtype, itemkey);

2140: END IF;
2141:
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);