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 116: RAISE fnd_api.g_exc_error;

112: IF (v_acct_period_id = 0)
113: OR(v_acct_period_id = -1) THEN
114: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
115: fnd_msg_pub.ADD;
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);

Line 165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

161: , x_incr_transfer_price => x_incr_transfer_price
162: , x_incr_currency_code => x_incr_currency_code
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;

Line 373: WHEN fnd_api.g_exc_error THEN

369:
370:
371: RETURN 0;
372: EXCEPTION
373: WHEN fnd_api.g_exc_error THEN
374: x_proc_msg := fnd_msg_pub.get(1, 'F');
375: RETURN -1;
376: WHEN OTHERS THEN
377: x_proc_msg := SUBSTR(SQLERRM, 1, 200);

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

1023: missing serial number error.
1024: */
1025:
1026: /* Uncommented following IF condition for bug 7322274 */
1027: IF (p_validation_level = fnd_api.g_valid_level_full) THEN
1028: BEGIN
1029: SELECT mmtt.transaction_temp_id
1030: , mmtt.transaction_header_id
1031: , mmtt.inventory_item_id

Line 1415: x_return_status := fnd_api.g_ret_sts_success;

1411: FROM mtl_system_items msi
1412: WHERE msi.inventory_item_id = l_inventory_item_id
1413: AND msi.organization_id = l_organization_id;
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;

Line 1422: IF p_transaction_temp_id IS NULL OR p_transaction_temp_id = fnd_api.g_miss_num 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
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');

Line 1428: RAISE fnd_api.g_exc_error;

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;
1429: END IF;
1430:
1431: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1432: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)

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

1428: RAISE fnd_api.g_exc_error;
1429: END IF;
1430:
1431: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1432: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1433: 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)
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

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

1429: END IF;
1430:
1431: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1432: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1433: 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)
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

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

1430:
1431: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1432: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1433: 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)
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);

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

1431: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate
1432: IF ( (p_inventory_item_id = fnd_api.g_miss_num OR p_organization_id = fnd_api.g_miss_num)
1433: 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)
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);

Line 1444: RAISE fnd_api.g_exc_error;

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;
1444: RAISE fnd_api.g_exc_error;
1445: END IF;
1446:
1447: -- Querying MMTT to get some required values.
1448: IF (p_organization_id IS NULL

Line 1460: RAISE fnd_api.g_exc_error;

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;
1463: END IF;
1464:

Line 1478: RAISE fnd_api.g_exc_error;

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;
1480:
1481: -- Conversion between Primary Qty and Transaction Qty
1482: 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 1489: RAISE fnd_api.g_exc_error;

1485: IF c_item_info%NOTFOUND THEN
1486: CLOSE c_item_info;
1487: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1488: fnd_msg_pub.ADD;
1489: RAISE fnd_api.g_exc_error;
1490: END IF;
1491: CLOSE c_item_info;
1492:
1493: IF l_primary_qty IS NULL THEN

Line 1509: RAISE fnd_api.g_exc_error;

1505: fnd_message.set_token('UOM1',l_transaction_uom);
1506: fnd_message.set_token('UOM2',l_primary_uom);
1507: fnd_message.set_token('MODULE',l_api_name);
1508: fnd_msg_pub.ADD;
1509: RAISE fnd_api.g_exc_error;
1510: END IF;
1511: ELSIF l_txn_qty IS NULL AND l_primary_qty IS NOT NULL THEN
1512: l_txn_qty := inv_convert.inv_um_convert(
1513: item_id => l_inventory_item_id

Line 1527: RAISE fnd_api.g_exc_error;

1523: fnd_message.set_token('UOM1',l_primary_uom);
1524: fnd_message.set_token('UOM2',l_transaction_uom);
1525: fnd_message.set_token('MODULE',l_api_name);
1526: fnd_msg_pub.ADD;
1527: RAISE fnd_api.g_exc_error;
1528: END IF;
1529: END IF;
1530: END IF;
1531:

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

1735: , program_update_date
1736: , secondary_transaction_quantity --INVCONV kkillams
1737: , secondary_uom_code -- Bug#7716563
1738: )
1739: SELECT decode(p_transaction_header_id, fnd_api.g_miss_num, NULL, NULL, transaction_header_id, p_transaction_header_id)
1740: , x_new_txn_temp_id
1741: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1742: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1743: , decode(l_organization_id, NULL, organization_id, l_organization_id)

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

1738: )
1739: SELECT decode(p_transaction_header_id, fnd_api.g_miss_num, NULL, NULL, transaction_header_id, p_transaction_header_id)
1740: , x_new_txn_temp_id
1741: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1742: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1743: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1744: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1745: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)

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

1740: , x_new_txn_temp_id
1741: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1742: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1743: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1744: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1745: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1747: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1748: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)

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

1741: , decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1742: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1743: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1744: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1745: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1747: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1748: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1749: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)

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

1742: , decode(p_revision, fnd_api.g_miss_char, NULL, NULL, revision, p_revision)
1743: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1744: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1745: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1747: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1748: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1749: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1750: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)

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

1743: , decode(l_organization_id, NULL, organization_id, l_organization_id)
1744: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1745: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1747: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1748: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1749: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1750: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1751: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)

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

1744: , decode(p_subinventory_code, fnd_api.g_miss_char, NULL, NULL, subinventory_code, p_subinventory_code)
1745: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1747: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1748: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1749: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1750: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1751: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1752: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)

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

1745: , decode(p_locator_id, fnd_api.g_miss_num, NULL, NULL, locator_id, p_locator_id)
1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1747: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1748: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1749: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1750: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1751: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1752: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1753: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)

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

1746: , decode(p_cost_group_id, fnd_api.g_miss_num, NULL, NULL, cost_group_id, p_cost_group_id)
1747: , decode(p_to_organization_id, fnd_api.g_miss_num, NULL, NULL, transfer_organization, p_to_organization_id)
1748: , decode(p_to_subinventory_code, fnd_api.g_miss_char, NULL, NULL, transfer_subinventory, p_to_subinventory_code)
1749: , decode(p_to_locator_id, fnd_api.g_miss_num, NULL, NULL, transfer_to_location, p_to_locator_id)
1750: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1751: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1752: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1753: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1754: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)

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

1750: , decode(p_to_cost_group_id, fnd_api.g_miss_num, NULL, NULL, transfer_cost_group_id, p_to_cost_group_id)
1751: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1752: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1753: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1754: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1755: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1756: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1757: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1758: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)

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

1751: , decode(l_txn_qty, NULL, transaction_quantity, l_txn_qty)
1752: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1753: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1754: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1755: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1756: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1757: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1758: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1759: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)

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

1752: , decode(l_primary_qty, NULL, primary_quantity, l_primary_qty)
1753: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1754: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1755: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1756: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1757: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1758: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1759: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1760: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)

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

1753: , decode(l_transaction_uom, NULL, transaction_uom, l_transaction_uom)
1754: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1755: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1756: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1757: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1758: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1759: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1760: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1761: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)

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

1754: , decode(p_move_order_header_id, fnd_api.g_miss_num, NULL, NULL, move_order_header_id, p_move_order_header_id)
1755: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1756: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1757: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1758: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1759: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1760: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1761: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1762: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)

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

1755: , decode(p_move_order_line_id, fnd_api.g_miss_num, NULL, NULL, move_order_line_id, p_move_order_line_id)
1756: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1757: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1758: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1759: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1760: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1761: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1762: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1763: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)

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

1756: , decode(p_serial_allocated_flag, fnd_api.g_miss_char, NULL, NULL, serial_allocated_flag, p_serial_allocated_flag)
1757: , decode(p_reservation_id, fnd_api.g_miss_num, NULL, NULL, reservation_id, p_reservation_id)
1758: , decode(p_lpn_id, fnd_api.g_miss_num, NULL, NULL, lpn_id, p_lpn_id)
1759: , decode(p_transfer_lpn_id, fnd_api.g_miss_num, NULL, NULL, transfer_lpn_id, p_transfer_lpn_id)
1760: , decode(p_content_lpn_id, fnd_api.g_miss_num, NULL, NULL, content_lpn_id, p_content_lpn_id)
1761: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1762: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1763: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)
1764: , transaction_source_name

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

1761: , decode(p_txn_type_id, NULL, transaction_type_id, p_txn_type_id)
1762: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1763: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)
1764: , transaction_source_name
1765: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1766: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1767: , trx_source_delivery_id
1768: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1769: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)

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

1762: , decode(p_txn_action_id, NULL, transaction_action_id, p_txn_action_id)
1763: , decode(p_txn_source_type_id, NULL, transaction_source_type_id, p_txn_source_type_id)
1764: , transaction_source_name
1765: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1766: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1767: , trx_source_delivery_id
1768: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1769: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)
1770: , demand_source_delivery

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

1764: , transaction_source_name
1765: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1766: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1767: , trx_source_delivery_id
1768: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1769: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)
1770: , demand_source_delivery
1771: , transaction_cost
1772: , l_transaction_date

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

1765: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, transaction_source_id, p_transaction_source_id)
1766: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, trx_source_line_id, p_trx_source_line_id)
1767: , trx_source_delivery_id
1768: , decode(p_transaction_source_id, fnd_api.g_miss_num, NULL, NULL, demand_source_header_id, p_transaction_source_id)
1769: , decode(p_trx_source_line_id, fnd_api.g_miss_num, NULL, NULL, demand_source_line, p_trx_source_line_id)
1770: , demand_source_delivery
1771: , transaction_cost
1772: , l_transaction_date
1773: , l_acct_period_id

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

1771: , transaction_cost
1772: , l_transaction_date
1773: , l_acct_period_id
1774: , distribution_account_id
1775: , decode(p_parent_line_id, fnd_api.g_miss_num, NULL, NULL, parent_line_id, p_parent_line_id)
1776: , parent_transaction_temp_id
1777: , decode(p_pick_slip_number, fnd_api.g_miss_num, NULL, NULL, pick_slip_number, p_pick_slip_number)
1778: , container_item_id
1779: , cartonization_id

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

1773: , l_acct_period_id
1774: , distribution_account_id
1775: , decode(p_parent_line_id, fnd_api.g_miss_num, NULL, NULL, parent_line_id, p_parent_line_id)
1776: , parent_transaction_temp_id
1777: , decode(p_pick_slip_number, fnd_api.g_miss_num, NULL, NULL, pick_slip_number, p_pick_slip_number)
1778: , container_item_id
1779: , cartonization_id
1780: , standard_operation_id
1781: , decode(p_operation_plan_id, fnd_api.g_miss_num, NULL, NULL, operation_plan_id, p_operation_plan_id) --lezhang

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

1777: , decode(p_pick_slip_number, fnd_api.g_miss_num, NULL, NULL, pick_slip_number, p_pick_slip_number)
1778: , container_item_id
1779: , cartonization_id
1780: , standard_operation_id
1781: , decode(p_operation_plan_id, fnd_api.g_miss_num, NULL, NULL, operation_plan_id, p_operation_plan_id) --lezhang
1782: , decode(p_wms_task_type, fnd_api.g_miss_num, NULL, NULL, wms_task_type, p_wms_task_type)
1783: , wms_task_status
1784: , task_priority
1785: , task_group_id

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

1778: , container_item_id
1779: , cartonization_id
1780: , standard_operation_id
1781: , decode(p_operation_plan_id, fnd_api.g_miss_num, NULL, NULL, operation_plan_id, p_operation_plan_id) --lezhang
1782: , decode(p_wms_task_type, fnd_api.g_miss_num, NULL, NULL, wms_task_type, p_wms_task_type)
1783: , wms_task_status
1784: , task_priority
1785: , task_group_id
1786: , transaction_reference

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

1927: , request_id
1928: , program_application_id
1929: , program_id
1930: , program_update_date
1931: , decode(p_sec_txn_qty, fnd_api.g_miss_num, NULL, NULL, secondary_transaction_quantity, p_sec_txn_qty) --INVCONV KKILLAMS
1932: ,decode(l_secondary_uom, NULL, secondary_uom_code, l_secondary_uom) --Bug#7716563
1933: FROM mtl_material_transactions_temp
1934: WHERE transaction_temp_id = p_transaction_temp_id;
1935:

Line 1940: WHEN fnd_api.g_exc_error THEN

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;
1942: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1943: WHEN fnd_api.g_exc_unexpected_error THEN
1944: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1941: x_return_status := fnd_api.g_ret_sts_error;

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;
1942: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1943: WHEN fnd_api.g_exc_unexpected_error THEN
1944: x_return_status := fnd_api.g_ret_sts_unexp_error;
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1943: WHEN fnd_api.g_exc_unexpected_error THEN

1939: EXCEPTION
1940: WHEN fnd_api.g_exc_error THEN
1941: x_return_status := fnd_api.g_ret_sts_error;
1942: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1943: WHEN fnd_api.g_exc_unexpected_error THEN
1944: x_return_status := fnd_api.g_ret_sts_unexp_error;
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: WHEN OTHERS THEN
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1944: x_return_status := fnd_api.g_ret_sts_unexp_error;

1940: WHEN fnd_api.g_exc_error THEN
1941: x_return_status := fnd_api.g_ret_sts_error;
1942: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1943: WHEN fnd_api.g_exc_unexpected_error THEN
1944: x_return_status := fnd_api.g_ret_sts_unexp_error;
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: WHEN OTHERS THEN
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1947: x_return_status := fnd_api.g_ret_sts_unexp_error;

1943: WHEN fnd_api.g_exc_unexpected_error THEN
1944: x_return_status := fnd_api.g_ret_sts_unexp_error;
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: WHEN OTHERS THEN
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1949: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1950: END IF;
1951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2027: x_return_status := fnd_api.g_ret_sts_success;

2023: AND msi.organization_id = mmtt.organization_id;
2024:
2025: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2026: BEGIN
2027: x_return_status := fnd_api.g_ret_sts_success;
2028:
2029: IF l_debug = 1 THEN
2030: TRACE('Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2031: END IF;

Line 2058: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2054: , p_lot_control_code => l_lot_control_code
2055: , p_serial_control_code => l_serial_control_code
2056: );
2057:
2058: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2059: IF l_debug = 1 THEN
2060: TRACE('Error occurred while updating the Parent Record', 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2061: END IF;
2062:

Line 2063: RAISE fnd_api.g_exc_error;

2059: IF l_debug = 1 THEN
2060: TRACE('Error occurred while updating the Parent Record', 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2061: END IF;
2062:
2063: RAISE fnd_api.g_exc_error;
2064: END IF;
2065: END IF;
2066:
2067: -- Unmarking and Deleting all the Serials associated with the Transaction

Line 2146: x_return_status := fnd_api.g_ret_sts_error;

2142: TRACE('Records deleted in MMTT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2143: END IF;
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: x_return_status := fnd_api.g_ret_sts_error;
2147: TRACE('Exception Occurred = ' || SQLERRM, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2148: END delete_transaction;
2149:
2150: PROCEDURE delete_lot_ser_trx(

Line 2168: x_return_status := fnd_api.g_ret_sts_success;

2164: SELECT serial_transaction_temp_id
2165: FROM mtl_transaction_lots_temp
2166: WHERE transaction_temp_id = l_txn_tmp_id;
2167: BEGIN
2168: x_return_status := fnd_api.g_ret_sts_success;
2169: TRACE('parameters passed to delete_lot_ser_trx', 'INVTRXUB', 9);
2170: 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);
2171:
2172: 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 2174: RAISE fnd_api.g_exc_error;

2170: 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);
2171:
2172: 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
2173: TRACE('Parameter passed is null...', 'INVTRXUB', 9);
2174: RAISE fnd_api.g_exc_error;
2175: END IF;
2176:
2177: IF ((p_serctrl <> 1) AND(p_lotctrl <> 2)) THEN
2178: --Item is only serial controlled

Line 2235: x_return_status := fnd_api.g_ret_sts_success;

2231: END IF;
2232:
2233:
2234:
2235: x_return_status := fnd_api.g_ret_sts_success;
2236: EXCEPTION
2237: WHEN fnd_api.g_exc_error THEN
2238: TRACE('Expected error has occured...', 'INVTRXUB', 9);
2239: x_return_status := fnd_api.g_ret_sts_error;

Line 2237: WHEN fnd_api.g_exc_error THEN

2233:
2234:
2235: x_return_status := fnd_api.g_ret_sts_success;
2236: EXCEPTION
2237: WHEN fnd_api.g_exc_error THEN
2238: TRACE('Expected error has occured...', 'INVTRXUB', 9);
2239: x_return_status := fnd_api.g_ret_sts_error;
2240: WHEN OTHERS THEN
2241: TRACE('Unexpected error has occured...', 'INVTRXUB', 9);

Line 2239: x_return_status := fnd_api.g_ret_sts_error;

2235: x_return_status := fnd_api.g_ret_sts_success;
2236: EXCEPTION
2237: WHEN fnd_api.g_exc_error THEN
2238: TRACE('Expected error has occured...', 'INVTRXUB', 9);
2239: x_return_status := fnd_api.g_ret_sts_error;
2240: WHEN OTHERS THEN
2241: TRACE('Unexpected error has occured...', 'INVTRXUB', 9);
2242: TRACE('SQLERRM...' || SUBSTR(SQLERRM, 1, 100), 'INVTRXUB', 9);
2243: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2243: x_return_status := fnd_api.g_ret_sts_unexp_error;

2239: x_return_status := fnd_api.g_ret_sts_error;
2240: WHEN OTHERS THEN
2241: TRACE('Unexpected error has occured...', 'INVTRXUB', 9);
2242: TRACE('SQLERRM...' || SUBSTR(SQLERRM, 1, 100), 'INVTRXUB', 9);
2243: x_return_status := fnd_api.g_ret_sts_unexp_error;
2244: END delete_lot_ser_trx;
2245:
2246: /*
2247: * Procedure: UPDATE_PARENT_MMTT

Line 2298: x_return_status := fnd_api.g_ret_sts_success;

2294:
2295: -- End 1 of Fix of Bug 11931654
2296:
2297: BEGIN
2298: x_return_status := fnd_api.g_ret_sts_success;
2299:
2300: OPEN c_child_details;
2301: FETCH c_child_details INTO l_item_id, l_child_pri_qty, l_child_txn_qty, l_child_sec_txn_qty, l_child_uom, l_parent_uom; --BUG12753174
2302: IF c_child_details%NOTFOUND THEN

Line 2304: x_return_status := fnd_api.g_ret_sts_error;

2300: OPEN c_child_details;
2301: FETCH c_child_details INTO l_item_id, l_child_pri_qty, l_child_txn_qty, l_child_sec_txn_qty, l_child_uom, l_parent_uom; --BUG12753174
2302: IF c_child_details%NOTFOUND THEN
2303: TRACE('Either Parent TxnTempID or Child TxnTempID is invalid', 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2304: x_return_status := fnd_api.g_ret_sts_error;
2305: RETURN;
2306: END IF;
2307:
2308: -- Delete the Serials

Line 2412: l_api_return_status := fnd_api.g_ret_sts_success;

2408: TRACE('Checking if parent should be archived: Txn Temp ID = ' || p_parent_line_id
2409: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2410: END IF;
2411:
2412: l_api_return_status := fnd_api.g_ret_sts_success;
2413: inv_parent_mmtt_pvt.process_parent
2414: ( x_return_status => l_api_return_status
2415: , p_parent_temp_id => p_parent_line_id
2416: );

Line 2418: IF l_api_return_status <> fnd_api.g_ret_sts_success

2414: ( x_return_status => l_api_return_status
2415: , p_parent_temp_id => p_parent_line_id
2416: );
2417:
2418: IF l_api_return_status <> fnd_api.g_ret_sts_success
2419: THEN
2420: IF l_debug = 1 THEN
2421: TRACE('Error from inv_parent_mmtt_pvt.process_parent'
2422: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

Line 2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2420: IF l_debug = 1 THEN
2421: TRACE('Error from inv_parent_mmtt_pvt.process_parent'
2422: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: END IF;
2426: ELSE
2427: IF l_debug = 1 THEN
2428: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

Line 2437: x_return_status := fnd_api.g_ret_sts_unexp_error;

2433: END IF;
2434: END IF;
2435: EXCEPTION
2436: WHEN OTHERS THEN
2437: x_return_status := fnd_api.g_ret_sts_unexp_error;
2438:
2439: IF (l_debug = 1) THEN
2440: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2441: END IF;