DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_UTIL_CORE

Line 685: l_delivery_id_tab wsh_util_core.id_tab_type;

681:
682: l_msg_count NUMBER;
683: l_msg_data VARCHAR2(2000);
684: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
685: l_delivery_id_tab wsh_util_core.id_tab_type;
686: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
687:
688: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
689: l_debug number;

Line 1720: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1716: p_source_code => 'OE',
1717: p_init_flag => 'Y',
1718: x_return_status => l_return_status);
1719:
1720: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1721: x_result := 1;
1722: l_delivery_detail_ids := l_delivery_detail_ids || ' ' || a_delivery_detail.delivery_detail_id;
1723: END IF;
1724:

Line 2110: l_delivery_id_tab wsh_util_core.id_tab_type;

2106: l_dock_appoint_flag VARCHAR2(1);
2107: temp_val NUMBER;
2108:
2109: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype; --g-log
2110: l_delivery_id_tab wsh_util_core.id_tab_type;
2111: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2112: l_msg_count NUMBER;
2113: l_msg_data VARCHAR2(2000);
2114:

Line 2282: IF l_delivery_id > 0 AND WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' THEN

2278: end if;
2279:
2280:
2281: --Add G-log code here -START
2282: IF l_delivery_id > 0 AND WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' THEN
2283: IF (l_debug = 1) THEN
2284: debug('G-Log Changes: G-Log installed', 'LPN_CHECK');
2285: END IF;
2286:

Line 2451: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;

2447:
2448: l_delivery_id NUMBER;
2449: l_delivery_name VARCHAR2(30);
2450: l_delivery_detail_id NUMBER;
2451: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2452: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2453: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2454: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2455: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;

Line 2452: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;

2448: l_delivery_id NUMBER;
2449: l_delivery_name VARCHAR2(30);
2450: l_delivery_detail_id NUMBER;
2451: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2452: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2453: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2454: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2455: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2456: l_return_Status VARCHAR2(1);

Line 2453: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;

2449: l_delivery_name VARCHAR2(30);
2450: l_delivery_detail_id NUMBER;
2451: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2452: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2453: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2454: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2455: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2456: l_return_Status VARCHAR2(1);
2457: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;

Line 2454: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;

2450: l_delivery_detail_id NUMBER;
2451: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2452: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2453: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2454: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2455: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2456: l_return_Status VARCHAR2(1);
2457: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2458: l_del_index NUMBER;

Line 2457: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;

2453: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2454: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2455: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2456: l_return_Status VARCHAR2(1);
2457: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2458: l_del_index NUMBER;
2459: l_del_count NUMBER;
2460: l_msg_count NUMBER;
2461: l_msg_data VARCHAR2(2000);

Line 2885: IF wsh_util_core.gc3_is_installed = 'Y' THEN

2881: * BUT, we need to update it at delivery level for LPN Ship, where
2882: * API: SHIP_CONFIRM_LPN_DELIVERIES depends on the delivery level shipmenthod
2883: */
2884:
2885: IF wsh_util_core.gc3_is_installed = 'Y' THEN
2886: IF (l_debug = 1) THEN
2887: debug('G-Log Changes: G-Log installed', 'update_delivery');
2888: END IF;
2889:

Line 3603: PROCEDURE PRINT_LABEL(p_del_rows IN wsh_util_core.id_tab_type,

3599: x_return_status := 'U';
3600: END SHIP_SET_CHECK;
3601:
3602:
3603: PROCEDURE PRINT_LABEL(p_del_rows IN wsh_util_core.id_tab_type,
3604: x_return_status OUT NOCOPY VARCHAR2) IS
3605: /*
3606: cursor Delivery_Details(p_delivery_id NUMBER) is
3607: select wdd.delivery_detail_id

Line 3651: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;

3647: p_action_flag IN VARCHAR2,
3648: x_return_status OUT NOCOPY VARCHAR2,
3649: x_msg_data OUT NOCOPY VARCHAR2,
3650: x_msg_count OUT NOCOPY NUMBER) IS
3651: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3652: l_report_set_id NUMBER;
3653:
3654: l_actual_dep_date DATE := SYSDATE;
3655: l_bol_flag VARCHAR2(1) := 'Y';

Line 3907: wsh_util_core.get_messages

3903: debug('inside EXCEPTION, x_msg_data is ' || x_msg_data, 'SHIP_CONFIRM_ALL');
3904: END IF;
3905:
3906: /* commented DHERRING Bug#5651219
3907: wsh_util_core.get_messages
3908: (p_init_msg_list => 'Y',
3909: x_summary => l_summary,
3910: x_details => l_msg_data,
3911: x_count => l_msg_count); */

Line 4134: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;

4130: AND rownum = 1;
4131:
4132: l_delivery_id NUMBER;
4133: l_del_index NUMBER;
4134: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
4135: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;
4136: l_drop_off_stops wsh_util_core.id_tab_type;
4137: l_report_set_id NUMBER;
4138:

Line 4135: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;

4131:
4132: l_delivery_id NUMBER;
4133: l_del_index NUMBER;
4134: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
4135: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;
4136: l_drop_off_stops wsh_util_core.id_tab_type;
4137: l_report_set_id NUMBER;
4138:
4139: l_sc_rule_id NUMBER;

Line 4136: l_drop_off_stops wsh_util_core.id_tab_type;

4132: l_delivery_id NUMBER;
4133: l_del_index NUMBER;
4134: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
4135: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;
4136: l_drop_off_stops wsh_util_core.id_tab_type;
4137: l_report_set_id NUMBER;
4138:
4139: l_sc_rule_id NUMBER;
4140: l_intransit_flag VARCHAR2(1);

Line 5014: wsh_util_core.get_messages

5010: debug('inside EXCEPTION, l_msg_count is ' || x_msg_count, 'SHIP_CONFIRM_LPN_DELIVERIES');
5011: debug('inside EXCEPTION, x_msg_data is ' || x_msg_data, 'SHIP_CONFIRM_LPN_DELIVERIES');
5012: END IF;
5013: /* commented for DHERRING Bug#5651219
5014: wsh_util_core.get_messages
5015: (p_init_msg_list => 'Y',
5016: x_summary => l_msg_data,
5017: x_details => l_summary,
5018: x_count => l_msg_count);*/

Line 5170: l_delivery_id_tab wsh_util_core.id_tab_type;

5166: l_debug number;
5167:
5168: /* Bug: 5585359: 10/09/06 Start*/
5169: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5170: l_delivery_id_tab wsh_util_core.id_tab_type;
5171: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5172: l_planned_flag VARCHAR2(1);
5173: /* Bug: 5585359: 10/09/06 - End*/
5174: