DBA Data[Home] [Help]

APPS.AMS_PRETTY_URL_PVT dependencies on STANDARD

Line 204: -- Standard Start of API savepoint

200: FROM AMS_PRETTY_URL
201: WHERE PRETTY_URL_ID = l_id;
202:
203: BEGIN
204: -- Standard Start of API savepoint
205: SAVEPOINT CREATE_Pretty_Url_PVT;
206:
207: -- Standard call to check for call compatibility.
208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

203: BEGIN
204: -- Standard Start of API savepoint
205: SAVEPOINT CREATE_Pretty_Url_PVT;
206:
207: -- Standard call to check for call compatibility.
208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
209: p_api_version_number,
210: l_api_name,
211: G_PKG_NAME)

Line 298: -- Standard check for p_commit

294: --
295: -- End of API body
296: --
297:
298: -- Standard check for p_commit
299: IF FND_API.to_Boolean( p_commit )
300: THEN
301: COMMIT WORK;
302: END IF;

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

304:
305: -- Debug Message
306: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
307:
308: -- Standard call to get message count and if count is 1, get message info.
309: FND_MSG_PUB.Count_And_Get
310: (p_count => x_msg_count,
311: p_data => x_msg_data
312: );

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

318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO CREATE_Pretty_Url_PVT;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: -- Standard call to get message count and if count=1, get the message
323: FND_MSG_PUB.Count_And_Get (
324: p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count,
326: p_data => x_msg_data

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

328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: ROLLBACK TO CREATE_Pretty_Url_PVT;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: FND_MSG_PUB.Count_And_Get (
334: p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count,
336: p_data => x_msg_data

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

342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
345: END IF;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (
348: p_encoded => FND_API.G_FALSE,
349: p_count => x_msg_count,
350: p_data => x_msg_data

Line 384: -- Standard Start of API savepoint

380: l_tar_pretty_url_rec AMS_Pretty_Url_PVT.pretty_url_rec_type := P_pretty_url_rec;
381: l_rowid ROWID;
382:
383: BEGIN
384: -- Standard Start of API savepoint
385: SAVEPOINT UPDATE_Pretty_Url_PVT;
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 UPDATE_Pretty_Url_PVT;
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 481: -- Standard check for p_commit

477: --
478: -- End of API body.
479: --
480:
481: -- Standard check for p_commit
482: IF FND_API.to_Boolean( p_commit )
483: THEN
484: COMMIT WORK;
485: END IF;

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

487:
488: -- Debug Message
489: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
490:
491: -- Standard call to get message count and if count is 1, get message info.
492: FND_MSG_PUB.Count_And_Get
493: (p_count => x_msg_count,
494: p_data => x_msg_data
495: );

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

501:
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO UPDATE_Pretty_Url_PVT;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: -- Standard call to get message count and if count=1, get the message
506: FND_MSG_PUB.Count_And_Get (
507: p_encoded => FND_API.G_FALSE,
508: p_count => x_msg_count,
509: p_data => x_msg_data

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

511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO UPDATE_Pretty_Url_PVT;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data

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

525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data

Line 556: -- Standard Start of API savepoint

552: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
553: l_object_version_number NUMBER;
554:
555: BEGIN
556: -- Standard Start of API savepoint
557: SAVEPOINT DELETE_Pretty_Url_PVT;
558:
559: -- Standard call to check for call compatibility.
560: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

555: BEGIN
556: -- Standard Start of API savepoint
557: SAVEPOINT DELETE_Pretty_Url_PVT;
558:
559: -- Standard call to check for call compatibility.
560: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
561: p_api_version_number,
562: l_api_name,
563: G_PKG_NAME)

Line 594: -- Standard check for p_commit

590: --
591: -- End of API body
592: --
593:
594: -- Standard check for p_commit
595: IF FND_API.to_Boolean( p_commit )
596: THEN
597: COMMIT WORK;
598: END IF;

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

600:
601: -- Debug Message
602: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
603:
604: -- Standard call to get message count and if count is 1, get message info.
605: FND_MSG_PUB.Count_And_Get
606: (p_count => x_msg_count,
607: p_data => x_msg_data
608: );

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

614:
615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO DELETE_Pretty_Url_PVT;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: -- Standard call to get message count and if count=1, get the message
619: FND_MSG_PUB.Count_And_Get (
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data

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

624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: ROLLBACK TO DELETE_Pretty_Url_PVT;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data

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

638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data

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

685: THEN
686: FND_MSG_PUB.initialize;
687: END IF;
688:
689: -- Standard call to check for call compatibility.
690: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
691: p_api_version_number,
692: l_api_name,
693: G_PKG_NAME)

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

732:
733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO LOCK_Pretty_Url_PVT;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: -- Standard call to get message count and if count=1, get the message
737: FND_MSG_PUB.Count_And_Get (
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data

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

742:
743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
744: ROLLBACK TO LOCK_Pretty_Url_PVT;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data

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

756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
759: END IF;
760: -- Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_msg_count,
764: p_data => x_msg_data

Line 1046: -- Standard Start of API savepoint

1042: l_object_version_number NUMBER;
1043: l_pretty_url_rec AMS_Pretty_Url_PVT.pretty_url_rec_type;
1044:
1045: BEGIN
1046: -- Standard Start of API savepoint
1047: SAVEPOINT VALIDATE_Pretty_Url_;
1048:
1049: -- Standard call to check for call compatibility.
1050: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1045: BEGIN
1046: -- Standard Start of API savepoint
1047: SAVEPOINT VALIDATE_Pretty_Url_;
1048:
1049: -- Standard call to check for call compatibility.
1050: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1051: p_api_version_number,
1052: l_api_name,
1053: G_PKG_NAME)

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

1106:
1107: -- Debug Message
1108: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1109:
1110: -- Standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get
1112: (p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );

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

1120:
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: ROLLBACK TO VALIDATE_Pretty_Url_;
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: -- Standard call to get message count and if count=1, get the message
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data

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

1130:
1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1132: ROLLBACK TO VALIDATE_Pretty_Url_;
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data

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

1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data

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

1179: -- x_return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: -- Debug Message
1182: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1183: -- Standard call to get message count and if count is 1, get message info.
1184: FND_MSG_PUB.Count_And_Get
1185: (p_count => x_msg_count,
1186: p_data => x_msg_data
1187: );