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 248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

244: RAISE;
245: WHEN fnd_api.g_exc_unexpected_error THEN
246: RAISE;
247: WHEN OTHERS THEN
248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
249: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
250: END IF;
251:
252: RAISE fnd_api.g_exc_unexpected_error;

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

245: WHEN fnd_api.g_exc_unexpected_error THEN
246: RAISE;
247: WHEN OTHERS THEN
248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
249: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
250: END IF;
251:
252: RAISE fnd_api.g_exc_unexpected_error;
253: END delete_troldt;

Line 376: fnd_msg_pub.ADD;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 617: fnd_msg_pub.ADD;

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

Line 818: fnd_msg_pub.ADD;

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

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

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

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

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

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

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

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

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

Line 1380: fnd_msg_pub.ADD;

1376: END IF;
1377: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1378: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1379: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1380: fnd_msg_pub.ADD;
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;
1383: END IF;
1384: -- END

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

1549: l_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
1550: l_trolin_tbl(i) := l_trolin_rec;
1551: l_old_trolin_tbl(i) := l_old_trolin_rec;
1552:
1553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1554: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1555: END IF;
1556:
1557: RAISE fnd_api.g_exc_unexpected_error;

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

1550: l_trolin_tbl(i) := l_trolin_rec;
1551: l_old_trolin_tbl(i) := l_old_trolin_rec;
1552:
1553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1554: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1555: END IF;
1556:
1557: RAISE fnd_api.g_exc_unexpected_error;
1558: END;

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

1567: RAISE;
1568: WHEN fnd_api.g_exc_unexpected_error THEN
1569: RAISE;
1570: WHEN OTHERS THEN
1571: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1572: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1573: END IF;
1574:
1575: RAISE fnd_api.g_exc_unexpected_error;

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

1568: WHEN fnd_api.g_exc_unexpected_error THEN
1569: RAISE;
1570: WHEN OTHERS THEN
1571: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1572: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Trolins');
1573: END IF;
1574:
1575: RAISE fnd_api.g_exc_unexpected_error;
1576: END trolins;

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

1649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1650: RAISE;
1651:
1652: WHEN OTHERS THEN
1653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1654: THEN
1655: FND_MSG_PUB.Add_Exc_Msg
1656: ( G_PKG_NAME
1657: , 'Trolins'

Line 1655: FND_MSG_PUB.Add_Exc_Msg

1651:
1652: WHEN OTHERS THEN
1653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1654: THEN
1655: FND_MSG_PUB.Add_Exc_Msg
1656: ( G_PKG_NAME
1657: , 'Trolins'
1658: );
1659: END IF;

Line 1718: fnd_msg_pub.initialize;

1714:
1715: -- Initialize message list.
1716:
1717: IF fnd_api.to_boolean(p_init_msg_list) THEN
1718: fnd_msg_pub.initialize;
1719: END IF;
1720:
1721: -- Use cache to get value for l_debug
1722: IF g_is_pickrelease_set IS NULL THEN

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

1824: END IF;
1825: --End Bug #4777248
1826:
1827: -- Get message count and data
1828: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1829: EXCEPTION
1830: WHEN fnd_api.g_exc_error THEN
1831: x_return_status := fnd_api.g_ret_sts_error;
1832: -- Get message count and data

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

1829: EXCEPTION
1830: WHEN fnd_api.g_exc_error THEN
1831: x_return_status := fnd_api.g_ret_sts_error;
1832: -- Get message count and data
1833: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1834: WHEN fnd_api.g_exc_unexpected_error THEN
1835: x_return_status := fnd_api.g_ret_sts_unexp_error;
1836: -- Get message count and data
1837: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1833: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1834: WHEN fnd_api.g_exc_unexpected_error THEN
1835: x_return_status := fnd_api.g_ret_sts_unexp_error;
1836: -- Get message count and data
1837: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1838: WHEN OTHERS THEN
1839: x_return_status := fnd_api.g_ret_sts_unexp_error;
1840:
1841: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

1837: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1838: WHEN OTHERS THEN
1839: x_return_status := fnd_api.g_ret_sts_unexp_error;
1840:
1841: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1842: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Process_Transfer_Order');
1843: END IF;
1844:
1845: -- Get message count and data

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

1838: WHEN OTHERS THEN
1839: x_return_status := fnd_api.g_ret_sts_unexp_error;
1840:
1841: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1842: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Process_Transfer_Order');
1843: END IF;
1844:
1845: -- Get message count and data
1846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1842: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Process_Transfer_Order');
1843: END IF;
1844:
1845: -- Get message count and data
1846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1847: END process_transfer_order;
1848:
1849: -- Start of Comments
1850: -- API name Lock_Transfer_Order

Line 1888: fnd_msg_pub.initialize;

1884: END IF;
1885:
1886: -- Initialize message list.
1887: IF fnd_api.to_boolean(p_init_msg_list) THEN
1888: fnd_msg_pub.initialize;
1889: END IF;
1890:
1891: -- Set Savepoint
1892: SAVEPOINT lock_transfer_order_pvt;

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

1919:
1920: -- Set return status
1921: x_return_status := fnd_api.g_ret_sts_success;
1922: -- Get message count and data
1923: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1924: EXCEPTION
1925: WHEN fnd_api.g_exc_error THEN
1926: x_return_status := fnd_api.g_ret_sts_error;
1927: -- Get message count and data

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

1924: EXCEPTION
1925: WHEN fnd_api.g_exc_error THEN
1926: x_return_status := fnd_api.g_ret_sts_error;
1927: -- Get message count and data
1928: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1929: -- Rollback
1930: ROLLBACK TO lock_transfer_order_pvt;
1931: WHEN fnd_api.g_exc_unexpected_error THEN
1932: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1930: ROLLBACK TO lock_transfer_order_pvt;
1931: WHEN fnd_api.g_exc_unexpected_error THEN
1932: x_return_status := fnd_api.g_ret_sts_unexp_error;
1933: -- Get message count and data
1934: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1935: -- Rollback
1936: ROLLBACK TO lock_transfer_order_pvt;
1937: WHEN OTHERS THEN
1938: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1936: ROLLBACK TO lock_transfer_order_pvt;
1937: WHEN OTHERS THEN
1938: x_return_status := fnd_api.g_ret_sts_unexp_error;
1939:
1940: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1941: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Transfer_Order');
1942: END IF;
1943:
1944: -- Get message count and data

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

1937: WHEN OTHERS THEN
1938: x_return_status := fnd_api.g_ret_sts_unexp_error;
1939:
1940: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1941: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Transfer_Order');
1942: END IF;
1943:
1944: -- Get message count and data
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1941: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Transfer_Order');
1942: END IF;
1943:
1944: -- Get message count and data
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: -- Rollback
1947: ROLLBACK TO lock_transfer_order_pvt;
1948: END lock_transfer_order;
1949:

Line 1988: fnd_msg_pub.initialize;

1984: END IF;
1985:
1986: -- Initialize message list.
1987: IF fnd_api.to_boolean(p_init_msg_list) THEN
1988: fnd_msg_pub.initialize;
1989: END IF;
1990:
1991: -- Get trohdr ( parent = trohdr )
1992: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id => p_header_id);

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

1998: x_trolin_tbl := l_trolin_tbl;
1999: -- Set return status
2000: x_return_status := fnd_api.g_ret_sts_success;
2001: -- Get message count and data
2002: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2003: EXCEPTION
2004: WHEN fnd_api.g_exc_error THEN
2005: x_return_status := fnd_api.g_ret_sts_error;
2006: -- Get message count and data

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

2003: EXCEPTION
2004: WHEN fnd_api.g_exc_error THEN
2005: x_return_status := fnd_api.g_ret_sts_error;
2006: -- Get message count and data
2007: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2008: WHEN fnd_api.g_exc_unexpected_error THEN
2009: x_return_status := fnd_api.g_ret_sts_unexp_error;
2010: -- Get message count and data
2011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2007: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2008: WHEN fnd_api.g_exc_unexpected_error THEN
2009: x_return_status := fnd_api.g_ret_sts_unexp_error;
2010: -- Get message count and data
2011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2012: WHEN OTHERS THEN
2013: x_return_status := fnd_api.g_ret_sts_unexp_error;
2014:
2015: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2012: WHEN OTHERS THEN
2013: x_return_status := fnd_api.g_ret_sts_unexp_error;
2014:
2015: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2016: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Transfer_Order');
2017: END IF;
2018:
2019: -- Get message count and data

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

2012: WHEN OTHERS THEN
2013: x_return_status := fnd_api.g_ret_sts_unexp_error;
2014:
2015: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2016: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Transfer_Order');
2017: END IF;
2018:
2019: -- Get message count and data
2020: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2016: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Transfer_Order');
2017: END IF;
2018:
2019: -- Get message count and data
2020: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2021: END get_transfer_order;
2022:
2023: 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)
2024: RETURN BOOLEAN IS

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

2091: -- g_from_sub.asset_inventory := p_from_sub_asset;
2092: l_return := inv_validate.to_subinventory(l_sub, l_org, l_item, g_from_sub, l_acct_txn);
2093:
2094: IF (l_return = inv_validate.f) THEN
2095: --l_error_msg := FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE);
2096: l_result := FALSE;
2097: ELSE
2098: l_result := TRUE;
2099: END IF;

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

2422: EXCEPTION
2423: WHEN fnd_api.g_exc_error THEN
2424: x_return_status := fnd_api.g_ret_sts_error;
2425: -- Get message count and data
2426: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2427: WHEN fnd_api.g_exc_unexpected_error THEN
2428: x_return_status := fnd_api.g_ret_sts_unexp_error;
2429: -- Get message count and data
2430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2426: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2427: WHEN fnd_api.g_exc_unexpected_error THEN
2428: x_return_status := fnd_api.g_ret_sts_unexp_error;
2429: -- Get message count and data
2430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2431: WHEN OTHERS THEN
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433:
2434: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2431: WHEN OTHERS THEN
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433:
2434: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2435: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Clean Reservations');
2436: END IF;
2437:
2438: -- Get message count and data

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

2431: WHEN OTHERS THEN
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433:
2434: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2435: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Clean Reservations');
2436: END IF;
2437:
2438: -- Get message count and data
2439: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2435: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Clean Reservations');
2436: END IF;
2437:
2438: -- Get message count and data
2439: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2440: END clean_reservations;
2441:
2442: --
2443: -- Finalize pick confirm processes the move orders that are being

Line 2809: fnd_msg_pub.ADD;

2805: END IF;
2806: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2807: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2808: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2809: fnd_msg_pub.ADD;
2810: RAISE fnd_api.g_exc_unexpected_error;
2811: END IF;
2812: ELSE
2813: l_primary_shipping_quantity := l_shipping_quantity;

Line 2862: fnd_msg_pub.ADD;

2858: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2859: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2860: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2861: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2862: fnd_msg_pub.ADD;
2863: RAISE fnd_api.g_exc_unexpected_error;
2864: END IF;
2865: END IF;
2866:

Line 2920: fnd_msg_pub.ADD;

2916: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2917: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom );
2918: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2919: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2920: fnd_msg_pub.ADD;
2921: RAISE fnd_api.g_exc_unexpected_error;
2922: END IF;
2923: g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom := l_mmtt_rec.transaction_uom ;
2924: END If;

Line 2981: fnd_msg_pub.ADD;

2977: END IF;
2978: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2979: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2980: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2981: fnd_msg_pub.ADD;
2982: RAISE fnd_api.g_exc_unexpected_error;
2983: END IF;
2984: ELSE
2985: l_primary_pending_quantity := l_pending_quantity;

Line 3074: fnd_msg_pub.ADD;

3070: END IF;
3071: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3072: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3073: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3074: fnd_msg_pub.ADD;
3075: RAISE fnd_api.g_exc_unexpected_error;
3076: END IF;
3077: END IF; -- if UOM code not primary UOM
3078:

Line 3111: fnd_msg_pub.ADD;

3107: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3108: DEBUG('Unable to lock the work order line for update', 'Finalize_Pick_Confirm');
3109: END IF;
3110: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
3111: fnd_msg_pub.ADD;
3112: RAISE fnd_api.g_exc_error;
3113: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
3114: IF (l_debug = 1) THEN
3115: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');

Line 4262: fnd_msg_pub.ADD;

4258: FOR UPDATE NOWAIT;
4259: EXCEPTION
4260: WHEN NO_DATA_FOUND THEN
4261: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
4262: fnd_msg_pub.ADD;
4263: RAISE fnd_api.g_exc_error;
4264: WHEN OTHERS THEN
4265: --could not lock row
4266: IF SQLCODE = -54 THEN

Line 4269: fnd_msg_pub.ADD;

4265: --could not lock row
4266: IF SQLCODE = -54 THEN
4267: fnd_message.set_name('INV', 'INV_DELIV_INFO_LOCKED');
4268: fnd_message.set_token('LINEID', l_trolin_rec.line_id);
4269: fnd_msg_pub.ADD;
4270: RAISE fnd_api.g_exc_error;
4271: ELSE
4272: RAISE fnd_api.g_exc_unexpected_error;
4273: END IF;

Line 4457: fnd_msg_pub.ADD;

4453: , p_organization_id => l_mmtt_rec.organization_id
4454: , p_inventory_item_id => l_mmtt_rec.inventory_item_id );
4455: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
4456: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
4457: fnd_msg_pub.ADD;
4458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4459: END IF;
4460:
4461: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)) THEN

Line 4463: fnd_msg_pub.ADD;

4459: END IF;
4460:
4461: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)) THEN
4462: fnd_message.set_name('INV', 'WMS_CATCH_WEIGHT_NO_LPN_ERR');
4463: fnd_msg_pub.ADD;
4464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4465: END IF;
4466:
4467: END IF;

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

6163: EXCEPTION
6164: WHEN fnd_api.g_exc_error THEN
6165: x_return_status := fnd_api.g_ret_sts_error;
6166: -- Get message count and data
6167: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6168: WHEN fnd_api.g_exc_unexpected_error THEN
6169: x_return_status := fnd_api.g_ret_sts_unexp_error;
6170: -- Get message count and data
6171: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

6167: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6168: WHEN fnd_api.g_exc_unexpected_error THEN
6169: x_return_status := fnd_api.g_ret_sts_unexp_error;
6170: -- Get message count and data
6171: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6172: WHEN OTHERS THEN
6173: x_return_status := fnd_api.g_ret_sts_unexp_error;
6174:
6175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

6171: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6172: WHEN OTHERS THEN
6173: x_return_status := fnd_api.g_ret_sts_unexp_error;
6174:
6175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6176: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Pick Confirm');
6177: END IF;
6178:
6179: -- Get message count and data

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

6172: WHEN OTHERS THEN
6173: x_return_status := fnd_api.g_ret_sts_unexp_error;
6174:
6175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6176: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Pick Confirm');
6177: END IF;
6178:
6179: -- Get message count and data
6180: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

6176: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Pick Confirm');
6177: END IF;
6178:
6179: -- Get message count and data
6180: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6181: END finalize_pick_confirm;
6182:
6183: -- Bug 2640757: Fill Kill Enhancement
6184: PROCEDURE kill_move_order(

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

6339: IF (l_debug = 1) THEN
6340: DEBUG('Expected error while closing the Line','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6341: END IF;
6342: x_return_status := FND_API.G_RET_STS_ERROR;
6343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6345: IF (l_debug = 1) THEN
6346: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6347: END IF;

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

6345: IF (l_debug = 1) THEN
6346: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6347: END IF;
6348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6349: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6350: WHEN OTHERS THEN
6351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6352:
6353: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

6349: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6350: WHEN OTHERS THEN
6351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6352:
6353: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6354: fnd_msg_pub.add_exc_msg(g_pkg_name, 'KILL_MOVE_ORDER');
6355: END IF;
6356: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6357: END kill_move_order;

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

6350: WHEN OTHERS THEN
6351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6352:
6353: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6354: fnd_msg_pub.add_exc_msg(g_pkg_name, 'KILL_MOVE_ORDER');
6355: END IF;
6356: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6357: END kill_move_order;
6358:

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

6352:
6353: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6354: fnd_msg_pub.add_exc_msg(g_pkg_name, 'KILL_MOVE_ORDER');
6355: END IF;
6356: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6357: END kill_move_order;
6358:
6359:
6360: --As part of fix for bug 2867490, we need to create the following procedure

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

6611: IF (l_debug = 1) THEN
6612: DEBUG('Expected error while closing the Line','INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6613: END IF;
6614: x_return_status := FND_API.G_RET_STS_ERROR;
6615: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6617: IF (l_debug = 1) THEN
6618: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6619: END IF;

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

6617: IF (l_debug = 1) THEN
6618: DEBUG('Unexpected error while closing the Line','INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6619: END IF;
6620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6621: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6622: WHEN OTHERS THEN
6623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6624:
6625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

6621: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6622: WHEN OTHERS THEN
6623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6624:
6625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6626: fnd_msg_pub.add_exc_msg(g_pkg_name, 'adjust_serial_numbers_in_MMTT');
6627: END IF;
6628: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6629: END adjust_serial_numbers_in_MSNT;

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

6622: WHEN OTHERS THEN
6623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6624:
6625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6626: fnd_msg_pub.add_exc_msg(g_pkg_name, 'adjust_serial_numbers_in_MMTT');
6627: END IF;
6628: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6629: END adjust_serial_numbers_in_MSNT;
6630:

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

6624:
6625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6626: fnd_msg_pub.add_exc_msg(g_pkg_name, 'adjust_serial_numbers_in_MMTT');
6627: END IF;
6628: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6629: END adjust_serial_numbers_in_MSNT;
6630:
6631: END inv_transfer_order_pvt;