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.AHL_MM_RESERVATIONS_PVT dependencies on AHL_MM_RESERVATIONS_PVT

Line 1: PACKAGE BODY AHL_MM_RESERVATIONS_PVT AS

1: PACKAGE BODY AHL_MM_RESERVATIONS_PVT AS
2: /* $Header: AHLVMMRB.pls 120.0.12020000.2 2012/12/14 10:35:47 shnatu noship $ */
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------

Line 1623: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : '

1619: fnd_log.string
1620: (
1621: fnd_log.level_statement,
1622: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1623: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : '
1624: );
1625: END IF;
1626:
1627: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION

Line 1627: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION

1623: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : '
1624: );
1625: END IF;
1626:
1627: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION
1628: (
1629: p_api_version => l_api_version,
1630: p_init_msg_list => l_init_msg_list,
1631: p_commit => FND_API.G_FALSE,

Line 1647: 'After Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION: P_RESERVATION_ID := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status

1643: fnd_log.string
1644: (
1645: fnd_log.level_statement,
1646: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1647: 'After Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION: P_RESERVATION_ID := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status
1648: );
1649: END IF;
1650:
1651: -- Check the error status

Line 1659: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Unexpected Error'

1655: fnd_log.string
1656: (
1657: fnd_log.level_error,
1658: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1659: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Unexpected Error'
1660: );
1661: END IF;
1662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1663: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1670: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Expected Error'

1666: fnd_log.string
1667: (
1668: fnd_log.level_error,
1669: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1670: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Expected Error'
1671: );
1672: END IF;
1673: --RAISE at the end of the API FND_API.G_EXC_ERROR;
1674: END IF;

Line 1709: AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION(

1705: l_filter_srl_number_tbl(1).serial_number := l_serial_number_tbl(i).serial_number;
1706: l_filter_srl_number_tbl(1).inventory_item_id := l_mtl_req_dtls_rec.inventory_item_id;
1707:
1708:
1709: AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION(
1710: p_api_version => l_api_version,
1711: p_init_msg_list => l_init_msg_list,
1712: p_commit => FND_API.G_FALSE,
1713: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

Line 1726: 'After Calling AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION: and l_return_status = '||l_return_status

1722: fnd_log.string
1723: (
1724: fnd_log.level_statement,
1725: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1726: 'After Calling AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION: and l_return_status = '||l_return_status
1727: );
1728: END IF;
1729:
1730: -- Check the error status

Line 1738: 'Call to AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION returned Unexpected Error'

1734: fnd_log.string
1735: (
1736: fnd_log.level_error,
1737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1738: 'Call to AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION returned Unexpected Error'
1739: );
1740: END IF;
1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1749: 'Call to AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION returned Expected Error'

1745: fnd_log.string
1746: (
1747: fnd_log.level_error,
1748: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1749: 'Call to AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION returned Expected Error'
1750: );
1751: END IF;
1752: RAISE FND_API.G_EXC_ERROR;
1753: END IF;

Line 1833: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : Supply is Inventory'

1829: fnd_log.string
1830: (
1831: fnd_log.level_statement,
1832: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1833: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : Supply is Inventory'
1834: );
1835: END IF;
1836: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION(
1837: p_api_version => l_api_version,

Line 1836: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION(

1832: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1833: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : Supply is Inventory'
1834: );
1835: END IF;
1836: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION(
1837: p_api_version => l_api_version,
1838: p_init_msg_list => l_init_msg_list,
1839: p_commit => FND_API.G_FALSE,
1840: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

Line 1854: 'After Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION: P_RESERVATION_ID := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status

1850: fnd_log.string
1851: (
1852: fnd_log.level_statement,
1853: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1854: 'After Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION: P_RESERVATION_ID := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status
1855: );
1856: END IF;
1857:
1858: -- Check the error status

Line 1866: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Unexpected Error'

1862: fnd_log.string
1863: (
1864: fnd_log.level_error,
1865: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1866: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Unexpected Error'
1867: );
1868: END IF;
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1877: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Expected Error'

1873: fnd_log.string
1874: (
1875: fnd_log.level_error,
1876: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1877: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Expected Error'
1878: );
1879: END IF;
1880: --RAISE at the end of the API FND_API.G_EXC_ERROR;
1881: END IF;

Line 1888: 'Calling AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION : Supply is Inventory'

1884: fnd_log.string
1885: (
1886: fnd_log.level_statement,
1887: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1888: 'Calling AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION : Supply is Inventory'
1889: );
1890: END IF;
1891:
1892: l_create_rsv_rec.subinventory_code := l_sub_inv_code;

Line 1898: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION(

1894: l_create_rsv_rec.lot_number := l_lot_number;
1895: l_create_rsv_rec.revision := l_revision;
1896: l_create_rsv_rec.primary_reservation_quantity := l_filter_srl_number_tbl.COUNT;
1897:
1898: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION(
1899: p_api_version => l_api_version,
1900: p_init_msg_list => l_init_msg_list,
1901: p_commit => FND_API.G_FALSE,
1902: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

Line 1916: 'After Calling AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION: x_reservation_id := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status

1912: fnd_log.string
1913: (
1914: fnd_log.level_statement,
1915: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1916: 'After Calling AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION: x_reservation_id := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status
1917: );
1918: END IF;
1919:
1920: -- Check the error status

Line 1928: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION returned Unexpected Error'

1924: fnd_log.string
1925: (
1926: fnd_log.level_error,
1927: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1928: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION returned Unexpected Error'
1929: );
1930: END IF;
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1939: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION returned Expected Error'

1935: fnd_log.string
1936: (
1937: fnd_log.level_error,
1938: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1939: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION returned Expected Error'
1940: );
1941: END IF;
1942: --RAISE at the end of the API FND_API.G_EXC_ERROR;
1943: END IF;

Line 1991: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : Supply is Workorder or Internal Requesition '

1987: fnd_log.string
1988: (
1989: fnd_log.level_statement,
1990: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1991: 'Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION : Supply is Workorder or Internal Requesition '
1992: );
1993: END IF;
1994:
1995: -- Added code by debadey

Line 2016: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION

2012: );
2013: END IF;
2014: -- End of changes by debadey
2015:
2016: AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION
2017: (
2018: p_api_version => l_api_version,
2019: p_init_msg_list => l_init_msg_list,
2020: p_commit => FND_API.G_FALSE,

Line 2036: 'After Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION: P_RESERVATION_ID := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status

2032: fnd_log.string
2033: (
2034: fnd_log.level_statement,
2035: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2036: 'After Calling AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION: P_RESERVATION_ID := '|| l_x_reservation_id || ' and l_return_status = '||l_return_status
2037: );
2038: END IF;
2039:
2040: -- Check the error status

Line 2048: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Unexpected Error'

2044: fnd_log.string
2045: (
2046: fnd_log.level_error,
2047: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2048: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Unexpected Error'
2049: );
2050: END IF;
2051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2059: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Expected Error'

2055: fnd_log.string
2056: (
2057: fnd_log.level_error,
2058: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2059: 'Call to AHL_MM_RESERVATIONS_PVT.UPDATE_RESERVATION returned Expected Error'
2060: );
2061: END IF;
2062: --RAISE at the end of the API FND_API.G_EXC_ERROR;
2063: END IF;

Line 2072: 'Calling AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION: Supply is Workorder or Internal Requesition'

2068: fnd_log.string
2069: (
2070: fnd_log.level_statement,
2071: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2072: 'Calling AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION: Supply is Workorder or Internal Requesition'
2073: );
2074: END IF;
2075: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION
2076: (

Line 2075: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION

2071: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2072: 'Calling AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION: Supply is Workorder or Internal Requesition'
2073: );
2074: END IF;
2075: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION
2076: (
2077: p_api_version => l_api_version,
2078: p_init_msg_list => l_init_msg_list,
2079: p_commit => FND_API.G_FALSE,

Line 2096: 'After AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION x_reservation_id := '|| x_reservation_id || ' and l_return_status = '||l_return_status

2092: fnd_log.string
2093: (
2094: fnd_log.level_statement,
2095: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2096: 'After AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION x_reservation_id := '|| x_reservation_id || ' and l_return_status = '||l_return_status
2097: );
2098: END IF;
2099: -- Check the error status
2100: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2107: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION Unexpected Error'

2103: fnd_log.string
2104: (
2105: fnd_log.level_error,
2106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2107: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION Unexpected Error'
2108: );
2109: END IF;
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2118: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION Expected Error'

2114: fnd_log.string
2115: (
2116: fnd_log.level_error,
2117: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2118: 'Call to AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION Expected Error'
2119: );
2120: END IF;
2121: --RAISE at the end of the API FND_API.G_EXC_ERROR;
2122: END IF;

Line 2460: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION(

2456:
2457: IF(l_resrv_quantity = l_tmp_serial_number_tbl.COUNT) THEN
2458:
2459:
2460: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION(
2461: p_api_version => l_api_version,
2462: p_init_msg_list => l_init_msg_list,
2463: p_commit => FND_API.G_FALSE,
2464: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

Line 2473: AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION(

2469: p_reservation_id => l_reservation_id);
2470:
2471:
2472: ELSE
2473: AHL_MM_RESERVATIONS_PVT.RELIEVE_RESERVATION(
2474: p_api_version => l_api_version,
2475: p_init_msg_list => l_init_msg_list,
2476: p_commit => FND_API.G_FALSE,
2477: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

Line 2504: 'Call to AHL_MM_RESERVATIONS_PVT.Relieve/Delete returned Unexpected Error'

2500: fnd_log.string
2501: (
2502: fnd_log.level_error,
2503: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2504: 'Call to AHL_MM_RESERVATIONS_PVT.Relieve/Delete returned Unexpected Error'
2505: );
2506: END IF;
2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2508: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2515: 'Call to AHL_MM_RESERVATIONS_PVT.Relieve/Delete returned Expected Error'

2511: fnd_log.string
2512: (
2513: fnd_log.level_error,
2514: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2515: 'Call to AHL_MM_RESERVATIONS_PVT.Relieve/Delete returned Expected Error'
2516: );
2517: END IF;
2518: RAISE FND_API.G_EXC_ERROR;
2519: END IF;

Line 3279: END AHL_MM_RESERVATIONS_PVT;

3275: );
3276: END IF;
3277: END INITIALIZE_WO_UPDATE_REC;
3278:
3279: END AHL_MM_RESERVATIONS_PVT;