[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_PG_ENRQ_INIT_SOURCES
103: WHERE initiation_source_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_pg_init_src_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_pg_init_src_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)
215: --
216: -- End of API body
217: --
218:
219: -- Standard check for p_commit
220: IF Fnd_Api.to_Boolean( p_commit )
221: THEN
222: COMMIT WORK;
223: END IF;
229: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
230: END IF;
231:
232:
233: -- Standard call to get message count and if count is 1, get message info.
234: Fnd_Msg_Pub.Count_And_Get
235: (p_count => x_msg_count,
236: p_data => x_msg_data
237: );
243:
244: WHEN Fnd_Api.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Pg_Init_Src_PVT;
246: x_return_status := Fnd_Api.G_RET_STS_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: Fnd_Msg_Pub.Count_And_Get (
249: p_encoded => Fnd_Api.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
253:
254: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK TO CREATE_Pg_Init_Src_PVT;
256: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
257: -- Standard call to get message count and if count=1, get the message
258: Fnd_Msg_Pub.Count_And_Get (
259: p_encoded => Fnd_Api.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
267: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: Fnd_Msg_Pub.Count_And_Get (
273: p_encoded => Fnd_Api.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
299: -- x_return_status OUT VARCHAR2
300: -- x_msg_count OUT NUMBER
301: -- x_msg_data OUT VARCHAR2
302: -- Version : Current version 1.0
303: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
304: -- and basic operation, developer must manually add parameters and business logic as necessary.
305: --
306: -- History
307: --
342: l_tar_enrq_init_sources_rec enrq_init_sources_rec_type := P_enrq_init_sources_rec;
343: l_rowid ROWID;
344:
345: BEGIN
346: -- Standard Start of API savepoint
347: SAVEPOINT update_pg_init_src_pvt;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
345: BEGIN
346: -- Standard Start of API savepoint
347: SAVEPOINT update_pg_init_src_pvt;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
351: p_api_version_number,
352: l_api_name,
353: G_PKG_NAME)
460: --
461: -- End of API body.
462: --
463:
464: -- Standard check for p_commit
465: IF Fnd_Api.to_Boolean( p_commit )
466: THEN
467: COMMIT WORK;
468: END IF;
474: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
475: END IF;
476:
477:
478: -- Standard call to get message count and if count is 1, get message info.
479: Fnd_Msg_Pub.Count_And_Get
480: (p_count => x_msg_count,
481: p_data => x_msg_data
482: );
488:
489: WHEN Fnd_Api.G_EXC_ERROR THEN
490: ROLLBACK TO UPDATE_Pg_Init_Src_PVT;
491: x_return_status := Fnd_Api.G_RET_STS_ERROR;
492: -- Standard call to get message count and if count=1, get the message
493: Fnd_Msg_Pub.Count_And_Get (
494: p_encoded => Fnd_Api.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data
498:
499: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO UPDATE_Pg_Init_Src_PVT;
501: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
502: -- Standard call to get message count and if count=1, get the message
503: Fnd_Msg_Pub.Count_And_Get (
504: p_encoded => Fnd_Api.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data
512: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
513: THEN
514: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
515: END IF;
516: -- Standard call to get message count and if count=1, get the message
517: Fnd_Msg_Pub.Count_And_Get (
518: p_encoded => Fnd_Api.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data
545: -- x_return_status OUT VARCHAR2
546: -- x_msg_count OUT NUMBER
547: -- x_msg_data OUT VARCHAR2
548: -- Version : Current version 1.0
549: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
550: -- and basic operation, developer must manually add parameters and business logic as necessary.
551: --
552: -- History
553: --
573: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
574: l_object_version_number NUMBER;
575:
576: BEGIN
577: -- Standard Start of API savepoint
578: SAVEPOINT delete_pg_init_src_pvt;
579:
580: -- Standard call to check for call compatibility.
581: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
576: BEGIN
577: -- Standard Start of API savepoint
578: SAVEPOINT delete_pg_init_src_pvt;
579:
580: -- Standard call to check for call compatibility.
581: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
582: p_api_version_number,
583: l_api_name,
584: G_PKG_NAME)
622: --
623: -- End of API body
624: --
625:
626: -- Standard check for p_commit
627: IF Fnd_Api.to_Boolean( p_commit )
628: THEN
629: COMMIT WORK;
630: END IF;
636: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
637: END IF;
638:
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: Fnd_Msg_Pub.Count_And_Get
642: (p_count => x_msg_count,
643: p_data => x_msg_data
644: );
650:
651: WHEN Fnd_Api.G_EXC_ERROR THEN
652: ROLLBACK TO DELETE_Pg_Init_Src_PVT;
653: x_return_status := Fnd_Api.G_RET_STS_ERROR;
654: -- Standard call to get message count and if count=1, get the message
655: Fnd_Msg_Pub.Count_And_Get (
656: p_encoded => Fnd_Api.G_FALSE,
657: p_count => x_msg_count,
658: p_data => x_msg_data
660:
661: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
662: ROLLBACK TO DELETE_Pg_Init_Src_PVT;
663: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
664: -- Standard call to get message count and if count=1, get the message
665: Fnd_Msg_Pub.Count_And_Get (
666: p_encoded => Fnd_Api.G_FALSE,
667: p_count => x_msg_count,
668: p_data => x_msg_data
674: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
675: THEN
676: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
677: END IF;
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
708: -- x_return_status OUT VARCHAR2
709: -- x_msg_count OUT NUMBER
710: -- x_msg_data OUT VARCHAR2
711: -- Version : Current version 1.0
712: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
713: -- and basic operation, developer must manually add parameters and business logic as necessary.
714: --
715: -- History
716: --
753: END IF;
754:
755:
756:
757: -- Standard call to check for call compatibility.
758: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
759: p_api_version_number,
760: l_api_name,
761: G_PKG_NAME)
790:
791: WHEN Fnd_Api.G_EXC_ERROR THEN
792: ROLLBACK TO LOCK_Pg_Enrq_Init_Sources_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
800:
801: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO LOCK_Pg_Enrq_Init_Sources_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
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
1111: l_enrq_init_sources_rec enrq_init_sources_rec_type;
1112: l_enrq_init_sources_rec_out enrq_init_sources_rec_type;
1113:
1114: BEGIN
1115: -- Standard Start of API savepoint
1116: SAVEPOINT Validate_Pg_Init_Src_;
1117:
1118: -- Standard call to check for call compatibility.
1119: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1114: BEGIN
1115: -- Standard Start of API savepoint
1116: SAVEPOINT Validate_Pg_Init_Src_;
1117:
1118: -- Standard call to check for call compatibility.
1119: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1120: p_api_version_number,
1121: l_api_name,
1122: G_PKG_NAME)
1194: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1195: END IF;
1196:
1197:
1198: -- Standard call to get message count and if count is 1, get message info.
1199: Fnd_Msg_Pub.Count_And_Get
1200: (p_count => x_msg_count,
1201: p_data => x_msg_data
1202: );
1208:
1209: WHEN Fnd_Api.G_EXC_ERROR THEN
1210: ROLLBACK TO Validate_Pg_Init_Src_;
1211: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1212: -- Standard call to get message count and if count=1, get the message
1213: Fnd_Msg_Pub.Count_And_Get (
1214: p_encoded => Fnd_Api.G_FALSE,
1215: p_count => x_msg_count,
1216: p_data => x_msg_data
1218:
1219: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1220: ROLLBACK TO Validate_Pg_Init_Src_;
1221: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: Fnd_Msg_Pub.Count_And_Get (
1224: p_encoded => Fnd_Api.G_FALSE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data
1232: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1233: THEN
1234: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1235: END IF;
1236: -- Standard call to get message count and if count=1, get the message
1237: Fnd_Msg_Pub.Count_And_Get (
1238: p_encoded => Fnd_Api.G_FALSE,
1239: p_count => x_msg_count,
1240: p_data => x_msg_data
1272: IF (PV_DEBUG_HIGH_ON) THEN
1273:
1274: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');
1275: END IF;
1276: -- Standard call to get message count and if count is 1, get message info.
1277: Fnd_Msg_Pub.Count_And_Get
1278: (p_count => x_msg_count,
1279: p_data => x_msg_data
1280: );