[Home] [Help]
662: WHERE resale_batch_id = p_resale_batch_id
663: AND status_code = 'DUPLICATED';
664:
665: BEGIN
666: -- Standard begin of API savepoint
667: SAVEPOINT Update_Batch_Calculations;
668:
669: -- Standard call to check FOR call compatibility.
670: IF NOT FND_API.Compatible_API_Call (
665: BEGIN
666: -- Standard begin of API savepoint
667: SAVEPOINT Update_Batch_Calculations;
668:
669: -- Standard call to check FOR call compatibility.
670: IF NOT FND_API.Compatible_API_Call (
671: l_api_version,
672: p_api_version,
673: l_api_name,
811: IF OZF_DEBUG_HIGH_ON THEN
812: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
813: END IF;
814:
815: --Standard call to get message count AND if count=1, get the message
816: FND_MSG_PUB.Count_and_Get (
817: p_encoded => FND_API.G_FALSE,
818: p_count => x_msg_count,
819: p_data => x_msg_data
821: EXCEPTION
822: WHEN FND_API.G_EXC_ERROR THEN
823: ROLLBACK TO Update_Batch_Calculations;
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: -- Standard call to get message count AND IF count=1, get the message
826: FND_MSG_PUB.Count_and_Get (
827: p_encoded => FND_API.G_FALSE,
828: p_count => x_msg_count,
829: p_data => x_msg_data
830: );
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO Update_Batch_Calculations;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: -- Standard call to get message count AND IF count=1, get the message
835: FND_MSG_PUB.Count_and_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: IF OZF_UNEXP_ERROR 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
914: -- bug 5969118 end
915:
916: --
917: BEGIN
918: -- Standard begin of API savepoint
919: SAVEPOINT Update_Line_Calculations;
920:
921: -- Debug Message
922: IF OZF_DEBUG_HIGH_ON THEN
1431:
1432:
1433: BEGIN
1434:
1435: -- Standard call to check for call compatibility.
1436: IF NOT FND_API.Compatible_API_Call (
1437: l_api_version,
1438: p_api_version_number,
1439: l_api_name,
1561: IF OZF_DEBUG_HIGH_ON THEN
1562: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1563: END IF;
1564:
1565: --Standard call to get message count AND IF count=1, get the message
1566: FND_MSG_PUB.Count_And_Get (
1567: p_encoded => FND_API.G_FALSE,
1568: p_count => x_msg_count,
1569: p_data => x_msg_data
1570: );
1571: EXCEPTION
1572: WHEN FND_API.G_EXC_ERROR THEN
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: -- Standard call to get message count AND IF count=1, get the message
1575: FND_MSG_PUB.Count_And_Get (
1576: p_encoded => FND_API.G_FALSE,
1577: p_count => x_msg_count,
1578: p_data => x_msg_data
1578: p_data => x_msg_data
1579: );
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582: -- Standard call to get message count AND IF count=1, get the message
1583: FND_MSG_PUB.Count_And_Get (
1584: p_encoded => FND_API.G_FALSE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data
1589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1590: IF OZF_UNEXP_ERROR THEN
1591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1592: END IF;
1593: -- Standard call to get message count AND IF count=1, get the message
1594: FND_MSG_PUB.Count_And_Get (
1595: p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data
1663:
1664: BEGIN
1665: SAVEPOINT Update_Duplicates;
1666:
1667: -- Standard call to check for call compatibility.
1668: IF NOT FND_API.Compatible_API_Call (
1669: l_api_version,
1670: p_api_version,
1671: l_api_name,
1813: IF OZF_DEBUG_HIGH_ON THEN
1814: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1815: END IF;
1816:
1817: --Standard call to get message count AND IF count=1, get the message
1818: FND_MSG_PUB.Count_And_Get (
1819: p_encoded => FND_API.G_FALSE,
1820: p_count => x_msg_count,
1821: p_data => x_msg_data
1824: EXCEPTION
1825: WHEN FND_API.G_EXC_ERROR THEN
1826: ROLLBACK TO Update_Duplicates;
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828: -- Standard call to get message count AND IF count=1, get the message
1829: FND_MSG_PUB.Count_And_Get (
1830: p_encoded => FND_API.G_FALSE,
1831: p_count => x_msg_count,
1832: p_data => x_msg_data
1833: );
1834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1835: ROLLBACK TO Update_Duplicates;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: -- Standard call to get message count AND IF count=1, get the message
1838: FND_MSG_PUB.Count_And_Get (
1839: p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846: IF OZF_UNEXP_ERROR THEN
1847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1848: END IF;
1849: -- Standard call to get message count AND IF count=1, get the message
1850: FND_MSG_PUB.Count_And_Get (
1851: p_encoded => FND_API.G_FALSE,
1852: p_count => x_msg_count,
1853: p_data => x_msg_data
1922: WHERE hca.cust_account_id = p_id);
1923: --
1924: BEGIN
1925:
1926: -- Standard call to check for call compatibility.
1927: IF NOT FND_API.Compatible_API_Call (
1928: l_api_version,
1929: p_api_version,
1930: l_api_name,
2227: IF OZF_DEBUG_HIGH_ON THEN
2228: OZF_UTILITY_PVT.debug_message(l_full_name||': END');
2229: END IF;
2230:
2231: --Standard call to get message count AND IF count=1, get the message
2232: FND_MSG_PUB.Count_And_Get (
2233: p_encoded => FND_API.G_FALSE,
2234: p_count => x_msg_count,
2235: p_data => x_msg_data
2237: --
2238: EXCEPTION
2239: WHEN FND_API.G_EXC_ERROR THEN
2240: x_return_status := FND_API.G_RET_STS_ERROR;
2241: -- Standard call to get message count AND IF count=1, get the message
2242: FND_MSG_PUB.Count_And_Get (
2243: p_encoded => FND_API.G_FALSE,
2244: p_count => x_msg_count,
2245: p_data => x_msg_data
2245: p_data => x_msg_data
2246: );
2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2249: -- Standard call to get message count AND IF count=1, get the message
2250: FND_MSG_PUB.Count_And_Get (
2251: p_encoded => FND_API.G_FALSE,
2252: p_count => x_msg_count,
2253: p_data => x_msg_data
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257: IF OZF_UNEXP_ERROR THEN
2258: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2259: END IF;
2260: -- Standard call to get message count AND IF count=1, get the message
2261: FND_MSG_PUB.Count_And_Get (
2262: p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count,
2264: p_data => x_msg_data
2293: --
2294: l_return_status varchar2(1);
2295: BEGIN
2296:
2297: -- Standard call to check for call compatibility.
2298: IF NOT FND_API.Compatible_API_Call (
2299: l_api_version,
2300: p_api_version,
2301: l_api_name,
2358: IF OZF_DEBUG_HIGH_ON THEN
2359: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2360: END IF;
2361:
2362: --Standard call to get message count AND IF count=1, get the message
2363: FND_MSG_PUB.Count_And_Get (
2364: p_encoded => FND_API.G_FALSE,
2365: p_count => x_msg_count,
2366: p_data => x_msg_data
2367: );
2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: x_return_status := FND_API.G_RET_STS_ERROR;
2371: -- Standard call to get message count AND IF count=1, get the message
2372: FND_MSG_PUB.Count_And_Get (
2373: p_encoded => FND_API.G_FALSE,
2374: p_count => x_msg_count,
2375: p_data => x_msg_data
2375: p_data => x_msg_data
2376: );
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: -- Standard call to get message count AND IF count=1, get the message
2380: FND_MSG_PUB.Count_And_Get (
2381: p_encoded => FND_API.G_FALSE,
2382: p_count => x_msg_count,
2383: p_data => x_msg_data
2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2387: IF OZF_UNEXP_ERROR THEN
2388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2389: END IF;
2390: -- Standard call to get message count AND IF count=1, get the message
2391: FND_MSG_PUB.Count_And_Get (
2392: p_encoded => FND_API.G_FALSE,
2393: p_count => x_msg_count,
2394: p_data => x_msg_data
2439: l_adjustment_id NUMBER;
2440: l_rate NUMBER;
2441: l_exchange_type VARCHAR2(30);
2442: BEGIN
2443: -- Standard begin of API savepoint
2444: SAVEPOINT IDSM_Create_Utiz_Rec;
2445: x_return_status := FND_API.G_RET_STS_SUCCESS;
2446:
2447: --
2680: l_org_id NUMBER;
2681:
2682: l_utilized_amount NUMBER;
2683: BEGIN
2684: -- Standard BEGIN of API savepoint
2685: SAVEPOINT Create_Adj_And_Utilization;
2686: -- Standard call to check for call compatibility.
2687: IF NOT FND_API.Compatible_API_Call (
2688: l_api_version,
2682: l_utilized_amount NUMBER;
2683: BEGIN
2684: -- Standard BEGIN of API savepoint
2685: SAVEPOINT Create_Adj_And_Utilization;
2686: -- Standard call to check for call compatibility.
2687: IF NOT FND_API.Compatible_API_Call (
2688: l_api_version,
2689: p_api_version,
2690: l_api_name,
2869: IF OZF_DEBUG_HIGH_ON THEN
2870: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2871: END IF;
2872:
2873: --Standard call to get message count AND IF count=1, get the message
2874: FND_MSG_PUB.Count_And_Get (
2875: p_encoded => FND_API.G_FALSE,
2876: p_count => x_msg_count,
2877: p_data => x_msg_data
2879: EXCEPTION
2880: WHEN FND_API.G_EXC_ERROR THEN
2881: ROLLBACK TO Create_Adj_And_Utilization;
2882: x_return_status := FND_API.G_RET_STS_ERROR;
2883: -- Standard call to get message count AND IF count=1, get the message
2884: FND_MSG_PUB.Count_And_Get (
2885: p_encoded => FND_API.G_FALSE,
2886: p_count => x_msg_count,
2887: p_data => x_msg_data
2888: );
2889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2890: ROLLBACK TO Create_Adj_And_Utilization;
2891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2892: -- Standard call to get message count AND IF count=1, get the message
2893: FND_MSG_PUB.Count_And_Get (
2894: p_encoded => FND_API.G_FALSE,
2895: p_count => x_msg_count,
2896: p_data => x_msg_data
2900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2901: IF OZF_UNEXP_ERROR THEN
2902: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2903: END IF;
2904: -- Standard call to get message count AND IF count=1, get the message
2905: FND_MSG_PUB.Count_And_Get (
2906: p_encoded => FND_API.G_FALSE,
2907: p_count => x_msg_count,
2908: p_data => x_msg_data
2980: l_to_create_utilization BOOLEAN;
2981: l_budget_source_id NUMBER;
2982: --
2983: BEGIN
2984: -- Standard BEGIN of API savepoint
2985: SAVEPOINT IDSM_Create_Utilization;
2986: -- Standard call to check for call compatibility.
2987: IF NOT FND_API.Compatible_API_Call (
2988: l_api_version,
2982: --
2983: BEGIN
2984: -- Standard BEGIN of API savepoint
2985: SAVEPOINT IDSM_Create_Utilization;
2986: -- Standard call to check for call compatibility.
2987: IF NOT FND_API.Compatible_API_Call (
2988: l_api_version,
2989: p_api_version,
2990: l_api_name,
3214: IF OZF_DEBUG_HIGH_ON THEN
3215: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3216: END IF;
3217:
3218: --Standard call to get message count AND IF count=1, get the message
3219: FND_MSG_PUB.Count_And_Get (
3220: p_encoded => FND_API.G_FALSE,
3221: p_count => x_msg_count,
3222: p_data => x_msg_data
3224: EXCEPTION
3225: WHEN FND_API.G_EXC_ERROR THEN
3226: ROLLBACK TO IDSM_Create_Utilization;
3227: x_return_status := FND_API.G_RET_STS_ERROR;
3228: -- Standard call to get message count AND IF count=1, get the message
3229: FND_MSG_PUB.Count_And_Get (
3230: p_encoded => FND_API.G_FALSE,
3231: p_count => x_msg_count,
3232: p_data => x_msg_data
3233: );
3234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3235: ROLLBACK TO IDSM_Create_Utilization;
3236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3237: -- Standard call to get message count AND IF count=1, get the message
3238: FND_MSG_PUB.Count_And_Get (
3239: p_encoded => FND_API.G_FALSE,
3240: p_count => x_msg_count,
3241: p_data => x_msg_data
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246: IF OZF_UNEXP_ERROR THEN
3247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3248: END IF;
3249: -- Standard call to get message count AND IF count=1, get the message
3250: FND_MSG_PUB.Count_And_Get (
3251: p_encoded => FND_API.G_FALSE,
3252: p_count => x_msg_count,
3253: p_data => x_msg_data
3307: FROM hz_cust_acct_sites
3308: WHERE cust_acct_site_id = p_account_site_id;
3309:
3310: BEGIN
3311: -- Standard BEGIN of API savepoint
3312: SAVEPOINT Create_Sales_Transaction;
3313: -- Standard call to check for call compatibility.
3314: IF NOT FND_API.Compatible_API_Call (
3315: l_api_version,
3309:
3310: BEGIN
3311: -- Standard BEGIN of API savepoint
3312: SAVEPOINT Create_Sales_Transaction;
3313: -- Standard call to check for call compatibility.
3314: IF NOT FND_API.Compatible_API_Call (
3315: l_api_version,
3316: p_api_version,
3317: l_api_name,
3391: IF OZF_DEBUG_HIGH_ON THEN
3392: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3393: END IF;
3394:
3395: --Standard call to get message count AND IF count=1, get the message
3396: FND_MSG_PUB.Count_And_Get (
3397: p_encoded => FND_API.G_FALSE,
3398: p_count => x_msg_count,
3399: p_data => x_msg_data
3401: EXCEPTION
3402: WHEN FND_API.G_EXC_ERROR THEN
3403: ROLLBACK TO Create_Sales_Transaction;
3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: -- Standard call to get message count AND IF count=1, get the message
3406: FND_MSG_PUB.Count_And_Get (
3407: p_encoded => FND_API.G_FALSE,
3408: p_count => x_msg_count,
3409: p_data => x_msg_data
3410: );
3411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3412: ROLLBACK TO Create_Sales_Transaction;
3413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3414: -- Standard call to get message count AND IF count=1, get the message
3415: FND_MSG_PUB.Count_And_Get (
3416: p_encoded => FND_API.G_FALSE,
3417: p_count => x_msg_count,
3418: p_data => x_msg_data
3422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3423: IF OZF_UNEXP_ERROR THEN
3424: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3425: END IF;
3426: -- Standard call to get message count AND IF count=1, get the message
3427: FND_MSG_PUB.Count_And_Get (
3428: p_encoded => FND_API.G_FALSE,
3429: p_count => x_msg_count,
3430: p_data => x_msg_data
3469: l_header_id NUMBER;
3470: l_object_version_number NUMBER := 1;
3471: l_org_id NUMBER;
3472: BEGIN
3473: -- Standard BEGIN of API savepoint
3474: SAVEPOINT Insert_Resale_Header;
3475: -- Standard call to check for call compatibility.
3476: IF NOT FND_API.Compatible_API_Call (
3477: l_api_version,
3471: l_org_id NUMBER;
3472: BEGIN
3473: -- Standard BEGIN of API savepoint
3474: SAVEPOINT Insert_Resale_Header;
3475: -- Standard call to check for call compatibility.
3476: IF NOT FND_API.Compatible_API_Call (
3477: l_api_version,
3478: p_api_version,
3479: l_api_name,
3602: IF OZF_DEBUG_HIGH_ON THEN
3603: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3604: END IF;
3605:
3606: --Standard call to get message count AND IF count=1, get the message
3607: FND_MSG_PUB.Count_And_Get (
3608: p_encoded => FND_API.G_FALSE,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data
3612: EXCEPTION
3613: WHEN FND_API.G_EXC_ERROR THEN
3614: ROLLBACK TO Insert_Resale_Header;
3615: x_return_status := FND_API.G_RET_STS_ERROR;
3616: -- Standard call to get message count AND IF count=1, get the message
3617: FND_MSG_PUB.Count_And_Get (
3618: p_encoded => FND_API.G_FALSE,
3619: p_count => x_msg_count,
3620: p_data => x_msg_data
3621: );
3622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3623: ROLLBACK TO Insert_Resale_Header;
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: -- Standard call to get message count AND IF count=1, get the message
3626: FND_MSG_PUB.Count_And_Get (
3627: p_encoded => FND_API.G_FALSE,
3628: p_count => x_msg_count,
3629: p_data => x_msg_data
3633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3634: IF OZF_UNEXP_ERROR THEN
3635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3636: END IF;
3637: -- Standard call to get message count AND IF count=1, get the message
3638: FND_MSG_PUB.Count_And_Get (
3639: p_encoded => FND_API.G_FALSE,
3640: p_count => x_msg_count,
3641: p_data => x_msg_data
3682: l_obj_ver_num NUMBER := 1;
3683: l_org_id NUMBER;
3684: l_map_id NUMBER;
3685: BEGIN
3686: -- Standard BEGIN of API savepoint
3687: SAVEPOINT Insert_Resale_Line;
3688: -- Standard call to check for call compatibility.
3689: IF NOT FND_API.Compatible_API_Call (
3690: l_api_version,
3684: l_map_id NUMBER;
3685: BEGIN
3686: -- Standard BEGIN of API savepoint
3687: SAVEPOINT Insert_Resale_Line;
3688: -- Standard call to check for call compatibility.
3689: IF NOT FND_API.Compatible_API_Call (
3690: l_api_version,
3691: p_api_version,
3692: l_api_name,
3913: OZF_UTILITY_PVT.debug_message('line INSERT successful id:' || l_line_id);
3914: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3915: END IF;
3916:
3917: --Standard call to get message count AND IF count=1, get the message
3918: FND_MSG_PUB.Count_And_Get (
3919: p_encoded => FND_API.G_FALSE,
3920: p_count => x_msg_count,
3921: p_data => x_msg_data
3924: EXCEPTION
3925: WHEN FND_API.G_EXC_ERROR THEN
3926: ROLLBACK TO Insert_Resale_Line;
3927: x_return_status := FND_API.G_RET_STS_ERROR;
3928: -- Standard call to get message count AND IF count=1, get the message
3929: FND_MSG_PUB.Count_And_Get (
3930: p_encoded => FND_API.G_FALSE,
3931: p_count => x_msg_count,
3932: p_data => x_msg_data
3933: );
3934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3935: ROLLBACK TO Insert_Resale_Line;
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: -- Standard call to get message count AND IF count=1, get the message
3938: FND_MSG_PUB.Count_And_Get (
3939: p_encoded => FND_API.G_FALSE,
3940: p_count => x_msg_count,
3941: p_data => x_msg_data
3945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3946: IF OZF_UNEXP_ERROR THEN
3947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3948: END IF;
3949: -- Standard call to get message count AND IF count=1, get the message
3950: FND_MSG_PUB.Count_And_Get (
3951: p_encoded => FND_API.G_FALSE,
3952: p_count => x_msg_count,
3953: p_data => x_msg_data
3992: l_org_id NUMBER;
3993: l_batch_org_id NUMBER; -- bug # 5997978 fixed
3994: l_map_id NUMBER;
3995: BEGIN
3996: -- Standard BEGIN of API savepoint
3997: SAVEPOINT Insert_Resale_Line_Mapping;
3998: -- Standard call to check for call compatibility.
3999: IF NOT FND_API.Compatible_API_Call (
4000: l_api_version,
3994: l_map_id NUMBER;
3995: BEGIN
3996: -- Standard BEGIN of API savepoint
3997: SAVEPOINT Insert_Resale_Line_Mapping;
3998: -- Standard call to check for call compatibility.
3999: IF NOT FND_API.Compatible_API_Call (
4000: l_api_version,
4001: p_api_version,
4002: l_api_name,
4070: IF OZF_DEBUG_HIGH_ON THEN
4071: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4072: END IF;
4073:
4074: --Standard call to get message count AND IF count=1, get the message
4075: FND_MSG_PUB.Count_And_Get (
4076: p_encoded => FND_API.G_FALSE,
4077: p_count => x_msg_count,
4078: p_data => x_msg_data
4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: ROLLBACK TO Insert_Resale_Line_Mapping;
4083: x_return_status := FND_API.G_RET_STS_ERROR;
4084: -- Standard call to get message count AND IF count=1, get the message
4085: FND_MSG_PUB.Count_And_Get (
4086: p_encoded => FND_API.G_FALSE,
4087: p_count => x_msg_count,
4088: p_data => x_msg_data
4089: );
4090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4091: ROLLBACK TO Insert_Resale_Line_Mapping;
4092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4093: -- Standard call to get message count AND IF count=1, get the message
4094: FND_MSG_PUB.Count_And_Get (
4095: p_encoded => FND_API.G_FALSE,
4096: p_count => x_msg_count,
4097: p_data => x_msg_data
4101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4102: IF OZF_UNEXP_ERROR THEN
4103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4104: END IF;
4105: -- Standard call to get message count AND IF count=1, get the message
4106: FND_MSG_PUB.Count_And_Get (
4107: p_encoded => FND_API.G_FALSE,
4108: p_count => x_msg_count,
4109: p_data => x_msg_data
4142: l_msg_data VARCHAR2(2000);
4143: l_msg_count NUMBER;
4144:
4145: BEGIN
4146: -- Standard BEGIN of API savepoint
4147: SAVEPOINT Delete_Log;
4148: -- Standard call to check for call compatibility.
4149: IF NOT FND_API.Compatible_API_Call (
4150: l_api_version,
4144:
4145: BEGIN
4146: -- Standard BEGIN of API savepoint
4147: SAVEPOINT Delete_Log;
4148: -- Standard call to check for call compatibility.
4149: IF NOT FND_API.Compatible_API_Call (
4150: l_api_version,
4151: p_api_version,
4152: l_api_name,
4187: IF OZF_DEBUG_HIGH_ON THEN
4188: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4189: END IF;
4190:
4191: --Standard call to get message count AND IF count=1, get the message
4192: FND_MSG_PUB.Count_And_Get (
4193: p_encoded => FND_API.G_FALSE,
4194: p_count => x_msg_count,
4195: p_data => x_msg_data
4197: EXCEPTION
4198: WHEN FND_API.G_EXC_ERROR THEN
4199: ROLLBACK TO Delete_Log;
4200: x_return_status := FND_API.G_RET_STS_ERROR;
4201: -- Standard call to get message count AND IF count=1, get the message
4202: FND_MSG_PUB.Count_And_Get (
4203: p_encoded => FND_API.G_FALSE,
4204: p_count => x_msg_count,
4205: p_data => x_msg_data
4206: );
4207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4208: ROLLBACK TO Delete_Log;
4209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4210: -- Standard call to get message count AND IF count=1, get the message
4211: FND_MSG_PUB.Count_And_Get (
4212: p_encoded => FND_API.G_FALSE,
4213: p_count => x_msg_count,
4214: p_data => x_msg_data
4218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4219: IF OZF_UNEXP_ERROR THEN
4220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4221: END IF;
4222: -- Standard call to get message count AND IF count=1, get the message
4223: FND_MSG_PUB.Count_And_Get (
4224: p_encoded => FND_API.G_FALSE,
4225: p_count => x_msg_count,
4226: p_data => x_msg_data
4274: l_party_site_use_id NUMBER;
4275: l_relationship_id NUMBER;
4276:
4277: BEGIN
4278: -- Standard BEGIN of API savepoint
4279: SAVEPOINT Party_Create;
4280: -- Standard call to check for call compatibility.
4281: IF NOT FND_API.Compatible_API_Call (
4282: l_api_version,
4276:
4277: BEGIN
4278: -- Standard BEGIN of API savepoint
4279: SAVEPOINT Party_Create;
4280: -- Standard call to check for call compatibility.
4281: IF NOT FND_API.Compatible_API_Call (
4282: l_api_version,
4283: p_api_version,
4284: l_api_name,
4477: -- Debug Message
4478: IF OZF_DEBUG_HIGH_ON THEN
4479: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4480: END IF;
4481: --Standard call to get message count AND IF count=1, get the message
4482: FND_MSG_PUB.Count_And_Get (
4483: p_encoded => FND_API.G_FALSE,
4484: p_count => x_msg_count,
4485: p_data => x_msg_data);
4486:
4487: EXCEPTION
4488: WHEN FND_API.G_EXC_ERROR THEN
4489: x_return_status := FND_API.G_RET_STS_ERROR;
4490: -- Standard call to get message count and if count=1, get the message
4491: FND_MSG_PUB.Count_And_Get (
4492: p_encoded => FND_API.G_FALSE,
4493: p_count => x_msg_count,
4494: p_data => x_msg_data
4494: p_data => x_msg_data
4495: );
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4498: -- Standard call to get message count and if count=1, get the message
4499: FND_MSG_PUB.Count_And_Get (
4500: p_encoded => FND_API.G_FALSE,
4501: p_count => x_msg_count,
4502: p_data => x_msg_data
4508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4509: THEN
4510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4511: END IF;
4512: -- Standard call to get message count and if count=1, get the message
4513: FND_MSG_PUB.Count_And_Get (
4514: p_encoded => FND_API.G_FALSE,
4515: p_count => x_msg_count,
4516: p_data => x_msg_data