APPS.OPIMXRU dependencies on EDW_LOG

Line 118: edw_log.put_line('Inserting into push_log for 24 hr availalbe res count ' || SQL%rowcount);

114: AND hoi.organization_id = mp.organization_id
115: AND hoi.ORG_INFORMATION_CONTEXT = 'Accounting Information'
116: ;
117:
118: edw_log.put_line('Inserting into push_log for 24 hr availalbe res count ' || SQL%rowcount);
119: edw_log.put_line('system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );
120: -- --------------------------------------------------------
121: -- commit since there might be a large set data
122: -- --------------------------------------------------------

Line 119: edw_log.put_line('system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );

115: AND hoi.ORG_INFORMATION_CONTEXT = 'Accounting Information'
116: ;
117:
118: edw_log.put_line('Inserting into push_log for 24 hr availalbe res count ' || SQL%rowcount);
119: edw_log.put_line('system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );
120: -- --------------------------------------------------------
121: -- commit since there might be a large set data
122: -- --------------------------------------------------------
123: COMMIT;

Line 184: edw_log.put_line('Inserting into push_log for shift availalbe res count ' || SQL%rowcount);

180: br.resource_code,
181: hoi.org_information1
182: ;
183:
184: edw_log.put_line('Inserting into push_log for shift availalbe res count ' || SQL%rowcount);
185: edw_log.put_line('system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );
186: COMMIT;
187:
188: -- --------------------------------------------------------

Line 185: edw_log.put_line('system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );

181: hoi.org_information1
182: ;
183:
184: edw_log.put_line('Inserting into push_log for shift availalbe res count ' || SQL%rowcount);
185: edw_log.put_line('system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );
186: COMMIT;
187:
188: -- --------------------------------------------------------
189: -- For the those resoruce actually used in WIP

Line 226: edw_log.put_line('After WIP used res update /insert system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );

222: END IF;
223:
224: END LOOP;
225:
226: edw_log.put_line('After WIP used res update /insert system time is ' || To_char(Sysdate, 'MM/DD/YYYY HH24:MI:SS') );
227:
228: COMMIT;
229:
230: EXCEPTION

Line 232: edw_log.put_line('Inserting into push log has failed. ');

228: COMMIT;
229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: edw_log.put_line('Inserting into push log has failed. ');
233: RAISE;
234:
235: END extract_opi_res_util;
236: