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.EDW_HR_PERSON_M_C dependencies on EDW_LOG

Line 265: edw_log.put_line( 'Pushing Supervisor Hierarchy Level ' ||

261: ';
262:
263: END IF;
264:
265: edw_log.put_line( 'Pushing Supervisor Hierarchy Level ' ||
266: p_from_level || ' to Level ' || p_to_level );
267:
268: l_temp_date := SYSDATE;
269: -- edw_log.put_line(l_sql_stmt);

Line 269: -- edw_log.put_line(l_sql_stmt);

265: edw_log.put_line( 'Pushing Supervisor Hierarchy Level ' ||
266: p_from_level || ' to Level ' || p_to_level );
267:
268: l_temp_date := SYSDATE;
269: -- edw_log.put_line(l_sql_stmt);
270: EXECUTE IMMEDIATE l_sql_stmt;
271:
272: l_rows_inserted := sql%rowcount;
273:

Line 278: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||

274: l_duration := sysdate - l_temp_date;
275:
276: Commit;
277:
278: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
279: ' rows into the ' || l_to_table || ' staging table');
280:
281: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
282: edw_log.put_line(' ');

Line 281: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

277:
278: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
279: ' rows into the ' || l_to_table || ' staging table');
280:
281: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
282: edw_log.put_line(' ');
283:
284: End Do_Insert;
285:

Line 282: edw_log.put_line(' ');

278: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
279: ' rows into the ' || l_to_table || ' staging table');
280:
281: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
282: edw_log.put_line(' ');
283:
284: End Do_Insert;
285:
286:

Line 315: edw_log.put_line('Starting Push_EDW_HR_PERM_SPSR_' || v_push_to_level || '_LSTG');

311: /****************************************************/
312:
313: FOR v_push_to_level IN 1..g_number_of_levels LOOP
314:
315: edw_log.put_line('Starting Push_EDW_HR_PERM_SPSR_' || v_push_to_level || '_LSTG');
316: edw_log.put_line(' ');
317:
318: FOR v_push_from_view IN v_push_to_level..g_number_of_levels LOOP
319:

Line 316: edw_log.put_line(' ');

312:
313: FOR v_push_to_level IN 1..g_number_of_levels LOOP
314:
315: edw_log.put_line('Starting Push_EDW_HR_PERM_SPSR_' || v_push_to_level || '_LSTG');
316: edw_log.put_line(' ');
317:
318: FOR v_push_from_view IN v_push_to_level..g_number_of_levels LOOP
319:
320: Do_Insert( p_tree_number => p_tree,

Line 376: edw_log.put_line( 'The collection range is from '||

372: EDW_HR_PERSON_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
373: END IF;
374:
375:
376: edw_log.put_line( 'The collection range is from '||
377: to_char(EDW_HR_PERSON_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
378: to_char(EDW_HR_PERSON_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
379: edw_log.put_line(' ');
380:

Line 379: edw_log.put_line(' ');

375:
376: edw_log.put_line( 'The collection range is from '||
377: to_char(EDW_HR_PERSON_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
378: to_char(EDW_HR_PERSON_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
379: edw_log.put_line(' ');
380:
381:
382: -- -----------------------------------------------------------------------------
383: -- Start of Collection , Developer Customizable Section

Line 391: edw_log.put_line( 'About to call Supervisor Hierarchy summary table population routine' );

387: /* New changes implemented by HRI */
388: /* 10 Levels inserted */
389: /*************************************************/
390:
391: edw_log.put_line( 'About to call Supervisor Hierarchy summary table population routine' );
392: hri_struct_summary.load_all_sup_hierarchies;
393:
394: open cur_check_sprvsr_hrchy;
395: fetch cur_check_sprvsr_hrchy into l_check_sprvsr_id;

Line 401: edw_log.put_line( 'Supervisor hierarchy is empty' );

397: /* Bug 3440848 - always collect supervisor tree */
398: /* Moved it outside cursor check */
399: if cur_check_sprvsr_hrchy%ISOPEN then
400: if cur_check_sprvsr_hrchy%NOTFOUND then
401: edw_log.put_line( 'Supervisor hierarchy is empty' );
402: else
403: edw_log.put_line( 'hri_struct_summary.load_all_sup_hierarchies completed OK.' );
404: end if;
405: end if;

Line 403: edw_log.put_line( 'hri_struct_summary.load_all_sup_hierarchies completed OK.' );

399: if cur_check_sprvsr_hrchy%ISOPEN then
400: if cur_check_sprvsr_hrchy%NOTFOUND then
401: edw_log.put_line( 'Supervisor hierarchy is empty' );
402: else
403: edw_log.put_line( 'hri_struct_summary.load_all_sup_hierarchies completed OK.' );
404: end if;
405: end if;
406:
407: edw_log.put_line( ' ' );

Line 407: edw_log.put_line( ' ' );

403: edw_log.put_line( 'hri_struct_summary.load_all_sup_hierarchies completed OK.' );
404: end if;
405: end if;
406:
407: edw_log.put_line( ' ' );
408: edw_log.put_line( 'About to call Supervisor Tree routine' );
409: edw_log.put_line( ' ' );
410:
411: EDW_HR_PERSON_M_C.Push_Tree(

Line 408: edw_log.put_line( 'About to call Supervisor Tree routine' );

404: end if;
405: end if;
406:
407: edw_log.put_line( ' ' );
408: edw_log.put_line( 'About to call Supervisor Tree routine' );
409: edw_log.put_line( ' ' );
410:
411: EDW_HR_PERSON_M_C.Push_Tree(
412: p_from_date => g_push_date_range1,

Line 409: edw_log.put_line( ' ' );

405: end if;
406:
407: edw_log.put_line( ' ' );
408: edw_log.put_line( 'About to call Supervisor Tree routine' );
409: edw_log.put_line( ' ' );
410:
411: EDW_HR_PERSON_M_C.Push_Tree(
412: p_from_date => g_push_date_range1,
413: p_to_date => g_push_date_range2,

Line 416: edw_log.put_line( ' Supervisor Tree routine completed ok' );

412: p_from_date => g_push_date_range1,
413: p_to_date => g_push_date_range2,
414: p_tree => 1 );
415:
416: edw_log.put_line( ' Supervisor Tree routine completed ok' );
417: edw_log.put_line( ' ' );
418:
419: /*************************************************/
420:

Line 417: edw_log.put_line( ' ' );

413: p_to_date => g_push_date_range2,
414: p_tree => 1 );
415:
416: edw_log.put_line( ' Supervisor Tree routine completed ok' );
417: edw_log.put_line( ' ' );
418:
419: /*************************************************/
420:
421: edw_log.put_line(' ');

Line 421: edw_log.put_line(' ');

417: edw_log.put_line( ' ' );
418:
419: /*************************************************/
420:
421: edw_log.put_line(' ');
422: edw_log.put_line('Pushing data');
423:
424: l_temp_date := sysdate;
425:

Line 422: edw_log.put_line('Pushing data');

418:
419: /*************************************************/
420:
421: edw_log.put_line(' ');
422: edw_log.put_line('Pushing data');
423:
424: l_temp_date := sysdate;
425:
426: Push_EDW_HR_PERM_ASSIGN_LSTG(EDW_HR_PERSON_M_C.g_push_date_range1, EDW_HR_PERSON_M_C.g_push_date_range2);

Line 431: edw_log.put_line('Total rows inserted : '||g_row_count);

427:
428:
429: l_duration := sysdate - l_temp_date;
430:
431: edw_log.put_line('Total rows inserted : '||g_row_count);
432: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
433: edw_log.put_line(' ');
434: -- ---------------------------------------------------------------------------
435: -- END OF Collection , Developer Customizable Section

Line 432: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

428:
429: l_duration := sysdate - l_temp_date;
430:
431: edw_log.put_line('Total rows inserted : '||g_row_count);
432: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
433: edw_log.put_line(' ');
434: -- ---------------------------------------------------------------------------
435: -- END OF Collection , Developer Customizable Section
436: -- ---------------------------------------------------------------------------

Line 433: edw_log.put_line(' ');

429: l_duration := sysdate - l_temp_date;
430:
431: edw_log.put_line('Total rows inserted : '||g_row_count);
432: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
433: edw_log.put_line(' ');
434: -- ---------------------------------------------------------------------------
435: -- END OF Collection , Developer Customizable Section
436: -- ---------------------------------------------------------------------------
437: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );

Line 457: edw_log.put_line('Starting Push_EDW_HR_PERM_ASSIGN_LSTG');

453: l_date1 DATE;
454: l_date2 DATE;
455: l_rows_inserted NUMBER :=0;
456: BEGIN
457: edw_log.put_line('Starting Push_EDW_HR_PERM_ASSIGN_LSTG');
458: l_date1 := p_from_date;
459: l_date2 := p_to_date;
460: Insert Into
461: EDW_HR_PERM_ASSIGN_LSTG@EDW_APPS_TO_WH(

Line 604: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||

600: where plcv.last_update_date between l_date1 and l_date2;
601: --
602: l_rows_inserted := sql%rowcount;
603: EDW_HR_PERSON_M_C.g_row_count := EDW_HR_PERSON_M_C.g_row_count + l_rows_inserted ;
604: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
605: ' rows into the EDW_HR_PERM_ASSIGN_LSTG staging table');
606: edw_log.put_line('Commiting records for EDW_HR_PERM_ASSIGN_LSTG');
607: commit;
608:

Line 606: edw_log.put_line('Commiting records for EDW_HR_PERM_ASSIGN_LSTG');

602: l_rows_inserted := sql%rowcount;
603: EDW_HR_PERSON_M_C.g_row_count := EDW_HR_PERSON_M_C.g_row_count + l_rows_inserted ;
604: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
605: ' rows into the EDW_HR_PERM_ASSIGN_LSTG staging table');
606: edw_log.put_line('Commiting records for EDW_HR_PERM_ASSIGN_LSTG');
607: commit;
608:
609: edw_log.put_line('Completed Push_EDW_HR_PERM_ASSIGN_LSTG');
610: Exception When others then

Line 609: edw_log.put_line('Completed Push_EDW_HR_PERM_ASSIGN_LSTG');

605: ' rows into the EDW_HR_PERM_ASSIGN_LSTG staging table');
606: edw_log.put_line('Commiting records for EDW_HR_PERM_ASSIGN_LSTG');
607: commit;
608:
609: edw_log.put_line('Completed Push_EDW_HR_PERM_ASSIGN_LSTG');
610: Exception When others then
611: raise;
612: commit;
613: END;