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_RSV_RESERVATIONS_PVT dependencies on STANDARD

Line 35: -- Standard IN Parameters :

31: -- Procedure name : CREATE_RESERVATION
32: -- Type : Private
33: -- Function : Reserves the serial numbers in the p_serial_number_tbl
34: -- Pre-reqs :
35: -- Standard IN Parameters :
36: -- p_api_version IN NUMBER Required
37: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 41: -- Standard OUT Parameters :

37: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
40: -- p_module_type IN VARCHAR2 Default NULL
41: -- Standard OUT Parameters :
42: -- x_return_status OUT VARCHAR2 Required
43: -- x_msg_count OUT NUMBER Required
44: -- x_msg_data OUT VARCHAR2 Required
45:

Line 145: -- Standard start of API savepoint

141: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
142: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
143:
144: BEGIN
145: -- Standard start of API savepoint
146: SAVEPOINT CREATE_RESERVATION_PVT;
147: -- Initialize return status to success before any code logic/validation
148: x_return_status:= FND_API.G_RET_STS_SUCCESS;
149:

Line 151: -- Standard call to check for call compatibility

147: -- Initialize return status to success before any code logic/validation
148: x_return_status:= FND_API.G_RET_STS_SUCCESS;
149:
150:
151: -- Standard call to check for call compatibility
152: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;

Line 411: -- Standard call to get message count and if count is 1, get message info

407: );
408: END IF;
409: END IF;
410:
411: -- Standard call to get message count and if count is 1, get message info
412: FND_MSG_PUB.count_and_get
413: (
414: p_count => x_msg_count,
415: p_data => x_msg_data,

Line 478: -- Standard IN Parameters :

474: -- Procedure name : UPDATE_RESERVATION
475: -- Type : Private
476: -- Function : Updates reservation for serial numbers in the p_serial_number_tbl
477: -- Pre-reqs :
478: -- Standard IN Parameters :
479: -- p_api_version IN NUMBER Required
480: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
481: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
482: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 484: -- Standard OUT Parameters :

480: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
481: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
482: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
483: -- p_module_type IN VARCHAR2 Default NULL
484: -- Standard OUT Parameters :
485: -- x_return_status OUT VARCHAR2 Required
486: -- x_msg_count OUT NUMBER Required
487: -- x_msg_data OUT VARCHAR2 Required
488:

Line 527: -- Variables to check the log level according to the coding standards

523: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
526:
527: -- Variables to check the log level according to the coding standards
528: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
529: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
530:
531:

Line 551: -- Standard start of API savepoint

547: AND mrsv.inventory_item_id = asmt.inventory_item_id
548: AND mrsv.external_source_code = 'AHL';
549:
550: BEGIN
551: -- Standard start of API savepoint
552: SAVEPOINT UPDATE_RESERVATION_PVT;
553:
554: -- Initialize return status to success before any code logic/validation
555: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 557: -- Standard call to check for call compatibility

553:
554: -- Initialize return status to success before any code logic/validation
555: x_return_status:= FND_API.G_RET_STS_SUCCESS;
556:
557: -- Standard call to check for call compatibility
558: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
559: THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;

Line 738: -- Standard call to get message count and if count is 1, get message info

734: );
735: END IF;
736: END IF;
737:
738: -- Standard call to get message count and if count is 1, get message info
739: FND_MSG_PUB.count_and_get
740: (
741: p_count => x_msg_count,
742: p_data => x_msg_data,

Line 804: -- Standard IN Parameters :

800: -- Procedure name : DELETE_RESERVATION
801: -- Type : Private
802: -- Function : API to delete all the reservation made for a requirement
803: -- Pre-reqs :
804: -- Standard IN Parameters :
805: -- p_api_version IN NUMBER Required
806: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
807: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
808: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 810: -- Standard OUT Parameters :

806: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
807: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
808: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
809: -- p_module_type IN VARCHAR2 Default NULL
810: -- Standard OUT Parameters :
811: -- x_return_status OUT VARCHAR2 Required
812: -- x_msg_count OUT NUMBER Required
813: -- x_msg_data OUT VARCHAR2 Required
814:

Line 854: -- Variables to check the log level according to the coding standards

850:
851: l_ret_value NUMBER;
852: l_reservation_id NUMBER;
853:
854: -- Variables to check the log level according to the coding standards
855: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
856: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
857:
858: l_temp NUMBER;

Line 883: -- Standard start of API savepoint

879: AND mrsv.organization_id = asmt.organization_id
880: AND mrsv.requirement_date = asmt.requested_date
881: AND mrsv.inventory_item_id = asmt.inventory_item_id;
882: BEGIN
883: -- Standard start of API savepoint
884: SAVEPOINT DELETE_RESERVATION_PVT;
885:
886: -- Initialize return status to success before any code logic/validation
887: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 889: -- Standard call to check for call compatibility

885:
886: -- Initialize return status to success before any code logic/validation
887: x_return_status:= FND_API.G_RET_STS_SUCCESS;
888:
889: -- Standard call to check for call compatibility
890: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
891: THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;

Line 1108: -- Standard call to get message count and if count is 1, get message info

1104: );
1105: END IF;
1106: END IF;
1107:
1108: -- Standard call to get message count and if count is 1, get message info
1109: FND_MSG_PUB.count_and_get
1110: (
1111: p_count => x_msg_count,
1112: p_data => x_msg_data,

Line 1165: -- Standard IN Parameters :

1161: -- Procedure name : RELIEVE_RESERVATION
1162: -- Type : Private
1163: -- Function : API to delete the reservation made for a particular serial number
1164: -- Pre-reqs :
1165: -- Standard IN Parameters :
1166: -- p_api_version IN NUMBER Required
1167: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1168: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1169: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1171: -- Standard OUT Parameters :

1167: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1168: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1169: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1170: -- p_module_type IN VARCHAR2 Default NULL
1171: -- Standard OUT Parameters :
1172: -- x_return_status OUT VARCHAR2 Required
1173: -- x_msg_count OUT NUMBER Required
1174: -- x_msg_data OUT VARCHAR2 Required
1175:

Line 1212: -- Variables to check the log level according to the coding standards

1208: l_reserved_quantity NUMBER;
1209: l_x_primary_relieved_quantity NUMBER;
1210: l_x_primary_remain_quantity NUMBER;
1211:
1212: -- Variables to check the log level according to the coding standards
1213: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1214: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1215:
1216: -- Declare Cursors

Line 1271: -- Standard start of API savepoint

1267:
1268: l_get_instance_dtls_rec get_instance_dtls_csr%ROWTYPE;
1269:
1270: BEGIN
1271: -- Standard start of API savepoint
1272: SAVEPOINT RELIEVE_RESERVATION_PVT;
1273:
1274: -- Initialize return status to success before any code logic/validation
1275: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 1277: -- Standard call to check for call compatibility

1273:
1274: -- Initialize return status to success before any code logic/validation
1275: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1276:
1277: -- Standard call to check for call compatibility
1278: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1279: THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;

Line 1485: -- Standard call to get message count and if count is 1, get message info

1481: THEN
1482: COMMIT WORK;
1483: END IF;
1484:
1485: -- Standard call to get message count and if count is 1, get message info
1486: FND_MSG_PUB.count_and_get
1487: (
1488: p_count => x_msg_count,
1489: p_data => x_msg_data,

Line 1542: -- Standard IN Parameters :

1538: -- Procedure name : TRANSFER_RESERVATION
1539: -- Type : Private
1540: -- Function : API to change the demand source type, called when pushed to production
1541: -- Pre-reqs :
1542: -- Standard IN Parameters :
1543: -- p_api_version IN NUMBER Required
1544: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1545: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1546: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1548: -- Standard OUT Parameters :

1544: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1545: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1546: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1547: -- p_module_type IN VARCHAR2 Default NULL
1548: -- Standard OUT Parameters :
1549: -- x_return_status OUT VARCHAR2 Required
1550: -- x_msg_count OUT NUMBER Required
1551: -- x_msg_data OUT VARCHAR2 Required
1552:

Line 1588: -- Variables to check the log level according to the coding standards

1584: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1585: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1586: l_x_to_reservation_id NUMBER;
1587:
1588: -- Variables to check the log level according to the coding standards
1589: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1590: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1591:
1592: -- Declare Cursors and local record types

Line 1625: -- Standard start of API savepoint

1621: WHERE aw.status_code in ('1','3') -- 1:Unreleased,3:Released
1622: AND aw.visit_task_id = c_visit_task_id;
1623:
1624: BEGIN
1625: -- Standard start of API savepoint
1626: SAVEPOINT TRANSFER_RESERVATION_PVT;
1627:
1628: -- Initialize return status to success before any code logic/validation
1629: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 1631: -- Standard call to check for call compatibility

1627:
1628: -- Initialize return status to success before any code logic/validation
1629: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1630:
1631: -- Standard call to check for call compatibility
1632: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1633: THEN
1634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1635: END IF;

Line 1783: -- Standard call to get message count and if count is 1, get message info

1779: THEN
1780: COMMIT WORK;
1781: END IF;
1782:
1783: -- Standard call to get message count and if count is 1, get message info
1784: FND_MSG_PUB.count_and_get
1785: (
1786: p_count => x_msg_count,
1787: p_data => x_msg_data,

Line 1841: -- Standard IN Parameters :

1837: -- Procedure name : UPDATE_VISIT_RESERVATIONS
1838: -- Type : Private
1839: -- Function : API to update all the reservations for s particular visit
1840: -- Pre-reqs :
1841: -- Standard IN Parameters :
1842: -- Standard OUT Parameters :
1843: -- x_return_status OUT VARCHAR2 Required
1844: --
1845: -- UPDATE_VISIT_RESERVATIONS Parameters:

Line 1842: -- Standard OUT Parameters :

1838: -- Type : Private
1839: -- Function : API to update all the reservations for s particular visit
1840: -- Pre-reqs :
1841: -- Standard IN Parameters :
1842: -- Standard OUT Parameters :
1843: -- x_return_status OUT VARCHAR2 Required
1844: --
1845: -- UPDATE_VISIT_RESERVATIONS Parameters:
1846: -- p_visit_id : The id of the visit for which the reservations need to be transferred.

Line 1910: -- Standard start of API savepoint

1906: l_inventory_item_id NUMBER;
1907: l_temp_id NUMBER;
1908:
1909: BEGIN
1910: -- Standard start of API savepoint
1911: SAVEPOINT UPDATE_VISIT_RESERVATIONS_PVT;
1912:
1913: -- Initialize return status to success before any code logic/validation
1914: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 2122: -- Standard IN Parameters :

2118: -- Procedure name : DELETE_VISIT_RESERVATIONS
2119: -- Type : Private
2120: -- Function : API to delete all the reservations for s particular visit
2121: -- Pre-reqs :
2122: -- Standard IN Parameters :
2123: -- Standard OUT Parameters :
2124: -- x_return_status OUT VARCHAR2 Required
2125: --
2126: -- DELETE_VISIT_RESERVATIONS Parameters:

Line 2123: -- Standard OUT Parameters :

2119: -- Type : Private
2120: -- Function : API to delete all the reservations for s particular visit
2121: -- Pre-reqs :
2122: -- Standard IN Parameters :
2123: -- Standard OUT Parameters :
2124: -- x_return_status OUT VARCHAR2 Required
2125: --
2126: -- DELETE_VISIT_RESERVATIONS Parameters:
2127: -- p_visit_id : The visit id for which the reservations need to be deleted

Line 2154: -- Variables to check the log level according to the coding standards

2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2152: l_x_quantity_reserved NUMBER;
2153:
2154: -- Variables to check the log level according to the coding standards
2155: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2156: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2157:
2158: l_reservation_id NUMBER:= null;

Line 2179: -- Standard start of API savepoint

2175: AND mrsv.requirement_date = asmt.requested_date
2176: AND mrsv.inventory_item_id = asmt.inventory_item_id;
2177:
2178: BEGIN
2179: -- Standard start of API savepoint
2180: SAVEPOINT DELETE_VISIT_RESERVATIONS_PVT;
2181:
2182: -- Initialize return status to success before any code logic/validation
2183: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 2250: -- Standard IN Parameters :

2246: -- Procedure name : INITIALIZE_CREATE_REC
2247: -- Type : Private
2248: -- Function : To initializa the record that is to be passed into WMS api
2249: -- Pre-reqs :
2250: -- Standard IN Parameters :
2251: -- Standard OUT Parameters :
2252: -- INITIALIZE_CREATE_REC Parameters:
2253: -- p_rsv_rec :
2254: -- p_schedule_material_id :

Line 2251: -- Standard OUT Parameters :

2247: -- Type : Private
2248: -- Function : To initializa the record that is to be passed into WMS api
2249: -- Pre-reqs :
2250: -- Standard IN Parameters :
2251: -- Standard OUT Parameters :
2252: -- INITIALIZE_CREATE_REC Parameters:
2253: -- p_rsv_rec :
2254: -- p_schedule_material_id :
2255: -- x_rsv_rec :

Line 2269: -- Variables to check the log level according to the coding standards

2265:
2266: -- Declare local variables
2267: l_api_name CONSTANT VARCHAR2(30) := 'initialize_create_rec';
2268: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2269: -- Variables to check the log level according to the coding standards
2270: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2272:
2273: -- Declare cursors

Line 2467: -- Standard IN Parameters :

2463: -- Procedure name : TRANSFER_RESERVATION_MATRL_REQR
2464: -- Type : Private
2465: -- Function : API to transfer the reservations from one material requirement to another
2466: -- Pre-reqs :
2467: -- Standard IN Parameters :
2468: -- p_api_version IN NUMBER Required
2469: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2470: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2471: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2473: -- Standard OUT Parameters :

2469: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2470: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2471: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2472: -- p_module_type IN VARCHAR2 Default NULL
2473: -- Standard OUT Parameters :
2474: -- x_return_status OUT VARCHAR2 Required
2475: -- x_msg_count OUT NUMBER Required
2476: -- x_msg_data OUT VARCHAR2 Required
2477:

Line 2520: -- Variables to check the log level according to the coding standards

2516: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2517: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2518: l_x_to_reservation_id NUMBER;
2519:
2520: -- Variables to check the log level according to the coding standards
2521: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2522: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2523:
2524: BEGIN

Line 2525: -- Standard start of API savepoint

2521: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2522: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2523:
2524: BEGIN
2525: -- Standard start of API savepoint
2526: SAVEPOINT TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2527:
2528: -- Initialize return status to success before any code logic/validation
2529: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 2531: -- Standard call to check for call compatibility

2527:
2528: -- Initialize return status to success before any code logic/validation
2529: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2530:
2531: -- Standard call to check for call compatibility
2532: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2533: THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;

Line 2624: -- Standard call to get message count and if count is 1, get message info

2620: THEN
2621: COMMIT WORK;
2622: END IF;
2623:
2624: -- Standard call to get message count and if count is 1, get message info
2625: FND_MSG_PUB.count_and_get
2626: (
2627: p_count => x_msg_count,
2628: p_data => x_msg_data,