DBA Data[Home] [Help]

APPS.XDPCORE_LINE dependencies on XDPCORE_LINE

Line 1: PACKAGE BODY XDPCORE_LINE AS

1: PACKAGE BODY XDPCORE_LINE AS
2: /* $Header: XDPCORLB.pls 120.1 2005/06/08 23:47:15 appldev $ */
3:
4:
5: /****

Line 125: wf_core.context('XDPCORE_LINE', 'LAUNCH_LINEITEM_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

121:
122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: wf_core.context('XDPCORE_LINE', 'LAUNCH_LINEITEM_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
126: raise;
127: END LAUNCH_LINEITEM_PROCESS;
128:
129:

Line 161: wf_core.context('XDPCORE_LINE', 'INITIALIZE_LINE', itemtype, itemkey, to_char(actid), funcmode);

157:
158:
159: EXCEPTION
160: WHEN OTHERS THEN
161: wf_core.context('XDPCORE_LINE', 'INITIALIZE_LINE', itemtype, itemkey, to_char(actid), funcmode);
162: raise;
163: END INITIALIZE_LINE;
164:
165:

Line 198: wf_core.context('XDPCORE_LINE', 'IS_LINE_A_PACKAGE', itemtype, itemkey, to_char(actid), funcmode);

194:
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: wf_core.context('XDPCORE_LINE', 'IS_LINE_A_PACKAGE', itemtype, itemkey, to_char(actid), funcmode);
199: raise;
200: END IS_LINE_A_PACKAGE;
201:
202:

Line 233: wf_core.context('XDPCORE_LINE', 'LAUNCH_LINE_FOR_ORDER_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

229:
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: wf_core.context('XDPCORE_LINE', 'LAUNCH_LINE_FOR_ORDER_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
234: raise;
235: END LAUNCH_LINE_FOR_ORDER_PROCESS;
236:
237:

Line 269: wf_core.context('XDPCORE_LINE', 'LAUNCH_SERVICE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

265:
266:
267: EXCEPTION
268: WHEN OTHERS THEN
269: wf_core.context('XDPCORE_LINE', 'LAUNCH_SERVICE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
270: raise;
271: END LAUNCH_SERVICE_PROCESS;
272:
273:

Line 305: wf_core.context('XDPCORE_LINE', 'ARE_ALL_LINES_DONE', itemtype, itemkey, to_char(actid), funcmode);

301: END IF;
302:
303: EXCEPTION
304: WHEN OTHERS THEN
305: wf_core.context('XDPCORE_LINE', 'ARE_ALL_LINES_DONE', itemtype, itemkey, to_char(actid), funcmode);
306: raise;
307: END ARE_ALL_LINES_DONE;
308:
309:

Line 334: wf_core.context('XDPCORE_LINE', 'UPDATE_INSTALL_BASE', itemtype, itemkey, to_char(actid), funcmode);

330: END IF;
331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: wf_core.context('XDPCORE_LINE', 'UPDATE_INSTALL_BASE', itemtype, itemkey, to_char(actid), funcmode);
335: raise;
336: END UPDATE_INSTALL_BASE;
337:
338: Procedure LAUNCH_ALL_IND_LINES (itemtype in varchar2,

Line 361: wf_core.context('XDPCORE_LINE', 'LAUNCH_ALL_IND_LINES', itemtype, itemkey, to_char(actid), funcmode);

357: END IF;
358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: wf_core.context('XDPCORE_LINE', 'LAUNCH_ALL_IND_LINES', itemtype, itemkey, to_char(actid), funcmode);
362: raise;
363: END LAUNCH_ALL_IND_LINES;
364:
365: Procedure INITIALIZE_DEP_LINE_PROCESS (itemtype in varchar2,

Line 388: wf_core.context('XDPCORE_LINE', 'INITIALIZE_DEP_LINE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

384: END IF;
385:
386: EXCEPTION
387: WHEN OTHERS THEN
388: wf_core.context('XDPCORE_LINE', 'INITIALIZE_DEP_LINE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
389: raise;
390: END INITIALIZE_DEP_LINE_PROCESS;
391:
392: Procedure RESOLVE_IND_DEP_LINES (itemtype in varchar2,

Line 415: wf_core.context('XDPCORE_LINE', 'RESOLVE_IND_DEP_LINES', itemtype, itemkey, to_char(actid), funcmode);

411: END IF;
412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: wf_core.context('XDPCORE_LINE', 'RESOLVE_IND_DEP_LINES', itemtype, itemkey, to_char(actid), funcmode);
416: raise;
417: END RESOLVE_IND_DEP_LINES;
418:
419: Procedure IS_SER_PART_PACKAGE (itemtype in varchar2,

Line 442: wf_core.context('XDPCORE_LINE', 'IS_SER_PART_PACKAGE', itemtype, itemkey, to_char(actid), funcmode);

438: END IF;
439:
440: EXCEPTION
441: WHEN OTHERS THEN
442: wf_core.context('XDPCORE_LINE', 'IS_SER_PART_PACKAGE', itemtype, itemkey, to_char(actid), funcmode);
443: raise;
444: END IS_SER_PART_PACKAGE;
445:
446:

Line 473: wf_core.context('XDPCORE_LINE', 'LINE_FULFILLMENT_DONE', itemtype, itemkey, to_char(actid), funcmode);

469: END IF;
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: wf_core.context('XDPCORE_LINE', 'LINE_FULFILLMENT_DONE', itemtype, itemkey, to_char(actid), funcmode);
474: raise;
475: END PUBLISH_XDP_LINE_DONE ;
476:
477:

Line 549: x_Progress := 'XDPCORE_LINE.AreAllLinesDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

545: return l_result;
546:
547: exception
548: when others then
549: x_Progress := 'XDPCORE_LINE.AreAllLinesDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
550: wf_core.context('XDPCORE_LINE', 'AreAllLinesDone', itemtype, itemkey, null, x_Progress);
551: raise;
552: end AreAllLinesDone;
553:

Line 550: wf_core.context('XDPCORE_LINE', 'AreAllLinesDone', itemtype, itemkey, null, x_Progress);

546:
547: exception
548: when others then
549: x_Progress := 'XDPCORE_LINE.AreAllLinesDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
550: wf_core.context('XDPCORE_LINE', 'AreAllLinesDone', itemtype, itemkey, null, x_Progress);
551: raise;
552: end AreAllLinesDone;
553:
554:

Line 655: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForBundleCaller', itemtype, itemkey, null, x_Progress);

651: if c_LineSeqForBundle%ISOPEN then
652: close c_LineSeqForBundle;
653: end if;
654:
655: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForBundleCaller', itemtype, itemkey, null, x_Progress);
656: raise;
657: when others then
658: if c_LineSeqNullBundle%ISOPEN then
659: close c_LineSeqNullBundle;

Line 666: x_Progress := 'XDPCORE_LINE.AreAllLinesDoneForBundleCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

662: if c_LineSeqForBundle%ISOPEN then
663: close c_LineSeqForBundle;
664: end if;
665:
666: x_Progress := 'XDPCORE_LINE.AreAllLinesDoneForBundleCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
667: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForBundleCaller', itemtype, itemkey, null, x_Progress);
668: raise;
669: end AreAllLinesDoneForBundleCaller;
670:

Line 667: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForBundleCaller', itemtype, itemkey, null, x_Progress);

663: close c_LineSeqForBundle;
664: end if;
665:
666: x_Progress := 'XDPCORE_LINE.AreAllLinesDoneForBundleCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
667: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForBundleCaller', itemtype, itemkey, null, x_Progress);
668: raise;
669: end AreAllLinesDoneForBundleCaller;
670:
671:

Line 732: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForOrderCaller', itemtype, itemkey, null, x_Progress);

728: if c_LineSeq%ISOPEN then
729: close c_LineSeq;
730: end if;
731:
732: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForOrderCaller', itemtype, itemkey, null, x_Progress);
733: raise;
734:
735: when others then
736: if c_LineSeq%ISOPEN then

Line 740: x_Progress := 'XDPCORE_LINE.AreAllLinesDoneForOrderCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

736: if c_LineSeq%ISOPEN then
737: close c_LineSeq;
738: end if;
739:
740: x_Progress := 'XDPCORE_LINE.AreAllLinesDoneForOrderCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
741: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForOrderCaller', itemtype, itemkey, null, x_Progress);
742: raise;
743: end AreAllLinesDoneForOrderCaller;
744:

Line 741: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForOrderCaller', itemtype, itemkey, null, x_Progress);

737: close c_LineSeq;
738: end if;
739:
740: x_Progress := 'XDPCORE_LINE.AreAllLinesDoneForOrderCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
741: wf_core.context('XDPCORE_LINE', 'AreAllLinesDoneForOrderCaller', itemtype, itemkey, null, x_Progress);
742: raise;
743: end AreAllLinesDoneForOrderCaller;
744:
745:

Line 771: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

767:
768:
769: exception
770: when others then
771: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
772: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcess', itemtype, itemkey, null, x_Progress);
773: raise;
774: end LaunchLineItemProcess;
775:

Line 772: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcess', itemtype, itemkey, null, x_Progress);

768:
769: exception
770: when others then
771: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
772: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcess', itemtype, itemkey, null, x_Progress);
773: raise;
774: end LaunchLineItemProcess;
775:
776:

Line 889: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForBundle. Could not find any Lines for Independet Bundle for OrderID: ' || l_OrderID;

885:
886: close c_LineSeqNullBundle;
887:
888: if l_Counter = 0 and l_CurrentLineSeq = 0 then
889: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForBundle. Could not find any Lines for Independet Bundle for OrderID: ' || l_OrderID;
890: RAISE e_InvalidConfigException;
891: else
892:
893: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchLineItemProcessForBundle.itemtype,

Line 994: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForBundle. Could not find any Lines for BundleID: ' || l_BundleID || ' OrderID: ' || l_OrderID;

990:
991: close c_LineSeqForBundle;
992:
993: if l_Counter = 0 and l_CurrentLineSeq = 0 then
994: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForBundle. Could not find any Lines for BundleID: ' || l_BundleID || ' OrderID: ' || l_OrderID;
995: RAISE e_InvalidConfigException;
996: else
997:
998: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchLineItemProcessForBundle.itemtype,

Line 1041: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForBundle', itemtype, itemkey, null, x_Progress);

1037: if c_LineSeqForBundle%ISOPEN then
1038: close c_LineSeqForBundle;
1039: end if;
1040:
1041: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForBundle', itemtype, itemkey, null, x_Progress);
1042: raise;
1043:
1044: when others then
1045: if c_LineSeqNullBundle%ISOPEN then

Line 1053: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForBundle. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1049: if c_LineSeqForBundle%ISOPEN then
1050: close c_LineSeqForBundle;
1051: end if;
1052:
1053: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForBundle. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1054: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForBundle', itemtype, itemkey, null, x_Progress);
1055: raise;
1056: end LaunchLineItemProcessForBundle;
1057:

Line 1054: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForBundle', itemtype, itemkey, null, x_Progress);

1050: close c_LineSeqForBundle;
1051: end if;
1052:
1053: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForBundle. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1054: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForBundle', itemtype, itemkey, null, x_Progress);
1055: raise;
1056: end LaunchLineItemProcessForBundle;
1057:
1058:

Line 1189: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForOrder. Could not find any Lines for OrderID: ' || l_OrderID || ' Current Line Seqeuence: ' || l_PrevLineSeq;

1185:
1186: close c_LineSeq;
1187:
1188: if l_Counter = 0 and l_CurrentLineSeq = 0 then
1189: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForOrder. Could not find any Lines for OrderID: ' || l_OrderID || ' Current Line Seqeuence: ' || l_PrevLineSeq;
1190: RAISE e_InvalidConfigException;
1191: else
1192: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchLineItemProcessForOrder.itemtype,
1193: itemkey => LaunchLineItemProcessForOrder.itemkey,

Line 1229: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForOrder', itemtype, itemkey, null, x_Progress);

1225: if c_LineSeq%ISOPEN then
1226: close c_LineSeq;
1227: end if;
1228:
1229: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForOrder', itemtype, itemkey, null, x_Progress);
1230: raise;
1231:
1232: when others then
1233: if c_LineSeq%ISOPEN then

Line 1237: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForOrder. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1233: if c_LineSeq%ISOPEN then
1234: close c_LineSeq;
1235: end if;
1236:
1237: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForOrder. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1238: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForOrder', itemtype, itemkey, null, x_Progress);
1239: raise;
1240: end LaunchLineItemProcessForOrder;
1241:

Line 1238: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForOrder', itemtype, itemkey, null, x_Progress);

1234: close c_LineSeq;
1235: end if;
1236:
1237: x_Progress := 'XDPCORE_LINE.LaunchLineItemProcessForOrder. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1238: wf_core.context('XDPCORE_LINE', 'LaunchLineItemProcessForOrder', itemtype, itemkey, null, x_Progress);
1239: raise;
1240: end LaunchLineItemProcessForOrder;
1241:
1242:

Line 1403: x_Progress := 'XDPCORE_LINE.LaunchLineForOrderProcess. Found No lines to be processed for OrderID: ' || l_OrderID;

1399:
1400: close c_GetDepLines;
1401:
1402: if l_Counter = 0 then
1403: x_Progress := 'XDPCORE_LINE.LaunchLineForOrderProcess. Found No lines to be processed for OrderID: ' || l_OrderID;
1404: RAISE e_NoLinesFoundException;
1405: end if;
1406:
1407:

Line 1425: wf_core.context('XDPCORE_LINE', 'LaunchLineForOrderProcess', itemtype, itemkey, null, x_Progress);

1421: if c_GetDepLines%ISOPEN then
1422: close c_GetDepLines;
1423: end if;
1424:
1425: wf_core.context('XDPCORE_LINE', 'LaunchLineForOrderProcess', itemtype, itemkey, null, x_Progress);
1426: raise;
1427:
1428: when e_NoLinesFoundException then
1429: if c_GetIndLines%ISOPEN then

Line 1437: wf_core.context('XDPCORE_LINE', 'LaunchLineForOrderProcess', itemtype, itemkey, null, x_Progress);

1433: if c_GetDepLines%ISOPEN then
1434: close c_GetDepLines;
1435: end if;
1436:
1437: wf_core.context('XDPCORE_LINE', 'LaunchLineForOrderProcess', itemtype, itemkey, null, x_Progress);
1438: raise;
1439:
1440: when others then
1441: if c_GetIndLines%ISOPEN then

Line 1449: x_Progress := 'XDPCORE_LINE.LaunchLineForOrderProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1445: if c_GetDepLines%ISOPEN then
1446: close c_GetDepLines;
1447: end if;
1448:
1449: x_Progress := 'XDPCORE_LINE.LaunchLineForOrderProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1450: wf_core.context('XDPCORE_LINE', 'LaunchLineForOrderProcess', itemtype, itemkey, null, x_Progress);
1451: raise;
1452: end LaunchLineForOrderProcess;
1453:

Line 1450: wf_core.context('XDPCORE_LINE', 'LaunchLineForOrderProcess', itemtype, itemkey, null, x_Progress);

1446: close c_GetDepLines;
1447: end if;
1448:
1449: x_Progress := 'XDPCORE_LINE.LaunchLineForOrderProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1450: wf_core.context('XDPCORE_LINE', 'LaunchLineForOrderProcess', itemtype, itemkey, null, x_Progress);
1451: raise;
1452: end LaunchLineForOrderProcess;
1453:
1454: Function LaunchAllIndLines (itemtype in varchar2,

Line 1586: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);

1582:
1583: exception
1584: when e_AddAttributeException then
1585:
1586: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1587: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1588: raise;
1589:
1590: when e_NoLinesFoundException then

Line 1587: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);

1583: exception
1584: when e_AddAttributeException then
1585:
1586: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1587: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1588: raise;
1589:
1590: when e_NoLinesFoundException then
1591:

Line 1592: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);

1588: raise;
1589:
1590: when e_NoLinesFoundException then
1591:
1592: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1593: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1594: raise;
1595:
1596: when others then

Line 1593: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);

1589:
1590: when e_NoLinesFoundException then
1591:
1592: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1593: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1594: raise;
1595:
1596: when others then
1597:

Line 1598: x_Progress := 'XDPCORE_LINE.LaunchAllIndLinesForOrder. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1594: raise;
1595:
1596: when others then
1597:
1598: x_Progress := 'XDPCORE_LINE.LaunchAllIndLinesForOrder. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1599: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1600: raise;
1601: end LaunchAllIndLinesForOrder;
1602:

Line 1599: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);

1595:
1596: when others then
1597:
1598: x_Progress := 'XDPCORE_LINE.LaunchAllIndLinesForOrder. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1599: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForOrder', itemtype, itemkey, null, x_Progress);
1600: raise;
1601: end LaunchAllIndLinesForOrder;
1602:
1603:

Line 1697: Module => 'XDPCORE_LINE.LaunchAllIndLinesForBundle',

1693: avalue => 'WAITFORFLOW-LINE-IND');
1694:
1695: AddLineAttributes(itemtype => 'XDPPROV',
1696: itemkey => t_ChildKeys(l_Counter),
1697: Module => 'XDPCORE_LINE.LaunchAllIndLinesForBundle',
1698: IsPackageFlag => l_IsPackageFlag,
1699: ibsource => l_ib_source,
1700: ibsourceid => l_ib_source_id,
1701: LineProcessCaller => 'BUNDLE',

Line 1749: Module => 'XDPCORE_LINE.LaunchAllIndLinesForBundle',

1745:
1746:
1747: AddLineAttributes(itemtype => 'XDPPROV',
1748: itemkey => t_ChildKeys(l_Counter),
1749: Module => 'XDPCORE_LINE.LaunchAllIndLinesForBundle',
1750: IsPackageFlag => l_IsPackageFlag,
1751: ibsource => l_ib_source,
1752: ibsourceid => l_ib_source_id,
1753: LineProcessCaller => 'BUNDLE',

Line 1778: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);

1774:
1775: exception
1776: when e_AddAttributeException then
1777:
1778: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1779: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1780: raise;
1781:
1782: when e_NoLinesFoundException then

Line 1779: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);

1775: exception
1776: when e_AddAttributeException then
1777:
1778: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1779: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1780: raise;
1781:
1782: when e_NoLinesFoundException then
1783:

Line 1784: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);

1780: raise;
1781:
1782: when e_NoLinesFoundException then
1783:
1784: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1785: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1786: raise;
1787:
1788: when others then

Line 1785: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);

1781:
1782: when e_NoLinesFoundException then
1783:
1784: xdpcore.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1785: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1786: raise;
1787:
1788: when others then
1789:

Line 1790: x_Progress := 'XDPCORE_LINE.LaunchAllIndLinesForBundle. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1786: raise;
1787:
1788: when others then
1789:
1790: x_Progress := 'XDPCORE_LINE.LaunchAllIndLinesForBundle. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1791: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1792: raise;
1793: end LaunchAllIndLinesForBundle;
1794:

Line 1791: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);

1787:
1788: when others then
1789:
1790: x_Progress := 'XDPCORE_LINE.LaunchAllIndLinesForBundle. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1791: wf_core.context('XDPCORE_LINE', 'LaunchAllIndLinesForBundle', itemtype, itemkey, null, x_Progress);
1792: raise;
1793: end LaunchAllIndLinesForBundle;
1794:
1795:

Line 1834: x_Progress := 'XDPCORE_LINE.IsLineaPackage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1830: return l_resultout;
1831:
1832: EXCEPTION
1833: WHEN others THEN
1834: x_Progress := 'XDPCORE_LINE.IsLineaPackage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1835: wf_core.context('XDPCORE_LINE', 'IsLineaPackage', itemtype, itemkey, null, x_Progress);
1836: raise;
1837: end IsLineaPackage;
1838:

Line 1835: wf_core.context('XDPCORE_LINE', 'IsLineaPackage', itemtype, itemkey, null, x_Progress);

1831:
1832: EXCEPTION
1833: WHEN others THEN
1834: x_Progress := 'XDPCORE_LINE.IsLineaPackage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1835: wf_core.context('XDPCORE_LINE', 'IsLineaPackage', itemtype, itemkey, null, x_Progress);
1836: raise;
1837: end IsLineaPackage;
1838:
1839:

Line 1889: x_Progress := 'XDPCORE_LINE.LaunchServiceProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1885:
1886:
1887: exception
1888: when others then
1889: x_Progress := 'XDPCORE_LINE.LaunchServiceProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1890: wf_core.context('XDPCORE_LINE', 'LaunchServiceProcess', itemtype, itemkey, null, x_Progress);
1891: raise;
1892: end LaunchServiceProcess;
1893:

Line 1890: wf_core.context('XDPCORE_LINE', 'LaunchServiceProcess', itemtype, itemkey, null, x_Progress);

1886:
1887: exception
1888: when others then
1889: x_Progress := 'XDPCORE_LINE.LaunchServiceProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1890: wf_core.context('XDPCORE_LINE', 'LaunchServiceProcess', itemtype, itemkey, null, x_Progress);
1891: raise;
1892: end LaunchServiceProcess;
1893:
1894:

Line 1925: x_Progress := 'XDPCORE_LINE.InitializeLine. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1921:
1922: end if;
1923: exception
1924: when others then
1925: x_Progress := 'XDPCORE_LINE.InitializeLine. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1926: wf_core.context('XDPCORE_LINE', 'InitializeLine', itemtype, itemkey, null, x_Progress);
1927: raise;
1928: end InitializeLine;
1929:

Line 1926: wf_core.context('XDPCORE_LINE', 'InitializeLine', itemtype, itemkey, null, x_Progress);

1922: end if;
1923: exception
1924: when others then
1925: x_Progress := 'XDPCORE_LINE.InitializeLine. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1926: wf_core.context('XDPCORE_LINE', 'InitializeLine', itemtype, itemkey, null, x_Progress);
1927: raise;
1928: end InitializeLine;
1929:
1930: PROCEDURE UPDATDE_ORDER_LINE(p_line_item_id IN NUMBER ,

Line 1953: x_Progress := 'XDPCORE_LINE.UPDATDE_ORDER_LINE. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

1949: COMMIT;
1950:
1951: EXCEPTION
1952: WHEN others THEN
1953: x_Progress := 'XDPCORE_LINE.UPDATDE_ORDER_LINE. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1954: wf_core.context('XDPCORE_LINE', 'UPDATDE_ORDER_LINE', p_itemtype, p_itemkey, null, x_Progress);
1955: ROLLBACK;
1956: raise;
1957: END UPDATDE_ORDER_LINE ;

Line 1954: wf_core.context('XDPCORE_LINE', 'UPDATDE_ORDER_LINE', p_itemtype, p_itemkey, null, x_Progress);

1950:
1951: EXCEPTION
1952: WHEN others THEN
1953: x_Progress := 'XDPCORE_LINE.UPDATDE_ORDER_LINE. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1954: wf_core.context('XDPCORE_LINE', 'UPDATDE_ORDER_LINE', p_itemtype, p_itemkey, null, x_Progress);
1955: ROLLBACK;
1956: raise;
1957: END UPDATDE_ORDER_LINE ;
1958:

Line 2114: x_progress := 'In XDPCORE_LINE.InitializeDepLineProcess. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error:' || substr(ErrStr,1,1500);

2110: ErrCode => ErrCode,
2111: ErrStr => ErrStr);
2112:
2113: if ErrCode <> 0 then
2114: x_progress := 'In XDPCORE_LINE.InitializeDepLineProcess. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error:' || substr(ErrStr,1,1500);
2115: raise e_AddAttributeException;
2116: end if;
2117:
2118:

Line 2121: x_Progress := 'XDPCORE_LINE.InitializeDepLineProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2117:
2118:
2119: EXCEPTION
2120: when others then
2121: x_Progress := 'XDPCORE_LINE.InitializeDepLineProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2122: xdpcore.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey,x_Progress);
2123: wf_core.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey, null, x_Progress);
2124: raise;
2125:

Line 2122: xdpcore.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey,x_Progress);

2118:
2119: EXCEPTION
2120: when others then
2121: x_Progress := 'XDPCORE_LINE.InitializeDepLineProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2122: xdpcore.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey,x_Progress);
2123: wf_core.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey, null, x_Progress);
2124: raise;
2125:
2126:

Line 2123: wf_core.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey, null, x_Progress);

2119: EXCEPTION
2120: when others then
2121: x_Progress := 'XDPCORE_LINE.InitializeDepLineProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2122: xdpcore.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey,x_Progress);
2123: wf_core.context('XDPCORE_LINE', 'InitializeDepLineProcess', itemtype, itemkey, null, x_Progress);
2124: raise;
2125:
2126:
2127: END InitializeDepLineProcess;

Line 2184: x_Progress := 'XDPCORE_LINE.ResolveIndDepLines. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

2180:
2181: exception
2182: when others then
2183:
2184: x_Progress := 'XDPCORE_LINE.ResolveIndDepLines. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
2185: wf_core.context('XDPCORE_LINE', 'ResolveIndDepLines', itemtype, itemkey, null, x_Progress);
2186: raise;
2187: end ResolveIndDepLines;
2188:

Line 2185: wf_core.context('XDPCORE_LINE', 'ResolveIndDepLines', itemtype, itemkey, null, x_Progress);

2181: exception
2182: when others then
2183:
2184: x_Progress := 'XDPCORE_LINE.ResolveIndDepLines. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
2185: wf_core.context('XDPCORE_LINE', 'ResolveIndDepLines', itemtype, itemkey, null, x_Progress);
2186: raise;
2187: end ResolveIndDepLines;
2188:
2189:

Line 2210: x_Progress := 'XDPCORE_LINE.IsSerPartPackage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

2206: return l_flag;
2207: exception
2208: when others then
2209:
2210: x_Progress := 'XDPCORE_LINE.IsSerPartPackage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
2211: wf_core.context('XDPCORE_LINE', 'IsSerPartPackage', itemtype, itemkey, null, x_Progress);
2212: raise;
2213: end IsSerPartPackage;
2214:

Line 2211: wf_core.context('XDPCORE_LINE', 'IsSerPartPackage', itemtype, itemkey, null, x_Progress);

2207: exception
2208: when others then
2209:
2210: x_Progress := 'XDPCORE_LINE.IsSerPartPackage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
2211: wf_core.context('XDPCORE_LINE', 'IsSerPartPackage', itemtype, itemkey, null, x_Progress);
2212: raise;
2213: end IsSerPartPackage;
2214:
2215:

Line 2259: x_progress := 'In XDPCORE_LINE.PublishXDPLineDone. Error while publishing XDP_LINE_DONE . Error :- ' ||l_error_message ;

2255: X_ERROR_CODE => l_error_code ,
2256: X_ERROR_MESSAGE => l_error_message );
2257:
2258: IF l_error_code <> 0 THEN
2259: x_progress := 'In XDPCORE_LINE.PublishXDPLineDone. Error while publishing XDP_LINE_DONE . Error :- ' ||l_error_message ;
2260: RAISE e_publish_exception ;
2261: END IF ;
2262:
2263: EXCEPTION

Line 2265: wf_core.context('XDPCORE_LINE', 'PublishXDPLineDone', itemtype, itemkey, null, x_Progress);

2261: END IF ;
2262:
2263: EXCEPTION
2264: WHEN e_publish_exception THEN
2265: wf_core.context('XDPCORE_LINE', 'PublishXDPLineDone', itemtype, itemkey, null, x_Progress);
2266: raise;
2267: WHEN others THEN
2268: wf_core.context('XDPCORE_LINE', 'PublishXDPLineDone',itemtype,itemkey,actid,null);
2269: raise;

Line 2268: wf_core.context('XDPCORE_LINE', 'PublishXDPLineDone',itemtype,itemkey,actid,null);

2264: WHEN e_publish_exception THEN
2265: wf_core.context('XDPCORE_LINE', 'PublishXDPLineDone', itemtype, itemkey, null, x_Progress);
2266: raise;
2267: WHEN others THEN
2268: wf_core.context('XDPCORE_LINE', 'PublishXDPLineDone',itemtype,itemkey,actid,null);
2269: raise;
2270: END PublishXDPLineDone ;
2271:
2272: End XDPCORE_LINE;

Line 2272: End XDPCORE_LINE;

2268: wf_core.context('XDPCORE_LINE', 'PublishXDPLineDone',itemtype,itemkey,actid,null);
2269: raise;
2270: END PublishXDPLineDone ;
2271:
2272: End XDPCORE_LINE;