eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_WSH_INTERFACE_PKG dependencies on WSH_INTERFACE

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 446: AND rtv_rti.processing_status_code = 'WSH_INTERFACED'

442: AND new_rti.processing_mode_code = 'ONLINE'
443: AND new_rti.interface_source_line_id = wdd.delivery_detail_id
444: AND rtv_rti.interface_transaction_id = wdd.source_line_id
445: AND rtv_rti.group_id = wdd.source_header_id
446: AND rtv_rti.processing_status_code = 'WSH_INTERFACED'
447: AND wdd.source_code = 'RTV'
448: AND wdd.container_flag = 'N'
449: GROUP BY rtv_rti.interface_transaction_id, rtv_rti.transaction_type,new_rti.transfer_lpn_id,
450: rtv_rti.item_id,rtv_rti.item_revision,rtv_rti.use_mtl_serial, rtv_rti.use_mtl_lot,

Line 770: wsh_interface_grp.create_update_delivery_detail

766: l_wdd_tbl(1).shipped_quantity := l_wdd_tbl(1).requested_quantity;
767: l_wdd_tbl(1).transaction_temp_id := p_interface_txn_id;
768: END IF;
769:
770: wsh_interface_grp.create_update_delivery_detail
771: ( p_api_version_number => 1.0,
772: p_init_msg_list => FND_API.G_TRUE,
773: p_commit => NULL,
774: x_return_status => l_return_status,

Line 843: wsh_interface_grp.create_update_delivery_detail

839: IF (p_use_mtl_serial in (2,5)) THEN
840: l_wdd_tbl(1).shipped_quantity := l_wdd_tbl(1).requested_quantity;
841: END IF;
842:
843: wsh_interface_grp.create_update_delivery_detail
844: ( p_api_version_number => 1.0,
845: p_init_msg_list => NULL,
846: p_commit => NULL,
847: x_return_status => l_return_status,

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 990: AND rti.processing_status_code = 'WSH_INTERFACED'

986: AND wdd.released_status = 'C'
987: AND wdd.inv_interfaced_flag <> 'Y'
988: AND wdd.container_flag = 'N'
989: AND wdd.source_line_id = rti.interface_transaction_id
990: AND rti.processing_status_code = 'WSH_INTERFACED'
991: AND wdd.organization_id = rti.to_organization_id
992: AND rti.shipment_line_id IS NULL
993: ORDER BY source_line_id, source_line_number;
994:

Line 1008: AND rti.processing_status_code = 'WSH_INTERFACED'

1004: AND wdd.released_status = 'C'
1005: AND wdd.inv_interfaced_flag <> 'Y'
1006: AND wdd.container_flag = 'N'
1007: AND wdd.source_line_id = rti.interface_transaction_id
1008: AND rti.processing_status_code = 'WSH_INTERFACED'
1009: AND wdd.organization_id = rti.to_organization_id
1010: AND rti.shipment_line_id IS NOT NULL
1011: AND NOT EXISTS (SELECT 1 from rcv_transactions rt
1012: WHERE rt.transaction_type = 'RETURN TO VENDOR'

Line 1029: AND rti.processing_status_code = 'WSH_INTERFACED'

1025: AND wdd.released_status = 'C'
1026: AND wdd.inv_interfaced_flag <> 'Y'
1027: AND wdd.container_flag = 'N'
1028: AND wdd.source_line_id = rti.interface_transaction_id
1029: AND rti.processing_status_code = 'WSH_INTERFACED'
1030: AND wdd.organization_id <> rti.to_organization_id
1031: AND rti.shipment_line_id IS NOT NULL
1032: AND NOT EXISTS (SELECT 1
1033: FROM mtl_material_transactions mmt

Line 1050: AND rti.processing_status_code = 'WSH_INTERFACED'

1046: AND wdd.released_status = 'C'
1047: AND wdd.inv_interfaced_flag <> 'Y'
1048: AND wdd.container_flag = 'N'
1049: AND wdd.source_line_id = rti.interface_transaction_id
1050: AND rti.processing_status_code = 'WSH_INTERFACED'
1051: AND wdd.organization_id <> rti.to_organization_id
1052: AND rti.shipment_line_id IS NOT NULL
1053: AND EXISTS (SELECT 1
1054: FROM mtl_material_transactions mmt

Line 2619: AND rti.processing_status_code = 'WSH_INTERFACED'

2615: AND wdd.container_flag = 'N'
2616: AND wdd.delivery_detail_id = rt.interface_source_line_id
2617: AND rt.transaction_type = 'RETURN TO VENDOR'
2618: AND wdd.source_line_id = rti.interface_transaction_id
2619: AND rti.processing_status_code = 'WSH_INTERFACED'
2620: ORDER BY bkup_rti_id, delivery_detail_id
2621: FOR UPDATE;
2622:
2623:

Line 2650: AND rti.processing_status_code = 'WSH_INTERFACED'

2646: AND wdd.inv_interfaced_flag <> 'Y'
2647: AND wdd.container_flag = 'N'
2648: AND wdd.delivery_detail_id = mmt.picking_line_id
2649: AND wdd.source_line_id = rti.interface_transaction_id
2650: AND rti.processing_status_code = 'WSH_INTERFACED'
2651: ORDER BY bkup_rti_id, delivery_detail_id
2652: FOR UPDATE;
2653:
2654: pre_rti_id NUMBER := NULL; --RTV project phase 2

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 2957: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;

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);
2960: l_msg_count NUMBER;
2961: l_msg_data VARCHAR2(2000);

Line 3101: WSH_INTERFACE.Update_Shipping_Attributes

3097: END IF;
3098: --RTV2 rtv project phase 2 : end
3099:
3100:
3101: WSH_INTERFACE.Update_Shipping_Attributes
3102: ( p_source_code => 'RTV',
3103: p_changed_attributes => l_changed_attributes,
3104: x_return_status => l_return_status);
3105:

Line 3293: asn_debug.put_line('wsh_interface.update_shipping_attributes returned error!');

3289: raise fnd_api.g_exc_error;
3290:
3291: WHEN e_cancel_error2 THEN
3292: IF (g_asn_debug = 'Y') THEN
3293: asn_debug.put_line('wsh_interface.update_shipping_attributes returned error!');
3294: END IF;
3295: fnd_msg_pub.count_and_get (p_encoded => 'T',
3296: p_count => l_msg_count,
3297: p_data => l_msg_data

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;

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;