1: PACKAGE BODY GL_WF_JE_APPROVAL_PKG AS
2: /* $Header: glwfjeab.pls 120.13.12010000.4 2009/06/22 10:42:26 skotakar ship $ */
3:
4: -- +--------------------+
5: -- | PRIVATE PROCEDURES |
57: RETURN TRUE;
58:
59: EXCEPTION
60: WHEN OTHERS THEN
61: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG',
62: 'check_authorization_limit');
63: raise;
64: END check_authorization_limit;
65:
91: EXCEPTION
92: WHEN NO_DATA_FOUND THEN
93: manager_id := NULL;
94: WHEN OTHERS THEN
95: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'getmanager');
96: raise;
97: END getmanager;
98:
99:
153: END IF;
154:
155: EXCEPTION
156: WHEN OTHERS THEN
157: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'setpersonas',
158: item_type, item_key);
159: raise;
160: END setpersonas;
161:
190: END LOOP;
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'getfinalapprover');
195: raise;
196: END getfinalapprover;
197:
198:
257: END IF;
258:
259: EXCEPTION
260: WHEN OTHERS THEN
261: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'getapprover',
262: item_type, item_key);
263: raise;
264: END getapprover;
265:
401: diagn_msg('Process GL_JE_APPROVAL_PROCESS started');
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'start_approval_workflow',
406: l_itemtype, l_itemkey);
407: raise;
408:
409: END start_approval_workflow;
463: END IF;
464:
465: EXCEPTION
466: WHEN OTHERS THEN
467: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'is_employee_set',
468: itemtype, itemkey, to_char(actid), funcmode);
469: raise;
470:
471: END is_employee_set;
610: END IF;
611:
612: EXCEPTION
613: WHEN OTHERS THEN
614: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'get_sob_attributes',
615: itemtype, itemkey, to_char(actid), funcmode);
616: raise;
617: END get_sob_attributes;
618:
735: END IF;
736:
737: EXCEPTION
738: WHEN OTHERS THEN
739: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'get_jeb_attributes',
740: itemtype, itemkey, to_char(actid), funcmode);
741: raise;
742:
743: END get_jeb_attributes;
885: END IF;
886:
887: EXCEPTION
888: WHEN OTHERS THEN
889: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'is_je_valid',
890: itemtype, itemkey, to_char(actid), funcmode);
891: raise;
892: END is_je_valid;
893:
919: END IF;
920:
921: EXCEPTION
922: WHEN OTHERS THEN
923: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'set_je_invalid',
924: itemtype, itemkey, to_char(actid), funcmode);
925: raise;
926: END set_je_invalid;
927:
971: END IF;
972:
973: EXCEPTION
974: WHEN OTHERS THEN
975: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'does_je_need_approval',
976: itemtype, itemkey, to_char(actid), funcmode);
977: raise;
978: END does_je_need_approval;
979:
1005: END IF;
1006:
1007: EXCEPTION
1008: WHEN OTHERS THEN
1009: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'set_approval_not_required',
1010: itemtype, itemkey, to_char(actid), funcmode);
1011: raise;
1012: END set_approval_not_required;
1013:
1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN OTHERS THEN
1060: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'can_preparer_approve',
1061: itemtype, itemkey, to_char(actid), funcmode);
1062: raise;
1063: END can_preparer_approve;
1064:
1109: END IF;
1110:
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'set_approver_name',
1114: itemtype, itemkey, to_char(actid), funcmode);
1115: raise;
1116: END set_approver_name;
1117:
1145: END IF;
1146:
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'set_je_approver',
1150: itemtype, itemkey, to_char(actid), funcmode);
1151: raise;
1152: END set_je_approver;
1153:
1189: END IF;
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'approve_je',
1194: itemtype, itemkey, to_char(actid), funcmode);
1195: raise;
1196: END approve_je;
1197:
1221: END IF;
1222:
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'reject_je',
1226: itemtype, itemkey, to_char(actid), funcmode);
1227: raise;
1228: END reject_je;
1229:
1353: END IF;
1354:
1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'Find_Approver',
1358: item_type, item_key, to_char(actid), funcmode);
1359: raise;
1360:
1361: END find_approver;
1431: END IF;
1432:
1433: EXCEPTION
1434: WHEN OTHERS THEN
1435: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'first_approver',
1436: item_type, item_key, to_char(actid), funcmode);
1437: raise;
1438: END first_approver;
1439:
1497: END IF;
1498:
1499: EXCEPTION
1500: WHEN OTHERS THEN
1501: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'set_curr_approver', itemtype, itemkey);
1502: raise;
1503: END set_curr_approver;
1504:
1505:
1535: END IF;
1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'mgr_equalto_aprv',
1540: item_type, item_key, to_char(actid), funcmode);
1541: raise;
1542: END mgr_equalto_aprv;
1543:
1586: END IF;
1587:
1588: EXCEPTION
1589: WHEN OTHERS THEN
1590: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'notifyprep_noaprvresp',
1591: item_type, item_key, to_char(actid), funcmode);
1592: raise;
1593: END notifyprep_noaprvresp;
1594:
1628: END IF;
1629:
1630: EXCEPTION
1631: WHEN OTHERS THEN
1632: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'get_approver_manager',
1633: item_type, item_key, to_char(actid), funcmode);
1634: raise;
1635: END get_approver_manager;
1636:
1693: END IF;
1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'record_forward_from_info',
1698: item_type, item_key, to_char(actid), funcmode);
1699: raise;
1700: END record_forward_from_info;
1701:
1733: END IF;
1734:
1735: EXCEPTION
1736: WHEN OTHERS THEN
1737: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'verify_authority',
1738: itemtype, itemkey, to_char(actid), funcmode);
1739: raise;
1740: END verify_authority;
1741:
1769: END IF;
1770:
1771: EXCEPTION
1772: WHEN OTHERS THEN
1773: Wf_Core.Context('GL_WF_JE_APPROVAL_PKG', 'abort_process',
1774: itemtype, itemkey, to_char(actid), funcmode);
1775: raise;
1776: END abort_process;
1777:
1775: raise;
1776: END abort_process;
1777:
1778:
1779: END GL_WF_JE_APPROVAL_PKG;