[Home] [Help]
48: SELECT count(ae_line_id) FROM OZF_AE_LINES_ALL
49: WHERE AE_LINE_ID = l_id;
50:
51: BEGIN
52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_Ae_Line_PVT;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: BEGIN
52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_Ae_Line_PVT;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
57: p_api_version_number,
58: l_api_name,
59: G_PKG_NAME)
229: --
230: -- End of API body
231: --
232:
233: -- Standard check for p_commit
234: IF FND_API.to_Boolean( p_commit )
235: THEN
236: COMMIT WORK;
237: END IF;
240: IF G_DEBUG THEN
241: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
242: END IF;
243:
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get
246: (p_count => x_msg_count,
247: p_data => x_msg_data
248: );
252: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
253: WHEN FND_API.G_EXC_ERROR THEN
254: ROLLBACK TO CREATE_Ae_Line_PVT;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data
261: );
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO CREATE_Ae_Line_PVT;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data
274: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
275: THEN
276: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
277: END IF;
278: -- Standard call to get message count and if count=1, get the message
279: FND_MSG_PUB.Count_And_Get (
280: p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,
282: p_data => x_msg_data
313: l_tar_ae_line_rec OZF_Ae_Line_PVT.ae_line_rec_type := P_ae_line_rec;
314: l_rowid ROWID;
315:
316: BEGIN
317: -- Standard Start of API savepoint
318: SAVEPOINT UPDATE_Ae_Line_PVT;
319:
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
316: BEGIN
317: -- Standard Start of API savepoint
318: SAVEPOINT UPDATE_Ae_Line_PVT;
319:
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
322: p_api_version_number,
323: l_api_name,
324: G_PKG_NAME)
477: --
478: -- End of API body.
479: --
480:
481: -- Standard check for p_commit
482: IF FND_API.to_Boolean( p_commit )
483: THEN
484: COMMIT WORK;
485: END IF;
489: IF G_DEBUG THEN
490: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
491: END IF;
492:
493: -- Standard call to get message count and if count is 1, get message info.
494: FND_MSG_PUB.Count_And_Get
495: (p_count => x_msg_count,
496: p_data => x_msg_data
497: );
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505: ROLLBACK TO UPDATE_Ae_Line_PVT;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: -- Standard call to get message count and if count=1, get the message
508: FND_MSG_PUB.Count_And_Get (
509: p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: ROLLBACK TO UPDATE_Ae_Line_PVT;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: -- Standard call to get message count and if count=1, get the message
518: FND_MSG_PUB.Count_And_Get (
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data
527: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
528: THEN
529: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
530: END IF;
531: -- Standard call to get message count and if count=1, get the message
532: FND_MSG_PUB.Count_And_Get (
533: p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data
554: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
555: l_object_version_number NUMBER;
556:
557: BEGIN
558: -- Standard Start of API savepoint
559: SAVEPOINT DELETE_Ae_Line_PVT;
560:
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
557: BEGIN
558: -- Standard Start of API savepoint
559: SAVEPOINT DELETE_Ae_Line_PVT;
560:
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
563: p_api_version_number,
564: l_api_name,
565: G_PKG_NAME)
596: --
597: -- End of API body
598: --
599:
600: -- Standard check for p_commit
601: IF FND_API.to_Boolean( p_commit )
602: THEN
603: COMMIT WORK;
604: END IF;
608: IF G_DEBUG THEN
609: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
610: END IF;
611:
612: -- Standard call to get message count and if count is 1, get message info.
613: FND_MSG_PUB.Count_And_Get
614: (p_count => x_msg_count,
615: p_data => x_msg_data
616: );
622:
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK TO DELETE_Ae_Line_PVT;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: -- Standard call to get message count and if count=1, get the message
627: FND_MSG_PUB.Count_And_Get (
628: p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data
632:
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: ROLLBACK TO DELETE_Ae_Line_PVT;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: -- Standard call to get message count and if count=1, get the message
637: FND_MSG_PUB.Count_And_Get (
638: p_encoded => FND_API.G_FALSE,
639: p_count => x_msg_count,
640: p_data => x_msg_data
646: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
647: THEN
648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
649: END IF;
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (
652: p_encoded => FND_API.G_FALSE,
653: p_count => x_msg_count,
654: p_data => x_msg_data
695: THEN
696: FND_MSG_PUB.initialize;
697: END IF;
698:
699: -- Standard call to check for call compatibility.
700: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
701: p_api_version_number,
702: l_api_name,
703: G_PKG_NAME)
746:
747: WHEN FND_API.G_EXC_ERROR THEN
748: ROLLBACK TO LOCK_Ae_Line_PVT;
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: -- Standard call to get message count and if count=1, get the message
751: FND_MSG_PUB.Count_And_Get (
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_msg_count,
754: p_data => x_msg_data
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: ROLLBACK TO LOCK_Ae_Line_PVT;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760: -- Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_msg_count,
764: p_data => x_msg_data
770: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
771: THEN
772: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
773: END IF;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data
1684: l_object_version_number NUMBER;
1685: l_ae_line_rec OZF_Ae_Line_PVT.ae_line_rec_type;
1686:
1687: BEGIN
1688: -- Standard Start of API savepoint
1689: SAVEPOINT VALIDATE_Ae_Line_;
1690:
1691: -- Standard call to check for call compatibility.
1692: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1687: BEGIN
1688: -- Standard Start of API savepoint
1689: SAVEPOINT VALIDATE_Ae_Line_;
1690:
1691: -- Standard call to check for call compatibility.
1692: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1693: p_api_version_number,
1694: l_api_name,
1695: G_PKG_NAME)
1752: IF G_DEBUG THEN
1753: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1754: END IF;
1755:
1756: -- Standard call to get message count and if count is 1, get message info.
1757: FND_MSG_PUB.Count_And_Get
1758: (p_count => x_msg_count,
1759: p_data => x_msg_data
1760: );
1766:
1767: WHEN FND_API.G_EXC_ERROR THEN
1768: ROLLBACK TO VALIDATE_Ae_Line_;
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: -- Standard call to get message count and if count=1, get the message
1771: FND_MSG_PUB.Count_And_Get (
1772: p_encoded => FND_API.G_FALSE,
1773: p_count => x_msg_count,
1774: p_data => x_msg_data
1776:
1777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1778: ROLLBACK TO VALIDATE_Ae_Line_;
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: -- Standard call to get message count and if count=1, get the message
1781: FND_MSG_PUB.Count_And_Get (
1782: p_encoded => FND_API.G_FALSE,
1783: p_count => x_msg_count,
1784: p_data => x_msg_data
1790: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1791: THEN
1792: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1793: END IF;
1794: -- Standard call to get message count and if count=1, get the message
1795: FND_MSG_PUB.Count_And_Get (
1796: p_encoded => FND_API.G_FALSE,
1797: p_count => x_msg_count,
1798: p_data => x_msg_data
1827: -- Debug Message
1828: IF G_DEBUG THEN
1829: OZF_UTILITY_PVT.debug_message('Private API: Validate_ae_line_rec');
1830: END IF;
1831: -- Standard call to get message count and if count is 1, get message info.
1832: FND_MSG_PUB.Count_And_Get
1833: (p_count => x_msg_count,
1834: p_data => x_msg_data
1835: );