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.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_UTIL_CORE

Line 114: IF l_return_status <> WSH_UTIL_CORE.g_ret_sts_success THEN

110: debug('Message count is : ' || l_msg_count,'VALIDATE_SHIP_METHOD');
111: END IF;
112:
113: --treating warnings as errors also
114: IF l_return_status <> WSH_UTIL_CORE.g_ret_sts_success THEN
115: l_return_status := FND_API.g_ret_sts_error;
116: wsh_util_core.get_messages(
117: p_init_msg_list => 'Y',
118: x_summary => l_msg_data,

Line 116: wsh_util_core.get_messages(

112:
113: --treating warnings as errors also
114: IF l_return_status <> WSH_UTIL_CORE.g_ret_sts_success THEN
115: l_return_status := FND_API.g_ret_sts_error;
116: wsh_util_core.get_messages(
117: p_init_msg_list => 'Y',
118: x_summary => l_msg_data,
119: x_details => l_details,
120: x_count => l_msg_count);

Line 123: debug('message from wsh_util_core.get_messages: ' || l_msg_data, 'VALIDATE_SHIP_METHOD');

119: x_details => l_details,
120: x_count => l_msg_count);
121:
122: IF l_debug = 1 THEN
123: debug('message from wsh_util_core.get_messages: ' || l_msg_data, 'VALIDATE_SHIP_METHOD');
124: debug('l_msg_count : ' || l_msg_count,
125: 'VALIDATE_SHIP_METHOD');
126: END IF;
127: END IF;

Line 644: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;

640: l_requested_quantity NUMBER;
641: l_requested_quantity2 NUMBER;
642: l_picked_quantity NUMBER;
643:
644: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
645: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
646: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
647: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
648: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 645: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

641: l_requested_quantity2 NUMBER;
642: l_picked_quantity NUMBER;
643:
644: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
645: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
646: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
647: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
648: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
649: l_dummy_table wsh_util_core.id_tab_type;

Line 646: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

642: l_picked_quantity NUMBER;
643:
644: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
645: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
646: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
647: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
648: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
649: l_dummy_table wsh_util_core.id_tab_type;
650: l_table_index NUMBER := 1;

Line 647: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

643:
644: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
645: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
646: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
647: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
648: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
649: l_dummy_table wsh_util_core.id_tab_type;
650: l_table_index NUMBER := 1;
651:

Line 648: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

644: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
645: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
646: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
647: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
648: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
649: l_dummy_table wsh_util_core.id_tab_type;
650: l_table_index NUMBER := 1;
651:
652: l_parent_delivery_detail_id NUMBER;

Line 649: l_dummy_table wsh_util_core.id_tab_type;

645: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
646: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
647: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
648: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
649: l_dummy_table wsh_util_core.id_tab_type;
650: l_table_index NUMBER := 1;
651:
652: l_parent_delivery_detail_id NUMBER;
653: l_delivery_assignment_id NUMBER;

Line 884: wsh_util_core.get_messages

880: END IF;
881:
882: EXCEPTION
883: WHEN fnd_api.g_exc_unexpected_error THEN
884: wsh_util_core.get_messages
885: (p_init_msg_list => 'Y',
886: x_summary => x_msg_data,
887: x_details => l_details,
888: x_count => x_msg_count);

Line 924: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

920: FROM WMS_LICENSE_PLATE_NUMBERS
921: START WITH lpn_id = l_inner_lpn_id
922: CONNECT BY lpn_id = PRIOR parent_lpn_id;
923:
924: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
925: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;

Line 925: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

921: START WITH lpn_id = l_inner_lpn_id
922: CONNECT BY lpn_id = PRIOR parent_lpn_id;
923:
924: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
925: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;
929: l_out_rows wsh_util_core.id_tab_type;

Line 926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

922: CONNECT BY lpn_id = PRIOR parent_lpn_id;
923:
924: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
925: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;
929: l_out_rows wsh_util_core.id_tab_type;
930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

Line 927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

923:
924: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
925: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;
929: l_out_rows wsh_util_core.id_tab_type;
930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
931: l_dummy_num_var NUMBER := NULL;

Line 928: l_dummy_table wsh_util_core.id_tab_type;

924: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
925: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;
929: l_out_rows wsh_util_core.id_tab_type;
930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
931: l_dummy_num_var NUMBER := NULL;
932: l_table_index NUMBER := 1;

Line 929: l_out_rows wsh_util_core.id_tab_type;

925: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;
929: l_out_rows wsh_util_core.id_tab_type;
930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
931: l_dummy_num_var NUMBER := NULL;
932: l_table_index NUMBER := 1;
933:

Line 981: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

977: debug('fetched : l_picked_quantity: '|| l_picked_quantity, 'INV_LINE_RETURN_TO_STOCK');
978: END IF;
979: --6607967 start --FP 6922321
980: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_shipping_status);
981: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
982: debug('ERROR WHILE FETCHING SHIPPING GLOBAL PARAMETERS l_return_shipping_status'||l_return_shipping_status, 'INV_LINE_RETURN_TO_STOCK');
983: END IF;
984:
985: debug('fetched : l_global_param_rec.consolidate_bo_lines: '|| l_global_param_rec.consolidate_bo_lines, 'INV_LINE_RETURN_TO_STOCK');

Line 1243: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

1239: FROM WMS_LICENSE_PLATE_NUMBERS
1240: START WITH lpn_id = l_inner_lpn_id
1241: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1242:
1243: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
1244: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1244: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

1240: START WITH lpn_id = l_inner_lpn_id
1241: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1242:
1243: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
1244: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

1241: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1242:
1243: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
1244: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;

1242:
1243: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
1244: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;

Line 1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;

1243: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
1244: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;
1251: l_out_rows wsh_util_core.id_tab_type;

Line 1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;

1244: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;
1251: l_out_rows wsh_util_core.id_tab_type;
1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

Line 1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;

1245: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;
1251: l_out_rows wsh_util_core.id_tab_type;
1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1253: l_dummy_num_var NUMBER := NULL;

Line 1250: l_dummy_table wsh_util_core.id_tab_type;

1246: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;
1251: l_out_rows wsh_util_core.id_tab_type;
1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1253: l_dummy_num_var NUMBER := NULL;
1254: l_table_index NUMBER := 1;

Line 1251: l_out_rows wsh_util_core.id_tab_type;

1247: l_sec_bck_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;
1251: l_out_rows wsh_util_core.id_tab_type;
1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1253: l_dummy_num_var NUMBER := NULL;
1254: l_table_index NUMBER := 1;
1255:

Line 1510: wsh_util_core.get_messages

1506: END IF;
1507:
1508: EXCEPTION
1509: WHEN fnd_api.g_exc_unexpected_error THEN
1510: wsh_util_core.get_messages
1511: (p_init_msg_list => 'Y',
1512: x_summary => x_msg_data,
1513: x_details => l_details,
1514: x_count => x_msg_count);

Line 1573: wsh_util_core.get_messages

1569: END IF;
1570:
1571: EXCEPTION
1572: WHEN fnd_api.g_exc_unexpected_error THEN
1573: wsh_util_core.get_messages
1574: (p_init_msg_list => 'Y',
1575: x_summary => x_msg_data,
1576: x_details => l_details,
1577: x_count => x_msg_count);

Line 1690: wsh_util_core.get_messages

1686: RAISE fnd_api.g_exc_unexpected_error;
1687: END IF;
1688: EXCEPTION
1689: WHEN fnd_api.g_exc_unexpected_error THEN
1690: wsh_util_core.get_messages
1691: (p_init_msg_list => 'Y',
1692: x_summary => x_msg_data,
1693: x_details => l_details,
1694: x_count => x_msg_count);

Line 1824: wsh_util_core.get_messages

1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;
1822: EXCEPTION
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: wsh_util_core.get_messages
1825: (p_init_msg_list => 'Y',
1826: x_summary => x_msg_data,
1827: x_details => l_details,
1828: x_count => x_msg_count);

Line 2363: l_delivery_id_tab wsh_util_core.id_tab_type;

2359: l_msg_count NUMBER;
2360:
2361: l_wms_org_flag BOOLEAN;
2362: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
2363: l_delivery_id_tab wsh_util_core.id_tab_type;
2364: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2365:
2366: --Added for Bug 14696492
2367: CURSOR get_dlvy_trip(p_delivery_id NUMBER) IS