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_WI dependencies on XDPCORE_WI

Line 1: PACKAGE BODY XDPCORE_WI AS

1: PACKAGE BODY XDPCORE_WI AS
2: /* $Header: XDPCORWB.pls 120.3 2005/07/10 23:47:32 appldev noship $ */
3:
4:
5: /****

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

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

Line 148: wf_core.context('XDPCORE_WI', 'CONTINUE_WORKITEM', itemtype, itemkey, to_char(actid), funcmode);

144:
145:
146: EXCEPTION
147: WHEN OTHERS THEN
148: wf_core.context('XDPCORE_WI', 'CONTINUE_WORKITEM', itemtype, itemkey, to_char(actid), funcmode);
149: raise;
150: END CONTINUE_WORKITEM;
151:
152:

Line 186: wf_core.context('XDPCORE_WI', 'ARE_ALL_WIS_DONE', itemtype, itemkey, to_char(actid), funcmode);

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

Line 215: wf_core.context('XDPCORE_WI', 'EVALUATE_WI_PARAMS', itemtype, itemkey, to_char(actid), funcmode);

211:
212:
213: EXCEPTION
214: WHEN OTHERS THEN
215: wf_core.context('XDPCORE_WI', 'EVALUATE_WI_PARAMS', itemtype, itemkey, to_char(actid), funcmode);
216: raise;
217: END EVALUATE_WI_PARAMS;
218:
219: Procedure EVALUATE_ALL_WIS_PARAMS (itemtype in varchar2,

Line 249: XDPCORE.context('XDPCORE_WI', 'EVALUATE_ALL_WIS_PARAMS', itemtype, itemkey );

245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF XDPCORE.is_business_error = 'Y' THEN
249: XDPCORE.context('XDPCORE_WI', 'EVALUATE_ALL_WIS_PARAMS', itemtype, itemkey );
250:
251: --Log the error at the top level call
252: XDPCORE_ERROR.LOG_SESSION_ERROR( 'BUSINESS' );
253: --Set the workitem instance id of which evaluation failed..

Line 265: wf_core.context('XDPCORE_WI', 'EVALUATE_ALL_WIS_PARAMS', itemtype, itemkey, to_char(actid), funcmode);

261:
262: resultout := 'COMPLETE:FAILURE';
263: return;
264: END IF;
265: wf_core.context('XDPCORE_WI', 'EVALUATE_ALL_WIS_PARAMS', itemtype, itemkey, to_char(actid), funcmode);
266: RAISE;
267: END EVALUATE_ALL_WIS_PARAMS;
268:
269:

Line 295: wf_core.context('XDPCORE_WI', 'LAUNCH_WORKITEM_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

291:
292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: wf_core.context('XDPCORE_WI', 'LAUNCH_WORKITEM_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
296: raise;
297: END LAUNCH_WORKITEM_PROCESS;
298:
299:

Line 325: wf_core.context('XDPCORE_WI', 'INITIALIZE_DEP_WI_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

321:
322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: wf_core.context('XDPCORE_WI', 'INITIALIZE_DEP_WI_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
326: raise;
327: END INITIALIZE_DEP_WI_PROCESS;
328:
329:

Line 356: wf_core.context('XDPCORE_WI', 'LAUNCH_WI_SEQ_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

352:
353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: wf_core.context('XDPCORE_WI', 'LAUNCH_WI_SEQ_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
357: raise;
358: END LAUNCH_WI_SEQ_PROCESS;
359:
360:

Line 387: xdpcore.context('XDPCORE_WI', 'LAUNCH_ALL_IND_WIS', itemtype, itemkey, to_char(actid), funcmode);

383:
384:
385: EXCEPTION
386: WHEN OTHERS THEN
387: xdpcore.context('XDPCORE_WI', 'LAUNCH_ALL_IND_WIS', itemtype, itemkey, to_char(actid), funcmode);
388: wf_core.context('XDPCORE_WI', 'LAUNCH_ALL_IND_WIS', itemtype, itemkey, to_char(actid), funcmode);
389: raise;
390:
391: END LAUNCH_ALL_IND_WIS;

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

384:
385: EXCEPTION
386: WHEN OTHERS THEN
387: xdpcore.context('XDPCORE_WI', 'LAUNCH_ALL_IND_WIS', itemtype, itemkey, to_char(actid), funcmode);
388: wf_core.context('XDPCORE_WI', 'LAUNCH_ALL_IND_WIS', itemtype, itemkey, to_char(actid), funcmode);
389: raise;
390:
391: END LAUNCH_ALL_IND_WIS;
392:

Line 417: wf_core.context('XDPCORE_WI', 'LAUNCH_WI_SERVICE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

413:
414:
415: EXCEPTION
416: WHEN OTHERS THEN
417: wf_core.context('XDPCORE_WI', 'LAUNCH_WI_SERVICE_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
418: raise;
419: END LAUNCH_WI_SERVICE_PROCESS;
420:
421:

Line 452: wf_core.context('XDPCORE_WI', 'INITIALIZE_WI_LIST', itemtype, itemkey, to_char(actid), funcmode);

448: END IF;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: wf_core.context('XDPCORE_WI', 'INITIALIZE_WI_LIST', itemtype, itemkey, to_char(actid), funcmode);
453: raise;
454: END INITIALIZE_WI_LIST;
455:
456:

Line 491: wf_core.context('XDPCORE_WI', 'ARE_ALL_WIS_DONE', itemtype, itemkey, to_char(actid), funcmode);

487:
488:
489: EXCEPTION
490: WHEN OTHERS THEN
491: wf_core.context('XDPCORE_WI', 'ARE_ALL_WIS_DONE', itemtype, itemkey, to_char(actid), funcmode);
492: raise;
493: END GET_ONSTART_WI_PARAMS;
494:
495:

Line 523: wf_core.context('XDPCORE_WI', 'RESOLVE_IND_DEP_WIS', itemtype, itemkey, to_char(actid), funcmode);

519:
520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: wf_core.context('XDPCORE_WI', 'RESOLVE_IND_DEP_WIS', itemtype, itemkey, to_char(actid), funcmode);
524: raise;
525: END RESOLVE_IND_DEP_WIS;
526:
527: Procedure OVERRIDE_WI_PARAM (itemtype in varchar2,

Line 557: wf_core.context('XDPCORE_WI', 'OVERRIDE_WI_PARAM', itemtype, itemkey, to_char(actid), funcmode);

553: END IF;
554:
555: EXCEPTION
556: WHEN OTHERS THEN
557: wf_core.context('XDPCORE_WI', 'OVERRIDE_WI_PARAM', itemtype, itemkey, to_char(actid), funcmode);
558: raise;
559: END OVERRIDE_WI_PARAM;
560:
561: /****

Line 640: x_Progress := 'XDPCORE_WI.GetWIParamOnStart. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

636: RETURN l_return_flag;
637:
638: exception
639: when others then
640: x_Progress := 'XDPCORE_WI.GetWIParamOnStart. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
641: wf_core.context('XDPCORE_WI', 'GetWIParamOnStart', itemtype, itemkey, null, x_Progress);
642: raise;
643: END evaluateWIParams;
644:

Line 641: wf_core.context('XDPCORE_WI', 'GetWIParamOnStart', itemtype, itemkey, null, x_Progress);

637:
638: exception
639: when others then
640: x_Progress := 'XDPCORE_WI.GetWIParamOnStart. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
641: wf_core.context('XDPCORE_WI', 'GetWIParamOnStart', itemtype, itemkey, null, x_Progress);
642: raise;
643: END evaluateWIParams;
644:
645:

Line 708: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'WI', l_WIInstanceID );

704: IF l_return_flag = 'FAILURE' THEN
705: --set the error workitem so that we can access at higer level..
706: g_WIInstance_ID_in_Error := l_WIInstanceID;
707: --Failed to execute set the context and return..
708: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'WI', l_WIInstanceID );
709: RETURN l_return_flag;
710: END IF;
711:
712: IF l_WIsFound = 0 THEN

Line 713: x_Progress := 'XDPCORE_WI.evaluateAllWIsParams. Found No workitems to be processed for Order: ' || l_OrderID || ' LineItemID: ' || l_LineItemID;

709: RETURN l_return_flag;
710: END IF;
711:
712: IF l_WIsFound = 0 THEN
713: x_Progress := 'XDPCORE_WI.evaluateAllWIsParams. Found No workitems to be processed for Order: ' || l_OrderID || ' LineItemID: ' || l_LineItemID;
714: RAISE e_NoWorkitemsFoundException;
715: END IF;
716: -- Evaluation for all WI paramers are successfull...
717: RETURN l_return_flag;

Line 722: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'LINE', l_LineItemID, x_Progress );

718:
719: EXCEPTION
720:
721: WHEN e_NoWorkitemsFoundException THEN
722: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'LINE', l_LineItemID, x_Progress );
723: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);
724: RAISE;
725:
726: WHEN others THEN

Line 723: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);

719: EXCEPTION
720:
721: WHEN e_NoWorkitemsFoundException THEN
722: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'LINE', l_LineItemID, x_Progress );
723: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);
724: RAISE;
725:
726: WHEN others THEN
727: x_Progress := 'XDPCORE_WI.evaluateAllWIsParams. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

Line 727: x_Progress := 'XDPCORE_WI.evaluateAllWIsParams. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

723: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);
724: RAISE;
725:
726: WHEN others THEN
727: x_Progress := 'XDPCORE_WI.evaluateAllWIsParams. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
728: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'LINE', l_LineItemID );
729: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);
730: raise;
731: END evaluateAllWIsParams;

Line 728: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'LINE', l_LineItemID );

724: RAISE;
725:
726: WHEN others THEN
727: x_Progress := 'XDPCORE_WI.evaluateAllWIsParams. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
728: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'LINE', l_LineItemID );
729: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);
730: raise;
731: END evaluateAllWIsParams;
732:

Line 729: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);

725:
726: WHEN others THEN
727: x_Progress := 'XDPCORE_WI.evaluateAllWIsParams. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
728: XDPCORE.context('XDPCORE_WI', 'evaluateAllWIsParams', 'LINE', l_LineItemID );
729: wf_core.context('XDPCORE_WI', 'evaluateAllWIsParams', itemtype, itemkey, null, x_Progress);
730: raise;
731: END evaluateAllWIsParams;
732:
733:

Line 795: wf_core.context('XDPCORE_WI', 'AreAllWIsDone', itemtype, itemkey, null, x_Progress);

791: if c_WIList%ISOPEN then
792: Close c_WIList;
793: end if;
794:
795: wf_core.context('XDPCORE_WI', 'AreAllWIsDone', itemtype, itemkey, null, x_Progress);
796: raise;
797: when others then
798: if c_WIList%ISOPEN then
799: Close c_WIList;

Line 802: x_Progress := 'XDPCORE_WI.AreAllWIsDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

798: if c_WIList%ISOPEN then
799: Close c_WIList;
800: end if;
801:
802: x_Progress := 'XDPCORE_WI.AreAllWIsDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
803: wf_core.context('XDPCORE_WI', 'AreAllWIsDone', itemtype, itemkey, null, x_Progress);
804: raise;
805: end AreAllWIsDone;
806:

Line 803: wf_core.context('XDPCORE_WI', 'AreAllWIsDone', itemtype, itemkey, null, x_Progress);

799: Close c_WIList;
800: end if;
801:
802: x_Progress := 'XDPCORE_WI.AreAllWIsDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
803: wf_core.context('XDPCORE_WI', 'AreAllWIsDone', itemtype, itemkey, null, x_Progress);
804: raise;
805: end AreAllWIsDone;
806:
807:

Line 883: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Could Not Find User Defined Workflow Procedure for Workitem: '|| l_WorkitemID || ' Order: ' || l_OrderID;

879: if l_wiwf = 'WORKFLOW_PROC' then
880: /* The Workitem is a WOrkflow Process */
881:
882: if l_UserWIProc is null then
883: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Could Not Find User Defined Workflow Procedure for Workitem: '|| l_WorkitemID || ' Order: ' || l_OrderID;
884: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID|| ' LineItemID: ' || l_LineItemID || ' Check Workitem Configuration';
885: RAISE e_NullWIWfProcException;
886: end if;
887:

Line 904: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Executing The user-defined Workflow Procedure: '|| l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;

900: P_RETURN_CODE => l_ErrCode,
901: P_ERROR_DESCRIPTION => l_ErrDescription);
902:
903: if l_ErrCode <> 0 then
904: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Executing The user-defined Workflow Procedure: '|| l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;
905: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '|| SUBSTR(l_ErrDescription, 1, 1500);
906: RAISE e_CallWIWfProcException;
907: end if;
908:

Line 928: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding LINE_ITEM_ID attri bute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;

924: ErrCode => l_ErrCode,
925: ErrStr => l_ErrDescription);
926:
927: if l_ErrCode <> 0 then
928: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding LINE_ITEM_ID attri bute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;
929: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '|| SUBSTR(l_ErrDescription, 1, 1500);
930: RAISE e_AddWFItemException;
931: end if;
932:

Line 945: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding WORKITEM_INSTANCE_ID attribute for the user-defined Workflow Procedure: '|| l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;

941: ErrCode => l_ErrCode,
942: ErrStr => l_ErrDescription);
943:
944: if l_ErrCode <> 0 then
945: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding WORKITEM_INSTANCE_ID attribute for the user-defined Workflow Procedure: '|| l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;
946: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
947: RAISE e_AddWFItemException;
948: end if;
949:

Line 958: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding ORDER_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;

954: ErrCode => l_ErrCode,
955: ErrStr => l_ErrDescription);
956:
957: if l_ErrCode <> 0 then
958: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding ORDER_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;
959: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
960: RAISE e_AddWFItemException;
961: end if;
962:

Line 975: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Invalid user-defined Workitem Workfl ow Configuration. Itemtype: ' || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix;

971: */
972: elsif l_wiwf = 'WORKFLOW' then
973: if (l_UserItemKeyPrefix is null) OR (l_UserItemType is null) OR
974: (l_UserWFProcess is null) then
975: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Invalid user-defined Workitem Workfl ow Configuration. Itemtype: ' || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix;
976: x_Progress := x_Progress || ' WF Proce ss: ' || l_UserWFProcess || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID;
977: RAISE e_InvalidUserWFConfigException;
978: end if;
979:

Line 993: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when creating the Workflow Process for user-defined workflow. Itemtype: ' || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix || ' WF Proce ss: ';

989: 'WAITFORFLOW-IND_WI',
990: l_ErrCode, l_ErrDescription);
991:
992: if l_ErrCode <> 0 then
993: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when creating the Workflow Process for user-defined workflow. Itemtype: ' || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix || ' WF Proce ss: ';
994: x_Progress := x_Progress || l_UserWFProcess || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '|| SUBSTR(l_ErrDescription, 1, 1500);
995: RAISE e_UserWFCreateException;
996: end if;
997:

Line 1019: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;

1015: 'WAITFORFLOW-IND_WI',
1016: l_ErrCode, l_ErrDescription);
1017:
1018: if l_ErrCode <> 0 then
1019: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;
1020: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1021: RAISE e_WIWFCreateException;
1022: end if;
1023:

Line 1037: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when creating the WORKITEM_PRO CESS Workflow Process for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;

1033: 'WAITFORFLOW-IND_WI',
1034: l_ErrCode, l_ErrDescription);
1035:
1036: if l_ErrCode <> 0 then
1037: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when creating the WORKITEM_PRO CESS Workflow Process for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID;
1038: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1039: RAISE e_WIWFCreateException;
1040: end if;
1041:

Line 1044: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Invalid Workitem type: ' || l_wiwf || ' for workitemID: ' || l_WorkitemID || ' Order: ' || l_OrderID;

1040: end if;
1041:
1042: else
1043: /* Invalid Configuration again */
1044: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Invalid Workitem type: ' || l_wiwf || ' for workitemID: ' || l_WorkitemID || ' Order: ' || l_OrderID;
1045: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1046: RAISE e_InvalidWITypeException;
1047:
1048: end if;

Line 1072: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error When Adding Workitem to Queue . Itemtype : ' || l_WFItemType || ' Itemkey: ' || l_WFItemKey || ' for workitemID: ' || l_WorkitemID;

1068: P_RETURN_CODE => l_ErrCode,
1069: P_ERROR_DESCRIPTION => l_ErrDescription);
1070:
1071: if l_ErrCode <> 0 then
1072: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error When Adding Workitem to Queue . Itemtype : ' || l_WFItemType || ' Itemkey: ' || l_WFItemKey || ' for workitemID: ' || l_WorkitemID;
1073: x_Progress := x_Progress || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1074: RAISE e_AddWItoQException;
1075: end if;
1076:

Line 1079: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1075: end if;
1076:
1077: exception
1078: when e_CallWIWfProcException then
1079: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1080: raise;
1081:
1082: when e_NullWIWfProcException then
1083: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1083: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1079: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1080: raise;
1081:
1082: when e_NullWIWfProcException then
1083: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1084: raise;
1085:
1086: when e_CallWIMapProcException then
1087: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1087: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1083: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1084: raise;
1085:
1086: when e_CallWIMapProcException then
1087: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1088: raise;
1089:
1090: when e_InvalidWITypeException then
1091: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1091: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1087: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1088: raise;
1089:
1090: when e_InvalidWITypeException then
1091: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1092: raise;
1093:
1094: when e_InvalidUserWFConfigException then
1095: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1095: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1091: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1092: raise;
1093:
1094: when e_InvalidUserWFConfigException then
1095: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1096: raise;
1097:
1098: when e_UserWFCreateException then
1099: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1099: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1095: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1096: raise;
1097:
1098: when e_UserWFCreateException then
1099: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1100: raise;
1101:
1102: when e_WIWFCreateException then
1103: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1103: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1099: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1100: raise;
1101:
1102: when e_WIWFCreateException then
1103: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1104: raise;
1105:
1106: when e_AddWItoQException then
1107: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1107: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1103: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1104: raise;
1105:
1106: when e_AddWItoQException then
1107: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1108: raise;
1109:
1110: when e_AddWFItemException then
1111: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1111: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1107: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1108: raise;
1109:
1110: when e_AddWFItemException then
1111: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1112: raise;
1113:
1114: when others then
1115: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

Line 1115: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);

1111: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1112: raise;
1113:
1114: when others then
1115: wf_core.context('XDPCORE_WI', 'LaunchWorkitemProcess', itemtype, itemkey, null, x_Progress);
1116: raise;
1117: end LaunchWorkitemProcess;
1118:
1119: Function LaunchAllIndependentWIs (itemtype in varchar2,

Line 1173: x_Progress := 'XDPCORE_WI.LaunchAllIndependentWIs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1169: return l_result;
1170:
1171: exception
1172: when others then
1173: x_Progress := 'XDPCORE_WI.LaunchAllIndependentWIs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1174: xdpcore.context('XDPCORE_WI', 'LaunchAllIndependentWIs', 'LINE', l_LineItemID,x_Progress);
1175: wf_core.context('XDPCORE_WI', 'LaunchAllIndependentWIs', itemtype, itemkey, null, x_Progress);
1176: raise;
1177: end LaunchAllIndependentWIs;

Line 1174: xdpcore.context('XDPCORE_WI', 'LaunchAllIndependentWIs', 'LINE', l_LineItemID,x_Progress);

1170:
1171: exception
1172: when others then
1173: x_Progress := 'XDPCORE_WI.LaunchAllIndependentWIs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1174: xdpcore.context('XDPCORE_WI', 'LaunchAllIndependentWIs', 'LINE', l_LineItemID,x_Progress);
1175: wf_core.context('XDPCORE_WI', 'LaunchAllIndependentWIs', itemtype, itemkey, null, x_Progress);
1176: raise;
1177: end LaunchAllIndependentWIs;
1178:

Line 1175: wf_core.context('XDPCORE_WI', 'LaunchAllIndependentWIs', itemtype, itemkey, null, x_Progress);

1171: exception
1172: when others then
1173: x_Progress := 'XDPCORE_WI.LaunchAllIndependentWIs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1174: xdpcore.context('XDPCORE_WI', 'LaunchAllIndependentWIs', 'LINE', l_LineItemID,x_Progress);
1175: wf_core.context('XDPCORE_WI', 'LaunchAllIndependentWIs', itemtype, itemkey, null, x_Progress);
1176: raise;
1177: end LaunchAllIndependentWIs;
1178:
1179: Procedure LaunchIndWorkitemProcess (itemtype in varchar2,

Line 1230: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Could Not Find User Defined Workflow Procedure for Workitem: '|| p_WorkitemID || ' Order: ' || p_OrderID;

1226: */
1227:
1228: IF l_wiwf = 'WORKFLOW_PROC' THEN /* The Workitem is a WOrkflow Process */
1229: IF l_UserWIProc IS NULL THEN
1230: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Could Not Find User Defined Workflow Procedure for Workitem: '|| p_WorkitemID || ' Order: ' || p_OrderID;
1231: x_Progress := x_Progress || ' Workitem InstanceID: ' || p_WIInstanceID || 'LineItemID: ' || p_LineItemID || ' Check Workitem Configuration';
1232: RAISE e_NullWIWfProcException;
1233: end if;
1234:

Line 1250: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Executing The user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;

1246: P_RETURN_CODE => l_ErrCode,
1247: P_ERROR_DESCRIPTION => l_ErrDescription);
1248:
1249: if l_ErrCode <> 0 then
1250: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Executing The user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;
1251: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1252: RAISE e_CallWIWfProcException;
1253: end if;
1254:

Line 1274: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Adding LINE_ITEM_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;

1270: ErrCode => l_ErrCode,
1271: ErrStr => l_ErrDescription);
1272:
1273: if l_ErrCode <> 0 then
1274: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Adding LINE_ITEM_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;
1275: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1276: RAISE e_AddWFItemException;
1277: end if;
1278:

Line 1291: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Adding WORKITEM_INSTANCE_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;

1287: ErrCode => l_ErrCode,
1288: ErrStr => l_ErrDescription);
1289:
1290: if l_ErrCode <> 0 then
1291: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Adding WORKITEM_INSTANCE_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;
1292: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1293: RAISE e_AddWFItemException;
1294: end if;
1295:

Line 1304: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Adding ORDER_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;

1300: ErrCode => l_ErrCode,
1301: ErrStr => l_ErrDescription);
1302:
1303: if l_ErrCode <> 0 then
1304: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when Adding ORDER_ID attribute for the user-defined Workflow Procedure: ' || l_UserWIProc || ' for Workitem: ' || p_WorkitemID;
1305: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1306: RAISE e_AddWFItemException;
1307: end if;
1308:

Line 1321: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Invalid user-defined Workitem Workflow Configuration. Itemtype: ' || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix || ' WF Process: ';

1317: */
1318: elsif l_wiwf = 'WORKFLOW' then
1319: if (l_UserItemKeyPrefix is null) OR (l_UserItemType is null) OR
1320: (l_UserWFProcess is null) then
1321: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Invalid user-defined Workitem Workflow Configuration. Itemtype: ' || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix || ' WF Process: ';
1322: x_Progress := x_Progress || l_UserWFProcess || ' for Workitem: ' || p_WorkitemID || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID;
1323: RAISE e_InvalidUserWFConfigException;
1324: end if;
1325:

Line 1340: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when creating the

1336: 'WAITFORFLOW-IND_WI',
1337: l_ErrCode, l_ErrDescription);
1338:
1339: if l_ErrCode <> 0 then
1340: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when creating the
1341: Workflow Process for user-defined workflow. Itemtype: ' || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix || ' WF Process: ' || l_UserWFProcess || ' for Workitem: ' || p_WorkitemID;
1342: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1343: RAISE e_UserWFCreateException;
1344: end if;

Line 1366: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when creating the

1362: p_WorkitemID, p_WIInstanceID, 'WAITFORFLOW-IND_WI',
1363: l_ErrCode, l_ErrDescription);
1364:
1365: if l_ErrCode <> 0 then
1366: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when creating the
1367: WORKITEM_PROCESS Workflow Process for Workitem: ' || p_WorkitemID;
1368: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1369: RAISE e_WIWFCreateException;
1370: end if;

Line 1383: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: ' || p_WorkitemID || ' Order: ' || p_OrderID;

1379: 'WORKITEM_PROCESS',p_OrderID, p_LineItemID, p_WorkitemID, p_WIInstanceID,
1380: 'WAITFORFLOW-IND_WI', l_ErrCode, l_ErrDescription);
1381:
1382: if l_ErrCode <> 0 then
1383: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: ' || p_WorkitemID || ' Order: ' || p_OrderID;
1384: x_Progress := x_Progress || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1385: RAISE e_WIWFCreateException;
1386: end if;
1387:

Line 1390: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Invalid Workitem type: ' ||

1386: end if;
1387:
1388: else
1389: /* Invalid Configuration again */
1390: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Invalid Workitem type: ' ||
1391: l_wiwf || ' for workitemID: ' || p_WorkitemID || ' Order: ' || p_OrderID;
1392: x_Progress := x_Progress || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1393: RAISE e_InvalidWITypeException;
1394:

Line 1419: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error When Adding Workitem to Queue. Itemtype : ' || l_WFItemType || ' Itemkey: ' || l_WFItemKey || ' for workitemID: ' || p_WorkitemID;

1415: P_RETURN_CODE => l_ErrCode,
1416: P_ERROR_DESCRIPTION => l_ErrDescription);
1417:
1418: if l_ErrCode <> 0 then
1419: x_Progress := 'XDPCORE_WI.LaunchIndWorkitemProcess . Error When Adding Workitem to Queue. Itemtype : ' || l_WFItemType || ' Itemkey: ' || l_WFItemKey || ' for workitemID: ' || p_WorkitemID;
1420: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1421: RAISE e_AddWItoQException;
1422: end if;
1423: EXCEPTION

Line 1425: wf_core.context('XDPCORE_WI', 'LaunchIndWorkitemProcess ', itemtype, itemkey, null, x_Progress);

1421: RAISE e_AddWItoQException;
1422: end if;
1423: EXCEPTION
1424: WHEN others THEN
1425: wf_core.context('XDPCORE_WI', 'LaunchIndWorkitemProcess ', itemtype, itemkey, null, x_Progress);
1426: raise;
1427: end LaunchIndWorkitemProcess ;
1428:
1429:

Line 1464: x_Progress := 'XDPCORE_WI.CheckIfWorkItemIsaWorkflow. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1460: end loop;
1461:
1462: exception
1463: when others then
1464: x_Progress := 'XDPCORE_WI.CheckIfWorkItemIsaWorkflow. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1465: wf_core.context('XDPCORE_WI', 'CheckIfWorkItemIsaWorkflow', null, null, null,null);
1466: raise;
1467: end CheckIfWorkItemIsaWorkflow;
1468:

Line 1465: wf_core.context('XDPCORE_WI', 'CheckIfWorkItemIsaWorkflow', null, null, null,null);

1461:
1462: exception
1463: when others then
1464: x_Progress := 'XDPCORE_WI.CheckIfWorkItemIsaWorkflow. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1465: wf_core.context('XDPCORE_WI', 'CheckIfWorkItemIsaWorkflow', null, null, null,null);
1466: raise;
1467: end CheckIfWorkItemIsaWorkflow;
1468:
1469:

Line 1513: x_Progress := 'XDPCORE_WI.ContinueWorkitem. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1509: return (l_Continue);
1510:
1511: exception
1512: when others then
1513: x_Progress := 'XDPCORE_WI.ContinueWorkitem. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1514: wf_core.context('XDPCORE_WI', 'ContinueWorkitem',itemtype, itemkey, null, null);
1515: raise;
1516: end ContinueWorkitem;
1517:

Line 1514: wf_core.context('XDPCORE_WI', 'ContinueWorkitem',itemtype, itemkey, null, null);

1510:
1511: exception
1512: when others then
1513: x_Progress := 'XDPCORE_WI.ContinueWorkitem. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1514: wf_core.context('XDPCORE_WI', 'ContinueWorkitem',itemtype, itemkey, null, null);
1515: raise;
1516: end ContinueWorkitem;
1517:
1518: Procedure InitializeWorkitemProcess(itemtype in varchar2,

Line 1546: x_Progress := 'XDPCORE_WI.InitializeWorkitemProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1542: end if;
1543:
1544: exception
1545: when others then
1546: x_Progress := 'XDPCORE_WI.InitializeWorkitemProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1547: wf_core.context('XDPCORE_WI', 'InitializeWorkitemProcess', itemtype, itemkey, null, x_Progress);
1548: raise;
1549: end InitializeWorkitemProcess;
1550:

Line 1547: wf_core.context('XDPCORE_WI', 'InitializeWorkitemProcess', itemtype, itemkey, null, x_Progress);

1543:
1544: exception
1545: when others then
1546: x_Progress := 'XDPCORE_WI.InitializeWorkitemProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1547: wf_core.context('XDPCORE_WI', 'InitializeWorkitemProcess', itemtype, itemkey, null, x_Progress);
1548: raise;
1549: end InitializeWorkitemProcess;
1550:
1551:

Line 1649: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute CURRENT_WI_SEQUENCE. Error:' || substr(ErrStr,1,1500);

1645: ErrCode => ErrCode,
1646: ErrStr => ErrStr);
1647:
1648: if ErrCode <> 0 then
1649: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute CURRENT_WI_SEQUENCE. Error:' || substr(ErrStr,1,1500);
1650: raise e_AddAttributeException;
1651: end if;
1652:
1653:

Line 1656: x_Progress := 'XDPCORE_WI.InitDepWIProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1652:
1653:
1654: EXCEPTION
1655: when others then
1656: x_Progress := 'XDPCORE_WI.InitDepWIProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1657: xdpcore.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey,x_Progress);
1658: wf_core.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey, null, x_Progress);
1659: raise;
1660: end InitDepWIProcess;

Line 1657: xdpcore.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey,x_Progress);

1653:
1654: EXCEPTION
1655: when others then
1656: x_Progress := 'XDPCORE_WI.InitDepWIProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1657: xdpcore.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey,x_Progress);
1658: wf_core.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey, null, x_Progress);
1659: raise;
1660: end InitDepWIProcess;
1661:

Line 1658: wf_core.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey, null, x_Progress);

1654: EXCEPTION
1655: when others then
1656: x_Progress := 'XDPCORE_WI.InitDepWIProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1657: xdpcore.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey,x_Progress);
1658: wf_core.context('XDPCORE_WI', 'InitDepWIProcess', itemtype, itemkey, null, x_Progress);
1659: raise;
1660: end InitDepWIProcess;
1661:
1662:

Line 1758: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute WORKITEM_ID. Error:

1754: ErrCode => ErrCode,
1755: ErrStr => ErrStr);
1756:
1757: if ErrCode <> 0 then
1758: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute WORKITEM_ID. Error:
1759: ' || substr(ErrStr,1,1500);
1760: raise e_AddAttributeException;
1761: end if;
1762:

Line 1772: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute WI_PRIORITY. Error:

1768: ErrCode => ErrCode,
1769: ErrStr => ErrStr);
1770:
1771: if ErrCode <> 0 then
1772: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute WI_PRIORITY. Error:
1773: ' || substr(ErrStr,1,1500);
1774: raise e_AddAttributeException;
1775: end if;
1776: END LOOP;

Line 1818: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute CURRENT_WI_SEQUENCE. Error:

1814: ErrCode => ErrCode,
1815: ErrStr => ErrStr);
1816:
1817: if ErrCode <> 0 then
1818: x_progress := 'In XDPCORE_WI.LaunchWIServiceProcess. Error when adding Item Attribute CURRENT_WI_SEQUENCE. Error:
1819: ' || substr(ErrStr,1,1500);
1820: raise e_AddAttributeException;
1821: end if;
1822:

Line 1828: x_Progress := 'XDPCORE_WI.LaunchWIServiceProcess. Found No workitems to be processed for Order: ' || l_OrderID || ' LineItemID: ' || l_LineItemID;

1824:
1825: close c_GetDepWIList;
1826:
1827: if l_Counter = 0 then
1828: x_Progress := 'XDPCORE_WI.LaunchWIServiceProcess. Found No workitems to be processed for Order: ' || l_OrderID || ' LineItemID: ' || l_LineItemID;
1829: RAISE e_NoWorkitemsFoundException;
1830: else
1831:
1832: FOR i in 1..l_Counter LOOP

Line 1849: wf_core.context('XDPCORE_WI', 'LaunchWIServiceProcess', itemtype, itemkey, null, x_Progress);

1845: if c_GetDepWIList%ISOPEN then
1846: close c_GetDepWIList;
1847: end if;
1848:
1849: wf_core.context('XDPCORE_WI', 'LaunchWIServiceProcess', itemtype, itemkey, null, x_Progress);
1850: raise;
1851:
1852: when e_NoWorkitemsFoundException then
1853: if c_GetIndWIList%ISOPEN then

Line 1861: wf_core.context('XDPCORE_WI', 'LaunchWIServiceProcess', itemtype, itemkey, null, x_Progress);

1857: if c_GetDepWIList%ISOPEN then
1858: close c_GetDepWIList;
1859: end if;
1860:
1861: wf_core.context('XDPCORE_WI', 'LaunchWIServiceProcess', itemtype, itemkey, null, x_Progress);
1862: raise;
1863:
1864: when others then
1865: if c_GetIndWIList%ISOPEN then

Line 1873: x_Progress := 'XDPCORE_WI.LaunchWIServiceProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1869: if c_GetDepWIList%ISOPEN then
1870: close c_GetDepWIList;
1871: end if;
1872:
1873: x_Progress := 'XDPCORE_WI.LaunchWIServiceProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1874: wf_core.context('XDPCORE_WI', 'LaunchWIServiceProcess', itemtype, itemkey, null, x_Progress);
1875: raise;
1876: end LaunchWIServiceProcess;
1877:

Line 1874: wf_core.context('XDPCORE_WI', 'LaunchWIServiceProcess', itemtype, itemkey, null, x_Progress);

1870: close c_GetDepWIList;
1871: end if;
1872:
1873: x_Progress := 'XDPCORE_WI.LaunchWIServiceProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1874: wf_core.context('XDPCORE_WI', 'LaunchWIServiceProcess', itemtype, itemkey, null, x_Progress);
1875: raise;
1876: end LaunchWIServiceProcess;
1877:
1878:

Line 1977: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Could Not Find User DefinedWorkflow Procedure for Workitem: '

1973: if l_wiwf = 'WORKFLOW_PROC' then
1974: /* The Workitem is a WOrkflow Process */
1975:
1976: if l_UserWIProc is null then
1977: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Could Not Find User DefinedWorkflow Procedure for Workitem: '
1978: || l_WorkitemID || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID
1979: || ' LineItemID: ' || l_LineItemID || ' Check WorkitemConfiguration';
1980:
1981: RAISE e_NullWIWfProcException;

Line 1999: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when Executing The user-defined Workflow Procedure: '

1995: P_RETURN_CODE => l_ErrCode,
1996: P_ERROR_DESCRIPTION => l_ErrDescription);
1997:
1998: if l_ErrCode <> 0 then
1999: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when Executing The user-defined Workflow Procedure: '
2000: || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || 'Order: ' || l_OrderID
2001: || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '
2002: || SUBSTR(l_ErrDescription, 1, 1500);
2003:

Line 2026: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding LINE_ITEM_ID attribute for the user-defined Workflow Procedure: '

2022: ErrCode => l_ErrCode,
2023: ErrStr => l_ErrDescription);
2024:
2025: if l_ErrCode <> 0 then
2026: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding LINE_ITEM_ID attribute for the user-defined Workflow Procedure: '
2027: || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID
2028: || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '
2029: || SUBSTR(l_ErrDescription, 1, 1500);
2030: RAISE e_AddWFItemException;

Line 2046: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding WORKITEM_INSTANCE_ID attribute for the user-defined Workflow Procedure: '

2042: ErrCode => l_ErrCode,
2043: ErrStr => l_ErrDescription);
2044:
2045: if l_ErrCode <> 0 then
2046: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding WORKITEM_INSTANCE_ID attribute for the user-defined Workflow Procedure: '
2047: || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID
2048: || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '
2049: || SUBSTR(l_ErrDescription, 1, 1500);
2050: RAISE e_AddWFItemException;

Line 2061: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding ORDER_ID attribute for the user-defined Workflow Procedure: '

2057: ErrCode => l_ErrCode,
2058: ErrStr => l_ErrDescription);
2059:
2060: if l_ErrCode <> 0 then
2061: x_Progress := 'XDPCORE_WI.LaunchWorkitemProcess. Error when Adding ORDER_ID attribute for the user-defined Workflow Procedure: '
2062: || l_UserWIProc || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID
2063: || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '
2064: || SUBSTR(l_ErrDescription, 1, 1500);
2065: RAISE e_AddWFItemException;

Line 2081: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Invalid user-defined Workitem Workflow Configuration. Itemtype: '

2077: elsif l_wiwf = 'WORKFLOW' then
2078:
2079: if (l_UserItemKeyPrefix is null) OR (l_UserItemType is null) OR
2080: (l_UserWFProcess is null) then
2081: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Invalid user-defined Workitem Workflow Configuration. Itemtype: '
2082: || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix || ' WF Process: '
2083: || l_UserWFProcess || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID
2084: || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID;
2085:

Line 2103: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when creating the Workflow Process for user-defined workflow. Itemtype: '

2099: 'WAITFORFLOW-DEP_WI',
2100: l_ErrCode, l_ErrDescription);
2101:
2102: if l_ErrCode <> 0 then
2103: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when creating the Workflow Process for user-defined workflow. Itemtype: '
2104: || l_UserItemType || ' ItemKey Prefix: ' || l_UserItemKeyPrefix || ' WF Process: '
2105: || l_UserWFProcess || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID
2106: || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '
2107: || SUBSTR(l_ErrDescription, 1, 1500);

Line 2134: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: '

2130: 'WAITFORFLOW-DEP_WI',
2131: l_ErrCode, l_ErrDescription);
2132:
2133: if l_ErrCode <> 0 then
2134: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: '
2135: || l_WorkitemID || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID
2136: || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
2137:
2138: RAISE e_WIWFCreateException;

Line 2152: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: '

2148: 'WAITFORFLOW-DEP_WI',
2149: l_ErrCode, l_ErrDescription);
2150:
2151: if l_ErrCode <> 0 then
2152: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error when creating the WORKITEM_PROCESS Workflow Process for Workitem: '
2153: || l_WorkitemID || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID
2154: || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
2155:
2156: RAISE e_WIWFCreateException;

Line 2161: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Invalid Workitem type: ' || l_wiwf || ' for workitemID: '

2157: end if;
2158:
2159: else
2160: /* Invalid Configuration again */
2161: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Invalid Workitem type: ' || l_wiwf || ' for workitemID: '
2162: || l_WorkitemID || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID
2163: || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
2164:
2165: RAISE e_InvalidWITypeException;

Line 2174: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. No Workitems found to be processed for Order: ' || l_OrderID || ' LineItemID: ' || l_LineItemID;

2170:
2171: close c_WIList;
2172:
2173: if l_Counter = 0 and l_CurrentSequence = 0 then
2174: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. No Workitems found to be processed for Order: ' || l_OrderID || ' LineItemID: ' || l_LineItemID;
2175:
2176: RAISE e_NoWIsFoundException;
2177: else
2178:

Line 2187: x_progress := 'In XDPCORE_WI.LaunchWISeqProcess. Error when adding Item Attribute CURRENT_WI_SEQUENCE. Error: ' || substr(ErrStr,1,1500);

2183: ErrCode => ErrCode,
2184: ErrStr => ErrStr);
2185:
2186: if ErrCode <> 0 then
2187: x_progress := 'In XDPCORE_WI.LaunchWISeqProcess. Error when adding Item Attribute CURRENT_WI_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
2188: raise e_AddAttributeException;
2189: end if;
2190:
2191: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

Line 2213: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error When Adding Workitemto Queue. Itemtype : '

2209: P_RETURN_CODE => l_ErrCode,
2210: P_ERROR_DESCRIPTION => l_ErrDescription);
2211:
2212: if l_ErrCode <> 0 then
2213: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Error When Adding Workitemto Queue. Itemtype : '
2214: || t_ChildTypes(i) || ' Itemkey: ' || t_ChildKeys(i) || ' for workitemID: ' || l_WorkitemID
2215: || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: '
2216: || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
2217:

Line 2230: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2226: if c_WIList%ISOPEN then
2227: close c_WIList;
2228: end if;
2229:
2230: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2231: raise;
2232:
2233: when e_NoWIsFoundException then
2234: if c_WIList%ISOPEN then

Line 2238: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2234: if c_WIList%ISOPEN then
2235: close c_WIList;
2236: end if;
2237:
2238: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2239: raise;
2240:
2241: when e_CallWIWfProcException then
2242: if c_WIList%ISOPEN then

Line 2246: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2242: if c_WIList%ISOPEN then
2243: close c_WIList;
2244: end if;
2245:
2246: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2247: raise;
2248:
2249: when e_NullWIWfProcException then
2250: if c_WIList%ISOPEN then

Line 2254: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2250: if c_WIList%ISOPEN then
2251: close c_WIList;
2252: end if;
2253:
2254: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2255: raise;
2256:
2257: when e_CallWIMapProcException then
2258: if c_WIList%ISOPEN then

Line 2262: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2258: if c_WIList%ISOPEN then
2259: close c_WIList;
2260: end if;
2261:
2262: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2263: raise;
2264:
2265: when e_InvalidWITypeException then
2266: if c_WIList%ISOPEN then

Line 2270: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2266: if c_WIList%ISOPEN then
2267: close c_WIList;
2268: end if;
2269:
2270: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2271: raise;
2272:
2273: when e_InvalidUserWFConfigException then
2274: if c_WIList%ISOPEN then

Line 2278: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2274: if c_WIList%ISOPEN then
2275: close c_WIList;
2276: end if;
2277:
2278: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2279: raise;
2280:
2281: when e_UserWFCreateException then
2282: if c_WIList%ISOPEN then

Line 2286: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2282: if c_WIList%ISOPEN then
2283: close c_WIList;
2284: end if;
2285:
2286: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2287: raise;
2288:
2289: when e_WIWFCreateException then
2290: if c_WIList%ISOPEN then

Line 2294: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2290: if c_WIList%ISOPEN then
2291: close c_WIList;
2292: end if;
2293:
2294: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2295: raise;
2296:
2297: when e_AddWItoQException then
2298: if c_WIList%ISOPEN then

Line 2302: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2298: if c_WIList%ISOPEN then
2299: close c_WIList;
2300: end if;
2301:
2302: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2303: raise;
2304:
2305: when e_AddWFItemException then
2306: if c_WIList%ISOPEN then

Line 2310: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2306: if c_WIList%ISOPEN then
2307: close c_WIList;
2308: end if;
2309:
2310: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2311: raise;
2312:
2313: when others then
2314: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

Line 2314: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2310: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2311: raise;
2312:
2313: when others then
2314: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2315: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2316: raise;
2317: end LaunchWISeqProcess;
2318:

Line 2315: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);

2311: raise;
2312:
2313: when others then
2314: x_Progress := 'XDPCORE_WI.LaunchWISeqProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2315: wf_core.context('XDPCORE_WI', 'LaunchWISeqProcess', itemtype, itemkey, null, x_Progress);
2316: raise;
2317: end LaunchWISeqProcess;
2318:
2319:

Line 2340: x_Progress := 'XDPCORE_WI.GetWIParamOnStart. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2336:
2337:
2338: exception
2339: when others then
2340: x_Progress := 'XDPCORE_WI.GetWIParamOnStart. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2341: wf_core.context('XDPCORE_WI', 'GetWIParamOnStart', itemtype, itemkey, null, x_Progress);
2342: raise;
2343: end GetWIParamOnStart;
2344:

Line 2341: wf_core.context('XDPCORE_WI', 'GetWIParamOnStart', itemtype, itemkey, null, x_Progress);

2337:
2338: exception
2339: when others then
2340: x_Progress := 'XDPCORE_WI.GetWIParamOnStart. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2341: wf_core.context('XDPCORE_WI', 'GetWIParamOnStart', itemtype, itemkey, null, x_Progress);
2342: raise;
2343: end GetWIParamOnStart;
2344:
2345:

Line 2452: x_Progress := 'XDPCORE_WI.UPDATE_WORKITEM_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2448: COMMIT;
2449:
2450: EXCEPTION
2451: WHEN others THEN
2452: x_Progress := 'XDPCORE_WI.UPDATE_WORKITEM_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2453: wf_core.context('XDPCORE_WI', 'UPDATE_WORKITEM_STATUS', p_itemtype, p_itemkey, null, x_Progress);
2454: rollback;
2455: raise;
2456:

Line 2453: wf_core.context('XDPCORE_WI', 'UPDATE_WORKITEM_STATUS', p_itemtype, p_itemkey, null, x_Progress);

2449:
2450: EXCEPTION
2451: WHEN others THEN
2452: x_Progress := 'XDPCORE_WI.UPDATE_WORKITEM_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2453: wf_core.context('XDPCORE_WI', 'UPDATE_WORKITEM_STATUS', p_itemtype, p_itemkey, null, x_Progress);
2454: rollback;
2455: raise;
2456:
2457: END UPDATE_WORKITEM_STATUS ;

Line 2476: x_Progress := 'XDPCORE_WI.GetWIProvisioningDate. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2472:
2473:
2474: EXCEPTION
2475: WHEN others THEN
2476: x_Progress := 'XDPCORE_WI.GetWIProvisioningDate. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2477: wf_core.context('XDPCORE_WI', 'GetWIProvisioningDate', null, null, null, x_Progress);
2478: raise;
2479: END GetWIProvisioningDate ;
2480:

Line 2477: wf_core.context('XDPCORE_WI', 'GetWIProvisioningDate', null, null, null, x_Progress);

2473:
2474: EXCEPTION
2475: WHEN others THEN
2476: x_Progress := 'XDPCORE_WI.GetWIProvisioningDate. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2477: wf_core.context('XDPCORE_WI', 'GetWIProvisioningDate', null, null, null, x_Progress);
2478: raise;
2479: END GetWIProvisioningDate ;
2480:
2481: Function GET_WI_RESPONSIBILITY (itemtype in varchar2,

Line 2510: x_Progress := 'XDPCORE_WI.GET_WI_RESPONSIBILITY. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2506: return l_wi_responsiblilty;
2507:
2508: EXCEPTION
2509: WHEN others THEN
2510: x_Progress := 'XDPCORE_WI.GET_WI_RESPONSIBILITY. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2511: xdpcore.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, x_Progress);
2512: wf_core.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, null, x_Progress);
2513: raise;
2514: END GET_WI_RESPONSIBILITY;

Line 2511: xdpcore.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, x_Progress);

2507:
2508: EXCEPTION
2509: WHEN others THEN
2510: x_Progress := 'XDPCORE_WI.GET_WI_RESPONSIBILITY. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2511: xdpcore.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, x_Progress);
2512: wf_core.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, null, x_Progress);
2513: raise;
2514: END GET_WI_RESPONSIBILITY;
2515:

Line 2512: wf_core.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, null, x_Progress);

2508: EXCEPTION
2509: WHEN others THEN
2510: x_Progress := 'XDPCORE_WI.GET_WI_RESPONSIBILITY. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2511: xdpcore.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, x_Progress);
2512: wf_core.context('XDPCORE_WI', 'GET_WI_RESPONSIBILITY', 'WI', l_WIInstanceID, null, x_Progress);
2513: raise;
2514: END GET_WI_RESPONSIBILITY;
2515:
2516: Function ResolveIndDepWIs(itemtype in varchar2,

Line 2580: x_Progress := 'XDPCORE_WI. ResolveIndDepWIs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2576:
2577:
2578: EXCEPTION
2579: WHEN others THEN
2580: x_Progress := 'XDPCORE_WI. ResolveIndDepWIs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2581: wf_core.context('XDPCORE_WI', ' ResolveIndDepWIs', null, null, null, x_Progress);
2582: raise;
2583:
2584: END ResolveIndDepWIs;

Line 2581: wf_core.context('XDPCORE_WI', ' ResolveIndDepWIs', null, null, null, x_Progress);

2577:
2578: EXCEPTION
2579: WHEN others THEN
2580: x_Progress := 'XDPCORE_WI. ResolveIndDepWIs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2581: wf_core.context('XDPCORE_WI', ' ResolveIndDepWIs', null, null, null, x_Progress);
2582: raise;
2583:
2584: END ResolveIndDepWIs;
2585:

Line 2600: wf_core.context('XDPCORE_WI', 'get_display_name', null, null, null,p_WIInstanceID );

2596: return l_display_name;
2597:
2598: EXCEPTION
2599: WHEN others THEN
2600: wf_core.context('XDPCORE_WI', 'get_display_name', null, null, null,p_WIInstanceID );
2601: raise;
2602: END get_display_name;
2603:
2604: Procedure OverrideParamValue( p_WIInstanceID IN NUMBER,

Line 2640: wf_core.context('XDPCORE_WI', ' OverrideParamValue', null, null, null,p_WIInstanceID );

2636: EXCEPTION
2637: WHEN others THEN
2638: -- Rollback the autonomous transaction..
2639: rollback;
2640: wf_core.context('XDPCORE_WI', ' OverrideParamValue', null, null, null,p_WIInstanceID );
2641: raise;
2642: END OverrideParamValue;
2643:
2644: End XDPCORE_WI;

Line 2644: End XDPCORE_WI;

2640: wf_core.context('XDPCORE_WI', ' OverrideParamValue', null, null, null,p_WIInstanceID );
2641: raise;
2642: END OverrideParamValue;
2643:
2644: End XDPCORE_WI;