APPS.INV_DETAIL_UTIL_PVT dependencies on INV_DETAIL_UTIL_PVT

Line 1: PACKAGE BODY inv_detail_util_pvt AS

1: PACKAGE BODY inv_detail_util_pvt AS
2: /* $Header: INVVDEUB.pls 120.33.12020000.6 2013/02/22 21:49:34 sahmahes ship $ */
3: --
4: -- File : INVVDEUB.pls
5: -- Content : INV_DETAIL_UTIL_PVT package body

Line 5: -- Content : INV_DETAIL_UTIL_PVT package body

1: PACKAGE BODY inv_detail_util_pvt AS
2: /* $Header: INVVDEUB.pls 120.33.12020000.6 2013/02/22 21:49:34 sahmahes ship $ */
3: --
4: -- File : INVVDEUB.pls
5: -- Content : INV_DETAIL_UTIL_PVT package body
6: -- Description : utlitities used by the detailing engine (both inv and wms versions)
7: -- Notes :
8: -- Modified : 10/22/99 bitang created
9: -- Modified : 04/04/2002 grao bug# 228645

Line 12: g_pkg_name VARCHAR2(30) := 'INV_DETAIL_UTIL_PVT';

8: -- Modified : 10/22/99 bitang created
9: -- Modified : 04/04/2002 grao bug# 228645
10: -- Package name used in error messages
11: --
12: g_pkg_name VARCHAR2(30) := 'INV_DETAIL_UTIL_PVT';
13: g_version_printed BOOLEAN := FALSE;
14: --
15: TYPE g_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16: --

Line 1807: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;

1803: AND nvl(msn.end_item_unit_number,'@') = nvl(p_unit_number,'@')
1804: AND msn.current_status = 3;
1805:
1806: l_allocate_serial_flag VARCHAR2(1);
1807: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1808: l_selected_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1809:
1810: BEGIN
1811: x_return_status := fnd_api.g_ret_sts_success ;

Line 1808: l_selected_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;

1804: AND msn.current_status = 3;
1805:
1806: l_allocate_serial_flag VARCHAR2(1);
1807: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1808: l_selected_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1809:
1810: BEGIN
1811: x_return_status := fnd_api.g_ret_sts_success ;
1812: x_available_sl_qty := 0;

Line 4312: print_debug('INV_DETAIL_UTIL_PVT:'||l_api_name||': Error occured'||l_progress, 1);

4308: EXCEPTION
4309: WHEN OTHERS THEN
4310: IF (l_debug = 1) THEN
4311: l_progress := 'WMSSCC-0890';
4312: print_debug('INV_DETAIL_UTIL_PVT:'||l_api_name||': Error occured'||l_progress, 1);
4313: RAISE fnd_api.g_exc_unexpected_error;
4314: END IF;
4315: END;
4316:

Line 4346: print_debug('INV_DETAIL_UTIL_PVT:'||l_api_name||': Error occured'||l_progress, 1);

4342: l_status_return:= 'N';
4343: WHEN OTHERS THEN
4344: IF (l_debug = 1) THEN
4345: l_progress := 'WMSSCC-08891';
4346: print_debug('INV_DETAIL_UTIL_PVT:'||l_api_name||': Error occured'||l_progress, 1);
4347: END IF;
4348: END;
4349: RETURN l_status_return;
4350:

Line 4356: END inv_detail_util_pvt;

4352: END is_onhand_status_trx_allowed;
4353:
4354: -- LPN Status Project
4355:
4356: END inv_detail_util_pvt;