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.XDPCORE_LINE dependencies on XDPCORE

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 850: XDPCORE.CreateNAddAttrNParentLabel

846: t_ChildTypes(l_Counter) := 'XDPPROV';
847: t_ChildKeys(l_Counter) := l_tempKey;
848:
849: -- Create Process and Bulk Set Item Attribute
850: XDPCORE.CreateNAddAttrNParentLabel
851: (itemtype => t_ChildTypes(l_Counter),
852: itemkey => t_ChildKeys(l_Counter),
853: processname => 'LINE_PROCESSING_PROCESS',
854: parentitemtype => LaunchLineItemProcessForBundle.itemtype,

Line 869: Module => 'XDPCORE_WI.LaunchLinetItemProcessForBundle',

865: avalue => 'WAITFORFLOW-LINE-DEP');
866:
867: AddLineAttributes(itemtype => t_ChildTypes(l_Counter),
868: itemkey => t_ChildKeys(l_Counter),
869: Module => 'XDPCORE_WI.LaunchLinetItemProcessForBundle',
870: IsPackageFlag => l_PackageFlag,
871: ibsource => l_ib_source,
872: ibsourceid => l_ib_source_id,
873: LineProcessCaller => 'ORDER',

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 893: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchLineItemProcessForBundle.itemtype,

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,
894: itemkey => LaunchLineItemProcessForBundle.itemkey,
895: AttrName => 'CURRENT_LINE_SEQUENCE',
896: AttrValue => l_CurrentLineSeq,
897: ErrCode => ErrCode,

Line 901: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

897: ErrCode => ErrCode,
898: ErrStr => ErrStr);
899:
900: if ErrCode <> 0 then
901: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
902: raise e_AddAttributeException;
903: end if;
904:
905: /* Launch the Line Item Fulfillment Process */

Line 938: XDPCORE.CreateNAddAttrNParentLabel(itemtype => t_ChildTypes(l_Counter),

934: t_ChildKeys(l_Counter) := l_tempKey;
935:
936:
937: -- Create Process and Bulk Set Item Attribute
938: XDPCORE.CreateNAddAttrNParentLabel(itemtype => t_ChildTypes(l_Counter),
939: itemkey => t_ChildKeys(l_Counter),
940: processname => 'LINE_PROCESSING_PROCESS',
941: parentitemtype => LaunchLineItemProcessForBundle.itemtype,
942: parentitemkey => LaunchLineItemProcessForBundle.itemkey,

Line 954: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

950: itemkey => l_tempKey,
951: aname => 'MASTER_TO_CONTINUE',
952: avalue => 'WAITFORFLOW-LINE-DEP');
953:
954: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
955: itemkey => t_ChildKeys(l_Counter),
956: AttrName => 'IS_PACKAGE_FLAG',
957: AttrValue => l_PackageFlag,
958: ErrCode => ErrCode,

Line 962: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);

958: ErrCode => ErrCode,
959: ErrStr => ErrStr);
960:
961: if ErrCode <> 0 then
962: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
963: raise e_AddAttributeException;
964: end if;
965:
966: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

Line 966: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

962: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
963: raise e_AddAttributeException;
964: end if;
965:
966: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
967: itemkey => t_ChildKeys(l_Counter),
968: AttrName => 'IB_SOURCE',
969: AttrValue => l_ib_source,
970: ErrCode => ErrCode,

Line 974: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IB_SOURCE. Error: ' || substr(ErrStr,1,1500);

970: ErrCode => ErrCode,
971: ErrStr => ErrStr);
972:
973: if ErrCode <> 0 then
974: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IB_SOURCE. Error: ' || substr(ErrStr,1,1500);
975: raise e_AddAttributeException;
976: end if;
977:
978: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

Line 978: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

974: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IB_SOURCE. Error: ' || substr(ErrStr,1,1500);
975: raise e_AddAttributeException;
976: end if;
977:
978: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
979: itemkey => t_ChildKeys(l_Counter),
980: AttrName => 'IB_SOURCE_ID',
981: AttrValue => l_ib_source_id,
982: ErrCode => ErrCode,

Line 986: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IB_SOURCE_ID. Error: ' || substr(ErrStr,1,1500);

982: ErrCode => ErrCode,
983: ErrStr => ErrStr);
984:
985: if ErrCode <> 0 then
986: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute IB_SOURCE_ID. Error: ' || substr(ErrStr,1,1500);
987: raise e_AddAttributeException;
988: end if;
989: END LOOP;
990:

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 998: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchLineItemProcessForBundle.itemtype,

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,
999: itemkey => LaunchLineItemProcessForBundle.itemkey,
1000: AttrName => 'CURRENT_LINE_SEQUENCE',
1001: AttrValue => l_CurrentLineSeq,
1002: ErrCode => ErrCode,

Line 1006: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

1002: ErrCode => ErrCode,
1003: ErrStr => ErrStr);
1004:
1005: if ErrCode <> 0 then
1006: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForBundle. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1007: raise e_AddAttributeException;
1008: end if;
1009:
1010: /* Launch the Line Item Fulfillment Process */

Line 1029: wf_core.context('XDPCORE_WI', 'LaunchLineItemProcessForBundle', itemtype, itemkey, null, x_Progress);

1025: if c_LineSeqForBundle%ISOPEN then
1026: close c_LineSeqForBundle;
1027: end if;
1028:
1029: wf_core.context('XDPCORE_WI', 'LaunchLineItemProcessForBundle', itemtype, itemkey, null, x_Progress);
1030: raise;
1031:
1032: when e_InvalidConfigException then
1033: if c_LineSeqNullBundle%ISOPEN then

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 1125: XDPCORE.CreateNAddAttrNParentLabel(itemtype => t_ChildTypes(l_Counter),

1121: t_ChildTypes(l_Counter) := 'XDPPROV';
1122: t_ChildKeys(l_Counter) := l_tempKey;
1123:
1124: -- Create Process and Bulk Set Item Attribute
1125: XDPCORE.CreateNAddAttrNParentLabel(itemtype => t_ChildTypes(l_Counter),
1126: itemkey => t_ChildKeys(l_Counter),
1127: processname => 'LINE_PROCESSING_PROCESS',
1128: parentitemtype => LaunchLineItemProcessForOrder.itemtype,
1129: parentitemkey => LaunchLineItemProcessForOrder.itemkey,

Line 1144: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

1140: avalue => 'WAITFORFLOW-LINE-DEP');
1141:
1142: -- Adding IS_PACKAGE_FLAG to the itemattrlist
1143:
1144: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1145: itemkey => t_ChildKeys(l_Counter),
1146: AttrName => 'IS_PACKAGE_FLAG',
1147: AttrValue => l_PackageFlag,
1148: ErrCode => ErrCode,

Line 1152: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);

1148: ErrCode => ErrCode,
1149: ErrStr => ErrStr);
1150:
1151: if ErrCode <> 0 then
1152: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1153: raise e_AddAttributeException;
1154: end if;
1155:
1156: -- Adding IB_SOURCE to the itemattrlist

Line 1158: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

1154: end if;
1155:
1156: -- Adding IB_SOURCE to the itemattrlist
1157:
1158: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1159: itemkey => t_ChildKeys(l_Counter),
1160: AttrName => 'IB_SOURCE',
1161: AttrValue => l_ib_source,
1162: ErrCode => ErrCode,

Line 1166: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute IB_SOURCE. Error: ' || substr(ErrStr,1,1500);

1162: ErrCode => ErrCode,
1163: ErrStr => ErrStr);
1164:
1165: if ErrCode <> 0 then
1166: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute IB_SOURCE. Error: ' || substr(ErrStr,1,1500);
1167: raise e_AddAttributeException;
1168: end if;
1169:
1170: -- Adding IB_SOURCE_ID to the itemattrlist

Line 1172: XDPCORE.CheckNAddItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1168: end if;
1169:
1170: -- Adding IB_SOURCE_ID to the itemattrlist
1171:
1172: XDPCORE.CheckNAddItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1173: itemkey => t_ChildKeys(l_Counter),
1174: AttrName => 'IB_SOURCE_ID',
1175: AttrValue => l_ib_source_id,
1176: ErrCode => ErrCode,

Line 1180: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute IB_SOURCE_ID. Error: ' || substr(ErrStr,1,1500);

1176: ErrCode => ErrCode,
1177: ErrStr => ErrStr);
1178:
1179: if ErrCode <> 0 then
1180: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute IB_SOURCE_ID. Error: ' || substr(ErrStr,1,1500);
1181: raise e_AddAttributeException;
1182: end if;
1183:
1184: END LOOP;

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 1192: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchLineItemProcessForOrder.itemtype,

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,
1194: AttrName => 'CURRENT_LINE_SEQUENCE',
1195: AttrValue => l_CurrentLineSeq,
1196: ErrCode => ErrCode,

Line 1200: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

1196: ErrCode => ErrCode,
1197: ErrStr => ErrStr);
1198:
1199: if ErrCode <> 0 then
1200: x_progress := 'In XDPCORE_WI.LaunchLinetItemProcessForOrder. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1201: raise e_AddAttributeException;
1202: end if;
1203:
1204:

Line 1221: wf_core.context('XDPCORE_WI', 'LaunchLineItemProcessForOrder', itemtype, itemkey, null, x_Progress);

1217: if c_LineSeq%ISOPEN then
1218: close c_LineSeq;
1219: end if;
1220:
1221: wf_core.context('XDPCORE_WI', 'LaunchLineItemProcessForOrder', itemtype, itemkey, null, x_Progress);
1222: raise;
1223:
1224: when e_InvalidConfigException then
1225: if c_LineSeq%ISOPEN then

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 1319: XDPCORE.CreateAndAddAttrNum(itemtype => t_ChildTypes(l_Counter),

1315: t_ChildTypes(l_Counter) := 'XDPPROV';
1316: t_ChildKeys(l_Counter) := l_tempKey;
1317:
1318: -- Create Process and Bulk Set Item Attribute
1319: XDPCORE.CreateAndAddAttrNum(itemtype => t_ChildTypes(l_Counter),
1320: itemkey => t_ChildKeys(l_Counter),
1321: processname => 'LINE_PROCESSING_PROCESS',
1322: parentitemtype => LaunchLineForOrderProcess.itemtype,
1323: parentitemkey => LaunchLineForOrderProcess.itemkey,

Line 1331: Module => 'XDPCORE_WI.LaunchLinetItemForOrderProcess',

1327: FAInstanceID => null);
1328:
1329: AddLineAttributes(itemtype => t_ChildTypes(l_Counter),
1330: itemkey => t_ChildKeys(l_Counter),
1331: Module => 'XDPCORE_WI.LaunchLinetItemForOrderProcess',
1332: IsPackageFlag => l_IsPackageFlag,
1333: ibsource => l_ib_source,
1334: ibsourceid => l_ib_source_id,
1335: LineProcessCaller => 'ORDER',

Line 1371: XDPCORE.CreateAndAddAttrNum(itemtype => t_ChildTypes(l_Counter),

1367: t_ChildTypes(l_Counter) := 'XDPPROV';
1368: t_ChildKeys(l_Counter) := l_tempKey;
1369:
1370: -- Create Process and Bulk Set Item Attribute
1371: XDPCORE.CreateAndAddAttrNum(itemtype => t_ChildTypes(l_Counter),
1372: itemkey => t_ChildKeys(l_Counter),
1373: processname => 'LINE_SEQ_PROCESSING',
1374: parentitemtype => LaunchLineForOrderProcess.itemtype,
1375: parentitemkey => LaunchLineForOrderProcess.itemkey,

Line 1383: Module => 'XDPCORE_WI.LaunchLinetItemForOrderProcess',

1379: FAInstanceID => null);
1380:
1381: AddLineAttributes(itemtype => t_ChildTypes(l_Counter),
1382: itemkey => t_ChildKeys(l_Counter),
1383: Module => 'XDPCORE_WI.LaunchLinetItemForOrderProcess',
1384: IsPackageFlag => null,
1385: ibsource => null,
1386: ibsourceid => null,
1387: LineProcessCaller => 'ORDER',

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 1539: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',

1535:
1536: t_ChildKeys(l_Counter) := l_tempKey;
1537:
1538: -- Create Process and Bulk Set Item Attribute
1539: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',
1540: itemkey => t_ChildKeys(l_Counter),
1541: processname => 'LINE_PROCESSING_PROCESS',
1542: parentitemtype => LaunchAllIndLinesForOrder.itemtype,
1543: parentitemkey => LaunchAllIndLinesForOrder.itemkey,

Line 1558: Module => 'XDPCORE_WI.LaunchLinetItemForOrderProcess',

1554:
1555:
1556: AddLineAttributes(itemtype => 'XDPPROV',
1557: itemkey => t_ChildKeys(l_Counter),
1558: Module => 'XDPCORE_WI.LaunchLinetItemForOrderProcess',
1559: IsPackageFlag => l_IsPackageFlag,
1560: ibsource => l_ib_source,
1561: ibsourceid => l_ib_source_id,
1562: LineProcessCaller => 'ORDER',

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 1679: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',

1675:
1676: t_ChildKeys(l_Counter) := l_tempKey;
1677:
1678: -- Create Process and Bulk Set Item Attribute
1679: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',
1680: itemkey => t_ChildKeys(l_Counter),
1681: processname => 'LINE_PROCESSING_PROCESS',
1682: parentitemtype => LaunchAllIndLinesForBundle.itemtype,
1683: parentitemkey => LaunchAllIndLinesForBundle.itemkey,

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 1730: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',

1726:
1727: t_ChildKeys(l_Counter) := l_tempKey;
1728:
1729: -- Create Process and Bulk Set Item Attribute
1730: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',
1731: itemkey => t_ChildKeys(l_Counter),
1732: processname => 'LINE_PROCESSING_PROCESS',
1733: parentitemtype => LaunchAllIndLinesForBundle.itemtype,
1734: parentitemkey => LaunchAllIndLinesForBundle.itemkey,

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 1866: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',

1862: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1863: l_tempKey := to_char(l_OrderID) || '-SVC-' || to_char(l_LineItemID) || l_tempKey;
1864:
1865: -- Create Process and Bulk Set Item Attribute
1866: XDPCORE.CreateNAddAttrNParentLabel(itemtype => 'XDPPROV',
1867: itemkey => l_tempKey,
1868: processname => 'SERVICE_PROCESS',
1869: parentitemtype => LaunchServiceProcess.itemtype,
1870: parentitemkey => LaunchServiceProcess.itemkey,

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 1978: XDPCORE.CheckNAddItemAttrText (itemtype => AddLineAttributes.itemtype,

1974: ErrCode := 0;
1975: ErrStr := NULL;
1976:
1977: if IsPackageFlag is not null then
1978: XDPCORE.CheckNAddItemAttrText (itemtype => AddLineAttributes.itemtype,
1979: itemkey => AddLineAttributes.itemkey,
1980: AttrName => 'IS_PACKAGE_FLAG',
1981: AttrValue => IsPackageFlag,
1982: ErrCode => ErrCode,

Line 1993: XDPCORE.CheckNAddItemAttrText (itemtype => AddLineAttributes.itemtype,

1989: end if;
1990: end if;
1991:
1992: if ibsource is not null then
1993: XDPCORE.CheckNAddItemAttrText (itemtype => AddLineAttributes.itemtype,
1994: itemkey => AddLineAttributes.itemkey,
1995: AttrName => 'IB_SOURCE',
1996: AttrValue => ibsource,
1997: ErrCode => ErrCode,

Line 2007: XDPCORE.CheckNAddItemAttrNumber (itemtype => AddLineAttributes.itemtype,

2003: return;
2004: end if;
2005: end if;
2006: if ibsourceid is not null then
2007: XDPCORE.CheckNAddItemAttrNumber (itemtype => AddLineAttributes.itemtype,
2008: itemkey => AddLineAttributes.itemkey,
2009: AttrName => 'IB_SOURCE_ID',
2010: AttrValue => ibsourceid,
2011: ErrCode => ErrCode,

Line 2022: XDPCORE.CheckNAddItemAttrText (itemtype => AddLineAttributes.itemtype,

2018: end if;
2019: end if;
2020:
2021: if LineProcessCaller is not null then
2022: XDPCORE.CheckNAddItemAttrText (itemtype => AddLineAttributes.itemtype,
2023: itemkey => AddLineAttributes.itemkey,
2024: AttrName => 'LINE_PROCESSING_CALLER',
2025: AttrValue => LineProcessCaller,
2026: ErrCode => ErrCode,

Line 2038: XDPCORE.CheckNAddItemAttrNumber (itemtype => AddLineAttributes.itemtype,

2034: end if;
2035:
2036:
2037: if CurrentLineSequence is not null then
2038: XDPCORE.CheckNAddItemAttrNumber (itemtype => AddLineAttributes.itemtype,
2039: itemkey => AddLineAttributes.itemkey,
2040: AttrName => 'CURRENT_LINE_SEQUENCE',
2041: AttrValue => CurrentLineSequence,
2042: ErrCode => ErrCode,

Line 2106: XDPCORE.CheckNAddItemAttrNumber (itemtype => InitializeDepLineProcess.itemtype,

2102: x_Progress VARCHAR2(2000);
2103:
2104: begin
2105:
2106: XDPCORE.CheckNAddItemAttrNumber (itemtype => InitializeDepLineProcess.itemtype,
2107: itemkey => InitializeDepLineProcess.itemkey,
2108: AttrName => 'CURRENT_LINE_SEQUENCE',
2109: AttrValue => 0,
2110: ErrCode => ErrCode,

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;