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 1854: res := Inv_Lot_Attr_Pub.validate_origination_type (

1850:
1851: /******************* START Origination Type validation logic ********************/
1852:
1853: res := FALSE ;
1854: res := Inv_Lot_Attr_Pub.validate_origination_type (
1855: p_origination_type => p_origination_type
1856: , x_return_status => l_return_status
1857: , x_msg_count => l_msg_count
1858: , x_msg_data => l_msg_data

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

1864: END IF;
1865: RAISE fnd_api.g_exc_error;
1866: END IF;
1867: IF g_debug = 1 THEN
1868: print_debug('Program Inv_Lot_Attr_Pub.validate_origination_type ' || l_return_status, 9);
1869: END IF;
1870: IF l_return_status = fnd_api.g_ret_sts_error THEN
1871: IF g_debug = 1 THEN
1872: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a user defined exception', 9);

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

1868: print_debug('Program Inv_Lot_Attr_Pub.validate_origination_type ' || l_return_status, 9);
1869: END IF;
1870: IF l_return_status = fnd_api.g_ret_sts_error THEN
1871: IF g_debug = 1 THEN
1872: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a user defined exception', 9);
1873: END IF;
1874: RAISE fnd_api.g_exc_error;
1875: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1876: IF g_debug = 1 THEN

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

1873: END IF;
1874: RAISE fnd_api.g_exc_error;
1875: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1876: IF g_debug = 1 THEN
1877: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a Unexpected exception', 9);
1878: END IF;
1879: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1880: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1881: FND_MSG_PUB.ADD;

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

1876: IF g_debug = 1 THEN
1877: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a Unexpected exception', 9);
1878: END IF;
1879: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1880: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1881: FND_MSG_PUB.ADD;
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: END IF;
1884:

Line 1892: res := Inv_Lot_Attr_Pub.validate_grade_code(

1888:
1889: /******************* START Grade Code validation logic ********************/
1890:
1891: res := FALSE ;
1892: res := Inv_Lot_Attr_Pub.validate_grade_code(
1893: p_grade_code => p_grade_code
1894: , p_org_id => p_organization_id
1895: , p_inventory_item_id => p_inventory_item_id
1896: , p_grade_control_flag => NULL

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

1905: END IF;
1906: RAISE fnd_api.g_exc_error;
1907: END IF;
1908: IF g_debug = 1 THEN
1909: print_debug('Program Inv_Lot_Attr_Pub.validate_grade_code ' || l_return_status, 9);
1910: END IF;
1911: IF l_return_status = fnd_api.g_ret_sts_error THEN
1912: IF g_debug = 1 THEN
1913: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a user defined exception', 9);

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

1909: print_debug('Program Inv_Lot_Attr_Pub.validate_grade_code ' || l_return_status, 9);
1910: END IF;
1911: IF l_return_status = fnd_api.g_ret_sts_error THEN
1912: IF g_debug = 1 THEN
1913: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a user defined exception', 9);
1914: END IF;
1915: RAISE g_exc_error;
1916: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1917: IF g_debug = 1 THEN

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

1914: END IF;
1915: RAISE g_exc_error;
1916: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1917: IF g_debug = 1 THEN
1918: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a Unexpected exception', 9);
1919: END IF;
1920: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1921: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1922: FND_MSG_PUB.ADD;

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

1917: IF g_debug = 1 THEN
1918: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a Unexpected exception', 9);
1919: END IF;
1920: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1921: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1922: FND_MSG_PUB.ADD;
1923: RAISE fnd_api.g_exc_unexpected_error;
1924: END IF;
1925:

Line 1932: res := Inv_Lot_Attr_Pub.validate_exp_action_code(

1928:
1929: /******************* START Expiration Action Code validation logic ********************/
1930:
1931: res := FALSE ;
1932: res := Inv_Lot_Attr_Pub.validate_exp_action_code(
1933: p_expiration_action_code => p_expiration_action_code
1934: , p_org_id => p_organization_id
1935: , p_inventory_item_id => p_inventory_item_id
1936: , p_shelf_life_code => NULL

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

1945: END IF;
1946: RAISE fnd_api.g_exc_error;
1947: END IF;
1948: IF g_debug = 1 THEN
1949: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_code ' || l_return_status, 9);
1950: END IF;
1951: IF l_return_status = fnd_api.g_ret_sts_error THEN
1952: IF g_debug = 1 THEN
1953: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a user defined exception', 9);

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

1949: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_code ' || l_return_status, 9);
1950: END IF;
1951: IF l_return_status = fnd_api.g_ret_sts_error THEN
1952: IF g_debug = 1 THEN
1953: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a user defined exception', 9);
1954: END IF;
1955: RAISE fnd_api.g_exc_error;
1956: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1957: IF g_debug = 1 THEN

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

1954: END IF;
1955: RAISE fnd_api.g_exc_error;
1956: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1957: IF g_debug = 1 THEN
1958: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a Unexpected exception', 9);
1959: END IF;
1960: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1961: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1962: FND_MSG_PUB.ADD;

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

1957: IF g_debug = 1 THEN
1958: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a Unexpected exception', 9);
1959: END IF;
1960: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1961: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1962: FND_MSG_PUB.ADD;
1963: RAISE fnd_api.g_exc_unexpected_error;
1964: END IF;
1965:

Line 1981: res := Inv_Lot_Attr_Pub. validate_exp_action_date(

1977:
1978: IF l_item_info.expiration_action_interval IS NOT NULL
1979: AND l_item_info.expiration_action_interval > 0 THEN
1980:
1981: res := Inv_Lot_Attr_Pub. validate_exp_action_date(
1982: p_expiration_action_date => p_expiration_action_date
1983: , p_expiration_date => p_expiration_date
1984: , x_return_status => l_return_status
1985: , x_msg_count => l_msg_count

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

1992: END IF;
1993: RAISE fnd_api.g_exc_error;
1994: END IF;
1995: IF g_debug = 1 THEN
1996: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_date ' || l_return_status, 9);
1997: END IF;
1998: IF l_return_status = fnd_api.g_ret_sts_error THEN
1999: IF g_debug = 1 THEN
2000: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a user defined exception', 9);

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

1996: print_debug('Program Inv_Lot_Attr_Pub.validate_exp_action_date ' || l_return_status, 9);
1997: END IF;
1998: IF l_return_status = fnd_api.g_ret_sts_error THEN
1999: IF g_debug = 1 THEN
2000: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a user defined exception', 9);
2001: END IF;
2002: RAISE fnd_api.g_exc_error;
2003: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2004: IF g_debug = 1 THEN

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

2001: END IF;
2002: RAISE fnd_api.g_exc_error;
2003: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2004: IF g_debug = 1 THEN
2005: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a Unexpected exception', 9);
2006: END IF;
2007: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2008: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2009: FND_MSG_PUB.ADD;

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

2004: IF g_debug = 1 THEN
2005: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a Unexpected exception', 9);
2006: END IF;
2007: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2008: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2009: FND_MSG_PUB.ADD;
2010: RAISE fnd_api.g_exc_unexpected_error;
2011: END IF;
2012: END IF ; -- Check for positive expiration action interval

Line 2024: res := Inv_Lot_Attr_Pub.validate_retest_date(

2020:
2021: /******************* START Retest Date validation logic ********************/
2022:
2023: res := FALSE ;
2024: res := Inv_Lot_Attr_Pub.validate_retest_date(
2025: p_retest_date => p_retest_date
2026: , p_origination_date => p_origination_date
2027: , x_return_status => l_return_status
2028: , x_msg_count => l_msg_count

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

2035: END IF;
2036: RAISE fnd_api.g_exc_error;
2037: END IF;
2038: IF g_debug = 1 THEN
2039: print_debug('Program Inv_Lot_Attr_Pub.validate_retest_date ' || l_return_status, 9);
2040: END IF;
2041: IF l_return_status = fnd_api.g_ret_sts_error THEN
2042: IF g_debug = 1 THEN
2043: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a user defined exception', 9);

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

2039: print_debug('Program Inv_Lot_Attr_Pub.validate_retest_date ' || l_return_status, 9);
2040: END IF;
2041: IF l_return_status = fnd_api.g_ret_sts_error THEN
2042: IF g_debug = 1 THEN
2043: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a user defined exception', 9);
2044: END IF;
2045: RAISE fnd_api.g_exc_error;
2046: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2047: IF g_debug = 1 THEN

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

2044: END IF;
2045: RAISE fnd_api.g_exc_error;
2046: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2047: IF g_debug = 1 THEN
2048: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a Unexpected exception', 9);
2049: END IF;
2050: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2051: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2052: FND_MSG_PUB.ADD;

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

2047: IF g_debug = 1 THEN
2048: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a Unexpected exception', 9);
2049: END IF;
2050: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2051: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2052: FND_MSG_PUB.ADD;
2053: RAISE fnd_api.g_exc_unexpected_error;
2054: END IF;
2055:

Line 2063: res := Inv_Lot_Attr_Pub.validate_maturity_date(

2059:
2060: /******************* START Maturity Date validation logic ********************/
2061:
2062: res := FALSE ;
2063: res := Inv_Lot_Attr_Pub.validate_maturity_date(
2064: p_maturity_date => p_maturity_date
2065: , p_origination_date => p_origination_date
2066: , x_return_status => l_return_status
2067: , x_msg_count => l_msg_count

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

2074: END IF;
2075: RAISE fnd_api.g_exc_error;
2076: END IF;
2077: IF g_debug = 1 THEN
2078: print_debug('Program Inv_Lot_Attr_Pub.validate_maturity_date ' || l_return_status, 9);
2079: END IF;
2080: IF l_return_status = fnd_api.g_ret_sts_error THEN
2081: IF g_debug = 1 THEN
2082: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a user defined exception', 9);

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

2078: print_debug('Program Inv_Lot_Attr_Pub.validate_maturity_date ' || l_return_status, 9);
2079: END IF;
2080: IF l_return_status = fnd_api.g_ret_sts_error THEN
2081: IF g_debug = 1 THEN
2082: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a user defined exception', 9);
2083: END IF;
2084: RAISE fnd_api.g_exc_error;
2085: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2086: IF g_debug = 1 THEN

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

2083: END IF;
2084: RAISE fnd_api.g_exc_error;
2085: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2086: IF g_debug = 1 THEN
2087: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a Unexpected exception', 9);
2088: END IF;
2089: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2090: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2091: FND_MSG_PUB.ADD;

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

2086: IF g_debug = 1 THEN
2087: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a Unexpected exception', 9);
2088: END IF;
2089: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2090: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2091: FND_MSG_PUB.ADD;
2092: RAISE fnd_api.g_exc_unexpected_error;
2093: END IF;
2094:

Line 2102: res := Inv_Lot_Attr_Pub.validate_hold_date(

2098:
2099: /******************* START Hold Date validation logic ********************/
2100:
2101: res := FALSE ;
2102: res := Inv_Lot_Attr_Pub.validate_hold_date(
2103: p_hold_date => p_hold_date
2104: , p_origination_date => p_origination_date
2105: , x_return_status => l_return_status
2106: , x_msg_count => l_msg_count

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

2113: END IF;
2114: RAISE fnd_api.g_exc_error;
2115: END IF;
2116: IF g_debug = 1 THEN
2117: print_debug('Program Inv_Lot_Attr_Pub.validate_hold_date ' || l_return_status, 9);
2118: END IF;
2119: IF l_return_status = fnd_api.g_ret_sts_error THEN
2120: IF g_debug = 1 THEN
2121: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a user defined exception', 9);

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

2117: print_debug('Program Inv_Lot_Attr_Pub.validate_hold_date ' || l_return_status, 9);
2118: END IF;
2119: IF l_return_status = fnd_api.g_ret_sts_error THEN
2120: IF g_debug = 1 THEN
2121: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a user defined exception', 9);
2122: END IF;
2123: RAISE fnd_api.g_exc_error;
2124: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2125: IF g_debug = 1 THEN

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

2122: END IF;
2123: RAISE fnd_api.g_exc_error;
2124: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2125: IF g_debug = 1 THEN
2126: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a Unexpected exception', 9);
2127: END IF;
2128: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2129: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2130: FND_MSG_PUB.ADD;

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

2125: IF g_debug = 1 THEN
2126: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a Unexpected exception', 9);
2127: END IF;
2128: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2129: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2130: FND_MSG_PUB.ADD;
2131: RAISE fnd_api.g_exc_unexpected_error;
2132: END IF;
2133: