APPS.POA_FACTS dependencies on POA_LOG

Line 27: POA_LOG.setup('POAPOPF');

23:
24: errbuf := NULL;
25: retcode := 0;
26:
27: POA_LOG.setup('POAPOPF');
28:
29: SELECT NVL(TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS'), to_date(1,'J'))
30: INTO v_start_date
31: FROM sys.dual;

Line 37: POA_LOG.put_line('Parameter start_date is: ' ||

33: SELECT NVL(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
34: INTO v_end_date
35: FROM sys.dual;
36:
37: POA_LOG.put_line('Parameter start_date is: ' ||
38: fnd_date.date_to_chardate(v_start_date));
39: POA_LOG.put_line(' ');
40:
41: POA_LOG.put_line('Parameter end_date is: ' ||

Line 39: POA_LOG.put_line(' ');

35: FROM sys.dual;
36:
37: POA_LOG.put_line('Parameter start_date is: ' ||
38: fnd_date.date_to_chardate(v_start_date));
39: POA_LOG.put_line(' ');
40:
41: POA_LOG.put_line('Parameter end_date is: ' ||
42: fnd_date.date_to_chardate(v_end_date));
43: POA_LOG.put_line(' ');

Line 41: POA_LOG.put_line('Parameter end_date is: ' ||

37: POA_LOG.put_line('Parameter start_date is: ' ||
38: fnd_date.date_to_chardate(v_start_date));
39: POA_LOG.put_line(' ');
40:
41: POA_LOG.put_line('Parameter end_date is: ' ||
42: fnd_date.date_to_chardate(v_end_date));
43: POA_LOG.put_line(' ');
44:
45: poa_savings_main.populate_savings(v_start_date, v_end_date+1);

Line 43: POA_LOG.put_line(' ');

39: POA_LOG.put_line(' ');
40:
41: POA_LOG.put_line('Parameter end_date is: ' ||
42: fnd_date.date_to_chardate(v_end_date));
43: POA_LOG.put_line(' ');
44:
45: poa_savings_main.populate_savings(v_start_date, v_end_date+1);
46:
47: POA_LOG.put_line('Spend Analysis data populated');

Line 47: POA_LOG.put_line('Spend Analysis data populated');

43: POA_LOG.put_line(' ');
44:
45: poa_savings_main.populate_savings(v_start_date, v_end_date+1);
46:
47: POA_LOG.put_line('Spend Analysis data populated');
48: POA_LOG.put_line(' ');
49:
50:
51: POA_LOG.wrapup('SUCCESS');

Line 48: POA_LOG.put_line(' ');

44:
45: poa_savings_main.populate_savings(v_start_date, v_end_date+1);
46:
47: POA_LOG.put_line('Spend Analysis data populated');
48: POA_LOG.put_line(' ');
49:
50:
51: POA_LOG.wrapup('SUCCESS');
52:

Line 51: POA_LOG.wrapup('SUCCESS');

47: POA_LOG.put_line('Spend Analysis data populated');
48: POA_LOG.put_line(' ');
49:
50:
51: POA_LOG.wrapup('SUCCESS');
52:
53: RETURN;
54:
55: EXCEPTION

Line 63: POA_LOG.put_line(v_buf);

59: retcode := sqlcode;
60:
61: v_buf := to_char(retcode) || ':' || errbuf;
62: ROLLBACK;
63: POA_LOG.put_line(v_buf);
64: POA_LOG.wrapup('ERROR');
65:
66: RETURN;
67: END populate_facts;

Line 64: POA_LOG.wrapup('ERROR');

60:
61: v_buf := to_char(retcode) || ':' || errbuf;
62: ROLLBACK;
63: POA_LOG.put_line(v_buf);
64: POA_LOG.wrapup('ERROR');
65:
66: RETURN;
67: END populate_facts;
68: --