1: PACKAGE BODY mrp_exp_wf AS
2: /*$Header: MRPEXWFB.pls 120.1 2005/08/29 07:15:29 gmalhotr noship $ */
3:
4: PROCEDURE launch_workflow(errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
354: WHEN NO_DATA_FOUND THEN
355: null;
356:
357: WHEN OTHERS THEN
358: errbuf := 'Error in mrp_exp_wf.launch_workflow function' ||
359: ' Cursor: ' || l_cursor || ' Exception ID: '
360: || l_exception_id ||
361: ' SQL error: ' || sqlerrm;
362: retcode := 1;
603:
604: EXCEPTION
605:
606: when others then
607: wf_core.context('MRP_EXP_WF', 'StartWFProcess', item_key, compile_designator, organization_code, item_segments, to_char(exception_type));
608: raise;
609:
610: END StartWFProcess;
611:
680:
681: EXCEPTION
682:
683: when others then
684: wf_core.context('MRP_EXP_WF', 'DetermineProceed', itemtype, itemkey, actid, funcmode);
685: raise;
686:
687: END DetermineProceed;
688:
792:
793: EXCEPTION
794:
795: when others then
796: wf_core.context('MRP_EXP_WF', 'SelectPlanner', itemtype, itemkey, actid, funcmode);
797: raise;
798:
799: END SelectPlanner;
800:
900:
901: EXCEPTION
902:
903: when others then
904: wf_core.context('MRP_EXP_WF', 'SelectBuyer', itemtype, itemkey, actid, funcmode);
905: raise;
906:
907: END SelectBuyer;
908:
1001:
1002: EXCEPTION
1003:
1004: when others then
1005: wf_core.context('MRP_EXP_WF', 'SelectSupplierCnt', itemtype, itemkey, actid, funcmode);
1006: raise;
1007:
1008: END SelectSupplierCnt;
1009:
1109:
1110: EXCEPTION
1111:
1112: when others then
1113: wf_core.context('MRP_EXP_WF', 'SelectSalesRep', itemtype, itemkey, actid, funcmode);
1114: raise;
1115:
1116: END SelectSalesRep;
1117:
1209:
1210: EXCEPTION
1211:
1212: when others then
1213: wf_core.context('MRP_EXP_WF', 'SelectCustomerCnt', itemtype, itemkey, actid, funcmode);
1214: raise;
1215:
1216: END SelectCustomerCnt;
1217:
1341:
1342: EXCEPTION
1343:
1344: when others then
1345: wf_core.context('MRP_EXP_WF', 'SelectTaskMgr', itemtype, itemkey, actid, funcmode);
1346: raise;
1347:
1348: END SelectTaskMgr;
1349:
1489:
1490: EXCEPTION
1491:
1492: when others then
1493: wf_core.context('MRP_EXP_WF', 'GetMessageName', to_char(p_exception_type), to_char(p_order_type));
1494: raise;
1495:
1496: END GetMessageName;
1497:
1546:
1547: EXCEPTION
1548:
1549: when others then
1550: wf_core.context('MRP_EXP_WF', 'DetermineExceptionType', itemtype, itemkey, actid, funcmode);
1551: raise;
1552:
1553: END DetermineExceptionType;
1554:
1617:
1618: EXCEPTION
1619:
1620: when others then
1621: wf_core.context('MRP_EXP_WF', 'DetermineOrderType', itemtype, itemkey, actid, funcmode);
1622: raise;
1623:
1624: END DetermineOrderType;
1625:
1859:
1860: EXCEPTION
1861:
1862: when others then
1863: wf_core.context('MRP_EXP_WF', 'Reschedule', itemtype, itemkey, actid, funcmode);
1864: raise;
1865:
1866: END Reschedule;
1867:
1912:
1913: EXCEPTION
1914:
1915: when others then
1916: wf_core.context('MRP_EXP_WF', 'IsType19', itemtype, itemkey, actid, funcmode);
1917: raise;
1918:
1919: END IsType19;
1920:
2066:
2067: END DeleteActivities;
2068:
2069:
2070: END mrp_exp_wf;