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_BUNDLE dependencies on XDPCORE

Line 1: PACKAGE BODY XDPCORE_BUNDLE AS

1: PACKAGE BODY XDPCORE_BUNDLE AS
2: /* $Header: XDPCORBB.pls 120.1 2005/06/15 22:11:52 appldev $ */
3:
4: /****
5: All Private Procedures for the Package

Line 79: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_BUNDLE_PROCESSES', itemtype, itemkey, to_char(actid), funcmode);

75:
76:
77: EXCEPTION
78: WHEN OTHERS THEN
79: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_BUNDLE_PROCESSES', itemtype, itemkey, to_char(actid), funcmode);
80: raise;
81: END LAUNCH_BUNDLE_PROCESSES;
82:
83:

Line 114: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_BUNDLE_PROCESS_SEQ', itemtype, itemkey, to_char(actid), funcmode);

110:
111:
112: EXCEPTION
113: WHEN OTHERS THEN
114: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_BUNDLE_PROCESS_SEQ', itemtype, itemkey, to_char(actid), funcmode);
115: raise;
116: END LAUNCH_BUNDLE_PROCESS_SEQ;
117:
118:

Line 153: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_LINE_FOR_BUNDLE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

149:
150:
151: EXCEPTION
152: WHEN OTHERS THEN
153: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_LINE_FOR_BUNDLE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
154: raise;
155: END LAUNCH_LINE_FOR_BUNDLE_PROCESS;
156:
157:

Line 187: wf_core.context('XDPCORE_BUNDLE', 'ARE_ALL_BUNDLES_DONE', itemtype, itemkey, to_char(actid), funcmode);

183: END IF;
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: wf_core.context('XDPCORE_BUNDLE', 'ARE_ALL_BUNDLES_DONE', itemtype, itemkey, to_char(actid), funcmode);
188: raise;
189: END ARE_ALL_BUNDLES_DONE;
190:
191:

Line 212: x_Progress := 'XDPCORE_BUNDLE.UPDATE_BUNDLE_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);

208: COMMIT;
209:
210: EXCEPTION
211: WHEN others THEN
212: x_Progress := 'XDPCORE_BUNDLE.UPDATE_BUNDLE_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);
213: wf_core.context('XDPCORE_BUNDLE', 'UPDATE_BUNDLE_STATUS', p_itemtype, p_itemkey, null, x_Progress);
214: rollback;
215: raise;
216: END UPDATE_BUNDLE_STATUS ;

Line 213: wf_core.context('XDPCORE_BUNDLE', 'UPDATE_BUNDLE_STATUS', p_itemtype, p_itemkey, null, x_Progress);

209:
210: EXCEPTION
211: WHEN others THEN
212: x_Progress := 'XDPCORE_BUNDLE.UPDATE_BUNDLE_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);
213: wf_core.context('XDPCORE_BUNDLE', 'UPDATE_BUNDLE_STATUS', p_itemtype, p_itemkey, null, x_Progress);
214: rollback;
215: raise;
216: END UPDATE_BUNDLE_STATUS ;
217:

Line 248: wf_core.context('XDPCORE_BUNDLE', 'INITIALIZE_BUNDLE', itemtype, itemkey, to_char(actid), funcmode);

244:
245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: wf_core.context('XDPCORE_BUNDLE', 'INITIALIZE_BUNDLE', itemtype, itemkey, to_char(actid), funcmode);
249: raise;
250: END INITIALIZE_BUNDLE;
251:
252: Procedure RESOLVE_IND_DEP_BUNDLES (itemtype in varchar2,

Line 277: wf_core.context('XDPCORE_BUNDLE', 'RESOLVE_IND_DEP_BUNDLES', itemtype, itemkey, to_char(actid), funcmode);

273:
274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: wf_core.context('XDPCORE_BUNDLE', 'RESOLVE_IND_DEP_BUNDLES', itemtype, itemkey, to_char(actid), funcmode);
278: raise;
279: END RESOLVE_IND_DEP_BUNDLES;
280:
281: Procedure LAUNCH_ALL_IND_BUNDLES (itemtype in varchar2,

Line 304: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_ALL_IND_BUNDLES', itemtype, itemkey, to_char(actid), funcmode);

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

Line 333: wf_core.context('XDPCORE_BUNDLE', 'INITIALIZE_DEP_BUNDLE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

329: END IF;
330:
331: EXCEPTION
332: WHEN OTHERS THEN
333: wf_core.context('XDPCORE_BUNDLE', 'INITIALIZE_DEP_BUNDLE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
334: raise;
335: END INITIALIZE_DEP_BUNDLE_PROCESS;
336:
337:

Line 362: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_BUNDLE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

358: END IF;
359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: wf_core.context('XDPCORE_BUNDLE', 'LAUNCH_BUNDLE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
363: raise;
364: END LAUNCH_BUNDLE_PROCESS;
365:
366:

Line 390: wf_core.context('XDPCORE_BUNDLE', 'RESOLVE_IND_DEP_LINES_FOR_BUN', itemtype, itemkey, to_char(actid), funcmode);

386: END IF;
387:
388: EXCEPTION
389: WHEN OTHERS THEN
390: wf_core.context('XDPCORE_BUNDLE', 'RESOLVE_IND_DEP_LINES_FOR_BUN', itemtype, itemkey, to_char(actid), funcmode);
391: raise;
392: END RESOLVE_IND_DEP_LINES_FOR_BUN;
393:
394:

Line 503: wf_core.context('XDPCORE_BUNDLE', 'AreAllBundlesDone', itemtype, itemkey, null, x_Progress);

499: if c_BundleSeq%ISOPEN then
500: close c_BundleSeq;
501: end if;
502:
503: wf_core.context('XDPCORE_BUNDLE', 'AreAllBundlesDone', itemtype, itemkey, null, x_Progress);
504: raise;
505:
506: when others then
507: if c_BundleSeq%ISOPEN then

Line 511: x_Progress := 'XDPCORE_BUNDLE.AreAllBundlesDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);

507: if c_BundleSeq%ISOPEN then
508: close c_BundleSeq;
509: end if;
510:
511: x_Progress := 'XDPCORE_BUNDLE.AreAllBundlesDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);
512: wf_core.context('XDPCORE_BUNDLE', 'AreAllBundlesDone', itemtype, itemkey, null, x_Progress);
513: raise;
514: end AreAllBundlesDone;
515:

Line 512: wf_core.context('XDPCORE_BUNDLE', 'AreAllBundlesDone', itemtype, itemkey, null, x_Progress);

508: close c_BundleSeq;
509: end if;
510:
511: x_Progress := 'XDPCORE_BUNDLE.AreAllBundlesDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);
512: wf_core.context('XDPCORE_BUNDLE', 'AreAllBundlesDone', itemtype, itemkey, null, x_Progress);
513: raise;
514: end AreAllBundlesDone;
515:
516:

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

593: itemkey => t_ChildKeys(l_Counter),
594: aname => 'ORDER_ID',
595: avalue => l_OrderID);
596:
597: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
598: itemkey => t_ChildKeys(l_Counter),
599: AttrName => 'BUNDLE_ID',
600: AttrValue => l_BundleID,
601: ErrCode => ErrCode,

Line 605: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

601: ErrCode => ErrCode,
602: ErrStr => ErrStr);
603:
604: if ErrCode <> 0 then
605: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
606: raise e_AddAttributeException;
607: end if;
608:
609:

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

606: raise e_AddAttributeException;
607: end if;
608:
609:
610: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
611: itemkey => t_ChildKeys(l_Counter),
612: AttrName => 'INDEPENDENT_BUNDLE_FLAG',
613: AttrValue => 'TRUE',
614: ErrCode => ErrCode,

Line 618: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute INDEPENDENT_BUNDLE_FLAG. Error: ' || substr(ErrStr,1,1500);

614: ErrCode => ErrCode,
615: ErrStr => ErrStr);
616:
617: if ErrCode <> 0 then
618: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute INDEPENDENT_BUNDLE_FLAG. Error: ' || substr(ErrStr,1,1500);
619: raise e_AddAttributeException;
620: end if;
621:
622: END LOOP;

Line 641: x_Progress := 'XDPCORE_BUNDLE.LaunchBundleProcesses. No Bundles Detected for OrderID: ' || l_OrderID;

637:
638: if c_GetDepBundle%NOTFOUND and l_Counter = 0 then
639: /* Some thing wrong */
640: close c_GetDepBundle;
641: x_Progress := 'XDPCORE_BUNDLE.LaunchBundleProcesses. No Bundles Detected for OrderID: ' || l_OrderID;
642: RAISE e_InvalidConfigException;
643: elsif c_GetDepBundle%FOUND then
644: l_Counter := l_Counter + 1;
645:

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

664: itemkey => t_ChildKeys(l_Counter),
665: aname => 'ORDER_ID',
666: avalue => l_OrderID);
667:
668: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
669: itemkey => t_ChildKeys(l_Counter),
670: AttrName => 'BUNDLE_ID',
671: AttrValue => l_BundleID,
672: ErrCode => ErrCode,

Line 676: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

672: ErrCode => ErrCode,
673: ErrStr => ErrStr);
674:
675: if ErrCode <> 0 then
676: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
677: raise e_AddAttributeException;
678: end if;
679:
680: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

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

676: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
677: raise e_AddAttributeException;
678: end if;
679:
680: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
681: itemkey => t_ChildKeys(l_Counter),
682: AttrName => 'INDEPENDENT_BUNDLE_FLAG',
683: AttrValue => 'FALSE',
684: ErrCode => ErrCode,

Line 688: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute INDEPENDENT_BUNDLE_FLAG. Error: ' || substr(ErrStr,1,1500);

684: ErrCode => ErrCode,
685: ErrStr => ErrStr);
686:
687: if ErrCode <> 0 then
688: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute INDEPENDENT_BUNDLE_FLAG. Error: ' || substr(ErrStr,1,1500);
689: raise e_AddAttributeException;
690: end if;
691:
692: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

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

688: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute INDEPENDENT_BUNDLE_FLAG. Error: ' || substr(ErrStr,1,1500);
689: raise e_AddAttributeException;
690: end if;
691:
692: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
693: itemkey => t_ChildKeys(l_Counter),
694: AttrName => 'CURRENT_BUNDLE_SEQUENCE',
695: AttrValue => 0,
696: ErrCode => ErrCode,

Line 700: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

696: ErrCode => ErrCode,
697: ErrStr => ErrStr);
698:
699: if ErrCode <> 0 then
700: x_progress := 'In XDPCORE_WI.LaunchBundleProcesses. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
701: raise e_AddAttributeException;
702: end if;
703:
704:

Line 726: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcesses', itemtype, itemkey, null, x_Progress);

722: if c_GetIndBundle%ISOPEN then
723: close c_GetIndBundle;
724: end if;
725:
726: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcesses', itemtype, itemkey, null, x_Progress);
727: raise;
728:
729: when e_InvalidConfigException then
730: if c_GetDepBundle%ISOPEN then

Line 738: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcesses', itemtype, itemkey, null, x_Progress);

734: if c_GetIndBundle%ISOPEN then
735: close c_GetIndBundle;
736: end if;
737:
738: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcesses', itemtype, itemkey, null, x_Progress);
739: raise;
740:
741: when others then
742: if c_GetDepBundle%ISOPEN then

Line 750: x_Progress := 'XDPCORE_BUNDLE.LaunchBundleProcesses. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);

746: if c_GetIndBundle%ISOPEN then
747: close c_GetIndBundle;
748: end if;
749:
750: x_Progress := 'XDPCORE_BUNDLE.LaunchBundleProcesses. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);
751: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcesses', itemtype, itemkey, null, x_Progress);
752: raise;
753: end LaunchBundleProcesses;
754:

Line 751: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcesses', itemtype, itemkey, null, x_Progress);

747: close c_GetIndBundle;
748: end if;
749:
750: x_Progress := 'XDPCORE_BUNDLE.LaunchBundleProcesses. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);
751: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcesses', itemtype, itemkey, null, x_Progress);
752: raise;
753: end LaunchBundleProcesses;
754:
755:

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

884: itemkey => t_ChildKeys(l_Counter),
885: aname => 'LINE_ITEM_ID',
886: avalue => l_LineItemID);
887:
888: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
889: itemkey => t_ChildKeys(l_Counter),
890: AttrName => 'IS_PACKAGE_FLAG',
891: AttrValue => l_PackageFlag,
892: ErrCode => ErrCode,

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

892: ErrCode => ErrCode,
893: ErrStr => ErrStr);
894:
895: if ErrCode <> 0 then
896: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
897: raise e_AddAttributeException;
898: end if;
899:
900:

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

897: raise e_AddAttributeException;
898: end if;
899:
900:
901: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
902: itemkey => t_ChildKeys(l_Counter),
903: AttrName => 'LINE_PROCESSING_CALLER',
904: AttrValue => 'BUNDLE',
905: ErrCode => ErrCode,

Line 909: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

905: ErrCode => ErrCode,
906: ErrStr => ErrStr);
907:
908: if ErrCode <> 0 then
909: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
910: raise e_AddAttributeException;
911: end if;
912:
913:

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

910: raise e_AddAttributeException;
911: end if;
912:
913:
914: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
915: itemkey => t_ChildKeys(l_Counter),
916: AttrName => 'BUNDLE_ID',
917: AttrValue => l_BundleID,
918: ErrCode => ErrCode,

Line 922: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

918: ErrCode => ErrCode,
919: ErrStr => ErrStr);
920:
921: if ErrCode <> 0 then
922: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
923: raise e_AddAttributeException;
924: end if;
925:
926: END LOOP;

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

963: itemkey => t_ChildKeys(l_Counter),
964: aname => 'LINE_ITEM_ID',
965: avalue => l_LineItemID);
966:
967: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
968: itemkey => t_ChildKeys(l_Counter),
969: AttrName => 'CURRENT_LINE_SEQUENCE',
970: AttrValue => 0,
971: ErrCode => ErrCode,

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

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

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

975: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
976: raise e_AddAttributeException;
977: end if;
978:
979: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
980: itemkey => t_ChildKeys(l_Counter),
981: AttrName => 'IS_PACKAGE_FLAG',
982: AttrValue => l_PackageFlag,
983: ErrCode => ErrCode,

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

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

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

988: raise e_AddAttributeException;
989: end if;
990:
991:
992: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
993: itemkey => t_ChildKeys(l_Counter),
994: AttrName => 'LINE_PROCESSING_CALLER',
995: AttrValue => 'BUNDLE',
996: ErrCode => ErrCode,

Line 1000: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

996: ErrCode => ErrCode,
997: ErrStr => ErrStr);
998:
999: if ErrCode <> 0 then
1000: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1001: raise e_AddAttributeException;
1002: end if;
1003:
1004: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

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

1000: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1001: raise e_AddAttributeException;
1002: end if;
1003:
1004: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
1005: itemkey => t_ChildKeys(l_Counter),
1006: AttrName => 'BUNDLE_ID',
1007: AttrValue => l_BundleID,
1008: ErrCode => ErrCode,

Line 1012: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

1008: ErrCode => ErrCode,
1009: ErrStr => ErrStr);
1010:
1011: if ErrCode <> 0 then
1012: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1013: raise e_AddAttributeException;
1014: end if;
1015:
1016: end if;

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

1061: itemkey => t_ChildKeys(l_Counter),
1062: aname => 'LINE_ITEM_ID',
1063: avalue => l_LineItemID);
1064:
1065: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1066: itemkey => t_ChildKeys(l_Counter),
1067: AttrName => 'IS_PACKAGE_FLAG',
1068: AttrValue => l_PackageFlag,
1069: ErrCode => ErrCode,

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

1069: ErrCode => ErrCode,
1070: ErrStr => ErrStr);
1071:
1072: if ErrCode <> 0 then
1073: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1074: raise e_AddAttributeException;
1075: end if;
1076:
1077: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

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

1073: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1074: raise e_AddAttributeException;
1075: end if;
1076:
1077: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
1078: itemkey => t_ChildKeys(l_Counter),
1079: AttrName => 'BUNDLE_ID',
1080: AttrValue => l_BundleID,
1081: ErrCode => ErrCode,

Line 1085: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

1081: ErrCode => ErrCode,
1082: ErrStr => ErrStr);
1083:
1084: if ErrCode <> 0 then
1085: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1086: raise e_AddAttributeException;
1087: end if;
1088:
1089: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

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

1085: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1086: raise e_AddAttributeException;
1087: end if;
1088:
1089: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1090: itemkey => t_ChildKeys(l_Counter),
1091: AttrName => 'LINE_PROCESSING_CALLER',
1092: AttrValue => 'BUNDLE',
1093: ErrCode => ErrCode,

Line 1097: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

1093: ErrCode => ErrCode,
1094: ErrStr => ErrStr);
1095:
1096: if ErrCode <> 0 then
1097: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1098: raise e_AddAttributeException;
1099: end if;
1100:
1101:

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

1140: itemkey => t_ChildKeys(l_Counter),
1141: aname => 'LINE_ITEM_ID',
1142: avalue => l_LineItemID);
1143:
1144: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
1145: itemkey => t_ChildKeys(l_Counter),
1146: AttrName => 'CURRENT_LINE_SEQUENCE',
1147: AttrValue => 0,
1148: ErrCode => ErrCode,

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

1148: ErrCode => ErrCode,
1149: ErrStr => ErrStr);
1150:
1151: if ErrCode <> 0 then
1152: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1153: raise e_AddAttributeException;
1154: end if;
1155:
1156:

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

1153: raise e_AddAttributeException;
1154: end if;
1155:
1156:
1157: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1158: itemkey => t_ChildKeys(l_Counter),
1159: AttrName => 'IS_PACKAGE_FLAG',
1160: AttrValue => l_PackageFlag,
1161: ErrCode => ErrCode,

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

1161: ErrCode => ErrCode,
1162: ErrStr => ErrStr);
1163:
1164: if ErrCode <> 0 then
1165: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1166: raise e_AddAttributeException;
1167: end if;
1168:
1169: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

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

1165: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1166: raise e_AddAttributeException;
1167: end if;
1168:
1169: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
1170: itemkey => t_ChildKeys(l_Counter),
1171: AttrName => 'BUNDLE_ID',
1172: AttrValue => l_BundleID,
1173: ErrCode => ErrCode,

Line 1177: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

1173: ErrCode => ErrCode,
1174: ErrStr => ErrStr);
1175:
1176: if ErrCode <> 0 then
1177: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1178: raise e_AddAttributeException;
1179: end if;
1180:
1181: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

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

1177: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1178: raise e_AddAttributeException;
1179: end if;
1180:
1181: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1182: itemkey => t_ChildKeys(l_Counter),
1183: AttrName => 'LINE_PROCESSING_CALLER',
1184: AttrValue => 'BUNDLE',
1185: ErrCode => ErrCode,

Line 1189: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

1185: ErrCode => ErrCode,
1186: ErrStr => ErrStr);
1187:
1188: if ErrCode <> 0 then
1189: x_progress := 'In XDPCORE_WI.LaunchLineForBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1190: raise e_AddAttributeException;
1191: end if;
1192:
1193:

Line 1221: wf_core.context('XDPCORE_BUNDLE', 'LaunchLineForBundleProcess', itemtype, itemkey, null, x_Progress);

1217: END LOOP;
1218:
1219: exception
1220: when others then
1221: wf_core.context('XDPCORE_BUNDLE', 'LaunchLineForBundleProcess', itemtype, itemkey, null, x_Progress);
1222: raise;
1223: end LaunchLineForBundleProcess;
1224:
1225:

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

1335: itemkey => t_ChildKeys(l_Counter),
1336: aname => 'LINE_ITEM_ID',
1337: avalue => l_LineItemID);
1338:
1339: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1340: itemkey => t_ChildKeys(l_Counter),
1341: AttrName => 'IS_PACKAGE_FLAG',
1342: AttrValue => l_PackageFlag,
1343: ErrCode => ErrCode,

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

1343: ErrCode => ErrCode,
1344: ErrStr => ErrStr);
1345:
1346: if ErrCode <> 0 then
1347: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1348: raise e_AddAttributeException;
1349: end if;
1350:
1351: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

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

1347: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1348: raise e_AddAttributeException;
1349: end if;
1350:
1351: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
1352: itemkey => t_ChildKeys(l_Counter),
1353: AttrName => 'BUNDLE_ID',
1354: AttrValue => l_BundleID,
1355: ErrCode => ErrCode,

Line 1359: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

1355: ErrCode => ErrCode,
1356: ErrStr => ErrStr);
1357:
1358: if ErrCode <> 0 then
1359: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1360: raise e_AddAttributeException;
1361: end if;
1362:
1363: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

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

1359: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1360: raise e_AddAttributeException;
1361: end if;
1362:
1363: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1364: itemkey => t_ChildKeys(l_Counter),
1365: AttrName => 'LINE_PROCESSING_CALLER',
1366: AttrValue => 'BUNDLE',
1367: ErrCode => ErrCode,

Line 1371: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

1367: ErrCode => ErrCode,
1368: ErrStr => ErrStr);
1369:
1370: if ErrCode <> 0 then
1371: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1372: raise e_AddAttributeException;
1373: end if;
1374:
1375:

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

1415: itemkey => t_ChildKeys(l_Counter),
1416: aname => 'LINE_ITEM_ID',
1417: avalue => l_LineItemID);
1418:
1419: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
1420: itemkey => t_ChildKeys(l_Counter),
1421: AttrName => 'CURRENT_LINE_SEQUENCE',
1422: AttrValue => 0,
1423: ErrCode => ErrCode,

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

1423: ErrCode => ErrCode,
1424: ErrStr => ErrStr);
1425:
1426: if ErrCode <> 0 then
1427: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1428: raise e_AddAttributeException;
1429: end if;
1430:
1431: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

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

1427: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute CURRENT_LINE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1428: raise e_AddAttributeException;
1429: end if;
1430:
1431: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1432: itemkey => t_ChildKeys(l_Counter),
1433: AttrName => 'IS_PACKAGE_FLAG',
1434: AttrValue => l_PackageFlag,
1435: ErrCode => ErrCode,

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

1435: ErrCode => ErrCode,
1436: ErrStr => ErrStr);
1437:
1438: if ErrCode <> 0 then
1439: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1440: raise e_AddAttributeException;
1441: end if;
1442:
1443: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),

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

1439: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute IS_PACKAGE_FLAG. Error: ' || substr(ErrStr,1,1500);
1440: raise e_AddAttributeException;
1441: end if;
1442:
1443: XDPCORE.CheckNAddItemAttrNumber (itemtype => t_ChildTypes(l_Counter),
1444: itemkey => t_ChildKeys(l_Counter),
1445: AttrName => 'BUNDLE_ID',
1446: AttrValue => l_BundleID,
1447: ErrCode => ErrCode,

Line 1451: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

1447: ErrCode => ErrCode,
1448: ErrStr => ErrStr);
1449:
1450: if ErrCode <> 0 then
1451: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1452: raise e_AddAttributeException;
1453: end if;
1454:
1455: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),

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

1451: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1452: raise e_AddAttributeException;
1453: end if;
1454:
1455: XDPCORE.CheckNAddItemAttrText (itemtype => t_ChildTypes(l_Counter),
1456: itemkey => t_ChildKeys(l_Counter),
1457: AttrName => 'LINE_PROCESSING_CALLER',
1458: AttrValue => 'BUNDLE',
1459: ErrCode => ErrCode,

Line 1463: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

1459: ErrCode => ErrCode,
1460: ErrStr => ErrStr);
1461:
1462: if ErrCode <> 0 then
1463: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1464: raise e_AddAttributeException;
1465: end if;
1466:
1467:

Line 1478: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchBundleProcessSeq.itemtype,

1474: if l_Counter = 0 and l_CurrentBundleSeq = 0 then
1475: RAISE e_NoBundlesFoundException;
1476: else
1477:
1478: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchBundleProcessSeq.itemtype,
1479: itemkey => LaunchBundleProcessSeq.itemkey,
1480: AttrName => 'CURRENT_BUNDLE_SEQUENCE',
1481: AttrValue => l_CurrentBundleSeq,
1482: ErrCode => ErrCode,

Line 1486: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

1482: ErrCode => ErrCode,
1483: ErrStr => ErrStr);
1484:
1485: if ErrCode <> 0 then
1486: x_progress := 'In XDPCORE_WI.LaunchBundleProcessSeq. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1487: raise e_AddAttributeException;
1488: end if;
1489:
1490:

Line 1500: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcessSeq', itemtype, itemkey, null, x_Progress);

1496: end if;
1497:
1498: exception
1499: when others then
1500: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcessSeq', itemtype, itemkey, null, x_Progress);
1501: raise;
1502: end LaunchBundleProcessSeq;
1503:
1504:

Line 1535: XDPCORE.CheckNAddItemAttrText (itemtype => 'XDPPROV',

1531: p_status_code => 'IN PROGRESS',
1532: p_itemtype => InitializeBundle.itemtype,
1533: p_itemkey => InitializeBundle.itemkey) ;
1534: -- end if;
1535: XDPCORE.CheckNAddItemAttrText (itemtype => 'XDPPROV',
1536: itemkey => InitializeBundle.itemkey,
1537: AttrName => 'LINE_PROCESSING_CALLER',
1538: AttrValue => 'BUNDLE',
1539: ErrCode => ErrCode,

Line 1542: x_progress := 'In XDPCORE_BUNDLE.InitializeBundle. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

1538: AttrValue => 'BUNDLE',
1539: ErrCode => ErrCode,
1540: ErrStr => ErrStr);
1541: if ErrCode <> 0 then
1542: x_progress := 'In XDPCORE_BUNDLE.InitializeBundle. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1543: raise e_AddAttributeException;
1544: end if;
1545:
1546:

Line 1549: wf_core.context('XDPCORE_BUNDLE', 'InitializeBundle', itemtype, itemkey, null, x_Progress);

1545:
1546:
1547: exception
1548: when others then
1549: wf_core.context('XDPCORE_BUNDLE', 'InitializeBundle', itemtype, itemkey, null, x_Progress);
1550: raise;
1551: end InitializeBundle;
1552:
1553: Function ResolveIndDepBundles (itemtype in varchar2,

Line 1605: wf_core.context('XDPCORE_BUNDLE', 'ResolveIndDepBundles', itemtype, itemkey );

1601: end if;
1602:
1603: EXCEPTION
1604: WHEN OTHERS THEN
1605: wf_core.context('XDPCORE_BUNDLE', 'ResolveIndDepBundles', itemtype, itemkey );
1606: RAISE;
1607: END ResolveIndDepBundles;
1608:
1609:

Line 1676: XDPCORE.CheckNAddItemAttrNumber (itemtype =>'XDPPROV',

1672: itemkey => t_ChildKeys(l_Counter),
1673: aname => 'ORDER_ID',
1674: avalue => l_OrderID);
1675:
1676: XDPCORE.CheckNAddItemAttrNumber (itemtype =>'XDPPROV',
1677: itemkey => t_ChildKeys(l_Counter),
1678: AttrName => 'BUNDLE_ID',
1679: AttrValue => l_BundleID,
1680: ErrCode => ErrCode,

Line 1684: x_progress := 'In XDPCORE_BUNDLE.LaunchAllIndBundles. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

1680: ErrCode => ErrCode,
1681: ErrStr => ErrStr);
1682:
1683: if ErrCode <> 0 then
1684: x_progress := 'In XDPCORE_BUNDLE.LaunchAllIndBundles. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1685: raise e_AddAttributeException;
1686: end if;
1687: END LOOP;
1688:

Line 1698: wf_core.context('XDPCORE_BUNDLE', 'LaunchAllIndBundles', itemtype, itemkey, null, x_progress );

1694: return l_result;
1695:
1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: wf_core.context('XDPCORE_BUNDLE', 'LaunchAllIndBundles', itemtype, itemkey, null, x_progress );
1699: RAISE;
1700: END LaunchAllIndBundles;
1701:
1702: Procedure InitializeDepBundleProcess(itemtype in varchar2,

Line 1713: XDPCORE.CheckNAddItemAttrNumber (itemtype => 'XDPPROV',

1709: ErrCode number;
1710: ErrStr varchar2(1996);
1711:
1712: BEGIN
1713: XDPCORE.CheckNAddItemAttrNumber (itemtype => 'XDPPROV',
1714: itemkey => InitializeDepBundleProcess.itemkey,
1715: AttrName => 'CURRENT_BUNDLE_SEQUENCE',
1716: AttrValue => 0,
1717: ErrCode => ErrCode,

Line 1721: x_progress := 'In XDPCORE_BUNDLE.CheckNAddItemAttrNumber. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

1717: ErrCode => ErrCode,
1718: ErrStr => ErrStr);
1719:
1720: if ErrCode <> 0 then
1721: x_progress := 'In XDPCORE_BUNDLE.CheckNAddItemAttrNumber. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1722: raise e_AddAttributeException;
1723: end if;
1724:
1725:

Line 1728: wf_core.context('XDPCORE_BUNDLE', 'InitializeDepBundleProcess', itemtype, itemkey, null, x_progress );

1724:
1725:
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: wf_core.context('XDPCORE_BUNDLE', 'InitializeDepBundleProcess', itemtype, itemkey, null, x_progress );
1729: RAISE;
1730: END InitializeDepBundleProcess;
1731:
1732: Procedure LaunchBundleProcess(itemtype in varchar2,

Line 1806: XDPCORE.CheckNAddItemAttrNumber (itemtype =>'XDPPROV',

1802: itemkey => l_tempKey,
1803: aname => 'MASTER_TO_CONTINUE',
1804: avalue => 'WAITFORFLOW-BUNDLE-DEP');
1805:
1806: XDPCORE.CheckNAddItemAttrNumber (itemtype =>'XDPPROV',
1807: itemkey => l_tempKey,
1808: AttrName => 'BUNDLE_ID',
1809: AttrValue => l_BundleID,
1810: ErrCode => ErrCode,

Line 1814: x_progress := 'In XDPCORE_BUNDLE.LaunchBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);

1810: ErrCode => ErrCode,
1811: ErrStr => ErrStr);
1812:
1813: if ErrCode <> 0 then
1814: x_progress := 'In XDPCORE_BUNDLE.LaunchBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1815: raise e_AddAttributeException;
1816: end if;
1817:
1818: XDPCORE.CheckNAddItemAttrText (itemtype => 'XDPPROV',

Line 1818: XDPCORE.CheckNAddItemAttrText (itemtype => 'XDPPROV',

1814: x_progress := 'In XDPCORE_BUNDLE.LaunchBundleProcess. Error when adding Item Attribute BUNDLE_ID. Error: ' || substr(ErrStr,1,1500);
1815: raise e_AddAttributeException;
1816: end if;
1817:
1818: XDPCORE.CheckNAddItemAttrText (itemtype => 'XDPPROV',
1819: itemkey => l_tempKey,
1820: AttrName => 'LINE_PROCESSING_CALLER',
1821: AttrValue => 'BUNDLE',
1822: ErrCode => ErrCode,

Line 1827: x_progress := 'In XDPCORE_BUNDLE.LaunchBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);

1823: ErrStr => ErrStr);
1824:
1825:
1826: if ErrCode <> 0 then
1827: x_progress := 'In XDPCORE_BUNDLE.LaunchBundleProcess. Error when adding Item Attribute LINE_PROCESSING_CALLER. Error: ' || substr(ErrStr,1,1500);
1828: raise e_AddAttributeException;
1829: end if;
1830:
1831: --Start the process...

Line 1836: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchBundleProcess.itemtype,

1832: wf_engine.StartProcess('XDPPROV', l_tempKey );
1833:
1834: END LOOP;
1835:
1836: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchBundleProcess.itemtype,
1837: itemkey => LaunchBundleProcess.itemkey,
1838: AttrName => 'CURRENT_BUNDLE_SEQUENCE',
1839: AttrValue => l_CurrentBundleSeq,
1840: ErrCode => ErrCode,

Line 1844: x_progress := 'In XDPCORE_BUNDLE.LaunchBundleProcess. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

1840: ErrCode => ErrCode,
1841: ErrStr => ErrStr);
1842:
1843: if ErrCode <> 0 then
1844: x_progress := 'In XDPCORE_BUNDLE.LaunchBundleProcess. Error when adding Item Attribute CURRENT_BUNDLE_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
1845: raise e_AddAttributeException;
1846: end if;
1847:
1848: EXCEPTION

Line 1850: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcess', itemtype, itemkey, null, x_progress );

1846: end if;
1847:
1848: EXCEPTION
1849: WHEN OTHERS THEN
1850: wf_core.context('XDPCORE_BUNDLE', 'LaunchBundleProcess', itemtype, itemkey, null, x_progress );
1851: RAISE;
1852: END LaunchBundleProcess;
1853:
1854: Function ResolveIndDepLinesForBun (itemtype in varchar2,

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

1949: exception
1950:
1951: when others then
1952:
1953: x_Progress := 'XDPCORE_BUNDLE.ResolveIndDepLinesForBun. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1954: wf_core.context('XDPCORE_BUNDLE', 'ResolveIndDepLinesForBun', itemtype, itemkey, null, x_Progress);
1955: raise;
1956: end ResolveIndDepLinesForBun;
1957:

Line 1954: wf_core.context('XDPCORE_BUNDLE', 'ResolveIndDepLinesForBun', itemtype, itemkey, null, x_Progress);

1950:
1951: when others then
1952:
1953: x_Progress := 'XDPCORE_BUNDLE.ResolveIndDepLinesForBun. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
1954: wf_core.context('XDPCORE_BUNDLE', 'ResolveIndDepLinesForBun', itemtype, itemkey, null, x_Progress);
1955: raise;
1956: end ResolveIndDepLinesForBun;
1957:
1958: End XDPCORE_BUNDLE;

Line 1958: End XDPCORE_BUNDLE;

1954: wf_core.context('XDPCORE_BUNDLE', 'ResolveIndDepLinesForBun', itemtype, itemkey, null, x_Progress);
1955: raise;
1956: end ResolveIndDepLinesForBun;
1957:
1958: End XDPCORE_BUNDLE;