[Home] [Help]
676: WHERE resale_batch_id = p_resale_batch_id
677: AND status_code = 'DUPLICATED';
678:
679: BEGIN
680: -- Standard begin of API savepoint
681: SAVEPOINT Update_Batch_Calculations;
682:
683: -- Standard call to check FOR call compatibility.
684: IF NOT FND_API.Compatible_API_Call (
679: BEGIN
680: -- Standard begin of API savepoint
681: SAVEPOINT Update_Batch_Calculations;
682:
683: -- Standard call to check FOR call compatibility.
684: IF NOT FND_API.Compatible_API_Call (
685: l_api_version,
686: p_api_version,
687: l_api_name,
834: IF OZF_DEBUG_HIGH_ON THEN
835: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
836: END IF;
837:
838: --Standard call to get message count AND if count=1, get the message
839: FND_MSG_PUB.Count_and_Get (
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846: ROLLBACK TO Update_Batch_Calculations;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: -- Standard call to get message count AND IF count=1, get the message
849: FND_MSG_PUB.Count_and_Get (
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK TO Update_Batch_Calculations;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: -- Standard call to get message count AND IF count=1, get the message
858: FND_MSG_PUB.Count_and_Get (
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: IF OZF_UNEXP_ERROR THEN
867: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
868: END IF;
869: -- Standard call to get message count AND IF count=1, get the message
870: FND_MSG_PUB.Count_and_Get (
871: p_encoded => FND_API.G_FALSE,
872: p_count => x_msg_count,
873: p_data => x_msg_data
933: */
934: --Bug# 8418811 fixed by muthsubr(-)
935:
936: BEGIN
937: -- Standard begin of API savepoint
938: SAVEPOINT Update_Line_Calculations;
939:
940: -- Debug Message
941: IF OZF_DEBUG_HIGH_ON THEN
1556: -- Start RSATYAVA Bug#10085365 fix
1557:
1558: BEGIN
1559:
1560: -- Standard call to check for call compatibility.
1561: IF NOT FND_API.Compatible_API_Call (
1562: l_api_version,
1563: p_api_version_number,
1564: l_api_name,
1948: IF OZF_DEBUG_HIGH_ON THEN
1949: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1950: END IF;
1951:
1952: --Standard call to get message count AND IF count=1, get the message
1953: FND_MSG_PUB.Count_And_Get (
1954: p_encoded => FND_API.G_FALSE,
1955: p_count => x_msg_count,
1956: p_data => x_msg_data
1957: );
1958: EXCEPTION
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: -- Standard call to get message count AND IF count=1, get the message
1962: FND_MSG_PUB.Count_And_Get (
1963: p_encoded => FND_API.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => x_msg_data
1965: p_data => x_msg_data
1966: );
1967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: -- Standard call to get message count AND IF count=1, get the message
1970: FND_MSG_PUB.Count_And_Get (
1971: p_encoded => FND_API.G_FALSE,
1972: p_count => x_msg_count,
1973: p_data => x_msg_data
1976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1977: IF OZF_UNEXP_ERROR THEN
1978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1979: END IF;
1980: -- Standard call to get message count AND IF count=1, get the message
1981: FND_MSG_PUB.Count_And_Get (
1982: p_encoded => FND_API.G_FALSE,
1983: p_count => x_msg_count,
1984: p_data => x_msg_data
2052:
2053: BEGIN
2054: SAVEPOINT Update_Duplicates;
2055:
2056: -- Standard call to check for call compatibility.
2057: IF NOT FND_API.Compatible_API_Call (
2058: l_api_version,
2059: p_api_version,
2060: l_api_name,
2180: IF OZF_DEBUG_HIGH_ON THEN
2181: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2182: END IF;
2183:
2184: --Standard call to get message count AND IF count=1, get the message
2185: FND_MSG_PUB.Count_And_Get (
2186: p_encoded => FND_API.G_FALSE,
2187: p_count => x_msg_count,
2188: p_data => x_msg_data
2191: EXCEPTION
2192: WHEN FND_API.G_EXC_ERROR THEN
2193: ROLLBACK TO Update_Duplicates;
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195: -- Standard call to get message count AND IF count=1, get the message
2196: FND_MSG_PUB.Count_And_Get (
2197: p_encoded => FND_API.G_FALSE,
2198: p_count => x_msg_count,
2199: p_data => x_msg_data
2200: );
2201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2202: ROLLBACK TO Update_Duplicates;
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2204: -- Standard call to get message count AND IF count=1, get the message
2205: FND_MSG_PUB.Count_And_Get (
2206: p_encoded => FND_API.G_FALSE,
2207: p_count => x_msg_count,
2208: p_data => x_msg_data
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: IF OZF_UNEXP_ERROR THEN
2214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2215: END IF;
2216: -- Standard call to get message count AND IF count=1, get the message
2217: FND_MSG_PUB.Count_And_Get (
2218: p_encoded => FND_API.G_FALSE,
2219: p_count => x_msg_count,
2220: p_data => x_msg_data
2289: WHERE hca.cust_account_id = p_id);
2290: --
2291: BEGIN
2292:
2293: -- Standard call to check for call compatibility.
2294: IF NOT FND_API.Compatible_API_Call (
2295: l_api_version,
2296: p_api_version,
2297: l_api_name,
2594: IF OZF_DEBUG_HIGH_ON THEN
2595: OZF_UTILITY_PVT.debug_message(l_full_name||': END');
2596: END IF;
2597:
2598: --Standard call to get message count AND IF count=1, get the message
2599: FND_MSG_PUB.Count_And_Get (
2600: p_encoded => FND_API.G_FALSE,
2601: p_count => x_msg_count,
2602: p_data => x_msg_data
2604: --
2605: EXCEPTION
2606: WHEN FND_API.G_EXC_ERROR THEN
2607: x_return_status := FND_API.G_RET_STS_ERROR;
2608: -- Standard call to get message count AND IF count=1, get the message
2609: FND_MSG_PUB.Count_And_Get (
2610: p_encoded => FND_API.G_FALSE,
2611: p_count => x_msg_count,
2612: p_data => x_msg_data
2612: p_data => x_msg_data
2613: );
2614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2616: -- Standard call to get message count AND IF count=1, get the message
2617: FND_MSG_PUB.Count_And_Get (
2618: p_encoded => FND_API.G_FALSE,
2619: p_count => x_msg_count,
2620: p_data => x_msg_data
2623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2624: IF OZF_UNEXP_ERROR THEN
2625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2626: END IF;
2627: -- Standard call to get message count AND IF count=1, get the message
2628: FND_MSG_PUB.Count_And_Get (
2629: p_encoded => FND_API.G_FALSE,
2630: p_count => x_msg_count,
2631: p_data => x_msg_data
2660: --
2661: l_return_status varchar2(1);
2662: BEGIN
2663:
2664: -- Standard call to check for call compatibility.
2665: IF NOT FND_API.Compatible_API_Call (
2666: l_api_version,
2667: p_api_version,
2668: l_api_name,
2725: IF OZF_DEBUG_HIGH_ON THEN
2726: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2727: END IF;
2728:
2729: --Standard call to get message count AND IF count=1, get the message
2730: FND_MSG_PUB.Count_And_Get (
2731: p_encoded => FND_API.G_FALSE,
2732: p_count => x_msg_count,
2733: p_data => x_msg_data
2734: );
2735: EXCEPTION
2736: WHEN FND_API.G_EXC_ERROR THEN
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: -- Standard call to get message count AND IF count=1, get the message
2739: FND_MSG_PUB.Count_And_Get (
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,
2742: p_data => x_msg_data
2742: p_data => x_msg_data
2743: );
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: -- Standard call to get message count AND IF count=1, get the message
2747: FND_MSG_PUB.Count_And_Get (
2748: p_encoded => FND_API.G_FALSE,
2749: p_count => x_msg_count,
2750: p_data => x_msg_data
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754: IF OZF_UNEXP_ERROR THEN
2755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2756: END IF;
2757: -- Standard call to get message count AND IF count=1, get the message
2758: FND_MSG_PUB.Count_And_Get (
2759: p_encoded => FND_API.G_FALSE,
2760: p_count => x_msg_count,
2761: p_data => x_msg_data
2816: l_rate NUMBER;
2817: l_exchange_type VARCHAR2(30);
2818: l_utilization_id NUMBER;
2819: BEGIN
2820: -- Standard begin of API savepoint
2821: SAVEPOINT IDSM_Create_Utiz_Rec;
2822: x_return_status := FND_API.G_RET_STS_SUCCESS;
2823:
2824: --
3213:
3214: l_utilized_amount NUMBER;
3215: l_utilization_id NUMBER;
3216: BEGIN
3217: -- Standard BEGIN of API savepoint
3218: SAVEPOINT Create_Adj_And_Utilization;
3219: -- Standard call to check for call compatibility.
3220: IF NOT FND_API.Compatible_API_Call (
3221: l_api_version,
3215: l_utilization_id NUMBER;
3216: BEGIN
3217: -- Standard BEGIN of API savepoint
3218: SAVEPOINT Create_Adj_And_Utilization;
3219: -- Standard call to check for call compatibility.
3220: IF NOT FND_API.Compatible_API_Call (
3221: l_api_version,
3222: p_api_version,
3223: l_api_name,
3420: IF OZF_DEBUG_HIGH_ON THEN
3421: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3422: END IF;
3423:
3424: --Standard call to get message count AND IF count=1, get the message
3425: FND_MSG_PUB.Count_And_Get (
3426: p_encoded => FND_API.G_FALSE,
3427: p_count => x_msg_count,
3428: p_data => x_msg_data
3430: EXCEPTION
3431: WHEN FND_API.G_EXC_ERROR THEN
3432: ROLLBACK TO Create_Adj_And_Utilization;
3433: x_return_status := FND_API.G_RET_STS_ERROR;
3434: -- Standard call to get message count AND IF count=1, get the message
3435: FND_MSG_PUB.Count_And_Get (
3436: p_encoded => FND_API.G_FALSE,
3437: p_count => x_msg_count,
3438: p_data => x_msg_data
3439: );
3440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3441: ROLLBACK TO Create_Adj_And_Utilization;
3442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3443: -- Standard call to get message count AND IF count=1, get the message
3444: FND_MSG_PUB.Count_And_Get (
3445: p_encoded => FND_API.G_FALSE,
3446: p_count => x_msg_count,
3447: p_data => x_msg_data
3451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3452: IF OZF_UNEXP_ERROR THEN
3453: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3454: END IF;
3455: -- Standard call to get message count AND IF count=1, get the message
3456: FND_MSG_PUB.Count_And_Get (
3457: p_encoded => FND_API.G_FALSE,
3458: p_count => x_msg_count,
3459: p_data => x_msg_data
3686: -- POS Batch Processing by profiles by ateotia (-)
3687:
3688: --
3689: BEGIN
3690: -- Standard BEGIN of API savepoint
3691: SAVEPOINT IDSM_Create_Utilization;
3692: -- Standard call to check for call compatibility.
3693: IF NOT FND_API.Compatible_API_Call (
3694: l_api_version,
3688: --
3689: BEGIN
3690: -- Standard BEGIN of API savepoint
3691: SAVEPOINT IDSM_Create_Utilization;
3692: -- Standard call to check for call compatibility.
3693: IF NOT FND_API.Compatible_API_Call (
3694: l_api_version,
3695: p_api_version,
3696: l_api_name,
3984: IF OZF_DEBUG_HIGH_ON THEN
3985: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3986: END IF;
3987:
3988: --Standard call to get message count AND IF count=1, get the message
3989: FND_MSG_PUB.Count_And_Get (
3990: p_encoded => FND_API.G_FALSE,
3991: p_count => x_msg_count,
3992: p_data => x_msg_data
3994: EXCEPTION
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: ROLLBACK TO IDSM_Create_Utilization;
3997: x_return_status := FND_API.G_RET_STS_ERROR;
3998: -- Standard call to get message count AND IF count=1, get the message
3999: FND_MSG_PUB.Count_And_Get (
4000: p_encoded => FND_API.G_FALSE,
4001: p_count => x_msg_count,
4002: p_data => x_msg_data
4003: );
4004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4005: ROLLBACK TO IDSM_Create_Utilization;
4006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4007: -- Standard call to get message count AND IF count=1, get the message
4008: FND_MSG_PUB.Count_And_Get (
4009: p_encoded => FND_API.G_FALSE,
4010: p_count => x_msg_count,
4011: p_data => x_msg_data
4015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4016: IF OZF_UNEXP_ERROR THEN
4017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4018: END IF;
4019: -- Standard call to get message count AND IF count=1, get the message
4020: FND_MSG_PUB.Count_And_Get (
4021: p_encoded => FND_API.G_FALSE,
4022: p_count => x_msg_count,
4023: p_data => x_msg_data
4085: WHERE resale_batch_id = p_id;
4086: -- For Bug#9447673 SSD IDSM ER(-)
4087:
4088: BEGIN
4089: -- Standard BEGIN of API savepoint
4090: SAVEPOINT Create_Sales_Transaction;
4091: -- Standard call to check for call compatibility.
4092: IF NOT FND_API.Compatible_API_Call (
4093: l_api_version,
4087:
4088: BEGIN
4089: -- Standard BEGIN of API savepoint
4090: SAVEPOINT Create_Sales_Transaction;
4091: -- Standard call to check for call compatibility.
4092: IF NOT FND_API.Compatible_API_Call (
4093: l_api_version,
4094: p_api_version,
4095: l_api_name,
4210: IF OZF_DEBUG_HIGH_ON THEN
4211: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4212: END IF;
4213:
4214: --Standard call to get message count AND IF count=1, get the message
4215: FND_MSG_PUB.Count_And_Get (
4216: p_encoded => FND_API.G_FALSE,
4217: p_count => x_msg_count,
4218: p_data => x_msg_data
4220: EXCEPTION
4221: WHEN FND_API.G_EXC_ERROR THEN
4222: ROLLBACK TO Create_Sales_Transaction;
4223: x_return_status := FND_API.G_RET_STS_ERROR;
4224: -- Standard call to get message count AND IF count=1, get the message
4225: FND_MSG_PUB.Count_And_Get (
4226: p_encoded => FND_API.G_FALSE,
4227: p_count => x_msg_count,
4228: p_data => x_msg_data
4229: );
4230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4231: ROLLBACK TO Create_Sales_Transaction;
4232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4233: -- Standard call to get message count AND IF count=1, get the message
4234: FND_MSG_PUB.Count_And_Get (
4235: p_encoded => FND_API.G_FALSE,
4236: p_count => x_msg_count,
4237: p_data => x_msg_data
4241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4242: IF OZF_UNEXP_ERROR THEN
4243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4244: END IF;
4245: -- Standard call to get message count AND IF count=1, get the message
4246: FND_MSG_PUB.Count_And_Get (
4247: p_encoded => FND_API.G_FALSE,
4248: p_count => x_msg_count,
4249: p_data => x_msg_data
4288: l_header_id NUMBER;
4289: l_object_version_number NUMBER := 1;
4290: l_org_id NUMBER;
4291: BEGIN
4292: -- Standard BEGIN of API savepoint
4293: SAVEPOINT Insert_Resale_Header;
4294: -- Standard call to check for call compatibility.
4295: IF NOT FND_API.Compatible_API_Call (
4296: l_api_version,
4290: l_org_id NUMBER;
4291: BEGIN
4292: -- Standard BEGIN of API savepoint
4293: SAVEPOINT Insert_Resale_Header;
4294: -- Standard call to check for call compatibility.
4295: IF NOT FND_API.Compatible_API_Call (
4296: l_api_version,
4297: p_api_version,
4298: l_api_name,
4421: IF OZF_DEBUG_HIGH_ON THEN
4422: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4423: END IF;
4424:
4425: --Standard call to get message count AND IF count=1, get the message
4426: FND_MSG_PUB.Count_And_Get (
4427: p_encoded => FND_API.G_FALSE,
4428: p_count => x_msg_count,
4429: p_data => x_msg_data
4431: EXCEPTION
4432: WHEN FND_API.G_EXC_ERROR THEN
4433: ROLLBACK TO Insert_Resale_Header;
4434: x_return_status := FND_API.G_RET_STS_ERROR;
4435: -- Standard call to get message count AND IF count=1, get the message
4436: FND_MSG_PUB.Count_And_Get (
4437: p_encoded => FND_API.G_FALSE,
4438: p_count => x_msg_count,
4439: p_data => x_msg_data
4440: );
4441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4442: ROLLBACK TO Insert_Resale_Header;
4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4444: -- Standard call to get message count AND IF count=1, get the message
4445: FND_MSG_PUB.Count_And_Get (
4446: p_encoded => FND_API.G_FALSE,
4447: p_count => x_msg_count,
4448: p_data => x_msg_data
4452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4453: IF OZF_UNEXP_ERROR THEN
4454: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4455: END IF;
4456: -- Standard call to get message count AND IF count=1, get the message
4457: FND_MSG_PUB.Count_And_Get (
4458: p_encoded => FND_API.G_FALSE,
4459: p_count => x_msg_count,
4460: p_data => x_msg_data
4501: l_obj_ver_num NUMBER := 1;
4502: l_org_id NUMBER;
4503: l_map_id NUMBER;
4504: BEGIN
4505: -- Standard BEGIN of API savepoint
4506: SAVEPOINT Insert_Resale_Line;
4507: -- Standard call to check for call compatibility.
4508: IF NOT FND_API.Compatible_API_Call (
4509: l_api_version,
4503: l_map_id NUMBER;
4504: BEGIN
4505: -- Standard BEGIN of API savepoint
4506: SAVEPOINT Insert_Resale_Line;
4507: -- Standard call to check for call compatibility.
4508: IF NOT FND_API.Compatible_API_Call (
4509: l_api_version,
4510: p_api_version,
4511: l_api_name,
4740: OZF_UTILITY_PVT.debug_message('line INSERT successful id:' || l_line_id);
4741: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4742: END IF;
4743:
4744: --Standard call to get message count AND IF count=1, get the message
4745: FND_MSG_PUB.Count_And_Get (
4746: p_encoded => FND_API.G_FALSE,
4747: p_count => x_msg_count,
4748: p_data => x_msg_data
4751: EXCEPTION
4752: WHEN FND_API.G_EXC_ERROR THEN
4753: ROLLBACK TO Insert_Resale_Line;
4754: x_return_status := FND_API.G_RET_STS_ERROR;
4755: -- Standard call to get message count AND IF count=1, get the message
4756: FND_MSG_PUB.Count_And_Get (
4757: p_encoded => FND_API.G_FALSE,
4758: p_count => x_msg_count,
4759: p_data => x_msg_data
4760: );
4761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4762: ROLLBACK TO Insert_Resale_Line;
4763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4764: -- Standard call to get message count AND IF count=1, get the message
4765: FND_MSG_PUB.Count_And_Get (
4766: p_encoded => FND_API.G_FALSE,
4767: p_count => x_msg_count,
4768: p_data => x_msg_data
4772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4773: IF OZF_UNEXP_ERROR THEN
4774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4775: END IF;
4776: -- Standard call to get message count AND IF count=1, get the message
4777: FND_MSG_PUB.Count_And_Get (
4778: p_encoded => FND_API.G_FALSE,
4779: p_count => x_msg_count,
4780: p_data => x_msg_data
4819: l_org_id NUMBER;
4820: l_batch_org_id NUMBER; -- bug # 5997978 fixed
4821: l_map_id NUMBER;
4822: BEGIN
4823: -- Standard BEGIN of API savepoint
4824: SAVEPOINT Insert_Resale_Line_Mapping;
4825: -- Standard call to check for call compatibility.
4826: IF NOT FND_API.Compatible_API_Call (
4827: l_api_version,
4821: l_map_id NUMBER;
4822: BEGIN
4823: -- Standard BEGIN of API savepoint
4824: SAVEPOINT Insert_Resale_Line_Mapping;
4825: -- Standard call to check for call compatibility.
4826: IF NOT FND_API.Compatible_API_Call (
4827: l_api_version,
4828: p_api_version,
4829: l_api_name,
4897: IF OZF_DEBUG_HIGH_ON THEN
4898: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4899: END IF;
4900:
4901: --Standard call to get message count AND IF count=1, get the message
4902: FND_MSG_PUB.Count_And_Get (
4903: p_encoded => FND_API.G_FALSE,
4904: p_count => x_msg_count,
4905: p_data => x_msg_data
4907: EXCEPTION
4908: WHEN FND_API.G_EXC_ERROR THEN
4909: ROLLBACK TO Insert_Resale_Line_Mapping;
4910: x_return_status := FND_API.G_RET_STS_ERROR;
4911: -- Standard call to get message count AND IF count=1, get the message
4912: FND_MSG_PUB.Count_And_Get (
4913: p_encoded => FND_API.G_FALSE,
4914: p_count => x_msg_count,
4915: p_data => x_msg_data
4916: );
4917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4918: ROLLBACK TO Insert_Resale_Line_Mapping;
4919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4920: -- Standard call to get message count AND IF count=1, get the message
4921: FND_MSG_PUB.Count_And_Get (
4922: p_encoded => FND_API.G_FALSE,
4923: p_count => x_msg_count,
4924: p_data => x_msg_data
4928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4929: IF OZF_UNEXP_ERROR THEN
4930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4931: END IF;
4932: -- Standard call to get message count AND IF count=1, get the message
4933: FND_MSG_PUB.Count_And_Get (
4934: p_encoded => FND_API.G_FALSE,
4935: p_count => x_msg_count,
4936: p_data => x_msg_data
4969: l_msg_data VARCHAR2(2000);
4970: l_msg_count NUMBER;
4971:
4972: BEGIN
4973: -- Standard BEGIN of API savepoint
4974: SAVEPOINT Delete_Log;
4975: -- Standard call to check for call compatibility.
4976: IF NOT FND_API.Compatible_API_Call (
4977: l_api_version,
4971:
4972: BEGIN
4973: -- Standard BEGIN of API savepoint
4974: SAVEPOINT Delete_Log;
4975: -- Standard call to check for call compatibility.
4976: IF NOT FND_API.Compatible_API_Call (
4977: l_api_version,
4978: p_api_version,
4979: l_api_name,
5014: IF OZF_DEBUG_HIGH_ON THEN
5015: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5016: END IF;
5017:
5018: --Standard call to get message count AND IF count=1, get the message
5019: FND_MSG_PUB.Count_And_Get (
5020: p_encoded => FND_API.G_FALSE,
5021: p_count => x_msg_count,
5022: p_data => x_msg_data
5024: EXCEPTION
5025: WHEN FND_API.G_EXC_ERROR THEN
5026: ROLLBACK TO Delete_Log;
5027: x_return_status := FND_API.G_RET_STS_ERROR;
5028: -- Standard call to get message count AND IF count=1, get the message
5029: FND_MSG_PUB.Count_And_Get (
5030: p_encoded => FND_API.G_FALSE,
5031: p_count => x_msg_count,
5032: p_data => x_msg_data
5033: );
5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: ROLLBACK TO Delete_Log;
5036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5037: -- Standard call to get message count AND IF count=1, get the message
5038: FND_MSG_PUB.Count_And_Get (
5039: p_encoded => FND_API.G_FALSE,
5040: p_count => x_msg_count,
5041: p_data => x_msg_data
5045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5046: IF OZF_UNEXP_ERROR THEN
5047: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5048: END IF;
5049: -- Standard call to get message count AND IF count=1, get the message
5050: FND_MSG_PUB.Count_And_Get (
5051: p_encoded => FND_API.G_FALSE,
5052: p_count => x_msg_count,
5053: p_data => x_msg_data
5101: l_party_site_use_id NUMBER;
5102: l_relationship_id NUMBER;
5103:
5104: BEGIN
5105: -- Standard BEGIN of API savepoint
5106: SAVEPOINT Party_Create;
5107: -- Standard call to check for call compatibility.
5108: IF NOT FND_API.Compatible_API_Call (
5109: l_api_version,
5103:
5104: BEGIN
5105: -- Standard BEGIN of API savepoint
5106: SAVEPOINT Party_Create;
5107: -- Standard call to check for call compatibility.
5108: IF NOT FND_API.Compatible_API_Call (
5109: l_api_version,
5110: p_api_version,
5111: l_api_name,
5304: -- Debug Message
5305: IF OZF_DEBUG_HIGH_ON THEN
5306: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5307: END IF;
5308: --Standard call to get message count AND IF count=1, get the message
5309: FND_MSG_PUB.Count_And_Get (
5310: p_encoded => FND_API.G_FALSE,
5311: p_count => x_msg_count,
5312: p_data => x_msg_data);
5313:
5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: x_return_status := FND_API.G_RET_STS_ERROR;
5317: -- Standard call to get message count and if count=1, get the message
5318: FND_MSG_PUB.Count_And_Get (
5319: p_encoded => FND_API.G_FALSE,
5320: p_count => x_msg_count,
5321: p_data => x_msg_data
5321: p_data => x_msg_data
5322: );
5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5325: -- Standard call to get message count and if count=1, get the message
5326: FND_MSG_PUB.Count_And_Get (
5327: p_encoded => FND_API.G_FALSE,
5328: p_count => x_msg_count,
5329: p_data => x_msg_data
5335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5336: THEN
5337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5338: END IF;
5339: -- Standard call to get message count and if count=1, get the message
5340: FND_MSG_PUB.Count_And_Get (
5341: p_encoded => FND_API.G_FALSE,
5342: p_count => x_msg_count,
5343: p_data => x_msg_data
5616: l_msg_data VARCHAR2(2000);
5617: l_msg_count NUMBER;
5618:
5619: BEGIN
5620: -- Standard BEGIN of API savepoint
5621: SAVEPOINT Derive_Orig_Parties;
5622:
5623: -- Standard call to check for call compatibility.
5624: IF NOT FND_API.Compatible_API_Call (
5619: BEGIN
5620: -- Standard BEGIN of API savepoint
5621: SAVEPOINT Derive_Orig_Parties;
5622:
5623: -- Standard call to check for call compatibility.
5624: IF NOT FND_API.Compatible_API_Call (
5625: l_api_version,
5626: p_api_version,
5627: l_api_name,
5697: IF OZF_DEBUG_HIGH_ON THEN
5698: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5699: END IF;
5700:
5701: --Standard call to get message count AND IF count=1, get the message
5702: FND_MSG_PUB.Count_And_Get (
5703: p_encoded => FND_API.G_FALSE,
5704: p_count => x_msg_count,
5705: p_data => x_msg_data);
5707: EXCEPTION
5708: WHEN FND_API.G_EXC_ERROR THEN
5709: ROLLBACK TO Derive_Orig_Parties;
5710: x_return_status := FND_API.G_RET_STS_ERROR;
5711: -- Standard call to get message count and if count=1, get the message
5712: FND_MSG_PUB.Count_And_Get (
5713: p_encoded => FND_API.G_FALSE,
5714: p_count => x_msg_count,
5715: p_data => x_msg_data
5716: );
5717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5718: ROLLBACK TO Derive_Orig_Parties;
5719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5720: -- Standard call to get message count and if count=1, get the message
5721: FND_MSG_PUB.Count_And_Get (
5722: p_encoded => FND_API.G_FALSE,
5723: p_count => x_msg_count,
5724: p_data => x_msg_data
5732: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5733: THEN
5734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5735: END IF;
5736: -- Standard call to get message count and if count=1, get the message
5737: FND_MSG_PUB.Count_And_Get (
5738: p_encoded => FND_API.G_FALSE,
5739: p_count => x_msg_count,
5740: p_data => x_msg_data
5828: TYPE orig_billto_cust_tbl_type IS TABLE OF csr_orig_billto_cust%ROWTYPE INDEX BY BINARY_INTEGER;
5829: l_orig_billto_cust_tbl orig_billto_cust_tbl_type;
5830:
5831: BEGIN
5832: -- Standard BEGIN of API savepoint
5833: SAVEPOINT Derive_Bill_To_Party;
5834:
5835: -- Standard call to check for call compatibility.
5836: IF NOT FND_API.Compatible_API_Call (
5831: BEGIN
5832: -- Standard BEGIN of API savepoint
5833: SAVEPOINT Derive_Bill_To_Party;
5834:
5835: -- Standard call to check for call compatibility.
5836: IF NOT FND_API.Compatible_API_Call (
5837: l_api_version,
5838: p_api_version,
5839: l_api_name,
5928: IF OZF_DEBUG_HIGH_ON THEN
5929: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5930: END IF;
5931:
5932: --Standard call to get message count AND IF count=1, get the message
5933: FND_MSG_PUB.Count_And_Get (
5934: p_encoded => FND_API.G_FALSE,
5935: p_count => x_msg_count,
5936: p_data => x_msg_data);
5938: EXCEPTION
5939: WHEN FND_API.G_EXC_ERROR THEN
5940: ROLLBACK TO Derive_Bill_To_Party;
5941: x_return_status := FND_API.G_RET_STS_ERROR;
5942: -- Standard call to get message count and if count=1, get the message
5943: FND_MSG_PUB.Count_And_Get (
5944: p_encoded => FND_API.G_FALSE,
5945: p_count => x_msg_count,
5946: p_data => x_msg_data
5947: );
5948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5949: ROLLBACK TO Derive_Bill_To_Party;
5950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5951: -- Standard call to get message count and if count=1, get the message
5952: FND_MSG_PUB.Count_And_Get (
5953: p_encoded => FND_API.G_FALSE,
5954: p_count => x_msg_count,
5955: p_data => x_msg_data
5963: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5964: THEN
5965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5966: END IF;
5967: -- Standard call to get message count and if count=1, get the message
5968: FND_MSG_PUB.Count_And_Get (
5969: p_encoded => FND_API.G_FALSE,
5970: p_count => x_msg_count,
5971: p_data => x_msg_data
6102: TYPE orig_shipto_cust_tbl_type IS TABLE OF csr_orig_shipto_cust%ROWTYPE INDEX BY BINARY_INTEGER;
6103: l_orig_shipto_cust_tbl orig_shipto_cust_tbl_type;
6104:
6105: BEGIN
6106: -- Standard BEGIN of API savepoint
6107: SAVEPOINT Derive_ship_To_Party;
6108:
6109: -- Standard call to check for call compatibility.
6110: IF NOT FND_API.Compatible_API_Call (
6105: BEGIN
6106: -- Standard BEGIN of API savepoint
6107: SAVEPOINT Derive_ship_To_Party;
6108:
6109: -- Standard call to check for call compatibility.
6110: IF NOT FND_API.Compatible_API_Call (
6111: l_api_version,
6112: p_api_version,
6113: l_api_name,
6240: IF OZF_DEBUG_HIGH_ON THEN
6241: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
6242: END IF;
6243:
6244: --Standard call to get message count AND IF count=1, get the message
6245: FND_MSG_PUB.Count_And_Get (
6246: p_encoded => FND_API.G_FALSE,
6247: p_count => x_msg_count,
6248: p_data => x_msg_data);
6250: EXCEPTION
6251: WHEN FND_API.G_EXC_ERROR THEN
6252: ROLLBACK TO Derive_Ship_To_Party;
6253: x_return_status := FND_API.G_RET_STS_ERROR;
6254: -- Standard call to get message count and if count=1, get the message
6255: FND_MSG_PUB.Count_And_Get (
6256: p_encoded => FND_API.G_FALSE,
6257: p_count => x_msg_count,
6258: p_data => x_msg_data
6259: );
6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: ROLLBACK TO Derive_Ship_To_Party;
6262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6263: -- Standard call to get message count and if count=1, get the message
6264: FND_MSG_PUB.Count_And_Get (
6265: p_encoded => FND_API.G_FALSE,
6266: p_count => x_msg_count,
6267: p_data => x_msg_data
6275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6276: THEN
6277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6278: END IF;
6279: -- Standard call to get message count and if count=1, get the message
6280: FND_MSG_PUB.Count_And_Get (
6281: p_encoded => FND_API.G_FALSE,
6282: p_count => x_msg_count,
6283: p_data => x_msg_data
6370: TYPE orig_end_cust_tbl_type IS TABLE of csr_orig_end_cust%ROWTYPE INDEX BY BINARY_INTEGER;
6371: l_orig_end_cust_tbl orig_end_cust_tbl_type;
6372:
6373: BEGIN
6374: -- Standard BEGIN of API savepoint
6375: SAVEPOINT Derive_Bill_To_Party;
6376:
6377: -- Standard call to check for call compatibility.
6378: IF NOT FND_API.Compatible_API_Call (
6373: BEGIN
6374: -- Standard BEGIN of API savepoint
6375: SAVEPOINT Derive_Bill_To_Party;
6376:
6377: -- Standard call to check for call compatibility.
6378: IF NOT FND_API.Compatible_API_Call (
6379: l_api_version,
6380: p_api_version,
6381: l_api_name,
6470: IF OZF_DEBUG_HIGH_ON THEN
6471: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
6472: END IF;
6473:
6474: --Standard call to get message count AND IF count=1, get the message
6475: FND_MSG_PUB.Count_And_Get (
6476: p_encoded => FND_API.G_FALSE,
6477: p_count => x_msg_count,
6478: p_data => x_msg_data);
6480: EXCEPTION
6481: WHEN FND_API.G_EXC_ERROR THEN
6482: ROLLBACK TO Derive_End_Cust_Party;
6483: x_return_status := FND_API.G_RET_STS_ERROR;
6484: -- Standard call to get message count and if count=1, get the message
6485: FND_MSG_PUB.Count_And_Get (
6486: p_encoded => FND_API.G_FALSE,
6487: p_count => x_msg_count,
6488: p_data => x_msg_data
6489: );
6490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6491: ROLLBACK TO Derive_End_Cust_Party;
6492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6493: -- Standard call to get message count and if count=1, get the message
6494: FND_MSG_PUB.Count_And_Get (
6495: p_encoded => FND_API.G_FALSE,
6496: p_count => x_msg_count,
6497: p_data => x_msg_data
6505: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6506: THEN
6507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6508: END IF;
6509: -- Standard call to get message count and if count=1, get the message
6510: FND_MSG_PUB.Count_And_Get (
6511: p_encoded => FND_API.G_FALSE,
6512: p_count => x_msg_count,
6513: p_data => x_msg_data
7952: line_count NUMBER;
7953: l_draft_utilization_id NUMBER;
7954:
7955: BEGIN
7956: -- Standard begin of API savepoint
7957: SAVEPOINT Create_Draft_Utilization;
7958:
7959: -- Standard call to check for call compatibility.
7960: IF NOT FND_API.Compatible_API_Call (
7955: BEGIN
7956: -- Standard begin of API savepoint
7957: SAVEPOINT Create_Draft_Utilization;
7958:
7959: -- Standard call to check for call compatibility.
7960: IF NOT FND_API.Compatible_API_Call (
7961: l_api_version,
7962: p_api_version,
7963: l_api_name,
8103: px_draft_accrual_tbl(line_count).list_line_id := p_price_adj_rec.LIST_LINE_ID;
8104:
8105: x_return_status := l_return_status;
8106:
8107: --Standard check of commit
8108: IF FND_API.To_Boolean ( p_commit ) THEN
8109: COMMIT WORK;
8110: END IF;
8111: -- Debug Message
8113: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
8114: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
8115: FND_MSG_PUB.Add;
8116: END IF;
8117: --Standard call to get message count and if count=1, get the message
8118: FND_MSG_PUB.Count_And_Get (
8119: p_encoded => FND_API.G_FALSE,
8120: p_count => x_msg_count,
8121: p_data => x_msg_data
8124: WHEN FND_API.G_EXC_ERROR THEN
8125: ozf_utility_pvt.write_conc_log('ERROR in Create Draft Utilization: '|| SQLERRM);
8126: ROLLBACK TO Create_Draft_Utilization;
8127: x_return_status := FND_API.G_RET_STS_ERROR;
8128: -- Standard call to get message count and if count=1, get the message
8129: FND_MSG_PUB.Count_And_Get (
8130: p_encoded => FND_API.G_FALSE,
8131: p_count => x_msg_count,
8132: p_data => x_msg_data
8134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8135: ozf_utility_pvt.write_conc_log('UNEXPECTED ERROR in Create Draft Utilization: '|| SQLERRM);
8136: ROLLBACK TO Create_Draft_Utilization;
8137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8138: -- Standard call to get message count and if count=1, get the message
8139: FND_MSG_PUB.Count_And_Get (
8140: p_encoded => FND_API.G_FALSE,
8141: p_count => x_msg_count,
8142: p_data => x_msg_data
8148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8149: THEN
8150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8151: END IF;
8152: -- Standard call to get message count and if count=1, get the message
8153: FND_MSG_PUB.Count_And_Get (
8154: p_encoded => FND_API.G_FALSE,
8155: p_count => x_msg_count,
8156: p_data => x_msg_data