DBA Data[Home] [Help]

APPS.AHL_MM_RESERVATIONS_PVT dependencies on STANDARD

Line 102: -- Standard start of API savepoint

98: l_scheduled_material_id NUMBER := p_rsv_rec.demand_source_line_detail;
99: l_x_reservation_id NUMBER;
100:
101: BEGIN
102: -- Standard start of API savepoint
103: SAVEPOINT CREATE_RESERVATION_PVT;
104: -- Initialize return status to success before any code logic/validation
105: x_return_status:= FND_API.G_RET_STS_SUCCESS;
106:

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

104: -- Initialize return status to success before any code logic/validation
105: x_return_status:= FND_API.G_RET_STS_SUCCESS;
106:
107:
108: -- Standard call to check for call compatibility
109: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
110: THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;

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

310: );
311: END IF;
312: END IF;
313:
314: -- Standard call to get message count and if count is 1, get message info
315: FND_MSG_PUB.count_and_get
316: (
317: p_count => x_msg_count,
318: p_data => x_msg_data,

Line 418: -- Standard start of API savepoint

414: l_scheduled_material_id NUMBER;
415: l_inventory_item_id NUMBER;
416:
417: BEGIN
418: -- Standard start of API savepoint
419: SAVEPOINT UPDATE_RESERVATION_PVT;
420:
421: -- Initialize return status to success before any code logic/validation
422: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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

420:
421: -- Initialize return status to success before any code logic/validation
422: x_return_status:= FND_API.G_RET_STS_SUCCESS;
423:
424: -- Standard call to check for call compatibility
425: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
426: THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;

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

596: );
597: END IF;
598: END IF;
599:
600: -- Standard call to get message count and if count is 1, get message info
601: FND_MSG_PUB.count_and_get
602: (
603: p_count => x_msg_count,
604: p_data => x_msg_data,

Line 698: -- Standard start of API savepoint

694:
695: l_scheduled_material_id NUMBER;
696:
697: BEGIN
698: -- Standard start of API savepoint
699: SAVEPOINT DELETE_RESERVATION_PVT;
700:
701: -- Initialize return status to success before any code logic/validation
702: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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

700:
701: -- Initialize return status to success before any code logic/validation
702: x_return_status:= FND_API.G_RET_STS_SUCCESS;
703:
704: -- Standard call to check for call compatibility
705: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
706: THEN
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END IF;

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

806: );
807: END IF;
808: END IF;
809:
810: -- Standard call to get message count and if count is 1, get message info
811: FND_MSG_PUB.count_and_get
812: (
813: p_count => x_msg_count,
814: p_data => x_msg_data,

Line 901: -- Standard start of API savepoint

897: l_scheduled_material_id NUMBER;
898:
899:
900: BEGIN
901: -- Standard start of API savepoint
902: SAVEPOINT RELIEVE_RESERVATION_PVT;
903:
904: -- Initialize return status to success before any code logic/validation
905: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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

903:
904: -- Initialize return status to success before any code logic/validation
905: x_return_status:= FND_API.G_RET_STS_SUCCESS;
906:
907: -- Standard call to check for call compatibility
908: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
909: THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;

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

1059: THEN
1060: COMMIT WORK;
1061: END IF;
1062:
1063: -- Standard call to get message count and if count is 1, get message info
1064: FND_MSG_PUB.count_and_get
1065: (
1066: p_count => x_msg_count,
1067: p_data => x_msg_data,

Line 1165: -- Standard start of API savepoint

1161: l_scheduled_material_id NUMBER;
1162:
1163:
1164: BEGIN
1165: -- Standard start of API savepoint
1166: SAVEPOINT TRANSFER_RESERVATION_PVT;
1167:
1168: -- Initialize return status to success before any code logic/validation
1169: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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

1167:
1168: -- Initialize return status to success before any code logic/validation
1169: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1170:
1171: -- Standard call to check for call compatibility
1172: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1173: THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;

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

1427: THEN
1428: COMMIT WORK;
1429: END IF;
1430:
1431: -- Standard call to get message count and if count is 1, get message info
1432: FND_MSG_PUB.count_and_get
1433: (
1434: p_count => x_msg_count,
1435: p_data => x_msg_data,

Line 1543: -- Standard start of API savepoint

1539: l_fetch_lot_number VARCHAR2(80);
1540: l_reservation_id NUMBER;
1541:
1542: BEGIN
1543: -- Standard start of API savepoint
1544: SAVEPOINT PROCESS_RESERVATION_PVT;
1545: -- Initialize return status to success before any code logic/validation
1546: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1547:

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

1545: -- Initialize return status to success before any code logic/validation
1546: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1547:
1548:
1549: -- Standard call to check for call compatibility
1550: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1551: THEN
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553: END IF;

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

2168: );
2169: END IF;
2170: END IF;
2171:
2172: -- Standard call to get message count and if count is 1, get message info
2173: FND_MSG_PUB.count_and_get
2174: (
2175: p_count => x_msg_count,
2176: p_data => x_msg_data,

Line 2284: -- Standard start of API savepoint

2280: l_resrv_quantity NUMBER;
2281: l_index NUMBER;
2282:
2283: BEGIN
2284: -- Standard start of API savepoint
2285: SAVEPOINT CANCEL_RESERVATION_PVT;
2286: -- Initialize return status to success before any code logic/validation
2287: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2288:

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

2286: -- Initialize return status to success before any code logic/validation
2287: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2288:
2289:
2290: -- Standard call to check for call compatibility
2291: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2292: THEN
2293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2294: END IF;

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

2563: );
2564: END IF;
2565: END IF;
2566:
2567: -- Standard call to get message count and if count is 1, get message info
2568: FND_MSG_PUB.count_and_get
2569: (
2570: p_count => x_msg_count,
2571: p_data => x_msg_data,

Line 2634: -- Standard IN Parameters :

2630: -- Procedure name : INITIALIZE_REC_FROM_RESV
2631: -- Type : Private
2632: -- Function : To initializa the record that is to be passed into WMS api
2633: -- Pre-reqs :
2634: -- Standard IN Parameters :
2635: -- Standard OUT Parameters :
2636: -- INITIALIZE_REC_FROM_RESV Parameters:
2637: -- p_rsv_rec :
2638: -- p_schedule_material_id :

Line 2635: -- Standard OUT Parameters :

2631: -- Type : Private
2632: -- Function : To initializa the record that is to be passed into WMS api
2633: -- Pre-reqs :
2634: -- Standard IN Parameters :
2635: -- Standard OUT Parameters :
2636: -- INITIALIZE_REC_FROM_RESV Parameters:
2637: -- p_rsv_rec :
2638: -- p_schedule_material_id :
2639: -- p_x_rsv_rec :

Line 2738: -- Standard IN Parameters :

2734: -- Procedure name : INITIALIZE_CREATE_REC
2735: -- Type : Private
2736: -- Function : To initializa the record that is to be passed into WMS api
2737: -- Pre-reqs :
2738: -- Standard IN Parameters :
2739: -- Standard OUT Parameters :
2740: -- INITIALIZE_CREATE_REC Parameters:
2741: -- p_rsv_rec :
2742: -- p_schedule_material_id :

Line 2739: -- Standard OUT Parameters :

2735: -- Type : Private
2736: -- Function : To initializa the record that is to be passed into WMS api
2737: -- Pre-reqs :
2738: -- Standard IN Parameters :
2739: -- Standard OUT Parameters :
2740: -- INITIALIZE_CREATE_REC Parameters:
2741: -- p_rsv_rec :
2742: -- p_schedule_material_id :
2743: -- p_x_rsv_rec :

Line 3102: -- Standard IN Parameters :

3098: -- Procedure name : INITIALIZE_WO_UPDATE_REC
3099: -- Type : Private
3100: -- Function : To initializa the record that is to be passed into WMS Update Reservation API
3101: -- Pre-reqs :
3102: -- Standard IN Parameters :
3103: -- Standard OUT Parameters :
3104: -- INITIALIZE_CREATE_REC Parameters:
3105: -- p_rsv_rec :
3106: -- p_schedule_material_id :

Line 3103: -- Standard OUT Parameters :

3099: -- Type : Private
3100: -- Function : To initializa the record that is to be passed into WMS Update Reservation API
3101: -- Pre-reqs :
3102: -- Standard IN Parameters :
3103: -- Standard OUT Parameters :
3104: -- INITIALIZE_CREATE_REC Parameters:
3105: -- p_rsv_rec :
3106: -- p_schedule_material_id :
3107: -- p_x_rsv_rec :