APPS.XDP_INTERFACES dependencies on FND_MESSAGE

Line 258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

254: ERROR_DESCRIPTION);
255: EXCEPTION
256: WHEN OTHERS THEN
257: return_code := -191266;
258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
261: error_description := FND_MESSAGE.GET;
262: END Process_Order;

Line 259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

255: EXCEPTION
256: WHEN OTHERS THEN
257: return_code := -191266;
258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
261: error_description := FND_MESSAGE.GET;
262: END Process_Order;
263:

Line 260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

256: WHEN OTHERS THEN
257: return_code := -191266;
258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
261: error_description := FND_MESSAGE.GET;
262: END Process_Order;
263:
264: PROCEDURE Process_DRC_Order(

Line 261: error_description := FND_MESSAGE.GET;

257: return_code := -191266;
258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
261: error_description := FND_MESSAGE.GET;
262: END Process_Order;
263:
264: PROCEDURE Process_DRC_Order(
265: p_workitem_id IN NUMBER,

Line 322: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_WORKITEM_ID');

318: x_error_description);
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: x_return_code := SQLCODE;
322: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_WORKITEM_ID');
323: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
324: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
325: x_error_description := FND_MESSAGE.GET;
326: WHEN OTHERS THEN

Line 323: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: x_return_code := SQLCODE;
322: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_WORKITEM_ID');
323: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
324: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
325: x_error_description := FND_MESSAGE.GET;
326: WHEN OTHERS THEN
327: x_return_code := -191266;

Line 324: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

320: WHEN NO_DATA_FOUND THEN
321: x_return_code := SQLCODE;
322: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_WORKITEM_ID');
323: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
324: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
325: x_error_description := FND_MESSAGE.GET;
326: WHEN OTHERS THEN
327: x_return_code := -191266;
328: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 325: x_error_description := FND_MESSAGE.GET;

321: x_return_code := SQLCODE;
322: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_WORKITEM_ID');
323: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
324: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
325: x_error_description := FND_MESSAGE.GET;
326: WHEN OTHERS THEN
327: x_return_code := -191266;
328: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
329: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 328: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

324: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
325: x_error_description := FND_MESSAGE.GET;
326: WHEN OTHERS THEN
327: x_return_code := -191266;
328: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
329: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
330: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
331: x_error_description := FND_MESSAGE.GET;
332: END Process_DRC_Order;

Line 329: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

325: x_error_description := FND_MESSAGE.GET;
326: WHEN OTHERS THEN
327: x_return_code := -191266;
328: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
329: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
330: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
331: x_error_description := FND_MESSAGE.GET;
332: END Process_DRC_Order;
333:

Line 330: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

326: WHEN OTHERS THEN
327: x_return_code := -191266;
328: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
329: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
330: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
331: x_error_description := FND_MESSAGE.GET;
332: END Process_DRC_Order;
333:
334: --

Line 331: x_error_description := FND_MESSAGE.GET;

327: x_return_code := -191266;
328: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
329: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
330: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
331: x_error_description := FND_MESSAGE.GET;
332: END Process_DRC_Order;
333:
334: --
335: -- Private API check if all FAs are ready for cancel for the given order

Line 388: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

384: END IF;
385:
386: EXCEPTION
387: WHEN OTHERS THEN
388: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
389: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.IS_ORDER_TYPE_MAINT_AVAIL');
390: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
391:
392: END IS_ORDER_TYPE_MAINT_AVAIL;

Line 389: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.IS_ORDER_TYPE_MAINT_AVAIL');

385:
386: EXCEPTION
387: WHEN OTHERS THEN
388: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
389: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.IS_ORDER_TYPE_MAINT_AVAIL');
390: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
391:
392: END IS_ORDER_TYPE_MAINT_AVAIL;
393:

Line 390: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

386: EXCEPTION
387: WHEN OTHERS THEN
388: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
389: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.IS_ORDER_TYPE_MAINT_AVAIL');
390: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
391:
392: END IS_ORDER_TYPE_MAINT_AVAIL;
393:
394: --

Line 445: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');

441:
442: EXCEPTION
443: WHEN no_data_found THEN
444: return_code := -191314;
445: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
446: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
447: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
448: error_description := FND_MESSAGE.GET;
449: return;

Line 446: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);

442: EXCEPTION
443: WHEN no_data_found THEN
444: return_code := -191314;
445: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
446: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
447: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
448: error_description := FND_MESSAGE.GET;
449: return;
450: END;

Line 447: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);

443: WHEN no_data_found THEN
444: return_code := -191314;
445: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
446: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
447: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
448: error_description := FND_MESSAGE.GET;
449: return;
450: END;
451:

Line 448: error_description := FND_MESSAGE.GET;

444: return_code := -191314;
445: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
446: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
447: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
448: error_description := FND_MESSAGE.GET;
449: return;
450: END;
451:
452: CANCEL_ORDER(

Line 465: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

461:
462: EXCEPTION
463: WHEN others THEN
464: return_code := -191266;
465: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
466: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
467: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
468: error_description := FND_MESSAGE.GET;
469: END CANCEL_ORDER;

Line 466: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

462: EXCEPTION
463: WHEN others THEN
464: return_code := -191266;
465: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
466: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
467: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
468: error_description := FND_MESSAGE.GET;
469: END CANCEL_ORDER;
470:

Line 467: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

463: WHEN others THEN
464: return_code := -191266;
465: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
466: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
467: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
468: error_description := FND_MESSAGE.GET;
469: END CANCEL_ORDER;
470:
471: --

Line 468: error_description := FND_MESSAGE.GET;

464: return_code := -191266;
465: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
466: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
467: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
468: error_description := FND_MESSAGE.GET;
469: END CANCEL_ORDER;
470:
471: --
472: -- API for upstream ordering system to cancel a service activation order

Line 678: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

674:
675: EXCEPTION
676: when others then
677: return_code := -191266;
678: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
679: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
680: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
681: error_description := FND_MESSAGE.GET;
682:

Line 679: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

675: EXCEPTION
676: when others then
677: return_code := -191266;
678: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
679: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
680: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
681: error_description := FND_MESSAGE.GET;
682:
683: END Cancel_Order;

Line 680: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

676: when others then
677: return_code := -191266;
678: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
679: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
680: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
681: error_description := FND_MESSAGE.GET;
682:
683: END Cancel_Order;
684:

Line 681: error_description := FND_MESSAGE.GET;

677: return_code := -191266;
678: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
679: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
680: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
681: error_description := FND_MESSAGE.GET;
682:
683: END Cancel_Order;
684:
685: --

Line 753: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');

749: END IF;
750: END IF;
751:
752: return_code := -191315;
753: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
754: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
755: error_description := FND_MESSAGE.GET;
756: return;
757:

Line 754: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

750: END IF;
751:
752: return_code := -191315;
753: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
754: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
755: error_description := FND_MESSAGE.GET;
756: return;
757:
758: ELSIF lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') THEN

Line 755: error_description := FND_MESSAGE.GET;

751:
752: return_code := -191315;
753: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
754: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
755: error_description := FND_MESSAGE.GET;
756: return;
757:
758: ELSIF lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') THEN
759:

Line 770: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');

766: END IF;
767: END IF;
768:
769: return_code := -191316;
770: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
771: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
772: error_description := FND_MESSAGE.GET;
773: return;
774:

Line 771: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

767: END IF;
768:
769: return_code := -191316;
770: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
771: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
772: error_description := FND_MESSAGE.GET;
773: return;
774:
775: ELSIF lv_state = 'STANDBY' THEN

Line 772: error_description := FND_MESSAGE.GET;

768:
769: return_code := -191316;
770: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
771: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
772: error_description := FND_MESSAGE.GET;
773: return;
774:
775: ELSIF lv_state = 'STANDBY' THEN
776:

Line 881: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_UNKNOWN');

877: END IF;
878: END IF;
879:
880: return_code := -191317;
881: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_UNKNOWN');
882: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
883: FND_MESSAGE.SET_TOKEN('STATUS', lv_state);
884: error_description := FND_MESSAGE.GET;
885: return;

Line 882: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

878: END IF;
879:
880: return_code := -191317;
881: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_UNKNOWN');
882: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
883: FND_MESSAGE.SET_TOKEN('STATUS', lv_state);
884: error_description := FND_MESSAGE.GET;
885: return;
886: END IF;

Line 883: FND_MESSAGE.SET_TOKEN('STATUS', lv_state);

879:
880: return_code := -191317;
881: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_UNKNOWN');
882: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
883: FND_MESSAGE.SET_TOKEN('STATUS', lv_state);
884: error_description := FND_MESSAGE.GET;
885: return;
886: END IF;
887: commit;

Line 884: error_description := FND_MESSAGE.GET;

880: return_code := -191317;
881: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_UNKNOWN');
882: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
883: FND_MESSAGE.SET_TOKEN('STATUS', lv_state);
884: error_description := FND_MESSAGE.GET;
885: return;
886: END IF;
887: commit;
888:

Line 893: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');

889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN
891: rollback to lv_order_tag;
892: return_code := SQLCODE;
893: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
894: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
895: error_description := FND_MESSAGE.GET;
896:
897: WHEN e_order_type_not_reg THEN

Line 894: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

890: WHEN NO_DATA_FOUND THEN
891: rollback to lv_order_tag;
892: return_code := SQLCODE;
893: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
894: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
895: error_description := FND_MESSAGE.GET;
896:
897: WHEN e_order_type_not_reg THEN
898: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');

Line 895: error_description := FND_MESSAGE.GET;

891: rollback to lv_order_tag;
892: return_code := SQLCODE;
893: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
894: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
895: error_description := FND_MESSAGE.GET;
896:
897: WHEN e_order_type_not_reg THEN
898: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');
899: FND_MESSAGE.SET_TOKEN('ORDNUM', p_sdp_order_id);

Line 898: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');

894: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
895: error_description := FND_MESSAGE.GET;
896:
897: WHEN e_order_type_not_reg THEN
898: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');
899: FND_MESSAGE.SET_TOKEN('ORDNUM', p_sdp_order_id);
900: error_description := FND_MESSAGE.GET;
901:
902: WHEN OTHERS THEN

Line 899: FND_MESSAGE.SET_TOKEN('ORDNUM', p_sdp_order_id);

895: error_description := FND_MESSAGE.GET;
896:
897: WHEN e_order_type_not_reg THEN
898: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');
899: FND_MESSAGE.SET_TOKEN('ORDNUM', p_sdp_order_id);
900: error_description := FND_MESSAGE.GET;
901:
902: WHEN OTHERS THEN
903: rollback to lv_order_tag;

Line 900: error_description := FND_MESSAGE.GET;

896:
897: WHEN e_order_type_not_reg THEN
898: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');
899: FND_MESSAGE.SET_TOKEN('ORDNUM', p_sdp_order_id);
900: error_description := FND_MESSAGE.GET;
901:
902: WHEN OTHERS THEN
903: rollback to lv_order_tag;
904: return_code := -191266;

Line 905: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

901:
902: WHEN OTHERS THEN
903: rollback to lv_order_tag;
904: return_code := -191266;
905: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
906: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
907: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
908: error_description := FND_MESSAGE.GET;
909: END CANCELORDER;

Line 906: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

902: WHEN OTHERS THEN
903: rollback to lv_order_tag;
904: return_code := -191266;
905: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
906: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
907: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
908: error_description := FND_MESSAGE.GET;
909: END CANCELORDER;
910:

Line 907: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

903: rollback to lv_order_tag;
904: return_code := -191266;
905: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
906: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
907: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
908: error_description := FND_MESSAGE.GET;
909: END CANCELORDER;
910:
911: --

Line 908: error_description := FND_MESSAGE.GET;

904: return_code := -191266;
905: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
906: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
907: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
908: error_description := FND_MESSAGE.GET;
909: END CANCELORDER;
910:
911: --
912: -- Private API to cancel order with 'STANDBY' status

Line 1025: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');

1021:
1022: EXCEPTION
1023: WHEN resource_busy OR no_data_found THEN
1024: return_code := -191318;
1025: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1026: FND_MESSAGE.SET_TOKEN('ERROR_STRING', sqlcode||' - '||sqlerrm);
1027: error_description := FND_MESSAGE.GET;
1028: return;
1029: WHEN others THEN

Line 1026: FND_MESSAGE.SET_TOKEN('ERROR_STRING', sqlcode||' - '||sqlerrm);

1022: EXCEPTION
1023: WHEN resource_busy OR no_data_found THEN
1024: return_code := -191318;
1025: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1026: FND_MESSAGE.SET_TOKEN('ERROR_STRING', sqlcode||' - '||sqlerrm);
1027: error_description := FND_MESSAGE.GET;
1028: return;
1029: WHEN others THEN
1030: return_code := -191266;

Line 1027: error_description := FND_MESSAGE.GET;

1023: WHEN resource_busy OR no_data_found THEN
1024: return_code := -191318;
1025: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1026: FND_MESSAGE.SET_TOKEN('ERROR_STRING', sqlcode||' - '||sqlerrm);
1027: error_description := FND_MESSAGE.GET;
1028: return;
1029: WHEN others THEN
1030: return_code := -191266;
1031: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 1031: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

1027: error_description := FND_MESSAGE.GET;
1028: return;
1029: WHEN others THEN
1030: return_code := -191266;
1031: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1032: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1033: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1034: error_description := FND_MESSAGE.GET;
1035: END CANCEL_STANDBY_ORDER ;

Line 1032: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

1028: return;
1029: WHEN others THEN
1030: return_code := -191266;
1031: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1032: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1033: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1034: error_description := FND_MESSAGE.GET;
1035: END CANCEL_STANDBY_ORDER ;
1036:

Line 1033: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

1029: WHEN others THEN
1030: return_code := -191266;
1031: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1032: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1033: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1034: error_description := FND_MESSAGE.GET;
1035: END CANCEL_STANDBY_ORDER ;
1036:
1037: --

Line 1034: error_description := FND_MESSAGE.GET;

1030: return_code := -191266;
1031: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1032: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1033: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1034: error_description := FND_MESSAGE.GET;
1035: END CANCEL_STANDBY_ORDER ;
1036:
1037: --
1038: -- Private API which will remove a canceled order

Line 1223: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');

1219:
1220: EXCEPTION
1221: WHEN e_cannot_cancel_order THEN
1222: return_code := -191318;
1223: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1225: error_description := FND_MESSAGE.GET;
1226: return;
1227: WHEN OTHERS THEN

Line 1224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);

1220: EXCEPTION
1221: WHEN e_cannot_cancel_order THEN
1222: return_code := -191318;
1223: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1225: error_description := FND_MESSAGE.GET;
1226: return;
1227: WHEN OTHERS THEN
1228: return_code := -191266;

Line 1225: error_description := FND_MESSAGE.GET;

1221: WHEN e_cannot_cancel_order THEN
1222: return_code := -191318;
1223: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1225: error_description := FND_MESSAGE.GET;
1226: return;
1227: WHEN OTHERS THEN
1228: return_code := -191266;
1229: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 1229: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

1225: error_description := FND_MESSAGE.GET;
1226: return;
1227: WHEN OTHERS THEN
1228: return_code := -191266;
1229: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1230: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1231: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1232: error_description := FND_MESSAGE.GET;
1233: END CANCEL_READY_ORDER;

Line 1230: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

1226: return;
1227: WHEN OTHERS THEN
1228: return_code := -191266;
1229: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1230: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1231: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1232: error_description := FND_MESSAGE.GET;
1233: END CANCEL_READY_ORDER;
1234:

Line 1231: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

1227: WHEN OTHERS THEN
1228: return_code := -191266;
1229: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1230: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1231: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1232: error_description := FND_MESSAGE.GET;
1233: END CANCEL_READY_ORDER;
1234:
1235:

Line 1232: error_description := FND_MESSAGE.GET;

1228: return_code := -191266;
1229: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1230: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1231: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1232: error_description := FND_MESSAGE.GET;
1233: END CANCEL_READY_ORDER;
1234:
1235:
1236: PROCEDURE CANCEL_INPROGRESS_ORDER

Line 1604: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');

1600:
1601: EXCEPTION
1602: WHEN resource_busy OR no_data_found THEN
1603: return_code := -191318;
1604: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1605: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1606: error_description := FND_MESSAGE.GET;
1607: return;
1608: WHEN e_xdp_order_state_process THEN

Line 1605: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);

1601: EXCEPTION
1602: WHEN resource_busy OR no_data_found THEN
1603: return_code := -191318;
1604: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1605: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1606: error_description := FND_MESSAGE.GET;
1607: return;
1608: WHEN e_xdp_order_state_process THEN
1609: return_code := -191316;

Line 1606: error_description := FND_MESSAGE.GET;

1602: WHEN resource_busy OR no_data_found THEN
1603: return_code := -191318;
1604: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1605: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1606: error_description := FND_MESSAGE.GET;
1607: return;
1608: WHEN e_xdp_order_state_process THEN
1609: return_code := -191316;
1610: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');

Line 1610: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');

1606: error_description := FND_MESSAGE.GET;
1607: return;
1608: WHEN e_xdp_order_state_process THEN
1609: return_code := -191316;
1610: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1611: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1612: error_description := FND_MESSAGE.GET;
1613: rollback to lv_order_tag;
1614: return;

Line 1611: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

1607: return;
1608: WHEN e_xdp_order_state_process THEN
1609: return_code := -191316;
1610: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1611: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1612: error_description := FND_MESSAGE.GET;
1613: rollback to lv_order_tag;
1614: return;
1615: WHEN e_xdp_order_state_cancel THEN

Line 1612: error_description := FND_MESSAGE.GET;

1608: WHEN e_xdp_order_state_process THEN
1609: return_code := -191316;
1610: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1611: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1612: error_description := FND_MESSAGE.GET;
1613: rollback to lv_order_tag;
1614: return;
1615: WHEN e_xdp_order_state_cancel THEN
1616: return_code := -191315;

Line 1617: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');

1613: rollback to lv_order_tag;
1614: return;
1615: WHEN e_xdp_order_state_cancel THEN
1616: return_code := -191315;
1617: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1618: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1619: error_description := FND_MESSAGE.GET;
1620: rollback to lv_order_tag;
1621: return;

Line 1618: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

1614: return;
1615: WHEN e_xdp_order_state_cancel THEN
1616: return_code := -191315;
1617: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1618: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1619: error_description := FND_MESSAGE.GET;
1620: rollback to lv_order_tag;
1621: return;
1622: WHEN e_xdp_fa_state_inprogress THEN

Line 1619: error_description := FND_MESSAGE.GET;

1615: WHEN e_xdp_order_state_cancel THEN
1616: return_code := -191315;
1617: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1618: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1619: error_description := FND_MESSAGE.GET;
1620: rollback to lv_order_tag;
1621: return;
1622: WHEN e_xdp_fa_state_inprogress THEN
1623: return_code := 197010;

Line 1624: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');

1620: rollback to lv_order_tag;
1621: return;
1622: WHEN e_xdp_fa_state_inprogress THEN
1623: return_code := 197010;
1624: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');
1625: FND_MESSAGE.SET_TOKEN('FA_INSTANCE_ID', l_fa_instance_id);
1626: error_description := FND_MESSAGE.GET;
1627: rollback to lv_order_tag;
1628: return;

Line 1625: FND_MESSAGE.SET_TOKEN('FA_INSTANCE_ID', l_fa_instance_id);

1621: return;
1622: WHEN e_xdp_fa_state_inprogress THEN
1623: return_code := 197010;
1624: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');
1625: FND_MESSAGE.SET_TOKEN('FA_INSTANCE_ID', l_fa_instance_id);
1626: error_description := FND_MESSAGE.GET;
1627: rollback to lv_order_tag;
1628: return;
1629: WHEN OTHERS THEN

Line 1626: error_description := FND_MESSAGE.GET;

1622: WHEN e_xdp_fa_state_inprogress THEN
1623: return_code := 197010;
1624: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');
1625: FND_MESSAGE.SET_TOKEN('FA_INSTANCE_ID', l_fa_instance_id);
1626: error_description := FND_MESSAGE.GET;
1627: rollback to lv_order_tag;
1628: return;
1629: WHEN OTHERS THEN
1630: return_code := -191266;

Line 1631: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

1627: rollback to lv_order_tag;
1628: return;
1629: WHEN OTHERS THEN
1630: return_code := -191266;
1631: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1632: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1633: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1634: error_description := FND_MESSAGE.GET;
1635: END CANCEL_INPROGRESS_ORDER;

Line 1632: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

1628: return;
1629: WHEN OTHERS THEN
1630: return_code := -191266;
1631: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1632: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1633: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1634: error_description := FND_MESSAGE.GET;
1635: END CANCEL_INPROGRESS_ORDER;
1636:

Line 1633: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

1629: WHEN OTHERS THEN
1630: return_code := -191266;
1631: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1632: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1633: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1634: error_description := FND_MESSAGE.GET;
1635: END CANCEL_INPROGRESS_ORDER;
1636:
1637: --

Line 1634: error_description := FND_MESSAGE.GET;

1630: return_code := -191266;
1631: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1632: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1633: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1634: error_description := FND_MESSAGE.GET;
1635: END CANCEL_INPROGRESS_ORDER;
1636:
1637: --
1638: -- Private API which will remove a canceled order from the processor queue

Line 1699: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');

1695:
1696: -- Order has already been canceled
1697: IF lv_state IN ('CANCELED','ABORTED') THEN
1698: return_code := -191315;
1699: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1700: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1701: error_description := FND_MESSAGE.GET;
1702: rollback to lv_order_tag;
1703: return;

Line 1700: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

1696: -- Order has already been canceled
1697: IF lv_state IN ('CANCELED','ABORTED') THEN
1698: return_code := -191315;
1699: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1700: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1701: error_description := FND_MESSAGE.GET;
1702: rollback to lv_order_tag;
1703: return;
1704:

Line 1701: error_description := FND_MESSAGE.GET;

1697: IF lv_state IN ('CANCELED','ABORTED') THEN
1698: return_code := -191315;
1699: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1700: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1701: error_description := FND_MESSAGE.GET;
1702: rollback to lv_order_tag;
1703: return;
1704:
1705: -- Order has already been completed

Line 1709: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');

1705: -- Order has already been completed
1706:
1707: ELSIF lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') THEN
1708: return_code := -191316;
1709: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1710: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1711: error_description := FND_MESSAGE.GET;
1712: rollback to lv_order_tag;
1713: return;

Line 1710: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

1706:
1707: ELSIF lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') THEN
1708: return_code := -191316;
1709: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1710: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1711: error_description := FND_MESSAGE.GET;
1712: rollback to lv_order_tag;
1713: return;
1714:

Line 1711: error_description := FND_MESSAGE.GET;

1707: ELSIF lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') THEN
1708: return_code := -191316;
1709: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1710: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1711: error_description := FND_MESSAGE.GET;
1712: rollback to lv_order_tag;
1713: return;
1714:
1715: -- Order has already been started

Line 1775: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');

1771: /*
1772: error_description := 'Error: Can not remove order from queue. '||
1773: lv_error;
1774: */
1775: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1776: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1777: error_description := FND_MESSAGE.GET;
1778: return;
1779: END IF;

Line 1776: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);

1772: error_description := 'Error: Can not remove order from queue. '||
1773: lv_error;
1774: */
1775: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1776: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1777: error_description := FND_MESSAGE.GET;
1778: return;
1779: END IF;
1780: END IF;

Line 1777: error_description := FND_MESSAGE.GET;

1773: lv_error;
1774: */
1775: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
1776: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
1777: error_description := FND_MESSAGE.GET;
1778: return;
1779: END IF;
1780: END IF;
1781:

Line 1866: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');

1862: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE ;
1863:
1864: if lv_state IN ('CANCELED','ABORTED') then
1865: return_code := -191315;
1866: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1867: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1868: error_description := FND_MESSAGE.GET;
1869: return;
1870: elsif lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') then

Line 1867: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

1863:
1864: if lv_state IN ('CANCELED','ABORTED') then
1865: return_code := -191315;
1866: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1867: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1868: error_description := FND_MESSAGE.GET;
1869: return;
1870: elsif lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') then
1871: rollback to lv_order_tag2;

Line 1868: error_description := FND_MESSAGE.GET;

1864: if lv_state IN ('CANCELED','ABORTED') then
1865: return_code := -191315;
1866: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');
1867: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1868: error_description := FND_MESSAGE.GET;
1869: return;
1870: elsif lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') then
1871: rollback to lv_order_tag2;
1872: return_code := -191316;

Line 1873: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');

1869: return;
1870: elsif lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') then
1871: rollback to lv_order_tag2;
1872: return_code := -191316;
1873: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1874: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1875: error_description := FND_MESSAGE.GET;
1876: return;
1877: else

Line 1874: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

1870: elsif lv_state IN ('SUCCESS','SUCCESS_WITH_OVERRIDE') then
1871: rollback to lv_order_tag2;
1872: return_code := -191316;
1873: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1874: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1875: error_description := FND_MESSAGE.GET;
1876: return;
1877: else
1878: update xdp_order_headers

Line 1875: error_description := FND_MESSAGE.GET;

1871: rollback to lv_order_tag2;
1872: return_code := -191316;
1873: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_PROCESS');
1874: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1875: error_description := FND_MESSAGE.GET;
1876: return;
1877: else
1878: update xdp_order_headers
1879: set last_updated_by = FND_GLOBAL.USER_ID,

Line 1898: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

1894:
1895: EXCEPTION
1896: WHEN OTHERS THEN
1897: return_code := -191266;
1898: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1899: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1900: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1901: error_description := FND_MESSAGE.GET;
1902: END Remove_Order_From_ProcessorQ;

Line 1899: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

1895: EXCEPTION
1896: WHEN OTHERS THEN
1897: return_code := -191266;
1898: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1899: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1900: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1901: error_description := FND_MESSAGE.GET;
1902: END Remove_Order_From_ProcessorQ;
1903:

Line 1900: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

1896: WHEN OTHERS THEN
1897: return_code := -191266;
1898: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1899: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1900: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1901: error_description := FND_MESSAGE.GET;
1902: END Remove_Order_From_ProcessorQ;
1903:
1904:

Line 1901: error_description := FND_MESSAGE.GET;

1897: return_code := -191266;
1898: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1899: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1900: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1901: error_description := FND_MESSAGE.GET;
1902: END Remove_Order_From_ProcessorQ;
1903:
1904:
1905: --

Line 1984: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

1980:
1981: EXCEPTION
1982: WHEN OTHERS THEN
1983: return_code := -191266;
1984: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1985: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1986: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1987: error_description := FND_MESSAGE.GET;
1988: END Remove_WI_From_Q;

Line 1985: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

1981: EXCEPTION
1982: WHEN OTHERS THEN
1983: return_code := -191266;
1984: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1985: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1986: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1987: error_description := FND_MESSAGE.GET;
1988: END Remove_WI_From_Q;
1989:

Line 1986: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

1982: WHEN OTHERS THEN
1983: return_code := -191266;
1984: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1985: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1986: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1987: error_description := FND_MESSAGE.GET;
1988: END Remove_WI_From_Q;
1989:
1990:

Line 1987: error_description := FND_MESSAGE.GET;

1983: return_code := -191266;
1984: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
1985: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
1986: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
1987: error_description := FND_MESSAGE.GET;
1988: END Remove_WI_From_Q;
1989:
1990:
1991: --

Line 2102: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: return_code := -191266;
2102: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2103: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2104: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2105: error_description := FND_MESSAGE.GET;
2106: END Remove_FA_From_Q;

Line 2103: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: return_code := -191266;
2102: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2103: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2104: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2105: error_description := FND_MESSAGE.GET;
2106: END Remove_FA_From_Q;
2107:

Line 2104: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2100: WHEN OTHERS THEN
2101: return_code := -191266;
2102: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2103: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2104: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2105: error_description := FND_MESSAGE.GET;
2106: END Remove_FA_From_Q;
2107:
2108: --

Line 2105: error_description := FND_MESSAGE.GET;

2101: return_code := -191266;
2102: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2103: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2104: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2105: error_description := FND_MESSAGE.GET;
2106: END Remove_FA_From_Q;
2107:
2108: --
2109: -- Private API which will abort all workflow processes

Line 2160: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2156:
2157: exception
2158: when others then
2159: return_code := -191266;
2160: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2161: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2162: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2163: error_description := FND_MESSAGE.GET;
2164:

Line 2161: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2157: exception
2158: when others then
2159: return_code := -191266;
2160: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2161: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2162: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2163: error_description := FND_MESSAGE.GET;
2164:
2165: END Abort_Order_Workflows;

Line 2162: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2158: when others then
2159: return_code := -191266;
2160: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2161: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2162: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2163: error_description := FND_MESSAGE.GET;
2164:
2165: END Abort_Order_Workflows;
2166:

Line 2163: error_description := FND_MESSAGE.GET;

2159: return_code := -191266;
2160: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2161: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2162: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2163: error_description := FND_MESSAGE.GET;
2164:
2165: END Abort_Order_Workflows;
2166:
2167:

Line 2253: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');

2249: return_code := SQLCODE;
2250: /*
2251: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2252: */
2253: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2254: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2255: error_description := FND_MESSAGE.GET;
2256: WHEN OTHERS THEN
2257: return_code := -191266;

Line 2254: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

2250: /*
2251: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2252: */
2253: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2254: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2255: error_description := FND_MESSAGE.GET;
2256: WHEN OTHERS THEN
2257: return_code := -191266;
2258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2255: error_description := FND_MESSAGE.GET;

2251: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2252: */
2253: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2254: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2255: error_description := FND_MESSAGE.GET;
2256: WHEN OTHERS THEN
2257: return_code := -191266;
2258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 2258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2254: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2255: error_description := FND_MESSAGE.GET;
2256: WHEN OTHERS THEN
2257: return_code := -191266;
2258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2261: error_description := FND_MESSAGE.GET;
2262:

Line 2259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2255: error_description := FND_MESSAGE.GET;
2256: WHEN OTHERS THEN
2257: return_code := -191266;
2258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2261: error_description := FND_MESSAGE.GET;
2262:
2263: END Get_Order_Status;

Line 2260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2256: WHEN OTHERS THEN
2257: return_code := -191266;
2258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2261: error_description := FND_MESSAGE.GET;
2262:
2263: END Get_Order_Status;
2264:

Line 2261: error_description := FND_MESSAGE.GET;

2257: return_code := -191266;
2258: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2259: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2260: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2261: error_description := FND_MESSAGE.GET;
2262:
2263: END Get_Order_Status;
2264:
2265: /*

Line 2301: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');

2297:
2298: EXCEPTION
2299: WHEN NO_DATA_FOUND THEN
2300: x_return_code := SQLCODE;
2301: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2302: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2303: x_error_description := FND_MESSAGE.GET;
2304: WHEN OTHERS THEN
2305: x_return_code := -191266;

Line 2302: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

2298: EXCEPTION
2299: WHEN NO_DATA_FOUND THEN
2300: x_return_code := SQLCODE;
2301: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2302: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2303: x_error_description := FND_MESSAGE.GET;
2304: WHEN OTHERS THEN
2305: x_return_code := -191266;
2306: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2303: x_error_description := FND_MESSAGE.GET;

2299: WHEN NO_DATA_FOUND THEN
2300: x_return_code := SQLCODE;
2301: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2302: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2303: x_error_description := FND_MESSAGE.GET;
2304: WHEN OTHERS THEN
2305: x_return_code := -191266;
2306: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2307: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 2306: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2302: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2303: x_error_description := FND_MESSAGE.GET;
2304: WHEN OTHERS THEN
2305: x_return_code := -191266;
2306: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2307: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2308: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2309: x_error_description := FND_MESSAGE.GET;
2310: END Get_Order_Status;

Line 2307: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2303: x_error_description := FND_MESSAGE.GET;
2304: WHEN OTHERS THEN
2305: x_return_code := -191266;
2306: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2307: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2308: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2309: x_error_description := FND_MESSAGE.GET;
2310: END Get_Order_Status;
2311:

Line 2308: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2304: WHEN OTHERS THEN
2305: x_return_code := -191266;
2306: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2307: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2308: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2309: x_error_description := FND_MESSAGE.GET;
2310: END Get_Order_Status;
2311:
2312: /*

Line 2309: x_error_description := FND_MESSAGE.GET;

2305: x_return_code := -191266;
2306: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2307: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2308: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2309: x_error_description := FND_MESSAGE.GET;
2310: END Get_Order_Status;
2311:
2312: /*
2313: * Overload Function

Line 2351: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');

2347:
2348: EXCEPTION
2349: WHEN NO_DATA_FOUND THEN
2350: x_return_code := -191314;
2351: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
2352: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2353: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
2354: x_error_description := FND_MESSAGE.GET;
2355: WHEN OTHERS THEN

Line 2352: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);

2348: EXCEPTION
2349: WHEN NO_DATA_FOUND THEN
2350: x_return_code := -191314;
2351: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
2352: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2353: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
2354: x_error_description := FND_MESSAGE.GET;
2355: WHEN OTHERS THEN
2356: x_return_code := -191266;

Line 2353: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);

2349: WHEN NO_DATA_FOUND THEN
2350: x_return_code := -191314;
2351: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
2352: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2353: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
2354: x_error_description := FND_MESSAGE.GET;
2355: WHEN OTHERS THEN
2356: x_return_code := -191266;
2357: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2354: x_error_description := FND_MESSAGE.GET;

2350: x_return_code := -191314;
2351: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
2352: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2353: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
2354: x_error_description := FND_MESSAGE.GET;
2355: WHEN OTHERS THEN
2356: x_return_code := -191266;
2357: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2358: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 2357: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2353: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
2354: x_error_description := FND_MESSAGE.GET;
2355: WHEN OTHERS THEN
2356: x_return_code := -191266;
2357: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2358: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2359: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2360: x_error_description := FND_MESSAGE.GET;
2361: END Get_Order_Status;

Line 2358: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2354: x_error_description := FND_MESSAGE.GET;
2355: WHEN OTHERS THEN
2356: x_return_code := -191266;
2357: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2358: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2359: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2360: x_error_description := FND_MESSAGE.GET;
2361: END Get_Order_Status;
2362:

Line 2359: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2355: WHEN OTHERS THEN
2356: x_return_code := -191266;
2357: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2358: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2359: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2360: x_error_description := FND_MESSAGE.GET;
2361: END Get_Order_Status;
2362:
2363: /*

Line 2360: x_error_description := FND_MESSAGE.GET;

2356: x_return_code := -191266;
2357: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2358: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2359: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2360: x_error_description := FND_MESSAGE.GET;
2361: END Get_Order_Status;
2362:
2363: /*
2364: * A light-weight API for upstream ordering system to retrieve

Line 2399: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');

2395:
2396: EXCEPTION
2397: WHEN NO_DATA_FOUND THEN
2398: x_return_code := -191323;
2399: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2400: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2401: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_sdp_order_id);
2402: x_error_description := FND_MESSAGE.GET;
2403: WHEN OTHERS THEN

Line 2400: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);

2396: EXCEPTION
2397: WHEN NO_DATA_FOUND THEN
2398: x_return_code := -191323;
2399: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2400: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2401: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_sdp_order_id);
2402: x_error_description := FND_MESSAGE.GET;
2403: WHEN OTHERS THEN
2404: x_return_code := -191266;

Line 2401: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_sdp_order_id);

2397: WHEN NO_DATA_FOUND THEN
2398: x_return_code := -191323;
2399: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2400: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2401: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_sdp_order_id);
2402: x_error_description := FND_MESSAGE.GET;
2403: WHEN OTHERS THEN
2404: x_return_code := -191266;
2405: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2402: x_error_description := FND_MESSAGE.GET;

2398: x_return_code := -191323;
2399: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2400: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2401: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_sdp_order_id);
2402: x_error_description := FND_MESSAGE.GET;
2403: WHEN OTHERS THEN
2404: x_return_code := -191266;
2405: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 2405: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2401: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_sdp_order_id);
2402: x_error_description := FND_MESSAGE.GET;
2403: WHEN OTHERS THEN
2404: x_return_code := -191266;
2405: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2407: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2408: x_error_description := FND_MESSAGE.GET;
2409: END Get_Line_Status;

Line 2406: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2402: x_error_description := FND_MESSAGE.GET;
2403: WHEN OTHERS THEN
2404: x_return_code := -191266;
2405: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2407: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2408: x_error_description := FND_MESSAGE.GET;
2409: END Get_Line_Status;
2410:

Line 2407: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2403: WHEN OTHERS THEN
2404: x_return_code := -191266;
2405: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2407: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2408: x_error_description := FND_MESSAGE.GET;
2409: END Get_Line_Status;
2410:
2411: /*

Line 2408: x_error_description := FND_MESSAGE.GET;

2404: x_return_code := -191266;
2405: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2407: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2408: x_error_description := FND_MESSAGE.GET;
2409: END Get_Line_Status;
2410:
2411: /*
2412: * Overload Function

Line 2453: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');

2449:
2450: EXCEPTION
2451: WHEN NO_DATA_FOUND THEN
2452: x_return_code := -191323;
2453: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2454: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2455: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2456: x_error_description := FND_MESSAGE.GET;
2457: WHEN OTHERS THEN

Line 2454: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);

2450: EXCEPTION
2451: WHEN NO_DATA_FOUND THEN
2452: x_return_code := -191323;
2453: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2454: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2455: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2456: x_error_description := FND_MESSAGE.GET;
2457: WHEN OTHERS THEN
2458: x_return_code := -191266;

Line 2455: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);

2451: WHEN NO_DATA_FOUND THEN
2452: x_return_code := -191323;
2453: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2454: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2455: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2456: x_error_description := FND_MESSAGE.GET;
2457: WHEN OTHERS THEN
2458: x_return_code := -191266;
2459: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2456: x_error_description := FND_MESSAGE.GET;

2452: x_return_code := -191323;
2453: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_LINE_NOTEXISTS');
2454: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_number);
2455: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2456: x_error_description := FND_MESSAGE.GET;
2457: WHEN OTHERS THEN
2458: x_return_code := -191266;
2459: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2460: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 2459: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2455: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2456: x_error_description := FND_MESSAGE.GET;
2457: WHEN OTHERS THEN
2458: x_return_code := -191266;
2459: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2460: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2461: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2462: x_error_description := FND_MESSAGE.GET;
2463: END Get_Line_Status;

Line 2460: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2456: x_error_description := FND_MESSAGE.GET;
2457: WHEN OTHERS THEN
2458: x_return_code := -191266;
2459: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2460: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2461: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2462: x_error_description := FND_MESSAGE.GET;
2463: END Get_Line_Status;
2464:

Line 2461: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2457: WHEN OTHERS THEN
2458: x_return_code := -191266;
2459: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2460: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2461: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2462: x_error_description := FND_MESSAGE.GET;
2463: END Get_Line_Status;
2464:
2465: /*

Line 2462: x_error_description := FND_MESSAGE.GET;

2458: x_return_code := -191266;
2459: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2460: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2461: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2462: x_error_description := FND_MESSAGE.GET;
2463: END Get_Line_Status;
2464:
2465: /*
2466: * Overload Function

Line 2514: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_MULTIMATCH');

2510: x_state := null ;
2511: x_completion_date := NULL;
2512: x_cancellation_date := NULL;
2513: x_return_code := -191325;
2514: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_MULTIMATCH');
2515: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2516: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2517: x_error_description := FND_MESSAGE.GET;
2518: return;

Line 2515: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);

2511: x_completion_date := NULL;
2512: x_cancellation_date := NULL;
2513: x_return_code := -191325;
2514: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_MULTIMATCH');
2515: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2516: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2517: x_error_description := FND_MESSAGE.GET;
2518: return;
2519: END IF;

Line 2516: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);

2512: x_cancellation_date := NULL;
2513: x_return_code := -191325;
2514: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_MULTIMATCH');
2515: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2516: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2517: x_error_description := FND_MESSAGE.GET;
2518: return;
2519: END IF;
2520: END LOOP;

Line 2517: x_error_description := FND_MESSAGE.GET;

2513: x_return_code := -191325;
2514: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_MULTIMATCH');
2515: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2516: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2517: x_error_description := FND_MESSAGE.GET;
2518: return;
2519: END IF;
2520: END LOOP;
2521:

Line 2524: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_NOTEXISTS');

2520: END LOOP;
2521:
2522: IF lv_found = 'N' THEN
2523: x_return_code := -191325;
2524: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_NOTEXISTS');
2525: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2526: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2527: x_error_description := FND_MESSAGE.GET;
2528: return;

Line 2525: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);

2521:
2522: IF lv_found = 'N' THEN
2523: x_return_code := -191325;
2524: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_NOTEXISTS');
2525: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2526: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2527: x_error_description := FND_MESSAGE.GET;
2528: return;
2529: END IF;

Line 2526: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);

2522: IF lv_found = 'N' THEN
2523: x_return_code := -191325;
2524: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_NOTEXISTS');
2525: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2526: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2527: x_error_description := FND_MESSAGE.GET;
2528: return;
2529: END IF;
2530:

Line 2527: x_error_description := FND_MESSAGE.GET;

2523: x_return_code := -191325;
2524: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINE_NAME_NOTEXISTS');
2525: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
2526: FND_MESSAGE.SET_TOKEN('LINE_NAME', p_line_item_name);
2527: x_error_description := FND_MESSAGE.GET;
2528: return;
2529: END IF;
2530:
2531: EXCEPTION

Line 2534: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2530:
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: x_return_code := -191266;
2534: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2535: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2536: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2537: x_error_description := FND_MESSAGE.GET;
2538: END Get_Line_Status;

Line 2535: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: x_return_code := -191266;
2534: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2535: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2536: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2537: x_error_description := FND_MESSAGE.GET;
2538: END Get_Line_Status;
2539:

Line 2536: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2532: WHEN OTHERS THEN
2533: x_return_code := -191266;
2534: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2535: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2536: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2537: x_error_description := FND_MESSAGE.GET;
2538: END Get_Line_Status;
2539:
2540: --

Line 2537: x_error_description := FND_MESSAGE.GET;

2533: x_return_code := -191266;
2534: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2535: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2536: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2537: x_error_description := FND_MESSAGE.GET;
2538: END Get_Line_Status;
2539:
2540: --
2541: -- API for upstream ordering system to put a service activation

Line 2564: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');

2560: return_code := SQLCODE;
2561: /*
2562: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2563: */
2564: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2565: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2566: error_description := FND_MESSAGE.GET;
2567: WHEN OTHERS THEN
2568: return_code := -191266;

Line 2565: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

2561: /*
2562: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2563: */
2564: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2565: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2566: error_description := FND_MESSAGE.GET;
2567: WHEN OTHERS THEN
2568: return_code := -191266;
2569: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2566: error_description := FND_MESSAGE.GET;

2562: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2563: */
2564: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2565: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2566: error_description := FND_MESSAGE.GET;
2567: WHEN OTHERS THEN
2568: return_code := -191266;
2569: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2570: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 2569: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2565: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2566: error_description := FND_MESSAGE.GET;
2567: WHEN OTHERS THEN
2568: return_code := -191266;
2569: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2570: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2571: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2572: error_description := FND_MESSAGE.GET;
2573: END Hold_Order;

Line 2570: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2566: error_description := FND_MESSAGE.GET;
2567: WHEN OTHERS THEN
2568: return_code := -191266;
2569: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2570: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2571: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2572: error_description := FND_MESSAGE.GET;
2573: END Hold_Order;
2574:

Line 2571: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2567: WHEN OTHERS THEN
2568: return_code := -191266;
2569: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2570: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2571: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2572: error_description := FND_MESSAGE.GET;
2573: END Hold_Order;
2574:
2575: --

Line 2572: error_description := FND_MESSAGE.GET;

2568: return_code := -191266;
2569: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2570: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2571: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2572: error_description := FND_MESSAGE.GET;
2573: END Hold_Order;
2574:
2575: --
2576: -- API for upstream ordering system to resume a service activation order

Line 2600: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');

2596: return_code := SQLCODE;
2597: /*
2598: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2599: */
2600: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2601: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2602: error_description := FND_MESSAGE.GET;
2603: WHEN OTHERS THEN
2604: return_code := -191266;

Line 2601: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);

2597: /*
2598: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2599: */
2600: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2601: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2602: error_description := FND_MESSAGE.GET;
2603: WHEN OTHERS THEN
2604: return_code := -191266;
2605: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2602: error_description := FND_MESSAGE.GET;

2598: error_description := 'Error: Order ID '||p_sdp_order_id||' does not exist in SFM.';
2599: */
2600: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
2601: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2602: error_description := FND_MESSAGE.GET;
2603: WHEN OTHERS THEN
2604: return_code := -191266;
2605: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2606: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

Line 2605: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2601: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
2602: error_description := FND_MESSAGE.GET;
2603: WHEN OTHERS THEN
2604: return_code := -191266;
2605: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2606: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2607: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2608: error_description := FND_MESSAGE.GET;
2609: END Resume_Order;

Line 2606: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

2602: error_description := FND_MESSAGE.GET;
2603: WHEN OTHERS THEN
2604: return_code := -191266;
2605: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2606: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2607: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2608: error_description := FND_MESSAGE.GET;
2609: END Resume_Order;
2610:

Line 2607: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2603: WHEN OTHERS THEN
2604: return_code := -191266;
2605: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2606: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2607: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2608: error_description := FND_MESSAGE.GET;
2609: END Resume_Order;
2610:
2611: PROCEDURE Find_XDP_SCHEMA

Line 2608: error_description := FND_MESSAGE.GET;

2604: return_code := -191266;
2605: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2606: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
2607: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2608: error_description := FND_MESSAGE.GET;
2609: END Resume_Order;
2610:
2611: PROCEDURE Find_XDP_SCHEMA
2612: IS

Line 2652: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2648: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;
2649: EXCEPTION
2650: WHEN OTHERS THEN
2651: x_return_code := -191266;
2652: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2653: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_Value');
2654: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2655: x_error_description := FND_MESSAGE.GET;
2656: END Get_Order_Param_Value;

Line 2653: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_Value');

2649: EXCEPTION
2650: WHEN OTHERS THEN
2651: x_return_code := -191266;
2652: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2653: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_Value');
2654: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2655: x_error_description := FND_MESSAGE.GET;
2656: END Get_Order_Param_Value;
2657:

Line 2654: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2650: WHEN OTHERS THEN
2651: x_return_code := -191266;
2652: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2653: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_Value');
2654: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2655: x_error_description := FND_MESSAGE.GET;
2656: END Get_Order_Param_Value;
2657:
2658:

Line 2655: x_error_description := FND_MESSAGE.GET;

2651: x_return_code := -191266;
2652: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2653: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_Value');
2654: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2655: x_error_description := FND_MESSAGE.GET;
2656: END Get_Order_Param_Value;
2657:
2658:
2659:

Line 2673: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2669: RETURN XDP_ENGINE.Get_Order_Param_List(p_order_id);
2670: EXCEPTION
2671: WHEN OTHERS THEN
2672: x_return_code := -191266;
2673: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2674: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_List');
2675: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2676: x_error_description := FND_MESSAGE.GET;
2677: END Get_Order_Param_List;

Line 2674: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_List');

2670: EXCEPTION
2671: WHEN OTHERS THEN
2672: x_return_code := -191266;
2673: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2674: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_List');
2675: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2676: x_error_description := FND_MESSAGE.GET;
2677: END Get_Order_Param_List;
2678:

Line 2675: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2671: WHEN OTHERS THEN
2672: x_return_code := -191266;
2673: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2674: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_List');
2675: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2676: x_error_description := FND_MESSAGE.GET;
2677: END Get_Order_Param_List;
2678:
2679: PROCEDURE Get_Line_Param_Value(

Line 2676: x_error_description := FND_MESSAGE.GET;

2672: x_return_code := -191266;
2673: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2674: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Order_Param_List');
2675: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2676: x_error_description := FND_MESSAGE.GET;
2677: END Get_Order_Param_List;
2678:
2679: PROCEDURE Get_Line_Param_Value(
2680: p_order_id IN NUMBER,

Line 2702: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2698: x_return_code := 0;
2699: EXCEPTION
2700: WHEN OTHERS THEN
2701: x_return_code := -191266;
2702: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2703: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Param_Value');
2704: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2705: x_error_description := FND_MESSAGE.GET;
2706: END Get_Line_Param_Value;

Line 2703: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Param_Value');

2699: EXCEPTION
2700: WHEN OTHERS THEN
2701: x_return_code := -191266;
2702: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2703: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Param_Value');
2704: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2705: x_error_description := FND_MESSAGE.GET;
2706: END Get_Line_Param_Value;
2707:

Line 2704: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2700: WHEN OTHERS THEN
2701: x_return_code := -191266;
2702: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2703: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Param_Value');
2704: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2705: x_error_description := FND_MESSAGE.GET;
2706: END Get_Line_Param_Value;
2707:
2708: PROCEDURE Get_Ord_Fulfillment_Status(

Line 2705: x_error_description := FND_MESSAGE.GET;

2701: x_return_code := -191266;
2702: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2703: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Param_Value');
2704: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2705: x_error_description := FND_MESSAGE.GET;
2706: END Get_Line_Param_Value;
2707:
2708: PROCEDURE Get_Ord_Fulfillment_Status(
2709: p_order_id IN VARCHAR2,

Line 2733: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2729: x_return_code := 0;
2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: x_return_code := -191266;
2733: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2734: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Ord_Fulfillment_Status');
2735: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2736: x_error_description := FND_MESSAGE.GET;
2737: END Get_Ord_Fulfillment_Status;

Line 2734: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Ord_Fulfillment_Status');

2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: x_return_code := -191266;
2733: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2734: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Ord_Fulfillment_Status');
2735: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2736: x_error_description := FND_MESSAGE.GET;
2737: END Get_Ord_Fulfillment_Status;
2738:

Line 2735: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2731: WHEN OTHERS THEN
2732: x_return_code := -191266;
2733: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2734: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Ord_Fulfillment_Status');
2735: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2736: x_error_description := FND_MESSAGE.GET;
2737: END Get_Ord_Fulfillment_Status;
2738:
2739: PROCEDURE Set_Ord_Fulfillment_Status(

Line 2736: x_error_description := FND_MESSAGE.GET;

2732: x_return_code := -191266;
2733: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2734: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Ord_Fulfillment_Status');
2735: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2736: x_error_description := FND_MESSAGE.GET;
2737: END Get_Ord_Fulfillment_Status;
2738:
2739: PROCEDURE Set_Ord_Fulfillment_Status(
2740: p_order_id IN NUMBER,

Line 2760: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

2756: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;
2757: EXCEPTION
2758: WHEN OTHERS THEN
2759: x_return_code := -191266;
2760: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2761: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Ord_Fulfillment_Status');
2762: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2763: x_error_description := FND_MESSAGE.GET;
2764: END Set_Ord_Fulfillment_Status;

Line 2761: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Ord_Fulfillment_Status');

2757: EXCEPTION
2758: WHEN OTHERS THEN
2759: x_return_code := -191266;
2760: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2761: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Ord_Fulfillment_Status');
2762: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2763: x_error_description := FND_MESSAGE.GET;
2764: END Set_Ord_Fulfillment_Status;
2765:

Line 2762: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

2758: WHEN OTHERS THEN
2759: x_return_code := -191266;
2760: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2761: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Ord_Fulfillment_Status');
2762: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2763: x_error_description := FND_MESSAGE.GET;
2764: END Set_Ord_Fulfillment_Status;
2765:
2766:

Line 2763: x_error_description := FND_MESSAGE.GET;

2759: x_return_code := -191266;
2760: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
2761: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Ord_Fulfillment_Status');
2762: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
2763: x_error_description := FND_MESSAGE.GET;
2764: END Set_Ord_Fulfillment_Status;
2765:
2766:
2767: /*

Line 3015: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3011:
3012: EXCEPTION
3013: WHEN OTHERS THEN
3014: return_code := -191266;
3015: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3016: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.PROCESS_OLD_ORDER');
3017: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3018: error_description := FND_MESSAGE.GET;
3019: END Process_Old_Order;

Line 3016: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.PROCESS_OLD_ORDER');

3012: EXCEPTION
3013: WHEN OTHERS THEN
3014: return_code := -191266;
3015: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3016: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.PROCESS_OLD_ORDER');
3017: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3018: error_description := FND_MESSAGE.GET;
3019: END Process_Old_Order;
3020:

Line 3017: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3013: WHEN OTHERS THEN
3014: return_code := -191266;
3015: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3016: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.PROCESS_OLD_ORDER');
3017: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3018: error_description := FND_MESSAGE.GET;
3019: END Process_Old_Order;
3020:
3021: /*

Line 3018: error_description := FND_MESSAGE.GET;

3014: return_code := -191266;
3015: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3016: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.PROCESS_OLD_ORDER');
3017: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3018: error_description := FND_MESSAGE.GET;
3019: END Process_Old_Order;
3020:
3021: /*
3022: The following procedures are used to retreive order information.

Line 3073: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');

3069: END;
3070: EXCEPTION
3071: WHEN NO_DATA_FOUND THEN
3072: x_return_code := SQLCODE;
3073: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
3074: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3075: x_error_description := FND_MESSAGE.GET;
3076: END Get_Order_Status;
3077:

Line 3074: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);

3070: EXCEPTION
3071: WHEN NO_DATA_FOUND THEN
3072: x_return_code := SQLCODE;
3073: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
3074: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3075: x_error_description := FND_MESSAGE.GET;
3076: END Get_Order_Status;
3077:
3078: /*

Line 3075: x_error_description := FND_MESSAGE.GET;

3071: WHEN NO_DATA_FOUND THEN
3072: x_return_code := SQLCODE;
3073: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
3074: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3075: x_error_description := FND_MESSAGE.GET;
3076: END Get_Order_Status;
3077:
3078: /*
3079: This is a private procedure used by Get_Order_Details in this package

Line 3217: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');

3213: END LOOP;
3214: EXCEPTION
3215: WHEN NO_DATA_FOUND THEN
3216: x_return_code := SQLCODE;
3217: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
3218: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3219: x_error_description := FND_MESSAGE.GET;
3220: END Get_Order_Header;
3221:

Line 3218: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);

3214: EXCEPTION
3215: WHEN NO_DATA_FOUND THEN
3216: x_return_code := SQLCODE;
3217: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
3218: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3219: x_error_description := FND_MESSAGE.GET;
3220: END Get_Order_Header;
3221:
3222: --

Line 3219: x_error_description := FND_MESSAGE.GET;

3215: WHEN NO_DATA_FOUND THEN
3216: x_return_code := SQLCODE;
3217: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_NOTEXISTS');
3218: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3219: x_error_description := FND_MESSAGE.GET;
3220: END Get_Order_Header;
3221:
3222: --
3223: -- This is a private api used by Get_Order_Details

Line 3388: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');

3384: Get_Order_Status(l_order_id,x_order_status,x_return_code,x_error_description);
3385: EXCEPTION
3386: WHEN NO_DATA_FOUND THEN
3387: x_return_code := SQLCODE;
3388: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3389: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3390: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3391: x_error_description := FND_MESSAGE.GET;
3392: WHEN OTHERS THEN

Line 3389: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);

3385: EXCEPTION
3386: WHEN NO_DATA_FOUND THEN
3387: x_return_code := SQLCODE;
3388: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3389: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3390: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3391: x_error_description := FND_MESSAGE.GET;
3392: WHEN OTHERS THEN
3393: x_return_code := -191266;

Line 3390: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);

3386: WHEN NO_DATA_FOUND THEN
3387: x_return_code := SQLCODE;
3388: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3389: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3390: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3391: x_error_description := FND_MESSAGE.GET;
3392: WHEN OTHERS THEN
3393: x_return_code := -191266;
3394: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 3391: x_error_description := FND_MESSAGE.GET;

3387: x_return_code := SQLCODE;
3388: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3389: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3390: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3391: x_error_description := FND_MESSAGE.GET;
3392: WHEN OTHERS THEN
3393: x_return_code := -191266;
3394: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3395: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_STATUS');

Line 3394: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3390: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3391: x_error_description := FND_MESSAGE.GET;
3392: WHEN OTHERS THEN
3393: x_return_code := -191266;
3394: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3395: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_STATUS');
3396: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3397: x_error_description := FND_MESSAGE.GET;
3398: END Get_Order_Status;

Line 3395: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_STATUS');

3391: x_error_description := FND_MESSAGE.GET;
3392: WHEN OTHERS THEN
3393: x_return_code := -191266;
3394: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3395: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_STATUS');
3396: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3397: x_error_description := FND_MESSAGE.GET;
3398: END Get_Order_Status;
3399:

Line 3396: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3392: WHEN OTHERS THEN
3393: x_return_code := -191266;
3394: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3395: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_STATUS');
3396: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3397: x_error_description := FND_MESSAGE.GET;
3398: END Get_Order_Status;
3399:
3400:

Line 3397: x_error_description := FND_MESSAGE.GET;

3393: x_return_code := -191266;
3394: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3395: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_STATUS');
3396: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3397: x_error_description := FND_MESSAGE.GET;
3398: END Get_Order_Status;
3399:
3400:
3401: /*

Line 3434: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');

3430:
3431: EXCEPTION
3432: WHEN NO_DATA_FOUND THEN
3433: x_return_code := SQLCODE;
3434: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3435: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3436: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3437: x_error_description := FND_MESSAGE.GET;
3438: WHEN OTHERS THEN

Line 3435: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);

3431: EXCEPTION
3432: WHEN NO_DATA_FOUND THEN
3433: x_return_code := SQLCODE;
3434: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3435: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3436: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3437: x_error_description := FND_MESSAGE.GET;
3438: WHEN OTHERS THEN
3439: x_return_code := -191266;

Line 3436: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);

3432: WHEN NO_DATA_FOUND THEN
3433: x_return_code := SQLCODE;
3434: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3435: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3436: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3437: x_error_description := FND_MESSAGE.GET;
3438: WHEN OTHERS THEN
3439: x_return_code := -191266;
3440: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 3437: x_error_description := FND_MESSAGE.GET;

3433: x_return_code := SQLCODE;
3434: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_VERSION_NOTEXISTS');
3435: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', p_order_number);
3436: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3437: x_error_description := FND_MESSAGE.GET;
3438: WHEN OTHERS THEN
3439: x_return_code := -191266;
3440: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3441: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_DETAILS');

Line 3440: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3436: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', p_order_version);
3437: x_error_description := FND_MESSAGE.GET;
3438: WHEN OTHERS THEN
3439: x_return_code := -191266;
3440: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3441: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_DETAILS');
3442: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3443: x_error_description := FND_MESSAGE.GET;
3444:

Line 3441: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_DETAILS');

3437: x_error_description := FND_MESSAGE.GET;
3438: WHEN OTHERS THEN
3439: x_return_code := -191266;
3440: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3441: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_DETAILS');
3442: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3443: x_error_description := FND_MESSAGE.GET;
3444:
3445: END Get_Order_Details;

Line 3442: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3438: WHEN OTHERS THEN
3439: x_return_code := -191266;
3440: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3441: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_DETAILS');
3442: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3443: x_error_description := FND_MESSAGE.GET;
3444:
3445: END Get_Order_Details;
3446:

Line 3443: x_error_description := FND_MESSAGE.GET;

3439: x_return_code := -191266;
3440: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3441: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.GET_ORDER_DETAILS');
3442: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3443: x_error_description := FND_MESSAGE.GET;
3444:
3445: END Get_Order_Details;
3446:
3447: --

Line 3680: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');

3676:
3677: EXCEPTION
3678: WHEN resource_busy OR no_data_found THEN
3679: return_code := -191318;
3680: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
3681: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
3682: error_description := FND_MESSAGE.GET;
3683: return;
3684: WHEN e_xdp_fa_state_inprogress THEN

Line 3681: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);

3677: EXCEPTION
3678: WHEN resource_busy OR no_data_found THEN
3679: return_code := -191318;
3680: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
3681: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
3682: error_description := FND_MESSAGE.GET;
3683: return;
3684: WHEN e_xdp_fa_state_inprogress THEN
3685: return_code := 197010;

Line 3682: error_description := FND_MESSAGE.GET;

3678: WHEN resource_busy OR no_data_found THEN
3679: return_code := -191318;
3680: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
3681: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
3682: error_description := FND_MESSAGE.GET;
3683: return;
3684: WHEN e_xdp_fa_state_inprogress THEN
3685: return_code := 197010;
3686: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');

Line 3686: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');

3682: error_description := FND_MESSAGE.GET;
3683: return;
3684: WHEN e_xdp_fa_state_inprogress THEN
3685: return_code := 197010;
3686: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');
3687: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3688: error_description := FND_MESSAGE.GET;
3689: return;
3690: WHEN OTHERS THEN

Line 3687: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);

3683: return;
3684: WHEN e_xdp_fa_state_inprogress THEN
3685: return_code := 197010;
3686: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');
3687: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3688: error_description := FND_MESSAGE.GET;
3689: return;
3690: WHEN OTHERS THEN
3691: return_code := -191266;

Line 3688: error_description := FND_MESSAGE.GET;

3684: WHEN e_xdp_fa_state_inprogress THEN
3685: return_code := 197010;
3686: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_STATE_INPROGRESS');
3687: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_order_id);
3688: error_description := FND_MESSAGE.GET;
3689: return;
3690: WHEN OTHERS THEN
3691: return_code := -191266;
3692: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 3692: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3688: error_description := FND_MESSAGE.GET;
3689: return;
3690: WHEN OTHERS THEN
3691: return_code := -191266;
3692: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3693: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3694: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3695: error_description := FND_MESSAGE.GET;
3696: END CANCEL_FA ;

Line 3693: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

3689: return;
3690: WHEN OTHERS THEN
3691: return_code := -191266;
3692: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3693: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3694: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3695: error_description := FND_MESSAGE.GET;
3696: END CANCEL_FA ;
3697:

Line 3694: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3690: WHEN OTHERS THEN
3691: return_code := -191266;
3692: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3693: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3694: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3695: error_description := FND_MESSAGE.GET;
3696: END CANCEL_FA ;
3697:
3698:

Line 3695: error_description := FND_MESSAGE.GET;

3691: return_code := -191266;
3692: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3693: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3694: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3695: error_description := FND_MESSAGE.GET;
3696: END CANCEL_FA ;
3697:
3698:
3699: --

Line 3807: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');

3803:
3804: EXCEPTION
3805: WHEN e_xdp_wi_state_inprogress THEN
3806: return_code := -191318;
3807: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
3808: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
3809: error_description := FND_MESSAGE.GET;
3810: return;
3811: WHEN OTHERS THEN

Line 3808: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);

3804: EXCEPTION
3805: WHEN e_xdp_wi_state_inprogress THEN
3806: return_code := -191318;
3807: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
3808: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
3809: error_description := FND_MESSAGE.GET;
3810: return;
3811: WHEN OTHERS THEN
3812: return_code := -191266;

Line 3809: error_description := FND_MESSAGE.GET;

3805: WHEN e_xdp_wi_state_inprogress THEN
3806: return_code := -191318;
3807: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_REMOVE_ORDER');
3808: FND_MESSAGE.SET_TOKEN('ERROR_STRING', lv_error);
3809: error_description := FND_MESSAGE.GET;
3810: return;
3811: WHEN OTHERS THEN
3812: return_code := -191266;
3813: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 3813: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3809: error_description := FND_MESSAGE.GET;
3810: return;
3811: WHEN OTHERS THEN
3812: return_code := -191266;
3813: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3814: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3815: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3816: error_description := FND_MESSAGE.GET;
3817: END CANCEL_WORKITEM;

Line 3814: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');

3810: return;
3811: WHEN OTHERS THEN
3812: return_code := -191266;
3813: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3814: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3815: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3816: error_description := FND_MESSAGE.GET;
3817: END CANCEL_WORKITEM;
3818:

Line 3815: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3811: WHEN OTHERS THEN
3812: return_code := -191266;
3813: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3814: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3815: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3816: error_description := FND_MESSAGE.GET;
3817: END CANCEL_WORKITEM;
3818:
3819:

Line 3816: error_description := FND_MESSAGE.GET;

3812: return_code := -191266;
3813: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3814: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB');
3815: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3816: error_description := FND_MESSAGE.GET;
3817: END CANCEL_WORKITEM;
3818:
3819:
3820: --

Line 3858: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3854:
3855: EXCEPTION
3856: WHEN OTHERS THEN
3857: return_code := -191266;
3858: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3859: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB. UPDATE_XDP_ORDER_STATUS');
3860: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3861: error_description := FND_MESSAGE.GET;
3862: END UPDATE_XDP_ORDER_STATUS;

Line 3859: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB. UPDATE_XDP_ORDER_STATUS');

3855: EXCEPTION
3856: WHEN OTHERS THEN
3857: return_code := -191266;
3858: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3859: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB. UPDATE_XDP_ORDER_STATUS');
3860: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3861: error_description := FND_MESSAGE.GET;
3862: END UPDATE_XDP_ORDER_STATUS;
3863:

Line 3860: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3856: WHEN OTHERS THEN
3857: return_code := -191266;
3858: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3859: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB. UPDATE_XDP_ORDER_STATUS');
3860: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3861: error_description := FND_MESSAGE.GET;
3862: END UPDATE_XDP_ORDER_STATUS;
3863:
3864: --

Line 3861: error_description := FND_MESSAGE.GET;

3857: return_code := -191266;
3858: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3859: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB. UPDATE_XDP_ORDER_STATUS');
3860: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3861: error_description := FND_MESSAGE.GET;
3862: END UPDATE_XDP_ORDER_STATUS;
3863:
3864: --
3865: -- Private API which will update xdp_order_line_items status_code

Line 3901: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3897:
3898: EXCEPTION
3899: WHEN OTHERS THEN
3900: return_code := -191266;
3901: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3902: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_ORDER_LINE_STATUS');
3903: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3904: error_description := FND_MESSAGE.GET;
3905: END UPDATE_XDP_ORDER_LINE_STATUS;

Line 3902: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_ORDER_LINE_STATUS');

3898: EXCEPTION
3899: WHEN OTHERS THEN
3900: return_code := -191266;
3901: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3902: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_ORDER_LINE_STATUS');
3903: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3904: error_description := FND_MESSAGE.GET;
3905: END UPDATE_XDP_ORDER_LINE_STATUS;
3906:

Line 3903: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3899: WHEN OTHERS THEN
3900: return_code := -191266;
3901: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3902: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_ORDER_LINE_STATUS');
3903: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3904: error_description := FND_MESSAGE.GET;
3905: END UPDATE_XDP_ORDER_LINE_STATUS;
3906:
3907: --

Line 3904: error_description := FND_MESSAGE.GET;

3900: return_code := -191266;
3901: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3902: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_ORDER_LINE_STATUS');
3903: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3904: error_description := FND_MESSAGE.GET;
3905: END UPDATE_XDP_ORDER_LINE_STATUS;
3906:
3907: --
3908: -- Private API which will update xdp_fulfill_worklist status_code

Line 3943: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3939:
3940: EXCEPTION
3941: WHEN OTHERS THEN
3942: return_code := -191266;
3943: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3944: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_WI_INSTANCE_STATUS');
3945: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3946: error_description := FND_MESSAGE.GET;
3947: END UPDATE_XDP_WI_INSTANCE_STATUS;

Line 3944: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_WI_INSTANCE_STATUS');

3940: EXCEPTION
3941: WHEN OTHERS THEN
3942: return_code := -191266;
3943: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3944: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_WI_INSTANCE_STATUS');
3945: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3946: error_description := FND_MESSAGE.GET;
3947: END UPDATE_XDP_WI_INSTANCE_STATUS;
3948:

Line 3945: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3941: WHEN OTHERS THEN
3942: return_code := -191266;
3943: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3944: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_WI_INSTANCE_STATUS');
3945: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3946: error_description := FND_MESSAGE.GET;
3947: END UPDATE_XDP_WI_INSTANCE_STATUS;
3948:
3949: --

Line 3946: error_description := FND_MESSAGE.GET;

3942: return_code := -191266;
3943: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3944: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_WI_INSTANCE_STATUS');
3945: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3946: error_description := FND_MESSAGE.GET;
3947: END UPDATE_XDP_WI_INSTANCE_STATUS;
3948:
3949: --
3950: -- Private API which will update xdp_fa_runtime_list status_code

Line 3983: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

3979:
3980: EXCEPTION
3981: WHEN OTHERS THEN
3982: return_code := -191266;
3983: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3984: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_FA_INSTANCE_STATUS');
3985: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3986: error_description := FND_MESSAGE.GET;
3987: END UPDATE_XDP_FA_INSTANCE_STATUS;

Line 3984: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_FA_INSTANCE_STATUS');

3980: EXCEPTION
3981: WHEN OTHERS THEN
3982: return_code := -191266;
3983: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3984: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_FA_INSTANCE_STATUS');
3985: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3986: error_description := FND_MESSAGE.GET;
3987: END UPDATE_XDP_FA_INSTANCE_STATUS;
3988:

Line 3985: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

3981: WHEN OTHERS THEN
3982: return_code := -191266;
3983: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3984: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_FA_INSTANCE_STATUS');
3985: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3986: error_description := FND_MESSAGE.GET;
3987: END UPDATE_XDP_FA_INSTANCE_STATUS;
3988:
3989: --

Line 3986: error_description := FND_MESSAGE.GET;

3982: return_code := -191266;
3983: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
3984: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.UPDATE_XDP_FA_INSTANCE_STATUS');
3985: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
3986: error_description := FND_MESSAGE.GET;
3987: END UPDATE_XDP_FA_INSTANCE_STATUS;
3988:
3989: --
3990: -- Provate API to update status or outbound messages to 'CANCELED' for canceled orders

Line 4017: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

4013:
4014: EXCEPTION
4015: WHEN OTHERS THEN
4016: x_error_code := -191266;
4017: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4018: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.CANCEL_READY_MSGS');
4019: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4020: x_error_message := FND_MESSAGE.GET;
4021: END CANCEL_READY_MSGS ;

Line 4018: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.CANCEL_READY_MSGS');

4014: EXCEPTION
4015: WHEN OTHERS THEN
4016: x_error_code := -191266;
4017: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4018: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.CANCEL_READY_MSGS');
4019: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4020: x_error_message := FND_MESSAGE.GET;
4021: END CANCEL_READY_MSGS ;
4022:

Line 4019: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

4015: WHEN OTHERS THEN
4016: x_error_code := -191266;
4017: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4018: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.CANCEL_READY_MSGS');
4019: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4020: x_error_message := FND_MESSAGE.GET;
4021: END CANCEL_READY_MSGS ;
4022:
4023:

Line 4020: x_error_message := FND_MESSAGE.GET;

4016: x_error_code := -191266;
4017: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4018: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.CANCEL_READY_MSGS');
4019: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4020: x_error_message := FND_MESSAGE.GET;
4021: END CANCEL_READY_MSGS ;
4022:
4023:
4024:

Line 4042: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

4038: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;
4039: EXCEPTION
4040: WHEN OTHERS THEN
4041: x_return_code := -191266;
4042: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4043: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4044: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4045: x_error_description := FND_MESSAGE.GET;
4046: END Set_Line_Fulfillment_Status;

Line 4043: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');

4039: EXCEPTION
4040: WHEN OTHERS THEN
4041: x_return_code := -191266;
4042: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4043: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4044: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4045: x_error_description := FND_MESSAGE.GET;
4046: END Set_Line_Fulfillment_Status;
4047:

Line 4044: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

4040: WHEN OTHERS THEN
4041: x_return_code := -191266;
4042: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4043: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4044: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4045: x_error_description := FND_MESSAGE.GET;
4046: END Set_Line_Fulfillment_Status;
4047:
4048:

Line 4045: x_error_description := FND_MESSAGE.GET;

4041: x_return_code := -191266;
4042: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4043: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4044: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4045: x_error_description := FND_MESSAGE.GET;
4046: END Set_Line_Fulfillment_Status;
4047:
4048:
4049: PROCEDURE Set_Line_Fulfillment_Status(

Line 4079: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

4075: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;
4076: EXCEPTION
4077: WHEN OTHERS THEN
4078: x_return_code := -191266;
4079: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4080: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4081: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4082: x_error_description := FND_MESSAGE.GET;
4083: END Set_Line_Fulfillment_Status;

Line 4080: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');

4076: EXCEPTION
4077: WHEN OTHERS THEN
4078: x_return_code := -191266;
4079: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4080: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4081: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4082: x_error_description := FND_MESSAGE.GET;
4083: END Set_Line_Fulfillment_Status;
4084:

Line 4081: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

4077: WHEN OTHERS THEN
4078: x_return_code := -191266;
4079: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4080: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4081: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4082: x_error_description := FND_MESSAGE.GET;
4083: END Set_Line_Fulfillment_Status;
4084:
4085:

Line 4082: x_error_description := FND_MESSAGE.GET;

4078: x_return_code := -191266;
4079: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4080: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Set_Line_Fulfillment_Status');
4081: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4082: x_error_description := FND_MESSAGE.GET;
4083: END Set_Line_Fulfillment_Status;
4084:
4085:
4086:

Line 4108: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

4104: x_return_code := 0;
4105: EXCEPTION
4106: WHEN OTHERS THEN
4107: x_return_code := -191266;
4108: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4109: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4110: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4111: x_error_description := FND_MESSAGE.GET;
4112: END Get_Line_Fulfillment_Status;

Line 4109: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');

4105: EXCEPTION
4106: WHEN OTHERS THEN
4107: x_return_code := -191266;
4108: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4109: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4110: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4111: x_error_description := FND_MESSAGE.GET;
4112: END Get_Line_Fulfillment_Status;
4113:

Line 4110: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

4106: WHEN OTHERS THEN
4107: x_return_code := -191266;
4108: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4109: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4110: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4111: x_error_description := FND_MESSAGE.GET;
4112: END Get_Line_Fulfillment_Status;
4113:
4114:

Line 4111: x_error_description := FND_MESSAGE.GET;

4107: x_return_code := -191266;
4108: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4109: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4110: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4111: x_error_description := FND_MESSAGE.GET;
4112: END Get_Line_Fulfillment_Status;
4113:
4114:
4115:

Line 4148: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

4144: x_return_code := 0;
4145: EXCEPTION
4146: WHEN OTHERS THEN
4147: x_return_code := -191266;
4148: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4149: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4150: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4151: x_error_description := FND_MESSAGE.GET;
4152: END Get_Line_Fulfillment_Status;

Line 4149: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');

4145: EXCEPTION
4146: WHEN OTHERS THEN
4147: x_return_code := -191266;
4148: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4149: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4150: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4151: x_error_description := FND_MESSAGE.GET;
4152: END Get_Line_Fulfillment_Status;
4153:

Line 4150: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);

4146: WHEN OTHERS THEN
4147: x_return_code := -191266;
4148: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4149: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4150: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4151: x_error_description := FND_MESSAGE.GET;
4152: END Get_Line_Fulfillment_Status;
4153:
4154: BEGIN

Line 4151: x_error_description := FND_MESSAGE.GET;

4147: x_return_code := -191266;
4148: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
4149: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDPINTFB.Get_Line_Fulfillment_Status');
4150: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
4151: x_error_description := FND_MESSAGE.GET;
4152: END Get_Line_Fulfillment_Status;
4153:
4154: BEGIN
4155: -- Package initialization