eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on FND_API

Line 124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

120: p_from_date IN DATE,
121: p_to_date IN DATE,
122: p_qp_list_header_id IN NUMBER,
123: p_offer_adjustment_id IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
125: p_commit IN VARCHAR2 := fnd_api.g_false,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2

Line 125: p_commit IN VARCHAR2 := fnd_api.g_false,

121: p_to_date IN DATE,
122: p_qp_list_header_id IN NUMBER,
123: p_offer_adjustment_id IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
125: p_commit IN VARCHAR2 := fnd_api.g_false,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2
129: );

Line 277: IF Fnd_Api.to_boolean(p_init_msg_list) THEN

273: l_group_string VARCHAR2(256);
274:
275: BEGIN
276:
277: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
278: Fnd_Msg_Pub.initialize;
279: END IF;
280:
281: x_return_status := Fnd_Api.g_ret_sts_success;

Line 281: x_return_status := Fnd_Api.g_ret_sts_success;

277: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
278: Fnd_Msg_Pub.initialize;
279: END IF;
280:
281: x_return_status := Fnd_Api.g_ret_sts_success;
282:
283: --kdass 28-FEB-2006 fixed bug 5059735 - denorm offer's product eligibility to handle all types of product levels
284: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
285:

Line 331: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: ROLLBACK TO refresh_prod;
331: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
332: write_conc_log ('unexpected exception in refresh_products');
333: END;
334:
335: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 335: IF x_return_status <> fnd_api.g_ret_sts_success THEN

331: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
332: write_conc_log ('unexpected exception in refresh_products');
333: END;
334:
335: IF x_return_status <> fnd_api.g_ret_sts_success THEN
336: RETURN;
337: END IF;
338:
339: l_count_temp := 0;

Line 526: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

522: FROM oe_order_lines_all
523: WHERE line_id = p_order_line_id;
524:
525: l_order_org_id NUMBER;
526: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
527: l_autopay_party_id NUMBER;
528: l_autopay_party_attr VARCHAR2(30);
529: l_org_id NUMBER; -- site's lorg id
530:

Line 597: ,p_init_msg_list => FND_API.G_FALSE

593: write_conc_log ('p_list_line_id: ' || p_list_line_id);
594:
595: --get the qualified orders
596: get_orders(p_api_version => p_api_version
597: ,p_init_msg_list => FND_API.G_FALSE
598: ,p_commit => FND_API.G_FALSE
599: ,x_return_status => x_return_status
600: ,x_msg_count => x_msg_count
601: ,x_msg_data => x_msg_data

Line 598: ,p_commit => FND_API.G_FALSE

594:
595: --get the qualified orders
596: get_orders(p_api_version => p_api_version
597: ,p_init_msg_list => FND_API.G_FALSE
598: ,p_commit => FND_API.G_FALSE
599: ,x_return_status => x_return_status
600: ,x_msg_count => x_msg_count
601: ,x_msg_data => x_msg_data
602: ,p_list_header_id => p_list_header_id

Line 617: IF x_return_status = fnd_api.g_ret_sts_error THEN

613: write_conc_log ('x_return_status: ' || x_return_status);
614: write_conc_log ('number of orders: ' || l_order_line_tbl.count);
615:
616: /*kdass 04-AUG-2006 fixed bug 5446622
617: IF x_return_status = fnd_api.g_ret_sts_error THEN
618: RAISE fnd_api.g_exc_error;
619: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
620: RAISE fnd_api.g_exc_unexpected_error;
621: END IF;

Line 618: RAISE fnd_api.g_exc_error;

614: write_conc_log ('number of orders: ' || l_order_line_tbl.count);
615:
616: /*kdass 04-AUG-2006 fixed bug 5446622
617: IF x_return_status = fnd_api.g_ret_sts_error THEN
618: RAISE fnd_api.g_exc_error;
619: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
620: RAISE fnd_api.g_exc_unexpected_error;
621: END IF;
622: */

Line 619: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

615:
616: /*kdass 04-AUG-2006 fixed bug 5446622
617: IF x_return_status = fnd_api.g_ret_sts_error THEN
618: RAISE fnd_api.g_exc_error;
619: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
620: RAISE fnd_api.g_exc_unexpected_error;
621: END IF;
622: */
623: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 620: RAISE fnd_api.g_exc_unexpected_error;

616: /*kdass 04-AUG-2006 fixed bug 5446622
617: IF x_return_status = fnd_api.g_ret_sts_error THEN
618: RAISE fnd_api.g_exc_error;
619: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
620: RAISE fnd_api.g_exc_unexpected_error;
621: END IF;
622: */
623: IF x_return_status <> fnd_api.g_ret_sts_success THEN
624: RETURN;

Line 623: IF x_return_status <> fnd_api.g_ret_sts_success THEN

619: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
620: RAISE fnd_api.g_exc_unexpected_error;
621: END IF;
622: */
623: IF x_return_status <> fnd_api.g_ret_sts_success THEN
624: RETURN;
625: END IF;
626:
627: IF p_type = 'product' THEN

Line 752: IF x_return_status <> fnd_api.g_ret_sts_success THEN

748: ,x_rate => l_rate
749: );
750:
751: ozf_utility_pvt.write_conc_log('x_return_status: ' || x_return_status);
752: IF x_return_status <> fnd_api.g_ret_sts_success THEN
753: RETURN;
754: END IF;
755:
756: l_util_amount := l_conv_util_amount;

Line 852: IF x_return_status <> fnd_api.g_ret_sts_success THEN

848: );
849:
850: write_conc_log('process_act_budgets returns: ' || x_return_status);
851:
852: IF x_return_status <> fnd_api.g_ret_sts_success THEN
853: RETURN;
854: END IF;
855:
856: END IF;

Line 1109: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;

1105: l_included_vol_flag VARCHAR2(1);
1106: l_retroactive VARCHAR2(1) ;
1107: l_discount_type VARCHAR2(30);
1108: l_volume_type VARCHAR2(30);
1109: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;
1110: l_msg_count NUMBER;
1111: l_msg_data VARCHAR2 (2000) := NULL;
1112: l_source_code VARCHAR2(30);
1113: l_volume NUMBER;

Line 1136: ,p_init_msg_list => FND_API.G_FALSE

1132: write_conc_log ('in adjustment_volume_retro');
1133:
1134: --get the qualified orders
1135: get_orders(p_api_version => p_api_version
1136: ,p_init_msg_list => FND_API.G_FALSE
1137: ,p_commit => FND_API.G_FALSE
1138: ,x_return_status => x_return_status
1139: ,x_msg_count => x_msg_count
1140: ,x_msg_data => x_msg_data

Line 1137: ,p_commit => FND_API.G_FALSE

1133:
1134: --get the qualified orders
1135: get_orders(p_api_version => p_api_version
1136: ,p_init_msg_list => FND_API.G_FALSE
1137: ,p_commit => FND_API.G_FALSE
1138: ,x_return_status => x_return_status
1139: ,x_msg_count => x_msg_count
1140: ,x_msg_data => x_msg_data
1141: ,p_list_header_id => p_list_header_id

Line 1375: ,p_init_msg_list => FND_API.G_FALSE

1371:
1372: write_conc_log('calling Create_Transaction');
1373:
1374: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
1375: ,p_init_msg_list => FND_API.G_FALSE
1376: ,p_commit => FND_API.G_FALSE
1377: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1378: ,p_transaction_rec => l_sales_transaction_rec
1379: ,x_sales_transaction_id => l_sales_transaction_id

Line 1376: ,p_commit => FND_API.G_FALSE

1372: write_conc_log('calling Create_Transaction');
1373:
1374: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
1375: ,p_init_msg_list => FND_API.G_FALSE
1376: ,p_commit => FND_API.G_FALSE
1377: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1378: ,p_transaction_rec => l_sales_transaction_rec
1379: ,x_sales_transaction_id => l_sales_transaction_id
1380: ,x_return_status => x_return_status

Line 1377: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1373:
1374: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
1375: ,p_init_msg_list => FND_API.G_FALSE
1376: ,p_commit => FND_API.G_FALSE
1377: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1378: ,p_transaction_rec => l_sales_transaction_rec
1379: ,x_sales_transaction_id => l_sales_transaction_id
1380: ,x_return_status => x_return_status
1381: ,x_msg_data => x_msg_data

Line 1388: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1384:
1385: write_conc_log('Create_Transaction returns: ' || x_return_status);
1386: write_conc_log('l_sales_transaction_id: ' || l_sales_transaction_id);
1387:
1388: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1389: RETURN;
1390: END IF;
1391:
1392: END IF; --IF l_gl_date IS NOT NULL THEN

Line 1679: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1675: );
1676:
1677: write_conc_log('process_act_budgets returns: ' || x_return_status);
1678:
1679: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1680: RETURN;
1681: END IF;
1682:
1683: --END IF; --IF NVL(l_adjustment_exists,0) <> 1 THEN

Line 1806: l_return_status :=fnd_api.g_ret_sts_success;

1802: );
1803:
1804: /*removed code for future dated adjustments since offers team will be taking care of this.
1805: original code in version 120.19 */
1806: l_return_status :=fnd_api.g_ret_sts_success;
1807: write_conc_log ( l_full_name || ' : ' || 'Back Dated Adjusting ' || l_listHeaderIdTbl(i));
1808: -- Perform Adjustments for the already executed offer (for the orders raised between Effective Date and Approved Date)
1809: -- Fixed 10/23/2002 mpande
1810: IF l_offer_info.offer_type <> 'VOLUME_OFFER' THEN

Line 1823: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1819:
1820:
1821: write_conc_log ( l_full_name || ' : ' || 'Return Status For perform_adjustment ' || l_return_status);
1822:
1823: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1824: ozf_utility_pvt.write_conc_log ('/****** '
1825: || 'Offer Adjustment Failed For Offer'
1826: || l_offer_info.description
1827: || ' SOURCE CODE '

Line 1897: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1893: ,x_msg_count => l_msg_count
1894: ,x_msg_data => l_msg_data
1895: );
1896:
1897: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1898: write_conc_log (' /*************************** DEBUG MESSAGE END *************************/');
1899: ozf_utility_pvt.write_conc_log (' /****** '
1900: || 'Backdated Offer Adjustment Failed For Offer'
1901: || l_offer_info.description

Line 1924: IF l_return_status = fnd_api.g_ret_sts_success THEN --AND TRUNC(SYSDATE) >= l_effectiveDateTbl(i) THEN

1920: --END IF;
1921: -- if every thing goes correct then commit this adjustment
1922: -- only close the adjustment whose effective date less than sysdate to fix bug 4015372
1923:
1924: IF l_return_status = fnd_api.g_ret_sts_success THEN --AND TRUNC(SYSDATE) >= l_effectiveDateTbl(i) THEN
1925:
1926: IF l_offer_info.offer_type = 'VOLUME_OFFER' THEN
1927:
1928: --kdass bug 5610124 - retroactive adjustments for volume offer before offer start date

Line 1939: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1935: ,x_msg_count => l_msg_count
1936: ,x_msg_data => l_msg_data
1937: );
1938:
1939: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1940: ozf_utility_pvt.write_conc_log (' /****** '
1941: || 'Backdated Offer Adjustment Failed For Offer'
1942: || l_offer_info.description
1943: || ' SOURCE CODE '

Line 1962: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1958: ,x_msg_count=> l_msg_count
1959: ,x_msg_data=> l_msg_data
1960: );
1961:
1962: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1963: ozf_utility_pvt.write_conc_log ('volume adjustment Failed'
1964: || l_offer_info.description
1965: || ' SOURCE CODE '
1966: || l_offer_info.NAME

Line 1985: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1981: ,x_msg_count=> l_msg_count
1982: ,x_msg_data=> l_msg_data
1983: );
1984:
1985: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1986: ozf_utility_pvt.write_conc_log ('volume utilization adjustment Failed'
1987: || l_offer_info.description
1988: || ' SOURCE CODE '
1989: || l_offer_info.NAME

Line 2018: END IF; -- end of l_return_status = fnd_api.g_ret_sts_success

2014: x_retcode := 0;
2015: x_errbuf := l_msg_data;
2016: COMMIT;
2017:
2018: END IF; -- end of l_return_status = fnd_api.g_ret_sts_success
2019:
2020: <>
2021:
2022: write_conc_log( 'Return Status After Adjustment' || l_return_status);

Line 2068: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2064: p_from_date IN DATE,
2065: p_to_date IN DATE,
2066: p_qp_list_header_id IN NUMBER,
2067: p_offer_adjustment_id IN NUMBER,
2068: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2069: p_commit IN VARCHAR2 := fnd_api.g_false,
2070: x_return_status OUT NOCOPY VARCHAR2,
2071: x_msg_count OUT NOCOPY NUMBER,
2072: x_msg_data OUT NOCOPY VARCHAR2

Line 2069: p_commit IN VARCHAR2 := fnd_api.g_false,

2065: p_to_date IN DATE,
2066: p_qp_list_header_id IN NUMBER,
2067: p_offer_adjustment_id IN NUMBER,
2068: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2069: p_commit IN VARCHAR2 := fnd_api.g_false,
2070: x_return_status OUT NOCOPY VARCHAR2,
2071: x_msg_count OUT NOCOPY NUMBER,
2072: x_msg_data OUT NOCOPY VARCHAR2
2073: ) IS

Line 2549: x_return_status := fnd_api.g_ret_sts_success;

2545: || p_from_date
2546: || 'Adjusting To Date'
2547: || l_to_date);
2548: SAVEPOINT perform_adjustment;
2549: x_return_status := fnd_api.g_ret_sts_success;
2550: IF G_DEBUG THEN
2551: ozf_utility_pvt.debug_message (': begin ');
2552: END IF;
2553: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2553: IF fnd_api.to_boolean (p_init_msg_list) THEN

2549: x_return_status := fnd_api.g_ret_sts_success;
2550: IF G_DEBUG THEN
2551: ozf_utility_pvt.debug_message (': begin ');
2552: END IF;
2553: IF fnd_api.to_boolean (p_init_msg_list) THEN
2554: fnd_msg_pub.initialize;
2555: END IF;
2556: OPEN c_offer_info;
2557: FETCH c_offer_info INTO l_offer_info;

Line 2574: IF l_return_status = fnd_api.g_ret_sts_error THEN

2570: || 'After Process Product Return Status'
2571: || l_return_status);
2572: ----DBMS_OUTPUT.put_line ( 'After Process Product' || l_return_status);
2573:
2574: IF l_return_status = fnd_api.g_ret_sts_error THEN
2575: RAISE fnd_api.g_exc_error;
2576: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;

Line 2575: RAISE fnd_api.g_exc_error;

2571: || l_return_status);
2572: ----DBMS_OUTPUT.put_line ( 'After Process Product' || l_return_status);
2573:
2574: IF l_return_status = fnd_api.g_ret_sts_error THEN
2575: RAISE fnd_api.g_exc_error;
2576: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579: --IF l_source_from_par_flag = 'N' THEN

Line 2576: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2572: ----DBMS_OUTPUT.put_line ( 'After Process Product' || l_return_status);
2573:
2574: IF l_return_status = fnd_api.g_ret_sts_error THEN
2575: RAISE fnd_api.g_exc_error;
2576: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579: --IF l_source_from_par_flag = 'N' THEN
2580:

Line 2577: RAISE fnd_api.g_exc_unexpected_error;

2573:
2574: IF l_return_status = fnd_api.g_ret_sts_error THEN
2575: RAISE fnd_api.g_exc_error;
2576: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579: --IF l_source_from_par_flag = 'N' THEN
2580:
2581: -- updated by mkothari : 10-28-2002

Line 2723: p_encoded => FND_API.G_FALSE,

2719: IF(x_msg_count > 0)THEN
2720: FOR I IN 1 .. x_msg_count LOOP
2721: fnd_msg_pub.GET
2722: (p_msg_index => FND_MSG_PUB.G_NEXT,
2723: p_encoded => FND_API.G_FALSE,
2724: p_data => x_msg_data,
2725: p_msg_index_out => l_index);
2726: --ozf_utility_pvt.write_conc_log(l_full_name||' : '||i||x_msg_data);
2727: DBMS_OUTPUT.put_line('****(PA):'||x_msg_data);

Line 2735: IF l_return_status = fnd_api.g_ret_sts_error THEN

2731: -- END IF;
2732: END FOR_DEBUGGING */
2733: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
2734:
2735: IF l_return_status = fnd_api.g_ret_sts_error THEN
2736: RAISE fnd_api.g_exc_error;
2737: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2738: RAISE fnd_api.g_exc_unexpected_error;
2739: END IF;

Line 2736: RAISE fnd_api.g_exc_error;

2732: END FOR_DEBUGGING */
2733: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
2734:
2735: IF l_return_status = fnd_api.g_ret_sts_error THEN
2736: RAISE fnd_api.g_exc_error;
2737: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2738: RAISE fnd_api.g_exc_unexpected_error;
2739: END IF;
2740:

Line 2737: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2733: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
2734:
2735: IF l_return_status = fnd_api.g_ret_sts_error THEN
2736: RAISE fnd_api.g_exc_error;
2737: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2738: RAISE fnd_api.g_exc_unexpected_error;
2739: END IF;
2740:
2741: END LOOP; --FOR i IN NVL(backdate_adj_rec.FIRST, 1) .. NVL(backdate_adj_rec.LAST, 0) LOOP

Line 2738: RAISE fnd_api.g_exc_unexpected_error;

2734:
2735: IF l_return_status = fnd_api.g_ret_sts_error THEN
2736: RAISE fnd_api.g_exc_error;
2737: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2738: RAISE fnd_api.g_exc_unexpected_error;
2739: END IF;
2740:
2741: END LOOP; --FOR i IN NVL(backdate_adj_rec.FIRST, 1) .. NVL(backdate_adj_rec.LAST, 0) LOOP
2742:

Line 2766: WHEN fnd_api.g_exc_error THEN

2762: CLOSE c_bdadj_all_types;
2763: END IF;
2764:
2765: EXCEPTION
2766: WHEN fnd_api.g_exc_error THEN
2767: ROLLBACK TO perform_adjustment;
2768: x_return_status := fnd_api.g_ret_sts_error;
2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2768: x_return_status := fnd_api.g_ret_sts_error;

2764:
2765: EXCEPTION
2766: WHEN fnd_api.g_exc_error THEN
2767: ROLLBACK TO perform_adjustment;
2768: x_return_status := fnd_api.g_ret_sts_error;
2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN
2771: ROLLBACK TO perform_adjustment;
2772: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2765: EXCEPTION
2766: WHEN fnd_api.g_exc_error THEN
2767: ROLLBACK TO perform_adjustment;
2768: x_return_status := fnd_api.g_ret_sts_error;
2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN
2771: ROLLBACK TO perform_adjustment;
2772: x_return_status := fnd_api.g_ret_sts_unexp_error;
2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2770: WHEN fnd_api.g_exc_unexpected_error THEN

2766: WHEN fnd_api.g_exc_error THEN
2767: ROLLBACK TO perform_adjustment;
2768: x_return_status := fnd_api.g_ret_sts_error;
2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN
2771: ROLLBACK TO perform_adjustment;
2772: x_return_status := fnd_api.g_ret_sts_unexp_error;
2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2774: WHEN OTHERS THEN

Line 2772: x_return_status := fnd_api.g_ret_sts_unexp_error;

2768: x_return_status := fnd_api.g_ret_sts_error;
2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN
2771: ROLLBACK TO perform_adjustment;
2772: x_return_status := fnd_api.g_ret_sts_unexp_error;
2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2774: WHEN OTHERS THEN
2775: ROLLBACK TO perform_adjustment;
2776: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN
2771: ROLLBACK TO perform_adjustment;
2772: x_return_status := fnd_api.g_ret_sts_unexp_error;
2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2774: WHEN OTHERS THEN
2775: ROLLBACK TO perform_adjustment;
2776: x_return_status := fnd_api.g_ret_sts_unexp_error;
2777: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2776: x_return_status := fnd_api.g_ret_sts_unexp_error;

2772: x_return_status := fnd_api.g_ret_sts_unexp_error;
2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2774: WHEN OTHERS THEN
2775: ROLLBACK TO perform_adjustment;
2776: x_return_status := fnd_api.g_ret_sts_unexp_error;
2777: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2779: END IF;
2780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2776: x_return_status := fnd_api.g_ret_sts_unexp_error;
2777: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2779: END IF;
2780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2781: END perform_adjustment;
2782:
2783: -------------------------------------------------------------------
2784: -- NAME

Line 2815: x_return_status := fnd_api.g_ret_sts_success;

2811: WHERE adjl.offer_adjustment_id = p_offer_adjustment_id AND adjl.list_line_id = qppa.list_line_id;
2812: BEGIN
2813: -- ozf_utility_pvt.debug_message('enter validate_product_budget obj_id=' || p_object_id || ' budget_id=' || p_budget_id);
2814:
2815: x_return_status := fnd_api.g_ret_sts_success;
2816: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
2817: write_conc_log ( l_full_name
2818: || ' : '
2819: || 'In Process Product '

Line 2883: x_return_status := fnd_api.g_ret_sts_error;

2879:
2880: END LOOP;
2881: EXCEPTION
2882: WHEN OTHERS THEN
2883: x_return_status := fnd_api.g_ret_sts_error;
2884: END process_offer_product;
2885: ---------------------------------------------------------------------
2886: -- PROCEDURE
2887: -- PROCESS_ACCRUAL

Line 2969: l_return_status := FND_API.g_ret_sts_success;

2965:
2966: FND_MSG_PUB.initialize;
2967: l_msg_count:= 0;
2968: l_msg_data := NULL;
2969: l_return_status := FND_API.g_ret_sts_success;
2970:
2971: write_conc_log(l_full_name ||'VOLUME OFFER ID'|| l_qpListHeaderIdTbl(i));
2972:
2973: BEGIN

Line 2978: ,p_init_msg_list => fnd_api.g_false

2974: SAVEPOINT volume_offer;
2975:
2976: volume_offer_adjustment(p_qp_list_header_id => l_qpListHeaderIdTbl(i)
2977: ,p_vol_off_type => l_volumeOfferTypeTbl(i)
2978: ,p_init_msg_list => fnd_api.g_false
2979: ,p_commit => fnd_api.g_false
2980: ,x_return_status => l_return_status
2981: ,x_msg_count => l_msg_count
2982: ,x_msg_data => l_msg_data

Line 2979: ,p_commit => fnd_api.g_false

2975:
2976: volume_offer_adjustment(p_qp_list_header_id => l_qpListHeaderIdTbl(i)
2977: ,p_vol_off_type => l_volumeOfferTypeTbl(i)
2978: ,p_init_msg_list => fnd_api.g_false
2979: ,p_commit => fnd_api.g_false
2980: ,x_return_status => l_return_status
2981: ,x_msg_count => l_msg_count
2982: ,x_msg_data => l_msg_data
2983: );

Line 2987: IF l_return_status = fnd_api.g_ret_sts_error THEN

2983: );
2984:
2985: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
2986:
2987: IF l_return_status = fnd_api.g_ret_sts_error THEN
2988: RAISE fnd_api.g_exc_error;
2989: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2990: RAISE fnd_api.g_exc_unexpected_error;
2991: END IF;

Line 2988: RAISE fnd_api.g_exc_error;

2984:
2985: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
2986:
2987: IF l_return_status = fnd_api.g_ret_sts_error THEN
2988: RAISE fnd_api.g_exc_error;
2989: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2990: RAISE fnd_api.g_exc_unexpected_error;
2991: END IF;
2992:

Line 2989: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2985: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
2986:
2987: IF l_return_status = fnd_api.g_ret_sts_error THEN
2988: RAISE fnd_api.g_exc_error;
2989: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2990: RAISE fnd_api.g_exc_unexpected_error;
2991: END IF;
2992:
2993: ----------------------------------------

Line 2990: RAISE fnd_api.g_exc_unexpected_error;

2986:
2987: IF l_return_status = fnd_api.g_ret_sts_error THEN
2988: RAISE fnd_api.g_exc_error;
2989: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2990: RAISE fnd_api.g_exc_unexpected_error;
2991: END IF;
2992:
2993: ----------------------------------------
2994: volume_offer_util_adjustment(p_qp_list_header_id => l_qpListHeaderIdTbl(i)

Line 3002: IF l_return_status = fnd_api.g_ret_sts_error THEN

2998: );
2999:
3000: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
3001:
3002: IF l_return_status = fnd_api.g_ret_sts_error THEN
3003: RAISE fnd_api.g_exc_error;
3004: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3005: RAISE fnd_api.g_exc_unexpected_error;
3006: END IF;

Line 3003: RAISE fnd_api.g_exc_error;

2999:
3000: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
3001:
3002: IF l_return_status = fnd_api.g_ret_sts_error THEN
3003: RAISE fnd_api.g_exc_error;
3004: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3005: RAISE fnd_api.g_exc_unexpected_error;
3006: END IF;
3007: ----------------------------------------

Line 3004: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3000: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
3001:
3002: IF l_return_status = fnd_api.g_ret_sts_error THEN
3003: RAISE fnd_api.g_exc_error;
3004: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3005: RAISE fnd_api.g_exc_unexpected_error;
3006: END IF;
3007: ----------------------------------------
3008:

Line 3005: RAISE fnd_api.g_exc_unexpected_error;

3001:
3002: IF l_return_status = fnd_api.g_ret_sts_error THEN
3003: RAISE fnd_api.g_exc_error;
3004: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3005: RAISE fnd_api.g_exc_unexpected_error;
3006: END IF;
3007: ----------------------------------------
3008:
3009: EXCEPTION

Line 3010: WHEN FND_API.G_EXC_ERROR THEN

3006: END IF;
3007: ----------------------------------------
3008:
3009: EXCEPTION
3010: WHEN FND_API.G_EXC_ERROR THEN
3011: ROLLBACK TO VOLUME_OFFER;
3012: OZF_UTILITY_PVT.write_conc_log(l_full_name ||' Volume Offer Adjustment Failed EX ==>'||'VOLUME OFFER '|| l_qpListHeaderIdTbl(i));
3013: OZF_UTILITY_PVT.write_conc_log;
3014: OZF_UTILITY_PVT.write_conc_log(' ');

Line 3016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3012: OZF_UTILITY_PVT.write_conc_log(l_full_name ||' Volume Offer Adjustment Failed EX ==>'||'VOLUME OFFER '|| l_qpListHeaderIdTbl(i));
3013: OZF_UTILITY_PVT.write_conc_log;
3014: OZF_UTILITY_PVT.write_conc_log(' ');
3015:
3016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3017: ROLLBACK TO VOLUME_OFFER;
3018: OZF_UTILITY_PVT.write_conc_log(l_full_name ||' Volume Offer Adjustment Failed UNEX ==>'||'VOLUME OFFER '|| l_qpListHeaderIdTbl(i));
3019: OZF_UTILITY_PVT.write_conc_log;
3020: OZF_UTILITY_PVT.write_conc_log(' ');

Line 3038: WHEN fnd_api.g_exc_error THEN

3034: END LOOP; -- end volume offer bulk fetch loop
3035:
3036: write_conc_log (' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
3037: EXCEPTION
3038: WHEN fnd_api.g_exc_error THEN
3039: ROLLBACK TO adjust_volume_offer;
3040: OZF_UTILITY_PVT.write_conc_log;
3041: x_ERRBUF := l_msg_data;
3042: x_RETCODE := 1;

Line 3044: WHEN fnd_api.g_exc_unexpected_error THEN

3040: OZF_UTILITY_PVT.write_conc_log;
3041: x_ERRBUF := l_msg_data;
3042: x_RETCODE := 1;
3043:
3044: WHEN fnd_api.g_exc_unexpected_error THEN
3045: ROLLBACK TO adjust_volume_offer;
3046: OZF_UTILITY_PVT.write_conc_log;
3047: x_ERRBUF := l_msg_data;
3048: x_RETCODE := 1;

Line 3136: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

3132: SELECT exchange_rate_type
3133: FROM ozf_sys_parameters_all
3134: WHERE org_id = p_org_id;
3135:
3136: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
3137:
3138:
3139:
3140: l_adj_info c_adj_info%ROWTYPE;

Line 3143: x_return_status := fnd_api.g_ret_sts_success;

3139:
3140: l_adj_info c_adj_info%ROWTYPE;
3141:
3142: BEGIN
3143: x_return_status := fnd_api.g_ret_sts_success;
3144: SAVEPOINT process_accrual;
3145: IF G_DEBUG THEN
3146: ozf_utility_pvt.debug_message (' Start'|| g_pkg_name||'.'||l_api_name);
3147: END IF;

Line 3189: IF x_return_status = fnd_api.g_ret_sts_error THEN

3185: fnd_message.set_token ('OFFER_NAME', l_off_name);
3186: fnd_msg_pub.ADD;
3187: END IF;
3188: --dbms_output.put_line(' In error ');
3189: IF x_return_status = fnd_api.g_ret_sts_error THEN
3190: RAISE fnd_api.g_exc_error;
3191: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3192: RAISE fnd_api.g_exc_unexpected_error;
3193: END IF;

Line 3190: RAISE fnd_api.g_exc_error;

3186: fnd_msg_pub.ADD;
3187: END IF;
3188: --dbms_output.put_line(' In error ');
3189: IF x_return_status = fnd_api.g_ret_sts_error THEN
3190: RAISE fnd_api.g_exc_error;
3191: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3192: RAISE fnd_api.g_exc_unexpected_error;
3193: END IF;
3194: ELSE

Line 3191: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3187: END IF;
3188: --dbms_output.put_line(' In error ');
3189: IF x_return_status = fnd_api.g_ret_sts_error THEN
3190: RAISE fnd_api.g_exc_error;
3191: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3192: RAISE fnd_api.g_exc_unexpected_error;
3193: END IF;
3194: ELSE
3195: --if some row is returned to adjust then

Line 3192: RAISE fnd_api.g_exc_unexpected_error;

3188: --dbms_output.put_line(' In error ');
3189: IF x_return_status = fnd_api.g_ret_sts_error THEN
3190: RAISE fnd_api.g_exc_error;
3191: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3192: RAISE fnd_api.g_exc_unexpected_error;
3193: END IF;
3194: ELSE
3195: --if some row is returned to adjust then
3196: IF G_DEBUG THEN

Line 3199: IF (l_fund_amt_tbl.COUNT > 0) AND x_return_status = fnd_api.g_ret_sts_success THEN

3195: --if some row is returned to adjust then
3196: IF G_DEBUG THEN
3197: ozf_utility_pvt.debug_message ('Begin Processing For Offer Adjustment: '||l_off_name);
3198: END IF;
3199: IF (l_fund_amt_tbl.COUNT > 0) AND x_return_status = fnd_api.g_ret_sts_success THEN
3200: l_adj_amount := 0; -- in offer currency
3201: l_remaining_amt := ozf_utility_pvt.currround (
3202: p_earned_amt,
3203: l_util_curr ); -- in offer currency

Line 3247: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3243: ozf_utility_pvt.debug_message( ' Adj amount coverted '|| l_converted_adj_amount
3244: || ' l_adj amount' || l_adj_amount);
3245: END IF;
3246:
3247: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3248: IF G_DEBUG THEN
3249: -- ozf_utility_pvt.error_message( ' Convert Currency '||x_return_status);
3250: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
3251: END IF;

Line 3252: IF x_return_status = fnd_api.g_ret_sts_error THEN

3248: IF G_DEBUG THEN
3249: -- ozf_utility_pvt.error_message( ' Convert Currency '||x_return_status);
3250: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
3251: END IF;
3252: IF x_return_status = fnd_api.g_ret_sts_error THEN
3253: RAISE fnd_api.g_exc_error;
3254: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3255: RAISE fnd_api.g_exc_unexpected_error;
3256: END IF;

Line 3253: RAISE fnd_api.g_exc_error;

3249: -- ozf_utility_pvt.error_message( ' Convert Currency '||x_return_status);
3250: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
3251: END IF;
3252: IF x_return_status = fnd_api.g_ret_sts_error THEN
3253: RAISE fnd_api.g_exc_error;
3254: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3255: RAISE fnd_api.g_exc_unexpected_error;
3256: END IF;
3257: END IF;

Line 3254: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3250: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
3251: END IF;
3252: IF x_return_status = fnd_api.g_ret_sts_error THEN
3253: RAISE fnd_api.g_exc_error;
3254: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3255: RAISE fnd_api.g_exc_unexpected_error;
3256: END IF;
3257: END IF;
3258: IF x_return_status = fnd_api.g_ret_sts_success THEN

Line 3255: RAISE fnd_api.g_exc_unexpected_error;

3251: END IF;
3252: IF x_return_status = fnd_api.g_ret_sts_error THEN
3253: RAISE fnd_api.g_exc_error;
3254: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3255: RAISE fnd_api.g_exc_unexpected_error;
3256: END IF;
3257: END IF;
3258: IF x_return_status = fnd_api.g_ret_sts_success THEN
3259: IF l_util_curr = l_fund_amt_tbl (j).budget_currency THEN

Line 3258: IF x_return_status = fnd_api.g_ret_sts_success THEN

3254: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3255: RAISE fnd_api.g_exc_unexpected_error;
3256: END IF;
3257: END IF;
3258: IF x_return_status = fnd_api.g_ret_sts_success THEN
3259: IF l_util_curr = l_fund_amt_tbl (j).budget_currency THEN
3260: l_act_budgets_rec.parent_src_apprvd_amt :=
3261: ozf_utility_pvt.currround (
3262: l_adj_amount,

Line 3328: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3324: IF G_DEBUG THEN
3325: ozf_utility_pvt.debug_message('create utlization '|| x_return_status);
3326: END IF;
3327:
3328: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3329: IF x_return_status = fnd_api.g_ret_sts_error THEN
3330: RAISE fnd_api.g_exc_error;
3331: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3332: RAISE fnd_api.g_exc_unexpected_error;

Line 3329: IF x_return_status = fnd_api.g_ret_sts_error THEN

3325: ozf_utility_pvt.debug_message('create utlization '|| x_return_status);
3326: END IF;
3327:
3328: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3329: IF x_return_status = fnd_api.g_ret_sts_error THEN
3330: RAISE fnd_api.g_exc_error;
3331: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3332: RAISE fnd_api.g_exc_unexpected_error;
3333: END IF;

Line 3330: RAISE fnd_api.g_exc_error;

3326: END IF;
3327:
3328: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3329: IF x_return_status = fnd_api.g_ret_sts_error THEN
3330: RAISE fnd_api.g_exc_error;
3331: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3332: RAISE fnd_api.g_exc_unexpected_error;
3333: END IF;
3334: END IF;

Line 3331: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3327:
3328: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3329: IF x_return_status = fnd_api.g_ret_sts_error THEN
3330: RAISE fnd_api.g_exc_error;
3331: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3332: RAISE fnd_api.g_exc_unexpected_error;
3333: END IF;
3334: END IF;
3335: END IF; --l_act_budgets_rec.request_amount <> 0

Line 3332: RAISE fnd_api.g_exc_unexpected_error;

3328: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3329: IF x_return_status = fnd_api.g_ret_sts_error THEN
3330: RAISE fnd_api.g_exc_error;
3331: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3332: RAISE fnd_api.g_exc_unexpected_error;
3333: END IF;
3334: END IF;
3335: END IF; --l_act_budgets_rec.request_amount <> 0
3336: --- quit when the total earned amount is adjusted

Line 3348: WHEN fnd_api.g_exc_error THEN

3344: END LOOP earned_adj_loop;
3345: END IF; --end of check for table count >0
3346: END IF; -- end of check for count
3347: EXCEPTION
3348: WHEN fnd_api.g_exc_error THEN
3349: ROLLBACK TO process_accrual;
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3350: x_return_status := fnd_api.g_ret_sts_error;

3346: END IF; -- end of check for count
3347: EXCEPTION
3348: WHEN fnd_api.g_exc_error THEN
3349: ROLLBACK TO process_accrual;
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO process_accrual;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3347: EXCEPTION
3348: WHEN fnd_api.g_exc_error THEN
3349: ROLLBACK TO process_accrual;
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO process_accrual;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3352: WHEN fnd_api.g_exc_unexpected_error THEN

3348: WHEN fnd_api.g_exc_error THEN
3349: ROLLBACK TO process_accrual;
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO process_accrual;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3356: WHEN OTHERS THEN

Line 3354: x_return_status := fnd_api.g_ret_sts_unexp_error;

3350: x_return_status := fnd_api.g_ret_sts_error;
3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO process_accrual;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3356: WHEN OTHERS THEN
3357: ROLLBACK TO process_accrual;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO process_accrual;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3356: WHEN OTHERS THEN
3357: ROLLBACK TO process_accrual;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3358: x_return_status := fnd_api.g_ret_sts_unexp_error;

3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3356: WHEN OTHERS THEN
3357: ROLLBACK TO process_accrual;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3360: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3361: END IF;
3362: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3362: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3360: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3361: END IF;
3362: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3363:
3364: END process_accrual;
3365:
3366: ---------------------------------------------------------------------

Line 3578: x_return_status := fnd_api.g_ret_sts_success;

3574: --profile: 'OZF: Create GL Entries for Orders' -- change as global constant by feliu on 06/21/2005
3575: -- l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
3576:
3577: BEGIN
3578: x_return_status := fnd_api.g_ret_sts_success;
3579:
3580: OPEN c_volume_type(p_list_header_id);
3581: FETCH c_volume_type INTO l_volume_type;
3582: CLOSE c_volume_type;

Line 3616: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3612: ,x_to_amount => l_conv_amount
3613: ,x_rate => l_rate
3614: );
3615:
3616: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3617: ozf_utility_pvt.write_conc_log('x_return_status: ' || x_return_status);
3618: RETURN NULL;
3619: END IF;
3620:

Line 3653: x_return_status := fnd_api.g_ret_sts_error;

3649:
3650:
3651: EXCEPTION
3652: WHEN OTHERS THEN
3653: x_return_status := fnd_api.g_ret_sts_error;
3654: RETURN NULL;
3655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3656: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3657: END IF;

Line 3683: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

3679:
3680: PROCEDURE volume_offer_adjustment (
3681: p_qp_list_header_id IN NUMBER,
3682: p_vol_off_type IN VARCHAR2,
3683: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3684: p_commit IN VARCHAR2 := fnd_api.g_false,
3685: x_return_status OUT NOCOPY VARCHAR2,
3686: x_msg_count OUT NOCOPY NUMBER,
3687: x_msg_data OUT NOCOPY VARCHAR2

Line 3684: p_commit IN VARCHAR2 := fnd_api.g_false,

3680: PROCEDURE volume_offer_adjustment (
3681: p_qp_list_header_id IN NUMBER,
3682: p_vol_off_type IN VARCHAR2,
3683: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3684: p_commit IN VARCHAR2 := fnd_api.g_false,
3685: x_return_status OUT NOCOPY VARCHAR2,
3686: x_msg_count OUT NOCOPY NUMBER,
3687: x_msg_data OUT NOCOPY VARCHAR2
3688: ) IS

Line 3899: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;

3895:
3896: l_api_name CONSTANT VARCHAR2(30) := 'volume_offer_adjustment';
3897: l_full_name VARCHAR2(70):= g_pkg_name ||'.'||l_api_name ||' : ';
3898: l_api_version CONSTANT NUMBER := 1.0;
3899: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;
3900: l_msg_count NUMBER;
3901: l_msg_data VARCHAR2 (2000) := NULL;
3902: l_volume_offer_tier_id NUMBER;
3903: l_current_offer_tier_id NUMBER;

Line 4117: IF l_return_status = fnd_api.g_ret_sts_error THEN

4113: ,x_to_amount => l_conv_price
4114: ,x_rate => l_rate
4115: );
4116:
4117: IF l_return_status = fnd_api.g_ret_sts_error THEN
4118: RAISE fnd_api.g_exc_error;
4119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4120: RAISE fnd_api.g_exc_unexpected_error;
4121: END IF;

Line 4118: RAISE fnd_api.g_exc_error;

4114: ,x_rate => l_rate
4115: );
4116:
4117: IF l_return_status = fnd_api.g_ret_sts_error THEN
4118: RAISE fnd_api.g_exc_error;
4119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4120: RAISE fnd_api.g_exc_unexpected_error;
4121: END IF;
4122:

Line 4119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4115: );
4116:
4117: IF l_return_status = fnd_api.g_ret_sts_error THEN
4118: RAISE fnd_api.g_exc_error;
4119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4120: RAISE fnd_api.g_exc_unexpected_error;
4121: END IF;
4122:
4123: l_selling_price := l_conv_price;

Line 4120: RAISE fnd_api.g_exc_unexpected_error;

4116:
4117: IF l_return_status = fnd_api.g_ret_sts_error THEN
4118: RAISE fnd_api.g_exc_error;
4119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4120: RAISE fnd_api.g_exc_unexpected_error;
4121: END IF;
4122:
4123: l_selling_price := l_conv_price;
4124: write_conc_log ('selling price after currency conversion: ' || l_selling_price);

Line 4185: (p_init_msg_list =>fnd_api.g_false

4181: */
4182:
4183: IF l_retroactive = 'Y' THEN
4184: ozf_volume_calculation_pub.get_volume
4185: (p_init_msg_list =>fnd_api.g_false
4186: ,p_api_version =>1.0
4187: ,p_commit =>fnd_api.g_false
4188: ,x_return_status =>l_return_status
4189: ,x_msg_count => l_msg_count

Line 4187: ,p_commit =>fnd_api.g_false

4183: IF l_retroactive = 'Y' THEN
4184: ozf_volume_calculation_pub.get_volume
4185: (p_init_msg_list =>fnd_api.g_false
4186: ,p_api_version =>1.0
4187: ,p_commit =>fnd_api.g_false
4188: ,x_return_status =>l_return_status
4189: ,x_msg_count => l_msg_count
4190: ,x_msg_data => l_msg_data
4191: ,p_qp_list_header_id => l_qp_list_header_id

Line 4209: (p_init_msg_list =>fnd_api.g_false

4205: l_trx_date := l_glDateTbl(i);
4206: END IF;
4207: write_conc_log('transaction_date after conversion: ' || TO_CHAR(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
4208: ozf_volume_calculation_pub.get_volume
4209: (p_init_msg_list =>fnd_api.g_false
4210: ,p_api_version =>1.0
4211: ,p_commit =>fnd_api.g_false
4212: ,x_return_status =>l_return_status
4213: ,x_msg_count => l_msg_count

Line 4211: ,p_commit =>fnd_api.g_false

4207: write_conc_log('transaction_date after conversion: ' || TO_CHAR(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
4208: ozf_volume_calculation_pub.get_volume
4209: (p_init_msg_list =>fnd_api.g_false
4210: ,p_api_version =>1.0
4211: ,p_commit =>fnd_api.g_false
4212: ,x_return_status =>l_return_status
4213: ,x_msg_count => l_msg_count
4214: ,x_msg_data => l_msg_data
4215: ,p_qp_list_header_id => l_qp_list_header_id

Line 4224: IF l_return_status = fnd_api.g_ret_sts_error THEN

4220: ,x_acc_volume => l_volume
4221: );
4222: END IF;
4223:
4224: IF l_return_status = fnd_api.g_ret_sts_error THEN
4225: RAISE fnd_api.g_exc_error;
4226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4227: RAISE fnd_api.g_exc_unexpected_error;
4228: END IF;

Line 4225: RAISE fnd_api.g_exc_error;

4221: );
4222: END IF;
4223:
4224: IF l_return_status = fnd_api.g_ret_sts_error THEN
4225: RAISE fnd_api.g_exc_error;
4226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4227: RAISE fnd_api.g_exc_unexpected_error;
4228: END IF;
4229: -- END IF; --l_retroactive = 'Y'

Line 4226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4222: END IF;
4223:
4224: IF l_return_status = fnd_api.g_ret_sts_error THEN
4225: RAISE fnd_api.g_exc_error;
4226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4227: RAISE fnd_api.g_exc_unexpected_error;
4228: END IF;
4229: -- END IF; --l_retroactive = 'Y'
4230:

Line 4227: RAISE fnd_api.g_exc_unexpected_error;

4223:
4224: IF l_return_status = fnd_api.g_ret_sts_error THEN
4225: RAISE fnd_api.g_exc_error;
4226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4227: RAISE fnd_api.g_exc_unexpected_error;
4228: END IF;
4229: -- END IF; --l_retroactive = 'Y'
4230:
4231: IF G_DEBUG THEN

Line 4476: IF l_return_status = fnd_api.g_ret_sts_error THEN

4472: x_return_status =>l_return_status,
4473: x_msg_count =>l_msg_count,
4474: x_msg_data =>l_msg_data );
4475:
4476: IF l_return_status = fnd_api.g_ret_sts_error THEN
4477: RAISE fnd_api.g_exc_error;
4478: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4479: RAISE fnd_api.g_exc_unexpected_error;
4480: END IF;

Line 4477: RAISE fnd_api.g_exc_error;

4473: x_msg_count =>l_msg_count,
4474: x_msg_data =>l_msg_data );
4475:
4476: IF l_return_status = fnd_api.g_ret_sts_error THEN
4477: RAISE fnd_api.g_exc_error;
4478: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4479: RAISE fnd_api.g_exc_unexpected_error;
4480: END IF;
4481: END IF;

Line 4478: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4474: x_msg_data =>l_msg_data );
4475:
4476: IF l_return_status = fnd_api.g_ret_sts_error THEN
4477: RAISE fnd_api.g_exc_error;
4478: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4479: RAISE fnd_api.g_exc_unexpected_error;
4480: END IF;
4481: END IF;
4482:

Line 4479: RAISE fnd_api.g_exc_unexpected_error;

4475:
4476: IF l_return_status = fnd_api.g_ret_sts_error THEN
4477: RAISE fnd_api.g_exc_error;
4478: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4479: RAISE fnd_api.g_exc_unexpected_error;
4480: END IF;
4481: END IF;
4482:
4483: IF G_DEBUG THEN

Line 4499: IF l_return_status = fnd_api.g_ret_sts_error THEN

4495: EXIT WHEN c_old_price_adj%NOTFOUND;
4496: END LOOP; -- end price adj loop
4497: CLOSE c_old_price_adj;
4498:
4499: IF l_return_status = fnd_api.g_ret_sts_error THEN
4500: RAISE fnd_api.g_exc_error;
4501: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4502: RAISE fnd_api.g_exc_unexpected_error;
4503: END IF;

Line 4500: RAISE fnd_api.g_exc_error;

4496: END LOOP; -- end price adj loop
4497: CLOSE c_old_price_adj;
4498:
4499: IF l_return_status = fnd_api.g_ret_sts_error THEN
4500: RAISE fnd_api.g_exc_error;
4501: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4502: RAISE fnd_api.g_exc_unexpected_error;
4503: END IF;
4504:

Line 4501: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4497: CLOSE c_old_price_adj;
4498:
4499: IF l_return_status = fnd_api.g_ret_sts_error THEN
4500: RAISE fnd_api.g_exc_error;
4501: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4502: RAISE fnd_api.g_exc_unexpected_error;
4503: END IF;
4504:
4505: <>

Line 4502: RAISE fnd_api.g_exc_unexpected_error;

4498:
4499: IF l_return_status = fnd_api.g_ret_sts_error THEN
4500: RAISE fnd_api.g_exc_error;
4501: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4502: RAISE fnd_api.g_exc_unexpected_error;
4503: END IF;
4504:
4505: <>
4506: NULL;

Line 4513: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4509: ozf_utility_pvt.debug_message(' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
4510: END IF;
4511: write_conc_log(' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
4512:
4513: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4514:
4515: x_return_status := l_return_status;
4516:
4517: EXCEPTION

Line 4518: WHEN fnd_api.g_exc_error THEN

4514:
4515: x_return_status := l_return_status;
4516:
4517: EXCEPTION
4518: WHEN fnd_api.g_exc_error THEN
4519: ROLLBACK TO volume_offer_adjustment;
4520: x_return_status := fnd_api.g_ret_sts_error;
4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4520: x_return_status := fnd_api.g_ret_sts_error;

4516:
4517: EXCEPTION
4518: WHEN fnd_api.g_exc_error THEN
4519: ROLLBACK TO volume_offer_adjustment;
4520: x_return_status := fnd_api.g_ret_sts_error;
4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN
4523: ROLLBACK TO volume_offer_adjustment;
4524: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4517: EXCEPTION
4518: WHEN fnd_api.g_exc_error THEN
4519: ROLLBACK TO volume_offer_adjustment;
4520: x_return_status := fnd_api.g_ret_sts_error;
4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN
4523: ROLLBACK TO volume_offer_adjustment;
4524: x_return_status := fnd_api.g_ret_sts_unexp_error;
4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4522: WHEN fnd_api.g_exc_unexpected_error THEN

4518: WHEN fnd_api.g_exc_error THEN
4519: ROLLBACK TO volume_offer_adjustment;
4520: x_return_status := fnd_api.g_ret_sts_error;
4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN
4523: ROLLBACK TO volume_offer_adjustment;
4524: x_return_status := fnd_api.g_ret_sts_unexp_error;
4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4526: WHEN OTHERS THEN

Line 4524: x_return_status := fnd_api.g_ret_sts_unexp_error;

4520: x_return_status := fnd_api.g_ret_sts_error;
4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN
4523: ROLLBACK TO volume_offer_adjustment;
4524: x_return_status := fnd_api.g_ret_sts_unexp_error;
4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4526: WHEN OTHERS THEN
4527: ROLLBACK TO volume_offer_adjustment;
4528: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN
4523: ROLLBACK TO volume_offer_adjustment;
4524: x_return_status := fnd_api.g_ret_sts_unexp_error;
4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4526: WHEN OTHERS THEN
4527: ROLLBACK TO volume_offer_adjustment;
4528: x_return_status := fnd_api.g_ret_sts_unexp_error;
4529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4528: x_return_status := fnd_api.g_ret_sts_unexp_error;

4524: x_return_status := fnd_api.g_ret_sts_unexp_error;
4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4526: WHEN OTHERS THEN
4527: ROLLBACK TO volume_offer_adjustment;
4528: x_return_status := fnd_api.g_ret_sts_unexp_error;
4529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4530: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4531: END IF;
4532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4528: x_return_status := fnd_api.g_ret_sts_unexp_error;
4529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4530: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4531: END IF;
4532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4533:
4534: END volume_offer_adjustment;
4535:
4536:

Line 4876: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;

4872: l_offer_curr VARCHAR2(30);
4873: l_offer_id NUMBER;
4874: l_selling_price NUMBER;
4875: l_apply_discount VARCHAR2(1) ;
4876: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;
4877: l_conv_price NUMBER;
4878: l_rate NUMBER;
4879: l_new_utilization NUMBER;
4880: l_invoice_to_org_id NUMBER;

Line 5042: IF l_return_status = fnd_api.g_ret_sts_error THEN

5038: ,x_to_amount => l_conv_price
5039: ,x_rate => l_rate
5040: );
5041:
5042: IF l_return_status = fnd_api.g_ret_sts_error THEN
5043: RAISE fnd_api.g_exc_error;
5044: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5045: RAISE fnd_api.g_exc_unexpected_error;
5046: END IF;

Line 5043: RAISE fnd_api.g_exc_error;

5039: ,x_rate => l_rate
5040: );
5041:
5042: IF l_return_status = fnd_api.g_ret_sts_error THEN
5043: RAISE fnd_api.g_exc_error;
5044: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5045: RAISE fnd_api.g_exc_unexpected_error;
5046: END IF;
5047:

Line 5044: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5040: );
5041:
5042: IF l_return_status = fnd_api.g_ret_sts_error THEN
5043: RAISE fnd_api.g_exc_error;
5044: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5045: RAISE fnd_api.g_exc_unexpected_error;
5046: END IF;
5047:
5048: l_selling_price := NVL(l_conv_price,0);

Line 5045: RAISE fnd_api.g_exc_unexpected_error;

5041:
5042: IF l_return_status = fnd_api.g_ret_sts_error THEN
5043: RAISE fnd_api.g_exc_error;
5044: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5045: RAISE fnd_api.g_exc_unexpected_error;
5046: END IF;
5047:
5048: l_selling_price := NVL(l_conv_price,0);
5049: write_conc_log ('selling price after currency conversion: ' || l_selling_price);

Line 5415: IF l_return_status = fnd_api.g_ret_sts_error THEN

5411: ,x_act_budget_id => l_act_budget_id
5412: );
5413:
5414: write_conc_log('process_act_budgets returns: ' || x_return_status);
5415: IF l_return_status = fnd_api.g_ret_sts_error THEN
5416: RAISE fnd_api.g_exc_error;
5417: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5418: RAISE fnd_api.g_exc_unexpected_error;
5419: END IF;

Line 5416: RAISE fnd_api.g_exc_error;

5412: );
5413:
5414: write_conc_log('process_act_budgets returns: ' || x_return_status);
5415: IF l_return_status = fnd_api.g_ret_sts_error THEN
5416: RAISE fnd_api.g_exc_error;
5417: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5418: RAISE fnd_api.g_exc_unexpected_error;
5419: END IF;
5420: END IF;

Line 5417: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5413:
5414: write_conc_log('process_act_budgets returns: ' || x_return_status);
5415: IF l_return_status = fnd_api.g_ret_sts_error THEN
5416: RAISE fnd_api.g_exc_error;
5417: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5418: RAISE fnd_api.g_exc_unexpected_error;
5419: END IF;
5420: END IF;
5421: -- END IF;

Line 5418: RAISE fnd_api.g_exc_unexpected_error;

5414: write_conc_log('process_act_budgets returns: ' || x_return_status);
5415: IF l_return_status = fnd_api.g_ret_sts_error THEN
5416: RAISE fnd_api.g_exc_error;
5417: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5418: RAISE fnd_api.g_exc_unexpected_error;
5419: END IF;
5420: END IF;
5421: -- END IF;
5422: