DBA Data[Home] [Help]

APPS.AMS_PS_POSTING_PVT dependencies on STANDARD

Line 46: -- Standard Start of API savepoint

42: FROM AMS_IBA_PS_POSTINGS_B
43: WHERE POSTING_ID = l_id;
44:
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_Ps_Posting_PVT;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_Ps_Posting_PVT;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)

Line 190: -- Standard check for p_commit

186: -- End of API body
187: --
188: x_posting_id := l_posting_id;
189:
190: -- Standard check for p_commit
191: IF FND_API.to_Boolean( p_commit )
192: THEN
193: COMMIT WORK;
194: END IF;

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

198:
199: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
200: END IF;
201:
202: -- Standard call to get message count and if count is 1, get message info.
203: FND_MSG_PUB.Count_And_Get
204: (p_count => x_msg_count,
205: p_data => x_msg_data
206: );

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

212:
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO CREATE_Ps_Posting_PVT;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data

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

222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO CREATE_Ps_Posting_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data

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

236: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
239: END IF;
240: -- Standard call to get message count and if count=1, get the message
241: FND_MSG_PUB.Count_And_Get (
242: p_encoded => FND_API.G_FALSE,
243: p_count => x_msg_count,
244: p_data => x_msg_data

Line 272: -- Standard Start of API savepoint

268: FROM AMS_IBA_PS_POSTINGS_B
269: WHERE posting_id = post_id;
270:
271: BEGIN
272: -- Standard Start of API savepoint
273: SAVEPOINT UPDATE_Ps_Posting_PVT;
274:
275: -- Standard call to check for call compatibility.
276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

271: BEGIN
272: -- Standard Start of API savepoint
273: SAVEPOINT UPDATE_Ps_Posting_PVT;
274:
275: -- Standard call to check for call compatibility.
276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
277: p_api_version_number,
278: l_api_name,
279: G_PKG_NAME)

Line 450: -- Standard check for p_commit

446: IF (AMS_DEBUG_HIGH_ON) THEN
447: AMS_UTILITY_PVT.debug_message('Private API: Updated TL');
448: END IF;
449:
450: -- Standard check for p_commit
451: IF FND_API.to_Boolean( p_commit )
452: THEN
453: COMMIT WORK;
454: END IF;

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

457: IF (AMS_DEBUG_HIGH_ON) THEN
458: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
459: END IF;
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get
463: (p_count => x_msg_count,
464: p_data => x_msg_data);
465:

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

471:
472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO UPDATE_Ps_Posting_PVT;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE,
478: p_count => x_msg_count,
479: p_data => x_msg_data

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

481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO UPDATE_Ps_Posting_PVT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data

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

495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data

Line 544: -- Standard Start of API savepoint

540: FROM AMS_IBA_PS_RULEGRPS_B
541: where posting_id = post_id;
542:
543: BEGIN
544: -- Standard Start of API savepoint
545: SAVEPOINT DELETE_Ps_Posting_PVT;
546:
547: -- Standard call to check for call compatibility.
548: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

543: BEGIN
544: -- Standard Start of API savepoint
545: SAVEPOINT DELETE_Ps_Posting_PVT;
546:
547: -- Standard call to check for call compatibility.
548: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
549: p_api_version_number,
550: l_api_name,
551: G_PKG_NAME)

Line 641: -- Standard check for p_commit

637:
638: -- End of API body
639: --
640:
641: -- Standard check for p_commit
642: IF FND_API.to_Boolean( p_commit )
643: THEN
644: COMMIT;
645: END IF;

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

650:
651: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
652: END IF;
653:
654: -- Standard call to get message count and if count is 1, get message info.
655: FND_MSG_PUB.Count_And_Get
656: (p_count => x_msg_count,
657: p_data => x_msg_data
658: );

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

664:
665: WHEN FND_API.G_EXC_ERROR THEN
666: ROLLBACK TO DELETE_Ps_Posting_PVT;
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: -- Standard call to get message count and if count=1, get the message
669: FND_MSG_PUB.Count_And_Get (
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_msg_count,
672: p_data => x_msg_data

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

674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO DELETE_Ps_Posting_PVT;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: -- Standard call to get message count and if count=1, get the message
679: FND_MSG_PUB.Count_And_Get (
680: p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count,
682: p_data => x_msg_data

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

688: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
691: END IF;
692: -- Standard call to get message count and if count=1, get the message
693: FND_MSG_PUB.Count_And_Get (
694: p_encoded => FND_API.G_FALSE,
695: p_count => x_msg_count,
696: p_data => x_msg_data

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

738: THEN
739: FND_MSG_PUB.initialize;
740: END IF;
741:
742: -- Standard call to check for call compatibility.
743: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
744: p_api_version_number,
745: l_api_name,
746: G_PKG_NAME)

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

790:
791: WHEN FND_API.G_EXC_ERROR THEN
792: ROLLBACK TO LOCK_Ps_Posting_PVT;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: -- Standard call to get message count and if count=1, get the message
795: FND_MSG_PUB.Count_And_Get (
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_msg_count,
798: p_data => x_msg_data

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

800:
801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO LOCK_Ps_Posting_PVT;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: -- Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data

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

814: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
817: END IF;
818: -- Standard call to get message count and if count=1, get the message
819: FND_MSG_PUB.Count_And_Get (
820: p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
822: p_data => x_msg_data

Line 925: -- Standard Start of API savepoint

921: l_object_version_number NUMBER;
922: l_ps_posting_rec AMS_Ps_Posting_PVT.ps_posting_rec_type;
923:
924: BEGIN
925: -- Standard Start of API savepoint
926: SAVEPOINT VALIDATE_Ps_Posting_;
927:
928: IF (AMS_DEBUG_HIGH_ON) THEN
929:

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

932: AMS_Utility_PVT.debug_message('In '||L_API_NAME);
933:
934: END IF;
935:
936: -- Standard call to check for call compatibility.
937: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
938: p_api_version_number,
939: l_api_name,
940: G_PKG_NAME)

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

984:
985: WHEN FND_API.G_EXC_ERROR THEN
986: ROLLBACK TO VALIDATE_Ps_Posting_;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: -- Standard call to get message count and if count=1, get the message
989: FND_MSG_PUB.Count_And_Get (
990: p_encoded => FND_API.G_FALSE,
991: p_count => x_msg_count,
992: p_data => x_msg_data

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

994:
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO VALIDATE_Ps_Posting_;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: -- Standard call to get message count and if count=1, get the message
999: FND_MSG_PUB.Count_And_Get (
1000: p_encoded => FND_API.G_FALSE,
1001: p_count => x_msg_count,
1002: p_data => x_msg_data

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

1008: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1009: THEN
1010: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1011: END IF;
1012: -- Standard call to get message count and if count=1, get the message
1013: FND_MSG_PUB.Count_And_Get (
1014: p_encoded => FND_API.G_FALSE,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data

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

1045: IF (AMS_DEBUG_HIGH_ON) THEN
1046:
1047: AMS_UTILITY_PVT.debug_message('Private API: Validate_ps_Posting_rec');
1048: END IF;
1049: -- Standard call to get message count and if count is 1, get message info.
1050: FND_MSG_PUB.Count_And_Get
1051: (p_count => x_msg_count,
1052: p_data => x_msg_data
1053: );