DBA Data[Home] [Help]

APPS.AMS_VENUE_RATES_PVT dependencies on STANDARD

Line 63: -- Standard Start of API savepoint

59: FROM AMS_VENUE_RATES_B
60: WHERE RATE_ID = l_id;
61:
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Venue_Rates_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Venue_Rates_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
68: p_api_version_number,
69: l_api_name,
70: G_PKG_NAME)

Line 204: -- Standard check for p_commit

200: --
201: -- End of API body
202: --
203:
204: -- Standard check for p_commit
205: IF FND_API.to_Boolean( p_commit )
206: THEN
207: COMMIT WORK;
208: END IF;

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

213:
214: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
215: END IF;
216:
217: -- Standard call to get message count and if count is 1, get message info.
218: FND_MSG_PUB.Count_And_Get
219: (p_count => x_msg_count,
220: p_data => x_msg_data
221: );

Line 231: -- Standard call to get message count and if count=1, get the message

227:
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO CREATE_Venue_Rates_PVT;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.Count_And_Get (
233: p_encoded => FND_API.G_FALSE,
234: p_count => x_msg_count,
235: p_data => x_msg_data

Line 241: -- Standard call to get message count and if count=1, get the message

237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO CREATE_Venue_Rates_PVT;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: -- Standard call to get message count and if count=1, get the message
242: FND_MSG_PUB.Count_And_Get (
243: p_encoded => FND_API.G_FALSE,
244: p_count => x_msg_count,
245: p_data => x_msg_data

Line 255: -- Standard call to get message count and if count=1, get the message

251: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
252: THEN
253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
254: END IF;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data

Line 295: -- Standard Start of API savepoint

291: l_tar_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type := P_venue_rates_rec;
292: l_rowid ROWID;
293:
294: BEGIN
295: -- Standard Start of API savepoint
296: SAVEPOINT UPDATE_Venue_Rates_PVT;
297:
298: -- Standard call to check for call compatibility.
299: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

294: BEGIN
295: -- Standard Start of API savepoint
296: SAVEPOINT UPDATE_Venue_Rates_PVT;
297:
298: -- Standard call to check for call compatibility.
299: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
300: p_api_version_number,
301: l_api_name,
302: G_PKG_NAME)

Line 436: -- Standard check for p_commit

432: --
433: -- End of API body.
434: --
435:
436: -- Standard check for p_commit
437: IF FND_API.to_Boolean( p_commit )
438: THEN
439: COMMIT WORK;
440: END IF;

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

445:
446: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
447: END IF;
448:
449: -- Standard call to get message count and if count is 1, get message info.
450: FND_MSG_PUB.Count_And_Get
451: (p_count => x_msg_count,
452: p_data => x_msg_data
453: );

Line 463: -- Standard call to get message count and if count=1, get the message

459:
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO UPDATE_Venue_Rates_PVT;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,
467: p_data => x_msg_data

Line 473: -- Standard call to get message count and if count=1, get the message

469:
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: ROLLBACK TO UPDATE_Venue_Rates_PVT;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: -- Standard call to get message count and if count=1, get the message
474: FND_MSG_PUB.Count_And_Get (
475: p_encoded => FND_API.G_FALSE,
476: p_count => x_msg_count,
477: p_data => x_msg_data

Line 487: -- Standard call to get message count and if count=1, get the message

483: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
486: END IF;
487: -- Standard call to get message count and if count=1, get the message
488: FND_MSG_PUB.Count_And_Get (
489: p_encoded => FND_API.G_FALSE,
490: p_count => x_msg_count,
491: p_data => x_msg_data

Line 514: -- Standard Start of API savepoint

510: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
511: l_object_version_number NUMBER;
512:
513: BEGIN
514: -- Standard Start of API savepoint
515: SAVEPOINT DELETE_Venue_Rates_PVT;
516:
517: -- Standard call to check for call compatibility.
518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

513: BEGIN
514: -- Standard Start of API savepoint
515: SAVEPOINT DELETE_Venue_Rates_PVT;
516:
517: -- Standard call to check for call compatibility.
518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
519: p_api_version_number,
520: l_api_name,
521: G_PKG_NAME)

Line 558: -- Standard check for p_commit

554: --
555: -- End of API body
556: --
557:
558: -- Standard check for p_commit
559: IF FND_API.to_Boolean( p_commit )
560: THEN
561: COMMIT WORK;
562: END IF;

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

567:
568: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
569: END IF;
570:
571: -- Standard call to get message count and if count is 1, get message info.
572: FND_MSG_PUB.Count_And_Get
573: (p_count => x_msg_count,
574: p_data => x_msg_data
575: );

Line 585: -- Standard call to get message count and if count=1, get the message

581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: ROLLBACK TO DELETE_Venue_Rates_PVT;
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => x_msg_data

Line 595: -- Standard call to get message count and if count=1, get the message

591:
592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
593: ROLLBACK TO DELETE_Venue_Rates_PVT;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: -- Standard call to get message count and if count=1, get the message
596: FND_MSG_PUB.Count_And_Get (
597: p_encoded => FND_API.G_FALSE,
598: p_count => x_msg_count,
599: p_data => x_msg_data

Line 609: -- Standard call to get message count and if count=1, get the message

605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
606: THEN
607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
608: END IF;
609: -- Standard call to get message count and if count=1, get the message
610: FND_MSG_PUB.Count_And_Get (
611: p_encoded => FND_API.G_FALSE,
612: p_count => x_msg_count,
613: p_data => x_msg_data

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

655: THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658:
659: -- Standard call to check for call compatibility.
660: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
661: p_api_version_number,
662: l_api_name,
663: G_PKG_NAME)

Line 715: -- Standard call to get message count and if count=1, get the message

711:
712: WHEN FND_API.G_EXC_ERROR THEN
713: ROLLBACK TO LOCK_Venue_Rates_PVT;
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: -- Standard call to get message count and if count=1, get the message
716: FND_MSG_PUB.Count_And_Get (
717: p_encoded => FND_API.G_FALSE,
718: p_count => x_msg_count,
719: p_data => x_msg_data

Line 725: -- Standard call to get message count and if count=1, get the message

721:
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: ROLLBACK TO LOCK_Venue_Rates_PVT;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
725: -- Standard call to get message count and if count=1, get the message
726: FND_MSG_PUB.Count_And_Get (
727: p_encoded => FND_API.G_FALSE,
728: p_count => x_msg_count,
729: p_data => x_msg_data

Line 739: -- Standard call to get message count and if count=1, get the message

735: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
736: THEN
737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
738: END IF;
739: -- Standard call to get message count and if count=1, get the message
740: FND_MSG_PUB.Count_And_Get (
741: p_encoded => FND_API.G_FALSE,
742: p_count => x_msg_count,
743: p_data => x_msg_data

Line 1275: -- Standard Start of API savepoint

1271: l_object_version_number NUMBER;
1272: l_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type;
1273:
1274: BEGIN
1275: -- Standard Start of API savepoint
1276: SAVEPOINT VALIDATE_Venue_Rates_;
1277:
1278: -- Standard call to check for call compatibility.
1279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1274: BEGIN
1275: -- Standard Start of API savepoint
1276: SAVEPOINT VALIDATE_Venue_Rates_;
1277:
1278: -- Standard call to check for call compatibility.
1279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1280: p_api_version_number,
1281: l_api_name,
1282: G_PKG_NAME)

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

1341:
1342: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1343: END IF;
1344:
1345: -- Standard call to get message count and if count is 1, get message info.
1346: FND_MSG_PUB.Count_And_Get
1347: (p_count => x_msg_count,
1348: p_data => x_msg_data
1349: );

Line 1359: -- Standard call to get message count and if count=1, get the message

1355:
1356: WHEN FND_API.G_EXC_ERROR THEN
1357: ROLLBACK TO VALIDATE_Venue_Rates_;
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: -- Standard call to get message count and if count=1, get the message
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => FND_API.G_FALSE,
1362: p_count => x_msg_count,
1363: p_data => x_msg_data

Line 1369: -- Standard call to get message count and if count=1, get the message

1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO VALIDATE_Venue_Rates_;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: -- Standard call to get message count and if count=1, get the message
1370: FND_MSG_PUB.Count_And_Get (
1371: p_encoded => FND_API.G_FALSE,
1372: p_count => x_msg_count,
1373: p_data => x_msg_data

Line 1383: -- Standard call to get message count and if count=1, get the message

1379: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1380: THEN
1381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1382: END IF;
1383: -- Standard call to get message count and if count=1, get the message
1384: FND_MSG_PUB.Count_And_Get (
1385: p_encoded => FND_API.G_FALSE,
1386: p_count => x_msg_count,
1387: p_data => x_msg_data

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

1417: IF (AMS_DEBUG_HIGH_ON) THEN
1418:
1419: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1420: END IF;
1421: -- Standard call to get message count and if count is 1, get message info.
1422: FND_MSG_PUB.Count_And_Get
1423: (p_count => x_msg_count,
1424: p_data => x_msg_data
1425: );