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_MAIN dependencies on POA_LOG

Line 82: POA_LOG.debug_line('Populate_savings: entered');

78: l_start_time date;
79: l_end_time date;
80: BEGIN
81: select sysdate into l_start_time from dual;
82: POA_LOG.debug_line('Populate_savings: entered');
83: POA_LOG.debug_line(' ');
84:
85: -- check if we need to populate the INC table poa_edw_po_dist_inc.
86: -- For EDW, we don't need to, since that is taken care in Push program.

Line 83: POA_LOG.debug_line(' ');

79: l_end_time date;
80: BEGIN
81: select sysdate into l_start_time from dual;
82: POA_LOG.debug_line('Populate_savings: entered');
83: POA_LOG.debug_line(' ');
84:
85: -- check if we need to populate the INC table poa_edw_po_dist_inc.
86: -- For EDW, we don't need to, since that is taken care in Push program.
87: -- For OLTP, we should.

Line 107: poa_log.put_line('time to populate incremental table: '|| poa_log.duration(l_end_time-l_start_time) || ', start time: ' || to_char(l_start_time, 'MM/DD/YYYY HH24:MI:SS') || ', end time: ' || to_char(l_end_time, 'MM/DD/YYYY HH24:MI:SS'));

103: EXIT WHEN l_count < l_batch_size;
104: end loop;
105: close v_changed_rows;
106: select sysdate into l_end_time from dual;
107: poa_log.put_line('time to populate incremental table: '|| poa_log.duration(l_end_time-l_start_time) || ', start time: ' || to_char(l_start_time, 'MM/DD/YYYY HH24:MI:SS') || ', end time: ' || to_char(l_end_time, 'MM/DD/YYYY HH24:MI:SS'));
108: end if;
109: -----------------------------------------------------------------------
110:
111:

Line 141: poa_log.put_line('total time taken for bis savings : '||poa_log.duration(l_end_time-l_start_time));

137: END LOOP;
138: end if;
139:
140: select sysdate into l_end_time from dual;
141: poa_log.put_line('total time taken for bis savings : '||poa_log.duration(l_end_time-l_start_time));
142:
143: /* Loop through to get the account information for each
144: * distribution
145: */

Line 152: POA_LOG.debug_line('Opening cursor v_account_cursor');

148: * Scoping this out for now.
149: */
150:
151: /*
152: POA_LOG.debug_line('Opening cursor v_account_cursor');
153: POA_LOG.debug_line(' ');
154:
155: OPEN v_account_cursor FOR
156: SELECT distinct pod.code_combination_id

Line 153: POA_LOG.debug_line(' ');

149: */
150:
151: /*
152: POA_LOG.debug_line('Opening cursor v_account_cursor');
153: POA_LOG.debug_line(' ');
154:
155: OPEN v_account_cursor FOR
156: SELECT distinct pod.code_combination_id
157: , pod.set_of_books_id

Line 189: POA_LOG.debug_line('Closed cursor v_account_cursor');

185:
186: END LOOP;
187: CLOSE v_account_cursor;
188:
189: POA_LOG.debug_line('Closed cursor v_account_cursor');
190: POA_LOG.debug_line(' ');
191:
192: POA_LOG.debug_line('Populate_savings: Updating account complete ');
193: POA_LOG.debug_line(' ');

Line 190: POA_LOG.debug_line(' ');

186: END LOOP;
187: CLOSE v_account_cursor;
188:
189: POA_LOG.debug_line('Closed cursor v_account_cursor');
190: POA_LOG.debug_line(' ');
191:
192: POA_LOG.debug_line('Populate_savings: Updating account complete ');
193: POA_LOG.debug_line(' ');
194: */

Line 192: POA_LOG.debug_line('Populate_savings: Updating account complete ');

188:
189: POA_LOG.debug_line('Closed cursor v_account_cursor');
190: POA_LOG.debug_line(' ');
191:
192: POA_LOG.debug_line('Populate_savings: Updating account complete ');
193: POA_LOG.debug_line(' ');
194: */
195: POA_LOG.debug_line('Populate_savings: exit');
196: POA_LOG.debug_line(' ');

Line 193: POA_LOG.debug_line(' ');

189: POA_LOG.debug_line('Closed cursor v_account_cursor');
190: POA_LOG.debug_line(' ');
191:
192: POA_LOG.debug_line('Populate_savings: Updating account complete ');
193: POA_LOG.debug_line(' ');
194: */
195: POA_LOG.debug_line('Populate_savings: exit');
196: POA_LOG.debug_line(' ');
197:

Line 195: POA_LOG.debug_line('Populate_savings: exit');

191:
192: POA_LOG.debug_line('Populate_savings: Updating account complete ');
193: POA_LOG.debug_line(' ');
194: */
195: POA_LOG.debug_line('Populate_savings: exit');
196: POA_LOG.debug_line(' ');
197:
198: EXCEPTION
199: WHEN others THEN

Line 196: POA_LOG.debug_line(' ');

192: POA_LOG.debug_line('Populate_savings: Updating account complete ');
193: POA_LOG.debug_line(' ');
194: */
195: POA_LOG.debug_line('Populate_savings: exit');
196: POA_LOG.debug_line(' ');
197:
198: EXCEPTION
199: WHEN others THEN
200: v_buf := 'Main function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;

Line 203: POA_LOG.put_line(v_buf);

199: WHEN others THEN
200: v_buf := 'Main function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
201: ROLLBACK;
202:
203: POA_LOG.put_line(v_buf);
204: POA_LOG.put_line(' ');
205: RAISE;
206: END populate_savings;
207: --

Line 204: POA_LOG.put_line(' ');

200: v_buf := 'Main function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
201: ROLLBACK;
202:
203: POA_LOG.put_line(v_buf);
204: POA_LOG.put_line(' ');
205: RAISE;
206: END populate_savings;
207: --
208: