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 153: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

149: p_from_date IN DATE,
150: p_to_date IN DATE,
151: p_qp_list_header_id IN NUMBER,
152: p_offer_adjustment_id IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
154: p_commit IN VARCHAR2 := fnd_api.g_false,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2

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

150: p_to_date IN DATE,
151: p_qp_list_header_id IN NUMBER,
152: p_offer_adjustment_id IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
154: p_commit IN VARCHAR2 := fnd_api.g_false,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2
158: );

Line 318: IF Fnd_Api.to_boolean(p_init_msg_list) THEN

314: l_uom_ratio NUMBER;
315:
316: BEGIN
317:
318: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
319: Fnd_Msg_Pub.initialize;
320: END IF;
321:
322: x_return_status := Fnd_Api.g_ret_sts_success;

Line 322: x_return_status := Fnd_Api.g_ret_sts_success;

318: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
319: Fnd_Msg_Pub.initialize;
320: END IF;
321:
322: x_return_status := Fnd_Api.g_ret_sts_success;
323:
324: --kdass 28-FEB-2006 fixed bug 5059735 - denorm offer's product eligibility to handle all types of product levels
325: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
326:

Line 372: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: ROLLBACK TO refresh_prod;
372: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
373: write_conc_log ('unexpected exception in refresh_products');
374: END;
375:
376: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 376: IF x_return_status <> fnd_api.g_ret_sts_success THEN

372: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
373: write_conc_log ('unexpected exception in refresh_products');
374: END;
375:
376: IF x_return_status <> fnd_api.g_ret_sts_success THEN
377: RETURN;
378: END IF;
379:
380: l_count_temp := 0;

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

637: FROM oe_order_lines_all
638: WHERE line_id = p_order_line_id;
639:
640: l_order_org_id NUMBER;
641: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
642: l_autopay_party_id NUMBER;
643: l_autopay_party_attr VARCHAR2(30);
644: l_org_id NUMBER; -- site's lorg id
645:

Line 716: ,p_init_msg_list => FND_API.G_FALSE

712: write_conc_log ('offer_currency ' || p_offer_currency);
713:
714: --get the qualified orders
715: get_orders(p_api_version => p_api_version
716: ,p_init_msg_list => FND_API.G_FALSE
717: ,p_commit => FND_API.G_FALSE
718: ,x_return_status => x_return_status
719: ,x_msg_count => x_msg_count
720: ,x_msg_data => x_msg_data

Line 717: ,p_commit => FND_API.G_FALSE

713:
714: --get the qualified orders
715: get_orders(p_api_version => p_api_version
716: ,p_init_msg_list => FND_API.G_FALSE
717: ,p_commit => FND_API.G_FALSE
718: ,x_return_status => x_return_status
719: ,x_msg_count => x_msg_count
720: ,x_msg_data => x_msg_data
721: ,p_list_header_id => p_list_header_id

Line 736: IF x_return_status = fnd_api.g_ret_sts_error THEN

732: write_conc_log ('x_return_status: ' || x_return_status);
733: write_conc_log ('number of orders: ' || l_order_line_tbl.count);
734:
735: /*kdass 04-AUG-2006 fixed bug 5446622
736: IF x_return_status = fnd_api.g_ret_sts_error THEN
737: RAISE fnd_api.g_exc_error;
738: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;

Line 737: RAISE fnd_api.g_exc_error;

733: write_conc_log ('number of orders: ' || l_order_line_tbl.count);
734:
735: /*kdass 04-AUG-2006 fixed bug 5446622
736: IF x_return_status = fnd_api.g_ret_sts_error THEN
737: RAISE fnd_api.g_exc_error;
738: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;
741: */

Line 738: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

734:
735: /*kdass 04-AUG-2006 fixed bug 5446622
736: IF x_return_status = fnd_api.g_ret_sts_error THEN
737: RAISE fnd_api.g_exc_error;
738: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;
741: */
742: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 739: RAISE fnd_api.g_exc_unexpected_error;

735: /*kdass 04-AUG-2006 fixed bug 5446622
736: IF x_return_status = fnd_api.g_ret_sts_error THEN
737: RAISE fnd_api.g_exc_error;
738: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;
741: */
742: IF x_return_status <> fnd_api.g_ret_sts_success THEN
743: RETURN;

Line 742: IF x_return_status <> fnd_api.g_ret_sts_success THEN

738: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;
741: */
742: IF x_return_status <> fnd_api.g_ret_sts_success THEN
743: RETURN;
744: END IF;
745:
746: IF p_type = 'product' THEN

Line 885: IF x_return_status <> fnd_api.g_ret_sts_success THEN

881: ,x_rate => l_rate
882: );
883:
884: ozf_utility_pvt.write_conc_log('x_return_status: ' || x_return_status);
885: IF x_return_status <> fnd_api.g_ret_sts_success THEN
886: RETURN;
887: END IF;
888:
889: l_util_amount := l_conv_util_amount;

Line 1009: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1005: );
1006:
1007: write_conc_log('process_act_budgets returns: ' || x_return_status);
1008:
1009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1010: RETURN;
1011: END IF;
1012:
1013: END IF;

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

1269: l_included_vol_flag VARCHAR2(1);
1270: l_retroactive VARCHAR2(1) ;
1271: l_discount_type VARCHAR2(30);
1272: l_volume_type VARCHAR2(30);
1273: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;
1274: l_msg_count NUMBER;
1275: l_msg_data VARCHAR2 (2000) := NULL;
1276: l_source_code VARCHAR2(30);
1277: l_volume NUMBER;

Line 1305: ,p_init_msg_list => FND_API.G_FALSE

1301: write_conc_log ('offer_currency ' || p_offer_currency);
1302:
1303: --get the qualified orders
1304: get_orders(p_api_version => p_api_version
1305: ,p_init_msg_list => FND_API.G_FALSE
1306: ,p_commit => FND_API.G_FALSE
1307: ,x_return_status => x_return_status
1308: ,x_msg_count => x_msg_count
1309: ,x_msg_data => x_msg_data

Line 1306: ,p_commit => FND_API.G_FALSE

1302:
1303: --get the qualified orders
1304: get_orders(p_api_version => p_api_version
1305: ,p_init_msg_list => FND_API.G_FALSE
1306: ,p_commit => FND_API.G_FALSE
1307: ,x_return_status => x_return_status
1308: ,x_msg_count => x_msg_count
1309: ,x_msg_data => x_msg_data
1310: ,p_list_header_id => p_list_header_id

Line 1546: ,p_init_msg_list => FND_API.G_FALSE

1542:
1543: write_conc_log('calling Create_Transaction');
1544:
1545: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
1546: ,p_init_msg_list => FND_API.G_FALSE
1547: ,p_commit => FND_API.G_FALSE
1548: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1549: ,p_transaction_rec => l_sales_transaction_rec
1550: ,x_sales_transaction_id => l_sales_transaction_id

Line 1547: ,p_commit => FND_API.G_FALSE

1543: write_conc_log('calling Create_Transaction');
1544:
1545: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
1546: ,p_init_msg_list => FND_API.G_FALSE
1547: ,p_commit => FND_API.G_FALSE
1548: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1549: ,p_transaction_rec => l_sales_transaction_rec
1550: ,x_sales_transaction_id => l_sales_transaction_id
1551: ,x_return_status => x_return_status

Line 1548: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1544:
1545: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
1546: ,p_init_msg_list => FND_API.G_FALSE
1547: ,p_commit => FND_API.G_FALSE
1548: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1549: ,p_transaction_rec => l_sales_transaction_rec
1550: ,x_sales_transaction_id => l_sales_transaction_id
1551: ,x_return_status => x_return_status
1552: ,x_msg_data => x_msg_data

Line 1559: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1555:
1556: write_conc_log('Create_Transaction returns: ' || x_return_status);
1557: write_conc_log('l_sales_transaction_id: ' || l_sales_transaction_id);
1558:
1559: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1560: RETURN;
1561: END IF;
1562:
1563: END IF; --IF l_gl_date IS NOT NULL THEN

Line 1711: IF l_return_status = fnd_api.g_ret_sts_error THEN

1707: ,x_to_amount => l_conv_price
1708: ,x_rate => l_rate
1709: );
1710:
1711: IF l_return_status = fnd_api.g_ret_sts_error THEN
1712: RAISE fnd_api.g_exc_error;
1713: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1714: RAISE fnd_api.g_exc_unexpected_error;
1715: END IF;

Line 1712: RAISE fnd_api.g_exc_error;

1708: ,x_rate => l_rate
1709: );
1710:
1711: IF l_return_status = fnd_api.g_ret_sts_error THEN
1712: RAISE fnd_api.g_exc_error;
1713: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1714: RAISE fnd_api.g_exc_unexpected_error;
1715: END IF;
1716:

Line 1713: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1709: );
1710:
1711: IF l_return_status = fnd_api.g_ret_sts_error THEN
1712: RAISE fnd_api.g_exc_error;
1713: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1714: RAISE fnd_api.g_exc_unexpected_error;
1715: END IF;
1716:
1717: l_unit_selling_price := l_conv_price;

Line 1714: RAISE fnd_api.g_exc_unexpected_error;

1710:
1711: IF l_return_status = fnd_api.g_ret_sts_error THEN
1712: RAISE fnd_api.g_exc_error;
1713: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1714: RAISE fnd_api.g_exc_unexpected_error;
1715: END IF;
1716:
1717: l_unit_selling_price := l_conv_price;
1718: write_conc_log ('selling price after currency conversion: ' || l_unit_selling_price);

Line 1897: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1893: );
1894:
1895: write_conc_log('process_act_budgets returns: ' || x_return_status);
1896:
1897: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1898: RETURN;
1899: END IF;
1900:
1901: --END IF; --IF NVL(l_adjustment_exists,0) <> 1 THEN

Line 2919: x_return_status :=fnd_api.g_ret_sts_success;

2915: );
2916:
2917: /*removed code for future dated adjustments since offers team will be taking care of this.
2918: original code in version 120.19 */
2919: x_return_status :=fnd_api.g_ret_sts_success;
2920:
2921: -- Perform Adjustments for the already executed offer (for the orders raised between Effective Date and Approved Date)
2922: -- Fixed 10/23/2002 mpande
2923: IF l_offer_info.offer_type <> 'VOLUME_OFFER' THEN

Line 2938: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2934: ,x_msg_data=> l_msg_data
2935: );
2936:
2937:
2938: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2939: ozf_utility_pvt.write_conc_log ('/****** '
2940: || 'Offer Adjustment Failed For Offer'
2941: || l_offer_info.description
2942: || ' SOURCE CODE '

Line 2968: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2964: ,x_msg_count=> l_msg_count
2965: ,x_msg_data=> l_msg_data
2966: );
2967:
2968: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2969: ozf_utility_pvt.write_conc_log ('volume adjustment Failed'
2970: || l_offer_info.description
2971: || ' SOURCE CODE '
2972: || l_offer_info.NAME

Line 3004: ,p_init_msg_list => FND_API.G_FALSE

3000: BEGIN
3001: SAVEPOINT refresh_prod;
3002:
3003: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => l_api_version
3004: ,p_init_msg_list => FND_API.G_FALSE
3005: ,p_commit => FND_API.G_FALSE
3006: ,p_list_header_id => l_listHeaderIdTbl(i)
3007: ,p_calling_from_den => 'N'
3008: ,x_return_status => x_return_status

Line 3005: ,p_commit => FND_API.G_FALSE

3001: SAVEPOINT refresh_prod;
3002:
3003: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => l_api_version
3004: ,p_init_msg_list => FND_API.G_FALSE
3005: ,p_commit => FND_API.G_FALSE
3006: ,p_list_header_id => l_listHeaderIdTbl(i)
3007: ,p_calling_from_den => 'N'
3008: ,x_return_status => x_return_status
3009: ,x_msg_count => l_msg_count

Line 3029: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

3025:
3026: EXCEPTION
3027: WHEN OTHERS THEN
3028: ROLLBACK TO refresh_prod;
3029: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
3030: write_conc_log ('unexpected exception in refresh_products');
3031: END;
3032:
3033:

Line 3826: IF l_return_status_code <> FND_API.G_RET_STS_SUCCESS THEN

3822: write_conc_log ('l_return_status_code ' || l_return_status_code);
3823: write_conc_log ('l_price_return_msg ' || l_price_return_msg);
3824: END IF;
3825:
3826: IF l_return_status_code <> FND_API.G_RET_STS_SUCCESS THEN
3827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3828: FND_MESSAGE.set_name('OZF', 'OZF_ORDER_INSERT_ERR');
3829: FND_MSG_PUB.add;
3830: dbms_output.put_line(l_price_return_msg);

Line 3832: RAISE FND_API.G_EXC_ERROR;

3828: FND_MESSAGE.set_name('OZF', 'OZF_ORDER_INSERT_ERR');
3829: FND_MSG_PUB.add;
3830: dbms_output.put_line(l_price_return_msg);
3831: END IF;
3832: RAISE FND_API.G_EXC_ERROR;
3833: END IF;
3834:
3835:
3836: -- Call qp price engine

Line 3847: IF x_return_status = FND_API.g_ret_sts_error THEN

3843: write_conc_log ('x_return_status ' || x_return_status);
3844: write_conc_log ('l_msg_data ' || l_msg_data);
3845: END IF;
3846:
3847: IF x_return_status = FND_API.g_ret_sts_error THEN
3848: write_conc_log('in error'|| l_msg_data);
3849: RAISE FND_API.g_exc_error;
3850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3851: write_conc_log('in un'|| l_msg_data);

Line 3849: RAISE FND_API.g_exc_error;

3845: END IF;
3846:
3847: IF x_return_status = FND_API.g_ret_sts_error THEN
3848: write_conc_log('in error'|| l_msg_data);
3849: RAISE FND_API.g_exc_error;
3850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3851: write_conc_log('in un'|| l_msg_data);
3852: RAISE FND_API.g_exc_unexpected_error;
3853: END IF;

Line 3850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3846:
3847: IF x_return_status = FND_API.g_ret_sts_error THEN
3848: write_conc_log('in error'|| l_msg_data);
3849: RAISE FND_API.g_exc_error;
3850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3851: write_conc_log('in un'|| l_msg_data);
3852: RAISE FND_API.g_exc_unexpected_error;
3853: END IF;
3854:

Line 3852: RAISE FND_API.g_exc_unexpected_error;

3848: write_conc_log('in error'|| l_msg_data);
3849: RAISE FND_API.g_exc_error;
3850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3851: write_conc_log('in un'|| l_msg_data);
3852: RAISE FND_API.g_exc_unexpected_error;
3853: END IF;
3854:
3855: Process_Pricing_Result(
3856: p_header_id => l_uniqueHeaderIdtbl(P),

Line 3861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3857: p_line_tbl => l_line_tbl,
3858: p_adjIdByListHdrId => l_adjIdByListHdrId,
3859: x_return_status => x_return_status);
3860:
3861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3862: write_conc_log('Process_Pricing_Result '|| x_return_status);
3863: END IF;
3864: write_conc_log( '--------------------------------------------------------');
3865: COMMIT;

Line 3909: --IF x_return_status = fnd_api.g_ret_sts_success THEN

3905: --loop of orders qualified for backdated adjustment
3906: -- If only regular adjustment is processed successfully.
3907: --adjustment should get closed.
3908:
3909: --IF x_return_status = fnd_api.g_ret_sts_success THEN
3910:
3911: -- handle TP Orders distinctly as backdated adjustment is not supported.
3912:
3913: IF g_debug_flag = 'Y' THEN

Line 3946: WHEN FND_API.G_EXC_ERROR THEN

3942:
3943:
3944: write_conc_log (' /*************************** ADJUST BD END *************************/');
3945: EXCEPTION
3946: WHEN FND_API.G_EXC_ERROR THEN
3947: ROLLBACK TO adjust_backdated_offer;
3948: x_retcode := 1;
3949: x_errbuf := l_msg_data;
3950: ozf_utility_pvt.write_conc_log;

Line 3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3949: x_errbuf := l_msg_data;
3950: ozf_utility_pvt.write_conc_log;
3951: ozf_utility_pvt.write_conc_log (x_errbuf);
3952: write_conc_log( 'G_EXC_ERROR'||sqlerrm );
3953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3954: ROLLBACK TO adjust_backdated_offer;
3955: x_retcode := 1;
3956: x_errbuf := l_msg_data;
3957: ozf_utility_pvt.write_conc_log;

Line 4022: x_return_status := FND_API.G_RET_STS_SUCCESS;

4018: AND list_header_id = p_list_header_id;
4019:
4020: BEGIN
4021: -- Initialize API return status to sucess
4022: x_return_status := FND_API.G_RET_STS_SUCCESS;
4023:
4024: ozf_utility_pvt.write_conc_log('p_list_header_id '||p_list_header_id );
4025: ozf_utility_pvt.write_conc_log('p_list_line_id '||p_list_line_id);
4026: ozf_utility_pvt.write_conc_log('p_line_id '||p_line_id);

Line 4071: WHEN FND_API.G_EXC_ERROR THEN

4067: END IF;
4068:
4069:
4070: EXCEPTION
4071: WHEN FND_API.G_EXC_ERROR THEN
4072: x_return_status := FND_API.G_RET_STS_ERROR;
4073: WHEN OTHERS THEN
4074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4075: IF g_debug_flag = 'Y' THEN

Line 4072: x_return_status := FND_API.G_RET_STS_ERROR;

4068:
4069:
4070: EXCEPTION
4071: WHEN FND_API.G_EXC_ERROR THEN
4072: x_return_status := FND_API.G_RET_STS_ERROR;
4073: WHEN OTHERS THEN
4074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4075: IF g_debug_flag = 'Y' THEN
4076: ozf_utility_pvt.write_conc_log('Exception in is_valid_offer ');

Line 4074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4070: EXCEPTION
4071: WHEN FND_API.G_EXC_ERROR THEN
4072: x_return_status := FND_API.G_RET_STS_ERROR;
4073: WHEN OTHERS THEN
4074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4075: IF g_debug_flag = 'Y' THEN
4076: ozf_utility_pvt.write_conc_log('Exception in is_valid_offer ');
4077: END IF;
4078: END is_valid_offer;

Line 4242: x_return_status := FND_API.G_RET_STS_SUCCESS;

4238: IF g_debug_flag = 'Y' THEN
4239: OZF_UTILITY_PVT.write_conc_log(l_full_name||': start');
4240: END IF;
4241:
4242: x_return_status := FND_API.G_RET_STS_SUCCESS;
4243:
4244: SAVEPOINT PROC_VO_RESULT;
4245:
4246: --Since, pricing call is already made, removed the simulation of pricing call.

Line 4499: ,p_init_msg_list => FND_API.G_FALSE

4495:
4496: write_conc_log('calling Create_Transaction');
4497:
4498: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
4499: ,p_init_msg_list => FND_API.G_FALSE
4500: ,p_commit => FND_API.G_FALSE
4501: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
4502: ,p_transaction_rec => l_sales_transaction_rec
4503: ,x_sales_transaction_id => l_sales_transaction_id

Line 4500: ,p_commit => FND_API.G_FALSE

4496: write_conc_log('calling Create_Transaction');
4497:
4498: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
4499: ,p_init_msg_list => FND_API.G_FALSE
4500: ,p_commit => FND_API.G_FALSE
4501: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
4502: ,p_transaction_rec => l_sales_transaction_rec
4503: ,x_sales_transaction_id => l_sales_transaction_id
4504: ,x_return_status => x_return_status

Line 4501: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

4497:
4498: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
4499: ,p_init_msg_list => FND_API.G_FALSE
4500: ,p_commit => FND_API.G_FALSE
4501: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
4502: ,p_transaction_rec => l_sales_transaction_rec
4503: ,x_sales_transaction_id => l_sales_transaction_id
4504: ,x_return_status => x_return_status
4505: ,x_msg_data => l_msg_data

Line 4512: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4508:
4509: write_conc_log('Create_Transaction returns: ' || x_return_status);
4510: write_conc_log('l_sales_transaction_id: ' || l_sales_transaction_id);
4511:
4512: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4513: RETURN;
4514: END IF;
4515: END IF; --IF l_gl_date IS NOT NULL THEN
4516:

Line 4658: IF l_return_status = fnd_api.g_ret_sts_error THEN

4654: ,x_to_amount => l_conv_price
4655: ,x_rate => l_rate
4656: );
4657:
4658: IF l_return_status = fnd_api.g_ret_sts_error THEN
4659: RAISE fnd_api.g_exc_error;
4660: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4661: RAISE fnd_api.g_exc_unexpected_error;
4662: END IF;

Line 4659: RAISE fnd_api.g_exc_error;

4655: ,x_rate => l_rate
4656: );
4657:
4658: IF l_return_status = fnd_api.g_ret_sts_error THEN
4659: RAISE fnd_api.g_exc_error;
4660: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4661: RAISE fnd_api.g_exc_unexpected_error;
4662: END IF;
4663:

Line 4660: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4656: );
4657:
4658: IF l_return_status = fnd_api.g_ret_sts_error THEN
4659: RAISE fnd_api.g_exc_error;
4660: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4661: RAISE fnd_api.g_exc_unexpected_error;
4662: END IF;
4663:
4664: l_unit_selling_price := l_conv_price;

Line 4661: RAISE fnd_api.g_exc_unexpected_error;

4657:
4658: IF l_return_status = fnd_api.g_ret_sts_error THEN
4659: RAISE fnd_api.g_exc_error;
4660: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4661: RAISE fnd_api.g_exc_unexpected_error;
4662: END IF;
4663:
4664: l_unit_selling_price := l_conv_price;
4665: write_conc_log ('selling price after currency conversion: ' || l_unit_selling_price);

Line 4721: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4717: );
4718:
4719: write_conc_log('process_act_budgets returns: ' || x_return_status);
4720:
4721: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4722: ROLLBACK TO PROC_VO_RESULT;
4723: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
4724: write_conc_log('Adjustment creation failed for offer: ' || p_ldets_rec.list_header_id);
4725: RETURN;

Line 4734: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4730: ,x_msg_count=> l_msg_count
4731: ,x_msg_data=> l_msg_data
4732: );
4733:
4734: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4735: ozf_utility_pvt.write_conc_log ('volume adjustment Failed'
4736: || p_ldets_rec.list_header_id
4737: || ' SOURCE CODE '
4738: || p_adjIdByListHdrId(p_ldets_rec.list_header_id)

Line 4757: WHEN FND_API.G_EXC_ERROR THEN

4753: OZF_UTILITY_PVT.write_conc_log(l_full_name||': end');
4754: END IF;
4755:
4756: EXCEPTION
4757: WHEN FND_API.G_EXC_ERROR THEN
4758: ROLLBACK TO PROC_VO_RESULT;
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4761: ROLLBACK TO PROC_VO_RESULT;

Line 4759: x_return_status := FND_API.G_RET_STS_ERROR;

4755:
4756: EXCEPTION
4757: WHEN FND_API.G_EXC_ERROR THEN
4758: ROLLBACK TO PROC_VO_RESULT;
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4761: ROLLBACK TO PROC_VO_RESULT;
4762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4763: WHEN OTHERS THEN

Line 4760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4756: EXCEPTION
4757: WHEN FND_API.G_EXC_ERROR THEN
4758: ROLLBACK TO PROC_VO_RESULT;
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4761: ROLLBACK TO PROC_VO_RESULT;
4762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4763: WHEN OTHERS THEN
4764: ROLLBACK TO PROC_VO_RESULT;

Line 4762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4758: ROLLBACK TO PROC_VO_RESULT;
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4761: ROLLBACK TO PROC_VO_RESULT;
4762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4763: WHEN OTHERS THEN
4764: ROLLBACK TO PROC_VO_RESULT;
4765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4766: END Process_VO_Result;

Line 4765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4761: ROLLBACK TO PROC_VO_RESULT;
4762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4763: WHEN OTHERS THEN
4764: ROLLBACK TO PROC_VO_RESULT;
4765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4766: END Process_VO_Result;
4767:
4768: ---------------------------------------------------------------------
4769: -- PROCEDURE

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

4896: l_column_name VARCHAR2(15);
4897: l_stmt VARCHAR2(3000);
4898: c_purchase_price purchase_price_cursor_type;
4899: l_cost_price NUMBER := 0;
4900: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
4901: l_justification VARCHAR2(50);
4902: l_rate NUMBER;
4903: l_msg_count NUMBER;
4904: l_msg_data VARCHAR2 (2000) := NULL;

Line 4918: x_return_status := FND_API.G_RET_STS_SUCCESS;

4914: IF g_debug_flag = 'Y' THEN
4915: OZF_UTILITY_PVT.debug_message(l_full_name||': start');
4916: END IF;
4917:
4918: x_return_status := FND_API.G_RET_STS_SUCCESS;
4919:
4920: SAVEPOINT PROC_SSD_RESULT;
4921:
4922: OPEN c_offer_info(p_ldets_rec.list_header_id);

Line 5067: IF l_column_name IS NOT NULL AND l_column_name <> FND_API.G_MISS_CHAR THEN

5063:
5064: MO_GLOBAL.set_policy_context('S', l_order_org_id);
5065: l_column_name := FND_PROFILE.VALUE('OZF_ITEM_COST_COLUMN');
5066:
5067: IF l_column_name IS NOT NULL AND l_column_name <> FND_API.G_MISS_CHAR THEN
5068: l_stmt := 'SELECT ' || l_column_name ||' FROM oe_order_lines_all WHERE line_id = :1 AND org_id = :2';
5069: IF g_debug_flag = 'Y' THEN
5070: ozf_utility_pvt.write_conc_log('Query to obtain purchase price '||l_stmt);
5071: END IF;

Line 5264: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5260: ,x_act_budget_id => l_act_budget_id
5261: );
5262:
5263: write_conc_log('process_act_budgets returns: ' || x_return_status);
5264: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5265: ROLLBACK TO PROC_SSD_RESULT;
5266: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5267: write_conc_log('Adjustment creation failed for offer: ' || p_ldets_rec.list_header_id);
5268: RETURN;

Line 5279: WHEN FND_API.G_EXC_ERROR THEN

5275: OZF_UTILITY_PVT.write_conc_log(l_full_name||': end');
5276: END IF;
5277:
5278: EXCEPTION
5279: WHEN FND_API.G_EXC_ERROR THEN
5280: ROLLBACK TO PROC_SSD_RESULT;
5281: x_return_status := FND_API.G_RET_STS_ERROR;
5282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5283: ROLLBACK TO PROC_SSD_RESULT;

Line 5281: x_return_status := FND_API.G_RET_STS_ERROR;

5277:
5278: EXCEPTION
5279: WHEN FND_API.G_EXC_ERROR THEN
5280: ROLLBACK TO PROC_SSD_RESULT;
5281: x_return_status := FND_API.G_RET_STS_ERROR;
5282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5283: ROLLBACK TO PROC_SSD_RESULT;
5284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5285: WHEN OTHERS THEN

Line 5282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5278: EXCEPTION
5279: WHEN FND_API.G_EXC_ERROR THEN
5280: ROLLBACK TO PROC_SSD_RESULT;
5281: x_return_status := FND_API.G_RET_STS_ERROR;
5282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5283: ROLLBACK TO PROC_SSD_RESULT;
5284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5285: WHEN OTHERS THEN
5286: ROLLBACK TO PROC_SSD_RESULT;

Line 5284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5280: ROLLBACK TO PROC_SSD_RESULT;
5281: x_return_status := FND_API.G_RET_STS_ERROR;
5282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5283: ROLLBACK TO PROC_SSD_RESULT;
5284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5285: WHEN OTHERS THEN
5286: ROLLBACK TO PROC_SSD_RESULT;
5287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5288: END Process_SSD_Result;

Line 5287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5283: ROLLBACK TO PROC_SSD_RESULT;
5284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5285: WHEN OTHERS THEN
5286: ROLLBACK TO PROC_SSD_RESULT;
5287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5288: END Process_SSD_Result;
5289: ---------------------------------------------------------------------
5290: -- PROCEDURE
5291: -- Process_Result

Line 5412: x_return_status := FND_API.G_RET_STS_SUCCESS;

5408: IF g_debug_flag = 'Y' THEN
5409: OZF_UTILITY_PVT.debug_message(l_full_name||': start');
5410: END IF;
5411:
5412: x_return_status := FND_API.G_RET_STS_SUCCESS;
5413:
5414: SAVEPOINT PROC_RESULT;
5415:
5416: IF g_debug_flag = 'Y' THEN

Line 5661: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5657: ,x_act_budget_id => l_act_budget_id
5658: );
5659:
5660: write_conc_log('process_act_budgets returns: ' || x_return_status);
5661: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5662: ROLLBACK TO PROC_RESULT;
5663: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5664: write_conc_log('Adjustment creation failed for offer: ' || p_ldets_rec.list_header_id);
5665: RETURN;

Line 5679: WHEN FND_API.G_EXC_ERROR THEN

5675: OZF_UTILITY_PVT.write_conc_log(l_full_name||': end');
5676: END IF;
5677:
5678: EXCEPTION
5679: WHEN FND_API.G_EXC_ERROR THEN
5680: ROLLBACK TO PROC_RESULT;
5681: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5682: RETURN;
5683: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5683: x_return_status := FND_API.G_RET_STS_ERROR;

5679: WHEN FND_API.G_EXC_ERROR THEN
5680: ROLLBACK TO PROC_RESULT;
5681: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5682: RETURN;
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5685: ROLLBACK TO PROC_RESULT;
5686: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5687: RETURN;

Line 5684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5680: ROLLBACK TO PROC_RESULT;
5681: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5682: RETURN;
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5685: ROLLBACK TO PROC_RESULT;
5686: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5687: RETURN;
5688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5685: ROLLBACK TO PROC_RESULT;
5686: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5687: RETURN;
5688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5689: WHEN OTHERS THEN
5690: ROLLBACK TO PROC_RESULT;
5691: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5692: RETURN;

Line 5693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5689: WHEN OTHERS THEN
5690: ROLLBACK TO PROC_RESULT;
5691: p_adjIdByListHdrId.DELETE(p_ldets_rec.list_header_id);
5692: RETURN;
5693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5694: END Process_Result;
5695: ---------------------------------------------------------------------
5696: -- PROCEDURE
5697: -- process_pricing_result

Line 5758: x_return_status := FND_API.G_RET_STS_SUCCESS;

5754: IF g_debug_flag = 'Y' THEN
5755: OZF_UTILITY_PVT.write_conc_log(l_full_name||': start');
5756: END IF;
5757:
5758: x_return_status := FND_API.G_RET_STS_SUCCESS;
5759:
5760: SAVEPOINT PROC_PRIC_RESULT;
5761:
5762: -- First check whether the order result collection EXISTS or not

Line 5858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5854: p_object_type => l_object_type,
5855: x_result => l_is_valid_offer,
5856: x_return_status => l_return_status
5857: );
5858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5859: RAISE FND_API.G_EXC_ERROR;
5860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5862: END IF;

Line 5859: RAISE FND_API.G_EXC_ERROR;

5855: x_result => l_is_valid_offer,
5856: x_return_status => l_return_status
5857: );
5858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5859: RAISE FND_API.G_EXC_ERROR;
5860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5862: END IF;
5863:

Line 5860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5856: x_return_status => l_return_status
5857: );
5858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5859: RAISE FND_API.G_EXC_ERROR;
5860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5862: END IF;
5863:
5864: --l_ldets_tbl(k).line_quantity := NVL(p_line_tbl(i).priced_quantity, ABS(p_line_tbl(i).quantity));

Line 5861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5857: );
5858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5859: RAISE FND_API.G_EXC_ERROR;
5860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5862: END IF;
5863:
5864: --l_ldets_tbl(k).line_quantity := NVL(p_line_tbl(i).priced_quantity, ABS(p_line_tbl(i).quantity));
5865:

Line 5938: WHEN FND_API.G_EXC_ERROR THEN

5934: OZF_UTILITY_PVT.write_conc_log(l_full_name||': end');
5935: END IF;
5936:
5937: EXCEPTION
5938: WHEN FND_API.G_EXC_ERROR THEN
5939: ROLLBACK TO PROC_PRIC_RESULT;
5940: x_return_status := FND_API.G_RET_STS_ERROR;
5941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5942: ROLLBACK TO PROC_PRIC_RESULT;

Line 5940: x_return_status := FND_API.G_RET_STS_ERROR;

5936:
5937: EXCEPTION
5938: WHEN FND_API.G_EXC_ERROR THEN
5939: ROLLBACK TO PROC_PRIC_RESULT;
5940: x_return_status := FND_API.G_RET_STS_ERROR;
5941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5942: ROLLBACK TO PROC_PRIC_RESULT;
5943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5944: WHEN OTHERS THEN

Line 5941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5937: EXCEPTION
5938: WHEN FND_API.G_EXC_ERROR THEN
5939: ROLLBACK TO PROC_PRIC_RESULT;
5940: x_return_status := FND_API.G_RET_STS_ERROR;
5941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5942: ROLLBACK TO PROC_PRIC_RESULT;
5943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5944: WHEN OTHERS THEN
5945: ROLLBACK TO PROC_PRIC_RESULT;

Line 5943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5939: ROLLBACK TO PROC_PRIC_RESULT;
5940: x_return_status := FND_API.G_RET_STS_ERROR;
5941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5942: ROLLBACK TO PROC_PRIC_RESULT;
5943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5944: WHEN OTHERS THEN
5945: ROLLBACK TO PROC_PRIC_RESULT;
5946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5947: END process_pricing_result;

Line 5946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5942: ROLLBACK TO PROC_PRIC_RESULT;
5943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5944: WHEN OTHERS THEN
5945: ROLLBACK TO PROC_PRIC_RESULT;
5946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5947: END process_pricing_result;
5948:
5949:
5950: ---------------------------------------------------------------------

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

5974: p_from_date IN DATE,
5975: p_to_date IN DATE,
5976: p_qp_list_header_id IN NUMBER,
5977: p_offer_adjustment_id IN NUMBER,
5978: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5979: p_commit IN VARCHAR2 := fnd_api.g_false,
5980: x_return_status OUT NOCOPY VARCHAR2,
5981: x_msg_count OUT NOCOPY NUMBER,
5982: x_msg_data OUT NOCOPY VARCHAR2

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

5975: p_to_date IN DATE,
5976: p_qp_list_header_id IN NUMBER,
5977: p_offer_adjustment_id IN NUMBER,
5978: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5979: p_commit IN VARCHAR2 := fnd_api.g_false,
5980: x_return_status OUT NOCOPY VARCHAR2,
5981: x_msg_count OUT NOCOPY NUMBER,
5982: x_msg_data OUT NOCOPY VARCHAR2
5983: ) IS

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

6508: l_arithmetic_operator VARCHAR2 (30);
6509: l_adj_amt NUMBER;
6510: --nirprasa, 12.1.1 enhancement
6511: l_converted_util_amount NUMBER;
6512: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
6513:
6514: BEGIN
6515: write_conc_log ( l_full_name
6516: || ' : '

Line 6522: x_return_status := fnd_api.g_ret_sts_success;

6518: || p_from_date
6519: || 'Adjusting To Date'
6520: || l_to_date);
6521: SAVEPOINT perform_adjustment;
6522: x_return_status := fnd_api.g_ret_sts_success;
6523: IF G_DEBUG THEN
6524: ozf_utility_pvt.debug_message (': begin ');
6525: END IF;
6526: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 6526: IF fnd_api.to_boolean (p_init_msg_list) THEN

6522: x_return_status := fnd_api.g_ret_sts_success;
6523: IF G_DEBUG THEN
6524: ozf_utility_pvt.debug_message (': begin ');
6525: END IF;
6526: IF fnd_api.to_boolean (p_init_msg_list) THEN
6527: fnd_msg_pub.initialize;
6528: END IF;
6529: OPEN c_offer_info;
6530: FETCH c_offer_info INTO l_offer_info;

Line 6547: IF l_return_status = fnd_api.g_ret_sts_error THEN

6543: || 'After Process Product Return Status'
6544: || l_return_status);
6545:
6546:
6547: IF l_return_status = fnd_api.g_ret_sts_error THEN
6548: RAISE fnd_api.g_exc_error;
6549: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6550: RAISE fnd_api.g_exc_unexpected_error;
6551: END IF;

Line 6548: RAISE fnd_api.g_exc_error;

6544: || l_return_status);
6545:
6546:
6547: IF l_return_status = fnd_api.g_ret_sts_error THEN
6548: RAISE fnd_api.g_exc_error;
6549: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6550: RAISE fnd_api.g_exc_unexpected_error;
6551: END IF;
6552: --IF l_source_from_par_flag = 'N' THEN

Line 6549: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

6545:
6546:
6547: IF l_return_status = fnd_api.g_ret_sts_error THEN
6548: RAISE fnd_api.g_exc_error;
6549: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6550: RAISE fnd_api.g_exc_unexpected_error;
6551: END IF;
6552: --IF l_source_from_par_flag = 'N' THEN
6553:

Line 6550: RAISE fnd_api.g_exc_unexpected_error;

6546:
6547: IF l_return_status = fnd_api.g_ret_sts_error THEN
6548: RAISE fnd_api.g_exc_error;
6549: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6550: RAISE fnd_api.g_exc_unexpected_error;
6551: END IF;
6552: --IF l_source_from_par_flag = 'N' THEN
6553:
6554: -- updated by mkothari : 10-28-2002

Line 6654: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6650: IF g_debug_flag = 'Y' THEN
6651: write_conc_log ('l_converted_util_amount '||l_converted_util_amount);
6652: END IF;
6653:
6654: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6655: IF g_debug_flag = 'Y' THEN
6656: ozf_utility_pvt.write_conc_log (' D: post_adjust_to_budget() convert currency failed. No posting to budget. Return');
6657: END IF;
6658: RAISE fnd_api.g_exc_unexpected_error;

Line 6658: RAISE fnd_api.g_exc_unexpected_error;

6654: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6655: IF g_debug_flag = 'Y' THEN
6656: ozf_utility_pvt.write_conc_log (' D: post_adjust_to_budget() convert currency failed. No posting to budget. Return');
6657: END IF;
6658: RAISE fnd_api.g_exc_unexpected_error;
6659: END IF;
6660: l_act_budgets_rec.parent_src_apprvd_amt := l_converted_util_amount;
6661:
6662: END IF;

Line 6751: p_encoded => FND_API.G_FALSE,

6747: IF(x_msg_count > 0)THEN
6748: FOR I IN 1 .. x_msg_count LOOP
6749: fnd_msg_pub.GET
6750: (p_msg_index => FND_MSG_PUB.G_NEXT,
6751: p_encoded => FND_API.G_FALSE,
6752: p_data => x_msg_data,
6753: p_msg_index_out => l_index);
6754: --ozf_utility_pvt.write_conc_log(l_full_name||' : '||i||x_msg_data);
6755: DBMS_OUTPUT.put_line('****(PA):'||x_msg_data);

Line 6763: IF l_return_status = fnd_api.g_ret_sts_error THEN

6759: -- END IF;
6760: END FOR_DEBUGGING */
6761: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
6762:
6763: IF l_return_status = fnd_api.g_ret_sts_error THEN
6764: RAISE fnd_api.g_exc_error;
6765: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6766: RAISE fnd_api.g_exc_unexpected_error;
6767: END IF;

Line 6764: RAISE fnd_api.g_exc_error;

6760: END FOR_DEBUGGING */
6761: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
6762:
6763: IF l_return_status = fnd_api.g_ret_sts_error THEN
6764: RAISE fnd_api.g_exc_error;
6765: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6766: RAISE fnd_api.g_exc_unexpected_error;
6767: END IF;
6768:

Line 6765: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

6761: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);
6762:
6763: IF l_return_status = fnd_api.g_ret_sts_error THEN
6764: RAISE fnd_api.g_exc_error;
6765: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6766: RAISE fnd_api.g_exc_unexpected_error;
6767: END IF;
6768:
6769: END LOOP; --FOR i IN NVL(backdate_adj_rec.FIRST, 1) .. NVL(backdate_adj_rec.LAST, 0) LOOP

Line 6766: RAISE fnd_api.g_exc_unexpected_error;

6762:
6763: IF l_return_status = fnd_api.g_ret_sts_error THEN
6764: RAISE fnd_api.g_exc_error;
6765: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6766: RAISE fnd_api.g_exc_unexpected_error;
6767: END IF;
6768:
6769: END LOOP; --FOR i IN NVL(backdate_adj_rec.FIRST, 1) .. NVL(backdate_adj_rec.LAST, 0) LOOP
6770:

Line 6794: WHEN fnd_api.g_exc_error THEN

6790: CLOSE c_bdadj_all_types;
6791: END IF;
6792:
6793: EXCEPTION
6794: WHEN fnd_api.g_exc_error THEN
6795: ROLLBACK TO perform_adjustment;
6796: x_return_status := fnd_api.g_ret_sts_error;
6797: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6798: WHEN fnd_api.g_exc_unexpected_error THEN

Line 6796: x_return_status := fnd_api.g_ret_sts_error;

6792:
6793: EXCEPTION
6794: WHEN fnd_api.g_exc_error THEN
6795: ROLLBACK TO perform_adjustment;
6796: x_return_status := fnd_api.g_ret_sts_error;
6797: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6798: WHEN fnd_api.g_exc_unexpected_error THEN
6799: ROLLBACK TO perform_adjustment;
6800: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6793: EXCEPTION
6794: WHEN fnd_api.g_exc_error THEN
6795: ROLLBACK TO perform_adjustment;
6796: x_return_status := fnd_api.g_ret_sts_error;
6797: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6798: WHEN fnd_api.g_exc_unexpected_error THEN
6799: ROLLBACK TO perform_adjustment;
6800: x_return_status := fnd_api.g_ret_sts_unexp_error;
6801: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 6798: WHEN fnd_api.g_exc_unexpected_error THEN

6794: WHEN fnd_api.g_exc_error THEN
6795: ROLLBACK TO perform_adjustment;
6796: x_return_status := fnd_api.g_ret_sts_error;
6797: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6798: WHEN fnd_api.g_exc_unexpected_error THEN
6799: ROLLBACK TO perform_adjustment;
6800: x_return_status := fnd_api.g_ret_sts_unexp_error;
6801: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6802: WHEN OTHERS THEN

Line 6800: x_return_status := fnd_api.g_ret_sts_unexp_error;

6796: x_return_status := fnd_api.g_ret_sts_error;
6797: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6798: WHEN fnd_api.g_exc_unexpected_error THEN
6799: ROLLBACK TO perform_adjustment;
6800: x_return_status := fnd_api.g_ret_sts_unexp_error;
6801: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6802: WHEN OTHERS THEN
6803: ROLLBACK TO perform_adjustment;
6804: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6797: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6798: WHEN fnd_api.g_exc_unexpected_error THEN
6799: ROLLBACK TO perform_adjustment;
6800: x_return_status := fnd_api.g_ret_sts_unexp_error;
6801: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6802: WHEN OTHERS THEN
6803: ROLLBACK TO perform_adjustment;
6804: x_return_status := fnd_api.g_ret_sts_unexp_error;
6805: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 6804: x_return_status := fnd_api.g_ret_sts_unexp_error;

6800: x_return_status := fnd_api.g_ret_sts_unexp_error;
6801: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6802: WHEN OTHERS THEN
6803: ROLLBACK TO perform_adjustment;
6804: x_return_status := fnd_api.g_ret_sts_unexp_error;
6805: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6806: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6807: END IF;
6808: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

6804: x_return_status := fnd_api.g_ret_sts_unexp_error;
6805: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6806: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6807: END IF;
6808: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
6809: END perform_adjustment;
6810:
6811: -------------------------------------------------------------------
6812: -- NAME

Line 6843: x_return_status := fnd_api.g_ret_sts_success;

6839: WHERE adjl.offer_adjustment_id = p_offer_adjustment_id AND adjl.list_line_id = qppa.list_line_id;
6840: BEGIN
6841: -- ozf_utility_pvt.debug_message('enter validate_product_budget obj_id=' || p_object_id || ' budget_id=' || p_budget_id);
6842:
6843: x_return_status := fnd_api.g_ret_sts_success;
6844: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
6845: write_conc_log ( l_full_name
6846: || ' : '
6847: || 'In Process Product '

Line 6911: x_return_status := fnd_api.g_ret_sts_error;

6907:
6908: END LOOP;
6909: EXCEPTION
6910: WHEN OTHERS THEN
6911: x_return_status := fnd_api.g_ret_sts_error;
6912: END process_offer_product;
6913: ---------------------------------------------------------------------
6914: -- PROCEDURE
6915: -- PROCESS_ACCRUAL

Line 6997: l_return_status := FND_API.g_ret_sts_success;

6993:
6994: FND_MSG_PUB.initialize;
6995: l_msg_count:= 0;
6996: l_msg_data := NULL;
6997: l_return_status := FND_API.g_ret_sts_success;
6998:
6999: write_conc_log(l_full_name ||'VOLUME OFFER ID'|| l_qpListHeaderIdTbl(i));
7000:
7001: BEGIN

Line 7006: ,p_init_msg_list => fnd_api.g_false

7002: SAVEPOINT volume_offer;
7003:
7004: volume_offer_adjustment(p_qp_list_header_id => l_qpListHeaderIdTbl(i)
7005: ,p_vol_off_type => l_volumeOfferTypeTbl(i)
7006: ,p_init_msg_list => fnd_api.g_false
7007: ,p_commit => fnd_api.g_false
7008: ,x_return_status => l_return_status
7009: ,x_msg_count => l_msg_count
7010: ,x_msg_data => l_msg_data

Line 7007: ,p_commit => fnd_api.g_false

7003:
7004: volume_offer_adjustment(p_qp_list_header_id => l_qpListHeaderIdTbl(i)
7005: ,p_vol_off_type => l_volumeOfferTypeTbl(i)
7006: ,p_init_msg_list => fnd_api.g_false
7007: ,p_commit => fnd_api.g_false
7008: ,x_return_status => l_return_status
7009: ,x_msg_count => l_msg_count
7010: ,x_msg_data => l_msg_data
7011: );

Line 7015: IF l_return_status = fnd_api.g_ret_sts_error THEN

7011: );
7012:
7013: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
7014:
7015: IF l_return_status = fnd_api.g_ret_sts_error THEN
7016: RAISE fnd_api.g_exc_error;
7017: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7018: RAISE fnd_api.g_exc_unexpected_error;
7019: END IF;

Line 7016: RAISE fnd_api.g_exc_error;

7012:
7013: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
7014:
7015: IF l_return_status = fnd_api.g_ret_sts_error THEN
7016: RAISE fnd_api.g_exc_error;
7017: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7018: RAISE fnd_api.g_exc_unexpected_error;
7019: END IF;
7020:

Line 7017: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

7013: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
7014:
7015: IF l_return_status = fnd_api.g_ret_sts_error THEN
7016: RAISE fnd_api.g_exc_error;
7017: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7018: RAISE fnd_api.g_exc_unexpected_error;
7019: END IF;
7020:
7021: ----------------------------------------

Line 7018: RAISE fnd_api.g_exc_unexpected_error;

7014:
7015: IF l_return_status = fnd_api.g_ret_sts_error THEN
7016: RAISE fnd_api.g_exc_error;
7017: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7018: RAISE fnd_api.g_exc_unexpected_error;
7019: END IF;
7020:
7021: ----------------------------------------
7022: volume_offer_util_adjustment(p_qp_list_header_id => l_qpListHeaderIdTbl(i)

Line 7030: IF l_return_status = fnd_api.g_ret_sts_error THEN

7026: );
7027:
7028: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
7029:
7030: IF l_return_status = fnd_api.g_ret_sts_error THEN
7031: RAISE fnd_api.g_exc_error;
7032: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7033: RAISE fnd_api.g_exc_unexpected_error;
7034: END IF;

Line 7031: RAISE fnd_api.g_exc_error;

7027:
7028: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
7029:
7030: IF l_return_status = fnd_api.g_ret_sts_error THEN
7031: RAISE fnd_api.g_exc_error;
7032: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7033: RAISE fnd_api.g_exc_unexpected_error;
7034: END IF;
7035: ----------------------------------------

Line 7032: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

7028: write_conc_log(l_full_name ||'x_return_status'|| l_return_status);
7029:
7030: IF l_return_status = fnd_api.g_ret_sts_error THEN
7031: RAISE fnd_api.g_exc_error;
7032: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7033: RAISE fnd_api.g_exc_unexpected_error;
7034: END IF;
7035: ----------------------------------------
7036:

Line 7033: RAISE fnd_api.g_exc_unexpected_error;

7029:
7030: IF l_return_status = fnd_api.g_ret_sts_error THEN
7031: RAISE fnd_api.g_exc_error;
7032: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7033: RAISE fnd_api.g_exc_unexpected_error;
7034: END IF;
7035: ----------------------------------------
7036:
7037: EXCEPTION

Line 7038: WHEN FND_API.G_EXC_ERROR THEN

7034: END IF;
7035: ----------------------------------------
7036:
7037: EXCEPTION
7038: WHEN FND_API.G_EXC_ERROR THEN
7039: ROLLBACK TO VOLUME_OFFER;
7040: OZF_UTILITY_PVT.write_conc_log(l_full_name ||' Volume Offer Adjustment Failed EX ==>'||'VOLUME OFFER '|| l_qpListHeaderIdTbl(i));
7041: OZF_UTILITY_PVT.write_conc_log;
7042: OZF_UTILITY_PVT.write_conc_log(' ');

Line 7044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7040: OZF_UTILITY_PVT.write_conc_log(l_full_name ||' Volume Offer Adjustment Failed EX ==>'||'VOLUME OFFER '|| l_qpListHeaderIdTbl(i));
7041: OZF_UTILITY_PVT.write_conc_log;
7042: OZF_UTILITY_PVT.write_conc_log(' ');
7043:
7044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7045: ROLLBACK TO VOLUME_OFFER;
7046: OZF_UTILITY_PVT.write_conc_log(l_full_name ||' Volume Offer Adjustment Failed UNEX ==>'||'VOLUME OFFER '|| l_qpListHeaderIdTbl(i));
7047: OZF_UTILITY_PVT.write_conc_log;
7048: OZF_UTILITY_PVT.write_conc_log(' ');

Line 7066: WHEN fnd_api.g_exc_error THEN

7062: END LOOP; -- end volume offer bulk fetch loop
7063:
7064: write_conc_log (' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
7065: EXCEPTION
7066: WHEN fnd_api.g_exc_error THEN
7067: ROLLBACK TO adjust_volume_offer;
7068: OZF_UTILITY_PVT.write_conc_log;
7069: x_ERRBUF := l_msg_data;
7070: x_RETCODE := 1;

Line 7072: WHEN fnd_api.g_exc_unexpected_error THEN

7068: OZF_UTILITY_PVT.write_conc_log;
7069: x_ERRBUF := l_msg_data;
7070: x_RETCODE := 1;
7071:
7072: WHEN fnd_api.g_exc_unexpected_error THEN
7073: ROLLBACK TO adjust_volume_offer;
7074: OZF_UTILITY_PVT.write_conc_log;
7075: x_ERRBUF := l_msg_data;
7076: x_RETCODE := 1;

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

7160: SELECT exchange_rate_type
7161: FROM ozf_sys_parameters_all
7162: WHERE org_id = p_org_id;
7163:
7164: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
7165:
7166:
7167:
7168: l_adj_info c_adj_info%ROWTYPE;

Line 7171: x_return_status := fnd_api.g_ret_sts_success;

7167:
7168: l_adj_info c_adj_info%ROWTYPE;
7169:
7170: BEGIN
7171: x_return_status := fnd_api.g_ret_sts_success;
7172: SAVEPOINT process_accrual;
7173: IF G_DEBUG THEN
7174: ozf_utility_pvt.debug_message (' Start'|| g_pkg_name||'.'||l_api_name);
7175: END IF;

Line 7217: IF x_return_status = fnd_api.g_ret_sts_error THEN

7213: fnd_message.set_token ('OFFER_NAME', l_off_name);
7214: fnd_msg_pub.ADD;
7215: END IF;
7216: --dbms_output.put_line(' In error ');
7217: IF x_return_status = fnd_api.g_ret_sts_error THEN
7218: RAISE fnd_api.g_exc_error;
7219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7220: RAISE fnd_api.g_exc_unexpected_error;
7221: END IF;

Line 7218: RAISE fnd_api.g_exc_error;

7214: fnd_msg_pub.ADD;
7215: END IF;
7216: --dbms_output.put_line(' In error ');
7217: IF x_return_status = fnd_api.g_ret_sts_error THEN
7218: RAISE fnd_api.g_exc_error;
7219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7220: RAISE fnd_api.g_exc_unexpected_error;
7221: END IF;
7222: ELSE

Line 7219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

7215: END IF;
7216: --dbms_output.put_line(' In error ');
7217: IF x_return_status = fnd_api.g_ret_sts_error THEN
7218: RAISE fnd_api.g_exc_error;
7219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7220: RAISE fnd_api.g_exc_unexpected_error;
7221: END IF;
7222: ELSE
7223: --if some row is returned to adjust then

Line 7220: RAISE fnd_api.g_exc_unexpected_error;

7216: --dbms_output.put_line(' In error ');
7217: IF x_return_status = fnd_api.g_ret_sts_error THEN
7218: RAISE fnd_api.g_exc_error;
7219: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7220: RAISE fnd_api.g_exc_unexpected_error;
7221: END IF;
7222: ELSE
7223: --if some row is returned to adjust then
7224: IF G_DEBUG THEN

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

7223: --if some row is returned to adjust then
7224: IF G_DEBUG THEN
7225: ozf_utility_pvt.debug_message ('Begin Processing For Offer Adjustment: '||l_off_name);
7226: END IF;
7227: IF (l_fund_amt_tbl.COUNT > 0) AND x_return_status = fnd_api.g_ret_sts_success THEN
7228: l_adj_amount := 0; -- in offer currency
7229: l_remaining_amt := ozf_utility_pvt.currround (
7230: p_earned_amt,
7231: --nirprasa,12.1.1 l_util_curr ); -- in offer currency

Line 7280: IF x_return_status <> fnd_api.g_ret_sts_success THEN

7276: ozf_utility_pvt.debug_message( ' Adj amount coverted '|| l_converted_adj_amount
7277: || ' l_adj amount' || l_adj_amount);
7278: END IF;
7279:
7280: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7281: IF G_DEBUG THEN
7282: -- ozf_utility_pvt.error_message( ' Convert Currency '||x_return_status);
7283: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
7284: END IF;

Line 7285: IF x_return_status = fnd_api.g_ret_sts_error THEN

7281: IF G_DEBUG THEN
7282: -- ozf_utility_pvt.error_message( ' Convert Currency '||x_return_status);
7283: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
7284: END IF;
7285: IF x_return_status = fnd_api.g_ret_sts_error THEN
7286: RAISE fnd_api.g_exc_error;
7287: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7288: RAISE fnd_api.g_exc_unexpected_error;
7289: END IF;

Line 7286: RAISE fnd_api.g_exc_error;

7282: -- ozf_utility_pvt.error_message( ' Convert Currency '||x_return_status);
7283: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
7284: END IF;
7285: IF x_return_status = fnd_api.g_ret_sts_error THEN
7286: RAISE fnd_api.g_exc_error;
7287: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7288: RAISE fnd_api.g_exc_unexpected_error;
7289: END IF;
7290: END IF;

Line 7287: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

7283: ozf_utility_pvt.debug_message( ' Convert Currency '||x_return_status);
7284: END IF;
7285: IF x_return_status = fnd_api.g_ret_sts_error THEN
7286: RAISE fnd_api.g_exc_error;
7287: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7288: RAISE fnd_api.g_exc_unexpected_error;
7289: END IF;
7290: END IF;
7291: IF x_return_status = fnd_api.g_ret_sts_success THEN

Line 7288: RAISE fnd_api.g_exc_unexpected_error;

7284: END IF;
7285: IF x_return_status = fnd_api.g_ret_sts_error THEN
7286: RAISE fnd_api.g_exc_error;
7287: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7288: RAISE fnd_api.g_exc_unexpected_error;
7289: END IF;
7290: END IF;
7291: IF x_return_status = fnd_api.g_ret_sts_success THEN
7292: IF l_act_util_rec.plan_currency_code = l_fund_amt_tbl (j).budget_currency THEN

Line 7291: IF x_return_status = fnd_api.g_ret_sts_success THEN

7287: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7288: RAISE fnd_api.g_exc_unexpected_error;
7289: END IF;
7290: END IF;
7291: IF x_return_status = fnd_api.g_ret_sts_success THEN
7292: IF l_act_util_rec.plan_currency_code = l_fund_amt_tbl (j).budget_currency THEN
7293: l_act_budgets_rec.parent_src_apprvd_amt :=
7294: ozf_utility_pvt.currround (
7295: l_adj_amount,

Line 7367: IF x_return_status <> fnd_api.g_ret_sts_success THEN

7363: IF G_DEBUG THEN
7364: ozf_utility_pvt.debug_message('create utlization '|| x_return_status);
7365: END IF;
7366:
7367: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7368: IF x_return_status = fnd_api.g_ret_sts_error THEN
7369: RAISE fnd_api.g_exc_error;
7370: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7371: RAISE fnd_api.g_exc_unexpected_error;

Line 7368: IF x_return_status = fnd_api.g_ret_sts_error THEN

7364: ozf_utility_pvt.debug_message('create utlization '|| x_return_status);
7365: END IF;
7366:
7367: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7368: IF x_return_status = fnd_api.g_ret_sts_error THEN
7369: RAISE fnd_api.g_exc_error;
7370: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7371: RAISE fnd_api.g_exc_unexpected_error;
7372: END IF;

Line 7369: RAISE fnd_api.g_exc_error;

7365: END IF;
7366:
7367: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7368: IF x_return_status = fnd_api.g_ret_sts_error THEN
7369: RAISE fnd_api.g_exc_error;
7370: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7371: RAISE fnd_api.g_exc_unexpected_error;
7372: END IF;
7373: END IF;

Line 7370: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

7366:
7367: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7368: IF x_return_status = fnd_api.g_ret_sts_error THEN
7369: RAISE fnd_api.g_exc_error;
7370: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7371: RAISE fnd_api.g_exc_unexpected_error;
7372: END IF;
7373: END IF;
7374: END IF; --l_act_budgets_rec.request_amount <> 0

Line 7371: RAISE fnd_api.g_exc_unexpected_error;

7367: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7368: IF x_return_status = fnd_api.g_ret_sts_error THEN
7369: RAISE fnd_api.g_exc_error;
7370: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7371: RAISE fnd_api.g_exc_unexpected_error;
7372: END IF;
7373: END IF;
7374: END IF; --l_act_budgets_rec.request_amount <> 0
7375: --- quit when the total earned amount is adjusted

Line 7387: WHEN fnd_api.g_exc_error THEN

7383: END LOOP earned_adj_loop;
7384: END IF; --end of check for table count >0
7385: END IF; -- end of check for count
7386: EXCEPTION
7387: WHEN fnd_api.g_exc_error THEN
7388: ROLLBACK TO process_accrual;
7389: x_return_status := fnd_api.g_ret_sts_error;
7390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7391: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7389: x_return_status := fnd_api.g_ret_sts_error;

7385: END IF; -- end of check for count
7386: EXCEPTION
7387: WHEN fnd_api.g_exc_error THEN
7388: ROLLBACK TO process_accrual;
7389: x_return_status := fnd_api.g_ret_sts_error;
7390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7391: WHEN fnd_api.g_exc_unexpected_error THEN
7392: ROLLBACK TO process_accrual;
7393: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7386: EXCEPTION
7387: WHEN fnd_api.g_exc_error THEN
7388: ROLLBACK TO process_accrual;
7389: x_return_status := fnd_api.g_ret_sts_error;
7390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7391: WHEN fnd_api.g_exc_unexpected_error THEN
7392: ROLLBACK TO process_accrual;
7393: x_return_status := fnd_api.g_ret_sts_unexp_error;
7394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 7391: WHEN fnd_api.g_exc_unexpected_error THEN

7387: WHEN fnd_api.g_exc_error THEN
7388: ROLLBACK TO process_accrual;
7389: x_return_status := fnd_api.g_ret_sts_error;
7390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7391: WHEN fnd_api.g_exc_unexpected_error THEN
7392: ROLLBACK TO process_accrual;
7393: x_return_status := fnd_api.g_ret_sts_unexp_error;
7394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7395: WHEN OTHERS THEN

Line 7393: x_return_status := fnd_api.g_ret_sts_unexp_error;

7389: x_return_status := fnd_api.g_ret_sts_error;
7390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7391: WHEN fnd_api.g_exc_unexpected_error THEN
7392: ROLLBACK TO process_accrual;
7393: x_return_status := fnd_api.g_ret_sts_unexp_error;
7394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7395: WHEN OTHERS THEN
7396: ROLLBACK TO process_accrual;
7397: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7391: WHEN fnd_api.g_exc_unexpected_error THEN
7392: ROLLBACK TO process_accrual;
7393: x_return_status := fnd_api.g_ret_sts_unexp_error;
7394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7395: WHEN OTHERS THEN
7396: ROLLBACK TO process_accrual;
7397: x_return_status := fnd_api.g_ret_sts_unexp_error;
7398: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 7397: x_return_status := fnd_api.g_ret_sts_unexp_error;

7393: x_return_status := fnd_api.g_ret_sts_unexp_error;
7394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7395: WHEN OTHERS THEN
7396: ROLLBACK TO process_accrual;
7397: x_return_status := fnd_api.g_ret_sts_unexp_error;
7398: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7399: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
7400: END IF;
7401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

7397: x_return_status := fnd_api.g_ret_sts_unexp_error;
7398: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7399: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
7400: END IF;
7401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
7402:
7403: END process_accrual;
7404:
7405: ---------------------------------------------------------------------

Line 7617: x_return_status := fnd_api.g_ret_sts_success;

7613: --profile: 'OZF: Create GL Entries for Orders' -- change as global constant by feliu on 06/21/2005
7614: -- l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
7615:
7616: BEGIN
7617: x_return_status := fnd_api.g_ret_sts_success;
7618:
7619: OPEN c_volume_type(p_list_header_id);
7620: FETCH c_volume_type INTO l_volume_type;
7621: CLOSE c_volume_type;

Line 7655: IF x_return_status <> fnd_api.g_ret_sts_success THEN

7651: ,x_to_amount => l_conv_amount
7652: ,x_rate => l_rate
7653: );
7654:
7655: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7656: ozf_utility_pvt.write_conc_log('x_return_status: ' || x_return_status);
7657: RETURN NULL;
7658: END IF;
7659:

Line 7692: x_return_status := fnd_api.g_ret_sts_error;

7688:
7689:
7690: EXCEPTION
7691: WHEN OTHERS THEN
7692: x_return_status := fnd_api.g_ret_sts_error;
7693: RETURN NULL;
7694: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7695: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
7696: END IF;

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

7718:
7719: PROCEDURE volume_offer_adjustment (
7720: p_qp_list_header_id IN NUMBER,
7721: p_vol_off_type IN VARCHAR2,
7722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7723: p_commit IN VARCHAR2 := fnd_api.g_false,
7724: x_return_status OUT NOCOPY VARCHAR2,
7725: x_msg_count OUT NOCOPY NUMBER,
7726: x_msg_data OUT NOCOPY VARCHAR2

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

7719: PROCEDURE volume_offer_adjustment (
7720: p_qp_list_header_id IN NUMBER,
7721: p_vol_off_type IN VARCHAR2,
7722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7723: p_commit IN VARCHAR2 := fnd_api.g_false,
7724: x_return_status OUT NOCOPY VARCHAR2,
7725: x_msg_count OUT NOCOPY NUMBER,
7726: x_msg_data OUT NOCOPY VARCHAR2
7727: ) IS

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

7953:
7954: l_api_name CONSTANT VARCHAR2(30) := 'volume_offer_adjustment';
7955: l_full_name VARCHAR2(70):= g_pkg_name ||'.'||l_api_name ||' : ';
7956: l_api_version CONSTANT NUMBER := 1.0;
7957: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;
7958: l_msg_count NUMBER;
7959: l_msg_data VARCHAR2 (2000) := NULL;
7960: l_volume_offer_tier_id NUMBER;
7961: l_current_offer_tier_id NUMBER;

Line 8191: IF l_return_status = fnd_api.g_ret_sts_error THEN

8187: ,x_to_amount => l_conv_price
8188: ,x_rate => l_rate
8189: );
8190:
8191: IF l_return_status = fnd_api.g_ret_sts_error THEN
8192: RAISE fnd_api.g_exc_error;
8193: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8194: RAISE fnd_api.g_exc_unexpected_error;
8195: END IF;

Line 8192: RAISE fnd_api.g_exc_error;

8188: ,x_rate => l_rate
8189: );
8190:
8191: IF l_return_status = fnd_api.g_ret_sts_error THEN
8192: RAISE fnd_api.g_exc_error;
8193: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8194: RAISE fnd_api.g_exc_unexpected_error;
8195: END IF;
8196:

Line 8193: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

8189: );
8190:
8191: IF l_return_status = fnd_api.g_ret_sts_error THEN
8192: RAISE fnd_api.g_exc_error;
8193: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8194: RAISE fnd_api.g_exc_unexpected_error;
8195: END IF;
8196:
8197: l_selling_price := l_conv_price;

Line 8194: RAISE fnd_api.g_exc_unexpected_error;

8190:
8191: IF l_return_status = fnd_api.g_ret_sts_error THEN
8192: RAISE fnd_api.g_exc_error;
8193: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8194: RAISE fnd_api.g_exc_unexpected_error;
8195: END IF;
8196:
8197: l_selling_price := l_conv_price;
8198: write_conc_log ('selling price after currency conversion: ' || l_selling_price);

Line 8281: (p_init_msg_list =>fnd_api.g_false

8277: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = Y l_order_line_id = '|| l_order_line_id);
8278: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = Y l_source_code = '|| l_source_code);
8279: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = Y trx_date = '|| sysdate+1);
8280: ozf_volume_calculation_pub.get_volume
8281: (p_init_msg_list =>fnd_api.g_false
8282: ,p_api_version =>1.0
8283: ,p_commit =>fnd_api.g_false
8284: ,x_return_status =>l_return_status
8285: ,x_msg_count => l_msg_count

Line 8283: ,p_commit =>fnd_api.g_false

8279: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = Y trx_date = '|| sysdate+1);
8280: ozf_volume_calculation_pub.get_volume
8281: (p_init_msg_list =>fnd_api.g_false
8282: ,p_api_version =>1.0
8283: ,p_commit =>fnd_api.g_false
8284: ,x_return_status =>l_return_status
8285: ,x_msg_count => l_msg_count
8286: ,x_msg_data => l_msg_data
8287: ,p_qp_list_header_id => l_qp_list_header_id

Line 8311: (p_init_msg_list =>fnd_api.g_false

8307: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = N l_order_line_id = '|| l_order_line_id);
8308: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = N l_source_code = '|| l_source_code);
8309: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = Y trx_date = '|| l_trx_date);
8310: ozf_volume_calculation_pub.get_volume
8311: (p_init_msg_list =>fnd_api.g_false
8312: ,p_api_version =>1.0
8313: ,p_commit =>fnd_api.g_false
8314: ,x_return_status =>l_return_status
8315: ,x_msg_count => l_msg_count

Line 8313: ,p_commit =>fnd_api.g_false

8309: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = Y trx_date = '|| l_trx_date);
8310: ozf_volume_calculation_pub.get_volume
8311: (p_init_msg_list =>fnd_api.g_false
8312: ,p_api_version =>1.0
8313: ,p_commit =>fnd_api.g_false
8314: ,x_return_status =>l_return_status
8315: ,x_msg_count => l_msg_count
8316: ,x_msg_data => l_msg_data
8317: ,p_qp_list_header_id => l_qp_list_header_id

Line 8327: IF l_return_status = fnd_api.g_ret_sts_error THEN

8323: );
8324: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = N l_volume = '|| l_volume);
8325: END IF;
8326:
8327: IF l_return_status = fnd_api.g_ret_sts_error THEN
8328: RAISE fnd_api.g_exc_error;
8329: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8330: RAISE fnd_api.g_exc_unexpected_error;
8331: END IF;

Line 8328: RAISE fnd_api.g_exc_error;

8324: ozf_utility_pvt.write_conc_log('Catch Weight --> l_retroactive = N l_volume = '|| l_volume);
8325: END IF;
8326:
8327: IF l_return_status = fnd_api.g_ret_sts_error THEN
8328: RAISE fnd_api.g_exc_error;
8329: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8330: RAISE fnd_api.g_exc_unexpected_error;
8331: END IF;
8332: -- END IF; --l_retroactive = 'Y'

Line 8329: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

8325: END IF;
8326:
8327: IF l_return_status = fnd_api.g_ret_sts_error THEN
8328: RAISE fnd_api.g_exc_error;
8329: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8330: RAISE fnd_api.g_exc_unexpected_error;
8331: END IF;
8332: -- END IF; --l_retroactive = 'Y'
8333:

Line 8330: RAISE fnd_api.g_exc_unexpected_error;

8326:
8327: IF l_return_status = fnd_api.g_ret_sts_error THEN
8328: RAISE fnd_api.g_exc_error;
8329: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8330: RAISE fnd_api.g_exc_unexpected_error;
8331: END IF;
8332: -- END IF; --l_retroactive = 'Y'
8333:
8334: IF G_DEBUG THEN

Line 8766: IF l_return_status = fnd_api.g_ret_sts_error THEN

8762: x_return_status =>l_return_status,
8763: x_msg_count =>l_msg_count,
8764: x_msg_data =>l_msg_data );
8765:
8766: IF l_return_status = fnd_api.g_ret_sts_error THEN
8767: RAISE fnd_api.g_exc_error;
8768: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8769: RAISE fnd_api.g_exc_unexpected_error;
8770: END IF;

Line 8767: RAISE fnd_api.g_exc_error;

8763: x_msg_count =>l_msg_count,
8764: x_msg_data =>l_msg_data );
8765:
8766: IF l_return_status = fnd_api.g_ret_sts_error THEN
8767: RAISE fnd_api.g_exc_error;
8768: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8769: RAISE fnd_api.g_exc_unexpected_error;
8770: END IF;
8771: END IF;

Line 8768: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

8764: x_msg_data =>l_msg_data );
8765:
8766: IF l_return_status = fnd_api.g_ret_sts_error THEN
8767: RAISE fnd_api.g_exc_error;
8768: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8769: RAISE fnd_api.g_exc_unexpected_error;
8770: END IF;
8771: END IF;
8772:

Line 8769: RAISE fnd_api.g_exc_unexpected_error;

8765:
8766: IF l_return_status = fnd_api.g_ret_sts_error THEN
8767: RAISE fnd_api.g_exc_error;
8768: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8769: RAISE fnd_api.g_exc_unexpected_error;
8770: END IF;
8771: END IF;
8772:
8773: IF G_DEBUG THEN

Line 8789: IF l_return_status = fnd_api.g_ret_sts_error THEN

8785: EXIT WHEN c_old_price_adj%NOTFOUND;
8786: END LOOP; -- end price adj loop
8787: CLOSE c_old_price_adj;
8788:
8789: IF l_return_status = fnd_api.g_ret_sts_error THEN
8790: RAISE fnd_api.g_exc_error;
8791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8792: RAISE fnd_api.g_exc_unexpected_error;
8793: END IF;

Line 8790: RAISE fnd_api.g_exc_error;

8786: END LOOP; -- end price adj loop
8787: CLOSE c_old_price_adj;
8788:
8789: IF l_return_status = fnd_api.g_ret_sts_error THEN
8790: RAISE fnd_api.g_exc_error;
8791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8792: RAISE fnd_api.g_exc_unexpected_error;
8793: END IF;
8794:

Line 8791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

8787: CLOSE c_old_price_adj;
8788:
8789: IF l_return_status = fnd_api.g_ret_sts_error THEN
8790: RAISE fnd_api.g_exc_error;
8791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8792: RAISE fnd_api.g_exc_unexpected_error;
8793: END IF;
8794:
8795: <>

Line 8792: RAISE fnd_api.g_exc_unexpected_error;

8788:
8789: IF l_return_status = fnd_api.g_ret_sts_error THEN
8790: RAISE fnd_api.g_exc_error;
8791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8792: RAISE fnd_api.g_exc_unexpected_error;
8793: END IF;
8794:
8795: <>
8796: NULL;

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

8799: ozf_utility_pvt.debug_message(' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
8800: END IF;
8801: write_conc_log(' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
8802:
8803: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8804:
8805: x_return_status := l_return_status;
8806:
8807: EXCEPTION

Line 8808: WHEN fnd_api.g_exc_error THEN

8804:
8805: x_return_status := l_return_status;
8806:
8807: EXCEPTION
8808: WHEN fnd_api.g_exc_error THEN
8809: ROLLBACK TO volume_offer_adjustment;
8810: x_return_status := fnd_api.g_ret_sts_error;
8811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8812: WHEN fnd_api.g_exc_unexpected_error THEN

Line 8810: x_return_status := fnd_api.g_ret_sts_error;

8806:
8807: EXCEPTION
8808: WHEN fnd_api.g_exc_error THEN
8809: ROLLBACK TO volume_offer_adjustment;
8810: x_return_status := fnd_api.g_ret_sts_error;
8811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8812: WHEN fnd_api.g_exc_unexpected_error THEN
8813: ROLLBACK TO volume_offer_adjustment;
8814: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

8807: EXCEPTION
8808: WHEN fnd_api.g_exc_error THEN
8809: ROLLBACK TO volume_offer_adjustment;
8810: x_return_status := fnd_api.g_ret_sts_error;
8811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8812: WHEN fnd_api.g_exc_unexpected_error THEN
8813: ROLLBACK TO volume_offer_adjustment;
8814: x_return_status := fnd_api.g_ret_sts_unexp_error;
8815: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 8812: WHEN fnd_api.g_exc_unexpected_error THEN

8808: WHEN fnd_api.g_exc_error THEN
8809: ROLLBACK TO volume_offer_adjustment;
8810: x_return_status := fnd_api.g_ret_sts_error;
8811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8812: WHEN fnd_api.g_exc_unexpected_error THEN
8813: ROLLBACK TO volume_offer_adjustment;
8814: x_return_status := fnd_api.g_ret_sts_unexp_error;
8815: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8816: WHEN OTHERS THEN

Line 8814: x_return_status := fnd_api.g_ret_sts_unexp_error;

8810: x_return_status := fnd_api.g_ret_sts_error;
8811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8812: WHEN fnd_api.g_exc_unexpected_error THEN
8813: ROLLBACK TO volume_offer_adjustment;
8814: x_return_status := fnd_api.g_ret_sts_unexp_error;
8815: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8816: WHEN OTHERS THEN
8817: ROLLBACK TO volume_offer_adjustment;
8818: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

8811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8812: WHEN fnd_api.g_exc_unexpected_error THEN
8813: ROLLBACK TO volume_offer_adjustment;
8814: x_return_status := fnd_api.g_ret_sts_unexp_error;
8815: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8816: WHEN OTHERS THEN
8817: ROLLBACK TO volume_offer_adjustment;
8818: x_return_status := fnd_api.g_ret_sts_unexp_error;
8819: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 8818: x_return_status := fnd_api.g_ret_sts_unexp_error;

8814: x_return_status := fnd_api.g_ret_sts_unexp_error;
8815: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8816: WHEN OTHERS THEN
8817: ROLLBACK TO volume_offer_adjustment;
8818: x_return_status := fnd_api.g_ret_sts_unexp_error;
8819: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8820: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
8821: END IF;
8822: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

8818: x_return_status := fnd_api.g_ret_sts_unexp_error;
8819: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8820: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
8821: END IF;
8822: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
8823:
8824: END volume_offer_adjustment;
8825:
8826:

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

9162: l_offer_curr VARCHAR2(30);
9163: l_offer_id NUMBER;
9164: l_selling_price NUMBER;
9165: l_apply_discount VARCHAR2(1) ;
9166: l_return_status VARCHAR2 (20) := fnd_api.g_ret_sts_success;
9167: l_conv_price NUMBER;
9168: l_rate NUMBER;
9169: l_new_utilization NUMBER;
9170: l_invoice_to_org_id NUMBER;

Line 9334: IF l_return_status = fnd_api.g_ret_sts_error THEN

9330: ,x_to_amount => l_conv_price
9331: ,x_rate => l_rate
9332: );
9333:
9334: IF l_return_status = fnd_api.g_ret_sts_error THEN
9335: RAISE fnd_api.g_exc_error;
9336: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9337: RAISE fnd_api.g_exc_unexpected_error;
9338: END IF;

Line 9335: RAISE fnd_api.g_exc_error;

9331: ,x_rate => l_rate
9332: );
9333:
9334: IF l_return_status = fnd_api.g_ret_sts_error THEN
9335: RAISE fnd_api.g_exc_error;
9336: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9337: RAISE fnd_api.g_exc_unexpected_error;
9338: END IF;
9339:

Line 9336: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

9332: );
9333:
9334: IF l_return_status = fnd_api.g_ret_sts_error THEN
9335: RAISE fnd_api.g_exc_error;
9336: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9337: RAISE fnd_api.g_exc_unexpected_error;
9338: END IF;
9339:
9340: l_selling_price := NVL(l_conv_price,0);

Line 9337: RAISE fnd_api.g_exc_unexpected_error;

9333:
9334: IF l_return_status = fnd_api.g_ret_sts_error THEN
9335: RAISE fnd_api.g_exc_error;
9336: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9337: RAISE fnd_api.g_exc_unexpected_error;
9338: END IF;
9339:
9340: l_selling_price := NVL(l_conv_price,0);
9341: write_conc_log ('selling price after currency conversion: ' || l_selling_price);

Line 9718: IF l_return_status = fnd_api.g_ret_sts_error THEN

9714: ,x_act_budget_id => l_act_budget_id
9715: );
9716:
9717: write_conc_log('process_act_budgets returns: ' || x_return_status);
9718: IF l_return_status = fnd_api.g_ret_sts_error THEN
9719: RAISE fnd_api.g_exc_error;
9720: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9721: RAISE fnd_api.g_exc_unexpected_error;
9722: END IF;

Line 9719: RAISE fnd_api.g_exc_error;

9715: );
9716:
9717: write_conc_log('process_act_budgets returns: ' || x_return_status);
9718: IF l_return_status = fnd_api.g_ret_sts_error THEN
9719: RAISE fnd_api.g_exc_error;
9720: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9721: RAISE fnd_api.g_exc_unexpected_error;
9722: END IF;
9723: END IF;

Line 9720: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

9716:
9717: write_conc_log('process_act_budgets returns: ' || x_return_status);
9718: IF l_return_status = fnd_api.g_ret_sts_error THEN
9719: RAISE fnd_api.g_exc_error;
9720: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9721: RAISE fnd_api.g_exc_unexpected_error;
9722: END IF;
9723: END IF;
9724: -- END IF;

Line 9721: RAISE fnd_api.g_exc_unexpected_error;

9717: write_conc_log('process_act_budgets returns: ' || x_return_status);
9718: IF l_return_status = fnd_api.g_ret_sts_error THEN
9719: RAISE fnd_api.g_exc_error;
9720: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9721: RAISE fnd_api.g_exc_unexpected_error;
9722: END IF;
9723: END IF;
9724: -- END IF;
9725: