[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: --
108: SELECT 1
109: FROM PV_GE_CHKLST_RESPONSES
110: WHERE chklst_response_id = l_id;
111: BEGIN
112: -- Standard Start of API savepoint
113: SAVEPOINT create_ge_chklst_resp_pvt;
114:
115: -- Standard call to check for call compatibility.
116: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
111: BEGIN
112: -- Standard Start of API savepoint
113: SAVEPOINT create_ge_chklst_resp_pvt;
114:
115: -- Standard call to check for call compatibility.
116: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
117: p_api_version_number,
118: l_api_name,
119: G_PKG_NAME)
240: --
241: -- End of API body
242: --
243:
244: -- Standard check for p_commit
245: IF FND_API.to_Boolean( p_commit )
246: THEN
247: COMMIT WORK;
248: END IF;
254: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
255: END IF;
256:
257:
258: -- Standard call to get message count and if count is 1, get message info.
259: FND_MSG_PUB.Count_And_Get
260: (p_count => x_msg_count,
261: p_data => x_msg_data
262: );
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (
284: p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,
286: p_data => x_msg_data
292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
295: END IF;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data
324: -- x_return_status OUT VARCHAR2
325: -- x_msg_count OUT NUMBER
326: -- x_msg_data OUT VARCHAR2
327: -- Version : Current version 1.0
328: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
329: -- and basic operation, developer must manually add parameters and business logic as necessary.
330: --
331: -- History
332: --
367: l_tar_ge_chklst_resp_rec ge_chklst_resp_rec_type := P_ge_chklst_resp_rec;
368: l_rowid ROWID;
369:
370: BEGIN
371: -- Standard Start of API savepoint
372: SAVEPOINT update_ge_chklst_resp_pvt;
373:
374: -- Standard call to check for call compatibility.
375: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
370: BEGIN
371: -- Standard Start of API savepoint
372: SAVEPOINT update_ge_chklst_resp_pvt;
373:
374: -- Standard call to check for call compatibility.
375: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
376: p_api_version_number,
377: l_api_name,
378: G_PKG_NAME)
483: --
484: -- End of API body.
485: --
486:
487: -- Standard check for p_commit
488: IF FND_API.to_Boolean( p_commit )
489: THEN
490: COMMIT WORK;
491: END IF;
497: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
498: END IF;
499:
500:
501: -- Standard call to get message count and if count is 1, get message info.
502: FND_MSG_PUB.Count_And_Get
503: (p_count => x_msg_count,
504: p_data => x_msg_data
505: );
511:
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data
535: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
536: THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: -- Standard call to get message count and if count=1, get the message
540: FND_MSG_PUB.Count_And_Get (
541: p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data
568: -- x_return_status OUT VARCHAR2
569: -- x_msg_count OUT NUMBER
570: -- x_msg_data OUT VARCHAR2
571: -- Version : Current version 1.0
572: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
573: -- and basic operation, developer must manually add parameters and business logic as necessary.
574: --
575: -- History
576: --
596: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
597: l_object_version_number NUMBER;
598:
599: BEGIN
600: -- Standard Start of API savepoint
601: SAVEPOINT delete_ge_chklst_resp_pvt;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
599: BEGIN
600: -- Standard Start of API savepoint
601: SAVEPOINT delete_ge_chklst_resp_pvt;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
605: p_api_version_number,
606: l_api_name,
607: G_PKG_NAME)
645: --
646: -- End of API body
647: --
648:
649: -- Standard check for p_commit
650: IF FND_API.to_Boolean( p_commit )
651: THEN
652: COMMIT WORK;
653: END IF;
659: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
660: END IF;
661:
662:
663: -- Standard call to get message count and if count is 1, get message info.
664: FND_MSG_PUB.Count_And_Get
665: (p_count => x_msg_count,
666: p_data => x_msg_data
667: );
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: -- Standard call to get message count and if count=1, get the message
678: FND_MSG_PUB.Count_And_Get (
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: -- Standard call to get message count and if count=1, get the message
688: FND_MSG_PUB.Count_And_Get (
689: p_encoded => FND_API.G_FALSE,
690: p_count => x_msg_count,
691: p_data => x_msg_data
697: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
698: THEN
699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
700: END IF;
701: -- Standard call to get message count and if count=1, get the message
702: FND_MSG_PUB.Count_And_Get (
703: p_encoded => FND_API.G_FALSE,
704: p_count => x_msg_count,
705: p_data => x_msg_data
731: -- x_return_status OUT VARCHAR2
732: -- x_msg_count OUT NUMBER
733: -- x_msg_data OUT VARCHAR2
734: -- Version : Current version 1.0
735: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
736: -- and basic operation, developer must manually add parameters and business logic as necessary.
737: --
738: -- History
739: --
776: END IF;
777:
778:
779:
780: -- Standard call to check for call compatibility.
781: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
782: p_api_version_number,
783: l_api_name,
784: G_PKG_NAME)
813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: -- Standard call to get message count and if count=1, get the message
818: FND_MSG_PUB.Count_And_Get (
819: p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data
823:
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data
837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
838: THEN
839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
840: END IF;
841: -- Standard call to get message count and if count=1, get the message
842: FND_MSG_PUB.Count_And_Get (
843: p_encoded => FND_API.G_FALSE,
844: p_count => x_msg_count,
845: p_data => x_msg_data
1163: l_ge_chklst_resp_rec ge_chklst_resp_rec_type;
1164: l_ge_chklst_resp_rec_out ge_chklst_resp_rec_type;
1165:
1166: BEGIN
1167: -- Standard Start of API savepoint
1168: SAVEPOINT validate_ge_chklst_resp_;
1169:
1170: -- Standard call to check for call compatibility.
1171: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1166: BEGIN
1167: -- Standard Start of API savepoint
1168: SAVEPOINT validate_ge_chklst_resp_;
1169:
1170: -- Standard call to check for call compatibility.
1171: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1172: p_api_version_number,
1173: l_api_name,
1174: G_PKG_NAME)
1246: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1247: END IF;
1248:
1249:
1250: -- Standard call to get message count and if count is 1, get message info.
1251: FND_MSG_PUB.Count_And_Get
1252: (p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: -- Standard call to get message count and if count=1, get the message
1275: FND_MSG_PUB.Count_And_Get (
1276: p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count,
1278: p_data => x_msg_data
1284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1285: THEN
1286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1287: END IF;
1288: -- Standard call to get message count and if count=1, get the message
1289: FND_MSG_PUB.Count_And_Get (
1290: p_encoded => FND_API.G_FALSE,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data
1324: IF (PV_DEBUG_HIGH_ON) THEN
1325:
1326: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1327: END IF;
1328: -- Standard call to get message count and if count is 1, get message info.
1329: FND_MSG_PUB.Count_And_Get
1330: (p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );