51: SELECT count(ae_header_id) FROM OZF_AE_HEADERS_ALL
52: WHERE AE_HEADER_ID = l_id;
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Ae_Header_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_Ae_Header_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)
188: --
189: -- End of API body
190: --
191:
192: -- Standard check for p_commit
193: IF FND_API.to_Boolean( p_commit )
194: THEN
195: COMMIT WORK;
196: END IF;
200: IF g_debug THEN
201: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
202: END IF;
203:
204: -- Standard call to get message count and if count is 1, get message info.
205: FND_MSG_PUB.Count_And_Get
206: (p_count => x_msg_count,
207: p_data => x_msg_data
208: );
213: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO CREATE_Ae_Header_PVT;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data
222: );
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO CREATE_Ae_Header_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data
235: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
238: END IF;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data
274: l_tar_ae_header_rec OZF_Ae_Header_PVT.ae_header_rec_type := P_ae_header_rec;
275: l_rowid ROWID;
276:
277: BEGIN
278: -- Standard Start of API savepoint
279: SAVEPOINT UPDATE_Ae_Header_PVT;
280:
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
277: BEGIN
278: -- Standard Start of API savepoint
279: SAVEPOINT UPDATE_Ae_Header_PVT;
280:
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
283: p_api_version_number,
284: l_api_name,
285: G_PKG_NAME)
407: --
408: -- End of API body.
409: --
410:
411: -- Standard check for p_commit
412: IF FND_API.to_Boolean( p_commit )
413: THEN
414: COMMIT WORK;
415: END IF;
419: IF g_debug THEN
420: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
421: END IF;
422:
423: -- Standard call to get message count and if count is 1, get message info.
424: FND_MSG_PUB.Count_And_Get
425: (p_count => x_msg_count,
426: p_data => x_msg_data
427: );
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO UPDATE_Ae_Header_PVT;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO UPDATE_Ae_Header_PVT;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
460: END IF;
461: -- Standard call to get message count and if count=1, get the message
462: FND_MSG_PUB.Count_And_Get (
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data
484: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
485: l_object_version_number NUMBER;
486:
487: BEGIN
488: -- Standard Start of API savepoint
489: SAVEPOINT DELETE_Ae_Header_PVT;
490:
491: -- Standard call to check for call compatibility.
492: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
487: BEGIN
488: -- Standard Start of API savepoint
489: SAVEPOINT DELETE_Ae_Header_PVT;
490:
491: -- Standard call to check for call compatibility.
492: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
493: p_api_version_number,
494: l_api_name,
495: G_PKG_NAME)
526: --
527: -- End of API body
528: --
529:
530: -- Standard check for p_commit
531: IF FND_API.to_Boolean( p_commit )
532: THEN
533: COMMIT WORK;
534: END IF;
538: IF g_debug THEN
539: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_MSG_PUB.Count_And_Get
544: (p_count => x_msg_count,
545: p_data => x_msg_data
546: );
552:
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO DELETE_Ae_Header_PVT;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: -- Standard call to get message count and if count=1, get the message
557: FND_MSG_PUB.Count_And_Get (
558: p_encoded => FND_API.G_FALSE,
559: p_count => x_msg_count,
560: p_data => x_msg_data
562:
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: ROLLBACK TO DELETE_Ae_Header_PVT;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data
625: THEN
626: FND_MSG_PUB.initialize;
627: END IF;
628:
629: -- Standard call to check for call compatibility.
630: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
631: p_api_version_number,
632: l_api_name,
633: G_PKG_NAME)
676:
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO LOCK_Ae_Header_PVT;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
686:
687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: ROLLBACK TO LOCK_Ae_Header_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
700: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data
1394: l_object_version_number NUMBER;
1395: l_ae_header_rec OZF_Ae_Header_PVT.ae_header_rec_type;
1396:
1397: BEGIN
1398: -- Standard Start of API savepoint
1399: SAVEPOINT VALIDATE_Ae_Header_;
1400:
1401: -- Standard call to check for call compatibility.
1402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1397: BEGIN
1398: -- Standard Start of API savepoint
1399: SAVEPOINT VALIDATE_Ae_Header_;
1400:
1401: -- Standard call to check for call compatibility.
1402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1403: p_api_version_number,
1404: l_api_name,
1405: G_PKG_NAME)
1462: IF g_debug THEN
1463: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1464: END IF;
1465:
1466: -- Standard call to get message count and if count is 1, get message info.
1467: FND_MSG_PUB.Count_And_Get
1468: (p_count => x_msg_count,
1469: p_data => x_msg_data
1470: );
1476:
1477: WHEN FND_API.G_EXC_ERROR THEN
1478: ROLLBACK TO VALIDATE_Ae_Header_;
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: -- Standard call to get message count and if count=1, get the message
1481: FND_MSG_PUB.Count_And_Get (
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => x_msg_count,
1484: p_data => x_msg_data
1486:
1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: ROLLBACK TO VALIDATE_Ae_Header_;
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1490: -- Standard call to get message count and if count=1, get the message
1491: FND_MSG_PUB.Count_And_Get (
1492: p_encoded => FND_API.G_FALSE,
1493: p_count => x_msg_count,
1494: p_data => x_msg_data
1500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data
1537: -- Debug Message
1538: IF g_debug THEN
1539: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1540: END IF;
1541: -- Standard call to get message count and if count is 1, get message info.
1542: FND_MSG_PUB.Count_And_Get
1543: (p_count => x_msg_count,
1544: p_data => x_msg_data
1545: );