DBA Data[Home] [Help]

APPS.POA_SUPPERF_API_PKG dependencies on POA_LOG

Line 31: POA_LOG.put_line('get_receipt_date: ' || x_progress

27: EXCEPTION
28: WHEN NO_DATA_FOUND THEN
29: RETURN(v_receipt_date);
30: WHEN OTHERS THEN
31: POA_LOG.put_line('get_receipt_date: ' || x_progress
32: || ' ' || sqlerrm);
33: POA_LOG.put_line(' ');
34: RAISE;
35: RETURN(v_receipt_date);

Line 33: POA_LOG.put_line(' ');

29: RETURN(v_receipt_date);
30: WHEN OTHERS THEN
31: POA_LOG.put_line('get_receipt_date: ' || x_progress
32: || ' ' || sqlerrm);
33: POA_LOG.put_line(' ');
34: RAISE;
35: RETURN(v_receipt_date);
36:
37: END get_receipt_date;

Line 76: POA_LOG.put_line('get_avg_price: ' || x_progress

72: RETURN(v_ave_price);
73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: POA_LOG.put_line('get_avg_price: ' || x_progress
77: || ' ' || sqlerrm);
78: POA_LOG.put_line(' ');
79: RAISE;
80: RETURN(v_ave_price);

Line 78: POA_LOG.put_line(' ');

74: EXCEPTION
75: WHEN OTHERS THEN
76: POA_LOG.put_line('get_avg_price: ' || x_progress
77: || ' ' || sqlerrm);
78: POA_LOG.put_line(' ');
79: RAISE;
80: RETURN(v_ave_price);
81:
82: END get_avg_price;

Line 128: POA_LOG.put_line('get_primary_avg_price: ' || x_progress

124: RETURN(v_primary_avg_price);
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: POA_LOG.put_line('get_primary_avg_price: ' || x_progress
129: || ' ' || sqlerrm);
130: POA_LOG.put_line(' ');
131: RAISE;
132: RETURN(v_primary_avg_price);

Line 130: POA_LOG.put_line(' ');

126: EXCEPTION
127: WHEN OTHERS THEN
128: POA_LOG.put_line('get_primary_avg_price: ' || x_progress
129: || ' ' || sqlerrm);
130: POA_LOG.put_line(' ');
131: RAISE;
132: RETURN(v_primary_avg_price);
133:
134: END get_primary_avg_price;

Line 167: POA_LOG.put_line('get_num_receipts: ' || x_progress

163: EXCEPTION
164: WHEN NO_DATA_FOUND THEN
165: RETURN(v_num_receipts);
166: WHEN OTHERS THEN
167: POA_LOG.put_line('get_num_receipts: ' || x_progress
168: || ' ' || sqlerrm);
169: POA_LOG.put_line(' ');
170: RAISE;
171: RETURN(v_num_receipts);

Line 169: POA_LOG.put_line(' ');

165: RETURN(v_num_receipts);
166: WHEN OTHERS THEN
167: POA_LOG.put_line('get_num_receipts: ' || x_progress
168: || ' ' || sqlerrm);
169: POA_LOG.put_line(' ');
170: RAISE;
171: RETURN(v_num_receipts);
172:
173: END get_num_receipts;

Line 226: POA_LOG.put_line('get_quantity_late: ' || x_progress

222: RETURN(v_quantity_late);
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: POA_LOG.put_line('get_quantity_late: ' || x_progress
227: || ' ' || sqlerrm);
228: POA_LOG.put_line(' ');
229: RAISE;
230: RETURN(v_quantity_late);

Line 228: POA_LOG.put_line(' ');

224: EXCEPTION
225: WHEN OTHERS THEN
226: POA_LOG.put_line('get_quantity_late: ' || x_progress
227: || ' ' || sqlerrm);
228: POA_LOG.put_line(' ');
229: RAISE;
230: RETURN(v_quantity_late);
231:
232: END get_quantity_late;

Line 286: POA_LOG.put_line('get_quantity_early: ' || x_progress

282: RETURN(v_quantity_early);
283:
284: EXCEPTION
285: WHEN OTHERS THEN
286: POA_LOG.put_line('get_quantity_early: ' || x_progress
287: || ' ' || sqlerrm);
288: POA_LOG.put_line(' ');
289: RAISE;
290: RETURN(v_quantity_early);

Line 288: POA_LOG.put_line(' ');

284: EXCEPTION
285: WHEN OTHERS THEN
286: POA_LOG.put_line('get_quantity_early: ' || x_progress
287: || ' ' || sqlerrm);
288: POA_LOG.put_line(' ');
289: RAISE;
290: RETURN(v_quantity_early);
291:
292: END get_quantity_early;

Line 358: POA_LOG.put_line('No primary UOM found for item ' || p_item_id || ' and org ' || p_organization_id);

354: RETURN(v_primary_uom);
355:
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN
358: POA_LOG.put_line('No primary UOM found for item ' || p_item_id || ' and org ' || p_organization_id);
359: POA_LOG.put_line(' ');
360: RAISE;
361: RETURN(v_primary_uom);
362: WHEN OTHERS THEN

Line 359: POA_LOG.put_line(' ');

355:
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN
358: POA_LOG.put_line('No primary UOM found for item ' || p_item_id || ' and org ' || p_organization_id);
359: POA_LOG.put_line(' ');
360: RAISE;
361: RETURN(v_primary_uom);
362: WHEN OTHERS THEN
363: POA_LOG.put_line('get_primary_uom: ' || x_progress || ' ' || sqlerrm);

Line 363: POA_LOG.put_line('get_primary_uom: ' || x_progress || ' ' || sqlerrm);

359: POA_LOG.put_line(' ');
360: RAISE;
361: RETURN(v_primary_uom);
362: WHEN OTHERS THEN
363: POA_LOG.put_line('get_primary_uom: ' || x_progress || ' ' || sqlerrm);
364: POA_LOG.put_line(' ');
365: RAISE;
366: RETURN(v_primary_uom);
367: END get_primary_uom;

Line 364: POA_LOG.put_line(' ');

360: RAISE;
361: RETURN(v_primary_uom);
362: WHEN OTHERS THEN
363: POA_LOG.put_line('get_primary_uom: ' || x_progress || ' ' || sqlerrm);
364: POA_LOG.put_line(' ');
365: RAISE;
366: RETURN(v_primary_uom);
367: END get_primary_uom;
368:

Line 505: POA_LOG.put_line('get_total_amount: ' || x_progress

501: RETURN(v_total_amount);
502:
503: EXCEPTION
504: WHEN OTHERS THEN
505: POA_LOG.put_line('get_total_amount: ' || x_progress
506: || ' ' || sqlerrm);
507: POA_LOG.put_line(' ');
508: RAISE;
509: RETURN(v_total_amount);

Line 507: POA_LOG.put_line(' ');

503: EXCEPTION
504: WHEN OTHERS THEN
505: POA_LOG.put_line('get_total_amount: ' || x_progress
506: || ' ' || sqlerrm);
507: POA_LOG.put_line(' ');
508: RAISE;
509: RETURN(v_total_amount);
510:
511: END get_total_amount;

Line 690: POA_LOG.put_line('get_suppliers: ' || x_progress

686: CLOSE v_cursor_blk;
687:
688: EXCEPTION
689: WHEN OTHERS THEN
690: POA_LOG.put_line('get_suppliers: ' || x_progress
691: || ' ' || sqlerrm);
692: POA_LOG.put_line(' ');
693: RAISE;
694: RETURN(v_suppliers);

Line 692: POA_LOG.put_line(' ');

688: EXCEPTION
689: WHEN OTHERS THEN
690: POA_LOG.put_line('get_suppliers: ' || x_progress
691: || ' ' || sqlerrm);
692: POA_LOG.put_line(' ');
693: RAISE;
694: RETURN(v_suppliers);
695:
696: END get_suppliers;

Line 808: POA_LOG.put_line('get_rcv_txn_qty: ' || x_progress

804: RETURN(v_quantity);
805:
806: EXCEPTION
807: WHEN invalid_type THEN
808: POA_LOG.put_line('get_rcv_txn_qty: ' || x_progress
809: || ' ' || 'Invalid transaction Type - '
810: || p_txn_type);
811: POA_LOG.put_line(' ');
812: RAISE;

Line 811: POA_LOG.put_line(' ');

807: WHEN invalid_type THEN
808: POA_LOG.put_line('get_rcv_txn_qty: ' || x_progress
809: || ' ' || 'Invalid transaction Type - '
810: || p_txn_type);
811: POA_LOG.put_line(' ');
812: RAISE;
813: RETURN(v_quantity);
814:
815: WHEN OTHERS THEN

Line 816: POA_LOG.put_line('get_rcv_txn_qty: ' || x_progress

812: RAISE;
813: RETURN(v_quantity);
814:
815: WHEN OTHERS THEN
816: POA_LOG.put_line('get_rcv_txn_qty: ' || x_progress
817: || ' ' || sqlerrm);
818: POA_LOG.put_line(' ');
819: RAISE;
820: RETURN(v_quantity);

Line 818: POA_LOG.put_line(' ');

814:
815: WHEN OTHERS THEN
816: POA_LOG.put_line('get_rcv_txn_qty: ' || x_progress
817: || ' ' || sqlerrm);
818: POA_LOG.put_line(' ');
819: RAISE;
820: RETURN(v_quantity);
821:
822: END get_rcv_txn_qty;