DBA Data[Home] [Help]

APPS.ASO_RESERVATION_INT dependencies on STANDARD

Line 53: -- Standard Start of API savepoint

49: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation' ;
50: l_api_version_number CONSTANT NUMBER := '1.0';
51: l_profile_name varchar2(240);
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT CREATE_RESERVATION_PUB;
55:
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 56: -- Standard call to check for call compatibility.

52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT CREATE_RESERVATION_PUB;
55:
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
58: p_api_version_number,
59: l_api_name,
60: G_PKG_NAME)

Line 182: -- Standard check for p_commit

178: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
179: raise FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: -- Standard check for p_commit
183: IF FND_API.to_Boolean( p_commit )
184: THEN
185: COMMIT WORK;
186: END IF;

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

185: COMMIT WORK;
186: END IF;
187:
188:
189: -- Standard call to get message count and if count is 1, get message info.
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data );
193:

Line 255: -- Standard Start of API savepoint

251: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
253: l_api_version_number CONSTANT NUMBER := 1.0;
254: BEGIN
255: -- Standard Start of API savepoint
256: SAVEPOINT UPDATE_RESERVATION_PUB;
257:
258: -- Standard call to check for call compatibility.
259: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 258: -- Standard call to check for call compatibility.

254: BEGIN
255: -- Standard Start of API savepoint
256: SAVEPOINT UPDATE_RESERVATION_PUB;
257:
258: -- Standard call to check for call compatibility.
259: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
260: p_api_version_number,
261: l_api_name,
262: G_PKG_NAME)

Line 319: -- Standard check for p_commit

315: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
316: raise FND_API.G_EXC_UNEXPECTED_ERROR;
317: END IF;
318:
319: -- Standard check for p_commit
320: IF FND_API.to_Boolean( p_commit )
321: THEN
322: COMMIT WORK;
323: END IF;

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

321: THEN
322: COMMIT WORK;
323: END IF;
324:
325: -- Standard call to get message count and if count is 1, get message info.
326: FND_MSG_PUB.Count_And_Get
327: ( p_count => x_msg_count,
328: p_data => x_msg_data );
329: EXCEPTION

Line 384: -- Standard Start of API savepoint

380: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
381: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
382: l_api_version_number CONSTANT NUMBER := 1.0;
383: BEGIN
384: -- Standard Start of API savepoint
385: SAVEPOINT DELETE_RESERVATION_PUB;
386:
387: -- Standard call to check for call compatibility.
388: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 387: -- Standard call to check for call compatibility.

383: BEGIN
384: -- Standard Start of API savepoint
385: SAVEPOINT DELETE_RESERVATION_PUB;
386:
387: -- Standard call to check for call compatibility.
388: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
389: p_api_version_number,
390: l_api_name,
391: G_PKG_NAME)

Line 439: -- Standard check for p_commit

435: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
436: raise FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: -- Standard check for p_commit
440: IF FND_API.to_Boolean( p_commit )
441: THEN
442: COMMIT WORK;
443: END IF;

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

441: THEN
442: COMMIT WORK;
443: END IF;
444:
445: -- Standard call to get message count and if count is 1, get message info.
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data );
449: EXCEPTION

Line 507: -- Standard Start of API savepoint

503:
504: -- Initialize API return status to SUCCESS
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: -- Standard Start of API savepoint
508: SAVEPOINT TRANSFER_RESERVATION_PUB;
509:
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 510: -- Standard call to check for call compatibility.

506:
507: -- Standard Start of API savepoint
508: SAVEPOINT TRANSFER_RESERVATION_PUB;
509:
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
512: p_api_version_number,
513: l_api_name,
514: G_PKG_NAME)

Line 574: -- Standard check for p_commit

570: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
571: raise FND_API.G_EXC_UNEXPECTED_ERROR;
572: END IF;
573:
574: -- Standard check for p_commit
575: IF FND_API.to_Boolean( p_commit )
576: THEN
577: COMMIT WORK;
578: END IF;

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

578: END IF;
579:
580: x_new_reservation_id := l_new_rsv_id ;
581:
582: -- Standard call to get message count and if count is 1, get message info.
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count,
585: p_data => x_msg_data );
586: EXCEPTION