APPS.INV_MO_LINE_DETAIL_UTIL dependencies on INV_MO_LINE_DETAIL_UTIL

Line 1: PACKAGE BODY inv_mo_line_detail_util AS

1: PACKAGE BODY inv_mo_line_detail_util AS
2: /* $Header: INVUTLDB.pls 120.1 2008/02/08 09:08:51 aysaha ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MO_LINE_DETAIL_UTIL';

2: /* $Header: INVUTLDB.pls 120.1 2008/02/08 09:08:51 aysaha ship $ */
3:
4: -- Global constant holding the package name
5:
6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MO_LINE_DETAIL_UTIL';
7:
8: PROCEDURE DEBUG(p_message IN VARCHAR2, p_module IN VARCHAR2) IS
9: BEGIN
10: inv_log_util.trace(p_message, p_module, 9);

Line 2088: , p_mold_table IN inv_mo_line_detail_util.g_update_qty_tbl_type

2084:
2085: -- This API currently works only for no control and lot controlled items
2086: PROCEDURE update_quantity_allocations(
2087: p_move_order_line_id IN NUMBER
2088: , p_mold_table IN inv_mo_line_detail_util.g_update_qty_tbl_type
2089: , x_mold_table OUT NOCOPY inv_mo_line_detail_util.g_mmtt_tbl_type
2090: , x_return_status OUT NOCOPY VARCHAR2
2091: , x_msg_count OUT NOCOPY NUMBER
2092: , x_msg_data OUT NOCOPY VARCHAR2

Line 2089: , x_mold_table OUT NOCOPY inv_mo_line_detail_util.g_mmtt_tbl_type

2085: -- This API currently works only for no control and lot controlled items
2086: PROCEDURE update_quantity_allocations(
2087: p_move_order_line_id IN NUMBER
2088: , p_mold_table IN inv_mo_line_detail_util.g_update_qty_tbl_type
2089: , x_mold_table OUT NOCOPY inv_mo_line_detail_util.g_mmtt_tbl_type
2090: , x_return_status OUT NOCOPY VARCHAR2
2091: , x_msg_count OUT NOCOPY NUMBER
2092: , x_msg_data OUT NOCOPY VARCHAR2
2093: ) IS

Line 2265: fnd_message.set_token('ROUTINE', 'inv_mo_line_detail_util.update_quantity_allocations');

2261:
2262: IF l_primary_quantity = -99999 THEN
2263: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2264: fnd_message.set_token('UOM', p_mold_table(i).transaction_uom);
2265: fnd_message.set_token('ROUTINE', 'inv_mo_line_detail_util.update_quantity_allocations');
2266: fnd_msg_pub.ADD;
2267: RAISE fnd_api.g_exc_error;
2268: END IF;
2269:

Line 2450: x_mold_table := inv_mo_line_detail_util.query_rows(p_move_order_line_id);

2446: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2447: END IF;
2448:
2449: -- Requery the MMTT rows and pass them back as the output parameter
2450: x_mold_table := inv_mo_line_detail_util.query_rows(p_move_order_line_id);
2451: -- Get message count and data
2452: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2453: EXCEPTION
2454: WHEN TOO_MANY_ROWS THEN

Line 3073: END inv_mo_line_detail_util;

3069: END IF;
3070:
3071: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3072: END is_line_detailed;
3073: END inv_mo_line_detail_util;