DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on FND_API

Line 1471: x_return_status := fnd_api.g_ret_sts_success;

1467: , p_transaction_type_id IN VARCHAR2
1468: , p_inventory_item_id IN NUMBER
1469: ) IS
1470: BEGIN
1471: x_return_status := fnd_api.g_ret_sts_success;
1472: x_msg_data := '';
1473:
1474: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1475: THEN

Line 1585: x_return_status := fnd_api.g_ret_sts_error;

1581: END IF;
1582: END IF;
1583: EXCEPTION
1584: WHEN NO_DATA_FOUND THEN
1585: x_return_status := fnd_api.g_ret_sts_error;
1586: fnd_message.set_name('INV', 'INV_NO_ITEM');
1587: fnd_msg_pub.ADD;
1588: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1589: WHEN OTHERS THEN

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

1584: WHEN NO_DATA_FOUND THEN
1585: x_return_status := fnd_api.g_ret_sts_error;
1586: fnd_message.set_name('INV', 'INV_NO_ITEM');
1587: fnd_msg_pub.ADD;
1588: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1589: WHEN OTHERS THEN
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1592: END get_lot_item_details;

Line 1590: x_return_status := fnd_api.g_ret_sts_unexp_error;

1586: fnd_message.set_name('INV', 'INV_NO_ITEM');
1587: fnd_msg_pub.ADD;
1588: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1589: WHEN OTHERS THEN
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1592: END get_lot_item_details;
1593:
1594: /* Overridden method to retreiveDUOM attributes for Convergence */

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

1587: fnd_msg_pub.ADD;
1588: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1589: WHEN OTHERS THEN
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1592: END get_lot_item_details;
1593:
1594: /* Overridden method to retreiveDUOM attributes for Convergence */
1595:

Line 1633: x_return_status := fnd_api.g_ret_sts_success;

1629: , p_transaction_type_id IN VARCHAR2
1630: , p_inventory_item_id IN NUMBER
1631: ) IS
1632: BEGIN
1633: x_return_status := fnd_api.g_ret_sts_success;
1634: x_msg_data := '';
1635:
1636: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1637: THEN

Line 1884: x_return_status := fnd_api.g_ret_sts_error;

1880: END IF;
1881: END IF;
1882: EXCEPTION
1883: WHEN NO_DATA_FOUND THEN
1884: x_return_status := fnd_api.g_ret_sts_error;
1885: fnd_message.set_name('INV', 'INV_NO_ITEM');
1886: fnd_msg_pub.ADD;
1887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1888: WHEN OTHERS THEN

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

1883: WHEN NO_DATA_FOUND THEN
1884: x_return_status := fnd_api.g_ret_sts_error;
1885: fnd_message.set_name('INV', 'INV_NO_ITEM');
1886: fnd_msg_pub.ADD;
1887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1888: WHEN OTHERS THEN
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1891: END get_lot_item_details;

Line 1889: x_return_status := fnd_api.g_ret_sts_unexp_error;

1885: fnd_message.set_name('INV', 'INV_NO_ITEM');
1886: fnd_msg_pub.ADD;
1887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1888: WHEN OTHERS THEN
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1891: END get_lot_item_details;
1892:
1893: -- Bug 5498323 - Procedure accepts two more parameters - Subinventory code and Locator Id

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

1886: fnd_msg_pub.ADD;
1887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1888: WHEN OTHERS THEN
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1891: END get_lot_item_details;
1892:
1893: -- Bug 5498323 - Procedure accepts two more parameters - Subinventory code and Locator Id
1894: -- If Subinventory code IS not NULL, then the Item list returned is filtered by this Subinventory