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.XDPSTATUS dependencies on WF_CORE

Line 138: wf_core.context('XDPSTATUS', 'SET_ERROR_STATUS', itemtype, itemkey, to_char(actid), funcmode);

134:
135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: wf_core.context('XDPSTATUS', 'SET_ERROR_STATUS', itemtype, itemkey, to_char(actid), funcmode);
139: raise;
140: END SET_ERROR_STATUS;
141:
142: -- SET_ORDER_STATUS

Line 200: wf_core.context('XDPSTATUS', 'SET_ORDER_STATUS', itemtype, itemkey, to_char(actid), funcmode);

196:
197:
198: EXCEPTION
199: WHEN OTHERS THEN
200: wf_core.context('XDPSTATUS', 'SET_ORDER_STATUS', itemtype, itemkey, to_char(actid), funcmode);
201: raise;
202: END SET_ORDER_STATUS;
203:
204:

Line 263: wf_core.context('XDPSTATUS', 'SEND_ORDER_STATUS', itemtype, itemkey, to_char(actid), funcmode);

259: END IF;
260:
261: EXCEPTION
262: WHEN OTHERS THEN
263: wf_core.context('XDPSTATUS', 'SEND_ORDER_STATUS', itemtype, itemkey, to_char(actid), funcmode);
264: raise;
265: END SEND_ORDER_STATUS;
266:
267:

Line 327: wf_core.context('XDPSTATUS', 'SEND_LINE_STATUS', itemtype, itemkey, to_char(actid), funcmode);

323: END IF;
324:
325: EXCEPTION
326: WHEN OTHERS THEN
327: wf_core.context('XDPSTATUS', 'SEND_LINE_STATUS', itemtype, itemkey, to_char(actid), funcmode);
328: raise;
329: END SEND_LINE_STATUS;
330:
331:

Line 391: wf_core.context('XDPSTATUS', 'SET_BUNDLE_STATUS', itemtype, itemkey, to_char(actid), funcmode);

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

Line 454: wf_core.context('XDPSTATUS', 'SET_LINE_STATUS', itemtype, itemkey, to_char(actid), funcmode);

450:
451:
452: EXCEPTION
453: WHEN OTHERS THEN
454: wf_core.context('XDPSTATUS', 'SET_LINE_STATUS', itemtype, itemkey, to_char(actid), funcmode);
455: raise;
456: END SET_LINE_STATUS;
457:
458:

Line 519: wf_core.context('XDPSTATUS', 'SET_PACKAGE_STATUS', itemtype, itemkey, to_char(actid), funcmode);

515:
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: wf_core.context('XDPSTATUS', 'SET_PACKAGE_STATUS', itemtype, itemkey, to_char(actid), funcmode);
520: raise;
521: END SET_PACKAGE_STATUS;
522:
523:

Line 580: wf_core.context('XDPSTATUS', 'SET_WORKITEM_STATUS', itemtype, itemkey, to_char(actid), funcmode);

576: END IF;
577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: wf_core.context('XDPSTATUS', 'SET_WORKITEM_STATUS', itemtype, itemkey, to_char(actid), funcmode);
581: raise;
582: END SET_WORKITEM_STATUS;
583:
584:

Line 639: wf_core.context('XDPSTATUS', 'SET_WI_STATUS_SUCCESS', itemtype, itemkey, to_char(actid), funcmode);

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

Line 704: wf_core.context('XDPSTATUS', 'SEND_WORKITEM_STATUS', itemtype, itemkey, to_char(actid), funcmode);

700: END IF;
701:
702: EXCEPTION
703: WHEN OTHERS THEN
704: wf_core.context('XDPSTATUS', 'SEND_WORKITEM_STATUS', itemtype, itemkey, to_char(actid), funcmode);
705: raise;
706: END SEND_WORKITEM_STATUS;
707:
708:

Line 763: wf_core.context('XDPSTATUS', 'SAVE_WORKITEM', itemtype, itemkey, to_char(actid), funcmode);

759: END IF;
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: wf_core.context('XDPSTATUS', 'SAVE_WORKITEM', itemtype, itemkey, to_char(actid), funcmode);
764: raise;
765: END SAVE_WORKITEM;
766:
767:

Line 826: wf_core.context('XDPSTATUS', 'SET_FA_STATUS', itemtype, itemkey, to_char(actid), funcmode);

822: END IF;
823:
824: EXCEPTION
825: WHEN OTHERS THEN
826: wf_core.context('XDPSTATUS', 'SET_FA_STATUS', itemtype, itemkey, to_char(actid), funcmode);
827: raise;
828: END SET_FA_STATUS;
829:
830:

Line 890: wf_core.context('XDPSTATUS', 'SEND_FE_PROV_STATUS', itemtype, itemkey, to_char(actid), funcmode);

886: END IF;
887:
888: EXCEPTION
889: WHEN OTHERS THEN
890: wf_core.context('XDPSTATUS', 'SEND_FE_PROV_STATUS', itemtype, itemkey, to_char(actid), funcmode);
891: raise;
892: END SEND_FE_PROV_STATUS;
893:
894:

Line 954: wf_core.context('XDPSTATUS', 'SET_FE_EXEC_STATUS', itemtype, itemkey, to_char(actid), funcmode);

950: END IF;
951:
952: EXCEPTION
953: WHEN OTHERS THEN
954: wf_core.context('XDPSTATUS', 'SET_FE_EXEC_STATUS', itemtype, itemkey, to_char(actid), funcmode);
955: raise;
956: END SET_FE_EXEC_STATUS;
957:
958:

Line 1012: wf_core.context('XDPSTATUS', 'SET_FE_PROV_STATE', itemtype, itemkey, to_char(actid), funcmode);

1008: END IF;
1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: wf_core.context('XDPSTATUS', 'SET_FE_PROV_STATE', itemtype, itemkey, to_char(actid), funcmode);
1013: raise;
1014: END SET_FE_PROV_STATE;
1015:
1016: --This procedure sets the Line item status to the status

Line 1038: wf_core.context('XDPSTATUS', 'SET_NODE_LINE_STATUS', itemtype, itemkey, to_char(actid), funcmode);

1034:
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: wf_core.context('XDPSTATUS', 'SET_NODE_LINE_STATUS', itemtype, itemkey, to_char(actid), funcmode);
1039: raise;
1040: END SET_NODE_LINE_STATUS;
1041: --This procedure sets the work item status to the status
1042: --that is assigned to the node in the workflow..

Line 1063: wf_core.context('XDPSTATUS', 'SET_NODE_WI_STATUS', itemtype, itemkey, to_char(actid), funcmode);

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

Line 1084: wf_core.clear;

1080: exception
1081: when others then
1082: if sqlcode = -20002 then
1083: l_JobID := 0;
1084: wf_core.clear;
1085: else
1086: raise e_UnhandledException;
1087: end if;
1088: end;

Line 1180: wf_core.context('XDPSTATUS', 'SetErrorStatus', itemtype, itemkey, null,null);

1176: END IF;
1177:
1178: EXCEPTION
1179: WHEN others THEN
1180: wf_core.context('XDPSTATUS', 'SetErrorStatus', itemtype, itemkey, null,null);
1181: RAISE;
1182: END SetErrorStatus;
1183:
1184: PROCEDURE SETORDERSTATUS(itemtype IN VARCHAR2,

Line 1255: wf_core.context('XDPSTATUS', 'SetOrderStatus', itemtype, itemkey, null,null);

1251:
1252: COMMIT;
1253: EXCEPTION
1254: WHEN others THEN
1255: wf_core.context('XDPSTATUS', 'SetOrderStatus', itemtype, itemkey, null,null);
1256: RAISE;
1257: END SetOrderStatus;
1258:
1259:

Line 1306: wf_core.context('XDPSTATUS', 'SendOrderStatus', itemtype, itemkey, to_char(actid),null);

1302: end if;
1303:
1304: exception
1305: when others then
1306: wf_core.context('XDPSTATUS', 'SendOrderStatus', itemtype, itemkey, to_char(actid),null);
1307: raise;
1308: end SendOrderStatus;
1309:
1310:

Line 1387: wf_core.context('XDPSTATUS', 'SetWorkitemStatus', itemtype, itemkey, null,null);

1383: END IF;
1384:
1385: EXCEPTION
1386: WHEN others THEN
1387: wf_core.context('XDPSTATUS', 'SetWorkitemStatus', itemtype, itemkey, null,null);
1388: RAISE;
1389: END SETWORKITEMSTATUS;
1390:
1391:

Line 1407: wf_core.context('XDPSTATUS', 'SetWIStatusSuccess', itemtype, itemkey, null,null);

1403: UPDATE_XDP_WORKITEM_STATUS('SUCCESS' , l_WIInstanceID );
1404:
1405: EXCEPTION
1406: WHEN others THEN
1407: wf_core.context('XDPSTATUS', 'SetWIStatusSuccess', itemtype, itemkey, null,null);
1408: RAISE;
1409: END SetWIStatusSuccess;
1410:
1411:

Line 1469: wf_core.context('XDPSTATUS', 'SendWorkitemStatus', itemtype, itemkey, to_char(actid),null);

1465:
1466:
1467: exception
1468: when others then
1469: wf_core.context('XDPSTATUS', 'SendWorkitemStatus', itemtype, itemkey, to_char(actid),null);
1470: raise;
1471: end SendWorkitemStatus;
1472:
1473:

Line 1558: wf_core.context('XDPSTATUS', 'SetFAStatus', itemtype, itemkey, to_char(actid), x_progress);

1554:
1555:
1556: EXCEPTION
1557: WHEN e_SetFAStatusException THEN
1558: wf_core.context('XDPSTATUS', 'SetFAStatus', itemtype, itemkey, to_char(actid), x_progress);
1559: RAISE;
1560: WHEN others THEN
1561: wf_core.context('XDPSTATUS', 'SetFAStatus', itemtype, itemkey, to_char(actid),null);
1562: RAISE;

Line 1561: wf_core.context('XDPSTATUS', 'SetFAStatus', itemtype, itemkey, to_char(actid),null);

1557: WHEN e_SetFAStatusException THEN
1558: wf_core.context('XDPSTATUS', 'SetFAStatus', itemtype, itemkey, to_char(actid), x_progress);
1559: RAISE;
1560: WHEN others THEN
1561: wf_core.context('XDPSTATUS', 'SetFAStatus', itemtype, itemkey, to_char(actid),null);
1562: RAISE;
1563: END SetFAStatus;
1564:
1565:

Line 1576: wf_core.context('XDPSTATUS', 'SetFeExecStatus', itemtype, itemkey, null,null);

1572: null;
1573:
1574: exception
1575: when others then
1576: wf_core.context('XDPSTATUS', 'SetFeExecStatus', itemtype, itemkey, null,null);
1577: raise;
1578: end SetFeExecStatus;
1579:
1580:

Line 1715: wf_core.context('XDPSTATUS', 'SendFeProvStatus', itemtype, itemkey, to_char(actid), x_progress);

1711: end if;
1712:
1713: exception
1714: when e_SendMessageException then
1715: wf_core.context('XDPSTATUS', 'SendFeProvStatus', itemtype, itemkey, to_char(actid), x_progress);
1716: raise;
1717: when others then
1718: wf_core.context('XDPSTATUS', 'SendFeProvStatus', itemtype, itemkey, to_char(actid),null);
1719: raise;

Line 1718: wf_core.context('XDPSTATUS', 'SendFeProvStatus', itemtype, itemkey, to_char(actid),null);

1714: when e_SendMessageException then
1715: wf_core.context('XDPSTATUS', 'SendFeProvStatus', itemtype, itemkey, to_char(actid), x_progress);
1716: raise;
1717: when others then
1718: wf_core.context('XDPSTATUS', 'SendFeProvStatus', itemtype, itemkey, to_char(actid),null);
1719: raise;
1720: end SendFeProvStatus;
1721:
1722:

Line 1752: wf_core.context('XDPSTATUS', 'UpdateFAStatus', null, null, null,null);

1748: END IF;
1749:
1750: EXCEPTION
1751: WHEN others THEN
1752: wf_core.context('XDPSTATUS', 'UpdateFAStatus', null, null, null,null);
1753: RAISE;
1754: END UpdateFAStatus;
1755:
1756:

Line 1767: wf_core.context('XDPSTATUS', 'SendLineStatus', null, null, null,null);

1763: null;
1764:
1765: exception
1766: when others then
1767: wf_core.context('XDPSTATUS', 'SendLineStatus', null, null, null,null);
1768: raise;
1769: end SendLineStatus;
1770:
1771:

Line 1781: wf_core.context('XDPSTATUS', 'SetBundleStatus', null, null, null,null);

1777: null;
1778:
1779: exception
1780: when others then
1781: wf_core.context('XDPSTATUS', 'SetBundleStatus', null, null, null,null);
1782: raise;
1783: end SetBundleStatus;
1784:
1785:

Line 1863: wf_core.context('XDPSTATUS', 'SetLineStatus', null, null, null,null);

1859: END IF;
1860:
1861: EXCEPTION
1862: WHEN others THEN
1863: wf_core.context('XDPSTATUS', 'SetLineStatus', null, null, null,null);
1864: RAISE;
1865: END SetLineStatus;
1866:
1867:

Line 1878: wf_core.context('XDPSTATUS', 'SetPackageStatus', null, null, null,null);

1874: null;
1875:
1876: exception
1877: when others then
1878: wf_core.context('XDPSTATUS', 'SetPackageStatus', null, null, null,null);
1879: raise;
1880: end SetPackageStatus;
1881:
1882:

Line 1907: wf_core.context('XDPSTATUS', 'SaveWorkitem', itemtype, itemkey, to_char(actid), null);

1903: UPDATE_XDP_WORKITEM_STATUS(l_Status, l_WIINstanceID);
1904:
1905: EXCEPTION
1906: WHEN others THEN
1907: wf_core.context('XDPSTATUS', 'SaveWorkitem', itemtype, itemkey, to_char(actid), null);
1908: raise;
1909: END SaveWorkitem;
1910:
1911:

Line 1985: wf_core.context('XDPSTATUS', 'SetFActionStatus',itemtype, itemkey, null, x_progress);

1981:
1982: EXCEPTION
1983: WHEN others THEN
1984: x_progress := 'In XDPSTATUS.SetFActionStatus. Unhandled Exception. Error: ' || SUBSTR(SQLERRM, 1, 1500);
1985: wf_core.context('XDPSTATUS', 'SetFActionStatus',itemtype, itemkey, null, x_progress);
1986: RAISE;
1987: END SetFActionStatus;
1988:
1989:

Line 2052: wf_core.context('XDPSTATUS', 'SetStatusForFA', null, null, null, x_progress);

2048:
2049: EXCEPTION
2050: WHEN others THEN
2051: x_progress := 'In XDPSTATUS.SetStatusForFA. Unhandled Exception. Error: ' || SUBSTR(SQLERRM, 1,1500);
2052: wf_core.context('XDPSTATUS', 'SetStatusForFA', null, null, null, x_progress);
2053: RAISE;
2054: END SetStatusForFA;
2055:
2056: PROCEDURE SetStatusForWI (WorkitemInstanceID IN NUMBER,

Line 2121: wf_core.context('XDPSTATUS', 'SetStatusForWI', null, null, null, x_progress);

2117: WHEN others THEN
2118: IF c_GetWIStat%ISOPEN THEN
2119: CLOSE c_GetWIStat;
2120: END IF;
2121: wf_core.context('XDPSTATUS', 'SetStatusForWI', null, null, null, x_progress);
2122: RAISE;
2123: END SetStatusForWI;
2124:
2125: PROCEDURE SetStatusForLine ( OrderID IN NUMBER,

Line 2298: wf_core.context('XDPSTATUS', 'SetStatusForLine', null, null, null, x_progress);

2294: if c_GetLineID%ISOPEN then
2295: close c_GetLineID;
2296: end if;
2297:
2298: wf_core.context('XDPSTATUS', 'SetStatusForLine', null, null, null, x_progress);
2299: raise;
2300: end SetStatusForLine;
2301:
2302:

Line 2360: wf_core.context('XDPSTATUS', 'SetStatusForOrder', null, null, null, x_progress);

2356: if c_GetOrderStat%ISOPEN then
2357: close c_GetOrderStat;
2358: end if;
2359:
2360: wf_core.context('XDPSTATUS', 'SetStatusForOrder', null, null, null, x_progress);
2361: raise;
2362: end SetStatusForOrder;
2363:
2364:

Line 2383: wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_STATUS', null, null, null, x_progress);

2379: COMMIT;
2380:
2381: EXCEPTION
2382: WHEN others THEN
2383: wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_STATUS', null, null, null, x_progress);
2384: ROLLBACK;
2385: RAISE ;
2386:
2387: END UPDATE_XDP_ORDER_BUNDLE_STATUS ;

Line 2420: wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_STATUS', null, null, null, x_progress);

2416: COMMIT;
2417:
2418: EXCEPTION
2419: WHEN others THEN
2420: wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_STATUS', null, null, null, x_progress);
2421: ROLLBACK;
2422: RAISE ;
2423: END UPDATE_XDP_ORDER_STATUS;
2424:

Line 2456: wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_LINE_STATUS', null, null, null, x_progress);

2452: COMMIT;
2453:
2454: EXCEPTION
2455: WHEN others THEN
2456: wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_LINE_STATUS', null, null, null, x_progress);
2457: ROLLBACK;
2458: RAISE ;
2459: END UPDATE_XDP_ORDER_LINE_STATUS;
2460:

Line 2492: wf_core.context('XDPSTATUS', 'UPDATE_XDP_WORKITEM_STATUS', null, null, null, x_progress);

2488: COMMIT;
2489:
2490: EXCEPTION
2491: WHEN others THEN
2492: wf_core.context('XDPSTATUS', 'UPDATE_XDP_WORKITEM_STATUS', null, null, null, x_progress);
2493: ROLLBACK;
2494: RAISE ;
2495: END UPDATE_XDP_WORKITEM_STATUS;
2496:

Line 2529: wf_core.context('XDPSTATUS', 'UPDATE_XDP_FA_STATUS', null, null, null, x_progress);

2525: COMMIT;
2526:
2527: EXCEPTION
2528: WHEN others THEN
2529: wf_core.context('XDPSTATUS', 'UPDATE_XDP_FA_STATUS', null, null, null, x_progress);
2530: ROLLBACK;
2531: RAISE ;
2532: END UPDATE_XDP_FA_STATUS;
2533:

Line 2708: wf_core.context('XDPSTATUS', 'SetNodeWIStatus', itemtype, itemkey, null,null);

2704:
2705:
2706: EXCEPTION
2707: WHEN others THEN
2708: wf_core.context('XDPSTATUS', 'SetNodeWIStatus', itemtype, itemkey, null,null);
2709: RAISE;
2710: END SetNodeWIStatus;
2711:
2712: PROCEDURE SetNodeLineStatus(itemtype IN VARCHAR2,

Line 2736: wf_core.context('XDPSTATUS', 'SetNodeLineStatus', itemtype, itemkey, null,null);

2732:
2733:
2734: EXCEPTION
2735: WHEN others THEN
2736: wf_core.context('XDPSTATUS', 'SetNodeLineStatus', itemtype, itemkey, null,null);
2737: RAISE;
2738:
2739:
2740: END SetNodeLineStatus;