DBA Data[Home] [Help]

APPS.RCV_WSH_INTERFACE_PKG dependencies on PO_MESSAGE_S

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 3288: po_message_s.sql_error('wsh_integration.get_cancel_qty_allowed', l_msg_data, sqlcode);

3284: IF (g_asn_debug = 'Y') THEN
3285: asn_debug.put_line('wsh_integration.get_cancel_qty_allowed returned error!');
3286: END IF;
3287: l_msg_data := fnd_msg_pub.get (1, 'F');
3288: po_message_s.sql_error('wsh_integration.get_cancel_qty_allowed', l_msg_data, sqlcode);
3289: raise fnd_api.g_exc_error;
3290:
3291: WHEN e_cancel_error2 THEN
3292: IF (g_asn_debug = 'Y') THEN

Line 3304: po_message_s.sql_error('wsh_interface.update_shipping_attributes', l_msg_data, sqlcode);

3300: FOR x IN 1 .. l_msg_count LOOP
3301: l_msg_data := fnd_msg_pub.get (x, 'F');
3302: END LOOP;
3303:
3304: po_message_s.sql_error('wsh_interface.update_shipping_attributes', l_msg_data, sqlcode);
3305: raise fnd_api.g_exc_error;
3306: -- Bug 10089980 : End
3307: -- RTV project phase 2 : start
3308: WHEN e_cancel_MR_error THEN

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;