[Home] [Help]
53: -- x_return_status OUT VARCHAR2
54: -- x_msg_count OUT NUMBER
55: -- x_msg_data OUT VARCHAR2
56: -- Version : Current version 1.0
57: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
58: -- and basic operation, developer must manually add parameters and business logic as necessary.
59: --
60: -- History
61: --
87: l_err_msg VARCHAR2(2000);
88: l_return_status VARCHAR2(1);
89:
90: BEGIN
91: -- Standard Start of API savepoint
92: SAVEPOINT Create_Tap_Access_Terrs_Pvt;
93:
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
90: BEGIN
91: -- Standard Start of API savepoint
92: SAVEPOINT Create_Tap_Access_Terrs_Pvt;
93:
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
96: p_api_version_number,
97: l_api_name,
98: G_PKG_NAME)
187: --
188: -- End of API body
189: --
190:
191: -- Standard check for p_commit
192: IF FND_API.to_Boolean( p_commit )
193: THEN
194: COMMIT WORK;
195: END IF;
199: IF (PV_DEBUG_HIGH_ON) THEN
200: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
201: END IF;
202:
203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get
205: (p_count => x_msg_count,
206: p_data => x_msg_data
207: );
213:
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO Create_Tap_Access_Terrs_Pvt;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO Create_Tap_Access_Terrs_Pvt;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227:
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (
230: p_encoded => FND_API.G_FALSE,
231: p_count => x_msg_count,
232: p_data => x_msg_data
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
242: END IF;
243:
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data
272: -- x_return_status OUT VARCHAR2
273: -- x_msg_count OUT NUMBER
274: -- x_msg_data OUT VARCHAR2
275: -- Version : Current version 1.0
276: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
277: -- and basic operation, developer must manually add parameters and business logic as necessary.
278: --
279: -- History
280: --
313: l_rowid ROWID;
314: l_err_msg VARCHAR(2000);
315:
316: BEGIN
317: -- Standard Start of API savepoint
318: SAVEPOINT Update_Tap_Access_Terrs_Pvt;
319:
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
316: BEGIN
317: -- Standard Start of API savepoint
318: SAVEPOINT Update_Tap_Access_Terrs_Pvt;
319:
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
322: p_api_version_number,
323: l_api_name,
324: G_PKG_NAME)
444: --
445: -- End of API body.
446: --
447:
448: -- Standard check for p_commit
449: IF FND_API.to_Boolean( p_commit )
450: THEN
451: COMMIT WORK;
452: END IF;
456: IF (PV_DEBUG_HIGH_ON) THEN
457: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' End');
458: END IF;
459:
460: -- Standard call to get message count and if count is 1, get message info.
461: FND_MSG_PUB.Count_And_Get
462: (p_count => x_msg_count,
463: p_data => x_msg_data
464: );
471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO Update_Tap_Access_Terrs_Pvt;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474:
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE,
478: p_count => x_msg_count,
479: p_data => x_msg_data
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO Update_Tap_Access_Terrs_Pvt;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485:
486: -- Standard call to get message count and if count=1, get the message
487: FND_MSG_PUB.Count_And_Get (
488: p_encoded => FND_API.G_FALSE,
489: p_count => x_msg_count,
490: p_data => x_msg_data
498: THEN
499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
500: END IF;
501:
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
531: -- x_return_status OUT VARCHAR2
532: -- x_msg_count OUT NUMBER
533: -- x_msg_data OUT VARCHAR2
534: -- Version : Current version 1.0
535: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
536: -- and basic operation, developer must manually add parameters and business logic as necessary.
537: --
538: -- History
539: --
560: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
561: l_object_version_number NUMBER;
562: l_err_msg VARCHAR(2000);
563: BEGIN
564: -- Standard Start of API savepoint
565: SAVEPOINT Delete_Tap_Access_Terrs;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
563: BEGIN
564: -- Standard Start of API savepoint
565: SAVEPOINT Delete_Tap_Access_Terrs;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
619: --
620: -- End of API body
621: --
622:
623: -- Standard check for p_commit
624: IF FND_API.to_Boolean( p_commit )
625: THEN
626: COMMIT WORK;
627: END IF;
630: IF (PV_DEBUG_HIGH_ON) THEN
631: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' End');
632: END IF;
633:
634: -- Standard call to get message count and if count is 1, get message info.
635: FND_MSG_PUB.Count_And_Get
636: (p_count => x_msg_count,
637: p_data => x_msg_data
638: );
645: WHEN FND_API.G_EXC_ERROR THEN
646: ROLLBACK TO DELETE_Territory_Accesses_Pvt;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648:
649: -- Standard call to get message count and if count=1, get the message
650: FND_MSG_PUB.Count_And_Get (
651: p_encoded => FND_API.G_FALSE,
652: p_count => x_msg_count,
653: p_data => x_msg_data
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO Delete_Tap_Access_Terrs_Pvt;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659:
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
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
674: END IF;
675:
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
705: -- x_return_status OUT VARCHAR2
706: -- x_msg_count OUT NUMBER
707: -- x_msg_data OUT VARCHAR2
708: -- Version : Current version 1.0
709: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
710: -- and basic operation, developer must manually add parameters and business logic as necessary.
711: --
712: -- History
713: --
735: l_partner_access_id NUMBER;
736: l_terr_id NUMBER;
737: l_err_msg VARCHAR(2000);
738: BEGIN
739: -- Standard Start of API savepoint
740: SAVEPOINT Lock_Tap_Access_Terrs;
741:
742: -- Debug Message
743: IF (PV_DEBUG_HIGH_ON) THEN
749: THEN
750: FND_MSG_PUB.initialize;
751: END IF;
752:
753: -- Standard call to check for call compatibility.
754: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
755: p_api_version_number,
756: l_api_name,
757: G_PKG_NAME)
799: WHEN FND_API.G_EXC_ERROR THEN
800: ROLLBACK TO Lock_Tap_Access_Terrs;
801: x_return_status := FND_API.G_RET_STS_ERROR;
802:
803: -- Standard call to get message count and if count=1, get the message
804: FND_MSG_PUB.Count_And_Get (
805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data
810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
811: ROLLBACK TO Lock_Tap_Access_Terrs;
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813:
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
826: THEN
827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
828: END IF;
829:
830: -- Standard call to get message count and if count=1, get the message
831: FND_MSG_PUB.Count_And_Get (
832: p_encoded => FND_API.G_FALSE,
833: p_count => x_msg_count,
834: p_data => x_msg_data
1126: l_object_version_number NUMBER;
1127: l_tap_access_terrs_rec tap_access_terrs_rec_type ;
1128:
1129: BEGIN
1130: -- Standard Start of API savepoint
1131: SAVEPOINT Validate_Tap_Access_Terrs_Pvt;
1132:
1133: -- Standard call to check for call compatibility.
1134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1129: BEGIN
1130: -- Standard Start of API savepoint
1131: SAVEPOINT Validate_Tap_Access_Terrs_Pvt;
1132:
1133: -- Standard call to check for call compatibility.
1134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1135: p_api_version_number,
1136: l_api_name,
1137: G_PKG_NAME)
1197:
1198: -- Debug Message
1199: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
1200:
1201: -- Standard call to get message count and if count is 1, get message info.
1202: FND_MSG_PUB.Count_And_Get
1203: (p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );
1211:
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: ROLLBACK TO Validate_Tap_Access_Terrs_Pvt;
1214: x_return_status := FND_API.G_RET_STS_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
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: ROLLBACK TO Validate_Tap_Access_Terrs_Pvt;
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: -- Standard call to get message count and if count=1, get the message
1226: FND_MSG_PUB.Count_And_Get (
1227: p_encoded => FND_API.G_FALSE,
1228: p_count => x_msg_count,
1229: p_data => x_msg_data
1235: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1236: THEN
1237: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1238: END IF;
1239: -- Standard call to get message count and if count=1, get the message
1240: FND_MSG_PUB.Count_And_Get (
1241: p_encoded => FND_API.G_FALSE,
1242: p_count => x_msg_count,
1243: p_data => x_msg_data
1270: -- x_return_status := FND_API.G_RET_STS_ERROR;
1271:
1272: -- Debug Message
1273: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1274: -- Standard call to get message count and if count is 1, get message info.
1275: FND_MSG_PUB.Count_And_Get
1276: (p_count => x_msg_count,
1277: p_data => x_msg_data
1278: );