[Home] [Help]
59: -- x_return_status OUT VARCHAR2
60: -- x_msg_count OUT NUMBER
61: -- x_msg_data OUT VARCHAR2
62: -- Version : Current version 1.0
63: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
64: -- and basic operation, developer must manually add parameters and business logic as necessary.
65: --
66: -- History
67: --
104: SELECT 1
105: FROM PV_PG_INVITE_HEADERS_B
106: WHERE INVITE_HEADER_ID = l_id;
107: BEGIN
108: -- Standard Start of API savepoint
109: SAVEPOINT create_invite_headers_pvt;
110:
111: -- Standard call to check for call compatibility.
112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
107: BEGIN
108: -- Standard Start of API savepoint
109: SAVEPOINT create_invite_headers_pvt;
110:
111: -- Standard call to check for call compatibility.
112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
113: p_api_version_number,
114: l_api_name,
115: G_PKG_NAME)
231: --
232: -- End of API body
233: --
234: --DBMS_OUTPUT.PUT_LINE('Private API: End of API body');
235: -- Standard check for p_commit
236: IF FND_API.to_Boolean( p_commit )
237: THEN
238: COMMIT WORK;
239: END IF;
245: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
246: END IF;
247:
248:
249: -- Standard call to get message count and if count is 1, get message info.
250: FND_MSG_PUB.Count_And_Get
251: (p_count => x_msg_count,
252: p_data => x_msg_data
253: );
259:
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO CREATE_Invite_Headers_PVT;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: -- Standard call to get message count and if count=1, get the message
264: FND_MSG_PUB.Count_And_Get (
265: p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data
269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: ROLLBACK TO CREATE_Invite_Headers_PVT;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
283: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
284: THEN
285: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
286: END IF;
287: -- Standard call to get message count and if count=1, get the message
288: FND_MSG_PUB.Count_And_Get (
289: p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => x_msg_data
315: -- x_return_status OUT VARCHAR2
316: -- x_msg_count OUT NUMBER
317: -- x_msg_data OUT VARCHAR2
318: -- Version : Current version 1.0
319: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
320: -- and basic operation, developer must manually add parameters and business logic as necessary.
321: --
322: -- History
323: --
358: l_tar_invite_headers_rec invite_headers_rec_type := P_invite_headers_rec;
359: l_rowid ROWID;
360:
361: BEGIN
362: -- Standard Start of API savepoint
363: SAVEPOINT update_invite_headers_pvt;
364:
365: -- Standard call to check for call compatibility.
366: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
361: BEGIN
362: -- Standard Start of API savepoint
363: SAVEPOINT update_invite_headers_pvt;
364:
365: -- Standard call to check for call compatibility.
366: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
367: p_api_version_number,
368: l_api_name,
369: G_PKG_NAME)
482: --
483: -- End of API body.
484: --
485:
486: -- Standard check for p_commit
487: IF FND_API.to_Boolean( p_commit )
488: THEN
489: COMMIT WORK;
490: END IF;
496: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
497: END IF;
498:
499:
500: -- Standard call to get message count and if count is 1, get message info.
501: FND_MSG_PUB.Count_And_Get
502: (p_count => x_msg_count,
503: p_data => x_msg_data
504: );
510:
511: WHEN FND_API.G_EXC_ERROR THEN
512: ROLLBACK TO UPDATE_Invite_Headers_PVT;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: -- Standard call to get message count and if count=1, get the message
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
518: p_data => x_msg_data
520:
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO UPDATE_Invite_Headers_PVT;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: -- Standard call to get message count and if count=1, get the message
525: FND_MSG_PUB.Count_And_Get (
526: p_encoded => FND_API.G_FALSE,
527: p_count => x_msg_count,
528: p_data => x_msg_data
534: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
537: END IF;
538: -- Standard call to get message count and if count=1, get the message
539: FND_MSG_PUB.Count_And_Get (
540: p_encoded => FND_API.G_FALSE,
541: p_count => x_msg_count,
542: p_data => x_msg_data
567: -- x_return_status OUT VARCHAR2
568: -- x_msg_count OUT NUMBER
569: -- x_msg_data OUT VARCHAR2
570: -- Version : Current version 1.0
571: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
572: -- and basic operation, developer must manually add parameters and business logic as necessary.
573: --
574: -- History
575: --
595: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
596: l_object_version_number NUMBER;
597:
598: BEGIN
599: -- Standard Start of API savepoint
600: SAVEPOINT delete_invite_headers_pvt;
601:
602: -- Standard call to check for call compatibility.
603: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
598: BEGIN
599: -- Standard Start of API savepoint
600: SAVEPOINT delete_invite_headers_pvt;
601:
602: -- Standard call to check for call compatibility.
603: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
604: p_api_version_number,
605: l_api_name,
606: G_PKG_NAME)
644: --
645: -- End of API body
646: --
647:
648: -- Standard check for p_commit
649: IF FND_API.to_Boolean( p_commit )
650: THEN
651: COMMIT WORK;
652: END IF;
658: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
659: END IF;
660:
661:
662: -- Standard call to get message count and if count is 1, get message info.
663: FND_MSG_PUB.Count_And_Get
664: (p_count => x_msg_count,
665: p_data => x_msg_data
666: );
672:
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO DELETE_Invite_Headers_PVT;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: ROLLBACK TO DELETE_Invite_Headers_PVT;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: -- Standard call to get message count and if count=1, get the message
687: FND_MSG_PUB.Count_And_Get (
688: p_encoded => FND_API.G_FALSE,
689: p_count => x_msg_count,
690: p_data => x_msg_data
696: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
697: THEN
698: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
699: END IF;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data
730: -- x_return_status OUT VARCHAR2
731: -- x_msg_count OUT NUMBER
732: -- x_msg_data OUT VARCHAR2
733: -- Version : Current version 1.0
734: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
735: -- and basic operation, developer must manually add parameters and business logic as necessary.
736: --
737: -- History
738: --
775: END IF;
776:
777:
778:
779: -- Standard call to check for call compatibility.
780: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
781: p_api_version_number,
782: l_api_name,
783: G_PKG_NAME)
812:
813: WHEN FND_API.G_EXC_ERROR THEN
814: ROLLBACK TO LOCK_Invite_Headers_PVT;
815: x_return_status := FND_API.G_RET_STS_ERROR;
816: -- Standard call to get message count and if count=1, get the message
817: FND_MSG_PUB.Count_And_Get (
818: p_encoded => FND_API.G_FALSE,
819: p_count => x_msg_count,
820: p_data => x_msg_data
822:
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO LOCK_Invite_Headers_PVT;
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: -- Standard call to get message count and if count=1, get the message
827: FND_MSG_PUB.Count_And_Get (
828: p_encoded => FND_API.G_FALSE,
829: p_count => x_msg_count,
830: p_data => x_msg_data
836: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
837: THEN
838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
839: END IF;
840: -- Standard call to get message count and if count=1, get the message
841: FND_MSG_PUB.Count_And_Get (
842: p_encoded => FND_API.G_FALSE,
843: p_count => x_msg_count,
844: p_data => x_msg_data
1154: l_invite_headers_rec invite_headers_rec_type;
1155: l_invite_headers_rec_out invite_headers_rec_type;
1156:
1157: BEGIN
1158: -- Standard Start of API savepoint
1159: SAVEPOINT validate_invite_headers_;
1160:
1161: -- Standard call to check for call compatibility.
1162: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1157: BEGIN
1158: -- Standard Start of API savepoint
1159: SAVEPOINT validate_invite_headers_;
1160:
1161: -- Standard call to check for call compatibility.
1162: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1163: p_api_version_number,
1164: l_api_name,
1165: G_PKG_NAME)
1237: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1238: END IF;
1239:
1240:
1241: -- Standard call to get message count and if count is 1, get message info.
1242: FND_MSG_PUB.Count_And_Get
1243: (p_count => x_msg_count,
1244: p_data => x_msg_data
1245: );
1251:
1252: WHEN FND_API.G_EXC_ERROR THEN
1253: ROLLBACK TO VALIDATE_Invite_Headers_;
1254: x_return_status := FND_API.G_RET_STS_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
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: ROLLBACK TO VALIDATE_Invite_Headers_;
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: -- Standard call to get message count and if count=1, get the message
1266: FND_MSG_PUB.Count_And_Get (
1267: p_encoded => FND_API.G_FALSE,
1268: p_count => x_msg_count,
1269: p_data => x_msg_data
1275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1276: THEN
1277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1278: END IF;
1279: -- Standard call to get message count and if count=1, get the message
1280: FND_MSG_PUB.Count_And_Get (
1281: p_encoded => FND_API.G_FALSE,
1282: p_count => x_msg_count,
1283: p_data => x_msg_data
1315: IF (PV_DEBUG_HIGH_ON) THEN
1316:
1317: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1318: END IF;
1319: -- Standard call to get message count and if count is 1, get message info.
1320: FND_MSG_PUB.Count_And_Get
1321: (p_count => x_msg_count,
1322: p_data => x_msg_data
1323: );