DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_UTIL_CORE

Line 632: l_delivery_id_tab wsh_util_core.id_tab_type;

628:
629: l_msg_count NUMBER;
630: l_msg_data VARCHAR2(2000);
631: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
632: l_delivery_id_tab wsh_util_core.id_tab_type;
633: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
634:
635: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
636: l_debug number;

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

1658: p_source_code => 'OE',
1659: p_init_flag => 'Y',
1660: x_return_status => l_return_status);
1661:
1662: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1663: x_result := 1;
1664: l_delivery_detail_ids := l_delivery_detail_ids || ' ' || a_delivery_detail.delivery_detail_id;
1665: END IF;
1666:

Line 2049: l_delivery_id_tab wsh_util_core.id_tab_type;

2045: l_dock_appoint_flag VARCHAR2(1);
2046: temp_val NUMBER;
2047:
2048: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype; --g-log
2049: l_delivery_id_tab wsh_util_core.id_tab_type;
2050: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2051: l_msg_count NUMBER;
2052: l_msg_data VARCHAR2(2000);
2053:

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

2217: end if;
2218:
2219:
2220: --Add G-log code here -START
2221: IF l_delivery_id > 0 AND WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' THEN
2222: IF (l_debug = 1) THEN
2223: debug('G-Log Changes: G-Log installed', 'LPN_CHECK');
2224: END IF;
2225:

Line 2390: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;

2386:
2387: l_delivery_id NUMBER;
2388: l_delivery_name VARCHAR2(30);
2389: l_delivery_detail_id NUMBER;
2390: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2391: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2392: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2393: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2394: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;

Line 2391: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;

2387: l_delivery_id NUMBER;
2388: l_delivery_name VARCHAR2(30);
2389: l_delivery_detail_id NUMBER;
2390: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2391: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2392: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2393: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2394: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2395: l_return_Status VARCHAR2(1);

Line 2392: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;

2388: l_delivery_name VARCHAR2(30);
2389: l_delivery_detail_id NUMBER;
2390: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2391: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2392: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2393: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2394: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2395: l_return_Status VARCHAR2(1);
2396: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;

Line 2393: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;

2389: l_delivery_detail_id NUMBER;
2390: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2391: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2392: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2393: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2394: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2395: l_return_Status VARCHAR2(1);
2396: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2397: l_del_index NUMBER;

Line 2396: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;

2392: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2393: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2394: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2395: l_return_Status VARCHAR2(1);
2396: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2397: l_del_index NUMBER;
2398: l_del_count NUMBER;
2399: l_msg_count NUMBER;
2400: l_msg_data VARCHAR2(2000);

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

2820: * BUT, we need to update it at delivery level for LPN Ship, where
2821: * API: SHIP_CONFIRM_LPN_DELIVERIES depends on the delivery level shipmenthod
2822: */
2823:
2824: IF wsh_util_core.gc3_is_installed = 'Y' THEN
2825: IF (l_debug = 1) THEN
2826: debug('G-Log Changes: G-Log installed', 'update_delivery');
2827: END IF;
2828:

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

3538: x_return_status := 'U';
3539: END SHIP_SET_CHECK;
3540:
3541:
3542: PROCEDURE PRINT_LABEL(p_del_rows IN wsh_util_core.id_tab_type,
3543: x_return_status OUT NOCOPY VARCHAR2) IS
3544: /*
3545: cursor Delivery_Details(p_delivery_id NUMBER) is
3546: select wdd.delivery_detail_id

Line 3590: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;

3586: p_action_flag IN VARCHAR2,
3587: x_return_status OUT NOCOPY VARCHAR2,
3588: x_msg_data OUT NOCOPY VARCHAR2,
3589: x_msg_count OUT NOCOPY NUMBER) IS
3590: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3591: l_report_set_id NUMBER;
3592:
3593: l_actual_dep_date DATE := SYSDATE;
3594: l_bol_flag VARCHAR2(1) := 'Y';

Line 3777: wsh_util_core.get_messages

3773: debug('inside EXCEPTION, x_msg_data is ' || x_msg_data, 'SHIP_CONFIRM_ALL');
3774: END IF;
3775:
3776: /* commented DHERRING Bug#5651219
3777: wsh_util_core.get_messages
3778: (p_init_msg_list => 'Y',
3779: x_summary => l_summary,
3780: x_details => l_msg_data,
3781: x_count => l_msg_count); */

Line 3974: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;

3970: AND rownum = 1;
3971:
3972: l_delivery_id NUMBER;
3973: l_del_index NUMBER;
3974: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3975: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3976: l_drop_off_stops wsh_util_core.id_tab_type;
3977: l_report_set_id NUMBER;
3978:

Line 3975: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;

3971:
3972: l_delivery_id NUMBER;
3973: l_del_index NUMBER;
3974: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3975: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3976: l_drop_off_stops wsh_util_core.id_tab_type;
3977: l_report_set_id NUMBER;
3978:
3979: l_sc_rule_id NUMBER;

Line 3976: l_drop_off_stops wsh_util_core.id_tab_type;

3972: l_delivery_id NUMBER;
3973: l_del_index NUMBER;
3974: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3975: l_stop_rows WSH_UTIL_CORE.ID_TAB_TYPE;
3976: l_drop_off_stops wsh_util_core.id_tab_type;
3977: l_report_set_id NUMBER;
3978:
3979: l_sc_rule_id NUMBER;
3980: l_intransit_flag VARCHAR2(1);

Line 4854: wsh_util_core.get_messages

4850: debug('inside EXCEPTION, l_msg_count is ' || x_msg_count, 'SHIP_CONFIRM_LPN_DELIVERIES');
4851: debug('inside EXCEPTION, x_msg_data is ' || x_msg_data, 'SHIP_CONFIRM_LPN_DELIVERIES');
4852: END IF;
4853: /* commented for DHERRING Bug#5651219
4854: wsh_util_core.get_messages
4855: (p_init_msg_list => 'Y',
4856: x_summary => l_msg_data,
4857: x_details => l_summary,
4858: x_count => l_msg_count);*/

Line 5010: l_delivery_id_tab wsh_util_core.id_tab_type;

5006: l_debug number;
5007:
5008: /* Bug: 5585359: 10/09/06 Start*/
5009: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5010: l_delivery_id_tab wsh_util_core.id_tab_type;
5011: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5012: l_planned_flag VARCHAR2(1);
5013: /* Bug: 5585359: 10/09/06 - End*/
5014: