[Home] [Help]
53: FROM OZF_CLAIM_LINES_HIST_ALL
54: WHERE CLAIM_LINE_HISTORY_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_Claim_Line_Hist_PVT;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_Claim_Line_Hist_PVT;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
62: p_api_version_number,
63: l_api_name,
64: G_PKG_NAME) THEN
247: END IF;
248: RAISE FND_API.g_exc_error;
249: END;
250:
251: -- Standard check for p_commit
252: IF FND_API.to_Boolean( p_commit )
253: THEN
254: COMMIT WORK;
255: END IF;
258: IF g_debug THEN
259: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
260: END IF;
261:
262: -- Standard call to get message count and if count is 1, get message info.
263: FND_MSG_PUB.Count_And_Get(
264: p_count => x_msg_count,
265: p_data => x_msg_data
266: );
272:
273: WHEN FND_API.G_EXC_ERROR THEN
274: ROLLBACK TO CREATE_Claim_Line_Hist_PVT;
275: x_return_status := FND_API.G_RET_STS_ERROR;
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
282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO CREATE_Claim_Line_Hist_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: -- Standard call to get message count and if count=1, get the message
287: FND_MSG_PUB.Count_And_Get (
288: p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
297: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
298: END IF;
299: -- Standard call to get message count and if count=1, get the message
300: FND_MSG_PUB.Count_And_Get(
301: p_encoded => FND_API.G_FALSE,
302: p_count => x_msg_count,
303: p_data => x_msg_data
341: FROM ozf_claim_lines_hist_all
342: WHERE claim_line_history_id = cv_claim_line_hist_id;
343:
344: BEGIN
345: -- Standard Start of API savepoint
346: SAVEPOINT UPDATE_Claim_Line_Hist_PVT;
347:
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
344: BEGIN
345: -- Standard Start of API savepoint
346: SAVEPOINT UPDATE_Claim_Line_Hist_PVT;
347:
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
350: p_api_version_number,
351: l_api_name,
352: G_PKG_NAME) THEN
516: END IF;
517: RAISE FND_API.g_exc_error;
518: END;
519:
520: -- Standard check for p_commit
521: IF FND_API.to_Boolean( p_commit ) THEN
522: COMMIT WORK;
523: END IF;
524:
526: IF g_debug THEN
527: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
528: END IF;
529:
530: -- Standard call to get message count and if count is 1, get message info.
531: FND_MSG_PUB.Count_And_Get(
532: p_count => x_msg_count,
533: p_data => x_msg_data
534: );
540:
541: WHEN FND_API.G_EXC_ERROR THEN
542: ROLLBACK TO UPDATE_Claim_Line_Hist_PVT;
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: -- Standard call to get message count and if count=1, get the message
545: FND_MSG_PUB.Count_And_Get (
546: p_encoded => FND_API.G_FALSE,
547: p_count => x_msg_count,
548: p_data => x_msg_data
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: ROLLBACK TO UPDATE_Claim_Line_Hist_PVT;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: -- Standard call to get message count and if count=1, get the message
555: FND_MSG_PUB.Count_And_Get(
556: p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count,
558: p_data => x_msg_data
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
565: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (
569: p_encoded => FND_API.G_FALSE,
570: p_count => x_msg_count,
571: p_data => x_msg_data
595: FROM ozf_claim_lines_hist_all
596: WHERE claim_line_history_id = cv_line_hist_id;
597:
598: BEGIN
599: -- Standard Start of API savepoint
600: SAVEPOINT DELETE_Claim_Line_Hist_PVT;
601:
602: -- Standard call to check for call compatibility.
603: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
598: BEGIN
599: -- Standard Start of API savepoint
600: SAVEPOINT DELETE_Claim_Line_Hist_PVT;
601:
602: -- Standard call to check for call compatibility.
603: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
604: p_api_version_number,
605: l_api_name,
606: G_PKG_NAME) THEN
653: END IF;
654: RAISE FND_API.g_exc_error;
655: END IF;
656:
657: -- Standard check for p_commit
658: IF FND_API.to_Boolean(p_commit) THEN
659: COMMIT WORK;
660: END IF;
661:
663: IF g_debug THEN
664: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
665: END IF;
666:
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count,
670: p_data => x_msg_data
671: );
677:
678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO DELETE_Claim_Line_Hist_PVT;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
687:
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: ROLLBACK TO DELETE_Claim_Line_Hist_PVT;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: -- Standard call to get message count and if count=1, get the message
692: FND_MSG_PUB.Count_And_Get (
693: p_encoded => FND_API.G_FALSE,
694: p_count => x_msg_count,
695: p_data => x_msg_data
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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
745: IF FND_API.to_Boolean( p_init_msg_list ) THEN
746: FND_MSG_PUB.initialize;
747: END IF;
748:
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
751: p_api_version_number,
752: l_api_name,
753: G_PKG_NAME) THEN
792:
793: WHEN FND_API.G_EXC_ERROR THEN
794: ROLLBACK TO LOCK_Claim_Line_Hist_PVT;
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: -- Standard call to get message count and if count=1, get the message
797: FND_MSG_PUB.Count_And_Get (
798: p_encoded => FND_API.G_FALSE,
799: p_count => x_msg_count,
800: p_data => x_msg_data
802:
803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO LOCK_Claim_Line_Hist_PVT;
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: -- Standard call to get message count and if count=1, get the message
807: FND_MSG_PUB.Count_And_Get (
808: p_encoded => FND_API.G_FALSE,
809: p_count => x_msg_count,
810: p_data => x_msg_data
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
817: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
818: END IF;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data
1837: l_object_version_number NUMBER;
1838: l_claim_line_hist_rec OZF_Claim_Line_Hist_PVT.claim_line_hist_rec_type;
1839:
1840: BEGIN
1841: -- Standard Start of API savepoint
1842: SAVEPOINT VALIDATE_Claim_Line_Hist_;
1843:
1844: -- Standard call to check for call compatibility.
1845: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
1840: BEGIN
1841: -- Standard Start of API savepoint
1842: SAVEPOINT VALIDATE_Claim_Line_Hist_;
1843:
1844: -- Standard call to check for call compatibility.
1845: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
1846: p_api_version_number,
1847: l_api_name,
1848: G_PKG_NAME) THEN
1902: IF g_debug THEN
1903: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1904: END IF;
1905:
1906: -- Standard call to get message count and if count is 1, get message info.
1907: FND_MSG_PUB.Count_And_Get(
1908: p_count => x_msg_count,
1909: p_data => x_msg_data
1910: );
1916:
1917: WHEN FND_API.G_EXC_ERROR THEN
1918: ROLLBACK TO VALIDATE_Claim_Line_Hist_;
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: -- Standard call to get message count and if count=1, get the message
1921: FND_MSG_PUB.Count_And_Get (
1922: p_encoded => FND_API.G_FALSE,
1923: p_count => x_msg_count,
1924: p_data => x_msg_data
1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1928: ROLLBACK TO VALIDATE_Claim_Line_Hist_;
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1930: -- Standard call to get message count and if count=1, get the message
1931: FND_MSG_PUB.Count_And_Get (
1932: p_encoded => FND_API.G_FALSE,
1933: p_count => x_msg_count,
1934: p_data => x_msg_data
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1941: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1942: END IF;
1943: -- Standard call to get message count and if count=1, get the message
1944: FND_MSG_PUB.Count_And_Get (
1945: p_encoded => FND_API.G_FALSE,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data
1976: -- Debug Message
1977: IF g_debug THEN
1978: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1979: END IF;
1980: -- Standard call to get message count and if count is 1, get message info.
1981: FND_MSG_PUB.Count_And_Get(
1982: p_count => x_msg_count,
1983: p_data => x_msg_data
1984: );