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.POA_SAVINGS_SAV dependencies on POA_LOG

Line 39: POA_LOG.debug_line('Get_lowest_possible_price: entered');

35:
36: v_buf VARCHAR2(240) := NULL;
37: BEGIN
38:
39: POA_LOG.debug_line('Get_lowest_possible_price: entered');
40:
41: v_ncum_lowest_price := get_lowest_ncum_price(p_creation_date,
42: p_quantity,
43: p_unit_meas_lookup_code,

Line 143: POA_LOG.debug_line(' v_ncum_lowest_price: ' || v_ncum_lowest_price);

139: end if;
140: /*
141: IF (v_ncum_lowest_price < v_cum_lowest_price) THEN
142: v_lowest_price := v_ncum_lowest_price;
143: POA_LOG.debug_line(' v_ncum_lowest_price: ' || v_ncum_lowest_price);
144:
145: ELSE
146: v_lowest_price := v_cum_lowest_price;
147: POA_LOG.debug_line(' v_cum_lowest_price: ' || v_ncum_lowest_price);

Line 147: POA_LOG.debug_line(' v_cum_lowest_price: ' || v_ncum_lowest_price);

143: POA_LOG.debug_line(' v_ncum_lowest_price: ' || v_ncum_lowest_price);
144:
145: ELSE
146: v_lowest_price := v_cum_lowest_price;
147: POA_LOG.debug_line(' v_cum_lowest_price: ' || v_ncum_lowest_price);
148: END IF;
149: POA_LOG.debug_line(' v_lowest_price: ' || v_lowest_price);
150: POA_LOG.debug_line(' p_item_id: ' || p_item_id);
151: */

Line 149: POA_LOG.debug_line(' v_lowest_price: ' || v_lowest_price);

145: ELSE
146: v_lowest_price := v_cum_lowest_price;
147: POA_LOG.debug_line(' v_cum_lowest_price: ' || v_ncum_lowest_price);
148: END IF;
149: POA_LOG.debug_line(' v_lowest_price: ' || v_lowest_price);
150: POA_LOG.debug_line(' p_item_id: ' || p_item_id);
151: */
152: IF v_ncum_lowest_price IS NULL AND v_cum_lowest_price IS NOT NULL THEN
153: RETURN v_cum_lowest_price;

Line 150: POA_LOG.debug_line(' p_item_id: ' || p_item_id);

146: v_lowest_price := v_cum_lowest_price;
147: POA_LOG.debug_line(' v_cum_lowest_price: ' || v_ncum_lowest_price);
148: END IF;
149: POA_LOG.debug_line(' v_lowest_price: ' || v_lowest_price);
150: POA_LOG.debug_line(' p_item_id: ' || p_item_id);
151: */
152: IF v_ncum_lowest_price IS NULL AND v_cum_lowest_price IS NOT NULL THEN
153: RETURN v_cum_lowest_price;
154: ELSIF v_ncum_lowest_price IS NOT NULL AND v_cum_lowest_price IS NULL THEN

Line 166: POA_LOG.put_line(v_buf);

162: WHEN others THEN
163: v_buf := 'Lowest possible price function: internal error';
164: ROLLBACK;
165:
166: POA_LOG.put_line(v_buf);
167: POA_LOG.put_line(' ');
168:
169: RAISE;
170: END get_lowest_possible_price;

Line 167: POA_LOG.put_line(' ');

163: v_buf := 'Lowest possible price function: internal error';
164: ROLLBACK;
165:
166: POA_LOG.put_line(v_buf);
167: POA_LOG.put_line(' ');
168:
169: RAISE;
170: END get_lowest_possible_price;
171:

Line 278: POA_LOG.debug_line('Get_lowest_ncum_price: entered');

274: );
275:
276: BEGIN
277:
278: POA_LOG.debug_line('Get_lowest_ncum_price: entered');
279: x_progress := '001';
280:
281: -- Get all blanket agreements matching ship_to_location that
282: -- we could have released this item on.

Line 360: POA_LOG.put_line(v_buf);

356: EXCEPTION
357: WHEN others THEN
358: v_buf := 'Get lowest cumulative price: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
359: ROLLBACK;
360: POA_LOG.put_line(v_buf);
361: POA_LOG.put_line(' ');
362:
363: RAISE;
364: END get_lowest_ncum_price;

Line 361: POA_LOG.put_line(' ');

357: WHEN others THEN
358: v_buf := 'Get lowest cumulative price: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
359: ROLLBACK;
360: POA_LOG.put_line(v_buf);
361: POA_LOG.put_line(' ');
362:
363: RAISE;
364: END get_lowest_ncum_price;
365:

Line 477: -- POA_LOG.debug_line(' fetched v_cursor_blk row no. ' || x_iteration_outer);

473: end if;
474: end if;
475:
476: LOOP
477: -- POA_LOG.debug_line(' fetched v_cursor_blk row no. ' || x_iteration_outer);
478: -- POA_LOG.debug_line(' v_blanket_id: ' || v_blanket_id);
479:
480: -- Get the po_line_id from the blanket agreement that
481: -- matches the item.

Line 478: -- POA_LOG.debug_line(' v_blanket_id: ' || v_blanket_id);

474: end if;
475:
476: LOOP
477: -- POA_LOG.debug_line(' fetched v_cursor_blk row no. ' || x_iteration_outer);
478: -- POA_LOG.debug_line(' v_blanket_id: ' || v_blanket_id);
479:
480: -- Get the po_line_id from the blanket agreement that
481: -- matches the item.
482:

Line 499: -- POA_LOG.debug_line(' v_po_line_id: ' || v_po_line_id);

495: x_iteration_inner := x_iteration_inner + 1;
496: FETCH v_cursor_po_line INTO v_po_line_id;
497: EXIT WHEN v_cursor_po_line%NOTFOUND;
498:
499: -- POA_LOG.debug_line(' v_po_line_id: ' || v_po_line_id);
500:
501: -- Get the total quantity already released
502: x_progress := '080';
503: SELECT sum(nvl(pod.quantity_ordered,0)) INTO v_total_qty_released

Line 512: -- POA_LOG.debug_line(' v_total_qty_released: ' || v_total_qty_released);

508: and pod.po_line_id = v_po_line_id
509: and pod.creation_date < p_creation_date
510: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT';
511:
512: -- POA_LOG.debug_line(' v_total_qty_released: ' || v_total_qty_released);
513:
514: x_progress := '090';
515:
516: BEGIN

Line 549: -- POA_LOG.debug_line(' v_cursor_po_line closed');

545: END IF;
546: END LOOP;
547: CLOSE v_cursor_po_line;
548:
549: -- POA_LOG.debug_line(' v_cursor_po_line closed');
550: select poa_savings_np.get_currency_conv_rate(v_currency_code,
551: p_edw_global_currency_code,
552: p_rate_date,
553: p_edw_global_rate_type

Line 574: -- POA_LOG.debug_line(' v_cursor_blk closed');

570: EXIT WHEN v_cursor_blk%NOTFOUND;
571: END LOOP;
572: CLOSE v_cursor_blk;
573:
574: -- POA_LOG.debug_line(' v_cursor_blk closed');
575:
576: RETURN v_min_price_global;
577: POA_LOG.debug_line('Get_lowest_cum_price exit');
578: EXCEPTION

Line 577: POA_LOG.debug_line('Get_lowest_cum_price exit');

573:
574: -- POA_LOG.debug_line(' v_cursor_blk closed');
575:
576: RETURN v_min_price_global;
577: POA_LOG.debug_line('Get_lowest_cum_price exit');
578: EXCEPTION
579: WHEN others THEN
580: v_buf := 'Get lowest cumulative price: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
581:

Line 584: POA_LOG.put_line(v_buf);

580: v_buf := 'Get lowest cumulative price: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
581:
582: ROLLBACK;
583:
584: POA_LOG.put_line(v_buf);
585: POA_LOG.put_line(' ');
586:
587: RAISE;
588: END get_lowest_cum_price;

Line 585: POA_LOG.put_line(' ');

581:
582: ROLLBACK;
583:
584: POA_LOG.put_line(v_buf);
585: POA_LOG.put_line(' ');
586:
587: RAISE;
588: END get_lowest_cum_price;
589: