[Home] [Help]
56: -- x_return_status OUT VARCHAR2
57: -- x_msg_count OUT NUMBER
58: -- x_msg_data OUT VARCHAR2
59: -- Version : Current version 1.0
60: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
61: -- and basic operation, developer must manually add parameters and business logic as necessary.
62: --
63: -- History
64: --
101: SELECT 1
102: FROM PV_GE_PARTY_NOTIFICATIONS
103: WHERE party_notification_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_ge_party_notif_pvt;
107:
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_ge_party_notif_pvt;
107:
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
110: p_api_version_number,
111: l_api_name,
112: G_PKG_NAME)
218: --
219: -- End of API body
220: --
221:
222: -- Standard check for p_commit
223: IF FND_API.to_Boolean( p_commit )
224: THEN
225: COMMIT WORK;
226: END IF;
232: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
233: END IF;
234:
235:
236: -- Standard call to get message count and if count is 1, get message info.
237: FND_MSG_PUB.Count_And_Get
238: (p_count => x_msg_count,
239: p_data => x_msg_data
240: );
246:
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO CREATE_Ge_Party_Notif_PVT;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data
256:
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO CREATE_Ge_Party_Notif_PVT;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: THEN
272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
273: END IF;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
302: -- x_return_status OUT VARCHAR2
303: -- x_msg_count OUT NUMBER
304: -- x_msg_data OUT VARCHAR2
305: -- Version : Current version 1.0
306: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
307: -- and basic operation, developer must manually add parameters and business logic as necessary.
308: --
309: -- History
310: --
345: l_tar_pgp_notif_rec pgp_notif_rec_type := P_pgp_notif_rec;
346: l_rowid ROWID;
347:
348: BEGIN
349: -- Standard Start of API savepoint
350: SAVEPOINT update_ge_party_notif_pvt;
351:
352: -- Standard call to check for call compatibility.
353: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
348: BEGIN
349: -- Standard Start of API savepoint
350: SAVEPOINT update_ge_party_notif_pvt;
351:
352: -- Standard call to check for call compatibility.
353: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
354: p_api_version_number,
355: l_api_name,
356: G_PKG_NAME)
466: --
467: -- End of API body.
468: --
469:
470: -- Standard check for p_commit
471: IF FND_API.to_Boolean( p_commit )
472: THEN
473: COMMIT WORK;
474: END IF;
480: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
481: END IF;
482:
483:
484: -- Standard call to get message count and if count is 1, get message info.
485: FND_MSG_PUB.Count_And_Get
486: (p_count => x_msg_count,
487: p_data => x_msg_data
488: );
494:
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO UPDATE_Ge_Party_Notif_PVT;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO UPDATE_Ge_Party_Notif_PVT;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: -- Standard call to get message count and if count=1, get the message
509: FND_MSG_PUB.Count_And_Get (
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
518: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
521: END IF;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data
551: -- x_return_status OUT VARCHAR2
552: -- x_msg_count OUT NUMBER
553: -- x_msg_data OUT VARCHAR2
554: -- Version : Current version 1.0
555: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
556: -- and basic operation, developer must manually add parameters and business logic as necessary.
557: --
558: -- History
559: --
579: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
580: l_object_version_number NUMBER;
581:
582: BEGIN
583: -- Standard Start of API savepoint
584: SAVEPOINT delete_ge_party_notif_pvt;
585:
586: -- Standard call to check for call compatibility.
587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
582: BEGIN
583: -- Standard Start of API savepoint
584: SAVEPOINT delete_ge_party_notif_pvt;
585:
586: -- Standard call to check for call compatibility.
587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
588: p_api_version_number,
589: l_api_name,
590: G_PKG_NAME)
628: --
629: -- End of API body
630: --
631:
632: -- Standard check for p_commit
633: IF FND_API.to_Boolean( p_commit )
634: THEN
635: COMMIT WORK;
636: END IF;
642: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
643: END IF;
644:
645:
646: -- Standard call to get message count and if count is 1, get message info.
647: FND_MSG_PUB.Count_And_Get
648: (p_count => x_msg_count,
649: p_data => x_msg_data
650: );
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO DELETE_Ge_Party_Notif_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: -- Standard call to get message count and if count=1, get the message
661: FND_MSG_PUB.Count_And_Get (
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO DELETE_Ge_Party_Notif_PVT;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: -- Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
714: -- x_return_status OUT VARCHAR2
715: -- x_msg_count OUT NUMBER
716: -- x_msg_data OUT VARCHAR2
717: -- Version : Current version 1.0
718: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
719: -- and basic operation, developer must manually add parameters and business logic as necessary.
720: --
721: -- History
722: --
759: END IF;
760:
761:
762:
763: -- Standard call to check for call compatibility.
764: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
765: p_api_version_number,
766: l_api_name,
767: G_PKG_NAME)
796:
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO LOCK_Ge_Party_Notif_PVT;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: -- Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
806:
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO LOCK_Ge_Party_Notif_PVT;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: -- Standard call to get message count and if count=1, get the message
811: FND_MSG_PUB.Count_And_Get (
812: p_encoded => FND_API.G_FALSE,
813: p_count => x_msg_count,
814: p_data => x_msg_data
820: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
1144: l_pgp_notif_rec pgp_notif_rec_type;
1145: l_pgp_notif_rec_out pgp_notif_rec_type;
1146:
1147: BEGIN
1148: -- Standard Start of API savepoint
1149: SAVEPOINT validate_ge_party_notif_;
1150:
1151: -- Standard call to check for call compatibility.
1152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1147: BEGIN
1148: -- Standard Start of API savepoint
1149: SAVEPOINT validate_ge_party_notif_;
1150:
1151: -- Standard call to check for call compatibility.
1152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1153: p_api_version_number,
1154: l_api_name,
1155: G_PKG_NAME)
1227: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1228: END IF;
1229:
1230:
1231: -- Standard call to get message count and if count is 1, get message info.
1232: FND_MSG_PUB.Count_And_Get
1233: (p_count => x_msg_count,
1234: p_data => x_msg_data
1235: );
1241:
1242: WHEN FND_API.G_EXC_ERROR THEN
1243: ROLLBACK TO VALIDATE_Ge_Party_Notif_;
1244: x_return_status := FND_API.G_RET_STS_ERROR;
1245: -- Standard call to get message count and if count=1, get the message
1246: FND_MSG_PUB.Count_And_Get (
1247: p_encoded => FND_API.G_FALSE,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data
1251:
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: ROLLBACK TO VALIDATE_Ge_Party_Notif_;
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: -- Standard call to get message count and if count=1, get the message
1256: FND_MSG_PUB.Count_And_Get (
1257: p_encoded => FND_API.G_FALSE,
1258: p_count => x_msg_count,
1259: p_data => x_msg_data
1265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1266: THEN
1267: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1268: END IF;
1269: -- Standard call to get message count and if count=1, get the message
1270: FND_MSG_PUB.Count_And_Get (
1271: p_encoded => FND_API.G_FALSE,
1272: p_count => x_msg_count,
1273: p_data => x_msg_data
1305: IF (PV_DEBUG_HIGH_ON) THEN
1306:
1307: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1308: END IF;
1309: -- Standard call to get message count and if count is 1, get message info.
1310: FND_MSG_PUB.Count_And_Get
1311: (p_count => x_msg_count,
1312: p_data => x_msg_data
1313: );