[Home] [Help]
42:
43:
44:
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT create_code_conversion_pvt;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT create_code_conversion_pvt;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
188: x_code_conversion_id_tbl(x_code_conversion_id_tbl.count) := l_code_conversion_id;
189:
190: end loop;
191:
192: -- Standard check for p_commit
193: IF FND_API.to_Boolean( p_commit )
194: THEN
195: COMMIT WORK;
196: END IF;
199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
200: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
201: END IF;
202:
203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get
205: (p_count => x_msg_count,
206: p_data => x_msg_data
207: );
217: END IF;
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO create_code_conversion_pvt;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: -- Standard call to get message count and if count=1, get the message
222: FND_MSG_PUB.Count_And_Get (
223: p_encoded => FND_API.G_FALSE,
224: p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO create_code_conversion_pvt;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: -- Standard call to get message count and if count=1, get the message
231: FND_MSG_PUB.Count_And_Get (
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,
234: p_data => x_msg_data
239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
242: END IF;
243: -- Standard call to get message count and if count=1, get the message
244: FND_MSG_PUB.Count_And_Get (
245: p_encoded => FND_API.G_FALSE,
246: p_count => x_msg_count,
247: p_data => x_msg_data
317: p_code_conversion_rec code_conversion_rec_type;
318:
319:
320: BEGIN
321: -- Standard Start of API savepoint
322: SAVEPOINT update_code_conversion_pvt;
323:
324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
320: BEGIN
321: -- Standard Start of API savepoint
322: SAVEPOINT update_code_conversion_pvt;
323:
324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
326: p_api_version_number,
327: l_api_name,
328: G_PKG_NAME)
596:
597: END LOOP;
598:
599:
600: -- Standard check for p_commit
601: IF FND_API.to_Boolean( p_commit )
602: THEN
603: COMMIT WORK;
604: END IF;
607: -- Debug Message
608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
609: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
610: END IF;
611: -- Standard call to get message count and if count is 1, get message info.
612: FND_MSG_PUB.Count_And_Get
613: (p_count => x_msg_count,
614: p_data => x_msg_data
615: );
616: EXCEPTION
617: WHEN FND_API.G_EXC_ERROR THEN
618: ROLLBACK TO update_code_conversion_pvt;
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: -- Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get (
622: p_encoded => FND_API.G_FALSE,
623: p_count => x_msg_count,
624: p_data => x_msg_data
625: );
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO update_code_conversion_pvt;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: -- Standard call to get message count and if count=1, get the message
630: FND_MSG_PUB.Count_And_Get (
631: p_encoded => FND_API.G_FALSE,
632: p_count => x_msg_count,
633: p_data => x_msg_data
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data
678: l_cc_cnt NUMBER := 0;
679: l_up_cnt NUMBER := 0;
680:
681: BEGIN
682: -- Standard Start of API savepoint
683: SAVEPOINT update_code_conversion_tbl_pvt;
684:
685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
686: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
686: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
687: END IF;
688:
689: -- Standard call to check for call compatibility.
690: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
691: p_api_version_number,
692: l_api_name,
693: G_PKG_NAME)
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: END IF;
804:
805: -- Standard check for p_commit
806: IF FND_API.to_Boolean( p_commit )
807: THEN
808: COMMIT WORK;
809: END IF;
811: -- Debug Message
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
813: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
814: END IF;
815: -- Standard call to get message count and if count is 1, get message info.
816: FND_MSG_PUB.Count_And_Get
817: (p_count => x_msg_count,
818: p_data => x_msg_data
819: );
820: EXCEPTION
821: WHEN FND_API.G_EXC_ERROR THEN
822: ROLLBACK TO update_code_conversion_tbl_pvt;
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: ROLLBACK TO update_code_conversion_tbl_pvt;
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: -- Standard call to get message count and if count=1, get the message
834: FND_MSG_PUB.Count_And_Get (
835: p_encoded => FND_API.G_FALSE,
836: p_count => x_msg_count,
837: p_data => x_msg_data
842: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
845: END IF;
846: -- Standard call to get message count and if count=1, get the message
847: FND_MSG_PUB.Count_And_Get (
848: p_encoded => FND_API.G_FALSE,
849: p_count => x_msg_count,
850: p_data => x_msg_data
875: l_object_version_number NUMBER;
876:
877:
878: BEGIN
879: -- Standard Start of API savepoint
880: SAVEPOINT delete_code_conversion_tbl_pvt;
881:
882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
883: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
883: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
884: END IF;
885:
886: -- Standard call to check for call compatibility.
887: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
888: p_api_version_number,
889: l_api_name,
890: G_PKG_NAME)
979:
980: END LOOP;
981:
982:
983: -- Standard check for p_commit
984: IF FND_API.to_Boolean( p_commit )
985: THEN
986: COMMIT WORK;
987: END IF;
989: -- Debug Message
990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
991: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
992: END IF;
993: -- Standard call to get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get
995: (p_count => x_msg_count,
996: p_data => x_msg_data
997: );
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO delete_code_conversion_tbl_pvt;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: -- Standard call to get message count and if count=1, get the message
1003: FND_MSG_PUB.Count_And_Get (
1004: p_encoded => FND_API.G_FALSE,
1005: p_count => x_msg_count,
1006: p_data => x_msg_data
1007: );
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO delete_code_conversion_tbl_pvt;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1142: FROM ozf_resale_adjustments lin
1143: WHERE orig_system_agreement_uom = cv_external_code;
1144:
1145: BEGIN
1146: -- Standard Start of API savepoint
1147: SAVEPOINT delete_code_conversion_pvt;
1148:
1149: -- Standard call to check for call compatibility.
1150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1145: BEGIN
1146: -- Standard Start of API savepoint
1147: SAVEPOINT delete_code_conversion_pvt;
1148:
1149: -- Standard call to check for call compatibility.
1150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1151: p_api_version_number,
1152: l_api_name,
1153: G_PKG_NAME)
1586: WHEN OTHERS THEN
1587: RAISE FND_API.G_EXC_ERROR;
1588: END;
1589:
1590: -- Standard check for p_commit
1591: IF FND_API.to_Boolean( p_commit )
1592: THEN
1593: COMMIT WORK;
1594: END IF;
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1598: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1599: END IF;
1600:
1601: -- Standard call to get message count and if count is 1, get message info.
1602: FND_MSG_PUB.Count_And_Get
1603: (p_count => x_msg_count,
1604: p_data => x_msg_data
1605: );
1606: EXCEPTION
1607: WHEN FND_API.G_EXC_ERROR THEN
1608: ROLLBACK TO delete_code_conversion_pvt;
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: -- Standard call to get message count and if count=1, get the message
1611: FND_MSG_PUB.Count_And_Get (
1612: p_encoded => FND_API.G_FALSE,
1613: p_count => x_msg_count,
1614: p_data => x_msg_data
1615: );
1616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1617: ROLLBACK TO delete_code_conversion_pvt;
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1619: -- Standard call to get message count and if count=1, get the message
1620: FND_MSG_PUB.Count_And_Get (
1621: p_encoded => FND_API.G_FALSE,
1622: p_count => x_msg_count,
1623: p_data => x_msg_data
1628: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1992: l_code_conversion_rec code_conversion_rec_type ;
1993:
1994:
1995: BEGIN
1996: -- Standard Start of API savepoint
1997: SAVEPOINT validate_code_conversion_pvt;
1998:
1999: -- Standard call to check for call compatibility.
2000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1995: BEGIN
1996: -- Standard Start of API savepoint
1997: SAVEPOINT validate_code_conversion_pvt;
1998:
1999: -- Standard call to check for call compatibility.
2000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2001: p_api_version_number,
2002: l_api_name,
2003: G_PKG_NAME)
2046:
2047: END IF;
2048: -- Initialize API return status to SUCCESS
2049: x_return_status := FND_API.G_RET_STS_SUCCESS;
2050: -- Standard call to get message count and if count is 1, get message info.
2051: FND_MSG_PUB.Count_And_Get
2052: (p_count => x_msg_count,
2053: p_data => x_msg_data
2054: );
2061: END IF;
2062: WHEN FND_API.G_EXC_ERROR THEN
2063: ROLLBACK TO validate_code_conversion_pvt;
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: -- Standard call to get message count and if count=1, get the message
2066: FND_MSG_PUB.Count_And_Get (
2067: p_encoded => FND_API.G_FALSE,
2068: p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );
2071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2072: ROLLBACK TO validate_code_conversion_pvt;
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: -- Standard call to get message count and if count=1, get the message
2075: FND_MSG_PUB.Count_And_Get (
2076: p_encoded => FND_API.G_FALSE,
2077: p_count => x_msg_count,
2078: p_data => x_msg_data
2083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2084: THEN
2085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2086: END IF;
2087: -- Standard call to get message count and if count=1, get the message
2088: FND_MSG_PUB.Count_And_Get (
2089: p_encoded => FND_API.G_FALSE,
2090: p_count => x_msg_count,
2091: p_data => x_msg_data
2222: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2223: THEN
2224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2225: END IF;
2226: -- Standard call to get message count and if count=1, get the message
2227: FND_MSG_PUB.Count_And_Get (
2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data
2515: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2516: THEN
2517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2518: END IF;
2519: -- Standard call to get message count and if count=1, get the message
2520: FND_MSG_PUB.Count_And_Get (
2521: p_encoded => FND_API.G_FALSE,
2522: p_count => x_msg_count,
2523: p_data => x_msg_data
2602: l_supp_code_conversion_rec supp_code_conversion_rec_type ;
2603:
2604:
2605: BEGIN
2606: -- Standard Start of API savepoint
2607: SAVEPOINT validate_supp_code_conv_pvt;
2608:
2609: -- Standard call to check for call compatibility.
2610: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2605: BEGIN
2606: -- Standard Start of API savepoint
2607: SAVEPOINT validate_supp_code_conv_pvt;
2608:
2609: -- Standard call to check for call compatibility.
2610: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2611: p_api_version_number,
2612: l_api_name,
2613: G_PKG_NAME)
2655:
2656: END IF;
2657: -- Initialize API return status to SUCCESS
2658: x_return_status := FND_API.G_RET_STS_SUCCESS;
2659: -- Standard call to get message count and if count is 1, get message info.
2660: FND_MSG_PUB.Count_And_Get
2661: (p_count => x_msg_count,
2662: p_data => x_msg_data
2663: );
2670: END IF;
2671: WHEN FND_API.G_EXC_ERROR THEN
2672: ROLLBACK TO validate_supp_code_conv_pvt;
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674: -- Standard call to get message count and if count=1, get the message
2675: FND_MSG_PUB.Count_And_Get (
2676: p_encoded => FND_API.G_FALSE,
2677: p_count => x_msg_count,
2678: p_data => x_msg_data
2679: );
2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: ROLLBACK TO validate_supp_code_conv_pvt;
2682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2683: -- Standard call to get message count and if count=1, get the message
2684: FND_MSG_PUB.Count_And_Get (
2685: p_encoded => FND_API.G_FALSE,
2686: p_count => x_msg_count,
2687: p_data => x_msg_data
2692: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2693: THEN
2694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2695: END IF;
2696: -- Standard call to get message count and if count=1, get the message
2697: FND_MSG_PUB.Count_And_Get (
2698: p_encoded => FND_API.G_FALSE,
2699: p_count => x_msg_count,
2700: p_data => x_msg_data
2725:
2726:
2727:
2728: BEGIN
2729: -- Standard Start of API savepoint
2730: SAVEPOINT create_supp_code_conv_pvt;
2731:
2732: -- Standard call to check for call compatibility.
2733: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2728: BEGIN
2729: -- Standard Start of API savepoint
2730: SAVEPOINT create_supp_code_conv_pvt;
2731:
2732: -- Standard call to check for call compatibility.
2733: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2734: p_api_version_number,
2735: l_api_name,
2736: G_PKG_NAME)
2870: x_supp_code_conversion_id_tbl(x_supp_code_conversion_id_tbl.count) := l_code_conversion_id;
2871:
2872: end loop;
2873:
2874: -- Standard check for p_commit
2875: IF FND_API.to_Boolean( p_commit )
2876: THEN
2877: COMMIT WORK;
2878: END IF;
2881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2882: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2883: END IF;
2884:
2885: -- Standard call to get message count and if count is 1, get message info.
2886: FND_MSG_PUB.Count_And_Get
2887: (p_count => x_msg_count,
2888: p_data => x_msg_data
2889: );
2899: END IF;
2900: WHEN FND_API.G_EXC_ERROR THEN
2901: ROLLBACK TO create_supp_code_conv_pvt;
2902: x_return_status := FND_API.G_RET_STS_ERROR;
2903: -- Standard call to get message count and if count=1, get the message
2904: FND_MSG_PUB.Count_And_Get (
2905: p_encoded => FND_API.G_FALSE,
2906: p_count => x_msg_count,
2907: p_data => x_msg_data
2908: );
2909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2910: ROLLBACK TO create_code_conversion_pvt;
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912: -- Standard call to get message count and if count=1, get the message
2913: FND_MSG_PUB.Count_And_Get (
2914: p_encoded => FND_API.G_FALSE,
2915: p_count => x_msg_count,
2916: p_data => x_msg_data
2921: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2922: THEN
2923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2924: END IF;
2925: -- Standard call to get message count and if count=1, get the message
2926: FND_MSG_PUB.Count_And_Get (
2927: p_encoded => FND_API.G_FALSE,
2928: p_count => x_msg_count,
2929: p_data => x_msg_data
2998: p_supp_code_conversion_rec supp_code_conversion_rec_type;
2999:
3000:
3001: BEGIN
3002: -- Standard Start of API savepoint
3003: SAVEPOINT update_supp_code_conv_pvt;
3004:
3005: -- Standard call to check for call compatibility.
3006: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3001: BEGIN
3002: -- Standard Start of API savepoint
3003: SAVEPOINT update_supp_code_conv_pvt;
3004:
3005: -- Standard call to check for call compatibility.
3006: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3007: p_api_version_number,
3008: l_api_name,
3009: G_PKG_NAME)
3276:
3277: END LOOP;
3278:
3279:
3280: -- Standard check for p_commit
3281: IF FND_API.to_Boolean( p_commit )
3282: THEN
3283: COMMIT WORK;
3284: END IF;
3287: -- Debug Message
3288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3289: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3290: END IF;
3291: -- Standard call to get message count and if count is 1, get message info.
3292: FND_MSG_PUB.Count_And_Get
3293: (p_count => x_msg_count,
3294: p_data => x_msg_data
3295: );
3296: EXCEPTION
3297: WHEN FND_API.G_EXC_ERROR THEN
3298: ROLLBACK TO update_supp_code_conv_pvt;
3299: x_return_status := FND_API.G_RET_STS_ERROR;
3300: -- Standard call to get message count and if count=1, get the message
3301: FND_MSG_PUB.Count_And_Get (
3302: p_encoded => FND_API.G_FALSE,
3303: p_count => x_msg_count,
3304: p_data => x_msg_data
3305: );
3306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3307: ROLLBACK TO update_supp_code_conv_pvt;
3308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3309: -- Standard call to get message count and if count=1, get the message
3310: FND_MSG_PUB.Count_And_Get (
3311: p_encoded => FND_API.G_FALSE,
3312: p_count => x_msg_count,
3313: p_data => x_msg_data
3318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3319: THEN
3320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3321: END IF;
3322: -- Standard call to get message count and if count=1, get the message
3323: FND_MSG_PUB.Count_And_Get (
3324: p_encoded => FND_API.G_FALSE,
3325: p_count => x_msg_count,
3326: p_data => x_msg_data
3358: l_cc_cnt NUMBER := 0;
3359: l_up_cnt NUMBER := 0;
3360:
3361: BEGIN
3362: -- Standard Start of API savepoint
3363: SAVEPOINT update_supp_code_conv_tbl_pvt;
3364:
3365: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3366: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3365: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3366: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3367: END IF;
3368:
3369: -- Standard call to check for call compatibility.
3370: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3371: p_api_version_number,
3372: l_api_name,
3373: G_PKG_NAME)
3481: RAISE FND_API.G_EXC_ERROR;
3482: END IF;
3483: END IF;
3484:
3485: -- Standard check for p_commit
3486: IF FND_API.to_Boolean( p_commit )
3487: THEN
3488: COMMIT WORK;
3489: END IF;
3491: -- Debug Message
3492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3493: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3494: END IF;
3495: -- Standard call to get message count and if count is 1, get message info.
3496: FND_MSG_PUB.Count_And_Get
3497: (p_count => x_msg_count,
3498: p_data => x_msg_data
3499: );
3500: EXCEPTION
3501: WHEN FND_API.G_EXC_ERROR THEN
3502: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3503: x_return_status := FND_API.G_RET_STS_ERROR;
3504: -- Standard call to get message count and if count=1, get the message
3505: FND_MSG_PUB.Count_And_Get (
3506: p_encoded => FND_API.G_FALSE,
3507: p_count => x_msg_count,
3508: p_data => x_msg_data
3509: );
3510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3511: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3513: -- Standard call to get message count and if count=1, get the message
3514: FND_MSG_PUB.Count_And_Get (
3515: p_encoded => FND_API.G_FALSE,
3516: p_count => x_msg_count,
3517: p_data => x_msg_data
3522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3523: THEN
3524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3525: END IF;
3526: -- Standard call to get message count and if count=1, get the message
3527: FND_MSG_PUB.Count_And_Get (
3528: p_encoded => FND_API.G_FALSE,
3529: p_count => x_msg_count,
3530: p_data => x_msg_data
3555: l_object_version_number NUMBER;
3556:
3557:
3558: BEGIN
3559: -- Standard Start of API savepoint
3560: SAVEPOINT delete_supp_code_conv_tbl_pvt;
3561:
3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3563: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3563: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3564: END IF;
3565:
3566: -- Standard call to check for call compatibility.
3567: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3568: p_api_version_number,
3569: l_api_name,
3570: G_PKG_NAME)
3644:
3645: END LOOP;
3646:
3647:
3648: -- Standard check for p_commit
3649: IF FND_API.to_Boolean( p_commit )
3650: THEN
3651: COMMIT WORK;
3652: END IF;
3654: -- Debug Message
3655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3656: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3657: END IF;
3658: -- Standard call to get message count and if count is 1, get message info.
3659: FND_MSG_PUB.Count_And_Get
3660: (p_count => x_msg_count,
3661: p_data => x_msg_data
3662: );
3663: EXCEPTION
3664: WHEN FND_API.G_EXC_ERROR THEN
3665: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3666: x_return_status := FND_API.G_RET_STS_ERROR;
3667: -- Standard call to get message count and if count=1, get the message
3668: FND_MSG_PUB.Count_And_Get (
3669: p_encoded => FND_API.G_FALSE,
3670: p_count => x_msg_count,
3671: p_data => x_msg_data
3672: );
3673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3674: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3676: -- Standard call to get message count and if count=1, get the message
3677: FND_MSG_PUB.Count_And_Get (
3678: p_encoded => FND_API.G_FALSE,
3679: p_count => x_msg_count,
3680: p_data => x_msg_data
3685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3686: THEN
3687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3688: END IF;
3689: -- Standard call to get message count and if count=1, get the message
3690: FND_MSG_PUB.Count_And_Get (
3691: p_encoded => FND_API.G_FALSE,
3692: p_count => x_msg_count,
3693: p_data => x_msg_data
3718:
3719: l_dummy NUMBER;
3720:
3721: BEGIN
3722: -- Standard Start of API savepoint
3723: SAVEPOINT delete_supp_code_conv_pvt;
3724:
3725: -- Standard call to check for call compatibility.
3726: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3721: BEGIN
3722: -- Standard Start of API savepoint
3723: SAVEPOINT delete_supp_code_conv_pvt;
3724:
3725: -- Standard call to check for call compatibility.
3726: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3727: p_api_version_number,
3728: l_api_name,
3729: G_PKG_NAME)
3763: WHEN OTHERS THEN
3764: RAISE FND_API.G_EXC_ERROR;
3765: END;
3766:
3767: -- Standard check for p_commit
3768: IF FND_API.to_Boolean( p_commit )
3769: THEN
3770: COMMIT WORK;
3771: END IF;
3774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3775: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3776: END IF;
3777:
3778: -- Standard call to get message count and if count is 1, get message info.
3779: FND_MSG_PUB.Count_And_Get
3780: (p_count => x_msg_count,
3781: p_data => x_msg_data
3782: );
3783: EXCEPTION
3784: WHEN FND_API.G_EXC_ERROR THEN
3785: ROLLBACK TO delete_supp_code_conv_pvt;
3786: x_return_status := FND_API.G_RET_STS_ERROR;
3787: -- Standard call to get message count and if count=1, get the message
3788: FND_MSG_PUB.Count_And_Get (
3789: p_encoded => FND_API.G_FALSE,
3790: p_count => x_msg_count,
3791: p_data => x_msg_data
3792: );
3793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3794: ROLLBACK TO delete_supp_code_conv_pvt;
3795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3796: -- Standard call to get message count and if count=1, get the message
3797: FND_MSG_PUB.Count_And_Get (
3798: p_encoded => FND_API.G_FALSE,
3799: p_count => x_msg_count,
3800: p_data => x_msg_data
3805: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3806: THEN
3807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3808: END IF;
3809: -- Standard call to get message count and if count=1, get the message
3810: FND_MSG_PUB.Count_And_Get (
3811: p_encoded => FND_API.G_FALSE,
3812: p_count => x_msg_count,
3813: p_data => x_msg_data