DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on INV_LOG_UTIL

Line 8: inv_log_util.TRACE(p_mesg, p_mod, p_level);

4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_TRX_UTIL_PUB';
5:
6: PROCEDURE TRACE(p_mesg VARCHAR2, p_mod VARCHAR2, p_level NUMBER := 9) IS
7: BEGIN
8: inv_log_util.TRACE(p_mesg, p_mod, p_level);
9: END;
10:
11: --
12: -- Name: INSERT_LINE_TRX

Line 120: inv_log_util.trace('p_process_flag is:' || p_process_flag, g_pkg_name || '.' || l_api_name, 5);

116: RAISE fnd_api.g_exc_error;
117: END IF;
118:
119: -- Start Bug 8939057
120: inv_log_util.trace('p_process_flag is:' || p_process_flag, g_pkg_name || '.' || l_api_name, 5);
121: inv_log_util.trace('p_relieve_reservations_flag is:' || p_relieve_reservations_flag, g_pkg_name || '.' || l_api_name, 5);
122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);
123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);

Line 121: inv_log_util.trace('p_relieve_reservations_flag is:' || p_relieve_reservations_flag, g_pkg_name || '.' || l_api_name, 5);

117: END IF;
118:
119: -- Start Bug 8939057
120: inv_log_util.trace('p_process_flag is:' || p_process_flag, g_pkg_name || '.' || l_api_name, 5);
121: inv_log_util.trace('p_relieve_reservations_flag is:' || p_relieve_reservations_flag, g_pkg_name || '.' || l_api_name, 5);
122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);
123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);
125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);

Line 122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);

118:
119: -- Start Bug 8939057
120: inv_log_util.trace('p_process_flag is:' || p_process_flag, g_pkg_name || '.' || l_api_name, 5);
121: inv_log_util.trace('p_relieve_reservations_flag is:' || p_relieve_reservations_flag, g_pkg_name || '.' || l_api_name, 5);
122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);
123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);
125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);
126: inv_log_util.trace('p_from_org_id is:' || p_org_id, g_pkg_name || '.' || l_api_name, 5);

Line 123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);

119: -- Start Bug 8939057
120: inv_log_util.trace('p_process_flag is:' || p_process_flag, g_pkg_name || '.' || l_api_name, 5);
121: inv_log_util.trace('p_relieve_reservations_flag is:' || p_relieve_reservations_flag, g_pkg_name || '.' || l_api_name, 5);
122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);
123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);
125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);
126: inv_log_util.trace('p_from_org_id is:' || p_org_id, g_pkg_name || '.' || l_api_name, 5);
127: inv_log_util.trace('p_to_org_id is :' || p_xfr_org_id, g_pkg_name || '.' || l_api_name, 5);

Line 124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);

120: inv_log_util.trace('p_process_flag is:' || p_process_flag, g_pkg_name || '.' || l_api_name, 5);
121: inv_log_util.trace('p_relieve_reservations_flag is:' || p_relieve_reservations_flag, g_pkg_name || '.' || l_api_name, 5);
122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);
123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);
125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);
126: inv_log_util.trace('p_from_org_id is:' || p_org_id, g_pkg_name || '.' || l_api_name, 5);
127: inv_log_util.trace('p_to_org_id is :' || p_xfr_org_id, g_pkg_name || '.' || l_api_name, 5);
128:

Line 125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);

121: inv_log_util.trace('p_relieve_reservations_flag is:' || p_relieve_reservations_flag, g_pkg_name || '.' || l_api_name, 5);
122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);
123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);
125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);
126: inv_log_util.trace('p_from_org_id is:' || p_org_id, g_pkg_name || '.' || l_api_name, 5);
127: inv_log_util.trace('p_to_org_id is :' || p_xfr_org_id, g_pkg_name || '.' || l_api_name, 5);
128:
129: -- Call GMF get transfer price only if FROM or TO org is process enabled.

Line 126: inv_log_util.trace('p_from_org_id is:' || p_org_id, g_pkg_name || '.' || l_api_name, 5);

122: inv_log_util.trace('p_opm_org_in_xfer is:' || p_opm_org_in_xfer, g_pkg_name || '.' || l_api_name, 5);
123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);
125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);
126: inv_log_util.trace('p_from_org_id is:' || p_org_id, g_pkg_name || '.' || l_api_name, 5);
127: inv_log_util.trace('p_to_org_id is :' || p_xfr_org_id, g_pkg_name || '.' || l_api_name, 5);
128:
129: -- Call GMF get transfer price only if FROM or TO org is process enabled.
130: IF (p_opm_org_in_xfer = 'Y') THEN

Line 127: inv_log_util.trace('p_to_org_id is :' || p_xfr_org_id, g_pkg_name || '.' || l_api_name, 5);

123: inv_log_util.trace('p_item_id is:' || p_item_id, g_pkg_name || '.' || l_api_name, 5);
124: inv_log_util.trace('p_trx_qty is:' || p_trx_qty, g_pkg_name || '.' || l_api_name, 5);
125: inv_log_util.trace('p_uom is:' || p_uom, g_pkg_name || '.' || l_api_name, 5);
126: inv_log_util.trace('p_from_org_id is:' || p_org_id, g_pkg_name || '.' || l_api_name, 5);
127: inv_log_util.trace('p_to_org_id is :' || p_xfr_org_id, g_pkg_name || '.' || l_api_name, 5);
128:
129: -- Call GMF get transfer price only if FROM or TO org is process enabled.
130: IF (p_opm_org_in_xfer = 'Y') THEN
131:

Line 132: inv_log_util.trace('Calling GMF_get_transfer_price_PUB.get_transfer_price', g_pkg_name || '.' || l_api_name, 5);

128:
129: -- Call GMF get transfer price only if FROM or TO org is process enabled.
130: IF (p_opm_org_in_xfer = 'Y') THEN
131:
132: inv_log_util.trace('Calling GMF_get_transfer_price_PUB.get_transfer_price', g_pkg_name || '.' || l_api_name, 5);
133:
134: GMF_get_transfer_price_PUB.get_transfer_price (
135: p_api_version => 1.0
136: , p_init_msg_list => 'F'

Line 167: inv_log_util.trace('X_return status is <> S',g_pkg_name || '.' || l_api_name, 5);

163: );
164:
165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
166: THEN
167: inv_log_util.trace('X_return status is <> S',g_pkg_name || '.' || l_api_name, 5);
168: x_transfer_price := 0;
169: END IF;
170:
171: inv_log_util.trace('x_transfer_price is:' || x_transfer_price, g_pkg_name || '.' || l_api_name, 5);

Line 171: inv_log_util.trace('x_transfer_price is:' || x_transfer_price, g_pkg_name || '.' || l_api_name, 5);

167: inv_log_util.trace('X_return status is <> S',g_pkg_name || '.' || l_api_name, 5);
168: x_transfer_price := 0;
169: END IF;
170:
171: inv_log_util.trace('x_transfer_price is:' || x_transfer_price, g_pkg_name || '.' || l_api_name, 5);
172: inv_log_util.trace('x_currency_code is :' || x_currency_code, g_pkg_name || '.' || l_api_name, 5);
173: END IF;
174: -- End Bug 8939057
175:

Line 172: inv_log_util.trace('x_currency_code is :' || x_currency_code, g_pkg_name || '.' || l_api_name, 5);

168: x_transfer_price := 0;
169: END IF;
170:
171: inv_log_util.trace('x_transfer_price is:' || x_transfer_price, g_pkg_name || '.' || l_api_name, 5);
172: inv_log_util.trace('x_currency_code is :' || x_currency_code, g_pkg_name || '.' || l_api_name, 5);
173: END IF;
174: -- End Bug 8939057
175:
176: IF (p_trx_action_id = inv_globals.g_action_issue)

Line 1418: inv_log_util.trace('Creating a new record in MMTT from TxnTempID = ' || p_transaction_temp_id, g_pkg_name || '.' || l_api_name, 5);

1414: BEGIN
1415: x_return_status := fnd_api.g_ret_sts_success;
1416:
1417: IF l_debug = 1 THEN
1418: inv_log_util.trace('Creating a new record in MMTT from TxnTempID = ' || p_transaction_temp_id, g_pkg_name || '.' || l_api_name, 5);
1419: END IF;
1420:
1421: -- Transaction Temp ID has to be passed with a valid value.
1422: IF p_transaction_temp_id IS NULL OR p_transaction_temp_id = fnd_api.g_miss_num THEN

Line 1424: inv_log_util.trace('Error: Transaction Temp ID has to be passed', g_pkg_name || '.' || l_api_name, 3);

1420:
1421: -- Transaction Temp ID has to be passed with a valid value.
1422: IF p_transaction_temp_id IS NULL OR p_transaction_temp_id = fnd_api.g_miss_num THEN
1423: IF l_debug = 1 THEN
1424: inv_log_util.trace('Error: Transaction Temp ID has to be passed', g_pkg_name || '.' || l_api_name, 3);
1425: END IF;
1426: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1427: fnd_msg_pub.ADD;
1428: RAISE fnd_api.g_exc_error;

Line 1438: inv_log_util.trace('Error: ItemID, OrgID, PriQty, TxnQty, TxnUOM, TxnTypeID, TxnActionID, TxnSourceTypeID or TxnDate is invalid', g_pkg_name || '.' || l_api_name, 3);

1434: OR (p_txn_type_id = fnd_api.g_miss_num OR p_txn_action_id = fnd_api.g_miss_num OR p_txn_source_type_id = fnd_api.g_miss_num)
1435: OR (p_transaction_date = fnd_api.g_miss_date) )
1436: THEN
1437: IF l_debug = 1 THEN
1438: inv_log_util.trace('Error: ItemID, OrgID, PriQty, TxnQty, TxnUOM, TxnTypeID, TxnActionID, TxnSourceTypeID or TxnDate is invalid', g_pkg_name || '.' || l_api_name, 3);
1439: inv_log_util.trace('Error: The passed value will make the Not NULLABLE column NULL', g_pkg_name || '.' || l_api_name, 3);
1440: END IF;
1441: fnd_message.set_name('INV','INV_DATA_ERROR');
1442: fnd_message.set_token('ENTITY',l_api_name);

Line 1439: inv_log_util.trace('Error: The passed value will make the Not NULLABLE column NULL', g_pkg_name || '.' || l_api_name, 3);

1435: OR (p_transaction_date = fnd_api.g_miss_date) )
1436: THEN
1437: IF l_debug = 1 THEN
1438: inv_log_util.trace('Error: ItemID, OrgID, PriQty, TxnQty, TxnUOM, TxnTypeID, TxnActionID, TxnSourceTypeID or TxnDate is invalid', g_pkg_name || '.' || l_api_name, 3);
1439: inv_log_util.trace('Error: The passed value will make the Not NULLABLE column NULL', g_pkg_name || '.' || l_api_name, 3);
1440: END IF;
1441: fnd_message.set_name('INV','INV_DATA_ERROR');
1442: fnd_message.set_token('ENTITY',l_api_name);
1443: fnd_msg_pub.ADD;

Line 1458: inv_log_util.trace('Error: No Record found for the given Transaction Temp ID', g_pkg_name || '.' || l_api_name, 3);

1454: FETCH c_mmtt_info INTO l_organization_id, l_inventory_item_id, l_transaction_uom;
1455: IF c_mmtt_info%NOTFOUND THEN
1456: CLOSE c_mmtt_info;
1457: IF l_debug = 1 THEN
1458: inv_log_util.trace('Error: No Record found for the given Transaction Temp ID', g_pkg_name || '.' || l_api_name, 3);
1459: END IF;
1460: RAISE fnd_api.g_exc_error;
1461: END IF;
1462: CLOSE c_mmtt_info;

Line 1475: inv_log_util.trace('Error: Period is not open for the Organization', g_pkg_name || '.' || l_api_name, 3);

1471:
1472: -- Open Period Check
1473: invttmtx.tdatechk(l_organization_id, l_transaction_date, l_acct_period_id, l_open_past_period);
1474: IF l_acct_period_id = -1 OR l_acct_period_id = 0 THEN
1475: inv_log_util.trace('Error: Period is not open for the Organization', g_pkg_name || '.' || l_api_name, 3);
1476: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
1477: fnd_msg_pub.ADD;
1478: RAISE fnd_api.g_exc_error;
1479: END IF;

Line 1937: inv_log_util.trace('Inserted a new record into MMTT with TxnTempID = ' || x_new_txn_temp_id, g_pkg_name || '.' || l_api_name, 5);

1933: FROM mtl_material_transactions_temp
1934: WHERE transaction_temp_id = p_transaction_temp_id;
1935:
1936: IF l_debug = 1 THEN
1937: inv_log_util.trace('Inserted a new record into MMTT with TxnTempID = ' || x_new_txn_temp_id, g_pkg_name || '.' || l_api_name, 5);
1938: END IF;
1939: EXCEPTION
1940: WHEN fnd_api.g_exc_error THEN
1941: x_return_status := fnd_api.g_ret_sts_error;