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_TEMP_APPROVERS
103: WHERE entity_approver_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_ptr_enr_temp_appr_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_ptr_enr_temp_appr_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)
219: --
220: -- End of API body
221: --
222:
223: -- Standard check for p_commit
224: IF FND_API.to_Boolean( p_commit )
225: THEN
226: COMMIT WORK;
227: END IF;
233: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
234: END IF;
235:
236:
237: -- Standard call to get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: (p_count => x_msg_count,
240: p_data => x_msg_data
241: );
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO CREATE_Ptr_Enr_Temp_Appr_PVT;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: -- Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => x_msg_count,
256: p_data => x_msg_data
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO CREATE_Ptr_Enr_Temp_Appr_PVT;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (
264: p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message
277: FND_MSG_PUB.Count_And_Get (
278: p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data
304: -- x_return_status OUT VARCHAR2
305: -- x_msg_count OUT NUMBER
306: -- x_msg_data OUT VARCHAR2
307: -- Version : Current version 1.0
308: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
309: -- and basic operation, developer must manually add parameters and business logic as necessary.
310: --
311: -- History
312: --
347: l_tar_approver_rec approver_rec_type := P_approver_rec;
348: l_rowid ROWID;
349:
350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT update_ptr_enr_temp_appr_pvt;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT update_ptr_enr_temp_appr_pvt;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
356: p_api_version_number,
357: l_api_name,
358: G_PKG_NAME)
497: --
498: -- End of API body.
499: --
500:
501: -- Standard check for p_commit
502: IF FND_API.to_Boolean( p_commit )
503: THEN
504: COMMIT WORK;
505: END IF;
511: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
512: END IF;
513:
514:
515: -- Standard call to get message count and if count is 1, get message info.
516: FND_MSG_PUB.Count_And_Get
517: (p_count => x_msg_count,
518: p_data => x_msg_data
519: );
566:
567: WHEN FND_API.G_EXC_ERROR THEN
568: ROLLBACK TO UPDATE_Ptr_Enr_Temp_Appr_PVT;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: -- Standard call to get message count and if count=1, get the message
571: FND_MSG_PUB.Count_And_Get (
572: p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO UPDATE_Ptr_Enr_Temp_Appr_PVT;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data
590: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
591: THEN
592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
593: END IF;
594: -- Standard call to get message count and if count=1, get the message
595: FND_MSG_PUB.Count_And_Get (
596: p_encoded => FND_API.G_FALSE,
597: p_count => x_msg_count,
598: p_data => x_msg_data
623: -- x_return_status OUT VARCHAR2
624: -- x_msg_count OUT NUMBER
625: -- x_msg_data OUT VARCHAR2
626: -- Version : Current version 1.0
627: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
628: -- and basic operation, developer must manually add parameters and business logic as necessary.
629: --
630: -- History
631: --
651: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
652: l_object_version_number NUMBER;
653:
654: BEGIN
655: -- Standard Start of API savepoint
656: SAVEPOINT delete_ptr_enr_temp_appr_pvt;
657:
658: -- Standard call to check for call compatibility.
659: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
654: BEGIN
655: -- Standard Start of API savepoint
656: SAVEPOINT delete_ptr_enr_temp_appr_pvt;
657:
658: -- Standard call to check for call compatibility.
659: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
660: p_api_version_number,
661: l_api_name,
662: G_PKG_NAME)
700: --
701: -- End of API body
702: --
703:
704: -- Standard check for p_commit
705: IF FND_API.to_Boolean( p_commit )
706: THEN
707: COMMIT WORK;
708: END IF;
714: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
715: END IF;
716:
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: (p_count => x_msg_count,
721: p_data => x_msg_data
722: );
729:
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO DELETE_Ptr_Enr_Temp_Appr_PVT;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: -- Standard call to get message count and if count=1, get the message
734: FND_MSG_PUB.Count_And_Get (
735: p_encoded => FND_API.G_FALSE,
736: p_count => x_msg_count,
737: p_data => x_msg_data
739:
740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
741: ROLLBACK TO DELETE_Ptr_Enr_Temp_Appr_PVT;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: -- Standard call to get message count and if count=1, get the message
744: FND_MSG_PUB.Count_And_Get (
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data
753: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
754: THEN
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
756: END IF;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
787: -- x_return_status OUT VARCHAR2
788: -- x_msg_count OUT NUMBER
789: -- x_msg_data OUT VARCHAR2
790: -- Version : Current version 1.0
791: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
792: -- and basic operation, developer must manually add parameters and business logic as necessary.
793: --
794: -- History
795: --
832: END IF;
833:
834:
835:
836: -- Standard call to check for call compatibility.
837: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
838: p_api_version_number,
839: l_api_name,
840: G_PKG_NAME)
870:
871: WHEN FND_API.G_EXC_ERROR THEN
872: ROLLBACK TO LOCK_Ptr_Enr_Temp_Appr_PVT;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: -- Standard call to get message count and if count=1, get the message
875: FND_MSG_PUB.Count_And_Get (
876: p_encoded => FND_API.G_FALSE,
877: p_count => x_msg_count,
878: p_data => x_msg_data
880:
881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882: ROLLBACK TO LOCK_Ptr_Enr_Temp_Appr_PVT;
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
884: -- Standard call to get message count and if count=1, get the message
885: FND_MSG_PUB.Count_And_Get (
886: p_encoded => FND_API.G_FALSE,
887: p_count => x_msg_count,
888: p_data => x_msg_data
894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
897: END IF;
898: -- Standard call to get message count and if count=1, get the message
899: FND_MSG_PUB.Count_And_Get (
900: p_encoded => FND_API.G_FALSE,
901: p_count => x_msg_count,
902: p_data => x_msg_data
1222: l_approver_rec approver_rec_type;
1223: l_approver_rec_out approver_rec_type;
1224:
1225: BEGIN
1226: -- Standard Start of API savepoint
1227: SAVEPOINT validate_ptr_enr_temp_appr_;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1225: BEGIN
1226: -- Standard Start of API savepoint
1227: SAVEPOINT validate_ptr_enr_temp_appr_;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1231: p_api_version_number,
1232: l_api_name,
1233: G_PKG_NAME)
1305: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1306: END IF;
1307:
1308:
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: );
1320:
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: ROLLBACK TO VALIDATE_Ptr_Enr_Temp_Appr_;
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: -- Standard call to get message count and if count=1, get the message
1325: FND_MSG_PUB.Count_And_Get (
1326: p_encoded => FND_API.G_FALSE,
1327: p_count => x_msg_count,
1328: p_data => x_msg_data
1330:
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: ROLLBACK TO VALIDATE_Ptr_Enr_Temp_Appr_;
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: -- Standard call to get message count and if count=1, get the message
1335: FND_MSG_PUB.Count_And_Get (
1336: p_encoded => FND_API.G_FALSE,
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1345: THEN
1346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1347: END IF;
1348: -- Standard call to get message count and if count=1, get the message
1349: FND_MSG_PUB.Count_And_Get (
1350: p_encoded => FND_API.G_FALSE,
1351: p_count => x_msg_count,
1352: p_data => x_msg_data
1384: IF (PV_DEBUG_HIGH_ON) THEN
1385:
1386: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1387: END IF;
1388: -- Standard call to get message count and if count is 1, get message info.
1389: FND_MSG_PUB.Count_And_Get
1390: (p_count => x_msg_count,
1391: p_data => x_msg_data
1392: );