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_FA dependencies on XDPCORE_FA

Line 1: PACKAGE BODY XDPCORE_FA AS

1: PACKAGE BODY XDPCORE_FA AS
2: /* $Header: XDPCORFB.pls 120.1 2005/06/08 23:44:29 appldev $ */
3:
4:
5: /****

Line 262: x_Progress := 'XDPCORE_FA.EnqueueFPQueue. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

258: end if;
259:
260: exception
261: when others then
262: x_Progress := 'XDPCORE_FA.EnqueueFPQueue. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
263: wf_core.context('XDPCORE_FA', 'EnqueueFPQueue', itemtype, itemkey, null, x_Progress);
264: raise;
265: end EnqueueFPQueue;
266:

Line 263: wf_core.context('XDPCORE_FA', 'EnqueueFPQueue', itemtype, itemkey, null, x_Progress);

259:
260: exception
261: when others then
262: x_Progress := 'XDPCORE_FA.EnqueueFPQueue. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
263: wf_core.context('XDPCORE_FA', 'EnqueueFPQueue', itemtype, itemkey, null, x_Progress);
264: raise;
265: end EnqueueFPQueue;
266:
267:

Line 316: XDPCORE.context('XDPCORE_FA', 'INITIALIZE_FA_LIST', itemtype, itemkey );

312:
313: EXCEPTION
314: WHEN e_InitFAFailed THEN
315: Rollback to InitFA;
316: XDPCORE.context('XDPCORE_FA', 'INITIALIZE_FA_LIST', itemtype, itemkey );
317:
318: --Log the error at the top level call
319: XDPCORE_ERROR.LOG_SESSION_ERROR( 'BUSINESS' );
320: return;

Line 323: wf_core.context('XDPCORE_FA', 'INITIALIZE_FA_LIST', itemtype, itemkey, to_char(actid), funcmode);

319: XDPCORE_ERROR.LOG_SESSION_ERROR( 'BUSINESS' );
320: return;
321:
322: WHEN OTHERS THEN
323: wf_core.context('XDPCORE_FA', 'INITIALIZE_FA_LIST', itemtype, itemkey, to_char(actid), funcmode);
324: raise;
325: END INITIALIZE_FA_LIST;
326:
327:

Line 357: wf_core.context('XDPCORE_FA', 'ARE_ALL_FAS_DONE', itemtype, itemkey, to_char(actid), funcmode);

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

Line 389: wf_core.context('XDPCORE_FA', 'LAUNCH_FA_PROVISIONING_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

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

Line 423: wf_core.context('XDPCORE_FA', 'LAUNCH_FA_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

419: END IF;
420:
421: EXCEPTION
422: WHEN OTHERS THEN
423: wf_core.context('XDPCORE_FA', 'LAUNCH_FA_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
424: raise;
425: END LAUNCH_FA_PROCESS;
426:
427:

Line 456: wf_core.context('XDPCORE_FA', 'LAUNCH_FA_PROCESS_SEQ', itemtype, itemkey, to_char(actid), funcmode);

452: END IF;
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: wf_core.context('XDPCORE_FA', 'LAUNCH_FA_PROCESS_SEQ', itemtype, itemkey, to_char(actid), funcmode);
457: raise;
458: END LAUNCH_FA_PROCESS_SEQ;
459:
460:

Line 498: XDPCORE.context('XDPCORE_FA', 'GET_FE', itemtype, itemkey );

494: EXCEPTION
495:
496: WHEN e_GetFEFailed THEN
497: Rollback to get_FE;
498: XDPCORE.context('XDPCORE_FA', 'GET_FE', itemtype, itemkey );
499:
500: --Log the error at the top level call
501: XDPCORE_ERROR.LOG_SESSION_ERROR( 'BUSINESS' );
502: return;

Line 505: wf_core.context('XDPCORE_FA', 'GET_FE', itemtype, itemkey, to_char(actid), funcmode);

501: XDPCORE_ERROR.LOG_SESSION_ERROR( 'BUSINESS' );
502: return;
503:
504: WHEN OTHERS THEN
505: wf_core.context('XDPCORE_FA', 'GET_FE', itemtype, itemkey, to_char(actid), funcmode);
506: raise;
507: END GET_FE;
508:
509:

Line 540: wf_core.context('XDPCORE_FA', 'INITIALIZE_FA', itemtype, itemkey, to_char(actid), funcmode);

536:
537:
538: EXCEPTION
539: WHEN OTHERS THEN
540: wf_core.context('XDPCORE_FA', 'INITIALIZE_FA', itemtype, itemkey, to_char(actid), funcmode);
541: raise;
542: END INITIALIZE_FA;
543:
544:

Line 577: wf_core.context('XDPCORE_FA', 'ENQUEUE_FP_QUEUE', itemtype, itemkey, to_char(actid), funcmode);

573: END IF;
574:
575: EXCEPTION
576: WHEN OTHERS THEN
577: wf_core.context('XDPCORE_FA', 'ENQUEUE_FP_QUEUE', itemtype, itemkey, to_char(actid), funcmode);
578: raise;
579: END ENQUEUE_FP_QUEUE;
580:
581:

Line 604: wf_core.context('XDPCORE_FA', 'ENQUEUE_FP_HOLD', itemtype, itemkey, to_char(actid), funcmode);

600: END IF;
601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: wf_core.context('XDPCORE_FA', 'ENQUEUE_FP_HOLD', itemtype, itemkey, to_char(actid), funcmode);
605: raise;
606: END ENQUEUE_FP_HOLD;
607:
608:

Line 638: wf_core.context('XDPCORE_FA', 'PROVISION_FE', itemtype, itemkey, to_char(actid), funcmode);

634: END IF;
635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: wf_core.context('XDPCORE_FA', 'PROVISION_FE', itemtype, itemkey, to_char(actid), funcmode);
639: raise;
640: END PROVISION_FE;
641:
642:

Line 675: wf_core.context('XDPCORE_FA', 'GET_FA_CALLER', itemtype, itemkey, to_char(actid), funcmode);

671:
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: wf_core.context('XDPCORE_FA', 'GET_FA_CALLER', itemtype, itemkey, to_char(actid), funcmode);
676: raise;
677: END GET_FA_CALLER;
678:
679:

Line 710: wf_core.context('XDPCORE_FA', 'RELEASE_FE_CHANNEL', itemtype, itemkey, to_char(actid), funcmode);

706:
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: wf_core.context('XDPCORE_FA', 'RELEASE_FE_CHANNEL', itemtype, itemkey, to_char(actid), funcmode);
711: raise;
712: END RELEASE_FE_CHANNEL;
713:
714:

Line 745: wf_core.context('XDPCORE_FA', 'STOP_FA_PROCESSING', itemtype, itemkey, to_char(actid), funcmode);

741:
742:
743: EXCEPTION
744: WHEN OTHERS THEN
745: wf_core.context('XDPCORE_FA', 'STOP_FA_PROCESSING', itemtype, itemkey, to_char(actid), funcmode);
746: raise;
747: END STOP_FA_PROCESSING;
748:
749:

Line 779: wf_core.context('XDPCORE_FA', 'IS_CHANNEL_AVAILABLE', itemtype, itemkey, to_char(actid), funcmode);

775:
776:
777: EXCEPTION
778: WHEN OTHERS THEN
779: wf_core.context('XDPCORE_FA', 'IS_CHANNEL_AVAILABLE', itemtype, itemkey, to_char(actid), funcmode);
780: raise;
781: END IS_CHANNEL_AVAILABLE;
782:
783: Procedure IS_ANY_CHANNEL_AVAILABLE (itemtype in varchar2,

Line 806: wf_core.context('XDPCORE_FA', 'IS_ANY_CHANNEL_AVAILABLE', itemtype, itemkey, to_char(actid), funcmode);

802:
803:
804: EXCEPTION
805: WHEN OTHERS THEN
806: wf_core.context('XDPCORE_FA', 'IS_ANY_CHANNEL_AVAILABLE', itemtype, itemkey, to_char(actid), funcmode);
807: raise;
808: END IS_ANY_CHANNEL_AVAILABLE;
809:
810:

Line 842: wf_core.context('XDPCORE_FA', 'IS_COD_CHANNEL_AVAILABLE', itemtype, itemkey, to_char(actid), funcmode);

838:
839:
840: EXCEPTION
841: WHEN OTHERS THEN
842: wf_core.context('XDPCORE_FA', 'IS_COD_CHANNEL_AVAILABLE', itemtype, itemkey, to_char(actid), funcmode);
843: raise;
844: END IS_COD_CHANNEL_AVAILABLE;
845:
846:

Line 875: wf_core.context('XDPCORE_FA', 'CONNECT_ON_DEMAND', itemtype, itemkey, to_char(actid), funcmode);

871: END IF;
872:
873: EXCEPTION
874: WHEN OTHERS THEN
875: wf_core.context('XDPCORE_FA', 'CONNECT_ON_DEMAND', itemtype, itemkey, to_char(actid), funcmode);
876: raise;
877: END CONNECT_ON_DEMAND;
878:
879:

Line 908: wf_core.context('XDPCORE_FA', 'WAIT_IN_FP_QUEUE', itemtype, itemkey, to_char(actid), funcmode);

904: END IF;
905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: wf_core.context('XDPCORE_FA', 'WAIT_IN_FP_QUEUE', itemtype, itemkey, to_char(actid), funcmode);
909: raise;
910: END WAIT_IN_FP_QUEUE;
911:
912:

Line 943: wf_core.context('XDPCORE_FA', 'VERIFY_CHANNEL', itemtype, itemkey, to_char(actid), funcmode);

939:
940:
941: EXCEPTION
942: WHEN OTHERS THEN
943: wf_core.context('XDPCORE_FA', 'VERIFY_CHANNEL', itemtype, itemkey, to_char(actid), funcmode);
944: raise;
945: END VERIFY_CHANNEL;
946:
947:

Line 978: wf_core.context('XDPCORE_FA', 'RESET_CHANNEL', itemtype, itemkey, to_char(actid), funcmode);

974:
975:
976: EXCEPTION
977: WHEN OTHERS THEN
978: wf_core.context('XDPCORE_FA', 'RESET_CHANNEL', itemtype, itemkey, to_char(actid), funcmode);
979: raise;
980: END RESET_CHANNEL;
981:
982:

Line 1007: wf_core.context('XDPCORE_FA', 'RESOLVE_IND_DEP_FAS', itemtype, itemkey, to_char(actid), funcmode);

1003:
1004:
1005: EXCEPTION
1006: WHEN OTHERS THEN
1007: wf_core.context('XDPCORE_FA', 'RESOLVE_IND_DEP_FAS', itemtype, itemkey, to_char(actid), funcmode);
1008: raise;
1009: END RESOLVE_IND_DEP_FAS;
1010:
1011: Procedure LAUNCH_ALL_IND_FAS (itemtype in varchar2,

Line 1035: wf_core.context('XDPCORE_FA', 'LAUNCH_ALL_IND_FAS', itemtype, itemkey, to_char(actid), funcmode);

1031:
1032:
1033: EXCEPTION
1034: WHEN OTHERS THEN
1035: wf_core.context('XDPCORE_FA', 'LAUNCH_ALL_IND_FAS', itemtype, itemkey, to_char(actid), funcmode);
1036: raise;
1037: END LAUNCH_ALL_IND_FAS;
1038:
1039: Procedure INITIALIZE_DEP_FA_PROCESS (itemtype in varchar2,

Line 1062: wf_core.context('XDPCORE_FA', 'INITIALIZE_DEP_FA_PROCESS', itemtype, itemkey, to_char(actid), funcmode);

1058:
1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: wf_core.context('XDPCORE_FA', 'INITIALIZE_DEP_FA_PROCESS', itemtype, itemkey, to_char(actid), funcmode);
1063: raise;
1064: END INITIALIZE_DEP_FA_PROCESS;
1065:
1066:

Line 1106: wf_core.context('XDPCORE_FA', 'IS_THRESHOLD_EXCEEDED', itemtype, itemkey, to_char(actid), funcmode);

1102:
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: wf_core.context('XDPCORE_FA', 'IS_THRESHOLD_EXCEEDED', itemtype, itemkey, to_char(actid), funcmode);
1107: raise;
1108: END IS_THRESHOLD_EXCEEDED;
1109:
1110:

Line 1135: wf_core.context('XDPCORE_FA', 'ERROR_DURING_RETRY', itemtype, itemkey, to_char(actid), funcmode);

1131:
1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: wf_core.context('XDPCORE_FA', 'ERROR_DURING_RETRY', itemtype, itemkey, to_char(actid), funcmode);
1136: raise;
1137: END ERROR_DURING_RETRY;
1138:
1139:

Line 1169: wf_core.context('XDPCORE_FA', 'IS_THRESHOLD_REACHED', itemtype, itemkey, to_char(actid), funcmode);

1165:
1166:
1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: wf_core.context('XDPCORE_FA', 'IS_THRESHOLD_REACHED', itemtype, itemkey, to_char(actid), funcmode);
1170: raise;
1171: END IS_THRESHOLD_REACHED;
1172:
1173:

Line 1200: wf_core.context('XDPCORE_FA', 'RESET_SYSTEM_HOLD', itemtype, itemkey, to_char(actid), funcmode);

1196:
1197:
1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: wf_core.context('XDPCORE_FA', 'RESET_SYSTEM_HOLD', itemtype, itemkey, to_char(actid), funcmode);
1201: raise;
1202: END RESET_SYSTEM_HOLD;
1203:
1204: Procedure OVERRIDE_FE (itemtype in varchar2,

Line 1242: wf_core.context('XDPCORE_FA', 'OVERRIDE_FE', itemtype, itemkey, to_char(actid), funcmode);

1238: return;
1239: END IF;
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: wf_core.context('XDPCORE_FA', 'OVERRIDE_FE', itemtype, itemkey, to_char(actid), funcmode);
1243: raise;
1244: END OVERRIDE_FE;
1245:
1246: Procedure AUTO_RETRY_ENABLED (itemtype in varchar2,

Line 1269: wf_core.context('XDPCORE_FA', 'AUTO_RETRY_ENABLED', itemtype, itemkey, to_char(actid), funcmode);

1265: END IF;
1266:
1267: EXCEPTION
1268: WHEN OTHERS THEN
1269: wf_core.context('XDPCORE_FA', 'AUTO_RETRY_ENABLED', itemtype, itemkey, to_char(actid), funcmode);
1270: raise;
1271: END AUTO_RETRY_ENABLED;
1272:
1273: /****

Line 1366: x_Progress := 'XDPCORE_FA.InitializeFAList. Exception when Adding FA to Workitem. Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID || 'Error: ' || SUBSTR(SQLERRM,1,200);

1362: PopulateFAs(l_WIInstanceID);
1363: l_FAsfound := 1;
1364: exception
1365: when others then
1366: x_Progress := 'XDPCORE_FA.InitializeFAList. Exception when Adding FA to Workitem. Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID || 'Error: ' || SUBSTR(SQLERRM,1,200);
1367: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1368: l_result := 'FAILURE';
1369: end;
1370:

Line 1367: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1363: l_FAsfound := 1;
1364: exception
1365: when others then
1366: x_Progress := 'XDPCORE_FA.InitializeFAList. Exception when Adding FA to Workitem. Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID || 'Error: ' || SUBSTR(SQLERRM,1,200);
1367: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1368: l_result := 'FAILURE';
1369: end;
1370:
1371: else

Line 1394: x_Progress := l_ErrStr || 'XDPCORE_FA.InitializeFAList. Error when Executing Procedure: ' || l_FAListProc || ' to dynamically get the FA List for Order: ' || l_OrderID;

1390: -- set the business error...
1391: XDPCORE.error_context( 'WI', l_WIInstanceID, 'XDP_UNABLE_TO_RESOLVE_FAS', l_message_params );
1392:
1393:
1394: x_Progress := l_ErrStr || 'XDPCORE_FA.InitializeFAList. Error when Executing Procedure: ' || l_FAListProc || ' to dynamically get the FA List for Order: ' || l_OrderID;
1395: x_Progress := x_Progress || ' WorkitemInstanceID: ' || l_WIInstanceID || ' Error: ' || SUBSTR(l_ErrStr, 1, 1500);
1396: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1397: l_result := 'FAILURE';
1398: end if;

Line 1396: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1392:
1393:
1394: x_Progress := l_ErrStr || 'XDPCORE_FA.InitializeFAList. Error when Executing Procedure: ' || l_FAListProc || ' to dynamically get the FA List for Order: ' || l_OrderID;
1395: x_Progress := x_Progress || ' WorkitemInstanceID: ' || l_WIInstanceID || ' Error: ' || SUBSTR(l_ErrStr, 1, 1500);
1396: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1397: l_result := 'FAILURE';
1398: end if;
1399: l_FAsfound := 1;
1400:

Line 1416: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1412:
1413: -- set the business error...
1414: XDPCORE.error_context( 'WI', l_WIInstanceID, 'XDP_UNABLE_TO_RESOLVE_FAS', l_message_params );
1415: END IF;
1416: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1417: l_result := 'FAILURE';
1418: end if;
1419: return l_result;
1420: exception

Line 1422: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1418: end if;
1419: return l_result;
1420: exception
1421: when e_ProcExecException then
1422: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1423: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1424: raise;
1425:
1426: when e_UnHandledException then

Line 1423: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1419: return l_result;
1420: exception
1421: when e_ProcExecException then
1422: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1423: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1424: raise;
1425:
1426: when e_UnHandledException then
1427: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

Line 1427: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1423: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1424: raise;
1425:
1426: when e_UnHandledException then
1427: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1428: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1429: raise;
1430:
1431: when e_CallFAMapProcException then

Line 1428: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1424: raise;
1425:
1426: when e_UnHandledException then
1427: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1428: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1429: raise;
1430:
1431: when e_CallFAMapProcException then
1432: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

Line 1432: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1428: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1429: raise;
1430:
1431: when e_CallFAMapProcException then
1432: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1433: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1434: raise;
1435:
1436: when e_AddFAToWIException then

Line 1433: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1429: raise;
1430:
1431: when e_CallFAMapProcException then
1432: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1433: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1434: raise;
1435:
1436: when e_AddFAToWIException then
1437: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

Line 1437: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1433: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1434: raise;
1435:
1436: when e_AddFAToWIException then
1437: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1438: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1439: raise;
1440:
1441: when others then

Line 1438: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1434: raise;
1435:
1436: when e_AddFAToWIException then
1437: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1438: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1439: raise;
1440:
1441: when others then
1442: x_Progress := 'XDPCORE_FA.InitializeFAList. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

Line 1442: x_Progress := 'XDPCORE_FA.InitializeFAList. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1438: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1439: raise;
1440:
1441: when others then
1442: x_Progress := 'XDPCORE_FA.InitializeFAList. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1443: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1444: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1445: raise;
1446: end InitializeFAList;

Line 1443: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1439: raise;
1440:
1441: when others then
1442: x_Progress := 'XDPCORE_FA.InitializeFAList. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1443: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1444: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1445: raise;
1446: end InitializeFAList;
1447:

Line 1444: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);

1440:
1441: when others then
1442: x_Progress := 'XDPCORE_FA.InitializeFAList. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1443: xdpcore.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1444: wf_core.context('XDPCORE_FA', 'InitializeFAList', itemtype, itemkey, null, x_Progress);
1445: raise;
1446: end InitializeFAList;
1447:
1448:

Line 1505: wf_core.context('XDPCORE_FA', 'AreAllFAsDone', itemtype, itemkey, null, x_Progress);

1501: if c_FaList%ISOPEN then
1502: Close c_FaList;
1503: end if;
1504:
1505: wf_core.context('XDPCORE_FA', 'AreAllFAsDone', itemtype, itemkey, null, x_Progress);
1506: raise;
1507:
1508: when others then
1509: if c_FaList%ISOPEN then

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

1509: if c_FaList%ISOPEN then
1510: Close c_FaList;
1511: end if;
1512:
1513: x_Progress := 'XDPCORE_FA.AreAllFAsDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1514: wf_core.context('XDPCORE_FA', 'AreAllFAsDone', itemtype, itemkey, null, x_Progress);
1515: raise;
1516: end AreAllFAsDone;
1517:

Line 1514: wf_core.context('XDPCORE_FA', 'AreAllFAsDone', itemtype, itemkey, null, x_Progress);

1510: Close c_FaList;
1511: end if;
1512:
1513: x_Progress := 'XDPCORE_FA.AreAllFAsDone. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1514: wf_core.context('XDPCORE_FA', 'AreAllFAsDone', itemtype, itemkey, null, x_Progress);
1515: raise;
1516: end AreAllFAsDone;
1517:
1518:

Line 1567: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Error when creating FA Process for Order: '

1563: l_FAItemType, l_FAItemKey,
1564: l_ErrCode, l_ErrDescription);
1565:
1566: if l_ErrCode <> 0 then
1567: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Error when creating FA Process for Order: '
1568: || l_OrderID || ' Workitem InstabceID: ' || l_WIInstanceID || ' FAInstanceID: ' || l_FAInstanceID
1569: || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1570: RAISE e_CreatFAWFException;
1571: end if;

Line 1595: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Error when Ading FA to Queue for for Order: '

1591: P_RETURN_CODE => l_ErrCode,
1592: P_ERROR_DESCRIPTION => l_ErrDescription);
1593:
1594: if l_ErrCode <> 0 then
1595: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Error when Ading FA to Queue for for Order: '
1596: || l_OrderID || ' Workitem InstabceID: ' || l_WIInstanceID || ' FAInstanceID: ' || l_FAInstanceID
1597: || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1598:
1599: RAISE e_AddFAtoQException;

Line 1604: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);

1600: end if;
1601:
1602: exception
1603: when e_CreatFAWFException then
1604: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);
1605: raise;
1606:
1607: when e_AddFAtoQException then
1608: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);

Line 1608: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);

1604: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);
1605: raise;
1606:
1607: when e_AddFAtoQException then
1608: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);
1609: raise;
1610:
1611: when others then
1612: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

Line 1612: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1608: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);
1609: raise;
1610:
1611: when others then
1612: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1613: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);
1614: raise;
1615: end LaunchFAProvisioningProcess;
1616:

Line 1613: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);

1609: raise;
1610:
1611: when others then
1612: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1613: wf_core.context('XDPCORE_FA', 'LaunchFAProvisioningProcess', itemtype, itemkey, null, x_Progress);
1614: raise;
1615: end LaunchFAProvisioningProcess;
1616:
1617:

Line 1671: x_Progress := 'XDPCORE_FA.InitializeFA. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1667: return;
1668: end if;
1669: exception
1670: when others then
1671: x_Progress := 'XDPCORE_FA.InitializeFA. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1672: wf_core.context('XDPCORE_FA', 'InitializeFA', itemtype, itemkey, null, x_Progress);
1673: raise;
1674: end InitializeFA;
1675:

Line 1672: wf_core.context('XDPCORE_FA', 'InitializeFA', itemtype, itemkey, null, x_Progress);

1668: end if;
1669: exception
1670: when others then
1671: x_Progress := 'XDPCORE_FA.InitializeFA. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1672: wf_core.context('XDPCORE_FA', 'InitializeFA', itemtype, itemkey, null, x_Progress);
1673: raise;
1674: end InitializeFA;
1675:
1676:

Line 1753: x_Progress := 'XDPCORE_FA.GetFE. No entries for FA InstanceID: ' || l_FAInstanceID || ' found. Check Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;

1749:
1750: -- set the business error...
1751: XDPCORE.error_context( 'FA', l_FAInstanceID, 'XDP_FE_NOT_FOUND', l_message_params );
1752:
1753: x_Progress := 'XDPCORE_FA.GetFE. No entries for FA InstanceID: ' || l_FAInstanceID || ' found. Check Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;
1754:
1755: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1756: return 'FAILURE';
1757: end if;

Line 1755: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1751: XDPCORE.error_context( 'FA', l_FAInstanceID, 'XDP_FE_NOT_FOUND', l_message_params );
1752:
1753: x_Progress := 'XDPCORE_FA.GetFE. No entries for FA InstanceID: ' || l_FAInstanceID || ' found. Check Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;
1754:
1755: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1756: return 'FAILURE';
1757: end if;
1758:
1759: if l_FeID is not null then

Line 1773: x_Progress := 'XDPCORE_FA.GeFe. Exception when Getting FE Config Info for FEID: ' || l_FeID || ' FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID || ' Error: ' || SUBSTR(SQLERRM,1,500);

1769: l_FeSWGeneric,
1770: l_AdapterType);
1771: exception
1772: when others then
1773: x_Progress := 'XDPCORE_FA.GeFe. Exception when Getting FE Config Info for FEID: ' || l_FeID || ' FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID || ' Error: ' || SUBSTR(SQLERRM,1,500);
1774:
1775: RAISE e_GetFeConfigException;
1776: end;
1777:

Line 1786: x_Progress := 'XDPCORE_FA.GeFe. Could not locate te FE Routing Procedure for FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;

1782:
1783: l_LocateFEProc := GetLocateFEProc(l_FAInstanceID);
1784:
1785: if l_LocateFEProc IS NULL then
1786: x_Progress := 'XDPCORE_FA.GeFe. Could not locate te FE Routing Procedure for FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;
1787:
1788: RAISE e_InvalidConfigException;
1789: end if;
1790:

Line 1813: xdpcore.context('XDPCORE_FA', 'InitializeFAList', 'FA', l_FAInstanceID, null, l_ErrStr);

1809:
1810: -- set the business error...
1811: XDPCORE.error_context( 'FA', l_WIInstanceID, 'XDP_EXCEP_IN_FE_RT_PROC', l_message_params );
1812:
1813: xdpcore.context('XDPCORE_FA', 'InitializeFAList', 'FA', l_FAInstanceID, null, l_ErrStr);
1814: return 'FAILURE';
1815: end if;
1816:
1817: /* Got the FE Name. Now get the FetypeID, FEID, SW/Generic */

Line 1839: x_Progress := 'XDPCORE_FA.GeFe. Exception when Getting FE Config Info for FE: ' || l_FeName || ' FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID || ' Error: ' || SUBSTR(SQLERRM,1,500);

1835: l_message_params := 'FA='||l_fa_disp_name|| '#XDP#FE=' || l_FeName ||'#XDP#ROUT_PROC='||l_routing_proc_disp_name||'#XDP#';
1836:
1837: -- set the business error...
1838: XDPCORE.error_context( 'FE', l_FeID, 'XDP_ROUT_PROC_RETND_INVALID_FE', l_message_params );
1839: x_Progress := 'XDPCORE_FA.GeFe. Exception when Getting FE Config Info for FE: ' || l_FeName || ' FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID || ' Error: ' || SUBSTR(SQLERRM,1,500);
1840: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1841: return 'FAILURE';
1842: end;
1843:

Line 1840: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1836:
1837: -- set the business error...
1838: XDPCORE.error_context( 'FE', l_FeID, 'XDP_ROUT_PROC_RETND_INVALID_FE', l_message_params );
1839: x_Progress := 'XDPCORE_FA.GeFe. Exception when Getting FE Config Info for FE: ' || l_FeName || ' FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID || ' Error: ' || SUBSTR(SQLERRM,1,500);
1840: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1841: return 'FAILURE';
1842: end;
1843:
1844: FOR v_UpdateFEID in c_UpdateFEID(l_FAInstanceID) LOOP

Line 1862: x_progress := 'In XDPCORE_FA.GetFE. Error when adding FE_NAME attribute. ';

1858: ErrCode => ErrCode,
1859: ErrStr => ErrStr);
1860:
1861: if ErrCode <> 0 then
1862: x_progress := 'In XDPCORE_FA.GetFE. Error when adding FE_NAME attribute. ';
1863: raise e_AddAttributeException;
1864: end if;
1865:
1866: XDPCORE.CheckNAddItemAttrNumber (itemtype => GetFE.itemtype,

Line 1874: x_progress := 'In XDPCORE_FA.GetFE. Error when adding FE_ID attribute. ';

1870: ErrCode => ErrCode,
1871: ErrStr => ErrStr);
1872:
1873: if ErrCode <> 0 then
1874: x_progress := 'In XDPCORE_FA.GetFE. Error when adding FE_ID attribute. ';
1875: raise e_AddAttributeException;
1876: end if;
1877:
1878: l_FaProvProc := GetFPProc (l_FAInstanceID, l_FeTypeID,

Line 1889: x_Progress := 'XDPCORE_FA.GetFe. Could not find and FP for FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;

1885:
1886: -- set the business error...
1887: XDPCORE.error_context( 'FA', l_FAInstanceID, 'XDP_FE_FP_NOT_FOUND', l_message_params );
1888:
1889: x_Progress := 'XDPCORE_FA.GetFe. Could not find and FP for FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;
1890:
1891: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1892: return 'FAILURE';
1893: end if;

Line 1891: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1887: XDPCORE.error_context( 'FA', l_FAInstanceID, 'XDP_FE_FP_NOT_FOUND', l_message_params );
1888:
1889: x_Progress := 'XDPCORE_FA.GetFe. Could not find and FP for FA InstanceID: ' || l_FAInstanceID || ' Order: ' || l_OrderID || ' Workitem InstanceID : ' || l_WIInstanceID;
1890:
1891: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1892: return 'FAILURE';
1893: end if;
1894:
1895: -- skilaru 04/05/02

Line 1910: x_progress := 'In XDPCORE_FA.GetFE. Error when adding FP_NAME attribute. ';

1906: ErrCode => ErrCode,
1907: ErrStr => ErrStr);
1908:
1909: if ErrCode <> 0 then
1910: x_progress := 'In XDPCORE_FA.GetFE. Error when adding FP_NAME attribute. ';
1911: raise e_AddAttributeException;
1912: end if;
1913:
1914:

Line 1928: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1924: return l_result;
1925:
1926: exception
1927: when e_InvalidConfigException then
1928: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1929: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1930: raise;
1931:
1932: when e_InvalidFEConfigException then

Line 1929: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1925:
1926: exception
1927: when e_InvalidConfigException then
1928: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1929: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1930: raise;
1931:
1932: when e_InvalidFEConfigException then
1933: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

Line 1933: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1929: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1930: raise;
1931:
1932: when e_InvalidFEConfigException then
1933: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1934: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1935:
1936: when e_CallFeRoutingProcException then
1937: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

Line 1934: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1930: raise;
1931:
1932: when e_InvalidFEConfigException then
1933: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1934: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1935:
1936: when e_CallFeRoutingProcException then
1937: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1938: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

Line 1937: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1933: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1934: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1935:
1936: when e_CallFeRoutingProcException then
1937: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1938: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1939: raise;
1940:
1941: when e_ProcExecException then

Line 1938: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1934: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1935:
1936: when e_CallFeRoutingProcException then
1937: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1938: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1939: raise;
1940:
1941: when e_ProcExecException then
1942: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

Line 1942: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1938: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1939: raise;
1940:
1941: when e_ProcExecException then
1942: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1943: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1944: raise;
1945:
1946: when e_GetFeConfigException then

Line 1943: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1939: raise;
1940:
1941: when e_ProcExecException then
1942: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1943: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1944: raise;
1945:
1946: when e_GetFeConfigException then
1947: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

Line 1947: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1943: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1944: raise;
1945:
1946: when e_GetFeConfigException then
1947: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1948: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1949: raise;
1950:
1951: when others then

Line 1948: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

1944: raise;
1945:
1946: when e_GetFeConfigException then
1947: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1948: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1949: raise;
1950:
1951: when others then
1952: x_Progress := 'XDPCORE_FA.GetFe. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

Line 1952: x_Progress := 'XDPCORE_FA.GetFe. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

1948: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1949: raise;
1950:
1951: when others then
1952: x_Progress := 'XDPCORE_FA.GetFe. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
1953: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1954: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);
1955: raise;
1956: end GetFe;

Line 1953: xdpcore.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

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

Line 1954: wf_core.context('XDPCORE_FA', 'GetFe', itemtype, itemkey, null, x_Progress);

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

Line 2021: x_progress := 'In XDPCORE_FA.IsChannelAvailable. Error when adding CHANNEL_NAME attribute. ';

2017: ErrCode => ErrCode,
2018: ErrStr => ErrStr);
2019:
2020: if ErrCode <> 0 then
2021: x_progress := 'In XDPCORE_FA.IsChannelAvailable. Error when adding CHANNEL_NAME attribute. ';
2022: raise e_AddAttributeException;
2023: end if;
2024:
2025: /* If the Resubmission JobID is non zero the fa must look for "RESUBMISSION" type

Line 2069: x_progress := 'In XDPCORE_FA.IsChannelAvailable. Error when adding CHANNEL_NAME attribute. ';

2065: ErrCode => ErrCode,
2066: ErrStr => ErrStr);
2067:
2068: if ErrCode <> 0 then
2069: x_progress := 'In XDPCORE_FA.IsChannelAvailable. Error when adding CHANNEL_NAME attribute. ';
2070: raise e_AddAttributeException;
2071: end if;
2072:
2073: /* Check if the FA is aborted. If so abort the process immediately */

Line 2097: x_Progress := 'XDPCORE_FA.IsChannelAvailable. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2093: end if;
2094:
2095: exception
2096: when others then
2097: x_Progress := 'XDPCORE_FA.IsChannelAvailable. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2098: wf_core.context('XDPCORE_FA', 'IsChannelAvailable', itemtype, itemkey, null, x_Progress);
2099: l_Status := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => l_ChannelName);
2100: raise;
2101: end IsChannelAvailable;

Line 2098: wf_core.context('XDPCORE_FA', 'IsChannelAvailable', itemtype, itemkey, null, x_Progress);

2094:
2095: exception
2096: when others then
2097: x_Progress := 'XDPCORE_FA.IsChannelAvailable. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2098: wf_core.context('XDPCORE_FA', 'IsChannelAvailable', itemtype, itemkey, null, x_Progress);
2099: l_Status := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => l_ChannelName);
2100: raise;
2101: end IsChannelAvailable;
2102:

Line 2256: x_Progress := 'XDPCORE_FA.VerifyChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2252: END IF ;
2253:
2254: Rollback to VerifyChannel;
2255:
2256: x_Progress := 'XDPCORE_FA.VerifyChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2257: wf_core.context('XDPCORE_FA', 'VerifyChannel', itemtype, itemkey, null, x_Progress);
2258: raise;
2259: end VerifyChannel;
2260:

Line 2257: wf_core.context('XDPCORE_FA', 'VerifyChannel', itemtype, itemkey, null, x_Progress);

2253:
2254: Rollback to VerifyChannel;
2255:
2256: x_Progress := 'XDPCORE_FA.VerifyChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2257: wf_core.context('XDPCORE_FA', 'VerifyChannel', itemtype, itemkey, null, x_Progress);
2258: raise;
2259: end VerifyChannel;
2260:
2261:

Line 2442: xdpcore.context('XDPCORE_FA', 'ProvisionFe', 'FE', l_FeName);

2438: end if;
2439:
2440:
2441: if l_ErrCode <> 0 then
2442: xdpcore.context('XDPCORE_FA', 'ProvisionFe', 'FE', l_FeName);
2443: ExamineErrorCodes(l_ErrCode, l_FAInstanceID, l_AbortFAFlag, l_ErrAction);
2444: if l_ErrAction = 'PROVISIONING_ERROR' then
2445: l_result := 'FAILURE';
2446:

Line 2464: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';

2460: ErrCode => ErrCode,
2461: ErrStr => ErrStr);
2462:
2463: if ErrCode <> 0 then
2464: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';
2465: raise e_AddAttributeException;
2466: end if;
2467:
2468: elsif l_ErrAction = 'NE_SESSION_LOST' then

Line 2488: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';

2484: ErrCode => ErrCode,
2485: ErrStr => ErrStr);
2486:
2487: if ErrCode <> 0 then
2488: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';
2489: raise e_AddAttributeException;
2490: end if;
2491:
2492: elsif l_ErrAction = 'NE_TIMED_OUT' then

Line 2504: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';

2500: ErrCode => ErrCode,
2501: ErrStr => ErrStr);
2502:
2503: if ErrCode <> 0 then
2504: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';
2505: raise e_AddAttributeException;
2506: end if;
2507: elsif l_ErrAction = 'DYNAMIC_EXEC_ERROR' then
2508:

Line 2598: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';

2594: ErrCode => ErrCode,
2595: ErrStr => ErrStr);
2596:
2597: if ErrCode <> 0 then
2598: x_progress := 'In XDPCORE_FA.ProvisionFE. Error when adding FE_ERROR_DESCRIPTION attribute. ';
2599: raise e_AddAttributeException;
2600: end if;
2601: l_result := 'FAILURE';
2602:

Line 2684: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

2680:
2681: l_Status := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock
2682: (p_ChannelName => l_ChannelName);
2683:
2684: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
2685: raise;
2686:
2687: when others then
2688:

Line 2702: x_Progress := 'XDPCORE_FA.ProvisionFE. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2698: aname => 'FP_FUNC_MODE',
2699: avalue => 'RETRY');
2700:
2701: COMMIT;
2702: x_Progress := 'XDPCORE_FA.ProvisionFE. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2703: wf_core.context('XDPCORE_FA', 'ProvisionFE', itemtype, itemkey, null, x_Progress);
2704: raise;
2705:
2706: end ProvisionFE;

Line 2703: wf_core.context('XDPCORE_FA', 'ProvisionFE', itemtype, itemkey, null, x_Progress);

2699: avalue => 'RETRY');
2700:
2701: COMMIT;
2702: x_Progress := 'XDPCORE_FA.ProvisionFE. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2703: wf_core.context('XDPCORE_FA', 'ProvisionFE', itemtype, itemkey, null, x_Progress);
2704: raise;
2705:
2706: end ProvisionFE;
2707:

Line 2750: x_Progress := 'XDPCORE_FA.ExamineErrorCodes. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2746:
2747:
2748: exception
2749: when others then
2750: x_Progress := 'XDPCORE_FA.ExamineErrorCodes. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2751: wf_core.context('XDPCORE_FA', 'ExamineErrorCodes', null, null, x_Progress,null);
2752: raise;
2753: end ExamineErrorCodes;
2754:

Line 2751: wf_core.context('XDPCORE_FA', 'ExamineErrorCodes', null, null, x_Progress,null);

2747:
2748: exception
2749: when others then
2750: x_Progress := 'XDPCORE_FA.ExamineErrorCodes. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2751: wf_core.context('XDPCORE_FA', 'ExamineErrorCodes', null, null, x_Progress,null);
2752: raise;
2753: end ExamineErrorCodes;
2754:
2755:

Line 2844: x_Progress := 'XDPCORE_FA.ReleaseFEChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2840: end if;
2841:
2842: exception
2843: when others then
2844: x_Progress := 'XDPCORE_FA.ReleaseFEChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2845: wf_core.context('XDPCORE_FA', 'ReleaseFEChannel', itemtype, itemkey, null, x_Progress);
2846: l_Status := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => l_ChannelName);
2847: raise;
2848: end ReleaseFEChannel;

Line 2845: wf_core.context('XDPCORE_FA', 'ReleaseFEChannel', itemtype, itemkey, null, x_Progress);

2841:
2842: exception
2843: when others then
2844: x_Progress := 'XDPCORE_FA.ReleaseFEChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2845: wf_core.context('XDPCORE_FA', 'ReleaseFEChannel', itemtype, itemkey, null, x_Progress);
2846: l_Status := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => l_ChannelName);
2847: raise;
2848: end ReleaseFEChannel;
2849:

Line 2892: x_Progress := 'XDPCORE_FA.StopFAProcessing. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2888:
2889:
2890: exception
2891: when others then
2892: x_Progress := 'XDPCORE_FA.StopFAProcessing. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2893: wf_core.context('XDPCORE_FA', 'StopFAProcessing', itemtype, itemkey, to_char(actid),null);
2894: raise;
2895: end StopFAProcessing;
2896:

Line 2893: wf_core.context('XDPCORE_FA', 'StopFAProcessing', itemtype, itemkey, to_char(actid),null);

2889:
2890: exception
2891: when others then
2892: x_Progress := 'XDPCORE_FA.StopFAProcessing. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2893: wf_core.context('XDPCORE_FA', 'StopFAProcessing', itemtype, itemkey, to_char(actid),null);
2894: raise;
2895: end StopFAProcessing;
2896:
2897:

Line 2922: x_Progress := 'XDPCORE_FA.ResetChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2918: avalue => null);
2919:
2920: exception
2921: when others then
2922: x_Progress := 'XDPCORE_FA.ResetChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2923: wf_core.context('XDPCORE_FA', 'ResetChannel', itemtype, itemkey, null, x_Progress);
2924: raise;
2925: end ResetChannel;
2926:

Line 2923: wf_core.context('XDPCORE_FA', 'ResetChannel', itemtype, itemkey, null, x_Progress);

2919:
2920: exception
2921: when others then
2922: x_Progress := 'XDPCORE_FA.ResetChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2923: wf_core.context('XDPCORE_FA', 'ResetChannel', itemtype, itemkey, null, x_Progress);
2924: raise;
2925: end ResetChannel;
2926:
2927:

Line 2953: x_Progress := 'XDPCORE_FA.GetFaCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

2949: return (l_FaCaller);
2950:
2951: exception
2952: when others then
2953: x_Progress := 'XDPCORE_FA.GetFaCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2954: wf_core.context('XDPCORE_FA', 'GetFaCaller', itemtype, itemkey, to_char(actid),null);
2955: raise;
2956: end GetFaCaller;
2957:

Line 2954: wf_core.context('XDPCORE_FA', 'GetFaCaller', itemtype, itemkey, to_char(actid),null);

2950:
2951: exception
2952: when others then
2953: x_Progress := 'XDPCORE_FA.GetFaCaller. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
2954: wf_core.context('XDPCORE_FA', 'GetFaCaller', itemtype, itemkey, to_char(actid),null);
2955: raise;
2956: end GetFaCaller;
2957:
2958:

Line 3322: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute FA_PRIORITY. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;

3318: ErrCode => l_ErrCode,
3319: ErrStr => l_ErrStr);
3320:
3321: if l_ErrCode <> 0 then
3322: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute FA_PRIORITY. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;
3323:
3324: raise e_AddAttributeException;
3325: end if;
3326:

Line 3336: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute CURRENT_FA_SEQUENCE. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;

3332: ErrCode => l_ErrCode,
3333: ErrStr => l_ErrStr);
3334:
3335: if l_ErrCode <> 0 then
3336: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute CURRENT_FA_SEQUENCE. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;
3337:
3338: raise e_AddAttributeException;
3339: end if;
3340:

Line 3384: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute FA_PRIORITY. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;

3380: ErrCode => l_ErrCode,
3381: ErrStr => l_ErrStr);
3382:
3383: if l_ErrCode <> 0 then
3384: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute FA_PRIORITY. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;
3385:
3386: raise e_AddAttributeException;
3387: end if;
3388:

Line 3398: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute CURRENT_FA_SEQUENCE. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;

3394: ErrCode => l_ErrCode,
3395: ErrStr => l_ErrStr);
3396:
3397: if l_ErrCode <> 0 then
3398: x_progress := 'XDPCORE_FA.LaunchFAProcess. Error when adding item attribute CURRENT_FA_SEQUENCE. Order ID: ' || l_OrderID || ' Workitem Instance ID: ' || l_WIInstanceID || ' Line Item ID: ' || l_LineItemID;
3399:
3400: raise e_AddAttributeException;
3401: end if;
3402:

Line 3406: x_Progress := 'XDPCORE_FA.LaunchFAProcess. No FA''s found to be processed for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID;

3402:
3403: end if;
3404:
3405: if l_Counter = 0 then
3406: x_Progress := 'XDPCORE_FA.LaunchFAProcess. No FA''s found to be processed for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID;
3407: RAISE e_NoFAsFoundException;
3408: end if;
3409:
3410: /* Launch all the WOrkflows */

Line 3427: wf_core.context('XDPCORE_FA', 'LaunchFAProcess', itemtype, itemkey, null, x_Progress);

3423: if c_GetDepFA%ISOPEN then
3424: close c_GetDepFA;
3425: end if;
3426:
3427: wf_core.context('XDPCORE_FA', 'LaunchFAProcess', itemtype, itemkey, null, x_Progress);
3428: raise;
3429:
3430: when e_NoFAsFoundException then
3431: if c_GetIndFA%ISOPEN then

Line 3439: wf_core.context('XDPCORE_FA', 'LaunchFAProcess', itemtype, itemkey, null, x_Progress);

3435: if c_GetDepFA%ISOPEN then
3436: close c_GetDepFA;
3437: end if;
3438:
3439: wf_core.context('XDPCORE_FA', 'LaunchFAProcess', itemtype, itemkey, null, x_Progress);
3440: raise;
3441:
3442: when others then
3443: if c_GetIndFA%ISOPEN then

Line 3451: x_Progress := 'XDPCORE_FA.LaunchFAProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

3447: if c_GetDepFA%ISOPEN then
3448: close c_GetDepFA;
3449: end if;
3450:
3451: x_Progress := 'XDPCORE_FA.LaunchFAProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3452: wf_core.context('XDPCORE_FA', 'LaunchFAProcess', itemtype, itemkey, null, x_Progress);
3453: raise;
3454: end LaunchFAProcess;
3455:

Line 3452: wf_core.context('XDPCORE_FA', 'LaunchFAProcess', itemtype, itemkey, null, x_Progress);

3448: close c_GetDepFA;
3449: end if;
3450:
3451: x_Progress := 'XDPCORE_FA.LaunchFAProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3452: wf_core.context('XDPCORE_FA', 'LaunchFAProcess', itemtype, itemkey, null, x_Progress);
3453: raise;
3454: end LaunchFAProcess;
3455:
3456:

Line 3540: x_Progress := 'XDPCORE_FA.LaunchFAProcessSeq. Error when creating FA Process for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);

3536: t_ChildTypes(l_Counter), t_childKeys(l_Counter),
3537: l_ErrCode, l_ErrDescription);
3538:
3539: if l_ErrCode <> 0 then
3540: x_Progress := 'XDPCORE_FA.LaunchFAProcessSeq. Error when creating FA Process for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
3541: RAISE e_CreateFAProcessException;
3542: end if;
3543:
3544: t_FaIdList(l_Counter) := l_FAInstanceID;

Line 3555: x_Progress := 'XDPCORE_FA.LaunchFAProcess. No FA''s found to be processed for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID;

3551: end if;
3552:
3553:
3554: if l_Counter = 0 and l_CurrentFASeq = 0 then
3555: x_Progress := 'XDPCORE_FA.LaunchFAProcess. No FA''s found to be processed for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID;
3556: RAISE e_NoFAsFoundException;
3557:
3558: else
3559:

Line 3568: x_progress := 'XDPCORE_FA.LaunchFAProcessSeq. Error when adding item attribute CURRENT_FA_SEQUENCE.';

3564: ErrCode => l_ErrCode,
3565: ErrStr => l_ErrDescription);
3566:
3567: if l_ErrCode <> 0 then
3568: x_progress := 'XDPCORE_FA.LaunchFAProcessSeq. Error when adding item attribute CURRENT_FA_SEQUENCE.';
3569: raise e_AddAttributeException;
3570: end if;
3571:
3572: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */

Line 3594: x_Progress := 'XDPCORE_FA.LaunchFAProcessSeq. Error When Adding FA: ' || t_FaIdList(i) || ' to Queue for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);

3590: P_RETURN_CODE => l_ErrCode,
3591: P_ERROR_DESCRIPTION => l_ErrDescription);
3592:
3593: if l_ErrCode <> 0 then
3594: x_Progress := 'XDPCORE_FA.LaunchFAProcessSeq. Error When Adding FA: ' || t_FaIdList(i) || ' to Queue for Order: ' || l_OrderID || ' WorkitemInstanceID: ' || l_WIInstanceID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
3595:
3596: RAISE e_AddFAtoQException;
3597: end if;
3598:

Line 3610: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);

3606: if c_FAList%ISOPEN then
3607: close c_FAList ;
3608: end if;
3609:
3610: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);
3611: raise;
3612:
3613: when e_NoFAsFoundException then
3614: if c_FAList%ISOPEN then

Line 3618: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);

3614: if c_FAList%ISOPEN then
3615: close c_FAList ;
3616: end if;
3617:
3618: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);
3619: raise;
3620:
3621: when e_AddFAtoQException then
3622: if c_FAList%ISOPEN then

Line 3626: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);

3622: if c_FAList%ISOPEN then
3623: close c_FAList ;
3624: end if;
3625:
3626: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);
3627: raise;
3628:
3629: when e_CreateFAProcessException then
3630: if c_FAList%ISOPEN then

Line 3634: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);

3630: if c_FAList%ISOPEN then
3631: close c_FAList ;
3632: end if;
3633:
3634: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);
3635: raise;
3636:
3637: when others then
3638: if c_FAList%ISOPEN then

Line 3642: x_Progress := 'XDPCORE_FA.LaunchFAProcessSeq. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

3638: if c_FAList%ISOPEN then
3639: close c_FAList ;
3640: end if;
3641:
3642: x_Progress := 'XDPCORE_FA.LaunchFAProcessSeq. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3643: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);
3644: raise;
3645: end LaunchFAProcessSeq;
3646:

Line 3643: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);

3639: close c_FAList ;
3640: end if;
3641:
3642: x_Progress := 'XDPCORE_FA.LaunchFAProcessSeq. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3643: wf_core.context('XDPCORE_FA', 'LaunchFAProcessSeq', itemtype, itemkey, null, x_Progress);
3644: raise;
3645: end LaunchFAProcessSeq;
3646:
3647: -- This version of HandOver is used When the HandOver is called from the Adapter

Line 3870: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when handing Over Channel: ' || p_ChannelName

3866: p_ErrStr);
3867:
3868:
3869: if p_ErrCode <> 0 then
3870: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when handing Over Channel: ' || p_ChannelName
3871: || ' for FE: ' || p_FeName || ' to itemtype: ' || l_New_itemtype || ' with itemkey: '
3872: || l_New_itemkey || ' Current Order: ' || l_OrderID || ' WIInstanceID: ' || l_WIInstanceID
3873: || ' FA InstanceID: ' || l_FAInstanceID || ' Error: ' || SUBSTR(p_ErrStr, 1, 1000);
3874:

Line 3918: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when updating the Adapter Registration to be IDLE for Channel: '

3914:
3915:
3916: EXCEPTION
3917: WHEN OTHERS THEN
3918: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when updating the Adapter Registration to be IDLE for Channel: '
3919: || p_ChannelName || ' for FE: ' || l_FeID || ' Current Order: ' || l_OrderID || ' WIInstanceID: '
3920: || l_WIInstanceID || ' FA InstanceID: ' || l_FAInstanceID || ' Error: ' || SUBSTR(SQLERRM,1,500);
3921:
3922: RAISE e_UpdateAdapterRegException;

Line 3950: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

3946: IF l_channellock THEN
3947: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => HandOverChannel.p_ChannelName);
3948: END IF ;
3949:
3950: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3951: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
3952: raise;
3953:
3954: when e_UpdateAdapterRegException then

Line 3951: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

3947: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => HandOverChannel.p_ChannelName);
3948: END IF ;
3949:
3950: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3951: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
3952: raise;
3953:
3954: when e_UpdateAdapterRegException then
3955: IF c_AdapterJobQueue%ISOPEN THEN

Line 3963: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

3959: IF l_channellock THEN
3960: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => HandOverChannel.p_ChannelName);
3961: END IF ;
3962:
3963: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
3964: raise;
3965:
3966: when e_HandOverChannelException then
3967: IF c_AdapterJobQueue%ISOPEN THEN

Line 3975: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

3971: IF l_channellock THEN
3972: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => HandOverChannel.p_ChannelName);
3973: END IF ;
3974:
3975: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
3976: raise;
3977:
3978: when others then
3979: IF c_AdapterJobQueue%ISOPEN THEN

Line 3987: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

3983: IF l_channellock THEN
3984: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => HandOverChannel.p_ChannelName);
3985: END IF ;
3986:
3987: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3988: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
3989: raise;
3990: end HandOverChannel;
3991:

Line 3988: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

3984: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock (p_ChannelName => HandOverChannel.p_ChannelName);
3985: END IF ;
3986:
3987: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
3988: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
3989: raise;
3990: end HandOverChannel;
3991:
3992:

Line 4236: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when handing Over Channel: ' || ChannelName

4232: ErrStr);
4233:
4234:
4235: if ErrCode <> 0 then
4236: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when handing Over Channel: ' || ChannelName
4237: || ' for FE: ' || l_FeID || ' to itemtype: ' || l_New_itemtype || ' with itemkey: '
4238: || l_New_itemkey || ' Current Order: ' || l_OrderID || ' WIInstanceID: ' || l_WIInstanceID
4239: || ' FA InstanceID: ' || l_FAInstanceID || ' Error: ' || SUBSTR(ErrStr, 1, 1000);
4240:

Line 4284: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when updating the Adapter Registration to be IDLE for Channel: '

4280:
4281:
4282: EXCEPTION
4283: WHEN OTHERS THEN
4284: x_Progress := 'XDPCORE_FA.HandOverChannel. Exception when updating the Adapter Registration to be IDLE for Channel: '
4285: || ChannelName || ' for FE: ' || l_FeID || ' Current Order: ' || l_OrderID || ' WIInstanceID: '
4286: || l_WIInstanceID || ' FA InstanceID: ' || l_FAInstanceID || ' Error: ' || SUBSTR(SQLERRM,1,500);
4287:
4288: RAISE e_UpdateAdapterRegException;

Line 4317: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

4313: IF l_channellock THEN
4314: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName => HandOverChannel.ChannelName);
4315: END IF ;
4316:
4317: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
4318: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
4319: raise;
4320:
4321: when e_UpdateAdapterRegException then

Line 4318: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

4314: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName => HandOverChannel.ChannelName);
4315: END IF ;
4316:
4317: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
4318: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
4319: raise;
4320:
4321: when e_UpdateAdapterRegException then
4322: IF c_AdapterJobQueue%ISOPEN THEN

Line 4330: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

4326: IF l_channellock THEN
4327: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName => HandOverChannel.ChannelName);
4328: END IF ;
4329:
4330: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
4331: raise;
4332:
4333: when e_HandOverChannelException then
4334: IF c_AdapterJobQueue%ISOPEN THEN

Line 4342: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

4338: IF l_channellock THEN
4339: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName => HandOverChannel.ChannelName);
4340: END IF ;
4341:
4342: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
4343: raise;
4344:
4345: when others then
4346: IF c_AdapterJobQueue%ISOPEN THEN

Line 4354: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

4350: IF l_channellock THEN
4351: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName => HandOverChannel.ChannelName);
4352: END IF ;
4353:
4354: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
4355: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
4356: raise;
4357: end HandOverChannel;
4358:

Line 4355: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);

4351: l_channelstatus := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName => HandOverChannel.ChannelName);
4352: END IF ;
4353:
4354: x_Progress := 'XDPCORE_FA.HandOverChannel. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
4355: wf_core.context('XDPCORE_FA', 'HandOverChannel', null, null, x_Progress,null);
4356: raise;
4357: end HandOverChannel;
4358:
4359: Procedure FindAdminRequestAndPublish (ChannelName in varchar2,

Line 4443: wf_core.context('XDPCORE_FA', 'FindAdminRequestAndPublish', null, null, null, x_progress);

4439: if c_AdapterAdmin%ISOPEN then
4440: close c_AdapterAdmin;
4441: end if;
4442:
4443: wf_core.context('XDPCORE_FA', 'FindAdminRequestAndPublish', null, null, null, x_progress);
4444: raise;
4445: when others then
4446: if c_AdapterAdmin%ISOPEN then
4447: close c_AdapterAdmin;

Line 4450: x_Progress := 'XDPCORE_FA.FindAdminRequestAndPublish. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

4446: if c_AdapterAdmin%ISOPEN then
4447: close c_AdapterAdmin;
4448: end if;
4449:
4450: x_Progress := 'XDPCORE_FA.FindAdminRequestAndPublish. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
4451: wf_core.context('XDPCORE_FA', 'FindAdminRequestAndPublish', null, null, x_Progress,null);
4452: raise;
4453: end FindAdminRequestAndPublish;
4454:

Line 4451: wf_core.context('XDPCORE_FA', 'FindAdminRequestAndPublish', null, null, x_Progress,null);

4447: close c_AdapterAdmin;
4448: end if;
4449:
4450: x_Progress := 'XDPCORE_FA.FindAdminRequestAndPublish. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
4451: wf_core.context('XDPCORE_FA', 'FindAdminRequestAndPublish', null, null, x_Progress,null);
4452: raise;
4453: end FindAdminRequestAndPublish;
4454:
4455:

Line 4524: xdpcore.context( 'XDPCORE_FA', 'PopulateFAs', 'WI',WIInstanceID);

4520: raise e_NoFAsFound;
4521: end if;
4522: exception
4523: when others then
4524: xdpcore.context( 'XDPCORE_FA', 'PopulateFAs', 'WI',WIInstanceID);
4525: if c_GetFaList%ISOPEN then
4526: close c_GetFaList;
4527: end if;
4528: raise;

Line 5092: x_Progress := 'XDPCORE_FA.UPDATE_FA_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

5088: COMMIT;
5089:
5090: EXCEPTION
5091: WHEN others THEN
5092: x_Progress := 'XDPCORE_FA.UPDATE_FA_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
5093: wf_core.context('XDPCORE_FA', 'UPDATE_FA_STATUS', p_itemtype, p_itemkey, null, x_Progress);
5094: rollback;
5095: raise;
5096: END UPDATE_FA_STATUS ;

Line 5093: wf_core.context('XDPCORE_FA', 'UPDATE_FA_STATUS', p_itemtype, p_itemkey, null, x_Progress);

5089:
5090: EXCEPTION
5091: WHEN others THEN
5092: x_Progress := 'XDPCORE_FA.UPDATE_FA_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);
5093: wf_core.context('XDPCORE_FA', 'UPDATE_FA_STATUS', p_itemtype, p_itemkey, null, x_Progress);
5094: rollback;
5095: raise;
5096: END UPDATE_FA_STATUS ;
5097:

Line 5151: x_Progress := 'XDPCORE_FA.ResolveIndDepFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

5147:
5148: exception
5149: when others then
5150:
5151: x_Progress := 'XDPCORE_FA.ResolveIndDepFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5152: wf_core.context('XDPCORE_FA', 'ResolveIndDepFAs', itemtype, itemkey, null, x_Progress);
5153: raise;
5154: end ResolveIndDepFAs;
5155:

Line 5152: wf_core.context('XDPCORE_FA', 'ResolveIndDepFAs', itemtype, itemkey, null, x_Progress);

5148: exception
5149: when others then
5150:
5151: x_Progress := 'XDPCORE_FA.ResolveIndDepFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5152: wf_core.context('XDPCORE_FA', 'ResolveIndDepFAs', itemtype, itemkey, null, x_Progress);
5153: raise;
5154: end ResolveIndDepFAs;
5155:
5156: Function LaunchAllIndFAs(itemtype in varchar2,

Line 5223: x_Progress := 'XDPCORE_FA.LaunchAllIndFAs. Error when creating FA Process for Order: '

5219: l_ErrCode, l_ErrStr);
5220:
5221:
5222: if l_ErrCode <> 0 then
5223: x_Progress := 'XDPCORE_FA.LaunchAllIndFAs. Error when creating FA Process for Order: '
5224: || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID || ' FAInstanceID: ' || l_FAInstanceID
5225: || ' Error: ' || SUBSTR(l_ErrStr, 1, 1500);
5226: RAISE e_CreatFAWFException;
5227: end if;

Line 5250: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Error when Ading FA to Queue for for Order: '

5246: P_RETURN_CODE => l_ErrCode,
5247: P_ERROR_DESCRIPTION => l_ErrStr);
5248:
5249: if l_ErrCode <> 0 then
5250: x_Progress := 'XDPCORE_FA.LaunchFAProvisioningProcess. Error when Ading FA to Queue for for Order: '
5251: || l_OrderID || ' Workitem InstabceID: ' || l_WIInstanceID || ' FAInstanceID: ' || l_FAInstanceID
5252: || ' Error: ' || SUBSTR(l_ErrStr, 1, 1500);
5253:
5254: RAISE e_AddFAtoQException;

Line 5263: x_Progress := 'XDPCORE_FA.LaunchAllIndFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

5259: return l_result;
5260:
5261: exception
5262: when others then
5263: x_Progress := 'XDPCORE_FA.LaunchAllIndFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5264: wf_core.context('XDPCORE_FA', 'LaunchAllIndFAs', itemtype, itemkey, null, x_Progress);
5265: raise;
5266:
5267: END LaunchAllIndFAs;

Line 5264: wf_core.context('XDPCORE_FA', 'LaunchAllIndFAs', itemtype, itemkey, null, x_Progress);

5260:
5261: exception
5262: when others then
5263: x_Progress := 'XDPCORE_FA.LaunchAllIndFAs. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5264: wf_core.context('XDPCORE_FA', 'LaunchAllIndFAs', itemtype, itemkey, null, x_Progress);
5265: raise;
5266:
5267: END LaunchAllIndFAs;
5268:

Line 5288: x_Progress := 'XDPCORE_FA.InitializeDepFAProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

5284:
5285:
5286: EXCEPTION
5287: when others then
5288: x_Progress := 'XDPCORE_FA.InitializeDepFAProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5289: wf_core.context('XDPCORE_FA', 'InitializeDepFAProcess', itemtype, itemkey, null, x_Progress);
5290: raise;
5291:
5292: END InitializeDepFAProcess;

Line 5289: wf_core.context('XDPCORE_FA', 'InitializeDepFAProcess', itemtype, itemkey, null, x_Progress);

5285:
5286: EXCEPTION
5287: when others then
5288: x_Progress := 'XDPCORE_FA.InitializeDepFAProcess. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5289: wf_core.context('XDPCORE_FA', 'InitializeDepFAProcess', itemtype, itemkey, null, x_Progress);
5290: raise;
5291:
5292: END InitializeDepFAProcess;
5293:

Line 5312: x_Progress := 'XDPCORE_FA.IsAnyChannelAvailable. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);

5308: END IF;
5309:
5310: EXCEPTION
5311: when others then
5312: x_Progress := 'XDPCORE_FA.IsAnyChannelAvailable. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5313: wf_core.context('XDPCORE_FA', 'IsAnyChannelAvailable', itemtype, itemkey, null, x_Progress);
5314: raise;
5315:
5316: END;

Line 5313: wf_core.context('XDPCORE_FA', 'IsAnyChannelAvailable', itemtype, itemkey, null, x_Progress);

5309:
5310: EXCEPTION
5311: when others then
5312: x_Progress := 'XDPCORE_FA.IsAnyChannelAvailable. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1200);
5313: wf_core.context('XDPCORE_FA', 'IsAnyChannelAvailable', itemtype, itemkey, null, x_Progress);
5314: raise;
5315:
5316: END;
5317:

Line 5332: wf_core.context('XDPCORE_FA', 'get_display_name', null, null, null,p_FAInstanceID );

5328: return l_display_name;
5329:
5330: EXCEPTION
5331: WHEN others THEN
5332: wf_core.context('XDPCORE_FA', 'get_display_name', null, null, null,p_FAInstanceID );
5333: raise;
5334: END get_display_name;
5335:
5336: Function IsThresholdExceeded (p_fp_name in varchar2) return varchar2 IS

Line 5417: wf_core.context('XDPCORE_FA', 'ErrorDuringRetry', itemtype, itemkey );

5413: RETURN lv_fp_in_error;
5414:
5415: EXCEPTION
5416: WHEN others THEN
5417: wf_core.context('XDPCORE_FA', 'ErrorDuringRetry', itemtype, itemkey );
5418: raise;
5419: END ErrorDuringRetry;
5420:
5421:

Line 5622: xdpcore.context('XDPCORE_FA', 'OverrideFE', 'FA', p_faInstanceID);

5618: l_messageParams := 'FA='||l_faDispName|| '#XDP#FE=' || p_FEName ||'#XDP#';
5619:
5620: -- set the business error...
5621: XDPCORE.error_context( 'FA', p_faInstanceID, 'XDP_USER_ENTERED_INVALID_FE', l_messageParams );
5622: xdpcore.context('XDPCORE_FA', 'OverrideFE', 'FA', p_faInstanceID);
5623: resultout := 'COMPLETE:FE_NOT_FOUND';
5624: END IF;
5625:
5626: EXCEPTION

Line 5633: End XDPCORE_FA;

5629: END OverrideFE;
5630:
5631:
5632:
5633: End XDPCORE_FA;