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

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

42: FII_PROJECT_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
43: FII_PROJECT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||
47: to_char(FII_PROJECT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PROJECT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50: end if;

Line 49: edw_log.put_line(' ');

45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||
47: to_char(FII_PROJECT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PROJECT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50: end if;
51:
52: -- -----------------------------------------------------------------------------
53: -- Start of Collection , Developer Customizable Section

Line 57: edw_log.put_line(' ');

53: -- Start of Collection , Developer Customizable Section
54: -- -----------------------------------------------------------------------------
55:
56: if g_debug_flag = 'Y' then
57: edw_log.put_line(' ');
58: edw_log.put_line('Pushing data');
59: end if;
60:
61: l_temp_date := sysdate;

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

54: -- -----------------------------------------------------------------------------
55:
56: if g_debug_flag = 'Y' then
57: edw_log.put_line(' ');
58: edw_log.put_line('Pushing data');
59: end if;
60:
61: l_temp_date := sysdate;
62:

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

81:
82: l_duration := sysdate - l_temp_date;
83:
84: if g_debug_flag = 'Y' then
85: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
86: edw_log.put_line(' ');
87: end if;
88:
89: -- ---------------------------------------------------------------------------

Line 86: edw_log.put_line(' ');

82: l_duration := sysdate - l_temp_date;
83:
84: if g_debug_flag = 'Y' then
85: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
86: edw_log.put_line(' ');
87: end if;
88:
89: -- ---------------------------------------------------------------------------
90: -- END OF Collection , Developer Customizable Section

Line 124: edw_log.put_line('Starting Push_EDW_PROJ_TASK_LSTG');

120:
121: BEGIN
122:
123: if g_debug_flag = 'Y' then
124: edw_log.put_line('Starting Push_EDW_PROJ_TASK_LSTG');
125: end if;
126:
127: l_date1 := p_from_date;
128: l_date2 := p_to_date;

Line 187: edw_log.put_line('Commiting records for EDW_PROJ_TASK_LSTG');

183: l_rows_inserted := sql%rowcount;
184: g_row_count := g_row_count + l_rows_inserted ;
185:
186: if g_debug_flag = 'Y' then
187: edw_log.put_line('Commiting records for EDW_PROJ_TASK_LSTG');
188: end if;
189:
190: commit;
191:

Line 193: edw_log.put_line('Completed Push_EDW_PROJ_TASK_LSTG');

189:
190: commit;
191:
192: if g_debug_flag = 'Y' then
193: edw_log.put_line('Completed Push_EDW_PROJ_TASK_LSTG');
194: end if;
195:
196: Exception
197:

Line 214: edw_log.put_line('Starting Push_EDW_PROJ_TOP_TASK_LSTG');

210:
211: BEGIN
212:
213: if g_debug_flag = 'Y' then
214: edw_log.put_line('Starting Push_EDW_PROJ_TOP_TASK_LSTG');
215: end if;
216:
217: l_date1 := p_from_date;
218: l_date2 := p_to_date;

Line 269: edw_log.put_line('Commiting records for EDW_PROJ_TOP_TASK_LSTG');

265: l_rows_inserted := sql%rowcount;
266: --g_row_count := g_row_count + l_rows_inserted ;
267:
268: if g_debug_flag = 'Y' then
269: edw_log.put_line('Commiting records for EDW_PROJ_TOP_TASK_LSTG');
270: end if;
271:
272: commit;
273:

Line 275: edw_log.put_line('Completed Push_EDW_PROJ_TOP_TASK_LSTG');

271:
272: commit;
273:
274: if g_debug_flag = 'Y' then
275: edw_log.put_line('Completed Push_EDW_PROJ_TOP_TASK_LSTG');
276: end if;
277:
278: Exception
279:

Line 296: edw_log.put_line('Starting Push_EDW_PROJ_PROJECT_LSTG');

292:
293: BEGIN
294:
295: if g_debug_flag = 'Y' then
296: edw_log.put_line('Starting Push_EDW_PROJ_PROJECT_LSTG');
297: end if;
298:
299: l_date1 := p_from_date;
300: l_date2 := p_to_date;

Line 363: edw_log.put_line('Commiting records for EDW_PROJ_PROJECT_LSTG');

359: l_rows_inserted := sql%rowcount;
360: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
361:
362: if g_debug_flag = 'Y' then
363: edw_log.put_line('Commiting records for EDW_PROJ_PROJECT_LSTG');
364: end if;
365:
366: commit;
367:

Line 369: edw_log.put_line('Completed Push_EDW_PROJ_PROJECT_LSTG');

365:
366: commit;
367:
368: if g_debug_flag = 'Y' then
369: edw_log.put_line('Completed Push_EDW_PROJ_PROJECT_LSTG');
370: end if;
371:
372: Exception
373:

Line 392: edw_log.put_line('Starting Push_EDW_PROJ_PRJ_TYP_LSTG');

388:
389: BEGIN
390:
391: if g_debug_flag = 'Y' then
392: edw_log.put_line('Starting Push_EDW_PROJ_PRJ_TYP_LSTG');
393: end if;
394:
395: l_date1 := p_from_date;
396: l_date2 := p_to_date;

Line 495: edw_log.put_line('Commiting records for EDW_PROJ_PRJ_TYP_LSTG');

491:
492: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
493:
494: if g_debug_flag = 'Y' then
495: edw_log.put_line('Commiting records for EDW_PROJ_PRJ_TYP_LSTG');
496: end if;
497:
498: commit;
499:

Line 501: edw_log.put_line('Completed Push_EDW_PROJ_PRJ_TYP_LSTG');

497:
498: commit;
499:
500: if g_debug_flag = 'Y' then
501: edw_log.put_line('Completed Push_EDW_PROJ_PRJ_TYP_LSTG');
502: end if;
503:
504: Exception
505:

Line 522: edw_log.put_line('Starting Push_EDW_PROJ_CLS1_LSTG');

518:
519: BEGIN
520:
521: if g_debug_flag = 'Y' then
522: edw_log.put_line('Starting Push_EDW_PROJ_CLS1_LSTG');
523: end if;
524:
525: l_date1 := p_from_date;
526: l_date2 := p_to_date;

Line 567: edw_log.put_line('Commiting records for EDW_PROJ_CLS1_LSTG');

563: l_rows_inserted := sql%rowcount;
564: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
565:
566: if g_debug_flag = 'Y' then
567: edw_log.put_line('Commiting records for EDW_PROJ_CLS1_LSTG');
568: end if;
569:
570: commit;
571:

Line 573: edw_log.put_line('Completed Push_EDW_PROJ_CLS1_LSTG');

569:
570: commit;
571:
572: if g_debug_flag = 'Y' then
573: edw_log.put_line('Completed Push_EDW_PROJ_CLS1_LSTG');
574: end if;
575:
576: Exception
577:

Line 594: edw_log.put_line('Starting Push_EDW_PROJ_CLS2_LSTG');

590:
591: BEGIN
592:
593: if g_debug_flag = 'Y' then
594: edw_log.put_line('Starting Push_EDW_PROJ_CLS2_LSTG');
595: end if;
596:
597: l_date1 := p_from_date;
598: l_date2 := p_to_date;

Line 638: edw_log.put_line('Commiting records for EDW_PROJ_CLS2_LSTG');

634: l_rows_inserted := sql%rowcount;
635: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
636:
637: if g_debug_flag = 'Y' then
638: edw_log.put_line('Commiting records for EDW_PROJ_CLS2_LSTG');
639: end if;
640:
641: commit;
642:

Line 644: edw_log.put_line('Completed Push_EDW_PROJ_CLS2_LSTG');

640:
641: commit;
642:
643: if g_debug_flag = 'Y' then
644: edw_log.put_line('Completed Push_EDW_PROJ_CLS2_LSTG');
645: end if;
646:
647: Exception
648:

Line 665: edw_log.put_line('Starting Push_EDW_PROJ_CLS3_LSTG');

661:
662: BEGIN
663:
664: if g_debug_flag = 'Y' then
665: edw_log.put_line('Starting Push_EDW_PROJ_CLS3_LSTG');
666: end if;
667:
668: l_date1 := p_from_date;
669: l_date2 := p_to_date;

Line 710: edw_log.put_line('Commiting records for EDW_PROJ_CLS3_LSTG');

706: l_rows_inserted := sql%rowcount;
707: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
708:
709: if g_debug_flag = 'Y' then
710: edw_log.put_line('Commiting records for EDW_PROJ_CLS3_LSTG');
711: end if;
712:
713: commit;
714:

Line 716: edw_log.put_line('Completed Push_EDW_PROJ_CLS3_LSTG');

712:
713: commit;
714:
715: if g_debug_flag = 'Y' then
716: edw_log.put_line('Completed Push_EDW_PROJ_CLS3_LSTG');
717: end if;
718:
719: Exception
720:

Line 737: edw_log.put_line('Starting Push_EDW_PROJ_CLS4_LSTG');

733:
734: BEGIN
735:
736: if g_debug_flag = 'Y' then
737: edw_log.put_line('Starting Push_EDW_PROJ_CLS4_LSTG');
738: end if;
739:
740: l_date1 := p_from_date;
741: l_date2 := p_to_date;

Line 782: edw_log.put_line('Commiting records for EDW_PROJ_CLS4_LSTG');

778: l_rows_inserted := sql%rowcount;
779: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
780:
781: if g_debug_flag = 'Y' then
782: edw_log.put_line('Commiting records for EDW_PROJ_CLS4_LSTG');
783: end if;
784:
785: commit;
786:

Line 788: edw_log.put_line('Completed Push_EDW_PROJ_CLS4_LSTG');

784:
785: commit;
786:
787: if g_debug_flag = 'Y' then
788: edw_log.put_line('Completed Push_EDW_PROJ_CLS4_LSTG');
789: end if;
790:
791: Exception
792:

Line 809: edw_log.put_line('Starting Push_EDW_PROJ_CLS5_LSTG');

805:
806: BEGIN
807:
808: if g_debug_flag = 'Y' then
809: edw_log.put_line('Starting Push_EDW_PROJ_CLS5_LSTG');
810: end if;
811:
812: l_date1 := p_from_date;
813: l_date2 := p_to_date;

Line 854: edw_log.put_line('Commiting records for EDW_PROJ_CLS5_LSTG');

850: l_rows_inserted := sql%rowcount;
851: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
852:
853: if g_debug_flag = 'Y' then
854: edw_log.put_line('Commiting records for EDW_PROJ_CLS5_LSTG');
855: end if;
856:
857: commit;
858:

Line 860: edw_log.put_line('Completed Push_EDW_PROJ_CLS5_LSTG');

856:
857: commit;
858:
859: if g_debug_flag = 'Y' then
860: edw_log.put_line('Completed Push_EDW_PROJ_CLS5_LSTG');
861: end if;
862:
863: Exception
864:

Line 881: edw_log.put_line('Starting Push_EDW_PROJ_CLS6_LSTG');

877:
878: BEGIN
879:
880: if g_debug_flag = 'Y' then
881: edw_log.put_line('Starting Push_EDW_PROJ_CLS6_LSTG');
882: end if;
883:
884: l_date1 := p_from_date;
885: l_date2 := p_to_date;

Line 926: edw_log.put_line('Commiting records for EDW_PROJ_CLS6_LSTG');

922: l_rows_inserted := sql%rowcount;
923: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
924:
925: if g_debug_flag = 'Y' then
926: edw_log.put_line('Commiting records for EDW_PROJ_CLS6_LSTG');
927: end if;
928:
929: commit;
930:

Line 932: edw_log.put_line('Completed Push_EDW_PROJ_CLS6_LSTG');

928:
929: commit;
930:
931: if g_debug_flag = 'Y' then
932: edw_log.put_line('Completed Push_EDW_PROJ_CLS6_LSTG');
933: end if;
934:
935: Exception
936:

Line 953: edw_log.put_line('Starting Push_EDW_PROJ_CLS7_LSTG');

949:
950: BEGIN
951:
952: if g_debug_flag = 'Y' then
953: edw_log.put_line('Starting Push_EDW_PROJ_CLS7_LSTG');
954: end if;
955:
956: l_date1 := p_from_date;
957: l_date2 := p_to_date;

Line 998: edw_log.put_line('Commiting records for EDW_PROJ_CLS7_LSTG');

994: l_rows_inserted := sql%rowcount;
995: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
996:
997: if g_debug_flag = 'Y' then
998: edw_log.put_line('Commiting records for EDW_PROJ_CLS7_LSTG');
999: end if;
1000:
1001: commit;
1002:

Line 1004: edw_log.put_line('Completed Push_EDW_PROJ_CLS7_LSTG');

1000:
1001: commit;
1002:
1003: if g_debug_flag = 'Y' then
1004: edw_log.put_line('Completed Push_EDW_PROJ_CLS7_LSTG');
1005: end if;
1006:
1007: Exception
1008:

Line 1025: edw_log.put_line('Starting Push_EDW_PROJ_CATEG1_LSTG');

1021:
1022: BEGIN
1023:
1024: if g_debug_flag = 'Y' then
1025: edw_log.put_line('Starting Push_EDW_PROJ_CATEG1_LSTG');
1026: end if;
1027:
1028: l_date1 := p_from_date;
1029: l_date2 := p_to_date;

Line 1070: edw_log.put_line('Commiting records for EDW_PROJ_CATEG1_LSTG');

1066: l_rows_inserted := sql%rowcount;
1067: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1068:
1069: if g_debug_flag = 'Y' then
1070: edw_log.put_line('Commiting records for EDW_PROJ_CATEG1_LSTG');
1071: end if;
1072:
1073: commit;
1074:

Line 1076: edw_log.put_line('Completed Push_EDW_PROJ_CATEG1_LSTG');

1072:
1073: commit;
1074:
1075: if g_debug_flag = 'Y' then
1076: edw_log.put_line('Completed Push_EDW_PROJ_CATEG1_LSTG');
1077: end if;
1078:
1079: Exception
1080:

Line 1097: edw_log.put_line('Starting Push_EDW_PROJ_CATEG2_LSTG');

1093:
1094: BEGIN
1095:
1096: if g_debug_flag = 'Y' then
1097: edw_log.put_line('Starting Push_EDW_PROJ_CATEG2_LSTG');
1098: end if;
1099:
1100: l_date1 := p_from_date;
1101: l_date2 := p_to_date;

Line 1142: edw_log.put_line('Commiting records for EDW_PROJ_CATEG2_LSTG');

1138: l_rows_inserted := sql%rowcount;
1139: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1140:
1141: if g_debug_flag = 'Y' then
1142: edw_log.put_line('Commiting records for EDW_PROJ_CATEG2_LSTG');
1143: end if;
1144:
1145: commit;
1146:

Line 1148: edw_log.put_line('Completed Push_EDW_PROJ_CATEG2_LSTG');

1144:
1145: commit;
1146:
1147: if g_debug_flag = 'Y' then
1148: edw_log.put_line('Completed Push_EDW_PROJ_CATEG2_LSTG');
1149: end if;
1150:
1151: Exception
1152:

Line 1168: edw_log.put_line('Starting Push_EDW_PROJ_CATEG3_LSTG');

1164:
1165: BEGIN
1166:
1167: if g_debug_flag = 'Y' then
1168: edw_log.put_line('Starting Push_EDW_PROJ_CATEG3_LSTG');
1169: end if;
1170:
1171: l_date1 := p_from_date;
1172: l_date2 := p_to_date;

Line 1213: edw_log.put_line('Commiting records for EDW_PROJ_CATEG3_LSTG');

1209: l_rows_inserted := sql%rowcount;
1210: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1211:
1212: if g_debug_flag = 'Y' then
1213: edw_log.put_line('Commiting records for EDW_PROJ_CATEG3_LSTG');
1214: end if;
1215:
1216: commit;
1217:

Line 1219: edw_log.put_line('Completed Push_EDW_PROJ_CATEG3_LSTG');

1215:
1216: commit;
1217:
1218: if g_debug_flag = 'Y' then
1219: edw_log.put_line('Completed Push_EDW_PROJ_CATEG3_LSTG');
1220: end if;
1221:
1222: Exception
1223:

Line 1240: edw_log.put_line('Starting Push_EDW_PROJ_CATEG4_LSTG');

1236:
1237: BEGIN
1238:
1239: if g_debug_flag = 'Y' then
1240: edw_log.put_line('Starting Push_EDW_PROJ_CATEG4_LSTG');
1241: end if;
1242:
1243: l_date1 := p_from_date;
1244: l_date2 := p_to_date;

Line 1285: edw_log.put_line('Commiting records for EDW_PROJ_CATEG4_LSTG');

1281: l_rows_inserted := sql%rowcount;
1282: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1283:
1284: if g_debug_flag = 'Y' then
1285: edw_log.put_line('Commiting records for EDW_PROJ_CATEG4_LSTG');
1286: end if;
1287:
1288: commit;
1289:

Line 1291: edw_log.put_line('Completed Push_EDW_PROJ_CATEG4_LSTG');

1287:
1288: commit;
1289:
1290: if g_debug_flag = 'Y' then
1291: edw_log.put_line('Completed Push_EDW_PROJ_CATEG4_LSTG');
1292: end if;
1293:
1294: Exception
1295:

Line 1312: edw_log.put_line('Starting Push_EDW_PROJ_CATEG5_LSTG');

1308:
1309: BEGIN
1310:
1311: if g_debug_flag = 'Y' then
1312: edw_log.put_line('Starting Push_EDW_PROJ_CATEG5_LSTG');
1313: end if;
1314:
1315: l_date1 := p_from_date;
1316: l_date2 := p_to_date;

Line 1357: edw_log.put_line('Commiting records for EDW_PROJ_CATEG5_LSTG');

1353: l_rows_inserted := sql%rowcount;
1354: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1355:
1356: if g_debug_flag = 'Y' then
1357: edw_log.put_line('Commiting records for EDW_PROJ_CATEG5_LSTG');
1358: end if;
1359:
1360: commit;
1361:

Line 1363: edw_log.put_line('Completed Push_EDW_PROJ_CATEG5_LSTG');

1359:
1360: commit;
1361:
1362: if g_debug_flag = 'Y' then
1363: edw_log.put_line('Completed Push_EDW_PROJ_CATEG5_LSTG');
1364: end if;
1365:
1366: Exception
1367:

Line 1384: edw_log.put_line('Starting Push_EDW_PROJ_CATEG6_LSTG');

1380:
1381: BEGIN
1382:
1383: if g_debug_flag = 'Y' then
1384: edw_log.put_line('Starting Push_EDW_PROJ_CATEG6_LSTG');
1385: end if;
1386:
1387: l_date1 := p_from_date;
1388: l_date2 := p_to_date;

Line 1429: edw_log.put_line('Commiting records for EDW_PROJ_CATEG6_LSTG');

1425: l_rows_inserted := sql%rowcount;
1426: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1427:
1428: if g_debug_flag = 'Y' then
1429: edw_log.put_line('Commiting records for EDW_PROJ_CATEG6_LSTG');
1430: end if;
1431:
1432: commit;
1433:

Line 1435: edw_log.put_line('Completed Push_EDW_PROJ_CATEG6_LSTG');

1431:
1432: commit;
1433:
1434: if g_debug_flag = 'Y' then
1435: edw_log.put_line('Completed Push_EDW_PROJ_CATEG6_LSTG');
1436: end if;
1437:
1438: Exception
1439:

Line 1456: edw_log.put_line('Starting Push_EDW_PROJ_CATEG7_LSTG');

1452:
1453: BEGIN
1454:
1455: if g_debug_flag = 'Y' then
1456: edw_log.put_line('Starting Push_EDW_PROJ_CATEG7_LSTG');
1457: end if;
1458:
1459: l_date1 := p_from_date;
1460: l_date2 := p_to_date;

Line 1501: edw_log.put_line('Commiting records for EDW_PROJ_CATEG7_LSTG');

1497: l_rows_inserted := sql%rowcount;
1498: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1499:
1500: if g_debug_flag = 'Y' then
1501: edw_log.put_line('Commiting records for EDW_PROJ_CATEG7_LSTG');
1502: end if;
1503:
1504: commit;
1505:

Line 1507: edw_log.put_line('Completed Push_EDW_PROJ_CATEG7_LSTG');

1503:
1504: commit;
1505:
1506: if g_debug_flag = 'Y' then
1507: edw_log.put_line('Completed Push_EDW_PROJ_CATEG7_LSTG');
1508: end if;
1509:
1510: Exception
1511: