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_GE_PTNR_RESPS
106: WHERE ptnr_resp_id = l_id;
107: BEGIN
108: -- Standard Start of API savepoint
109: SAVEPOINT create_ge_ptnr_resps_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_ge_ptnr_resps_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)
221: --
222: -- End of API body
223: --
224:
225: -- Standard check for p_commit
226: IF FND_API.to_Boolean( p_commit )
227: THEN
228: COMMIT WORK;
229: END IF;
235: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
236: END IF;
237:
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: FND_MSG_PUB.Count_And_Get
241: (p_count => x_msg_count,
242: p_data => x_msg_data
243: );
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
262: x_return_status := FND_API.G_RET_STS_UNEXP_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
273: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
274: THEN
275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
276: END IF;
277: -- Standard call to get message count and if count=1, get the message
278: FND_MSG_PUB.Count_And_Get (
279: p_encoded => FND_API.G_FALSE,
280: p_count => x_msg_count,
281: p_data => x_msg_data
305: -- x_return_status OUT VARCHAR2
306: -- x_msg_count OUT NUMBER
307: -- x_msg_data OUT VARCHAR2
308: -- Version : Current version 1.0
309: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
310: -- and basic operation, developer must manually add parameters and business logic as necessary.
311: --
312: -- History
313: --
348: l_tar_ge_ptnr_resps_rec ge_ptnr_resps_rec_type := P_ge_ptnr_resps_rec;
349: l_rowid ROWID;
350:
351: BEGIN
352: -- Standard Start of API savepoint
353: SAVEPOINT update_ge_ptnr_resps_pvt;
354:
355: -- Standard call to check for call compatibility.
356: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
351: BEGIN
352: -- Standard Start of API savepoint
353: SAVEPOINT update_ge_ptnr_resps_pvt;
354:
355: -- Standard call to check for call compatibility.
356: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
357: p_api_version_number,
358: l_api_name,
359: G_PKG_NAME)
477: --
478: -- End of API body.
479: --
480:
481: -- Standard check for p_commit
482: IF FND_API.to_Boolean( p_commit )
483: THEN
484: COMMIT WORK;
485: END IF;
491: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
492: END IF;
493:
494:
495: -- Standard call to get message count and if count is 1, get message info.
496: FND_MSG_PUB.Count_And_Get
497: (p_count => x_msg_count,
498: p_data => x_msg_data
499: );
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: -- Standard call to get message count and if count=1, get the message
510: FND_MSG_PUB.Count_And_Get (
511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,
513: p_data => x_msg_data
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: -- Standard call to get message count and if count=1, get the message
520: FND_MSG_PUB.Count_And_Get (
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
562: -- x_return_status OUT VARCHAR2
563: -- x_msg_count OUT NUMBER
564: -- x_msg_data OUT VARCHAR2
565: -- Version : Current version 1.0
566: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
567: -- and basic operation, developer must manually add parameters and business logic as necessary.
568: --
569: -- History
570: --
590: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
591: l_object_version_number NUMBER;
592:
593: BEGIN
594: -- Standard Start of API savepoint
595: SAVEPOINT delete_ge_ptnr_resps_pvt;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
593: BEGIN
594: -- Standard Start of API savepoint
595: SAVEPOINT delete_ge_ptnr_resps_pvt;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
599: p_api_version_number,
600: l_api_name,
601: G_PKG_NAME)
639: --
640: -- End of API body
641: --
642:
643: -- Standard check for p_commit
644: IF FND_API.to_Boolean( p_commit )
645: THEN
646: COMMIT WORK;
647: END IF;
653: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
654: END IF;
655:
656:
657: -- Standard call to get message count and if count is 1, get message info.
658: FND_MSG_PUB.Count_And_Get
659: (p_count => x_msg_count,
660: p_data => x_msg_data
661: );
667:
668: WHEN FND_API.G_EXC_ERROR THEN
669: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: -- Standard call to get message count and if count=1, get the message
672: FND_MSG_PUB.Count_And_Get (
673: p_encoded => FND_API.G_FALSE,
674: p_count => x_msg_count,
675: p_data => x_msg_data
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
691: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
694: END IF;
695: -- Standard call to get message count and if count=1, get the message
696: FND_MSG_PUB.Count_And_Get (
697: p_encoded => FND_API.G_FALSE,
698: p_count => x_msg_count,
699: p_data => x_msg_data
725: -- x_return_status OUT VARCHAR2
726: -- x_msg_count OUT NUMBER
727: -- x_msg_data OUT VARCHAR2
728: -- Version : Current version 1.0
729: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
730: -- and basic operation, developer must manually add parameters and business logic as necessary.
731: --
732: -- History
733: --
770: END IF;
771:
772:
773:
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
776: p_api_version_number,
777: l_api_name,
778: G_PKG_NAME)
807:
808: WHEN FND_API.G_EXC_ERROR THEN
809: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: -- Standard call to get message count and if count=1, get the message
812: FND_MSG_PUB.Count_And_Get (
813: p_encoded => FND_API.G_FALSE,
814: p_count => x_msg_count,
815: p_data => x_msg_data
817:
818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
819: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: -- Standard call to get message count and if count=1, get the message
822: FND_MSG_PUB.Count_And_Get (
823: p_encoded => FND_API.G_FALSE,
824: p_count => x_msg_count,
825: p_data => x_msg_data
831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
832: THEN
833: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
834: END IF;
835: -- Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => x_msg_data
1198: l_ge_ptnr_resps_rec ge_ptnr_resps_rec_type;
1199: l_ge_ptnr_resps_rec_out ge_ptnr_resps_rec_type;
1200:
1201: BEGIN
1202: -- Standard Start of API savepoint
1203: SAVEPOINT validate_ge_ptnr_resps_;
1204:
1205: -- Standard call to check for call compatibility.
1206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1201: BEGIN
1202: -- Standard Start of API savepoint
1203: SAVEPOINT validate_ge_ptnr_resps_;
1204:
1205: -- Standard call to check for call compatibility.
1206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1207: p_api_version_number,
1208: l_api_name,
1209: G_PKG_NAME)
1278: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1279: END IF;
1280:
1281:
1282: -- Standard call to get message count and if count is 1, get message info.
1283: FND_MSG_PUB.Count_And_Get
1284: (p_count => x_msg_count,
1285: p_data => x_msg_data
1286: );
1292:
1293: WHEN FND_API.G_EXC_ERROR THEN
1294: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1302:
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: -- Standard call to get message count and if count=1, get the message
1307: FND_MSG_PUB.Count_And_Get (
1308: p_encoded => FND_API.G_FALSE,
1309: p_count => x_msg_count,
1310: p_data => x_msg_data
1316: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1317: THEN
1318: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1319: END IF;
1320: -- Standard call to get message count and if count=1, get the message
1321: FND_MSG_PUB.Count_And_Get (
1322: p_encoded => FND_API.G_FALSE,
1323: p_count => x_msg_count,
1324: p_data => x_msg_data
1356: IF (PV_DEBUG_HIGH_ON) THEN
1357:
1358: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1359: END IF;
1360: -- Standard call to get message count and if count is 1, get message info.
1361: FND_MSG_PUB.Count_And_Get
1362: (p_count => x_msg_count,
1363: p_data => x_msg_data
1364: );