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_TRANSFER_ORDER_PVT dependencies on FND_MSG_PUB

Line 252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

248: RAISE;
249: WHEN fnd_api.g_exc_unexpected_error THEN
250: RAISE;
251: WHEN OTHERS THEN
252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
253: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
254: END IF;
255:
256: RAISE fnd_api.g_exc_unexpected_error;

Line 253: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');

249: WHEN fnd_api.g_exc_unexpected_error THEN
250: RAISE;
251: WHEN OTHERS THEN
252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
253: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
254: END IF;
255:
256: RAISE fnd_api.g_exc_unexpected_error;
257: END delete_troldt;

Line 379: fnd_msg_pub.ADD;

375: END IF;
376: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
377: fnd_message.set_token('VALUE1', l_secondary_uom_code);
378: fnd_message.set_token('VALUE2', p_trx_uom);
379: fnd_msg_pub.ADD;
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
382:
383: l_mtlt_sec_trx_qty := l_mtlt_sec_trx_qty - l_sec_quantity_cancel;

Line 413: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

409: END IF;
410: EXCEPTION
411: WHEN fnd_api.g_exc_error THEN
412: x_return_status := fnd_api.g_ret_sts_error;
413: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
414: WHEN fnd_api.g_exc_unexpected_error THEN
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
417: WHEN OTHERS THEN

Line 416: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

412: x_return_status := fnd_api.g_ret_sts_error;
413: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
414: WHEN fnd_api.g_exc_unexpected_error THEN
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419:
420: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 420: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

416: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419:
420: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
421: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update lots temp');
422: END IF;
423:
424: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 421: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update lots temp');

417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419:
420: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
421: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update lots temp');
422: END IF;
423:
424: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
425: END update_lots_temp;

Line 424: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

420: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
421: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update lots temp');
422: END IF;
423:
424: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
425: END update_lots_temp;
426:
427: -- bug 2195303
428:

Line 517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

513: END IF;
514: EXCEPTION
515: WHEN fnd_api.g_exc_error THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
518: WHEN fnd_api.g_exc_unexpected_error THEN
519: x_return_status := fnd_api.g_ret_sts_unexp_error;
520: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
521: WHEN OTHERS THEN

Line 520: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

516: x_return_status := fnd_api.g_ret_sts_error;
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
518: WHEN fnd_api.g_exc_unexpected_error THEN
519: x_return_status := fnd_api.g_ret_sts_unexp_error;
520: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523:
524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

520: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523:
524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
525: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update serial temp');
526: END IF;
527:
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 525: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update serial temp');

521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523:
524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
525: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update serial temp');
526: END IF;
527:
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: END update_serial_temp;

Line 528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
525: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update serial temp');
526: END IF;
527:
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: END update_serial_temp;
530:
531: PROCEDURE update_troldt(
532: x_return_status OUT NOCOPY VARCHAR2

Line 620: fnd_msg_pub.ADD;

616: END IF;
617: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
618: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
619: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
620: fnd_msg_pub.ADD;
621: RAISE fnd_api.g_exc_unexpected_error;
622: END IF;
623: IF l_trolin_rec.secondary_quantity_detailed IS NOT NULL THEN
624: l_trolin_rec.secondary_quantity_detailed := l_trolin_rec.secondary_quantity_detailed - l_sec_quantity_cancel;

Line 821: fnd_msg_pub.ADD;

817: END IF;
818: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
819: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);
820: fnd_message.set_token('VALUE2', l_transaction_uom);
821: fnd_msg_pub.ADD;
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;
824: IF l_secondary_uom_qty < 0 THEN
825: l_secondary_uom_qty := 0;

Line 939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

935: RAISE;
936: WHEN fnd_api.g_exc_unexpected_error THEN
937: RAISE;
938: WHEN OTHERS THEN
939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
940: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
941: END IF;
942:
943: RAISE fnd_api.g_exc_unexpected_error;

Line 940: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');

936: WHEN fnd_api.g_exc_unexpected_error THEN
937: RAISE;
938: WHEN OTHERS THEN
939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
940: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
941: END IF;
942:
943: RAISE fnd_api.g_exc_unexpected_error;
944: END update_troldt;

Line 1091: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1087: x_trohdr_rec := l_trohdr_rec;
1088: x_old_trohdr_rec := l_old_trohdr_rec;
1089: RAISE;
1090: WHEN OTHERS THEN
1091: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1092: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trohdr');
1093: END IF;
1094:
1095: l_trohdr_rec.return_status := fnd_api.g_ret_sts_unexp_error;

Line 1092: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trohdr');

1088: x_old_trohdr_rec := l_old_trohdr_rec;
1089: RAISE;
1090: WHEN OTHERS THEN
1091: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1092: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trohdr');
1093: END IF;
1094:
1095: l_trohdr_rec.return_status := fnd_api.g_ret_sts_unexp_error;
1096: x_trohdr_rec := l_trohdr_rec;

Line 1393: fnd_msg_pub.ADD;

1389: END IF;
1390: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1391: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1392: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1393: fnd_msg_pub.ADD;
1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1396: END IF;
1397: -- END

Line 1566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1562: l_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
1563: l_trolin_tbl(i) := l_trolin_rec;
1564: l_old_trolin_tbl(i) := l_old_trolin_rec;
1565:
1566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1567: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1568: END IF;
1569:
1570: RAISE fnd_api.g_exc_unexpected_error;

Line 1567: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');

1563: l_trolin_tbl(i) := l_trolin_rec;
1564: l_old_trolin_tbl(i) := l_old_trolin_rec;
1565:
1566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1567: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1568: END IF;
1569:
1570: RAISE fnd_api.g_exc_unexpected_error;
1571: END;

Line 1584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1580: RAISE;
1581: WHEN fnd_api.g_exc_unexpected_error THEN
1582: RAISE;
1583: WHEN OTHERS THEN
1584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1585: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1586: END IF;
1587:
1588: RAISE fnd_api.g_exc_unexpected_error;

Line 1585: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');

1581: WHEN fnd_api.g_exc_unexpected_error THEN
1582: RAISE;
1583: WHEN OTHERS THEN
1584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1585: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1586: END IF;
1587:
1588: RAISE fnd_api.g_exc_unexpected_error;
1589: END trolins;

Line 1666: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1663: RAISE;
1664:
1665: WHEN OTHERS THEN
1666: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1667: THEN
1668: FND_MSG_PUB.Add_Exc_Msg
1669: ( G_PKG_NAME
1670: , 'Trolins'

Line 1668: FND_MSG_PUB.Add_Exc_Msg

1664:
1665: WHEN OTHERS THEN
1666: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1667: THEN
1668: FND_MSG_PUB.Add_Exc_Msg
1669: ( G_PKG_NAME
1670: , 'Trolins'
1671: );
1672: END IF;

Line 1731: fnd_msg_pub.initialize;

1727:
1728: -- Initialize message list.
1729:
1730: IF fnd_api.to_boolean(p_init_msg_list) THEN
1731: fnd_msg_pub.initialize;
1732: END IF;
1733:
1734: -- Use cache to get value for l_debug
1735: IF g_is_pickrelease_set IS NULL THEN

Line 1841: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1837: END IF;
1838: --End Bug #4777248
1839:
1840: -- Get message count and data
1841: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1842: EXCEPTION
1843: WHEN fnd_api.g_exc_error THEN
1844: x_return_status := fnd_api.g_ret_sts_error;
1845: -- Get message count and data

Line 1846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1842: EXCEPTION
1843: WHEN fnd_api.g_exc_error THEN
1844: x_return_status := fnd_api.g_ret_sts_error;
1845: -- Get message count and data
1846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1847: WHEN fnd_api.g_exc_unexpected_error THEN
1848: x_return_status := fnd_api.g_ret_sts_unexp_error;
1849: -- Get message count and data
1850: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1850: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1847: WHEN fnd_api.g_exc_unexpected_error THEN
1848: x_return_status := fnd_api.g_ret_sts_unexp_error;
1849: -- Get message count and data
1850: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1851: WHEN OTHERS THEN
1852: x_return_status := fnd_api.g_ret_sts_unexp_error;
1853:
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1850: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1851: WHEN OTHERS THEN
1852: x_return_status := fnd_api.g_ret_sts_unexp_error;
1853:
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1855: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Process_Transfer_Order');
1856: END IF;
1857:
1858: -- Get message count and data

Line 1855: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Process_Transfer_Order');

1851: WHEN OTHERS THEN
1852: x_return_status := fnd_api.g_ret_sts_unexp_error;
1853:
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1855: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Process_Transfer_Order');
1856: END IF;
1857:
1858: -- Get message count and data
1859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1855: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Process_Transfer_Order');
1856: END IF;
1857:
1858: -- Get message count and data
1859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1860: END process_transfer_order;
1861:
1862: -- Start of Comments
1863: -- API name Lock_Transfer_Order

Line 1901: fnd_msg_pub.initialize;

1897: END IF;
1898:
1899: -- Initialize message list.
1900: IF fnd_api.to_boolean(p_init_msg_list) THEN
1901: fnd_msg_pub.initialize;
1902: END IF;
1903:
1904: -- Set Savepoint
1905: SAVEPOINT lock_transfer_order_pvt;

Line 1936: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1932:
1933: -- Set return status
1934: x_return_status := fnd_api.g_ret_sts_success;
1935: -- Get message count and data
1936: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1937: EXCEPTION
1938: WHEN fnd_api.g_exc_error THEN
1939: x_return_status := fnd_api.g_ret_sts_error;
1940: -- Get message count and data

Line 1941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1937: EXCEPTION
1938: WHEN fnd_api.g_exc_error THEN
1939: x_return_status := fnd_api.g_ret_sts_error;
1940: -- Get message count and data
1941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1942: -- Rollback
1943: ROLLBACK TO lock_transfer_order_pvt;
1944: WHEN fnd_api.g_exc_unexpected_error THEN
1945: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1943: ROLLBACK TO lock_transfer_order_pvt;
1944: WHEN fnd_api.g_exc_unexpected_error THEN
1945: x_return_status := fnd_api.g_ret_sts_unexp_error;
1946: -- Get message count and data
1947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1948: -- Rollback
1949: ROLLBACK TO lock_transfer_order_pvt;
1950: WHEN OTHERS THEN
1951: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1953: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1949: ROLLBACK TO lock_transfer_order_pvt;
1950: WHEN OTHERS THEN
1951: x_return_status := fnd_api.g_ret_sts_unexp_error;
1952:
1953: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1954: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Transfer_Order');
1955: END IF;
1956:
1957: -- Get message count and data

Line 1954: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Transfer_Order');

1950: WHEN OTHERS THEN
1951: x_return_status := fnd_api.g_ret_sts_unexp_error;
1952:
1953: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1954: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Transfer_Order');
1955: END IF;
1956:
1957: -- Get message count and data
1958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1954: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Transfer_Order');
1955: END IF;
1956:
1957: -- Get message count and data
1958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1959: -- Rollback
1960: ROLLBACK TO lock_transfer_order_pvt;
1961: END lock_transfer_order;
1962:

Line 2001: fnd_msg_pub.initialize;

1997: END IF;
1998:
1999: -- Initialize message list.
2000: IF fnd_api.to_boolean(p_init_msg_list) THEN
2001: fnd_msg_pub.initialize;
2002: END IF;
2003:
2004: -- Get trohdr ( parent = trohdr )
2005: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id => p_header_id);

Line 2015: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2011: x_trolin_tbl := l_trolin_tbl;
2012: -- Set return status
2013: x_return_status := fnd_api.g_ret_sts_success;
2014: -- Get message count and data
2015: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2016: EXCEPTION
2017: WHEN fnd_api.g_exc_error THEN
2018: x_return_status := fnd_api.g_ret_sts_error;
2019: -- Get message count and data

Line 2020: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2016: EXCEPTION
2017: WHEN fnd_api.g_exc_error THEN
2018: x_return_status := fnd_api.g_ret_sts_error;
2019: -- Get message count and data
2020: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2021: WHEN fnd_api.g_exc_unexpected_error THEN
2022: x_return_status := fnd_api.g_ret_sts_unexp_error;
2023: -- Get message count and data
2024: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2024: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2020: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2021: WHEN fnd_api.g_exc_unexpected_error THEN
2022: x_return_status := fnd_api.g_ret_sts_unexp_error;
2023: -- Get message count and data
2024: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2025: WHEN OTHERS THEN
2026: x_return_status := fnd_api.g_ret_sts_unexp_error;
2027:
2028: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2028: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2024: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2025: WHEN OTHERS THEN
2026: x_return_status := fnd_api.g_ret_sts_unexp_error;
2027:
2028: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2029: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Transfer_Order');
2030: END IF;
2031:
2032: -- Get message count and data

Line 2029: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Transfer_Order');

2025: WHEN OTHERS THEN
2026: x_return_status := fnd_api.g_ret_sts_unexp_error;
2027:
2028: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2029: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Transfer_Order');
2030: END IF;
2031:
2032: -- Get message count and data
2033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2029: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Transfer_Order');
2030: END IF;
2031:
2032: -- Get message count and data
2033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2034: END get_transfer_order;
2035:
2036: FUNCTION validate_from_subinventory(p_from_subinventory_code IN VARCHAR2, p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER, p_transaction_type_id IN NUMBER, p_restrict_subinventories_code IN NUMBER)
2037: RETURN BOOLEAN IS

Line 2108: --l_error_msg := FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE);

2104: -- g_from_sub.asset_inventory := p_from_sub_asset;
2105: l_return := inv_validate.to_subinventory(l_sub, l_org, l_item, g_from_sub, l_acct_txn);
2106:
2107: IF (l_return = inv_validate.f) THEN
2108: --l_error_msg := FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE);
2109: l_result := FALSE;
2110: ELSE
2111: l_result := TRUE;
2112: END IF;

Line 2439: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2435: EXCEPTION
2436: WHEN fnd_api.g_exc_error THEN
2437: x_return_status := fnd_api.g_ret_sts_error;
2438: -- Get message count and data
2439: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2440: WHEN fnd_api.g_exc_unexpected_error THEN
2441: x_return_status := fnd_api.g_ret_sts_unexp_error;
2442: -- Get message count and data
2443: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2443: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2439: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2440: WHEN fnd_api.g_exc_unexpected_error THEN
2441: x_return_status := fnd_api.g_ret_sts_unexp_error;
2442: -- Get message count and data
2443: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2444: WHEN OTHERS THEN
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:
2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2443: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2444: WHEN OTHERS THEN
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:
2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2448: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Clean Reservations');
2449: END IF;
2450:
2451: -- Get message count and data

Line 2448: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Clean Reservations');

2444: WHEN OTHERS THEN
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:
2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2448: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Clean Reservations');
2449: END IF;
2450:
2451: -- Get message count and data
2452: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2452: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2448: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Clean Reservations');
2449: END IF;
2450:
2451: -- Get message count and data
2452: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2453: END clean_reservations;
2454:
2455: --
2456: -- Finalize pick confirm processes the move orders that are being

Line 2928: fnd_msg_pub.ADD;

2924: END IF;
2925: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2926: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2927: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2928: fnd_msg_pub.ADD;
2929: RAISE fnd_api.g_exc_unexpected_error;
2930: END IF;
2931: END IF;
2932: ELSE

Line 2986: fnd_msg_pub.ADD;

2982: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2983: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2984: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2985: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2986: fnd_msg_pub.ADD;
2987: RAISE fnd_api.g_exc_unexpected_error;
2988: END IF;
2989: ELSIF(l_fulfillment_base = 'S' ) THEN
2990: IF (l_curr_mmtt_txn_uom = NVL(l_mmtt_rec.secondary_uom_code,'@@@@')) THEN

Line 3012: fnd_msg_pub.ADD;

3008: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3009: fnd_message.set_token('UOM1', l_curr_mmtt_sec_uom);
3010: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3011: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3012: fnd_msg_pub.ADD;
3013: RAISE fnd_api.g_exc_unexpected_error;
3014: END IF;
3015: END IF;
3016: END IF;

Line 3081: fnd_msg_pub.ADD;

3077: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3078: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom );
3079: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3080: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3081: fnd_msg_pub.ADD;
3082: RAISE fnd_api.g_exc_unexpected_error;
3083: END IF;
3084: g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom := l_mmtt_rec.transaction_uom ;
3085: END If;

Line 3178: fnd_msg_pub.ADD;

3174: END IF;
3175: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3176: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
3177: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3178: fnd_msg_pub.ADD;
3179: RAISE fnd_api.g_exc_unexpected_error;
3180: END IF;
3181: ELSE
3182: l_primary_pending_quantity := l_pending_quantity;

Line 3285: fnd_msg_pub.ADD;

3281: END IF;
3282: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3283: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3284: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3285: fnd_msg_pub.ADD;
3286: RAISE fnd_api.g_exc_unexpected_error;
3287: END IF;
3288: END IF; -- if UOM code not primary UOM
3289:

Line 3322: fnd_msg_pub.ADD;

3318: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3319: DEBUG('Unable to lock the work order line for update', 'Finalize_Pick_Confirm');
3320: END IF;
3321: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
3322: fnd_msg_pub.ADD;
3323: RAISE fnd_api.g_exc_error;
3324: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
3325: IF (l_debug = 1) THEN
3326: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');

Line 4598: fnd_msg_pub.ADD;

4594: FOR UPDATE NOWAIT;
4595: EXCEPTION
4596: WHEN NO_DATA_FOUND THEN
4597: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
4598: fnd_msg_pub.ADD;
4599: RAISE fnd_api.g_exc_error;
4600: WHEN OTHERS THEN
4601: --could not lock row
4602: IF SQLCODE = -54 THEN

Line 4605: fnd_msg_pub.ADD;

4601: --could not lock row
4602: IF SQLCODE = -54 THEN
4603: fnd_message.set_name('INV', 'INV_DELIV_INFO_LOCKED');
4604: fnd_message.set_token('LINEID', l_trolin_rec.line_id);
4605: fnd_msg_pub.ADD;
4606: RAISE fnd_api.g_exc_error;
4607: ELSE
4608: RAISE fnd_api.g_exc_unexpected_error;
4609: END IF;

Line 4793: fnd_msg_pub.ADD;

4789: , p_organization_id => l_mmtt_rec.organization_id
4790: , p_inventory_item_id => l_mmtt_rec.inventory_item_id );
4791: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
4792: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
4793: fnd_msg_pub.ADD;
4794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4795: END IF;
4796:
4797: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)

Line 4800: fnd_msg_pub.ADD;

4796:
4797: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)
4798: AND nvl(l_mmtt_rec.secondary_transaction_quantity,0) = 0) THEN -- added secondary_transaction_quantity for bug 12616674
4799: fnd_message.set_name('INV', 'WMS_CATCH_WEIGHT_NO_LPN_ERR');
4800: fnd_msg_pub.ADD;
4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4802: END IF;
4803:
4804: END IF;

Line 6600: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

6596: -- end of code added for bug#8530301
6597: WHEN fnd_api.g_exc_error THEN
6598: x_return_status := fnd_api.g_ret_sts_error;
6599: -- Get message count and data
6600: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6601: WHEN fnd_api.g_exc_unexpected_error THEN
6602: x_return_status := fnd_api.g_ret_sts_unexp_error;
6603: -- Get message count and data
6604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 6604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

6600: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6601: WHEN fnd_api.g_exc_unexpected_error THEN
6602: x_return_status := fnd_api.g_ret_sts_unexp_error;
6603: -- Get message count and data
6604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6605: WHEN OTHERS THEN
6606: x_return_status := fnd_api.g_ret_sts_unexp_error;
6607:
6608: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 6608: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6605: WHEN OTHERS THEN
6606: x_return_status := fnd_api.g_ret_sts_unexp_error;
6607:
6608: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6609: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Pick Confirm');
6610: END IF;
6611:
6612: -- Get message count and data

Line 6609: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Pick Confirm');

6605: WHEN OTHERS THEN
6606: x_return_status := fnd_api.g_ret_sts_unexp_error;
6607:
6608: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6609: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Pick Confirm');
6610: END IF;
6611:
6612: -- Get message count and data
6613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 6613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

6609: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Pick Confirm');
6610: END IF;
6611:
6612: -- Get message count and data
6613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6614: END finalize_pick_confirm;
6615:
6616: -- Bug 2640757: Fill Kill Enhancement
6617: PROCEDURE kill_move_order(

Line 6777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

6773: IF (l_debug = 1) THEN
6774: DEBUG('Expected error while closing the Line','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6775: END IF;
6776: x_return_status := FND_API.G_RET_STS_ERROR;
6777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6779: IF (l_debug = 1) THEN
6780: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6781: END IF;

Line 6783: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

6779: IF (l_debug = 1) THEN
6780: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6781: END IF;
6782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6783: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6784: WHEN OTHERS THEN
6785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6786:
6787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 6787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6783: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6784: WHEN OTHERS THEN
6785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6786:
6787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6788: fnd_msg_pub.add_exc_msg(g_pkg_name, 'KILL_MOVE_ORDER');
6789: END IF;
6790: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6791: END kill_move_order;

Line 6788: fnd_msg_pub.add_exc_msg(g_pkg_name, 'KILL_MOVE_ORDER');

6784: WHEN OTHERS THEN
6785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6786:
6787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6788: fnd_msg_pub.add_exc_msg(g_pkg_name, 'KILL_MOVE_ORDER');
6789: END IF;
6790: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6791: END kill_move_order;
6792:

Line 6790: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

6786:
6787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6788: fnd_msg_pub.add_exc_msg(g_pkg_name, 'KILL_MOVE_ORDER');
6789: END IF;
6790: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6791: END kill_move_order;
6792:
6793:
6794: --As part of fix for bug 2867490, we need to create the following procedure

Line 7049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7045: IF (l_debug = 1) THEN
7046: DEBUG('Expected error while closing the Line','INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
7047: END IF;
7048: x_return_status := FND_API.G_RET_STS_ERROR;
7049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7051: IF (l_debug = 1) THEN
7052: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
7053: END IF;

Line 7055: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7051: IF (l_debug = 1) THEN
7052: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
7053: END IF;
7054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7055: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7056: WHEN OTHERS THEN
7057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7058:
7059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 7059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

7055: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7056: WHEN OTHERS THEN
7057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7058:
7059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7060: fnd_msg_pub.add_exc_msg(g_pkg_name, 'adjust_serial_numbers_in_MMTT');
7061: END IF;
7062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7063: END adjust_serial_numbers_in_MSNT;

Line 7060: fnd_msg_pub.add_exc_msg(g_pkg_name, 'adjust_serial_numbers_in_MMTT');

7056: WHEN OTHERS THEN
7057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7058:
7059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7060: fnd_msg_pub.add_exc_msg(g_pkg_name, 'adjust_serial_numbers_in_MMTT');
7061: END IF;
7062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7063: END adjust_serial_numbers_in_MSNT;
7064:

Line 7062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7058:
7059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7060: fnd_msg_pub.add_exc_msg(g_pkg_name, 'adjust_serial_numbers_in_MMTT');
7061: END IF;
7062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7063: END adjust_serial_numbers_in_MSNT;
7064:
7065: END inv_transfer_order_pvt;