1350: , p_transaction_type_id IN VARCHAR2
1351: , p_inventory_item_id IN NUMBER
1352: ) IS
1353: BEGIN
1354: x_return_status := fnd_api.g_ret_sts_success;
1355: x_msg_data := '';
1356:
1357: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1358: THEN
1464: END IF;
1465: END IF;
1466: EXCEPTION
1467: WHEN NO_DATA_FOUND THEN
1468: x_return_status := fnd_api.g_ret_sts_error;
1469: fnd_message.set_name('INV', 'INV_NO_ITEM');
1470: fnd_msg_pub.ADD;
1471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN OTHERS THEN
1467: WHEN NO_DATA_FOUND THEN
1468: x_return_status := fnd_api.g_ret_sts_error;
1469: fnd_message.set_name('INV', 'INV_NO_ITEM');
1470: fnd_msg_pub.ADD;
1471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN OTHERS THEN
1473: x_return_status := fnd_api.g_ret_sts_unexp_error;
1474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1475: END get_lot_item_details;
1469: fnd_message.set_name('INV', 'INV_NO_ITEM');
1470: fnd_msg_pub.ADD;
1471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN OTHERS THEN
1473: x_return_status := fnd_api.g_ret_sts_unexp_error;
1474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1475: END get_lot_item_details;
1476:
1477: /* Overridden method to retreiveDUOM attributes for Convergence */
1470: fnd_msg_pub.ADD;
1471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN OTHERS THEN
1473: x_return_status := fnd_api.g_ret_sts_unexp_error;
1474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1475: END get_lot_item_details;
1476:
1477: /* Overridden method to retreiveDUOM attributes for Convergence */
1478:
1512: , p_transaction_type_id IN VARCHAR2
1513: , p_inventory_item_id IN NUMBER
1514: ) IS
1515: BEGIN
1516: x_return_status := fnd_api.g_ret_sts_success;
1517: x_msg_data := '';
1518:
1519: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1520: THEN
1763: END IF;
1764: END IF;
1765: EXCEPTION
1766: WHEN NO_DATA_FOUND THEN
1767: x_return_status := fnd_api.g_ret_sts_error;
1768: fnd_message.set_name('INV', 'INV_NO_ITEM');
1769: fnd_msg_pub.ADD;
1770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1771: WHEN OTHERS THEN
1766: WHEN NO_DATA_FOUND THEN
1767: x_return_status := fnd_api.g_ret_sts_error;
1768: fnd_message.set_name('INV', 'INV_NO_ITEM');
1769: fnd_msg_pub.ADD;
1770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1771: WHEN OTHERS THEN
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1774: END get_lot_item_details;
1768: fnd_message.set_name('INV', 'INV_NO_ITEM');
1769: fnd_msg_pub.ADD;
1770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1771: WHEN OTHERS THEN
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1774: END get_lot_item_details;
1775:
1776: -- Bug 5498323 - Procedure accepts two more parameters - Subinventory code and Locator Id
1769: fnd_msg_pub.ADD;
1770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1771: WHEN OTHERS THEN
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1774: END get_lot_item_details;
1775:
1776: -- Bug 5498323 - Procedure accepts two more parameters - Subinventory code and Locator Id
1777: -- If Subinventory code IS not NULL, then the Item list returned is filtered by this Subinventory