[Home] [Help]
44:
45:
46:
47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT create_code_conversion_pvt;
50:
51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT create_code_conversion_pvt;
50:
51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
53: p_api_version_number,
54: l_api_name,
55: G_PKG_NAME)
201: x_code_conversion_id_tbl(x_code_conversion_id_tbl.count) := l_code_conversion_id;
202:
203: end loop;
204:
205: -- Standard check for p_commit
206: IF FND_API.to_Boolean( p_commit )
207: THEN
208: COMMIT WORK;
209: END IF;
212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
213: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
214: END IF;
215:
216: -- Standard call to get message count and if count is 1, get message info.
217: FND_MSG_PUB.Count_And_Get
218: (p_count => x_msg_count,
219: p_data => x_msg_data
220: );
230: END IF;
231: WHEN FND_API.G_EXC_ERROR THEN
232: ROLLBACK TO create_code_conversion_pvt;
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: -- Standard call to get message count and if count=1, get the message
235: FND_MSG_PUB.Count_And_Get (
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO create_code_conversion_pvt;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
252: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
255: END IF;
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
330: p_code_conversion_rec code_conversion_rec_type;
331:
332:
333: BEGIN
334: -- Standard Start of API savepoint
335: SAVEPOINT update_code_conversion_pvt;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
333: BEGIN
334: -- Standard Start of API savepoint
335: SAVEPOINT update_code_conversion_pvt;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
339: p_api_version_number,
340: l_api_name,
341: G_PKG_NAME)
609:
610: END LOOP;
611:
612:
613: -- Standard check for p_commit
614: IF FND_API.to_Boolean( p_commit )
615: THEN
616: COMMIT WORK;
617: END IF;
620: -- Debug Message
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
622: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
623: END IF;
624: -- Standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get
626: (p_count => x_msg_count,
627: p_data => x_msg_data
628: );
629: EXCEPTION
630: WHEN FND_API.G_EXC_ERROR THEN
631: ROLLBACK TO update_code_conversion_pvt;
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO update_code_conversion_pvt;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
651: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
652: THEN
653: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
654: END IF;
655: -- Standard call to get message count and if count=1, get the message
656: FND_MSG_PUB.Count_And_Get (
657: p_encoded => FND_API.G_FALSE,
658: p_count => x_msg_count,
659: p_data => x_msg_data
691: l_cc_cnt NUMBER := 0;
692: l_up_cnt NUMBER := 0;
693:
694: BEGIN
695: -- Standard Start of API savepoint
696: SAVEPOINT update_code_conversion_tbl_pvt;
697:
698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
699: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
699: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
700: END IF;
701:
702: -- Standard call to check for call compatibility.
703: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
704: p_api_version_number,
705: l_api_name,
706: G_PKG_NAME)
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816: END IF;
817:
818: -- Standard check for p_commit
819: IF FND_API.to_Boolean( p_commit )
820: THEN
821: COMMIT WORK;
822: END IF;
824: -- Debug Message
825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
826: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
827: END IF;
828: -- Standard call to get message count and if count is 1, get message info.
829: FND_MSG_PUB.Count_And_Get
830: (p_count => x_msg_count,
831: p_data => x_msg_data
832: );
833: EXCEPTION
834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO update_code_conversion_tbl_pvt;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: -- Standard call to get message count and if count=1, get the message
838: FND_MSG_PUB.Count_And_Get (
839: p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,
841: p_data => x_msg_data
842: );
843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
844: ROLLBACK TO update_code_conversion_tbl_pvt;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
855: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
858: END IF;
859: -- Standard call to get message count and if count=1, get the message
860: FND_MSG_PUB.Count_And_Get (
861: p_encoded => FND_API.G_FALSE,
862: p_count => x_msg_count,
863: p_data => x_msg_data
888: l_object_version_number NUMBER;
889:
890:
891: BEGIN
892: -- Standard Start of API savepoint
893: SAVEPOINT delete_code_conversion_tbl_pvt;
894:
895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
896: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
896: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
897: END IF;
898:
899: -- Standard call to check for call compatibility.
900: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
901: p_api_version_number,
902: l_api_name,
903: G_PKG_NAME)
992:
993: END LOOP;
994:
995:
996: -- Standard check for p_commit
997: IF FND_API.to_Boolean( p_commit )
998: THEN
999: COMMIT WORK;
1000: END IF;
1002: -- Debug Message
1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1004: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1005: END IF;
1006: -- Standard call to get message count and if count is 1, get message info.
1007: FND_MSG_PUB.Count_And_Get
1008: (p_count => x_msg_count,
1009: p_data => x_msg_data
1010: );
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_ERROR THEN
1013: ROLLBACK TO delete_code_conversion_tbl_pvt;
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: -- Standard call to get message count and if count=1, get the message
1016: FND_MSG_PUB.Count_And_Get (
1017: p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );
1021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1022: ROLLBACK TO delete_code_conversion_tbl_pvt;
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
1033: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1036: END IF;
1037: -- Standard call to get message count and if count=1, get the message
1038: FND_MSG_PUB.Count_And_Get (
1039: p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data
1155: FROM ozf_resale_adjustments lin
1156: WHERE orig_system_agreement_uom = cv_external_code;
1157:
1158: BEGIN
1159: -- Standard Start of API savepoint
1160: SAVEPOINT delete_code_conversion_pvt;
1161:
1162: -- Standard call to check for call compatibility.
1163: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1158: BEGIN
1159: -- Standard Start of API savepoint
1160: SAVEPOINT delete_code_conversion_pvt;
1161:
1162: -- Standard call to check for call compatibility.
1163: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1164: p_api_version_number,
1165: l_api_name,
1166: G_PKG_NAME)
1599: WHEN OTHERS THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END;
1602:
1603: -- Standard check for p_commit
1604: IF FND_API.to_Boolean( p_commit )
1605: THEN
1606: COMMIT WORK;
1607: END IF;
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1611: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1612: END IF;
1613:
1614: -- Standard call to get message count and if count is 1, get message info.
1615: FND_MSG_PUB.Count_And_Get
1616: (p_count => x_msg_count,
1617: p_data => x_msg_data
1618: );
1619: EXCEPTION
1620: WHEN FND_API.G_EXC_ERROR THEN
1621: ROLLBACK TO delete_code_conversion_pvt;
1622: x_return_status := FND_API.G_RET_STS_ERROR;
1623: -- Standard call to get message count and if count=1, get the message
1624: FND_MSG_PUB.Count_And_Get (
1625: p_encoded => FND_API.G_FALSE,
1626: p_count => x_msg_count,
1627: p_data => x_msg_data
1628: );
1629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1630: ROLLBACK TO delete_code_conversion_pvt;
1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
1641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1642: THEN
1643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1644: END IF;
1645: -- Standard call to get message count and if count=1, get the message
1646: FND_MSG_PUB.Count_And_Get (
1647: p_encoded => FND_API.G_FALSE,
1648: p_count => x_msg_count,
1649: p_data => x_msg_data
2023: l_code_conversion_rec code_conversion_rec_type ;
2024:
2025:
2026: BEGIN
2027: -- Standard Start of API savepoint
2028: SAVEPOINT validate_code_conversion_pvt;
2029:
2030: -- Standard call to check for call compatibility.
2031: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2026: BEGIN
2027: -- Standard Start of API savepoint
2028: SAVEPOINT validate_code_conversion_pvt;
2029:
2030: -- Standard call to check for call compatibility.
2031: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2032: p_api_version_number,
2033: l_api_name,
2034: G_PKG_NAME)
2077:
2078: END IF;
2079: -- Initialize API return status to SUCCESS
2080: x_return_status := FND_API.G_RET_STS_SUCCESS;
2081: -- Standard call to get message count and if count is 1, get message info.
2082: FND_MSG_PUB.Count_And_Get
2083: (p_count => x_msg_count,
2084: p_data => x_msg_data
2085: );
2092: END IF;
2093: WHEN FND_API.G_EXC_ERROR THEN
2094: ROLLBACK TO validate_code_conversion_pvt;
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096: -- Standard call to get message count and if count=1, get the message
2097: FND_MSG_PUB.Count_And_Get (
2098: p_encoded => FND_API.G_FALSE,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data
2101: );
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2103: ROLLBACK TO validate_code_conversion_pvt;
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2105: -- Standard call to get message count and if count=1, get the message
2106: FND_MSG_PUB.Count_And_Get (
2107: p_encoded => FND_API.G_FALSE,
2108: p_count => x_msg_count,
2109: p_data => x_msg_data
2114: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2115: THEN
2116: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2117: END IF;
2118: -- Standard call to get message count and if count=1, get the message
2119: FND_MSG_PUB.Count_And_Get (
2120: p_encoded => FND_API.G_FALSE,
2121: p_count => x_msg_count,
2122: p_data => x_msg_data
2253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2254: THEN
2255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2256: END IF;
2257: -- Standard call to get message count and if count=1, get the message
2258: FND_MSG_PUB.Count_And_Get (
2259: p_encoded => FND_API.G_FALSE,
2260: p_count => x_msg_count,
2261: p_data => x_msg_data
2546: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2547: THEN
2548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2549: END IF;
2550: -- Standard call to get message count and if count=1, get the message
2551: FND_MSG_PUB.Count_And_Get (
2552: p_encoded => FND_API.G_FALSE,
2553: p_count => x_msg_count,
2554: p_data => x_msg_data
2633: l_supp_code_conversion_rec supp_code_conversion_rec_type ;
2634:
2635:
2636: BEGIN
2637: -- Standard Start of API savepoint
2638: SAVEPOINT validate_supp_code_conv_pvt;
2639:
2640: -- Standard call to check for call compatibility.
2641: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2636: BEGIN
2637: -- Standard Start of API savepoint
2638: SAVEPOINT validate_supp_code_conv_pvt;
2639:
2640: -- Standard call to check for call compatibility.
2641: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2642: p_api_version_number,
2643: l_api_name,
2644: G_PKG_NAME)
2686:
2687: END IF;
2688: -- Initialize API return status to SUCCESS
2689: x_return_status := FND_API.G_RET_STS_SUCCESS;
2690: -- Standard call to get message count and if count is 1, get message info.
2691: FND_MSG_PUB.Count_And_Get
2692: (p_count => x_msg_count,
2693: p_data => x_msg_data
2694: );
2701: END IF;
2702: WHEN FND_API.G_EXC_ERROR THEN
2703: ROLLBACK TO validate_supp_code_conv_pvt;
2704: x_return_status := FND_API.G_RET_STS_ERROR;
2705: -- Standard call to get message count and if count=1, get the message
2706: FND_MSG_PUB.Count_And_Get (
2707: p_encoded => FND_API.G_FALSE,
2708: p_count => x_msg_count,
2709: p_data => x_msg_data
2710: );
2711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2712: ROLLBACK TO validate_supp_code_conv_pvt;
2713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2714: -- Standard call to get message count and if count=1, get the message
2715: FND_MSG_PUB.Count_And_Get (
2716: p_encoded => FND_API.G_FALSE,
2717: p_count => x_msg_count,
2718: p_data => x_msg_data
2723: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2724: THEN
2725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2726: END IF;
2727: -- Standard call to get message count and if count=1, get the message
2728: FND_MSG_PUB.Count_And_Get (
2729: p_encoded => FND_API.G_FALSE,
2730: p_count => x_msg_count,
2731: p_data => x_msg_data
2756:
2757:
2758:
2759: BEGIN
2760: -- Standard Start of API savepoint
2761: SAVEPOINT create_supp_code_conv_pvt;
2762:
2763: -- Standard call to check for call compatibility.
2764: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2759: BEGIN
2760: -- Standard Start of API savepoint
2761: SAVEPOINT create_supp_code_conv_pvt;
2762:
2763: -- Standard call to check for call compatibility.
2764: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2765: p_api_version_number,
2766: l_api_name,
2767: G_PKG_NAME)
2901: x_supp_code_conversion_id_tbl(x_supp_code_conversion_id_tbl.count) := l_code_conversion_id;
2902:
2903: end loop;
2904:
2905: -- Standard check for p_commit
2906: IF FND_API.to_Boolean( p_commit )
2907: THEN
2908: COMMIT WORK;
2909: END IF;
2912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2913: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2914: END IF;
2915:
2916: -- Standard call to get message count and if count is 1, get message info.
2917: FND_MSG_PUB.Count_And_Get
2918: (p_count => x_msg_count,
2919: p_data => x_msg_data
2920: );
2930: END IF;
2931: WHEN FND_API.G_EXC_ERROR THEN
2932: ROLLBACK TO create_supp_code_conv_pvt;
2933: x_return_status := FND_API.G_RET_STS_ERROR;
2934: -- Standard call to get message count and if count=1, get the message
2935: FND_MSG_PUB.Count_And_Get (
2936: p_encoded => FND_API.G_FALSE,
2937: p_count => x_msg_count,
2938: p_data => x_msg_data
2939: );
2940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2941: ROLLBACK TO create_code_conversion_pvt;
2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2943: -- Standard call to get message count and if count=1, get the message
2944: FND_MSG_PUB.Count_And_Get (
2945: p_encoded => FND_API.G_FALSE,
2946: p_count => x_msg_count,
2947: p_data => x_msg_data
2952: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2953: THEN
2954: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2955: END IF;
2956: -- Standard call to get message count and if count=1, get the message
2957: FND_MSG_PUB.Count_And_Get (
2958: p_encoded => FND_API.G_FALSE,
2959: p_count => x_msg_count,
2960: p_data => x_msg_data
3029: p_supp_code_conversion_rec supp_code_conversion_rec_type;
3030:
3031:
3032: BEGIN
3033: -- Standard Start of API savepoint
3034: SAVEPOINT update_supp_code_conv_pvt;
3035:
3036: -- Standard call to check for call compatibility.
3037: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3032: BEGIN
3033: -- Standard Start of API savepoint
3034: SAVEPOINT update_supp_code_conv_pvt;
3035:
3036: -- Standard call to check for call compatibility.
3037: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3038: p_api_version_number,
3039: l_api_name,
3040: G_PKG_NAME)
3307:
3308: END LOOP;
3309:
3310:
3311: -- Standard check for p_commit
3312: IF FND_API.to_Boolean( p_commit )
3313: THEN
3314: COMMIT WORK;
3315: END IF;
3318: -- Debug Message
3319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3320: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3321: END IF;
3322: -- Standard call to get message count and if count is 1, get message info.
3323: FND_MSG_PUB.Count_And_Get
3324: (p_count => x_msg_count,
3325: p_data => x_msg_data
3326: );
3327: EXCEPTION
3328: WHEN FND_API.G_EXC_ERROR THEN
3329: ROLLBACK TO update_supp_code_conv_pvt;
3330: x_return_status := FND_API.G_RET_STS_ERROR;
3331: -- Standard call to get message count and if count=1, get the message
3332: FND_MSG_PUB.Count_And_Get (
3333: p_encoded => FND_API.G_FALSE,
3334: p_count => x_msg_count,
3335: p_data => x_msg_data
3336: );
3337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3338: ROLLBACK TO update_supp_code_conv_pvt;
3339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3340: -- Standard call to get message count and if count=1, get the message
3341: FND_MSG_PUB.Count_And_Get (
3342: p_encoded => FND_API.G_FALSE,
3343: p_count => x_msg_count,
3344: p_data => x_msg_data
3349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3350: THEN
3351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3352: END IF;
3353: -- Standard call to get message count and if count=1, get the message
3354: FND_MSG_PUB.Count_And_Get (
3355: p_encoded => FND_API.G_FALSE,
3356: p_count => x_msg_count,
3357: p_data => x_msg_data
3389: l_cc_cnt NUMBER := 0;
3390: l_up_cnt NUMBER := 0;
3391:
3392: BEGIN
3393: -- Standard Start of API savepoint
3394: SAVEPOINT update_supp_code_conv_tbl_pvt;
3395:
3396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3397: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3397: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3398: END IF;
3399:
3400: -- Standard call to check for call compatibility.
3401: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3402: p_api_version_number,
3403: l_api_name,
3404: G_PKG_NAME)
3512: RAISE FND_API.G_EXC_ERROR;
3513: END IF;
3514: END IF;
3515:
3516: -- Standard check for p_commit
3517: IF FND_API.to_Boolean( p_commit )
3518: THEN
3519: COMMIT WORK;
3520: END IF;
3522: -- Debug Message
3523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3524: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3525: END IF;
3526: -- Standard call to get message count and if count is 1, get message info.
3527: FND_MSG_PUB.Count_And_Get
3528: (p_count => x_msg_count,
3529: p_data => x_msg_data
3530: );
3531: EXCEPTION
3532: WHEN FND_API.G_EXC_ERROR THEN
3533: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3534: x_return_status := FND_API.G_RET_STS_ERROR;
3535: -- Standard call to get message count and if count=1, get the message
3536: FND_MSG_PUB.Count_And_Get (
3537: p_encoded => FND_API.G_FALSE,
3538: p_count => x_msg_count,
3539: p_data => x_msg_data
3540: );
3541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3542: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3544: -- Standard call to get message count and if count=1, get the message
3545: FND_MSG_PUB.Count_And_Get (
3546: p_encoded => FND_API.G_FALSE,
3547: p_count => x_msg_count,
3548: p_data => x_msg_data
3553: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3554: THEN
3555: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3556: END IF;
3557: -- Standard call to get message count and if count=1, get the message
3558: FND_MSG_PUB.Count_And_Get (
3559: p_encoded => FND_API.G_FALSE,
3560: p_count => x_msg_count,
3561: p_data => x_msg_data
3586: l_object_version_number NUMBER;
3587:
3588:
3589: BEGIN
3590: -- Standard Start of API savepoint
3591: SAVEPOINT delete_supp_code_conv_tbl_pvt;
3592:
3593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3594: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3594: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3595: END IF;
3596:
3597: -- Standard call to check for call compatibility.
3598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3599: p_api_version_number,
3600: l_api_name,
3601: G_PKG_NAME)
3675:
3676: END LOOP;
3677:
3678:
3679: -- Standard check for p_commit
3680: IF FND_API.to_Boolean( p_commit )
3681: THEN
3682: COMMIT WORK;
3683: END IF;
3685: -- Debug Message
3686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3687: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3688: END IF;
3689: -- Standard call to get message count and if count is 1, get message info.
3690: FND_MSG_PUB.Count_And_Get
3691: (p_count => x_msg_count,
3692: p_data => x_msg_data
3693: );
3694: EXCEPTION
3695: WHEN FND_API.G_EXC_ERROR THEN
3696: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3697: x_return_status := FND_API.G_RET_STS_ERROR;
3698: -- Standard call to get message count and if count=1, get the message
3699: FND_MSG_PUB.Count_And_Get (
3700: p_encoded => FND_API.G_FALSE,
3701: p_count => x_msg_count,
3702: p_data => x_msg_data
3703: );
3704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3705: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3707: -- Standard call to get message count and if count=1, get the message
3708: FND_MSG_PUB.Count_And_Get (
3709: p_encoded => FND_API.G_FALSE,
3710: p_count => x_msg_count,
3711: p_data => x_msg_data
3716: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3717: THEN
3718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3719: END IF;
3720: -- Standard call to get message count and if count=1, get the message
3721: FND_MSG_PUB.Count_And_Get (
3722: p_encoded => FND_API.G_FALSE,
3723: p_count => x_msg_count,
3724: p_data => x_msg_data
3749:
3750: l_dummy NUMBER;
3751:
3752: BEGIN
3753: -- Standard Start of API savepoint
3754: SAVEPOINT delete_supp_code_conv_pvt;
3755:
3756: -- Standard call to check for call compatibility.
3757: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3752: BEGIN
3753: -- Standard Start of API savepoint
3754: SAVEPOINT delete_supp_code_conv_pvt;
3755:
3756: -- Standard call to check for call compatibility.
3757: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3758: p_api_version_number,
3759: l_api_name,
3760: G_PKG_NAME)
3794: WHEN OTHERS THEN
3795: RAISE FND_API.G_EXC_ERROR;
3796: END;
3797:
3798: -- Standard check for p_commit
3799: IF FND_API.to_Boolean( p_commit )
3800: THEN
3801: COMMIT WORK;
3802: END IF;
3805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3806: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3807: END IF;
3808:
3809: -- Standard call to get message count and if count is 1, get message info.
3810: FND_MSG_PUB.Count_And_Get
3811: (p_count => x_msg_count,
3812: p_data => x_msg_data
3813: );
3814: EXCEPTION
3815: WHEN FND_API.G_EXC_ERROR THEN
3816: ROLLBACK TO delete_supp_code_conv_pvt;
3817: x_return_status := FND_API.G_RET_STS_ERROR;
3818: -- Standard call to get message count and if count=1, get the message
3819: FND_MSG_PUB.Count_And_Get (
3820: p_encoded => FND_API.G_FALSE,
3821: p_count => x_msg_count,
3822: p_data => x_msg_data
3823: );
3824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3825: ROLLBACK TO delete_supp_code_conv_pvt;
3826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3827: -- Standard call to get message count and if count=1, get the message
3828: FND_MSG_PUB.Count_And_Get (
3829: p_encoded => FND_API.G_FALSE,
3830: p_count => x_msg_count,
3831: p_data => x_msg_data
3836: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3837: THEN
3838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3839: END IF;
3840: -- Standard call to get message count and if count=1, get the message
3841: FND_MSG_PUB.Count_And_Get (
3842: p_encoded => FND_API.G_FALSE,
3843: p_count => x_msg_count,
3844: p_data => x_msg_data