eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRX_UTIL_PUB dependencies on FND_API

Line 92: RAISE fnd_api.g_exc_error;

88: IF (v_acct_period_id = 0)
89: OR(v_acct_period_id = -1) THEN
90: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
91: fnd_msg_pub.ADD;
92: RAISE fnd_api.g_exc_error;
93: END IF;
94:
95: IF (p_trx_action_id = inv_globals.g_action_issue)
96: OR(p_trx_action_id = inv_globals.g_action_intransitshipment) THEN

Line 245: WHEN fnd_api.g_exc_error THEN

241:
242:
243: RETURN 0;
244: EXCEPTION
245: WHEN fnd_api.g_exc_error THEN
246: x_proc_msg := fnd_msg_pub.get(1, 'F');
247: RETURN -1;
248: WHEN OTHERS THEN
249: x_proc_msg := SUBSTR(SQLERRM, 1, 200);

Line 899: IF (p_validation_level = fnd_api.g_valid_level_full) THEN

895: missing serial number error.
896: */
897:
898: /* Uncommented following IF condition for bug 7322274 */
899: IF (p_validation_level = fnd_api.g_valid_level_full) THEN
900: BEGIN
901: SELECT mmtt.transaction_temp_id
902: , mmtt.transaction_header_id
903: , mmtt.inventory_item_id

Line 1286: x_return_status := fnd_api.g_ret_sts_success;

1282: FROM mtl_system_items msi
1283: WHERE msi.inventory_item_id = l_inventory_item_id
1284: AND msi.organization_id = l_organization_id;
1285: BEGIN
1286: x_return_status := fnd_api.g_ret_sts_success;
1287:
1288: IF l_debug = 1 THEN
1289: inv_log_util.trace('Creating a new record in MMTT from TxnTempID = ' || p_transaction_temp_id, g_pkg_name || '.' || l_api_name, 5);
1290: END IF;

Line 1293: IF p_transaction_temp_id IS NULL OR p_transaction_temp_id = fnd_api.g_miss_num THEN

1289: inv_log_util.trace('Creating a new record in MMTT from TxnTempID = ' || p_transaction_temp_id, g_pkg_name || '.' || l_api_name, 5);
1290: END IF;
1291:
1292: -- Transaction Temp ID has to be passed with a valid value.
1293: IF p_transaction_temp_id IS NULL OR p_transaction_temp_id = fnd_api.g_miss_num THEN
1294: IF l_debug = 1 THEN
1295: inv_log_util.trace('Error: Transaction Temp ID has to be passed', g_pkg_name || '.' || l_api_name, 3);
1296: END IF;
1297: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

Line 1299: RAISE fnd_api.g_exc_error;

1295: inv_log_util.trace('Error: Transaction Temp ID has to be passed', g_pkg_name || '.' || l_api_name, 3);
1296: END IF;
1297: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1298: fnd_msg_pub.ADD;
1299: RAISE fnd_api.g_exc_error;
1300: END IF;
1301:
1302: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1303: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)

Line 1303: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)

1299: RAISE fnd_api.g_exc_error;
1300: END IF;
1301:
1302: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1303: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1304: OR (p_txn_qty = fnd_api.g_miss_num OR p_primary_qty = fnd_api.g_miss_num OR p_transaction_uom = fnd_api.g_miss_char)
1305: 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)
1306: OR (p_transaction_date = fnd_api.g_miss_date) )
1307: THEN

Line 1304: OR (p_txn_qty = fnd_api.g_miss_num OR p_primary_qty = fnd_api.g_miss_num OR p_transaction_uom = fnd_api.g_miss_char)

1300: END IF;
1301:
1302: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1303: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1304: OR (p_txn_qty = fnd_api.g_miss_num OR p_primary_qty = fnd_api.g_miss_num OR p_transaction_uom = fnd_api.g_miss_char)
1305: 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)
1306: OR (p_transaction_date = fnd_api.g_miss_date) )
1307: THEN
1308: IF l_debug = 1 THEN

Line 1305: 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)

1301:
1302: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1303: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1304: OR (p_txn_qty = fnd_api.g_miss_num OR p_primary_qty = fnd_api.g_miss_num OR p_transaction_uom = fnd_api.g_miss_char)
1305: 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)
1306: OR (p_transaction_date = fnd_api.g_miss_date) )
1307: THEN
1308: IF l_debug = 1 THEN
1309: inv_log_util.trace('Error: ItemID, OrgID, PriQty, TxnQty, TxnUOM, TxnTypeID, TxnActionID, TxnSourceTypeID or TxnDate is invalid', g_pkg_name || '.' || l_api_name, 3);

Line 1306: OR (p_transaction_date = fnd_api.g_miss_date) )

1302: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1303: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1304: OR (p_txn_qty = fnd_api.g_miss_num OR p_primary_qty = fnd_api.g_miss_num OR p_transaction_uom = fnd_api.g_miss_char)
1305: 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)
1306: OR (p_transaction_date = fnd_api.g_miss_date) )
1307: THEN
1308: IF l_debug = 1 THEN
1309: inv_log_util.trace('Error: ItemID, OrgID, PriQty, TxnQty, TxnUOM, TxnTypeID, TxnActionID, TxnSourceTypeID or TxnDate is invalid', g_pkg_name || '.' || l_api_name, 3);
1310: inv_log_util.trace('Error: The passed value will make the Not NULLABLE column NULL', g_pkg_name || '.' || l_api_name, 3);

Line 1315: RAISE fnd_api.g_exc_error;

1311: END IF;
1312: fnd_message.set_name('INV','INV_DATA_ERROR');
1313: fnd_message.set_token('ENTITY',l_api_name);
1314: fnd_msg_pub.ADD;
1315: RAISE fnd_api.g_exc_error;
1316: END IF;
1317:
1318: -- Querying MMTT to get some required values.
1319: IF (p_organization_id IS NULL

Line 1331: RAISE fnd_api.g_exc_error;

1327: CLOSE c_mmtt_info;
1328: IF l_debug = 1 THEN
1329: inv_log_util.trace('Error: No Record found for the given Transaction Temp ID', g_pkg_name || '.' || l_api_name, 3);
1330: END IF;
1331: RAISE fnd_api.g_exc_error;
1332: END IF;
1333: CLOSE c_mmtt_info;
1334: END IF;
1335:

Line 1349: RAISE fnd_api.g_exc_error;

1345: IF l_acct_period_id = -1 OR l_acct_period_id = 0 THEN
1346: inv_log_util.trace('Error: Period is not open for the Organization', g_pkg_name || '.' || l_api_name, 3);
1347: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
1348: fnd_msg_pub.ADD;
1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351:
1352: -- Conversion between Primary Qty and Transaction Qty
1353: IF (p_txn_qty IS NOT NULL AND p_primary_qty IS NULL) OR (p_txn_qty IS NULL AND p_primary_qty IS NOT NULL) THEN

Line 1360: RAISE fnd_api.g_exc_error;

1356: IF c_item_info%NOTFOUND THEN
1357: CLOSE c_item_info;
1358: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1359: fnd_msg_pub.ADD;
1360: RAISE fnd_api.g_exc_error;
1361: END IF;
1362: CLOSE c_item_info;
1363:
1364: IF l_primary_qty IS NULL THEN

Line 1380: RAISE fnd_api.g_exc_error;

1376: fnd_message.set_token('UOM1',l_transaction_uom);
1377: fnd_message.set_token('UOM2',l_primary_uom);
1378: fnd_message.set_token('MODULE',l_api_name);
1379: fnd_msg_pub.ADD;
1380: RAISE fnd_api.g_exc_error;
1381: END IF;
1382: ELSIF l_txn_qty IS NULL AND l_primary_qty IS NOT NULL THEN
1383: l_txn_qty := inv_convert.inv_um_convert(
1384: item_id => l_inventory_item_id

Line 1398: RAISE fnd_api.g_exc_error;

1394: fnd_message.set_token('UOM1',l_primary_uom);
1395: fnd_message.set_token('UOM2',l_transaction_uom);
1396: fnd_message.set_token('MODULE',l_api_name);
1397: fnd_msg_pub.ADD;
1398: RAISE fnd_api.g_exc_error;
1399: END IF;
1400: END IF;
1401: END IF;
1402:

Line 1601: SELECT decode(p_transaction_header_id, fnd_api.g_miss_num, NULL, NULL, transaction_header_id, p_transaction_header_id)

1597: , program_id
1598: , program_update_date
1599: , secondary_transaction_quantity --INVCONV kkillams
1600: )
1601: SELECT decode(p_transaction_header_id, fnd_api.g_miss_num, NULL, NULL, transaction_header_id, p_transaction_header_id)
1602: , x_new_txn_temp_id
1603: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1604: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1605: , decode(l_organization_id, NULL, organization_id, l_organization_id)

Line 1604: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)

1600: )
1601: SELECT decode(p_transaction_header_id, fnd_api.g_miss_num, NULL, NULL, transaction_header_id, p_transaction_header_id)
1602: , x_new_txn_temp_id
1603: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1604: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1605: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1606: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)

Line 1606: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)

1602: , x_new_txn_temp_id
1603: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1604: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1605: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1606: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)

Line 1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)

1603: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1604: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1605: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1606: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1611: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)

Line 1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)

1604: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1605: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1606: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1611: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1612: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)

Line 1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)

1605: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1606: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1611: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1612: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1613: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)

Line 1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)

1606: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1611: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1612: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1613: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1614: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)

Line 1611: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)

1607: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1611: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1612: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1613: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1614: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1615: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)

Line 1612: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)

1608: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1609: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1610: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1611: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1612: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1613: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1614: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1615: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1616: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)

Line 1616: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)

1612: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1613: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1614: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1615: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1616: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1617: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)

Line 1617: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)

1613: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1614: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1615: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1616: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1617: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1621: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)

Line 1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)

1614: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1615: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1616: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1617: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1621: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1622: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)

Line 1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)

1615: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1616: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1617: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1621: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1622: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1623: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)

Line 1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)

1616: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1617: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1621: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1622: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1623: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1624: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)

Line 1621: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)

1617: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1621: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1622: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1623: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1624: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1625: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)

Line 1622: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)

1618: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1619: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1620: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1621: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1622: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1623: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1624: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1625: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)
1626: , transaction_source_name

Line 1627: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)

1623: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1624: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1625: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)
1626: , transaction_source_name
1627: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1628: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1629: , trx_source_delivery_id
1630: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1631: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)

Line 1628: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)

1624: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1625: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)
1626: , transaction_source_name
1627: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1628: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1629: , trx_source_delivery_id
1630: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1631: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)
1632: , demand_source_delivery

Line 1630: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)

1626: , transaction_source_name
1627: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1628: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1629: , trx_source_delivery_id
1630: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1631: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)
1632: , demand_source_delivery
1633: , transaction_cost
1634: , l_transaction_date

Line 1631: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)

1627: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1628: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1629: , trx_source_delivery_id
1630: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1631: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)
1632: , demand_source_delivery
1633: , transaction_cost
1634: , l_transaction_date
1635: , l_acct_period_id

Line 1637: , decode(p_parent_line_id, fnd_api.g_miss_num, NULL, NULL, parent_line_id, p_parent_line_id)

1633: , transaction_cost
1634: , l_transaction_date
1635: , l_acct_period_id
1636: , distribution_account_id
1637: , decode(p_parent_line_id, fnd_api.g_miss_num, NULL, NULL, parent_line_id, p_parent_line_id)
1638: , parent_transaction_temp_id
1639: , decode(p_pick_slip_number, fnd_api.g_miss_num, NULL, NULL, pick_slip_number, p_pick_slip_number)
1640: , container_item_id
1641: , cartonization_id

Line 1639: , decode(p_pick_slip_number, fnd_api.g_miss_num, NULL, NULL, pick_slip_number, p_pick_slip_number)

1635: , l_acct_period_id
1636: , distribution_account_id
1637: , decode(p_parent_line_id, fnd_api.g_miss_num, NULL, NULL, parent_line_id, p_parent_line_id)
1638: , parent_transaction_temp_id
1639: , decode(p_pick_slip_number, fnd_api.g_miss_num, NULL, NULL, pick_slip_number, p_pick_slip_number)
1640: , container_item_id
1641: , cartonization_id
1642: , standard_operation_id
1643: , decode(p_operation_plan_id, fnd_api.g_miss_num, NULL, NULL, operation_plan_id, p_operation_plan_id) --lezhang

Line 1643: , decode(p_operation_plan_id, fnd_api.g_miss_num, NULL, NULL, operation_plan_id, p_operation_plan_id) --lezhang

1639: , decode(p_pick_slip_number, fnd_api.g_miss_num, NULL, NULL, pick_slip_number, p_pick_slip_number)
1640: , container_item_id
1641: , cartonization_id
1642: , standard_operation_id
1643: , decode(p_operation_plan_id, fnd_api.g_miss_num, NULL, NULL, operation_plan_id, p_operation_plan_id) --lezhang
1644: , decode(p_wms_task_type, fnd_api.g_miss_num, NULL, NULL, wms_task_type, p_wms_task_type)
1645: , wms_task_status
1646: , task_priority
1647: , task_group_id

Line 1644: , decode(p_wms_task_type, fnd_api.g_miss_num, NULL, NULL, wms_task_type, p_wms_task_type)

1640: , container_item_id
1641: , cartonization_id
1642: , standard_operation_id
1643: , decode(p_operation_plan_id, fnd_api.g_miss_num, NULL, NULL, operation_plan_id, p_operation_plan_id) --lezhang
1644: , decode(p_wms_task_type, fnd_api.g_miss_num, NULL, NULL, wms_task_type, p_wms_task_type)
1645: , wms_task_status
1646: , task_priority
1647: , task_group_id
1648: , transaction_reference

Line 1793: , decode(p_sec_txn_qty, fnd_api.g_miss_num, NULL, NULL, secondary_transaction_quantity, p_sec_txn_qty) --INVCONV KKILLAMS

1789: , request_id
1790: , program_application_id
1791: , program_id
1792: , program_update_date
1793: , decode(p_sec_txn_qty, fnd_api.g_miss_num, NULL, NULL, secondary_transaction_quantity, p_sec_txn_qty) --INVCONV KKILLAMS
1794: FROM mtl_material_transactions_temp
1795: WHERE transaction_temp_id = p_transaction_temp_id;
1796:
1797: IF l_debug = 1 THEN

Line 1801: WHEN fnd_api.g_exc_error THEN

1797: IF l_debug = 1 THEN
1798: inv_log_util.trace('Inserted a new record into MMTT with TxnTempID = ' || x_new_txn_temp_id, g_pkg_name || '.' || l_api_name, 5);
1799: END IF;
1800: EXCEPTION
1801: WHEN fnd_api.g_exc_error THEN
1802: x_return_status := fnd_api.g_ret_sts_error;
1803: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1802: x_return_status := fnd_api.g_ret_sts_error;

1798: inv_log_util.trace('Inserted a new record into MMTT with TxnTempID = ' || x_new_txn_temp_id, g_pkg_name || '.' || l_api_name, 5);
1799: END IF;
1800: EXCEPTION
1801: WHEN fnd_api.g_exc_error THEN
1802: x_return_status := fnd_api.g_ret_sts_error;
1803: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1804: WHEN fnd_api.g_exc_unexpected_error THEN

1800: EXCEPTION
1801: WHEN fnd_api.g_exc_error THEN
1802: x_return_status := fnd_api.g_ret_sts_error;
1803: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1805: x_return_status := fnd_api.g_ret_sts_unexp_error;

1801: WHEN fnd_api.g_exc_error THEN
1802: x_return_status := fnd_api.g_ret_sts_error;
1803: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: x_return_status := fnd_api.g_ret_sts_unexp_error;
1809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1808: x_return_status := fnd_api.g_ret_sts_unexp_error;

1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: x_return_status := fnd_api.g_ret_sts_unexp_error;
1809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1811: END IF;
1812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1886: x_return_status := fnd_api.g_ret_sts_success;

1882: AND msi.organization_id = mmtt.organization_id;
1883:
1884: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1885: BEGIN
1886: x_return_status := fnd_api.g_ret_sts_success;
1887:
1888: IF l_debug = 1 THEN
1889: TRACE('Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1890: END IF;

Line 1917: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1913: , p_lot_control_code => l_lot_control_code
1914: , p_serial_control_code => l_serial_control_code
1915: );
1916:
1917: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1918: IF l_debug = 1 THEN
1919: TRACE('Error occurred while updating the Parent Record', 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1920: END IF;
1921:

Line 1922: RAISE fnd_api.g_exc_error;

1918: IF l_debug = 1 THEN
1919: TRACE('Error occurred while updating the Parent Record', 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1920: END IF;
1921:
1922: RAISE fnd_api.g_exc_error;
1923: END IF;
1924: END IF;
1925:
1926: -- Unmarking and Deleting all the Serials associated with the Transaction

Line 1991: x_return_status := fnd_api.g_ret_sts_error;

1987: TRACE('Records deleted in MMTT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1988: END IF;
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: x_return_status := fnd_api.g_ret_sts_error;
1992: TRACE('Exception Occurred = ' || SQLERRM, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1993: END delete_transaction;
1994:
1995: PROCEDURE delete_lot_ser_trx(

Line 2013: x_return_status := fnd_api.g_ret_sts_success;

2009: SELECT serial_transaction_temp_id
2010: FROM mtl_transaction_lots_temp
2011: WHERE transaction_temp_id = l_txn_tmp_id;
2012: BEGIN
2013: x_return_status := fnd_api.g_ret_sts_success;
2014: TRACE('parameters passed to delete_lot_ser_trx', 'INVTRXUB', 9);
2015: TRACE('p_trx_tmp_id = '|| p_trx_tmp_id|| 'p_org_id = '|| p_org_id|| 'p_item_id = '|| p_item_id|| 'p_lotctrl = '|| p_lotctrl|| 'p_serctrl = '|| p_serctrl, 'INVTRXUB', 9);
2016:
2017: IF (p_trx_tmp_id IS NULL) OR(p_org_id IS NULL) OR(p_item_id IS NULL) OR(p_lotctrl IS NULL) OR(p_serctrl IS NULL) THEN

Line 2019: RAISE fnd_api.g_exc_error;

2015: TRACE('p_trx_tmp_id = '|| p_trx_tmp_id|| 'p_org_id = '|| p_org_id|| 'p_item_id = '|| p_item_id|| 'p_lotctrl = '|| p_lotctrl|| 'p_serctrl = '|| p_serctrl, 'INVTRXUB', 9);
2016:
2017: IF (p_trx_tmp_id IS NULL) OR(p_org_id IS NULL) OR(p_item_id IS NULL) OR(p_lotctrl IS NULL) OR(p_serctrl IS NULL) THEN
2018: TRACE('Parameter passed is null...', 'INVTRXUB', 9);
2019: RAISE fnd_api.g_exc_error;
2020: END IF;
2021:
2022: IF ((p_serctrl <> 1) AND(p_lotctrl <> 2)) THEN
2023: --Item is only serial controlled

Line 2080: x_return_status := fnd_api.g_ret_sts_success;

2076: END IF;
2077:
2078:
2079:
2080: x_return_status := fnd_api.g_ret_sts_success;
2081: EXCEPTION
2082: WHEN fnd_api.g_exc_error THEN
2083: TRACE('Expected error has occured...', 'INVTRXUB', 9);
2084: x_return_status := fnd_api.g_ret_sts_error;

Line 2082: WHEN fnd_api.g_exc_error THEN

2078:
2079:
2080: x_return_status := fnd_api.g_ret_sts_success;
2081: EXCEPTION
2082: WHEN fnd_api.g_exc_error THEN
2083: TRACE('Expected error has occured...', 'INVTRXUB', 9);
2084: x_return_status := fnd_api.g_ret_sts_error;
2085: WHEN OTHERS THEN
2086: TRACE('Unexpected error has occured...', 'INVTRXUB', 9);

Line 2084: x_return_status := fnd_api.g_ret_sts_error;

2080: x_return_status := fnd_api.g_ret_sts_success;
2081: EXCEPTION
2082: WHEN fnd_api.g_exc_error THEN
2083: TRACE('Expected error has occured...', 'INVTRXUB', 9);
2084: x_return_status := fnd_api.g_ret_sts_error;
2085: WHEN OTHERS THEN
2086: TRACE('Unexpected error has occured...', 'INVTRXUB', 9);
2087: TRACE('SQLERRM...' || SUBSTR(SQLERRM, 1, 100), 'INVTRXUB', 9);
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2088: x_return_status := fnd_api.g_ret_sts_unexp_error;

2084: x_return_status := fnd_api.g_ret_sts_error;
2085: WHEN OTHERS THEN
2086: TRACE('Unexpected error has occured...', 'INVTRXUB', 9);
2087: TRACE('SQLERRM...' || SUBSTR(SQLERRM, 1, 100), 'INVTRXUB', 9);
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: END delete_lot_ser_trx;
2090:
2091: /*
2092: * Procedure: UPDATE_PARENT_MMTT

Line 2127: x_return_status := fnd_api.g_ret_sts_success;

2123: FROM mtl_material_transactions_temp c, mtl_material_transactions_temp p
2124: WHERE c.transaction_temp_id = p_child_line_id
2125: AND p.transaction_temp_id = p_parent_line_id;
2126: BEGIN
2127: x_return_status := fnd_api.g_ret_sts_success;
2128:
2129: OPEN c_child_details;
2130: FETCH c_child_details INTO l_item_id, l_child_pri_qty, l_child_txn_qty, l_child_uom, l_parent_uom;
2131: IF c_child_details%NOTFOUND THEN

Line 2133: x_return_status := fnd_api.g_ret_sts_error;

2129: OPEN c_child_details;
2130: FETCH c_child_details INTO l_item_id, l_child_pri_qty, l_child_txn_qty, l_child_uom, l_parent_uom;
2131: IF c_child_details%NOTFOUND THEN
2132: TRACE('Either Parent TxnTempID or Child TxnTempID is invalid', 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2133: x_return_status := fnd_api.g_ret_sts_error;
2134: RETURN;
2135: END IF;
2136:
2137: -- Delete the Serials

Line 2216: l_api_return_status := fnd_api.g_ret_sts_success;

2212: TRACE('Checking if parent should be archived: Txn Temp ID = ' || p_parent_line_id
2213: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2214: END IF;
2215:
2216: l_api_return_status := fnd_api.g_ret_sts_success;
2217: inv_parent_mmtt_pvt.process_parent
2218: ( x_return_status => l_api_return_status
2219: , p_parent_temp_id => p_parent_line_id
2220: );

Line 2222: IF l_api_return_status <> fnd_api.g_ret_sts_success

2218: ( x_return_status => l_api_return_status
2219: , p_parent_temp_id => p_parent_line_id
2220: );
2221:
2222: IF l_api_return_status <> fnd_api.g_ret_sts_success
2223: THEN
2224: IF l_debug = 1 THEN
2225: TRACE('Error from inv_parent_mmtt_pvt.process_parent'
2226: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

Line 2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2224: IF l_debug = 1 THEN
2225: TRACE('Error from inv_parent_mmtt_pvt.process_parent'
2226: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2227: END IF;
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230: ELSE
2231: IF l_debug = 1 THEN
2232: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

Line 2241: x_return_status := fnd_api.g_ret_sts_unexp_error;

2237: END IF;
2238: END IF;
2239: EXCEPTION
2240: WHEN OTHERS THEN
2241: x_return_status := fnd_api.g_ret_sts_unexp_error;
2242:
2243: IF (l_debug = 1) THEN
2244: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2245: END IF;