1: PACKAGE BODY POA_LOG AS
2: /* $Header: POALOGB.pls 115.6 2003/12/29 13:50:05 sriswami ship $ */
3:
4:
5: -- ------------------------------------------------------------------
73: filename VARCHAR2) IS
74: BEGIN
75:
76: IF (fnd_profile.value('POA_DEBUG') = 'Y') THEN
77: poa_log.g_debug := TRUE;
78: END IF;
79:
80: poa_log.put_names(filename ||'.log',filename||'.out',
81: '/sqlcom/log');
76: IF (fnd_profile.value('POA_DEBUG') = 'Y') THEN
77: poa_log.g_debug := TRUE;
78: END IF;
79:
80: poa_log.put_names(filename ||'.log',filename||'.out',
81: '/sqlcom/log');
82: poa_log.put_line('System time at the start of the process is: ' ||
83: fnd_date.date_to_charDT(sysdate));
84: poa_log.put_line( ' ');
78: END IF;
79:
80: poa_log.put_names(filename ||'.log',filename||'.out',
81: '/sqlcom/log');
82: poa_log.put_line('System time at the start of the process is: ' ||
83: fnd_date.date_to_charDT(sysdate));
84: poa_log.put_line( ' ');
85:
86: END setup;
80: poa_log.put_names(filename ||'.log',filename||'.out',
81: '/sqlcom/log');
82: poa_log.put_line('System time at the start of the process is: ' ||
83: fnd_date.date_to_charDT(sysdate));
84: poa_log.put_line( ' ');
85:
86: END setup;
87:
88: PROCEDURE wrapup(
89: status VARCHAR2) IS
90:
91: BEGIN
92: IF (status = 'SUCCESS') THEN
93: poa_log.put_line('Process completed at: ' ||
94: fnd_date.date_to_charDT(sysdate));
95: ELSIF (status = 'ERROR') THEN
96: poa_log.put_line('Process terminated with error at: ' ||
97: fnd_date.date_to_charDT(sysdate));
92: IF (status = 'SUCCESS') THEN
93: poa_log.put_line('Process completed at: ' ||
94: fnd_date.date_to_charDT(sysdate));
95: ELSIF (status = 'ERROR') THEN
96: poa_log.put_line('Process terminated with error at: ' ||
97: fnd_date.date_to_charDT(sysdate));
98: END IF;
99:
100: poa_log.put_line(' ');
96: poa_log.put_line('Process terminated with error at: ' ||
97: fnd_date.date_to_charDT(sysdate));
98: END IF;
99:
100: poa_log.put_line(' ');
101: END wrapup;
102:
103: end POA_LOG;
99:
100: poa_log.put_line(' ');
101: END wrapup;
102:
103: end POA_LOG;