DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on FND_API

Line 1354: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1468: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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;

Line 1473: x_return_status := fnd_api.g_ret_sts_unexp_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;
1476:
1477: /* Overridden method to retreiveDUOM attributes for Convergence */

Line 1474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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:

Line 1516: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1767: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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;

Line 1772: x_return_status := fnd_api.g_ret_sts_unexp_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;
1775:
1776: -- Bug 5498323 - Procedure accepts two more parameters - Subinventory code and Locator Id

Line 1773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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