[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_GE_HISTORY_LOG_PARAMS
103: WHERE history_log_param_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_ge_hl_param_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_ge_hl_param_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)
217: --
218: -- End of API body
219: --
220:
221: -- Standard check for p_commit
222: IF FND_API.to_Boolean( p_commit )
223: THEN
224: COMMIT WORK;
225: END IF;
231: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
232: END IF;
233:
234:
235: -- Standard call to get message count and if count is 1, get message info.
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count,
238: p_data => x_msg_data
239: );
245:
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_Ge_Hl_Param_PVT;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: ROLLBACK TO CREATE_Ge_Hl_Param_PVT;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
269: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
270: THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
272: END IF;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
301: -- x_return_status OUT VARCHAR2
302: -- x_msg_count OUT NUMBER
303: -- x_msg_data OUT VARCHAR2
304: -- Version : Current version 1.0
305: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
306: -- and basic operation, developer must manually add parameters and business logic as necessary.
307: --
308: -- History
309: --
344: l_tar_ge_hl_param_rec ge_hl_param_rec_type := P_ge_hl_param_rec;
345: l_rowid ROWID;
346:
347: BEGIN
348: -- Standard Start of API savepoint
349: SAVEPOINT update_ge_hl_param_pvt;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
347: BEGIN
348: -- Standard Start of API savepoint
349: SAVEPOINT update_ge_hl_param_pvt;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
353: p_api_version_number,
354: l_api_name,
355: G_PKG_NAME)
464: --
465: -- End of API body.
466: --
467:
468: -- Standard check for p_commit
469: IF FND_API.to_Boolean( p_commit )
470: THEN
471: COMMIT WORK;
472: END IF;
478: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
479: END IF;
480:
481:
482: -- Standard call to get message count and if count is 1, get message info.
483: FND_MSG_PUB.Count_And_Get
484: (p_count => x_msg_count,
485: p_data => x_msg_data
486: );
492:
493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO UPDATE_Ge_Hl_Param_PVT;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: -- Standard call to get message count and if count=1, get the message
497: FND_MSG_PUB.Count_And_Get (
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,
500: p_data => x_msg_data
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO UPDATE_Ge_Hl_Param_PVT;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
549: -- x_return_status OUT VARCHAR2
550: -- x_msg_count OUT NUMBER
551: -- x_msg_data OUT VARCHAR2
552: -- Version : Current version 1.0
553: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
554: -- and basic operation, developer must manually add parameters and business logic as necessary.
555: --
556: -- History
557: --
577: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
578: l_object_version_number NUMBER;
579:
580: BEGIN
581: -- Standard Start of API savepoint
582: SAVEPOINT delete_ge_hl_param_pvt;
583:
584: -- Standard call to check for call compatibility.
585: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
580: BEGIN
581: -- Standard Start of API savepoint
582: SAVEPOINT delete_ge_hl_param_pvt;
583:
584: -- Standard call to check for call compatibility.
585: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
586: p_api_version_number,
587: l_api_name,
588: G_PKG_NAME)
626: --
627: -- End of API body
628: --
629:
630: -- Standard check for p_commit
631: IF FND_API.to_Boolean( p_commit )
632: THEN
633: COMMIT WORK;
634: END IF;
640: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
641: END IF;
642:
643:
644: -- Standard call to get message count and if count is 1, get message info.
645: FND_MSG_PUB.Count_And_Get
646: (p_count => x_msg_count,
647: p_data => x_msg_data
648: );
654:
655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO DELETE_Ge_Hl_Param_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: -- Standard call to get message count and if count=1, get the message
659: FND_MSG_PUB.Count_And_Get (
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_msg_count,
662: p_data => x_msg_data
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO DELETE_Ge_Hl_Param_PVT;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: -- Standard call to get message count and if count=1, get the message
669: FND_MSG_PUB.Count_And_Get (
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_msg_count,
672: p_data => x_msg_data
678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
679: THEN
680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
681: END IF;
682: -- Standard call to get message count and if count=1, get the message
683: FND_MSG_PUB.Count_And_Get (
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_msg_count,
686: p_data => x_msg_data
712: -- x_return_status OUT VARCHAR2
713: -- x_msg_count OUT NUMBER
714: -- x_msg_data OUT VARCHAR2
715: -- Version : Current version 1.0
716: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
717: -- and basic operation, developer must manually add parameters and business logic as necessary.
718: --
719: -- History
720: --
757: END IF;
758:
759:
760:
761: -- Standard call to check for call compatibility.
762: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
763: p_api_version_number,
764: l_api_name,
765: G_PKG_NAME)
794:
795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO LOCK_Ge_Hl_Param_PVT;
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: -- Standard call to get message count and if count=1, get the message
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => x_msg_count,
802: p_data => x_msg_data
804:
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ROLLBACK TO LOCK_Ge_Hl_Param_PVT;
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: -- Standard call to get message count and if count=1, get the message
809: FND_MSG_PUB.Count_And_Get (
810: p_encoded => FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
823: FND_MSG_PUB.Count_And_Get (
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_msg_count,
826: p_data => x_msg_data
1114: l_object_version_number NUMBER;
1115: l_ge_hl_param_rec ge_hl_param_rec_type;
1116:
1117: BEGIN
1118: -- Standard Start of API savepoint
1119: SAVEPOINT validate_ge_hl_param_;
1120:
1121: -- Standard call to check for call compatibility.
1122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1117: BEGIN
1118: -- Standard Start of API savepoint
1119: SAVEPOINT validate_ge_hl_param_;
1120:
1121: -- Standard call to check for call compatibility.
1122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1123: p_api_version_number,
1124: l_api_name,
1125: G_PKG_NAME)
1195: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1196: END IF;
1197:
1198:
1199: -- Standard call to get message count and if count is 1, get message info.
1200: FND_MSG_PUB.Count_And_Get
1201: (p_count => x_msg_count,
1202: p_data => x_msg_data
1203: );
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Ge_Hl_Param_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: ROLLBACK TO VALIDATE_Ge_Hl_Param_;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223: -- Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1234: THEN
1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1273: IF (PV_DEBUG_HIGH_ON) THEN
1274:
1275: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1276: END IF;
1277: -- Standard call to get message count and if count is 1, get message info.
1278: FND_MSG_PUB.Count_And_Get
1279: (p_count => x_msg_count,
1280: p_data => x_msg_data
1281: );