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_LOT_API_PKG dependencies on INV_LOT_ATTR_PUB

Line 1798: res := Inv_Lot_Attr_Pub.validate_origination_type (

1794:
1795: /******************* START Origination Type validation logic ********************/
1796:
1797: res := FALSE ;
1798: res := Inv_Lot_Attr_Pub.validate_origination_type (
1799: p_origination_type => p_origination_type
1800: , x_return_status => l_return_status
1801: , x_msg_count => l_msg_count
1802: , x_msg_data => l_msg_data

Line 1812: print_debug('Program Inv_Lot_Attr_Pub.validate_origination_type ' || l_return_status, 9);

1808: END IF;
1809: RAISE fnd_api.g_exc_error;
1810: END IF;
1811: IF g_debug = 1 THEN
1812: print_debug('Program Inv_Lot_Attr_Pub.validate_origination_type ' || l_return_status, 9);
1813: END IF;
1814: IF l_return_status = fnd_api.g_ret_sts_error THEN
1815: IF g_debug = 1 THEN
1816: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a user defined exception', 9);

Line 1816: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a user defined exception', 9);

1812: print_debug('Program Inv_Lot_Attr_Pub.validate_origination_type ' || l_return_status, 9);
1813: END IF;
1814: IF l_return_status = fnd_api.g_ret_sts_error THEN
1815: IF g_debug = 1 THEN
1816: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a user defined exception', 9);
1817: END IF;
1818: RAISE fnd_api.g_exc_error;
1819: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1820: IF g_debug = 1 THEN

Line 1821: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a Unexpected exception', 9);

1817: END IF;
1818: RAISE fnd_api.g_exc_error;
1819: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1820: IF g_debug = 1 THEN
1821: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a Unexpected exception', 9);
1822: END IF;
1823: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1824: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1825: FND_MSG_PUB.ADD;

Line 1824: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1820: IF g_debug = 1 THEN
1821: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a Unexpected exception', 9);
1822: END IF;
1823: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1824: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1825: FND_MSG_PUB.ADD;
1826: RAISE fnd_api.g_exc_unexpected_error;
1827: END IF;
1828:

Line 1836: res := Inv_Lot_Attr_Pub.validate_grade_code(

1832:
1833: /******************* START Grade Code validation logic ********************/
1834:
1835: res := FALSE ;
1836: res := Inv_Lot_Attr_Pub.validate_grade_code(
1837: p_grade_code => p_grade_code
1838: , p_org_id => p_organization_id
1839: , p_inventory_item_id => p_inventory_item_id
1840: , p_grade_control_flag => NULL

Line 1853: print_debug('Program Inv_Lot_Attr_Pub.validate_grade_code ' || l_return_status, 9);

1849: END IF;
1850: RAISE fnd_api.g_exc_error;
1851: END IF;
1852: IF g_debug = 1 THEN
1853: print_debug('Program Inv_Lot_Attr_Pub.validate_grade_code ' || l_return_status, 9);
1854: END IF;
1855: IF l_return_status = fnd_api.g_ret_sts_error THEN
1856: IF g_debug = 1 THEN
1857: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a user defined exception', 9);

Line 1857: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a user defined exception', 9);

1853: print_debug('Program Inv_Lot_Attr_Pub.validate_grade_code ' || l_return_status, 9);
1854: END IF;
1855: IF l_return_status = fnd_api.g_ret_sts_error THEN
1856: IF g_debug = 1 THEN
1857: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a user defined exception', 9);
1858: END IF;
1859: RAISE g_exc_error;
1860: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1861: IF g_debug = 1 THEN

Line 1862: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a Unexpected exception', 9);

1858: END IF;
1859: RAISE g_exc_error;
1860: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1861: IF g_debug = 1 THEN
1862: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a Unexpected exception', 9);
1863: END IF;
1864: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1865: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1866: FND_MSG_PUB.ADD;

Line 1865: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1861: IF g_debug = 1 THEN
1862: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a Unexpected exception', 9);
1863: END IF;
1864: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1865: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1866: FND_MSG_PUB.ADD;
1867: RAISE fnd_api.g_exc_unexpected_error;
1868: END IF;
1869:

Line 1876: res := Inv_Lot_Attr_Pub.validate_exp_action_code(

1872:
1873: /******************* START Expiration Action Code validation logic ********************/
1874:
1875: res := FALSE ;
1876: res := Inv_Lot_Attr_Pub.validate_exp_action_code(
1877: p_expiration_action_code => p_expiration_action_code
1878: , p_org_id => p_organization_id
1879: , p_inventory_item_id => p_inventory_item_id
1880: , p_shelf_life_code => NULL

Line 1893: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_code ' || l_return_status, 9);

1889: END IF;
1890: RAISE fnd_api.g_exc_error;
1891: END IF;
1892: IF g_debug = 1 THEN
1893: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_code ' || l_return_status, 9);
1894: END IF;
1895: IF l_return_status = fnd_api.g_ret_sts_error THEN
1896: IF g_debug = 1 THEN
1897: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a user defined exception', 9);

Line 1897: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a user defined exception', 9);

1893: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_code ' || l_return_status, 9);
1894: END IF;
1895: IF l_return_status = fnd_api.g_ret_sts_error THEN
1896: IF g_debug = 1 THEN
1897: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a user defined exception', 9);
1898: END IF;
1899: RAISE fnd_api.g_exc_error;
1900: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1901: IF g_debug = 1 THEN

Line 1902: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a Unexpected exception', 9);

1898: END IF;
1899: RAISE fnd_api.g_exc_error;
1900: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1901: IF g_debug = 1 THEN
1902: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a Unexpected exception', 9);
1903: END IF;
1904: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1905: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1906: FND_MSG_PUB.ADD;

Line 1905: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1901: IF g_debug = 1 THEN
1902: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a Unexpected exception', 9);
1903: END IF;
1904: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1905: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1906: FND_MSG_PUB.ADD;
1907: RAISE fnd_api.g_exc_unexpected_error;
1908: END IF;
1909:

Line 1925: res := Inv_Lot_Attr_Pub. validate_exp_action_date(

1921:
1922: IF l_item_info.expiration_action_interval IS NOT NULL
1923: AND l_item_info.expiration_action_interval > 0 THEN
1924:
1925: res := Inv_Lot_Attr_Pub. validate_exp_action_date(
1926: p_expiration_action_date => p_expiration_action_date
1927: , p_expiration_date => p_expiration_date
1928: , x_return_status => l_return_status
1929: , x_msg_count => l_msg_count

Line 1940: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_date ' || l_return_status, 9);

1936: END IF;
1937: RAISE fnd_api.g_exc_error;
1938: END IF;
1939: IF g_debug = 1 THEN
1940: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_date ' || l_return_status, 9);
1941: END IF;
1942: IF l_return_status = fnd_api.g_ret_sts_error THEN
1943: IF g_debug = 1 THEN
1944: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a user defined exception', 9);

Line 1944: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a user defined exception', 9);

1940: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_date ' || l_return_status, 9);
1941: END IF;
1942: IF l_return_status = fnd_api.g_ret_sts_error THEN
1943: IF g_debug = 1 THEN
1944: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a user defined exception', 9);
1945: END IF;
1946: RAISE fnd_api.g_exc_error;
1947: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1948: IF g_debug = 1 THEN

Line 1949: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a Unexpected exception', 9);

1945: END IF;
1946: RAISE fnd_api.g_exc_error;
1947: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1948: IF g_debug = 1 THEN
1949: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a Unexpected exception', 9);
1950: END IF;
1951: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1952: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1953: FND_MSG_PUB.ADD;

Line 1952: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1948: IF g_debug = 1 THEN
1949: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a Unexpected exception', 9);
1950: END IF;
1951: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1952: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1953: FND_MSG_PUB.ADD;
1954: RAISE fnd_api.g_exc_unexpected_error;
1955: END IF;
1956: END IF ; -- Check for positive expiration action interval

Line 1968: res := Inv_Lot_Attr_Pub.validate_retest_date(

1964:
1965: /******************* START Retest Date validation logic ********************/
1966:
1967: res := FALSE ;
1968: res := Inv_Lot_Attr_Pub.validate_retest_date(
1969: p_retest_date => p_retest_date
1970: , p_origination_date => p_origination_date
1971: , x_return_status => l_return_status
1972: , x_msg_count => l_msg_count

Line 1983: print_debug('Program Inv_Lot_Attr_Pub.validate_retest_date ' || l_return_status, 9);

1979: END IF;
1980: RAISE fnd_api.g_exc_error;
1981: END IF;
1982: IF g_debug = 1 THEN
1983: print_debug('Program Inv_Lot_Attr_Pub.validate_retest_date ' || l_return_status, 9);
1984: END IF;
1985: IF l_return_status = fnd_api.g_ret_sts_error THEN
1986: IF g_debug = 1 THEN
1987: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a user defined exception', 9);

Line 1987: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a user defined exception', 9);

1983: print_debug('Program Inv_Lot_Attr_Pub.validate_retest_date ' || l_return_status, 9);
1984: END IF;
1985: IF l_return_status = fnd_api.g_ret_sts_error THEN
1986: IF g_debug = 1 THEN
1987: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a user defined exception', 9);
1988: END IF;
1989: RAISE fnd_api.g_exc_error;
1990: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1991: IF g_debug = 1 THEN

Line 1992: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a Unexpected exception', 9);

1988: END IF;
1989: RAISE fnd_api.g_exc_error;
1990: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1991: IF g_debug = 1 THEN
1992: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a Unexpected exception', 9);
1993: END IF;
1994: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1995: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1996: FND_MSG_PUB.ADD;

Line 1995: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1991: IF g_debug = 1 THEN
1992: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a Unexpected exception', 9);
1993: END IF;
1994: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1995: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1996: FND_MSG_PUB.ADD;
1997: RAISE fnd_api.g_exc_unexpected_error;
1998: END IF;
1999:

Line 2007: res := Inv_Lot_Attr_Pub.validate_maturity_date(

2003:
2004: /******************* START Maturity Date validation logic ********************/
2005:
2006: res := FALSE ;
2007: res := Inv_Lot_Attr_Pub.validate_maturity_date(
2008: p_maturity_date => p_maturity_date
2009: , p_origination_date => p_origination_date
2010: , x_return_status => l_return_status
2011: , x_msg_count => l_msg_count

Line 2022: print_debug('Program Inv_Lot_Attr_Pub.validate_maturity_date ' || l_return_status, 9);

2018: END IF;
2019: RAISE fnd_api.g_exc_error;
2020: END IF;
2021: IF g_debug = 1 THEN
2022: print_debug('Program Inv_Lot_Attr_Pub.validate_maturity_date ' || l_return_status, 9);
2023: END IF;
2024: IF l_return_status = fnd_api.g_ret_sts_error THEN
2025: IF g_debug = 1 THEN
2026: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a user defined exception', 9);

Line 2026: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a user defined exception', 9);

2022: print_debug('Program Inv_Lot_Attr_Pub.validate_maturity_date ' || l_return_status, 9);
2023: END IF;
2024: IF l_return_status = fnd_api.g_ret_sts_error THEN
2025: IF g_debug = 1 THEN
2026: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a user defined exception', 9);
2027: END IF;
2028: RAISE fnd_api.g_exc_error;
2029: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2030: IF g_debug = 1 THEN

Line 2031: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a Unexpected exception', 9);

2027: END IF;
2028: RAISE fnd_api.g_exc_error;
2029: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2030: IF g_debug = 1 THEN
2031: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a Unexpected exception', 9);
2032: END IF;
2033: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2034: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2035: FND_MSG_PUB.ADD;

Line 2034: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

2030: IF g_debug = 1 THEN
2031: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a Unexpected exception', 9);
2032: END IF;
2033: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2034: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2035: FND_MSG_PUB.ADD;
2036: RAISE fnd_api.g_exc_unexpected_error;
2037: END IF;
2038:

Line 2046: res := Inv_Lot_Attr_Pub.validate_hold_date(

2042:
2043: /******************* START Hold Date validation logic ********************/
2044:
2045: res := FALSE ;
2046: res := Inv_Lot_Attr_Pub.validate_hold_date(
2047: p_hold_date => p_hold_date
2048: , p_origination_date => p_origination_date
2049: , x_return_status => l_return_status
2050: , x_msg_count => l_msg_count

Line 2061: print_debug('Program Inv_Lot_Attr_Pub.validate_hold_date ' || l_return_status, 9);

2057: END IF;
2058: RAISE fnd_api.g_exc_error;
2059: END IF;
2060: IF g_debug = 1 THEN
2061: print_debug('Program Inv_Lot_Attr_Pub.validate_hold_date ' || l_return_status, 9);
2062: END IF;
2063: IF l_return_status = fnd_api.g_ret_sts_error THEN
2064: IF g_debug = 1 THEN
2065: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a user defined exception', 9);

Line 2065: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a user defined exception', 9);

2061: print_debug('Program Inv_Lot_Attr_Pub.validate_hold_date ' || l_return_status, 9);
2062: END IF;
2063: IF l_return_status = fnd_api.g_ret_sts_error THEN
2064: IF g_debug = 1 THEN
2065: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a user defined exception', 9);
2066: END IF;
2067: RAISE fnd_api.g_exc_error;
2068: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2069: IF g_debug = 1 THEN

Line 2070: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a Unexpected exception', 9);

2066: END IF;
2067: RAISE fnd_api.g_exc_error;
2068: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2069: IF g_debug = 1 THEN
2070: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a Unexpected exception', 9);
2071: END IF;
2072: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2073: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2074: FND_MSG_PUB.ADD;

Line 2073: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

2069: IF g_debug = 1 THEN
2070: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a Unexpected exception', 9);
2071: END IF;
2072: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2073: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2074: FND_MSG_PUB.ADD;
2075: RAISE fnd_api.g_exc_unexpected_error;
2076: END IF;
2077: