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

Line 240: ozf_utility_pvt.write_conc_log('========================= Insert Volume =========================');

236: l_rate NUMBER;
237: BEGIN
238: SAVEPOINT create_volume;
239: x_return_status := Fnd_Api.g_ret_sts_success;
240: ozf_utility_pvt.write_conc_log('========================= Insert Volume =========================');
241: ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);
242:
243: IF p_offer_id IS NOT NULL THEN
244: OPEN c_line_processed(p_offer_id, p_volume_detail_rec.source_code, p_volume_detail_rec.line_id);

Line 241: ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);

237: BEGIN
238: SAVEPOINT create_volume;
239: x_return_status := Fnd_Api.g_ret_sts_success;
240: ozf_utility_pvt.write_conc_log('========================= Insert Volume =========================');
241: ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);
242:
243: IF p_offer_id IS NOT NULL THEN
244: OPEN c_line_processed(p_offer_id, p_volume_detail_rec.source_code, p_volume_detail_rec.line_id);
245: FETCH c_line_processed INTO l_line_processed;

Line 247: ozf_utility_pvt.write_conc_log('line processed ' || l_line_processed);

243: IF p_offer_id IS NOT NULL THEN
244: OPEN c_line_processed(p_offer_id, p_volume_detail_rec.source_code, p_volume_detail_rec.line_id);
245: FETCH c_line_processed INTO l_line_processed;
246: CLOSE c_line_processed;
247: ozf_utility_pvt.write_conc_log('line processed ' || l_line_processed);
248: IF l_line_processed = 'N' THEN
249: IF p_volume_detail_rec.source_code = 'OM' THEN
250: OPEN c_order_line_type(p_volume_detail_rec.line_id);
251: FETCH c_order_line_type INTO l_order_line_type;

Line 305: --ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);

301: );
302: END IF;
303: END IF;
304:
305: --ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);
306:
307: --kdass fixed bug 6008340
308: OPEN c_group_prod(p_offer_id, p_volume_detail_rec.line_id, p_indirect_flag);
309: FETCH c_group_prod INTO l_group_no, l_volume_track_type, l_combine_schedule_yn, l_pbh_line_id, l_volume_type, l_include_volume;

Line 315: ozf_utility_pvt.write_conc_log('split_from_line_id: ' || l_split_from_line_id);

311:
312: IF p_indirect_flag = 'O' THEN
313: select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_volume_detail_rec.line_id;
314: IF (l_split_from_line_id IS NOT NULL) THEN
315: ozf_utility_pvt.write_conc_log('split_from_line_id: ' || l_split_from_line_id);
316: OPEN c_group_prod(p_offer_id, l_split_from_line_id, p_indirect_flag);
317: FETCH c_group_prod INTO l_group_no, l_volume_track_type, l_combine_schedule_yn, l_pbh_line_id, l_volume_type, l_include_volume;
318: CLOSE c_group_prod;
319: END IF;

Line 322: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);

318: CLOSE c_group_prod;
319: END IF;
320: END IF;
321:
322: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
323: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);

Line 323: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);

319: END IF;
320: END IF;
321:
322: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
323: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);

Line 324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);

320: END IF;
321:
322: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
323: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);

Line 325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);

321:
322: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
323: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
329: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);

Line 326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);

322: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
323: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
329: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
330: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);

Line 327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);

323: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
329: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
330: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
331:

Line 328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);

324: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
329: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
330: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
331:
332: IF l_volume_type = 'PRICING_ATTRIBUTE10' THEN

Line 329: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);

325: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
329: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
330: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
331:
332: IF l_volume_type = 'PRICING_ATTRIBUTE10' THEN
333: IF p_volume_detail_rec.source_code = 'IS' THEN

Line 330: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);

326: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
327: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
328: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
329: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
330: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
331:
332: IF l_volume_type = 'PRICING_ATTRIBUTE10' THEN
333: IF p_volume_detail_rec.source_code = 'IS' THEN
334: l_current_volume := p_volume_detail_rec.quantity;

Line 349: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

345: OPEN c_get_conversion_type(p_volume_detail_rec.org_id);
346: FETCH c_get_conversion_type INTO l_exchange_rate_type;
347: CLOSE c_get_conversion_type;
348:
349: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
350: ,p_from_currency => p_volume_detail_rec.currency_code
351: ,p_to_currency => l_currency_code
352: ,p_conv_type => l_exchange_rate_type --nirprasa, Added for bug 7030415
353: ,p_conv_date => p_volume_detail_rec.transaction_date

Line 359: ozf_utility_pvt.write_conc_log('Convert Currency failed');

355: ,x_to_amount => l_convert_amt
356: ,x_rate => l_rate); --7030415
357:
358: IF l_return_status <> fnd_api.g_ret_sts_success THEN
359: ozf_utility_pvt.write_conc_log('Convert Currency failed');
360: RAISE Fnd_Api.g_exc_unexpected_error;
361: END IF;
362:
363: IF p_volume_detail_rec.source_code = 'OM' THEN

Line 376: ozf_utility_pvt.write_conc_log('l_current_volume ' || l_current_volume);

372: l_current_volume := p_sign * p_volume_detail_rec.amount; -- for IDSM amount is always positive. need to convert for retrun order
373: END IF;
374: END IF;
375: END IF;
376: ozf_utility_pvt.write_conc_log('l_current_volume ' || l_current_volume);
377: IF l_include_volume = 'Y' THEN
378: -- process volume detail
379: INSERT INTO ozf_volume_detail
380: (

Line 441: ozf_utility_pvt.write_conc_log('group ' || l_volume_exists);

437: l_volume_exists := 'N';
438: OPEN c_group_volume_exists(p_offer_id, l_group_no, l_pbh_line_id);
439: FETCH c_group_volume_exists INTO l_volume_exists;
440: CLOSE c_group_volume_exists;
441: ozf_utility_pvt.write_conc_log('group ' || l_volume_exists);
442: IF l_volume_exists = 'Y' THEN -- update group's volume
443: IF l_combine_schedule_yn = 'Y' THEN -- update all pbh lines
444: UPDATE ozf_volume_summary
445: SET group_volume = group_volume + l_current_volume,

Line 533: ozf_utility_pvt.write_conc_log('distributor ' || l_volume_exists);

529: l_volume_exists := 'N';
530: OPEN c_individual_volume_exists(p_offer_id, 'DISTRIBUTOR', p_volume_detail_rec.sold_from_cust_account_id, l_pbh_line_id);
531: FETCH c_individual_volume_exists INTO l_volume_exists;
532: CLOSE c_individual_volume_exists;
533: ozf_utility_pvt.write_conc_log('distributor ' || l_volume_exists);
534: IF l_volume_exists = 'Y' THEN -- update distributor's volume
535: UPDATE ozf_volume_summary
536: SET individual_volume = individual_volume + l_current_volume,
537: last_update_date = SYSDATE,

Line 583: ozf_utility_pvt.write_conc_log('account ' || l_volume_exists);

579: l_volume_exists := 'N';
580: OPEN c_individual_volume_exists(p_offer_id, 'ACCOUNT', p_volume_detail_rec.sold_to_cust_account_id, l_pbh_line_id);
581: FETCH c_individual_volume_exists INTO l_volume_exists;
582: CLOSE c_individual_volume_exists;
583: ozf_utility_pvt.write_conc_log('account ' || l_volume_exists);
584: IF l_volume_exists = 'Y' THEN -- update customer's volume
585: UPDATE ozf_volume_summary
586: SET individual_volume = individual_volume + l_current_volume,
587: last_update_date = SYSDATE,

Line 632: ozf_utility_pvt.write_conc_log('bill_to ' || l_volume_exists);

628: l_volume_exists := 'N';
629: OPEN c_individual_volume_exists(p_offer_id, 'BILL_TO', p_volume_detail_rec.bill_to_site_use_id, l_pbh_line_id);
630: FETCH c_individual_volume_exists INTO l_volume_exists;
631: CLOSE c_individual_volume_exists;
632: ozf_utility_pvt.write_conc_log('bill_to ' || l_volume_exists);
633: IF l_volume_exists = 'Y' THEN -- update bill_to's volume
634: UPDATE ozf_volume_summary
635: SET individual_volume = individual_volume + l_current_volume,
636: last_update_date = SYSDATE,

Line 681: ozf_utility_pvt.write_conc_log('ship to ' || l_volume_exists);

677: l_volume_exists := 'N';
678: OPEN c_individual_volume_exists(p_offer_id, 'SHIP_TO', p_volume_detail_rec.ship_to_site_use_id, l_pbh_line_id);
679: FETCH c_individual_volume_exists INTO l_volume_exists;
680: CLOSE c_individual_volume_exists;
681: ozf_utility_pvt.write_conc_log('ship to ' || l_volume_exists);
682: IF l_volume_exists = 'Y' THEN -- update ship_to's volume
683: UPDATE ozf_volume_summary
684: SET individual_volume = individual_volume + l_current_volume,
685: last_update_date = SYSDATE,

Line 801: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');

797:
798: BEGIN
799: SAVEPOINT create_volume;
800: x_return_status := Fnd_Api.g_ret_sts_success;
801: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);

Line 802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);

798: BEGIN
799: SAVEPOINT create_volume;
800: x_return_status := Fnd_Api.g_ret_sts_success;
801: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);

Line 803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);

799: SAVEPOINT create_volume;
800: x_return_status := Fnd_Api.g_ret_sts_success;
801: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);

Line 804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);

800: x_return_status := Fnd_Api.g_ret_sts_success;
801: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);

Line 805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);

801: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
809: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);

Line 806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);

802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
809: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
810: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);

Line 807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);

803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
809: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
810: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
811:

Line 808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);

804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
809: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
810: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
811:
812: IF p_volume_detail_rec.source_code = 'OM' THEN

Line 809: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);

805: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
809: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
810: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
811:
812: IF p_volume_detail_rec.source_code = 'OM' THEN
813: l_object_type := 'ORDER';

Line 810: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);

806: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
807: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
808: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
809: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
810: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
811:
812: IF p_volume_detail_rec.source_code = 'OM' THEN
813: l_object_type := 'ORDER';
814: l_indirect_flag := 'O';

Line 824: ozf_utility_pvt.write_conc_log('OM offer_id 1: ' || l_offer_id_om.offer_id);

820: END IF;
821:
822: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN
823: FOR l_offer_id_om IN c_offer_id_om(p_volume_detail_rec.line_id, l_object_type) loop
824: ozf_utility_pvt.write_conc_log('OM offer_id 1: ' || l_offer_id_om.offer_id);
825: insert_volume(
826: p_init_msg_list => p_init_msg_list
827: ,p_api_version => p_api_version
828: ,p_commit => p_commit

Line 843: ozf_utility_pvt.write_conc_log('OM offer_id 2: ' || l_offer_id);

839: OPEN c_offer_id;
840: FETCH c_offer_id INTO l_offer_id, l_qp_list_header_id;
841: CLOSE c_offer_id;
842:
843: ozf_utility_pvt.write_conc_log('OM offer_id 2: ' || l_offer_id);
844: insert_volume(
845: p_init_msg_list => p_init_msg_list
846: ,p_api_version => p_api_version
847: ,p_commit => p_commit

Line 869: ozf_utility_pvt.write_conc_log('IS offer_id 1: ' || l_offer_id_is.offer_id);

865: END IF;
866:
867: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN
868: FOR l_offer_id_is IN c_offer_id_is(p_volume_detail_rec.line_id, l_object_type) LOOP
869: ozf_utility_pvt.write_conc_log('IS offer_id 1: ' || l_offer_id_is.offer_id);
870: insert_volume(
871: p_init_msg_list => p_init_msg_list
872: ,p_api_version => p_api_version
873: ,p_commit => p_commit

Line 888: ozf_utility_pvt.write_conc_log('IS offer_id 2: ' || l_offer_id);

884: OPEN c_offer_id;
885: FETCH c_offer_id INTO l_offer_id, l_qp_list_header_id;
886: CLOSE c_offer_id;
887:
888: ozf_utility_pvt.write_conc_log('IS offer_id 2: ' || l_offer_id);
889: insert_volume(
890: p_init_msg_list => p_init_msg_list
891: ,p_api_version => p_api_version
892: ,p_commit => p_commit

Line 903: ozf_utility_pvt.write_conc_log('indirect_flag ' || l_indirect_flag);

899: ,p_indirect_flag => l_indirect_flag
900: ,p_sign => l_sign);
901: END IF;
902: END IF;
903: ozf_utility_pvt.write_conc_log('indirect_flag ' || l_indirect_flag);
904:
905: EXCEPTION
906: WHEN OTHERS THEN
907: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 1158: ozf_utility_pvt.write_conc_log('==================== get_as_of_date_volume ====================');

1154: l_volume_offer_type VARCHAR2(30);
1155: l_volume_b4_trx_date NUMBER;
1156: l_volume_of_trx_date NUMBER;
1157: BEGIN
1158: ozf_utility_pvt.write_conc_log('==================== get_as_of_date_volume ====================');
1159:
1160: OPEN c_trx_date_volume_pk;
1161: FETCH c_trx_date_volume_pk INTO l_pk;
1162: CLOSE c_trx_date_volume_pk;

Line 1163: ozf_utility_pvt.write_conc_log('PK is ' || l_pk);

1159:
1160: OPEN c_trx_date_volume_pk;
1161: FETCH c_trx_date_volume_pk INTO l_pk;
1162: CLOSE c_trx_date_volume_pk;
1163: ozf_utility_pvt.write_conc_log('PK is ' || l_pk);
1164:
1165: IF p_combine_schedule = 'N' THEN
1166: IF p_volume_track_type = 'GROUP' THEN
1167: OPEN c_group_volume(p_group_no);

Line 1265: ozf_utility_pvt.write_conc_log('volume b4 trx_date ' || l_volume_b4_trx_date);

1261: END IF;
1262:
1263: x_acc_volume := l_volume_b4_trx_date + l_volume_of_trx_date;
1264:
1265: ozf_utility_pvt.write_conc_log('volume b4 trx_date ' || l_volume_b4_trx_date);
1266: ozf_utility_pvt.write_conc_log('volume of trx_date ' || l_volume_of_trx_date);
1267: ozf_utility_pvt.write_conc_log('as_of_date_volume ' || x_acc_volume);
1268:
1269: IF x_acc_volume IS NULL THEN

Line 1266: ozf_utility_pvt.write_conc_log('volume of trx_date ' || l_volume_of_trx_date);

1262:
1263: x_acc_volume := l_volume_b4_trx_date + l_volume_of_trx_date;
1264:
1265: ozf_utility_pvt.write_conc_log('volume b4 trx_date ' || l_volume_b4_trx_date);
1266: ozf_utility_pvt.write_conc_log('volume of trx_date ' || l_volume_of_trx_date);
1267: ozf_utility_pvt.write_conc_log('as_of_date_volume ' || x_acc_volume);
1268:
1269: IF x_acc_volume IS NULL THEN
1270: x_acc_volume := 0;

Line 1267: ozf_utility_pvt.write_conc_log('as_of_date_volume ' || x_acc_volume);

1263: x_acc_volume := l_volume_b4_trx_date + l_volume_of_trx_date;
1264:
1265: ozf_utility_pvt.write_conc_log('volume b4 trx_date ' || l_volume_b4_trx_date);
1266: ozf_utility_pvt.write_conc_log('volume of trx_date ' || l_volume_of_trx_date);
1267: ozf_utility_pvt.write_conc_log('as_of_date_volume ' || x_acc_volume);
1268:
1269: IF x_acc_volume IS NULL THEN
1270: x_acc_volume := 0;
1271: END IF;

Line 1442: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');

1438: END IF;
1439:
1440: l_trx_date := p_trx_date;
1441:
1442: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1443: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1444: ozf_utility_pvt.write_conc_log('other values');
1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);

Line 1443: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);

1439:
1440: l_trx_date := p_trx_date;
1441:
1442: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1443: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1444: ozf_utility_pvt.write_conc_log('other values');
1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');

Line 1444: ozf_utility_pvt.write_conc_log('other values');

1440: l_trx_date := p_trx_date;
1441:
1442: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1443: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1444: ozf_utility_pvt.write_conc_log('other values');
1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);

Line 1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');

1441:
1442: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1443: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1444: ozf_utility_pvt.write_conc_log('other values');
1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1449: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');

Line 1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);

1442: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1443: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1444: ozf_utility_pvt.write_conc_log('other values');
1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1449: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1450: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));

Line 1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');

1443: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1444: ozf_utility_pvt.write_conc_log('other values');
1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1449: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1450: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1451:

Line 1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);

1444: ozf_utility_pvt.write_conc_log('other values');
1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1449: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1450: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1451:
1452: IF l_apply_discount = 'N' THEN

Line 1449: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');

1445: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1449: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1450: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1451:
1452: IF l_apply_discount = 'N' THEN
1453: x_acc_volume := 0;

Line 1450: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));

1446: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1447: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1448: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1449: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1450: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1451:
1452: IF l_apply_discount = 'N' THEN
1453: x_acc_volume := 0;
1454: ELSE

Line 1471: ozf_utility_pvt.write_conc_log('calculated volume: ' || l_acc_volume);

1467: ,p_order_line_id => p_order_line_id
1468: ,p_source_code => p_source_code
1469: ,x_acc_volume => l_acc_volume
1470: );
1471: ozf_utility_pvt.write_conc_log('calculated volume: ' || l_acc_volume);
1472: IF l_acc_volume IS NULL THEN
1473: l_acc_volume := 0;
1474: END IF;
1475:

Line 1479: ozf_utility_pvt.write_conc_log('preset volume: ' || l_preset_volume);

1475:
1476: OPEN c_preset_volume(l_offer_id, l_group_no, l_pbh_line_id);
1477: FETCH c_preset_volume INTO l_preset_volume;
1478: CLOSE c_preset_volume;
1479: ozf_utility_pvt.write_conc_log('preset volume: ' || l_preset_volume);
1480: IF l_preset_volume IS NULL THEN
1481: l_preset_volume := 0;
1482: END IF;
1483: