[Home] [Help]
51: SELECT count(accounting_event_id) FROM OZF_ACCTNG_EVENTS_ALL
52: WHERE ACCOUNTING_EVENT_ID = l_id;
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Acctng_Events_PVT;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Acctng_Events_PVT;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
60: p_api_version_number,
61: l_api_name,
62: G_PKG_NAME)
178: --
179: -- End of API body
180: --
181:
182: -- Standard check for p_commit
183: IF FND_API.to_Boolean( p_commit )
184: THEN
185: COMMIT WORK;
186: END IF;
189: IF g_debug THEN
190: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
191: END IF;
192:
193: -- Standard call to get message count and if count is 1, get message info.
194: FND_MSG_PUB.Count_And_Get
195: (p_count => x_msg_count,
196: p_data => x_msg_data
197: );
201: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO CREATE_Acctng_Events_PVT;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: -- Standard call to get message count and if count=1, get the message
206: FND_MSG_PUB.Count_And_Get (
207: p_encoded => FND_API.G_FALSE,
208: p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO CREATE_Acctng_Events_PVT;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
226: END IF;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (
229: p_encoded => FND_API.G_FALSE,
230: p_count => x_msg_count,
231: p_data => x_msg_data
262: l_tar_acctng_event_rec OZF_Acctng_Events_PVT.acctng_event_rec_type := P_acctng_event_rec;
263: l_rowid ROWID;
264:
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT UPDATE_Acctng_Events_PVT;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT UPDATE_Acctng_Events_PVT;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
271: p_api_version_number,
272: l_api_name,
273: G_PKG_NAME)
387: --
388: -- End of API body.
389: --
390:
391: -- Standard check for p_commit
392: IF FND_API.to_Boolean( p_commit )
393: THEN
394: COMMIT WORK;
395: END IF;
399: IF g_debug THEN
400: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
401: END IF;
402:
403: -- Standard call to get message count and if count is 1, get message info.
404: FND_MSG_PUB.Count_And_Get
405: (p_count => x_msg_count,
406: p_data => x_msg_data
407: );
413:
414: WHEN FND_API.G_EXC_ERROR THEN
415: ROLLBACK TO UPDATE_Acctng_Events_PVT;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: -- Standard call to get message count and if count=1, get the message
418: FND_MSG_PUB.Count_And_Get (
419: p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,
421: p_data => x_msg_data
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: ROLLBACK TO UPDATE_Acctng_Events_PVT;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: -- Standard call to get message count and if count=1, get the message
428: FND_MSG_PUB.Count_And_Get (
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data
437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
438: THEN
439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
440: END IF;
441: -- Standard call to get message count and if count=1, get the message
442: FND_MSG_PUB.Count_And_Get (
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
445: p_data => x_msg_data
464: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
465: l_object_version_number NUMBER;
466:
467: BEGIN
468: -- Standard Start of API savepoint
469: SAVEPOINT DELETE_Acctng_Events_PVT;
470:
471: -- Standard call to check for call compatibility.
472: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
467: BEGIN
468: -- Standard Start of API savepoint
469: SAVEPOINT DELETE_Acctng_Events_PVT;
470:
471: -- Standard call to check for call compatibility.
472: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
473: p_api_version_number,
474: l_api_name,
475: G_PKG_NAME)
506: --
507: -- End of API body
508: --
509:
510: -- Standard check for p_commit
511: IF FND_API.to_Boolean( p_commit )
512: THEN
513: COMMIT WORK;
514: END IF;
518: IF g_debug THEN
519: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
520: END IF;
521:
522: -- Standard call to get message count and if count is 1, get message info.
523: FND_MSG_PUB.Count_And_Get
524: (p_count => x_msg_count,
525: p_data => x_msg_data
526: );
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: ROLLBACK TO DELETE_Acctng_Events_PVT;
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: ROLLBACK TO DELETE_Acctng_Events_PVT;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: -- Standard call to get message count and if count=1, get the message
547: FND_MSG_PUB.Count_And_Get (
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data
556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
559: END IF;
560: -- Standard call to get message count and if count=1, get the message
561: FND_MSG_PUB.Count_And_Get (
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count,
564: p_data => x_msg_data
605: THEN
606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Standard call to check for call compatibility.
610: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
611: p_api_version_number,
612: l_api_name,
613: G_PKG_NAME)
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_Acctng_Events_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
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
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO LOCK_Acctng_Events_PVT;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: -- Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
1268: l_object_version_number NUMBER;
1269: l_acctng_event_rec OZF_Acctng_Events_PVT.acctng_event_rec_type;
1270:
1271: BEGIN
1272: -- Standard Start of API savepoint
1273: SAVEPOINT VALIDATE_Acctng_Events_;
1274:
1275: -- Standard call to check for call compatibility.
1276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1271: BEGIN
1272: -- Standard Start of API savepoint
1273: SAVEPOINT VALIDATE_Acctng_Events_;
1274:
1275: -- Standard call to check for call compatibility.
1276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1277: p_api_version_number,
1278: l_api_name,
1279: G_PKG_NAME)
1336: IF g_debug THEN
1337: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1338: END IF;
1339:
1340: -- Standard call to get message count and if count is 1, get message info.
1341: FND_MSG_PUB.Count_And_Get
1342: (p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );
1350:
1351: WHEN FND_API.G_EXC_ERROR THEN
1352: ROLLBACK TO VALIDATE_Acctng_Events_;
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: -- Standard call to get message count and if count=1, get the message
1355: FND_MSG_PUB.Count_And_Get (
1356: p_encoded => FND_API.G_FALSE,
1357: p_count => x_msg_count,
1358: p_data => x_msg_data
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO VALIDATE_Acctng_Events_;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: -- Standard call to get message count and if count=1, get the message
1365: FND_MSG_PUB.Count_And_Get (
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,
1368: p_data => x_msg_data
1374: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,
1381: p_count => x_msg_count,
1382: p_data => x_msg_data
1411: -- Debug Message
1412: IF g_debug THEN
1413: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1414: END IF;
1415: -- Standard call to get message count and if count is 1, get message info.
1416: FND_MSG_PUB.Count_And_Get
1417: (p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );