DBA Data[Home] [Help]

APPS.RCV_WSH_INTERFACE_PKG dependencies on RCV_WSH_INTERFACE_PKG

Line 1: PACKAGE BODY RCV_WSH_INTERFACE_PKG AS

1: PACKAGE BODY RCV_WSH_INTERFACE_PKG AS
2: /* $Header: RCVWSHIB.pls 120.11.12020000.8 2013/03/26 06:59:37 honwei ship $*/
3:
4: /*===========================================================================
5:

Line 917: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);

913: FOR x IN 1 .. l_msg_count LOOP
914: l_msg_data := fnd_msg_pub.get (x, 'F');
915: END LOOP;
916:
917: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
918: raise fnd_api.g_exc_error;
919:
920: WHEN e_wdd_creation_error THEN
921: IF (g_asn_debug = 'Y') THEN

Line 925: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);

921: IF (g_asn_debug = 'Y') THEN
922: asn_debug.put_line('e_wdd_creation_error in create_delivery_details : ' || l_progress);
923: END IF;
924: l_msg_data := fnd_msg_pub.get (1, 'F');
925: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
926: raise fnd_api.g_exc_error;
927:
928: --RTV2 rtv project phase 2 : start
929: WHEN e_con_wdd_creation_error THEN

Line 941: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);

937:
938: FOR x IN 1 .. l_msg_count LOOP
939: l_msg_data := fnd_msg_pub.get (x, 'F');
940: END LOOP;
941: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
942: raise fnd_api.g_exc_error;
943:
944: WHEN e_mr_creation_error THEN
945: IF (g_asn_debug = 'Y') THEN

Line 956: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);

952:
953: FOR x IN 1 .. l_msg_count LOOP
954: l_msg_data := fnd_msg_pub.get (x, 'F');
955: END LOOP;
956: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
957: raise fnd_api.g_exc_error;
958: --RTV2 rtv project phase 2 : end
959:
960: WHEN OTHERS THEN

Line 965: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', 'Unexpected exception', sqlcode);

961: IF (g_asn_debug = 'Y') THEN
962: asn_debug.put_line('Unexpected exception in create_delivery_details : ' || SQLERRM);
963: asn_debug.put_line('l_progress : ' || l_progress);
964: END IF;
965: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', 'Unexpected exception', sqlcode);
966: raise fnd_api.g_exc_unexpected_error;
967: END create_delivery_details;
968:
969: /*===========================================================================

Line 2955: ( p_rti_id_tbl IN RCV_WSH_INTERFACE_PKG.RTI_id_tbl ) IS

2951: PROCEDURE NAME: cancel_rtv_lines ()
2952:
2953: ===========================================================================*/
2954: PROCEDURE cancel_rtv_lines
2955: ( p_rti_id_tbl IN RCV_WSH_INTERFACE_PKG.RTI_id_tbl ) IS
2956:
2957: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;
2958: l_wdd_cancel_qty NUMBER;
2959: l_return_status VARCHAR2(1);

Line 3321: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);

3317: FOR x IN 1 .. l_msg_count LOOP
3318: l_msg_data := fnd_msg_pub.get (x, 'F');
3319: END LOOP;
3320:
3321: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3322: raise fnd_api.g_exc_error;
3323:
3324: WHEN e_cancel_unmark_lpn_error THEN
3325: IF (g_asn_debug = 'Y') THEN

Line 3337: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);

3333: FOR x IN 1 .. l_msg_count LOOP
3334: l_msg_data := fnd_msg_pub.get (x, 'F');
3335: END LOOP;
3336:
3337: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3338: raise fnd_api.g_exc_error;
3339:
3340: WHEN e_cancel_unpack_lpn_error THEN
3341: IF (g_asn_debug = 'Y') THEN

Line 3353: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);

3349: FOR x IN 1 .. l_msg_count LOOP
3350: l_msg_data := fnd_msg_pub.get (x, 'F');
3351: END LOOP;
3352:
3353: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3354: raise fnd_api.g_exc_error;
3355:
3356: WHEN e_cancel_lpn_wdd_error THEN
3357: IF (g_asn_debug = 'Y') THEN

Line 3361: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);

3357: IF (g_asn_debug = 'Y') THEN
3358: asn_debug.put_line('whs_container_actions.delete_containers returned error!');
3359: END IF;
3360: l_msg_data := fnd_msg_pub.get (1, 'F');
3361: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3362: raise fnd_api.g_exc_error;
3363: -- RTV project phase 2 : end
3364:
3365: WHEN OTHERS THEN

Line 3369: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', 'Unexpected exception', sqlcode);

3365: WHEN OTHERS THEN
3366: IF (g_asn_debug = 'Y') THEN
3367: asn_debug.put_line('Unexpected exception in cancel_rtv_lines : ' || SQLERRM);
3368: END IF;
3369: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', 'Unexpected exception', sqlcode);
3370: raise fnd_api.g_exc_unexpected_error;
3371: END cancel_rtv_lines;
3372:
3373: END RCV_WSH_INTERFACE_PKG;

Line 3373: END RCV_WSH_INTERFACE_PKG;

3369: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', 'Unexpected exception', sqlcode);
3370: raise fnd_api.g_exc_unexpected_error;
3371: END cancel_rtv_lines;
3372:
3373: END RCV_WSH_INTERFACE_PKG;