[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_MMBR_TRANSITIONS
103: WHERE mmbr_transition_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_mmbr_trans_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_mmbr_trans_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)
214: --
215: -- End of API body
216: --
217:
218: -- Standard check for p_commit
219: IF FND_API.to_Boolean( p_commit )
220: THEN
221: COMMIT WORK;
222: END IF;
228: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
229: END IF;
230:
231:
232: -- Standard call to get message count and if count is 1, get message info.
233: FND_MSG_PUB.Count_And_Get
234: (p_count => x_msg_count,
235: p_data => x_msg_data
236: );
242:
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: -- Standard call to get message count and if count=1, get the message
247: FND_MSG_PUB.Count_And_Get (
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data
266: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
267: THEN
268: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
269: END IF;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
298: -- x_return_status OUT VARCHAR2
299: -- x_msg_count OUT NUMBER
300: -- x_msg_data OUT VARCHAR2
301: -- Version : Current version 1.0
302: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
303: -- and basic operation, developer must manually add parameters and business logic as necessary.
304: --
305: -- History
306: --
341: l_tar_mmbr_tran_rec mmbr_tran_rec_type := P_mmbr_tran_rec;
342: l_rowid ROWID;
343:
344: BEGIN
345: -- Standard Start of API savepoint
346: SAVEPOINT update_mmbr_trans_pvt;
347:
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
344: BEGIN
345: -- Standard Start of API savepoint
346: SAVEPOINT update_mmbr_trans_pvt;
347:
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
350: p_api_version_number,
351: l_api_name,
352: G_PKG_NAME)
458: --
459: -- End of API body.
460: --
461:
462: -- Standard check for p_commit
463: IF FND_API.to_Boolean( p_commit )
464: THEN
465: COMMIT WORK;
466: END IF;
472: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
473: END IF;
474:
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get
478: (p_count => x_msg_count,
479: p_data => x_msg_data
480: );
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data
510: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;
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
543: -- x_return_status OUT VARCHAR2
544: -- x_msg_count OUT NUMBER
545: -- x_msg_data OUT VARCHAR2
546: -- Version : Current version 1.0
547: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
548: -- and basic operation, developer must manually add parameters and business logic as necessary.
549: --
550: -- History
551: --
571: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
572: l_object_version_number NUMBER;
573:
574: BEGIN
575: -- Standard Start of API savepoint
576: SAVEPOINT delete_mmbr_trans_pvt;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
574: BEGIN
575: -- Standard Start of API savepoint
576: SAVEPOINT delete_mmbr_trans_pvt;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
620: --
621: -- End of API body
622: --
623:
624: -- Standard check for p_commit
625: IF FND_API.to_Boolean( p_commit )
626: THEN
627: COMMIT WORK;
628: END IF;
634: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
635: END IF;
636:
637:
638: -- Standard call to get message count and if count is 1, get message info.
639: FND_MSG_PUB.Count_And_Get
640: (p_count => x_msg_count,
641: p_data => x_msg_data
642: );
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
658:
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data
672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;
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
706: -- x_return_status OUT VARCHAR2
707: -- x_msg_count OUT NUMBER
708: -- x_msg_data OUT VARCHAR2
709: -- Version : Current version 1.0
710: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
711: -- and basic operation, developer must manually add parameters and business logic as necessary.
712: --
713: -- History
714: --
751: END IF;
752:
753:
754:
755: -- Standard call to check for call compatibility.
756: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
757: p_api_version_number,
758: l_api_name,
759: G_PKG_NAME)
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
798:
799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
800: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: -- Standard call to get message count and if count=1, get the message
803: FND_MSG_PUB.Count_And_Get (
804: p_encoded => FND_API.G_FALSE,
805: p_count => x_msg_count,
806: p_data => x_msg_data
812: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
813: THEN
814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
815: END IF;
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
1104: l_mmbr_tran_rec mmbr_tran_rec_type;
1105: l_mmbr_tran_rec_out mmbr_tran_rec_type;
1106:
1107: BEGIN
1108: -- Standard Start of API savepoint
1109: SAVEPOINT validate_mmbr_trans_;
1110:
1111: -- Standard call to check for call compatibility.
1112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1107: BEGIN
1108: -- Standard Start of API savepoint
1109: SAVEPOINT validate_mmbr_trans_;
1110:
1111: -- Standard call to check for call compatibility.
1112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1113: p_api_version_number,
1114: l_api_name,
1115: G_PKG_NAME)
1187: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1188: END IF;
1189:
1190:
1191: -- Standard call to get message count and if count is 1, get message info.
1192: FND_MSG_PUB.Count_And_Get
1193: (p_count => x_msg_count,
1194: p_data => x_msg_data
1195: );
1201:
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: -- Standard call to get message count and if count=1, get the message
1206: FND_MSG_PUB.Count_And_Get (
1207: p_encoded => FND_API.G_FALSE,
1208: p_count => x_msg_count,
1209: p_data => x_msg_data
1211:
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: -- Standard call to get message count and if count=1, get the message
1216: FND_MSG_PUB.Count_And_Get (
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_msg_count,
1219: p_data => x_msg_data
1225: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1228: END IF;
1229: -- Standard call to get message count and if count=1, get the message
1230: FND_MSG_PUB.Count_And_Get (
1231: p_encoded => FND_API.G_FALSE,
1232: p_count => x_msg_count,
1233: p_data => x_msg_data
1265: IF (PV_DEBUG_HIGH_ON) THEN
1266:
1267: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1268: END IF;
1269: -- Standard call to get message count and if count is 1, get message info.
1270: FND_MSG_PUB.Count_And_Get
1271: (p_count => x_msg_count,
1272: p_data => x_msg_data
1273: );