[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_B
103: WHERE entity_history_log_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_ge_hist_log_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_hist_log_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)
220: --
221: -- End of API body
222: --
223:
224: -- Standard check for p_commit
225: IF FND_API.to_Boolean( p_commit )
226: THEN
227: COMMIT WORK;
228: END IF;
234: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
235: END IF;
236:
237:
238: -- Standard call to get message count and if count is 1, get message info.
239: FND_MSG_PUB.Count_And_Get
240: (p_count => x_msg_count,
241: p_data => x_msg_data
242: );
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO CREATE_Ge_Hist_Log_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_Ge_Hist_Log_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_ge_hist_log_rec ge_hist_log_rec_type := P_ge_hist_log_rec;
348: l_rowid ROWID;
349:
350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT update_ge_hist_log_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_ge_hist_log_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)
470: --
471: -- End of API body.
472: --
473:
474: -- Standard check for p_commit
475: IF FND_API.to_Boolean( p_commit )
476: THEN
477: COMMIT WORK;
478: END IF;
484: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
485: END IF;
486:
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get
490: (p_count => x_msg_count,
491: p_data => x_msg_data
492: );
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO UPDATE_Ge_Hist_Log_PVT;
501: x_return_status := FND_API.G_RET_STS_ERROR;
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
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO UPDATE_Ge_Hist_Log_PVT;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data
555: -- x_return_status OUT VARCHAR2
556: -- x_msg_count OUT NUMBER
557: -- x_msg_data OUT VARCHAR2
558: -- Version : Current version 1.0
559: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
560: -- and basic operation, developer must manually add parameters and business logic as necessary.
561: --
562: -- History
563: --
583: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
584: l_object_version_number NUMBER;
585:
586: BEGIN
587: -- Standard Start of API savepoint
588: SAVEPOINT delete_ge_hist_log_pvt;
589:
590: -- Standard call to check for call compatibility.
591: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
586: BEGIN
587: -- Standard Start of API savepoint
588: SAVEPOINT delete_ge_hist_log_pvt;
589:
590: -- Standard call to check for call compatibility.
591: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
592: p_api_version_number,
593: l_api_name,
594: G_PKG_NAME)
632: --
633: -- End of API body
634: --
635:
636: -- Standard check for p_commit
637: IF FND_API.to_Boolean( p_commit )
638: THEN
639: COMMIT WORK;
640: END IF;
646: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
647: END IF;
648:
649:
650: -- Standard call to get message count and if count is 1, get message info.
651: FND_MSG_PUB.Count_And_Get
652: (p_count => x_msg_count,
653: p_data => x_msg_data
654: );
660:
661: WHEN FND_API.G_EXC_ERROR THEN
662: ROLLBACK TO DELETE_Ge_Hist_Log_PVT;
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: -- Standard call to get message count and if count=1, get the message
665: FND_MSG_PUB.Count_And_Get (
666: p_encoded => FND_API.G_FALSE,
667: p_count => x_msg_count,
668: p_data => x_msg_data
670:
671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: ROLLBACK TO DELETE_Ge_Hist_Log_PVT;
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: -- Standard call to get message count and if count=1, get the message
675: FND_MSG_PUB.Count_And_Get (
676: p_encoded => FND_API.G_FALSE,
677: p_count => x_msg_count,
678: p_data => x_msg_data
684: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
685: THEN
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
687: END IF;
688: -- Standard call to get message count and if count=1, get the message
689: FND_MSG_PUB.Count_And_Get (
690: p_encoded => FND_API.G_FALSE,
691: p_count => x_msg_count,
692: p_data => x_msg_data
718: -- x_return_status OUT VARCHAR2
719: -- x_msg_count OUT NUMBER
720: -- x_msg_data OUT VARCHAR2
721: -- Version : Current version 1.0
722: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
723: -- and basic operation, developer must manually add parameters and business logic as necessary.
724: --
725: -- History
726: --
763: END IF;
764:
765:
766:
767: -- Standard call to check for call compatibility.
768: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
769: p_api_version_number,
770: l_api_name,
771: G_PKG_NAME)
800:
801: WHEN FND_API.G_EXC_ERROR THEN
802: ROLLBACK TO LOCK_Ge_Hist_Log_PVT;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: -- Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data
810:
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: ROLLBACK TO LOCK_Ge_Hist_Log_PVT;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828: -- Standard call to get message count and if count=1, get the message
829: FND_MSG_PUB.Count_And_Get (
830: p_encoded => FND_API.G_FALSE,
831: p_count => x_msg_count,
832: p_data => x_msg_data
1186: l_ge_hist_log_rec ge_hist_log_rec_type;
1187: l_ge_hist_log_rec_out ge_hist_log_rec_type;
1188:
1189: BEGIN
1190: -- Standard Start of API savepoint
1191: SAVEPOINT validate_ge_hist_log_;
1192:
1193: -- Standard call to check for call compatibility.
1194: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1189: BEGIN
1190: -- Standard Start of API savepoint
1191: SAVEPOINT validate_ge_hist_log_;
1192:
1193: -- Standard call to check for call compatibility.
1194: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1195: p_api_version_number,
1196: l_api_name,
1197: G_PKG_NAME)
1269: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1270: END IF;
1271:
1272:
1273: -- Standard call to get message count and if count is 1, get message info.
1274: FND_MSG_PUB.Count_And_Get
1275: (p_count => x_msg_count,
1276: p_data => x_msg_data
1277: );
1283:
1284: WHEN FND_API.G_EXC_ERROR THEN
1285: ROLLBACK TO VALIDATE_Ge_Hist_Log_;
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: -- Standard call to get message count and if count=1, get the message
1288: FND_MSG_PUB.Count_And_Get (
1289: p_encoded => FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => x_msg_data
1293:
1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1295: ROLLBACK TO VALIDATE_Ge_Hist_Log_;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: -- Standard call to get message count and if count=1, get the message
1298: FND_MSG_PUB.Count_And_Get (
1299: p_encoded => FND_API.G_FALSE,
1300: p_count => x_msg_count,
1301: p_data => x_msg_data
1307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1308: THEN
1309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1310: END IF;
1311: -- Standard call to get message count and if count=1, get the message
1312: FND_MSG_PUB.Count_And_Get (
1313: p_encoded => FND_API.G_FALSE,
1314: p_count => x_msg_count,
1315: p_data => x_msg_data
1347: IF (PV_DEBUG_HIGH_ON) THEN
1348:
1349: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1350: END IF;
1351: -- Standard call to get message count and if count is 1, get message info.
1352: FND_MSG_PUB.Count_And_Get
1353: (p_count => x_msg_count,
1354: p_data => x_msg_data
1355: );