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_TP_ACCRUAL_PVT dependencies on OZF_UTILITY_PVT

Line 99: ozf_utility_pvt.error_message('OZF_RESALE_IS_TM_OFFER');

95: WHEN FND_API.G_EXC_ERROR THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: WHEN OTHERS THEN
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: ozf_utility_pvt.error_message('OZF_RESALE_IS_TM_OFFER');
100: END is_valid_offer;
101:
102: ---------------------------------------------------------------------
103: -- PROCEDURE

Line 160: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

156: END IF;
157:
158: -- Debug Message
159: IF OZF_DEBUG_HIGH_ON THEN
160: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
161: END IF;
162:
163: -- First, do some basic check
164:

Line 173: ozf_utility_pvt.error_message('OZF_BATCH_STATUS_WNG');

169: -- Check status
170: IF l_status_code <> 'CLOSED' THEN
171:
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: ozf_utility_pvt.error_message('OZF_BATCH_STATUS_WNG');
174: BEGIN
175: INSERT INTO ozf_resale_logs_all(
176: resale_log_id,
177: resale_id,

Line 214: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

210: END IF;
211:
212: -- Debug Message
213: IF OZF_DEBUG_HIGH_ON THEN
214: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
215: END IF;
216:
217: --Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (

Line 299: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

295: END IF;
296:
297: -- Debug Message
298: IF OZF_DEBUG_HIGH_ON THEN
299: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
300: END IF;
301:
302: -- Initialize API return status to sucess
303: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 340: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');

336: AND a.error_code ='OZF_RESALE_SELL_PRICE_NULL'
337: );
338: EXCEPTION
339: WHEN OTHERS THEN
340: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END;
343:
344: BEGIN

Line 354: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

350: AND selling_price IS NULL
351: AND resale_batch_id = p_resale_batch_id;
352: EXCEPTION
353: WHEN OTHERS THEN
354: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END;
357:
358: ELSE

Line 392: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');

388: AND a.error_code ='OZF_RESALE_SELL_PRICE_NULL'
389: );
390: EXCEPTION
391: WHEN OTHERS THEN
392: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END;
395: END IF;
396:

Line 399: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

395: END IF;
396:
397: -- Debug Message
398: IF OZF_DEBUG_HIGH_ON THEN
399: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
400: END IF;
401: --Standard call to get message count and if count=1, get the message
402: FND_MSG_PUB.Count_And_Get (
403: p_encoded => FND_API.G_FALSE,

Line 567: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

563: l_offer_type VARCHAR2(30);
564: -- end julou 5723309
565: BEGIN
566: IF OZF_DEBUG_HIGH_ON THEN
567: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
568: END IF;
569:
570: SAVEPOINT PROC_ONE_LINE;
571:

Line 577: ozf_utility_pvt.error_message('OZF_RESALE_INT_RECD_NULL');

573:
574: -- Make sure that records are passed in due to different caller type
575: IF p_caller_type = 'IFACE' AND
576: p_resale_line_int_rec.resale_line_int_id IS NULL THEN
577: ozf_utility_pvt.error_message('OZF_RESALE_INT_RECD_NULL');
578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;
580:
581: IF p_caller_type = 'RESALE' AND

Line 583: ozf_utility_pvt.error_message('OZF_RESALE_RECD_NULL');

579: END IF;
580:
581: IF p_caller_type = 'RESALE' AND
582: p_resale_line_rec.resale_line_id IS NULL THEN
583: ozf_utility_pvt.error_message('OZF_RESALE_RECD_NULL');
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587: -- create a resale line record, if it's FROM iface

Line 602: ozf_utility_pvt.error_message('OZF_INS_RESALE_LINE_WRG');

598: ,x_msg_data => l_msg_data
599: ,x_msg_count => l_msg_count
600: );
601: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
602: ozf_utility_pvt.error_message('OZF_INS_RESALE_LINE_WRG');
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(

Line 697: ozf_utility_PVT.debug_message(l_api_name||' >> do price adjustment');

693: );
694:
695: IF OZF_DEBUG_LOW_ON THEN
696: IF l_price_diff_util THEN
697: ozf_utility_PVT.debug_message(l_api_name||' >> do price adjustment');
698: ELSE
699: ozf_utility_pvt.debug_message(l_api_name||' >> no price adjustment');
700: END IF;
701: END IF;

Line 699: ozf_utility_pvt.debug_message(l_api_name||' >> no price adjustment');

695: IF OZF_DEBUG_LOW_ON THEN
696: IF l_price_diff_util THEN
697: ozf_utility_PVT.debug_message(l_api_name||' >> do price adjustment');
698: ELSE
699: ozf_utility_pvt.debug_message(l_api_name||' >> no price adjustment');
700: END IF;
701: END IF;
702:
703: IF l_ldets_tbl.EXISTS(1) THEN

Line 725: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (+)');

721: -- END IF;
722: -- list_line_type_code 'PLL' is added.
723:
724: IF OZF_DEBUG_LOW_ON THEN
725: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (+)');
726: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);
728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);
729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);

Line 726: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);

722: -- list_line_type_code 'PLL' is added.
723:
724: IF OZF_DEBUG_LOW_ON THEN
725: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (+)');
726: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);
728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);
729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);
730: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').automatic_flag = '||l_ldets_tbl(k).automatic_flag);

Line 727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);

723:
724: IF OZF_DEBUG_LOW_ON THEN
725: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (+)');
726: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);
728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);
729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);
730: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').automatic_flag = '||l_ldets_tbl(k).automatic_flag);
731: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (-)');

Line 728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);

724: IF OZF_DEBUG_LOW_ON THEN
725: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (+)');
726: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);
728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);
729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);
730: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').automatic_flag = '||l_ldets_tbl(k).automatic_flag);
731: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (-)');
732: END IF;

Line 729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);

725: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (+)');
726: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);
728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);
729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);
730: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').automatic_flag = '||l_ldets_tbl(k).automatic_flag);
731: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (-)');
732: END IF;
733:

Line 730: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').automatic_flag = '||l_ldets_tbl(k).automatic_flag);

726: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);
728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);
729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);
730: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').automatic_flag = '||l_ldets_tbl(k).automatic_flag);
731: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (-)');
732: END IF;
733:
734: IF l_ldets_tbl(k).list_line_type_code IN ('DIS','PBH', 'PLL') THEN

Line 731: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (-)');

727: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_line_type_code = '||l_ldets_tbl(k).list_line_type_code);
728: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').applied_flag = '||l_ldets_tbl(k).applied_flag);
729: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').accrual_flag = '||l_ldets_tbl(k).accrual_flag);
730: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').automatic_flag = '||l_ldets_tbl(k).automatic_flag);
731: ozf_utility_pvt.debug_message(l_api_name||' >> qp_ldets_v (-)');
732: END IF;
733:
734: IF l_ldets_tbl(k).list_line_type_code IN ('DIS','PBH', 'PLL') THEN
735: -- create utilization based on an offer

Line 769: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (+)');

765: END IF;
766:
767: IF OZF_DEBUG_LOW_ON THEN
768: IF l_is_valid_offer OR l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
769: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (+)');
770: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
771: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').order_qty_adj_amt = '||l_ldets_tbl(k).order_qty_adj_amt);
772: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').line_quantity = '||l_ldets_tbl(k).line_quantity);
773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);

Line 770: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);

766:
767: IF OZF_DEBUG_LOW_ON THEN
768: IF l_is_valid_offer OR l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
769: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (+)');
770: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
771: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').order_qty_adj_amt = '||l_ldets_tbl(k).order_qty_adj_amt);
772: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').line_quantity = '||l_ldets_tbl(k).line_quantity);
773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);
774: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN

Line 771: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').order_qty_adj_amt = '||l_ldets_tbl(k).order_qty_adj_amt);

767: IF OZF_DEBUG_LOW_ON THEN
768: IF l_is_valid_offer OR l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
769: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (+)');
770: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
771: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').order_qty_adj_amt = '||l_ldets_tbl(k).order_qty_adj_amt);
772: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').line_quantity = '||l_ldets_tbl(k).line_quantity);
773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);
774: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
775: ozf_utility_pvt.debug_message('order line unit_price = '||p_line_result_rec.unit_price);

Line 772: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').line_quantity = '||l_ldets_tbl(k).line_quantity);

768: IF l_is_valid_offer OR l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
769: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (+)');
770: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
771: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').order_qty_adj_amt = '||l_ldets_tbl(k).order_qty_adj_amt);
772: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').line_quantity = '||l_ldets_tbl(k).line_quantity);
773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);
774: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
775: ozf_utility_pvt.debug_message('order line unit_price = '||p_line_result_rec.unit_price);
776: END IF;

Line 773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);

769: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (+)');
770: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').list_header_id = '||l_ldets_tbl(k).list_header_id);
771: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').order_qty_adj_amt = '||l_ldets_tbl(k).order_qty_adj_amt);
772: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').line_quantity = '||l_ldets_tbl(k).line_quantity);
773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);
774: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
775: ozf_utility_pvt.debug_message('order line unit_price = '||p_line_result_rec.unit_price);
776: END IF;
777: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (-)');

Line 775: ozf_utility_pvt.debug_message('order line unit_price = '||p_line_result_rec.unit_price);

771: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').order_qty_adj_amt = '||l_ldets_tbl(k).order_qty_adj_amt);
772: ozf_utility_pvt.debug_message('l_ldets_tbl('||k||').line_quantity = '||l_ldets_tbl(k).line_quantity);
773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);
774: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
775: ozf_utility_pvt.debug_message('order line unit_price = '||p_line_result_rec.unit_price);
776: END IF;
777: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (-)');
778: END IF;
779: END IF;

Line 777: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (-)');

773: ozf_utility_pvt.debug_message('order line priced_quantity = '||p_line_result_rec.priced_quantity);
774: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
775: ozf_utility_pvt.debug_message('order line unit_price = '||p_line_result_rec.unit_price);
776: END IF;
777: ozf_utility_pvt.debug_message(l_api_name||' >> Accrual for TM OFFR or PLL adjustment (-)');
778: END IF;
779: END IF;
780:
781: IF l_is_valid_offer THEN

Line 919: ozf_utility_pvt.write_conc_log('JL: bill_to_site_use_id = ' || p_resale_line_rec.bill_to_site_use_id);

915: l_act_util_rec.product_level_type :='PRODUCT';
916:
917: l_act_util_rec.bill_to_site_use_id := p_resale_line_rec.bill_to_site_use_id;
918: l_act_util_rec.ship_to_site_use_id := p_resale_line_rec.ship_to_site_use_id;
919: ozf_utility_pvt.write_conc_log('JL: bill_to_site_use_id = ' || p_resale_line_rec.bill_to_site_use_id);
920: ozf_utility_pvt.write_conc_log('JL: ship_to_site_use_id = ' || p_resale_line_rec.ship_to_site_use_id);
921: IF p_caller_type = 'IFACE' THEN
922: l_act_util_rec.product_id := p_resale_line_int_rec.inventory_item_Id;
923: -- Here, there is a need to look INTO trading group issue

Line 920: ozf_utility_pvt.write_conc_log('JL: ship_to_site_use_id = ' || p_resale_line_rec.ship_to_site_use_id);

916:
917: l_act_util_rec.bill_to_site_use_id := p_resale_line_rec.bill_to_site_use_id;
918: l_act_util_rec.ship_to_site_use_id := p_resale_line_rec.ship_to_site_use_id;
919: ozf_utility_pvt.write_conc_log('JL: bill_to_site_use_id = ' || p_resale_line_rec.bill_to_site_use_id);
920: ozf_utility_pvt.write_conc_log('JL: ship_to_site_use_id = ' || p_resale_line_rec.ship_to_site_use_id);
921: IF p_caller_type = 'IFACE' THEN
922: l_act_util_rec.product_id := p_resale_line_int_rec.inventory_item_Id;
923: -- Here, there is a need to look INTO trading group issue
924: -- Handled by budget

Line 962: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(p_approver_id);

958:
959: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
960: l_act_budgets_rec.arc_act_budget_used_by := 'PRIC';
961: l_act_budgets_rec.budget_source_type := 'PRIC';
962: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(p_approver_id);
963: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id(p_approver_id);
964: l_act_budgets_rec.request_currency := p_line_result_rec.currency_code;
965:
966: -- Get fund info for price difference

Line 963: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id(p_approver_id);

959: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
960: l_act_budgets_rec.arc_act_budget_used_by := 'PRIC';
961: l_act_budgets_rec.budget_source_type := 'PRIC';
962: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(p_approver_id);
963: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id(p_approver_id);
964: l_act_budgets_rec.request_currency := p_line_result_rec.currency_code;
965:
966: -- Get fund info for price difference
967: -- get chargeback budget id FROM profile

Line 969: ozf_utility_pvt.error_message('OZF_THRDPTY_BUDGET_ERR');

965:
966: -- Get fund info for price difference
967: -- get chargeback budget id FROM profile
968: IF p_price_diff_fund_id IS NULL THEN
969: ozf_utility_pvt.error_message('OZF_THRDPTY_BUDGET_ERR');
970: RAISE FND_API.g_exc_error;
971: ELSE
972: l_act_budgets_rec.parent_source_id := p_price_diff_fund_id;
973: END IF;

Line 1008: OZF_UTILITY_PVT.convert_currency(

1004: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1005: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1006: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1007:
1008: OZF_UTILITY_PVT.convert_currency(
1009: p_from_currency => p_line_result_rec.currency_code
1010: ,p_to_currency => l_act_budgets_rec.request_currency
1011: ,p_conv_type => l_exchange_type
1012: ,p_conv_rate => FND_API.G_MISS_NUM

Line 1025: ozf_utility_PVT.debug_message('act budget: '||l_act_budgets_rec.request_amount);

1021: END IF;
1022: l_act_budgets_rec.request_amount := l_new_request_amount;
1023: END IF;
1024: IF OZF_DEBUG_LOW_ON THEN
1025: ozf_utility_PVT.debug_message('act budget: '||l_act_budgets_rec.request_amount);
1026: END IF;
1027:
1028: -- Utilization always have different sign than the price adjustment
1029: l_adjustment_rec.calculated_amount := l_act_budgets_rec.request_amount;

Line 1040: OZF_UTILITY_PVT.convert_currency(

1036: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1037: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1038: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1039:
1040: OZF_UTILITY_PVT.convert_currency(
1041: p_FROM_currency => p_line_result_rec.currency_code
1042: ,p_to_currency => l_act_budgets_rec.parent_src_curr
1043: ,p_conv_type => l_exchange_type
1044: ,p_conv_rate => FND_API.G_MISS_NUM

Line 1066: ozf_utility_pvt.debug_message(' JL offer_type: ' || l_offer_type);

1062: FETCH c_offer_type INTO l_offer_type;
1063: CLOSE c_offer_type;
1064:
1065: IF OZF_DEBUG_LOW_ON THEN
1066: ozf_utility_pvt.debug_message(' JL offer_type: ' || l_offer_type);
1067: ozf_utility_pvt.debug_message(' JL list_line_type_code: ' || l_ldets_tbl(k).list_line_type_code);
1068: ozf_utility_pvt.debug_message(' JL calculated_amount: ' || l_adjustment_rec.calculated_amount);
1069: END IF;
1070:

Line 1067: ozf_utility_pvt.debug_message(' JL list_line_type_code: ' || l_ldets_tbl(k).list_line_type_code);

1063: CLOSE c_offer_type;
1064:
1065: IF OZF_DEBUG_LOW_ON THEN
1066: ozf_utility_pvt.debug_message(' JL offer_type: ' || l_offer_type);
1067: ozf_utility_pvt.debug_message(' JL list_line_type_code: ' || l_ldets_tbl(k).list_line_type_code);
1068: ozf_utility_pvt.debug_message(' JL calculated_amount: ' || l_adjustment_rec.calculated_amount);
1069: END IF;
1070:
1071: l_to_create_utilization := (l_ldets_tbl(k).list_line_type_code = 'PLL' AND

Line 1068: ozf_utility_pvt.debug_message(' JL calculated_amount: ' || l_adjustment_rec.calculated_amount);

1064:
1065: IF OZF_DEBUG_LOW_ON THEN
1066: ozf_utility_pvt.debug_message(' JL offer_type: ' || l_offer_type);
1067: ozf_utility_pvt.debug_message(' JL list_line_type_code: ' || l_ldets_tbl(k).list_line_type_code);
1068: ozf_utility_pvt.debug_message(' JL calculated_amount: ' || l_adjustment_rec.calculated_amount);
1069: END IF;
1070:
1071: l_to_create_utilization := (l_ldets_tbl(k).list_line_type_code = 'PLL' AND
1072: l_adjustment_rec.calculated_amount IS NOT NULL)

Line 1199: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');

1195:
1196: x_return_status := l_return_status;
1197:
1198: IF OZF_DEBUG_HIGH_ON THEN
1199: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');
1200: END IF;
1201:
1202: EXCEPTION
1203: WHEN FND_API.G_EXC_ERROR THEN

Line 1361: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');

1357: -- end bug 6317120
1358: BEGIN
1359: -- Debug Message
1360: IF OZF_DEBUG_HIGH_ON THEN
1361: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');
1362: END IF;
1363:
1364: x_return_status := FND_API.G_RET_STS_SUCCESS;
1365:

Line 1377: ozf_utility_pvt.error_message('OZF_THRDPTY_BUDGET_ERR');

1373: l_last_updated_by;
1374: CLOSE batch_info_csr;
1375:
1376: IF l_fund_id is null THEN
1377: ozf_utility_pvt.error_message('OZF_THRDPTY_BUDGET_ERR');
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please setup Profile OZF : Price Difference Budget before running Third Party Accrual.');
1379: RAISE FND_API.g_exc_error;
1380: END IF;
1381:

Line 1420: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

1416: AND date_ordered = l_date_ordered
1417: AND resale_batch_id = p_resale_batch_id;
1418: EXCEPTION
1419: WHEN OTHERS THEN
1420: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END;
1423: l_id_type := 'IFACE';
1424: ELSE

Line 1457: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');

1453: px_org_id => l_org_id
1454: );
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');
1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1459: END;
1460: END LOOP;
1461: ELSE

Line 1500: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

1496: ,x_msg_count => l_msg_count
1497: ,x_msg_data => l_msg_data
1498: );
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1503: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: END IF;
1506: /*
1507: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (

Line 1518: ozf_utility_pvt.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

1514: ,x_msg_count => l_msg_count
1515: ,x_msg_data => l_msg_data
1516: );
1517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1518: ozf_utility_pvt.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1520: END IF;
1521: */
1522: -- Bug

Line 1554: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Need inventory tracking' );

1550: -- If inventory level IS lower than the asked, then there IS no need to
1551: -- continue processing
1552: IF l_inventory_tracking = 'T' THEN
1553: IF OZF_DEBUG_LOW_ON THEN
1554: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Need inventory tracking' );
1555: END IF;
1556:
1557: -- Check inventory level first
1558: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (

Line 1571: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Did not pass inventory checking');

1567: );
1568:
1569: IF NOT l_inventory_level_valid THEN
1570: IF OZF_DEBUG_LOW_ON THEN
1571: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Did not pass inventory checking');
1572: END IF;
1573: --
1574: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1575: p_id_value => l_resale_int_rec.resale_line_int_id,

Line 1602: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Pass inventory validation');

1598: -- Batch status won't be set to DISPUTED.
1599: -- TP Accrual Process will still continue.
1600: ELSE
1601: IF OZF_DEBUG_LOW_ON THEN
1602: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Pass inventory validation');
1603: END IF;
1604: END IF;
1605: --
1606: END IF;

Line 1651: ozf_utility_pvt.error_message('OZF_CLAIM_CONTYPE_MISSING');

1647: l_exchange_type := l_default_exchange_type;
1648: END IF;
1649:
1650: IF l_exchange_type IS NULL THEN
1651: ozf_utility_pvt.error_message('OZF_CLAIM_CONTYPE_MISSING');
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654:
1655: IF l_exchange_date IS NULL THEN

Line 1660: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Convert Currency <<');

1656: l_exchange_date := sysdate;
1657: END IF;
1658:
1659: IF OZF_DEBUG_LOW_ON THEN
1660: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Convert Currency <<');
1661: OZF_UTILITY_PVT.debug_message(l_api_name||' >> from currency :' || l_resale_int_rec.currency_code);
1662: OZF_UTILITY_PVT.debug_message(l_api_name||' >> to currency :' || l_func_currency_code);
1663: OZF_UTILITY_PVT.debug_message(l_api_name||' >> rate :' || l_rate);
1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);

Line 1661: OZF_UTILITY_PVT.debug_message(l_api_name||' >> from currency :' || l_resale_int_rec.currency_code);

1657: END IF;
1658:
1659: IF OZF_DEBUG_LOW_ON THEN
1660: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Convert Currency <<');
1661: OZF_UTILITY_PVT.debug_message(l_api_name||' >> from currency :' || l_resale_int_rec.currency_code);
1662: OZF_UTILITY_PVT.debug_message(l_api_name||' >> to currency :' || l_func_currency_code);
1663: OZF_UTILITY_PVT.debug_message(l_api_name||' >> rate :' || l_rate);
1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);
1665: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange type :' || l_exchange_type);

Line 1662: OZF_UTILITY_PVT.debug_message(l_api_name||' >> to currency :' || l_func_currency_code);

1658:
1659: IF OZF_DEBUG_LOW_ON THEN
1660: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Convert Currency <<');
1661: OZF_UTILITY_PVT.debug_message(l_api_name||' >> from currency :' || l_resale_int_rec.currency_code);
1662: OZF_UTILITY_PVT.debug_message(l_api_name||' >> to currency :' || l_func_currency_code);
1663: OZF_UTILITY_PVT.debug_message(l_api_name||' >> rate :' || l_rate);
1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);
1665: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange type :' || l_exchange_type);
1666: END IF;

Line 1663: OZF_UTILITY_PVT.debug_message(l_api_name||' >> rate :' || l_rate);

1659: IF OZF_DEBUG_LOW_ON THEN
1660: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Convert Currency <<');
1661: OZF_UTILITY_PVT.debug_message(l_api_name||' >> from currency :' || l_resale_int_rec.currency_code);
1662: OZF_UTILITY_PVT.debug_message(l_api_name||' >> to currency :' || l_func_currency_code);
1663: OZF_UTILITY_PVT.debug_message(l_api_name||' >> rate :' || l_rate);
1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);
1665: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange type :' || l_exchange_type);
1666: END IF;
1667:

Line 1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);

1660: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Convert Currency <<');
1661: OZF_UTILITY_PVT.debug_message(l_api_name||' >> from currency :' || l_resale_int_rec.currency_code);
1662: OZF_UTILITY_PVT.debug_message(l_api_name||' >> to currency :' || l_func_currency_code);
1663: OZF_UTILITY_PVT.debug_message(l_api_name||' >> rate :' || l_rate);
1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);
1665: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange type :' || l_exchange_type);
1666: END IF;
1667:
1668: OZF_UTILITY_PVT.Convert_Currency(

Line 1665: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange type :' || l_exchange_type);

1661: OZF_UTILITY_PVT.debug_message(l_api_name||' >> from currency :' || l_resale_int_rec.currency_code);
1662: OZF_UTILITY_PVT.debug_message(l_api_name||' >> to currency :' || l_func_currency_code);
1663: OZF_UTILITY_PVT.debug_message(l_api_name||' >> rate :' || l_rate);
1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);
1665: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange type :' || l_exchange_type);
1666: END IF;
1667:
1668: OZF_UTILITY_PVT.Convert_Currency(
1669: p_from_currency => l_resale_int_rec.currency_code

Line 1668: OZF_UTILITY_PVT.Convert_Currency(

1664: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange date :' || l_exchange_date);
1665: OZF_UTILITY_PVT.debug_message(l_api_name||' >> exchange type :' || l_exchange_type);
1666: END IF;
1667:
1668: OZF_UTILITY_PVT.Convert_Currency(
1669: p_from_currency => l_resale_int_rec.currency_code
1670: ,p_to_currency => l_func_currency_code
1671: ,p_conv_type => l_exchange_type
1672: ,p_conv_rate => l_rate

Line 1685: OZF_UTILITY_PVT.Convert_Currency(

1681: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684:
1685: OZF_UTILITY_PVT.Convert_Currency(
1686: p_from_currency => l_resale_int_rec.currency_code
1687: ,p_to_currency => l_func_currency_code
1688: ,p_conv_type => l_exchange_type
1689: ,p_conv_rate => l_rate

Line 1701: l_acctd_adj_unit_price := OZF_UTILITY_PVT.CurrRound(p_line_tbl(i).adjusted_unit_price*l_rate, l_func_currency_code);

1697: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1699: END IF;
1700: ELSE
1701: l_acctd_adj_unit_price := OZF_UTILITY_PVT.CurrRound(p_line_tbl(i).adjusted_unit_price*l_rate, l_func_currency_code);
1702: l_acctd_selling_price := OZF_UTILITY_PVT.CurrRound(l_resale_int_rec.selling_price*l_rate, l_func_currency_code);
1703: END IF;
1704: ELSE
1705: l_rate := 1;

Line 1702: l_acctd_selling_price := OZF_UTILITY_PVT.CurrRound(l_resale_int_rec.selling_price*l_rate, l_func_currency_code);

1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1699: END IF;
1700: ELSE
1701: l_acctd_adj_unit_price := OZF_UTILITY_PVT.CurrRound(p_line_tbl(i).adjusted_unit_price*l_rate, l_func_currency_code);
1702: l_acctd_selling_price := OZF_UTILITY_PVT.CurrRound(l_resale_int_rec.selling_price*l_rate, l_func_currency_code);
1703: END IF;
1704: ELSE
1705: l_rate := 1;
1706: l_acctd_adj_unit_price := p_line_tbl(i).adjusted_unit_price;

Line 1742: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

1738: dispute_code = 'OZF_PRIC_RESULT_ERR'
1739: WHERE resale_line_int_id = p_line_tbl(i).chargeback_int_id;
1740: EXCEPTION
1741: WHEN OTHERS THEN
1742: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
1743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1744: END;
1745: END IF;
1746: ELSE

Line 1755: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

1751: SET status_code= 'CLOSED'
1752: WHERE resale_line_int_id = p_line_tbl(i).chargeback_int_id;
1753: EXCEPTION
1754: WHEN OTHERS THEN
1755: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
1756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1757: END;
1758: END IF;
1759: END IF;

Line 1768: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');

1764:
1765: x_return_status := l_return_status;
1766:
1767: IF OZF_DEBUG_HIGH_ON THEN
1768: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
1769: END IF;
1770:
1771: EXCEPTION
1772: WHEN FND_API.G_EXC_ERROR THEN

Line 1900: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

1896: END IF;
1897:
1898: -- Debug Message
1899: IF OZF_DEBUG_HIGH_ON THEN
1900: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
1901: END IF;
1902:
1903: -- Initialize API return status to sucess
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1919: ozf_utility_PVT.debug_message('pricing event default');

1915:
1916: l_control_rec.pricing_event := fnd_profile.value('OZF_PRICING_SIMULATION_EVENT');
1917: IF l_control_rec.pricing_event is NULL THEN
1918: IF OZF_DEBUG_LOW_ON THEN
1919: ozf_utility_PVT.debug_message('pricing event default');
1920: END IF;
1921: l_control_rec.pricing_event := 'BATCH,BOOK,SHIP';
1922: ELSE
1923: IF l_control_rec.pricing_event = 'BATCH' THEN

Line 1933: ozf_utility_PVT.debug_message('Event:' ||l_control_rec.pricing_event );

1929: END IF;
1930: END IF;
1931:
1932: IF OZF_DEBUG_LOW_ON THEN
1933: ozf_utility_PVT.debug_message('Event:' ||l_control_rec.pricing_event );
1934: END IF;
1935:
1936: l_control_rec.calculate_flag := 'Y';
1937: l_control_rec.simulation_flag := 'Y';

Line 1978: ozf_utility_PVT.debug_message('Price flag:' ||l_price_flag );

1974: ELSE
1975: l_price_flag := 'Y';
1976: END IF;
1977: IF OZF_DEBUG_LOW_ON THEN
1978: ozf_utility_PVT.debug_message('Price flag:' ||l_price_flag );
1979: ozf_utility_PVT.debug_message('List Price Override Flag:' ||l_list_price_override_flag);
1980: END IF;
1981:
1982: For i in 1..l_header_id_tbl.LAST

Line 1979: ozf_utility_PVT.debug_message('List Price Override Flag:' ||l_list_price_override_flag);

1975: l_price_flag := 'Y';
1976: END IF;
1977: IF OZF_DEBUG_LOW_ON THEN
1978: ozf_utility_PVT.debug_message('Price flag:' ||l_price_flag );
1979: ozf_utility_PVT.debug_message('List Price Override Flag:' ||l_list_price_override_flag);
1980: END IF;
1981:
1982: For i in 1..l_header_id_tbl.LAST
1983: LOOP

Line 1990: ozf_utility_PVT.debug_message('/--- Processing order for order NUMBER:'||l_header_id_tbl(i).resale_header_id||'---/');

1986:
1987: QP_Price_Request_Context.Set_Request_Id;
1988:
1989: IF OZF_DEBUG_LOW_ON THEN
1990: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||l_header_id_tbl(i).resale_header_id||'---*/');
1991: END IF;
1992: -- Before start process, clean up the data structures if necessary.
1993: IF l_order_set_tbl.EXISTS(1) THEN l_order_set_tbl.DELETE; END IF;
1994: IF l_line_tbl.EXISTS(1) THEN l_line_tbl.DELETE; END IF;

Line 2016: ozf_utility_PVT.debug_message('after order set'||l_order_set_tbl.LAST);

2012: --END LOOP;
2013: CLOSE order_set_csr;
2014:
2015: IF OZF_DEBUG_LOW_ON THEN
2016: ozf_utility_PVT.debug_message('after order set'||l_order_set_tbl.LAST);
2017: END IF;
2018: IF l_order_set_tbl.exists(1) THEN
2019: For J in 1..l_order_set_tbl.LAST
2020: LOOP

Line 2030: ozf_utility_pvt.error_message('OZF_DEL_RESALE_LOG_WRG');

2026: WHERE resale_id = l_order_set_tbl(J).resale_line_id
2027: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE;
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: ozf_utility_pvt.error_message('OZF_DEL_RESALE_LOG_WRG');
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2032: END;
2033:
2034: IF OZF_DEBUG_LOW_ON THEN

Line 2035: ozf_utility_PVT.debug_message(l_api_name||'>> building order line for resale line id: '||l_order_set_tbl(j).resale_line_id);

2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2032: END;
2033:
2034: IF OZF_DEBUG_LOW_ON THEN
2035: ozf_utility_PVT.debug_message(l_api_name||'>> building order line for resale line id: '||l_order_set_tbl(j).resale_line_id);
2036: END IF;
2037:
2038: -- INSERT INTO l_line_tbl
2039: l_line_tbl(j).line_index := j;

Line 2181: ozf_utility_PVT.debug_message(l_api_name||'>> building order header');

2177:
2178: END LOOP;
2179:
2180: IF OZF_DEBUG_LOW_ON THEN
2181: ozf_utility_PVT.debug_message(l_api_name||'>> building order header');
2182: END IF;
2183:
2184: -- build summary line
2185: k := l_order_set_tbl.LAST + 1;

Line 2228: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');

2224: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_header_rec.date_ordered;
2225:
2226:
2227: IF OZF_DEBUG_LOW_ON THEN
2228: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');
2229: END IF;
2230:
2231: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2232: p_api_version => 1.0

Line 2245: ozf_utility_pvt.error_message('OZF_GET_ORDER_PRIC_ERR');

2241: ,x_ldets_tbl => l_ldets_tbl
2242: ,x_related_lines_tbl => l_related_lines_tbl
2243: );
2244: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
2245: ozf_utility_pvt.error_message('OZF_GET_ORDER_PRIC_ERR');
2246:
2247: FOR p in 1..l_order_set_tbl.LAST
2248: LOOP
2249: BEGIN

Line 2272: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');

2268: px_org_id => l_org_id
2269: );
2270: EXCEPTION
2271: WHEN OTHERS THEN
2272: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');
2273: RAISE FND_API.g_exc_unexpected_error;
2274: END;
2275: END LOOP;
2276: IF OZF_DEBUG_LOW_ON THEN

Line 2277: ozf_utility_PVT.debug_message('/--- Get order price failed ---/');

2273: RAISE FND_API.g_exc_unexpected_error;
2274: END;
2275: END LOOP;
2276: IF OZF_DEBUG_LOW_ON THEN
2277: ozf_utility_PVT.debug_message('/*--- Get order price failed ---*/');
2278: END IF;
2279: GOTO END_LOOP;
2280: END IF;
2281: IF OZF_DEBUG_LOW_ON THEN

Line 2282: ozf_utility_PVT.debug_message('/--- Get order price succeeded ---/');

2278: END IF;
2279: GOTO END_LOOP;
2280: END IF;
2281: IF OZF_DEBUG_LOW_ON THEN
2282: ozf_utility_PVT.debug_message('/*--- Get order price succeeded ---*/');
2283: ozf_utility_PVT.debug_message('calling process price result');
2284: ozf_utility_PVT.debug_message('/*--- Calling process_price_result: ---*/');
2285: END IF;
2286:

Line 2283: ozf_utility_PVT.debug_message('calling process price result');

2279: GOTO END_LOOP;
2280: END IF;
2281: IF OZF_DEBUG_LOW_ON THEN
2282: ozf_utility_PVT.debug_message('/*--- Get order price succeeded ---*/');
2283: ozf_utility_PVT.debug_message('calling process price result');
2284: ozf_utility_PVT.debug_message('/*--- Calling process_price_result: ---*/');
2285: END IF;
2286:
2287: -- Here, reasle_batch_id is passed for some process convenience, it's not necessary.

Line 2284: ozf_utility_PVT.debug_message('/--- Calling process_price_result: ---/');

2280: END IF;
2281: IF OZF_DEBUG_LOW_ON THEN
2282: ozf_utility_PVT.debug_message('/*--- Get order price succeeded ---*/');
2283: ozf_utility_PVT.debug_message('calling process price result');
2284: ozf_utility_PVT.debug_message('/*--- Calling process_price_result: ---*/');
2285: END IF;
2286:
2287: -- Here, reasle_batch_id is passed for some process convenience, it's not necessary.
2288:

Line 2309: ozf_utility_PVT.debug_message('After process_price:'||l_temp_count||' ,'||l_temp_data);

2305: p_data => l_temp_data,
2306: p_msg_index_out => l_temp_count
2307: );
2308: IF OZF_DEBUG_LOW_ON THEN
2309: ozf_utility_PVT.debug_message('After process_price:'||l_temp_count||' ,'||l_temp_data);
2310: END IF;
2311: FOR i in 1..l_order_set_tbl.LAST
2312: LOOP
2313: BEGIN

Line 2336: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');

2332: px_org_id => l_org_id
2333: );
2334: EXCEPTION
2335: WHEN OTHERS THEN
2336: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');
2337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2338: END;
2339: END LOOP;
2340: IF OZF_DEBUG_LOW_ON THEN

Line 2341: ozf_utility_PVT.debug_message('/--- process_price_result Failed ---/');

2337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2338: END;
2339: END LOOP;
2340: IF OZF_DEBUG_LOW_ON THEN
2341: ozf_utility_PVT.debug_message('/*--- process_price_result Failed ---*/');
2342: END IF;
2343: goto END_LOOP;
2344: END IF;
2345: ELSE

Line 2347: ozf_utility_PVT.debug_message('No order line to be processed');

2343: goto END_LOOP;
2344: END IF;
2345: ELSE
2346: IF OZF_DEBUG_LOW_ON THEN
2347: ozf_utility_PVT.debug_message('No order line to be processed');
2348: END IF;
2349: END IF;
2350: END IF; -- END if for order_NUMBER, bill_to cust not NULL
2351: << END_LOOP >>

Line 2356: ozf_utility_PVT.debug_message('/--- No order to process ---/');

2352: NULL;
2353: END LOOP;
2354: ELSE
2355: IF OZF_DEBUG_LOW_ON THEN
2356: ozf_utility_PVT.debug_message('/*--- No order to process ---*/');
2357: END IF;
2358: END IF;
2359: -- Debug Message
2360: IF OZF_DEBUG_HIGH_ON THEN

Line 2361: OZF_UTILITY_PVT.debug_message(l_full_name||': End'|| x_return_status);

2357: END IF;
2358: END IF;
2359: -- Debug Message
2360: IF OZF_DEBUG_HIGH_ON THEN
2361: OZF_UTILITY_PVT.debug_message(l_full_name||': End'|| x_return_status);
2362: END IF;
2363: --Standard call to get message count and if count=1, get the message
2364: FND_MSG_PUB.Count_And_Get (
2365: p_encoded => FND_API.G_FALSE,

Line 2451: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

2447: END IF;
2448:
2449: -- Debug Message
2450: IF OZF_DEBUG_LOW_ON THEN
2451: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
2452: END IF;
2453:
2454: -- Initialize API return status to sucess
2455: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2513: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

2509: END IF;
2510:
2511: -- Debug Message
2512: IF OZF_DEBUG_HIGH_ON THEN
2513: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2514: END IF;
2515: --Standard call to get message count and if count=1, get the message
2516: FND_MSG_PUB.Count_And_Get (
2517: p_encoded => FND_API.G_FALSE,

Line 2658: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

2654: END IF;
2655:
2656: -- Debug Message
2657: IF OZF_DEBUG_HIGH_ON THEN
2658: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
2659: END IF;
2660:
2661: -- Initialize API return status to sucess
2662: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2665: ozf_utility_PVT.debug_message('in mv id cust' );

2661: -- Initialize API return status to sucess
2662: x_return_status := FND_API.G_RET_STS_SUCCESS;
2663:
2664: IF OZF_DEBUG_LOW_ON THEN
2665: ozf_utility_PVT.debug_message('in mv id cust' );
2666: END IF;
2667: -- get org_id
2668: -- Start: bug # 5997978 fixed
2669: --OPEN org_id_csr;

Line 2677: ozf_utility_pvt.error_message('OZF_CLAIM_ORG_ID_MISSING');

2673: l_org_id := MO_GLOBAL.get_valid_org(l_batch_org_id);
2674: CLOSE org_id_csr;
2675:
2676: IF l_org_id is NULL THEN
2677: ozf_utility_pvt.error_message('OZF_CLAIM_ORG_ID_MISSING');
2678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2679: END IF;
2680:
2681: --j:=1;

Line 2699: ozf_utility_PVT.debug_message('mv indirect customer with order NUMBER, cust name:' || l_order_num_tbl(i).order_NUMBER|| ','||l_order_num_tbl(i).bill_to_cust_account_id);

2695: IF l_order_num_tbl.EXISTS(1) THEN
2696: FOR i in 1..l_order_num_tbl.LAST
2697: LOOP
2698: IF OZF_DEBUG_LOW_ON THEN
2699: ozf_utility_PVT.debug_message('mv indirect customer with order NUMBER, cust name:' || l_order_num_tbl(i).order_NUMBER|| ','||l_order_num_tbl(i).bill_to_cust_account_id);
2700: END IF;
2701:
2702: j:=1;
2703: OPEN interface_rec_csr( l_order_num_tbl(i).order_NUMBER,

Line 2778: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

2774: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
2775: AND resale_batch_id = p_resale_batch_id;
2776: EXCEPTION
2777: WHEN OTHERS THEN
2778: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
2779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2780: END;
2781: END IF;
2782: -- Debug Message

Line 2784: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

2780: END;
2781: END IF;
2782: -- Debug Message
2783: IF OZF_DEBUG_HIGH_ON THEN
2784: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2785: END IF;
2786:
2787: --Standard call to get message count and if count=1, get the message
2788: FND_MSG_PUB.Count_And_Get (

Line 3038: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');

3034: END IF;
3035:
3036: -- Debug Message
3037: IF OZF_DEBUG_HIGH_ON THEN
3038: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');
3039: END IF;
3040:
3041: -- Initialize API return status to sucess
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3057: ozf_utility_pvt.error_message('OZF_PRE_PROCESS_ERR');

3053: ,x_msg_data => l_msg_data
3054: ,x_msg_count => l_msg_count
3055: );
3056: IF l_return_status <> FND_API.g_ret_sts_SUCCESS THEN
3057: ozf_utility_pvt.error_message('OZF_PRE_PROCESS_ERR');
3058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3059: END IF;
3060:
3061: -- [BUG 4233341 FIXING]: add output file

Line 3119: ozf_utility_pvt.error_message('OZF_MV_ID_CUST_ORDER_ERR');

3115: ,x_msg_data => l_msg_data
3116: ,x_msg_count => l_msg_count
3117: );
3118: IF l_return_status <> FND_API.g_ret_sts_SUCCESS THEN
3119: ozf_utility_pvt.error_message('OZF_MV_ID_CUST_ORDER_ERR');
3120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3121: END IF;
3122:
3123: -- Get profile value for price list

Line 3146: ozf_utility_PVT.debug_message('Event:' ||l_control_rec.pricing_event );

3142: END IF;
3143: END IF;
3144:
3145: IF OZF_DEBUG_LOW_ON THEN
3146: ozf_utility_PVT.debug_message('Event:' ||l_control_rec.pricing_event );
3147: END IF;
3148:
3149: l_control_rec.calculate_flag := 'Y';
3150: l_control_rec.simulation_flag := 'Y';

Line 3192: ozf_utility_PVT.debug_message('Price flag:' ||l_price_flag );

3188: l_price_flag := 'Y';
3189: END IF;
3190:
3191: IF OZF_DEBUG_LOW_ON THEN
3192: ozf_utility_PVT.debug_message('Price flag:' ||l_price_flag );
3193: ozf_utility_PVT.debug_message('List Price Override Flag:' ||l_list_price_override_flag);
3194: END IF;
3195:
3196: FOR i IN 1..l_order_num_tbl.LAST LOOP

Line 3193: ozf_utility_PVT.debug_message('List Price Override Flag:' ||l_list_price_override_flag);

3189: END IF;
3190:
3191: IF OZF_DEBUG_LOW_ON THEN
3192: ozf_utility_PVT.debug_message('Price flag:' ||l_price_flag );
3193: ozf_utility_PVT.debug_message('List Price Override Flag:' ||l_list_price_override_flag);
3194: END IF;
3195:
3196: FOR i IN 1..l_order_num_tbl.LAST LOOP
3197: IF l_order_num_tbl(i).order_number IS NOT NULL AND

Line 3214: ozf_utility_PVT.debug_message(l_api_name||'>> order_number = '||l_order_num_tbl(i).order_number||' (+)');

3210:
3211: QP_Price_Request_Context.Set_Request_Id;
3212:
3213: IF OZF_DEBUG_LOW_ON THEN
3214: ozf_utility_PVT.debug_message(l_api_name||'>> order_number = '||l_order_num_tbl(i).order_number||' (+)');
3215: ozf_utility_PVT.debug_message(l_api_name||'>> bill_to_cust_account_id = '||l_order_num_tbl(i).bill_to_cust_account_id);
3216: END IF;
3217:
3218: --k:=1;

Line 3215: ozf_utility_PVT.debug_message(l_api_name||'>> bill_to_cust_account_id = '||l_order_num_tbl(i).bill_to_cust_account_id);

3211: QP_Price_Request_Context.Set_Request_Id;
3212:
3213: IF OZF_DEBUG_LOW_ON THEN
3214: ozf_utility_PVT.debug_message(l_api_name||'>> order_number = '||l_order_num_tbl(i).order_number||' (+)');
3215: ozf_utility_PVT.debug_message(l_api_name||'>> bill_to_cust_account_id = '||l_order_num_tbl(i).bill_to_cust_account_id);
3216: END IF;
3217:
3218: --k:=1;
3219: OPEN order_set_csr( l_order_num_tbl(i).order_number

Line 3250: ozf_utility_PVT.debug_message(l_api_name||'>> order count = '||l_order_set_tbl.COUNT);

3246: CLOSE order_set_csr;
3247: */
3248:
3249: IF OZF_DEBUG_LOW_ON THEN
3250: ozf_utility_PVT.debug_message(l_api_name||'>> order count = '||l_order_set_tbl.COUNT);
3251: END IF;
3252:
3253: FOR j IN l_order_set_tbl.FIRST .. l_order_set_tbl.LAST
3254: LOOP

Line 3262: ozf_utility_pvt.error_message('OZF_DEL_RESALE_LOG_WRG');

3258: WHERE resale_id = l_order_set_tbl(j).resale_line_int_id
3259: AND resale_id_type = 'IFACE';
3260: EXCEPTION
3261: WHEN OTHERS THEN
3262: ozf_utility_pvt.error_message('OZF_DEL_RESALE_LOG_WRG');
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: END;
3265:
3266: IF OZF_DEBUG_LOW_ON THEN

Line 3267: ozf_utility_PVT.debug_message(l_api_name||'>> building order line for inteface id: '||l_order_set_tbl(j).resale_line_int_id);

3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: END;
3265:
3266: IF OZF_DEBUG_LOW_ON THEN
3267: ozf_utility_PVT.debug_message(l_api_name||'>> building order line for inteface id: '||l_order_set_tbl(j).resale_line_int_id);
3268: END IF;
3269:
3270: -- INSERT INTO l_line_tbl
3271: l_line_tbl(j).line_index := j;

Line 3409: ozf_utility_PVT.debug_message(l_api_name||'>> building order header');

3405: END LOOP; ---FOR i IN l_order_set_tbl.FIRST .. l_order_set_tbl.LAST
3406:
3407:
3408: IF OZF_DEBUG_LOW_ON THEN
3409: ozf_utility_PVT.debug_message(l_api_name||'>> building order header');
3410: END IF;
3411:
3412: -- build summary line
3413: k := l_order_set_tbl.LAST + 1;

Line 3475: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');

3471: OZF_ORDER_PRICE_PVT.G_HEADER_REC.request_date := l_order_set_tbl(1).date_ordered;
3472: OZF_ORDER_PRICE_PVT.G_HEADER_REC.pricing_date := l_order_set_tbl(1).date_ordered;
3473:
3474: IF OZF_DEBUG_LOW_ON THEN
3475: ozf_utility_PVT.debug_message(l_api_name||'>> Calling Get_Order_');
3476: END IF;
3477:
3478: OZF_ORDER_PRICE_PVT.Get_Order_Price (
3479: p_api_version => 1.0

Line 3492: ozf_utility_pvt.error_message('OZF_GET_ORDER_PRIC_ERR');

3488: ,x_ldets_tbl => l_ldets_tbl
3489: ,x_related_lines_tbl => l_related_lines_tbl
3490: );
3491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3492: ozf_utility_pvt.error_message('OZF_GET_ORDER_PRIC_ERR');
3493:
3494: BEGIN
3495: UPDATE ozf_resale_lines_int
3496: SET status_code = 'DISPUTED'

Line 3504: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

3500: AND date_ordered = l_order_num_tbl(i).date_ordered
3501: AND resale_batch_id = p_resale_batch_id;
3502: EXCEPTION
3503: WHEN OTHERS THEN
3504: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3506: END;
3507:
3508: FOR p in 1..l_order_set_tbl.LAST

Line 3533: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');

3529: px_org_id => l_org_id
3530: );
3531: EXCEPTION
3532: WHEN OTHERS THEN
3533: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');
3534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3535: END;
3536: END LOOP;
3537:

Line 3539: ozf_utility_PVT.debug_message(l_api_name||'>> Get_Order_Price Failed!');

3535: END;
3536: END LOOP;
3537:
3538: IF OZF_DEBUG_LOW_ON THEN
3539: ozf_utility_PVT.debug_message(l_api_name||'>> Get_Order_Price Failed!');
3540: END IF;
3541:
3542: GOTO END_LOOP;
3543: END IF;

Line 3589: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');

3585: px_org_id => l_org_id
3586: );
3587: EXCEPTION
3588: WHEN OTHERS THEN
3589: ozf_utility_pvt.error_message('OZF_INS_RESALE_LOG_WRG');
3590: END;
3591: END LOOP;
3592:
3593: BEGIN

Line 3603: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

3599: AND date_ordered = l_order_num_tbl(i).date_ordered
3600: AND resale_batch_id = p_resale_batch_id;
3601: EXCEPTION
3602: WHEN OTHERS THEN
3603: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
3604: END;
3605:
3606: GOTO END_LOOP;
3607: END IF;

Line 3630: ozf_utility_PVT.debug_message(l_api_name||'>>- Success and Committed: Processing order for order number:'||l_order_num_tbl(i).order_number||'(-)');

3626:
3627:
3628:
3629: IF OZF_DEBUG_LOW_ON THEN
3630: ozf_utility_PVT.debug_message(l_api_name||'>>- Success and Committed: Processing order for order number:'||l_order_num_tbl(i).order_number||'(-)');
3631: ozf_utility_PVT.debug_message(l_api_name||'>>- and customer:'||l_order_num_tbl(i).bill_to_cust_account_id||'(-)');
3632: END IF;
3633:
3634: -- commit the data created by processing these G_BULK_LIMIT (default 500) lines

Line 3631: ozf_utility_PVT.debug_message(l_api_name||'>>- and customer:'||l_order_num_tbl(i).bill_to_cust_account_id||'(-)');

3627:
3628:
3629: IF OZF_DEBUG_LOW_ON THEN
3630: ozf_utility_PVT.debug_message(l_api_name||'>>- Success and Committed: Processing order for order number:'||l_order_num_tbl(i).order_number||'(-)');
3631: ozf_utility_PVT.debug_message(l_api_name||'>>- and customer:'||l_order_num_tbl(i).bill_to_cust_account_id||'(-)');
3632: END IF;
3633:
3634: -- commit the data created by processing these G_BULK_LIMIT (default 500) lines
3635: IF G_ALLOW_INTER_COMMIT = 'Y' THEN

Line 3651: ozf_utility_PVT.debug_message(l_api_name||'>> No Order to process <<');

3647:
3648: ELSE -- IF l_order_num_tbl.EXISTS(1) THEN
3649:
3650: IF OZF_DEBUG_LOW_ON THEN
3651: ozf_utility_PVT.debug_message(l_api_name||'>> No Order to process <<');
3652: END IF;
3653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' There is no valid order to process.');
3654:
3655: END IF; -- IF l_order_num_tbl.EXISTS(1) THEN

Line 3735: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');

3731:
3732:
3733: -- Debug Message
3734: IF OZF_DEBUG_HIGH_ON THEN
3735: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
3736: END IF;
3737: --Standard call to get message count and if count=1, get the message
3738: FND_MSG_PUB.Count_And_Get (
3739: p_encoded => FND_API.G_FALSE,

Line 3934: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

3930: END IF;
3931:
3932: -- Debug Message
3933: IF OZF_DEBUG_HIGH_ON THEN
3934: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
3935: END IF;
3936:
3937: -- Initialize API return status to sucess
3938: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3942: ozf_utility_pvt.error_message('OZF_RESALE_TP_SOURCE_NULL');

3938: x_return_status := FND_API.G_RET_STS_SUCCESS;
3939:
3940: /*
3941: IF p_data_source_code is NULL THEN
3942: ozf_utility_pvt.error_message('OZF_RESALE_TP_SOURCE_NULL');
3943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3944: END IF;
3945: */
3946:

Line 3953: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );

3949: p_data_source_code = 'ALL' THEN
3950:
3951: IF p_data_source_code is null THEN
3952: IF OZF_DEBUG_LOW_ON THEN
3953: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );
3954: END IF;
3955: ELSE
3956: IF OZF_DEBUG_LOW_ON THEN
3957: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );

Line 3957: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );

3953: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );
3954: END IF;
3955: ELSE
3956: IF OZF_DEBUG_LOW_ON THEN
3957: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
3958: END IF;
3959: END IF;
3960: UPDATE ozf_resale_lines_int_all
3961: SET request_id = G_CONC_REQUEST_ID

Line 3972: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );

3968: AND org_id = MO_GLOBAL.get_current_org_id();
3969:
3970: ELSE
3971: IF OZF_DEBUG_LOW_ON THEN
3972: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
3973: END IF;
3974: UPDATE ozf_resale_lines_int_all
3975: SET request_id = G_CONC_REQUEST_ID
3976: , dispute_code = null

Line 4155: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

4151: END IF; -- END if l_batch_tbl.EXISTS
4152:
4153: -- Debug Message
4154: IF OZF_DEBUG_HIGH_ON THEN
4155: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
4156: END IF;
4157: --Standard call to get message count and if count=1, get the message
4158: FND_MSG_PUB.Count_And_Get (
4159: p_encoded => FND_API.G_FALSE,

Line 4234: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

4230:
4231:
4232: -- Debug Message
4233: IF OZF_DEBUG_HIGH_ON THEN
4234: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
4235: END IF;
4236:
4237: Process_TP_ACCRUAL (
4238: p_api_version => 1.0

Line 4248: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

4244: ,x_msg_data => l_msg_data
4245: ,x_msg_count => l_msg_count
4246: );
4247: IF l_return_status = FND_API.g_ret_sts_error THEN
4248: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
4249: RAISE FND_API.G_EXC_ERROR;
4250: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4251: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
4252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4251: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

4247: IF l_return_status = FND_API.g_ret_sts_error THEN
4248: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
4249: RAISE FND_API.G_EXC_ERROR;
4250: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4251: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
4252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4253: END IF;
4254:
4255: -- Debug Message

Line 4257: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

4253: END IF;
4254:
4255: -- Debug Message
4256: IF OZF_DEBUG_HIGH_ON THEN
4257: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
4258: END IF;
4259:
4260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 4265: OZF_UTILITY_PVT.Write_Conc_Log;

4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4263:
4264: -- Write all messages to a log
4265: OZF_UTILITY_PVT.Write_Conc_Log;
4266: EXCEPTION
4267: WHEN FND_API.g_exc_error THEN
4268: OZF_UTILITY_PVT.Write_Conc_Log;
4269: ERRBUF := l_msg_data;

Line 4268: OZF_UTILITY_PVT.Write_Conc_Log;

4264: -- Write all messages to a log
4265: OZF_UTILITY_PVT.Write_Conc_Log;
4266: EXCEPTION
4267: WHEN FND_API.g_exc_error THEN
4268: OZF_UTILITY_PVT.Write_Conc_Log;
4269: ERRBUF := l_msg_data;
4270:
4271: WHEN FND_API.g_exc_unexpected_error THEN
4272: OZF_UTILITY_PVT.Write_Conc_Log;

Line 4272: OZF_UTILITY_PVT.Write_Conc_Log;

4268: OZF_UTILITY_PVT.Write_Conc_Log;
4269: ERRBUF := l_msg_data;
4270:
4271: WHEN FND_API.g_exc_unexpected_error THEN
4272: OZF_UTILITY_PVT.Write_Conc_Log;
4273: ERRBUF := l_msg_data;
4274: RETCODE := 2;
4275:
4276: WHEN OTHERS THEN

Line 4278: OZF_UTILITY_PVT.Write_Conc_Log;

4274: RETCODE := 2;
4275:
4276: WHEN OTHERS THEN
4277: ROLLBACK TO START_TP_ACCRUAL;
4278: OZF_UTILITY_PVT.Write_Conc_Log;
4279: ERRBUF := l_msg_data;
4280: RETCODE := 2;
4281: END Start_TP_ACCRUAL;
4282: