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 271: ozf_utility_pvt.write_conc_log('========================= Insert Volume =========================');

267: l_rate NUMBER;
268: BEGIN
269: SAVEPOINT create_volume;
270: x_return_status := Fnd_Api.g_ret_sts_success;
271: ozf_utility_pvt.write_conc_log('========================= Insert Volume =========================');
272: ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);
273:
274: IF p_offer_id IS NOT NULL THEN
275: OPEN c_line_processed(p_offer_id, p_volume_detail_rec.source_code, p_volume_detail_rec.line_id);

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

268: BEGIN
269: SAVEPOINT create_volume;
270: x_return_status := Fnd_Api.g_ret_sts_success;
271: ozf_utility_pvt.write_conc_log('========================= Insert Volume =========================');
272: ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);
273:
274: IF p_offer_id IS NOT NULL THEN
275: OPEN c_line_processed(p_offer_id, p_volume_detail_rec.source_code, p_volume_detail_rec.line_id);
276: FETCH c_line_processed INTO l_line_processed;

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

274: IF p_offer_id IS NOT NULL THEN
275: OPEN c_line_processed(p_offer_id, p_volume_detail_rec.source_code, p_volume_detail_rec.line_id);
276: FETCH c_line_processed INTO l_line_processed;
277: CLOSE c_line_processed;
278: ozf_utility_pvt.write_conc_log('line processed ' || l_line_processed);
279: IF l_line_processed = 'N' THEN
280: IF p_volume_detail_rec.source_code = 'OM' THEN
281: OPEN c_order_line_type(p_volume_detail_rec.line_id);
282: FETCH c_order_line_type INTO l_order_line_type;

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

332: );
333: END IF;
334: END IF;
335:
336: --ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);
337:
338: --kdass fixed bug 6008340
339: OPEN c_group_prod(p_offer_id, p_volume_detail_rec.line_id, p_indirect_flag);
340: 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 346: ozf_utility_pvt.write_conc_log('split_from_line_id: ' || l_split_from_line_id);

342:
343: IF p_indirect_flag = 'O' THEN
344: 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;
345: IF (l_split_from_line_id IS NOT NULL) THEN
346: ozf_utility_pvt.write_conc_log('split_from_line_id: ' || l_split_from_line_id);
347: OPEN c_group_prod(p_offer_id, l_split_from_line_id, p_indirect_flag);
348: 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;
349: CLOSE c_group_prod;
350: END IF;

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

349: CLOSE c_group_prod;
350: END IF;
351: END IF;
352:
353: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
354: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
355: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);

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

350: END IF;
351: END IF;
352:
353: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
354: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
355: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);

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

351: END IF;
352:
353: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
354: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
355: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);

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

352:
353: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
354: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
355: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);

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

353: ozf_utility_pvt.write_conc_log('group_no: ' || l_group_no);
354: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
355: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);

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

354: ozf_utility_pvt.write_conc_log('volume_track_type ' || l_volume_track_type);
355: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);

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

355: ozf_utility_pvt.write_conc_log('combine_schedule_yn ' || l_combine_schedule_yn);
356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);

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

356: ozf_utility_pvt.write_conc_log('pbh_line_id ' || l_pbh_line_id);
357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);

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

357: ozf_utility_pvt.write_conc_log('volume_type ' || l_volume_type);
358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);
365: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.ship_to_site_use_id ' ||p_volume_detail_rec.ship_to_site_use_id);

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

358: ozf_utility_pvt.write_conc_log('include_volume ' || l_include_volume);
359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);
365: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.ship_to_site_use_id ' ||p_volume_detail_rec.ship_to_site_use_id);
366: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' ||p_use_vol_smry_stg_tbl);

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

359: ozf_utility_pvt.write_conc_log('p_sign ' || p_sign);
360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);
365: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.ship_to_site_use_id ' ||p_volume_detail_rec.ship_to_site_use_id);
366: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' ||p_use_vol_smry_stg_tbl);
367: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' ||p_resale_batch_id);

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

360: ozf_utility_pvt.write_conc_log('quantity ' || p_volume_detail_rec.quantity);
361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);
365: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.ship_to_site_use_id ' ||p_volume_detail_rec.ship_to_site_use_id);
366: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' ||p_use_vol_smry_stg_tbl);
367: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' ||p_resale_batch_id);
368:

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

361: ozf_utility_pvt.write_conc_log('amount ' || p_volume_detail_rec.amount);
362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);
365: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.ship_to_site_use_id ' ||p_volume_detail_rec.ship_to_site_use_id);
366: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' ||p_use_vol_smry_stg_tbl);
367: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' ||p_resale_batch_id);
368:
369:

Line 366: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' ||p_use_vol_smry_stg_tbl);

362: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_from_cust_account_id ' ||p_volume_detail_rec.sold_from_cust_account_id);
363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);
365: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.ship_to_site_use_id ' ||p_volume_detail_rec.ship_to_site_use_id);
366: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' ||p_use_vol_smry_stg_tbl);
367: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' ||p_resale_batch_id);
368:
369:
370: IF l_volume_type = 'PRICING_ATTRIBUTE10' THEN

Line 367: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' ||p_resale_batch_id);

363: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.sold_to_cust_account_id ' ||p_volume_detail_rec.sold_to_cust_account_id);
364: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.bill_to_site_use_id ' ||p_volume_detail_rec.bill_to_site_use_id);
365: ozf_utility_pvt.write_conc_log('p_volume_detail_rec.ship_to_site_use_id ' ||p_volume_detail_rec.ship_to_site_use_id);
366: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' ||p_use_vol_smry_stg_tbl);
367: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' ||p_resale_batch_id);
368:
369:
370: IF l_volume_type = 'PRICING_ATTRIBUTE10' THEN
371: IF p_volume_detail_rec.source_code = 'IS' THEN

Line 387: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

383: OPEN c_get_conversion_type(p_volume_detail_rec.org_id);
384: FETCH c_get_conversion_type INTO l_exchange_rate_type;
385: CLOSE c_get_conversion_type;
386:
387: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
388: ,p_from_currency => p_volume_detail_rec.currency_code
389: ,p_to_currency => l_currency_code
390: ,p_conv_type => l_exchange_rate_type --nirprasa, Added for bug 7030415
391: ,p_conv_date => p_volume_detail_rec.transaction_date

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

393: ,x_to_amount => l_convert_amt
394: ,x_rate => l_rate); --7030415
395:
396: IF l_return_status <> fnd_api.g_ret_sts_success THEN
397: ozf_utility_pvt.write_conc_log('Convert Currency failed');
398: RAISE Fnd_Api.g_exc_unexpected_error;
399: END IF;
400:
401: IF p_volume_detail_rec.source_code = 'OM' THEN

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

410: l_current_volume := p_sign * p_volume_detail_rec.amount; -- for IDSM amount is always positive. need to convert for retrun order
411: END IF;
412: END IF;
413: END IF;
414: ozf_utility_pvt.write_conc_log('l_current_volume ' || l_current_volume);
415: IF l_include_volume = 'Y' THEN
416: -- process volume detail
417: INSERT INTO ozf_volume_detail
418: (

Line 472: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl is ' || p_use_vol_smry_stg_tbl);

468: ,l_include_volume
469: ,p_volume_detail_rec.source_code
470: );
471:
472: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl is ' || p_use_vol_smry_stg_tbl);
473:
474: IF p_use_vol_smry_stg_tbl ='T' THEN
475: ozf_utility_pvt.write_conc_log(' in p_use_vol_smry_stg_tbl is ' || p_use_vol_smry_stg_tbl);
476: -- process volume summary

Line 475: ozf_utility_pvt.write_conc_log(' in p_use_vol_smry_stg_tbl is ' || p_use_vol_smry_stg_tbl);

471:
472: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl is ' || p_use_vol_smry_stg_tbl);
473:
474: IF p_use_vol_smry_stg_tbl ='T' THEN
475: ozf_utility_pvt.write_conc_log(' in p_use_vol_smry_stg_tbl is ' || p_use_vol_smry_stg_tbl);
476: -- process volume summary
477: -- 1. group's volume
478: IF l_volume_track_type = 'GROUP' THEN
479: IF l_combine_schedule_yn = 'Y' THEN

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

550:
551: -- 2. distributor's volume
552: --IF p_volume_detail_rec.sold_from_cust_account_id IS NOT NULL AND p_volume_detail_rec.sold_from_cust_account_id <> fnd_api.g_miss_num THEN
553: IF p_indirect_flag = 'R' THEN -- indirect sales
554: ozf_utility_pvt.write_conc_log('distributor ' || l_volume_exists);
555: --insert distributor's volume in to volume summary int table
556: INSERT INTO ozf_volume_summary_int
557: (
558: resale_batch_id

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

706: l_volume_exists := 'N';
707: OPEN c_group_volume_exists(p_offer_id, l_group_no, l_pbh_line_id);
708: FETCH c_group_volume_exists INTO l_volume_exists;
709: CLOSE c_group_volume_exists;
710: ozf_utility_pvt.write_conc_log('group ' || l_volume_exists);
711: IF l_volume_exists = 'Y' THEN -- update group's volume
712: IF l_combine_schedule_yn = 'Y' THEN -- update all pbh lines
713: UPDATE ozf_volume_summary
714: SET group_volume = group_volume + l_current_volume,

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

804: OPEN c_ind_vol_woindvid_exists(p_offer_id, 'DISTRIBUTOR', p_volume_detail_rec.sold_from_cust_account_id, l_pbh_line_id);
805: FETCH c_ind_vol_woindvid_exists INTO l_volume_exists;
806: CLOSE c_ind_vol_woindvid_exists;
807: END IF;
808: ozf_utility_pvt.write_conc_log('distributor ' || l_volume_exists);
809: IF l_volume_exists = 'Y' THEN -- update distributor's volume
810: UPDATE ozf_volume_summary
811: SET individual_volume = individual_volume + l_current_volume,
812: last_update_date = SYSDATE,

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

861: FETCH c_ind_vol_woindvid_exists INTO l_volume_exists;
862: CLOSE c_ind_vol_woindvid_exists;
863:
864: END IF;
865: ozf_utility_pvt.write_conc_log('account ' || l_volume_exists);
866: IF l_volume_exists = 'Y' THEN -- update customer's volume
867: UPDATE ozf_volume_summary
868: SET individual_volume = individual_volume + l_current_volume,
869: last_update_date = SYSDATE,

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

916: OPEN c_ind_vol_woindvid_exists(p_offer_id, 'BILL_TO', p_volume_detail_rec.bill_to_site_use_id, l_pbh_line_id);
917: FETCH c_ind_vol_woindvid_exists INTO l_volume_exists;
918: CLOSE c_ind_vol_woindvid_exists;
919: END IF;
920: ozf_utility_pvt.write_conc_log('bill_to ' || l_volume_exists);
921: IF l_volume_exists = 'Y' THEN -- update bill_to's volume
922: UPDATE ozf_volume_summary
923: SET individual_volume = individual_volume + l_current_volume,
924: last_update_date = SYSDATE,

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

971: OPEN c_ind_vol_woindvid_exists(p_offer_id, 'SHIP_TO', p_volume_detail_rec.ship_to_site_use_id, l_pbh_line_id);
972: FETCH c_ind_vol_woindvid_exists INTO l_volume_exists;
973: CLOSE c_ind_vol_woindvid_exists;
974: END IF;
975: ozf_utility_pvt.write_conc_log('ship to ' || l_volume_exists);
976: IF l_volume_exists = 'Y' THEN -- update ship_to's volume
977: UPDATE ozf_volume_summary
978: SET individual_volume = individual_volume + l_current_volume,
979: last_update_date = SYSDATE,

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

1106:
1107: BEGIN
1108: SAVEPOINT create_volume;
1109: x_return_status := Fnd_Api.g_ret_sts_success;
1110: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
1111: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
1112: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);

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

1107: BEGIN
1108: SAVEPOINT create_volume;
1109: x_return_status := Fnd_Api.g_ret_sts_success;
1110: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
1111: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
1112: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);

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

1108: SAVEPOINT create_volume;
1109: x_return_status := Fnd_Api.g_ret_sts_success;
1110: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
1111: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
1112: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);

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

1109: x_return_status := Fnd_Api.g_ret_sts_success;
1110: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
1111: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
1112: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);

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

1110: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
1111: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
1112: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);

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

1111: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
1112: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
1119: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);

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

1112: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
1119: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
1120: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);

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

1113: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);
1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
1119: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
1120: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1121: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' || p_resale_batch_id);

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

1114: ozf_utility_pvt.write_conc_log('sold_from_cust_account_id ' || p_volume_detail_rec.sold_from_cust_account_id);
1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
1119: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
1120: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1121: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' || p_resale_batch_id);
1122:

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

1115: ozf_utility_pvt.write_conc_log('sold_to_cust_account_id ' || p_volume_detail_rec.sold_to_cust_account_id);
1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
1119: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
1120: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1121: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' || p_resale_batch_id);
1122:
1123: l_volume_detail_rec := p_volume_detail_rec ; -- Catch Weight ER assigning the input rec to a local variable of same type to change the quantity value before passing to insert_volume

Line 1120: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);

1116: ozf_utility_pvt.write_conc_log('bill_to_site_use_id ' || p_volume_detail_rec.bill_to_site_use_id);
1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
1119: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
1120: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1121: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' || p_resale_batch_id);
1122:
1123: l_volume_detail_rec := p_volume_detail_rec ; -- Catch Weight ER assigning the input rec to a local variable of same type to change the quantity value before passing to insert_volume
1124:

Line 1121: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' || p_resale_batch_id);

1117: ozf_utility_pvt.write_conc_log('ship_to_site_use_id ' || p_volume_detail_rec.ship_to_site_use_id);
1118: ozf_utility_pvt.write_conc_log('inventory_item_id ' || p_volume_detail_rec.inventory_item_id);
1119: ozf_utility_pvt.write_conc_log('qp_list_header_id ' || p_qp_list_header_id);
1120: ozf_utility_pvt.write_conc_log('p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1121: ozf_utility_pvt.write_conc_log('p_resale_batch_id ' || p_resale_batch_id);
1122:
1123: l_volume_detail_rec := p_volume_detail_rec ; -- Catch Weight ER assigning the input rec to a local variable of same type to change the quantity value before passing to insert_volume
1124:
1125: IF p_volume_detail_rec.source_code = 'OM' THEN

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

1133: END IF;
1134:
1135: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN
1136: FOR l_offer_id_om IN c_offer_id_om(p_volume_detail_rec.line_id, l_object_type) loop
1137: ozf_utility_pvt.write_conc_log('OM offer_id 1: ' || l_offer_id_om.offer_id);
1138:
1139: -- Catch Weight - start
1140: OPEN c_offer_uom_code(l_offer_id_om.offer_id);
1141: FETCH c_offer_uom_code INTO l_offer_uom_code;

Line 1144: ozf_utility_pvt.write_conc_log('offer uom code ='|| l_offer_uom_code);

1140: OPEN c_offer_uom_code(l_offer_id_om.offer_id);
1141: FETCH c_offer_uom_code INTO l_offer_uom_code;
1142: CLOSE c_offer_uom_code;
1143:
1144: ozf_utility_pvt.write_conc_log('offer uom code ='|| l_offer_uom_code);
1145: ozf_utility_pvt.write_conc_log('order uom code ='|| p_volume_detail_rec.uom_code);
1146:
1147: IF l_offer_uom_code <> p_volume_detail_rec.uom_code THEN
1148:

Line 1145: ozf_utility_pvt.write_conc_log('order uom code ='|| p_volume_detail_rec.uom_code);

1141: FETCH c_offer_uom_code INTO l_offer_uom_code;
1142: CLOSE c_offer_uom_code;
1143:
1144: ozf_utility_pvt.write_conc_log('offer uom code ='|| l_offer_uom_code);
1145: ozf_utility_pvt.write_conc_log('order uom code ='|| p_volume_detail_rec.uom_code);
1146:
1147: IF l_offer_uom_code <> p_volume_detail_rec.uom_code THEN
1148:
1149: l_volume_detail_rec.quantity := inv_convert.inv_um_convert(p_volume_detail_rec.inventory_item_id -- item_id

Line 1158: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');

1154: ,NULL -- from_name
1155: ,NULL -- to_name
1156: );
1157: IF (l_volume_detail_rec.quantity = -99999) THEN
1158: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');
1159: END IF;
1160:
1161: ELSE
1162: l_volume_detail_rec.quantity := p_volume_detail_rec.quantity;

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

1183: OPEN c_offer_id;
1184: FETCH c_offer_id INTO l_offer_id, l_qp_list_header_id;
1185: CLOSE c_offer_id;
1186:
1187: ozf_utility_pvt.write_conc_log('OM offer_id 2: ' || l_offer_id);
1188:
1189: -- Catch Weight ER - start
1190: OPEN c_offer_uom_code(l_offer_id);
1191: FETCH c_offer_uom_code INTO l_offer_uom_code;

Line 1204: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');

1200: ,NULL -- from_name
1201: ,NULL -- to_name
1202: );
1203: IF (l_volume_detail_rec.quantity = -99999) THEN
1204: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');
1205: END IF;
1206: ELSE
1207: l_volume_detail_rec.quantity := p_volume_detail_rec.quantity;
1208: END IF;

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

1236:
1237: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN
1238: FOR l_offer_id_is IN c_offer_id_is(p_volume_detail_rec.line_id, l_object_type) LOOP
1239:
1240: ozf_utility_pvt.write_conc_log('IS offer_id 1: ' || l_offer_id_is.offer_id);
1241: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1242: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);
1243:
1244: -- Catch Weight - start

Line 1241: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);

1237: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN
1238: FOR l_offer_id_is IN c_offer_id_is(p_volume_detail_rec.line_id, l_object_type) LOOP
1239:
1240: ozf_utility_pvt.write_conc_log('IS offer_id 1: ' || l_offer_id_is.offer_id);
1241: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1242: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);
1243:
1244: -- Catch Weight - start
1245: OPEN c_offer_uom_code(l_offer_id_is.offer_id);

Line 1242: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);

1238: FOR l_offer_id_is IN c_offer_id_is(p_volume_detail_rec.line_id, l_object_type) LOOP
1239:
1240: ozf_utility_pvt.write_conc_log('IS offer_id 1: ' || l_offer_id_is.offer_id);
1241: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1242: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);
1243:
1244: -- Catch Weight - start
1245: OPEN c_offer_uom_code(l_offer_id_is.offer_id);
1246: FETCH c_offer_uom_code INTO l_offer_uom_code;

Line 1249: ozf_utility_pvt.write_conc_log('offer uom code ='|| l_offer_uom_code);

1245: OPEN c_offer_uom_code(l_offer_id_is.offer_id);
1246: FETCH c_offer_uom_code INTO l_offer_uom_code;
1247: CLOSE c_offer_uom_code;
1248:
1249: ozf_utility_pvt.write_conc_log('offer uom code ='|| l_offer_uom_code);
1250: ozf_utility_pvt.write_conc_log('order uom code ='|| p_volume_detail_rec.uom_code);
1251:
1252: IF l_offer_uom_code <> p_volume_detail_rec.uom_code THEN
1253:

Line 1250: ozf_utility_pvt.write_conc_log('order uom code ='|| p_volume_detail_rec.uom_code);

1246: FETCH c_offer_uom_code INTO l_offer_uom_code;
1247: CLOSE c_offer_uom_code;
1248:
1249: ozf_utility_pvt.write_conc_log('offer uom code ='|| l_offer_uom_code);
1250: ozf_utility_pvt.write_conc_log('order uom code ='|| p_volume_detail_rec.uom_code);
1251:
1252: IF l_offer_uom_code <> p_volume_detail_rec.uom_code THEN
1253:
1254: l_volume_detail_rec.quantity := inv_convert.inv_um_convert(p_volume_detail_rec.inventory_item_id -- item_id

Line 1263: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');

1259: ,NULL -- from_name
1260: ,NULL -- to_name
1261: );
1262: IF (l_volume_detail_rec.quantity = -99999) THEN
1263: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');
1264: END IF;
1265:
1266: ELSE
1267: l_volume_detail_rec.quantity := p_volume_detail_rec.quantity;

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

1287: OPEN c_offer_id;
1288: FETCH c_offer_id INTO l_offer_id, l_qp_list_header_id;
1289: CLOSE c_offer_id;
1290:
1291: ozf_utility_pvt.write_conc_log('IS offer_id 2: ' || l_offer_id);
1292: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1293: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);
1294:
1295: -- Catch Weight ER - start

Line 1292: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);

1288: FETCH c_offer_id INTO l_offer_id, l_qp_list_header_id;
1289: CLOSE c_offer_id;
1290:
1291: ozf_utility_pvt.write_conc_log('IS offer_id 2: ' || l_offer_id);
1292: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1293: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);
1294:
1295: -- Catch Weight ER - start
1296: OPEN c_offer_uom_code(l_offer_id);

Line 1293: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);

1289: CLOSE c_offer_id;
1290:
1291: ozf_utility_pvt.write_conc_log('IS offer_id 2: ' || l_offer_id);
1292: ozf_utility_pvt.write_conc_log('IS p_use_vol_smry_stg_tbl ' || p_use_vol_smry_stg_tbl);
1293: ozf_utility_pvt.write_conc_log('IS p_resale_batch_id ' || p_resale_batch_id);
1294:
1295: -- Catch Weight ER - start
1296: OPEN c_offer_uom_code(l_offer_id);
1297: FETCH c_offer_uom_code INTO l_offer_uom_code;

Line 1310: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');

1306: ,NULL -- from_name
1307: ,NULL -- to_name
1308: );
1309: IF (l_volume_detail_rec.quantity = -99999) THEN
1310: ozf_utility_pvt.write_conc_log ('Error in UOM conversion');
1311: END IF;
1312: ELSE
1313: l_volume_detail_rec.quantity := p_volume_detail_rec.quantity;
1314: END IF;

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

1329: ,p_use_vol_smry_stg_tbl => p_use_vol_smry_stg_tbl
1330: ,p_resale_batch_id => p_resale_batch_id );
1331: END IF;
1332: END IF;
1333: ozf_utility_pvt.write_conc_log('indirect_flag ' || l_indirect_flag);
1334:
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

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

1584: l_volume_offer_type VARCHAR2(30);
1585: l_volume_b4_trx_date NUMBER;
1586: l_volume_of_trx_date NUMBER;
1587: BEGIN
1588: ozf_utility_pvt.write_conc_log('==================== get_as_of_date_volume ====================');
1589:
1590: OPEN c_trx_date_volume_pk;
1591: FETCH c_trx_date_volume_pk INTO l_pk;
1592: CLOSE c_trx_date_volume_pk;

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

1589:
1590: OPEN c_trx_date_volume_pk;
1591: FETCH c_trx_date_volume_pk INTO l_pk;
1592: CLOSE c_trx_date_volume_pk;
1593: ozf_utility_pvt.write_conc_log('PK is ' || l_pk);
1594:
1595: IF p_combine_schedule = 'N' THEN
1596: IF p_volume_track_type = 'GROUP' THEN
1597: OPEN c_group_volume(p_group_no);

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

1691: END IF;
1692:
1693: x_acc_volume := l_volume_b4_trx_date + l_volume_of_trx_date;
1694:
1695: ozf_utility_pvt.write_conc_log('volume b4 trx_date ' || l_volume_b4_trx_date);
1696: ozf_utility_pvt.write_conc_log('volume of trx_date ' || l_volume_of_trx_date);
1697: ozf_utility_pvt.write_conc_log('as_of_date_volume ' || x_acc_volume);
1698:
1699: IF x_acc_volume IS NULL THEN

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

1692:
1693: x_acc_volume := l_volume_b4_trx_date + l_volume_of_trx_date;
1694:
1695: ozf_utility_pvt.write_conc_log('volume b4 trx_date ' || l_volume_b4_trx_date);
1696: ozf_utility_pvt.write_conc_log('volume of trx_date ' || l_volume_of_trx_date);
1697: ozf_utility_pvt.write_conc_log('as_of_date_volume ' || x_acc_volume);
1698:
1699: IF x_acc_volume IS NULL THEN
1700: x_acc_volume := 0;

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

1693: x_acc_volume := l_volume_b4_trx_date + l_volume_of_trx_date;
1694:
1695: ozf_utility_pvt.write_conc_log('volume b4 trx_date ' || l_volume_b4_trx_date);
1696: ozf_utility_pvt.write_conc_log('volume of trx_date ' || l_volume_of_trx_date);
1697: ozf_utility_pvt.write_conc_log('as_of_date_volume ' || x_acc_volume);
1698:
1699: IF x_acc_volume IS NULL THEN
1700: x_acc_volume := 0;
1701: END IF;

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

1868: END IF;
1869:
1870: l_trx_date := p_trx_date;
1871:
1872: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1873: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1874: ozf_utility_pvt.write_conc_log('other values');
1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: 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 1873: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);

1869:
1870: l_trx_date := p_trx_date;
1871:
1872: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1873: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1874: ozf_utility_pvt.write_conc_log('other values');
1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');

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

1870: l_trx_date := p_trx_date;
1871:
1872: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1873: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1874: ozf_utility_pvt.write_conc_log('other values');
1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1878: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);

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

1871:
1872: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1873: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1874: ozf_utility_pvt.write_conc_log('other values');
1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1878: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1879: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');

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

1872: ozf_utility_pvt.write_conc_log('in api ' || l_api_name || ' -- ready to call get_as_of_date_volume');
1873: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1874: ozf_utility_pvt.write_conc_log('other values');
1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1878: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1879: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1880: 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 1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');

1873: ozf_utility_pvt.write_conc_log('apply discount ' || l_apply_discount);
1874: ozf_utility_pvt.write_conc_log('other values');
1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1878: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1879: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1880: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1881:

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

1874: ozf_utility_pvt.write_conc_log('other values');
1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1878: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1879: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1880: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1881:
1882: IF l_apply_discount = 'N' THEN

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

1875: ozf_utility_pvt.write_conc_log('l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to');
1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1878: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1879: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1880: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1881:
1882: IF l_apply_discount = 'N' THEN
1883: x_acc_volume := 0;

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

1876: ozf_utility_pvt.write_conc_log(l_offer_id || '/' || p_qp_list_header_id || '/' || l_cust_account_id || '/' || l_bill_to || '/' || l_ship_to);
1877: ozf_utility_pvt.write_conc_log('l_group_no/l_combine_schedule/l_volume_track_type/l_pbh_line_id');
1878: ozf_utility_pvt.write_conc_log(l_group_no || '/' || l_combine_schedule || '/' || l_volume_track_type || '/' || l_pbh_line_id);
1879: ozf_utility_pvt.write_conc_log('p_source_code/p_order_line_id/l_trx_date');
1880: ozf_utility_pvt.write_conc_log(p_source_code || '/' || p_order_line_id || '/' || to_char(l_trx_date, 'YYYY-MM-DD HH:MI:SS'));
1881:
1882: IF l_apply_discount = 'N' THEN
1883: x_acc_volume := 0;
1884: ELSE

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

1897: ,p_order_line_id => p_order_line_id
1898: ,p_source_code => p_source_code
1899: ,x_acc_volume => l_acc_volume
1900: );
1901: ozf_utility_pvt.write_conc_log('calculated volume: ' || l_acc_volume);
1902: IF l_acc_volume IS NULL THEN
1903: l_acc_volume := 0;
1904: END IF;
1905:

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

1905:
1906: OPEN c_preset_volume(l_offer_id, l_group_no, l_pbh_line_id);
1907: FETCH c_preset_volume INTO l_preset_volume;
1908: CLOSE c_preset_volume;
1909: ozf_utility_pvt.write_conc_log('preset volume: ' || l_preset_volume);
1910: IF l_preset_volume IS NULL THEN
1911: l_preset_volume := 0;
1912: END IF;
1913: