DBA Data[Home] [Help]

APPS.POA_SUPPERF_POPULATE_PKG dependencies on POA_LOG

Line 85: POA_LOG.debug_line('populate_fact_table: entered');

81: x_progress VARCHAR2(10);
82:
83: BEGIN
84:
85: POA_LOG.debug_line('populate_fact_table: entered');
86: POA_LOG.debug_line(' ');
87:
88: OPEN C_EXTRACT;
89: LOOP

Line 86: POA_LOG.debug_line(' ');

82:
83: BEGIN
84:
85: POA_LOG.debug_line('populate_fact_table: entered');
86: POA_LOG.debug_line(' ');
87:
88: OPEN C_EXTRACT;
89: LOOP
90: BEGIN

Line 311: POA_LOG.put_line('populate_fact_table: ' || x_progress

307: sysdate
308: );
309: EXCEPTION
310: WHEN OTHERS THEN
311: POA_LOG.put_line('populate_fact_table: ' || x_progress
312: || ' ' || sqlerrm);
313: POA_LOG.put_line(' ');
314:
315: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||

Line 313: POA_LOG.put_line(' ');

309: EXCEPTION
310: WHEN OTHERS THEN
311: POA_LOG.put_line('populate_fact_table: ' || x_progress
312: || ' ' || sqlerrm);
313: POA_LOG.put_line(' ');
314:
315: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||
316: to_char(v_c_info.line_location_id));
317: POA_LOG.debug_line(' ');

Line 315: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||

311: POA_LOG.put_line('populate_fact_table: ' || x_progress
312: || ' ' || sqlerrm);
313: POA_LOG.put_line(' ');
314:
315: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||
316: to_char(v_c_info.line_location_id));
317: POA_LOG.debug_line(' ');
318: END;
319: END LOOP;

Line 317: POA_LOG.debug_line(' ');

313: POA_LOG.put_line(' ');
314:
315: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||
316: to_char(v_c_info.line_location_id));
317: POA_LOG.debug_line(' ');
318: END;
319: END LOOP;
320:
321: CLOSE C_EXTRACT;

Line 325: POA_LOG.put_line('populate_fact_table: ' || x_progress

321: CLOSE C_EXTRACT;
322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: POA_LOG.put_line('populate_fact_table: ' || x_progress
326: || ' ' || sqlerrm);
327: POA_LOG.put_line(' ');
328:
329: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||

Line 327: POA_LOG.put_line(' ');

323: EXCEPTION
324: WHEN OTHERS THEN
325: POA_LOG.put_line('populate_fact_table: ' || x_progress
326: || ' ' || sqlerrm);
327: POA_LOG.put_line(' ');
328:
329: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||
330: to_char(v_c_info.line_location_id));
331: POA_LOG.debug_line(' ');

Line 329: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||

325: POA_LOG.put_line('populate_fact_table: ' || x_progress
326: || ' ' || sqlerrm);
327: POA_LOG.put_line(' ');
328:
329: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||
330: to_char(v_c_info.line_location_id));
331: POA_LOG.debug_line(' ');
332:
333: RAISE;

Line 331: POA_LOG.debug_line(' ');

327: POA_LOG.put_line(' ');
328:
329: POA_LOG.debug_line('populate_fact_table: line_location_id - ' ||
330: to_char(v_c_info.line_location_id));
331: POA_LOG.debug_line(' ');
332:
333: RAISE;
334:
335: END populate_fact_table;

Line 357: POA_LOG.put_line('delete_row: ' || x_progress

353: WHERE po_shipment_id = p_line_location_id;
354:
355: EXCEPTION
356: WHEN OTHERS THEN
357: POA_LOG.put_line('delete_row: ' || x_progress
358: || ' ' || sqlerrm);
359: POA_LOG.put_line(' ');
360: RAISE;
361:

Line 359: POA_LOG.put_line(' ');

355: EXCEPTION
356: WHEN OTHERS THEN
357: POA_LOG.put_line('delete_row: ' || x_progress
358: || ' ' || sqlerrm);
359: POA_LOG.put_line(' ');
360: RAISE;
361:
362: END delete_row;
363:

Line 502: POA_LOG.put_line('insert_row: ' || x_progress

498: );
499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: POA_LOG.put_line('insert_row: ' || x_progress
503: || ' ' || sqlerrm);
504: POA_LOG.put_line(' ');
505: RAISE;
506:

Line 504: POA_LOG.put_line(' ');

500: EXCEPTION
501: WHEN OTHERS THEN
502: POA_LOG.put_line('insert_row: ' || x_progress
503: || ' ' || sqlerrm);
504: POA_LOG.put_line(' ');
505: RAISE;
506:
507: END insert_row;
508: