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_TIME_M_C dependencies on EDW_LOG

Line 40: edw_log.put_line(' ');

36: FII_TIME_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
37:
38: FII_TIME_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
39:
40: edw_log.put_line(' ');
41: edw_log.put_line('Pushing GL calendar and Enterprise calendar');
42:
43: edw_log.put_line( 'The collection range is from '||
44: to_char(FII_TIME_M_C.g_push_date_range1,'dd-MON-yyyy')||' to '||

Line 41: edw_log.put_line('Pushing GL calendar and Enterprise calendar');

37:
38: FII_TIME_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
39:
40: edw_log.put_line(' ');
41: edw_log.put_line('Pushing GL calendar and Enterprise calendar');
42:
43: edw_log.put_line( 'The collection range is from '||
44: to_char(FII_TIME_M_C.g_push_date_range1,'dd-MON-yyyy')||' to '||
45: to_char(FII_TIME_M_C.g_push_date_range2,'dd-MON-yyyy'));

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

39:
40: edw_log.put_line(' ');
41: edw_log.put_line('Pushing GL calendar and Enterprise calendar');
42:
43: edw_log.put_line( 'The collection range is from '||
44: to_char(FII_TIME_M_C.g_push_date_range1,'dd-MON-yyyy')||' to '||
45: to_char(FII_TIME_M_C.g_push_date_range2,'dd-MON-yyyy'));
46:
47: -- -----------------------------------------------------------------------------

Line 53: edw_log.put_line(' ');

49: -- -----------------------------------------------------------------------------
50:
51: /* Push GL calendar and Enterprise calendar*/
52:
53: edw_log.put_line(' ');
54: l_temp_date := sysdate;
55:
56: Push_gl_and_ent_calendar(FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);
57:

Line 59: edw_log.put_line('GL calendar and Enterprise calendar has been pushed successfully!');

55:
56: Push_gl_and_ent_calendar(FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);
57:
58: l_duration := sysdate - l_temp_date;
59: edw_log.put_line('GL calendar and Enterprise calendar has been pushed successfully!');
60: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
61: edw_log.put_line('-------------------------------------------------------------------------');
62: edw_log.put_line(' ');
63:

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

56: Push_gl_and_ent_calendar(FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);
57:
58: l_duration := sysdate - l_temp_date;
59: edw_log.put_line('GL calendar and Enterprise calendar has been pushed successfully!');
60: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
61: edw_log.put_line('-------------------------------------------------------------------------');
62: edw_log.put_line(' ');
63:
64: /* Push Gregorian calendar */

Line 61: edw_log.put_line('-------------------------------------------------------------------------');

57:
58: l_duration := sysdate - l_temp_date;
59: edw_log.put_line('GL calendar and Enterprise calendar has been pushed successfully!');
60: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
61: edw_log.put_line('-------------------------------------------------------------------------');
62: edw_log.put_line(' ');
63:
64: /* Push Gregorian calendar */
65:

Line 62: edw_log.put_line(' ');

58: l_duration := sysdate - l_temp_date;
59: edw_log.put_line('GL calendar and Enterprise calendar has been pushed successfully!');
60: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
61: edw_log.put_line('-------------------------------------------------------------------------');
62: edw_log.put_line(' ');
63:
64: /* Push Gregorian calendar */
65:
66: edw_log.put_line('Pushing Gregorian calendar');

Line 66: edw_log.put_line('Pushing Gregorian calendar');

62: edw_log.put_line(' ');
63:
64: /* Push Gregorian calendar */
65:
66: edw_log.put_line('Pushing Gregorian calendar');
67: l_temp_date :=sysdate;
68:
69: FII_POPULATE_TIME.Push(errbuf,retcode,rows_inserted,c_from_date,c_to_date);
70:

Line 72: edw_log.put_line('Gregorian calendar has been pushed successfully!');

68:
69: FII_POPULATE_TIME.Push(errbuf,retcode,rows_inserted,c_from_date,c_to_date);
70:
71: l_duration := sysdate - l_temp_date;
72: edw_log.put_line('Gregorian calendar has been pushed successfully!');
73: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
74:
75: g_rows_inserted:=g_rows_inserted+rows_inserted;
76:

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

69: FII_POPULATE_TIME.Push(errbuf,retcode,rows_inserted,c_from_date,c_to_date);
70:
71: l_duration := sysdate - l_temp_date;
72: edw_log.put_line('Gregorian calendar has been pushed successfully!');
73: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
74:
75: g_rows_inserted:=g_rows_inserted+rows_inserted;
76:
77: EDW_COLLECTION_UTIL.wrapup(TRUE, g_rows_inserted, null,

Line 290: edw_log.put_line('Purging the existing staging tables');

286:
287: -- -----------------------------------------------------------------------------
288: -- Clear the staging table before pushing data
289: -- -----------------------------------------------------------------------------
290: edw_log.put_line('Purging the existing staging tables');
291:
292: delete edw_time_cal_period_lstg
293: where instance = l_instance;
294:

Line 335: edw_log.put_line('Purge completed');

331:
332: commit;
333: END IF;
334:
335: edw_log.put_line('Purge completed');
336: edw_log.put_line(' ');
337:
338: -- -----------------------------------------------------------------------------
339: -- Pushing GL calendar

Line 336: edw_log.put_line(' ');

332: commit;
333: END IF;
334:
335: edw_log.put_line('Purge completed');
336: edw_log.put_line(' ');
337:
338: -- -----------------------------------------------------------------------------
339: -- Pushing GL calendar
340: -- Note: 'oracle_source' is populated in enterprise foreign key in order for

Line 343: edw_log.put_line('Pushing GL calendar');

339: -- Pushing GL calendar
340: -- Note: 'oracle_source' is populated in enterprise foreign key in order for
341: -- pre collection hook to differentiate between oracle source and other source
342: -- -----------------------------------------------------------------------------
343: edw_log.put_line('Pushing GL calendar');
344: edw_log.put_line('===================');
345:
346: -- --------------------------------------------------------------
347: -- Populating different parts into calendar day level

Line 344: edw_log.put_line('===================');

340: -- Note: 'oracle_source' is populated in enterprise foreign key in order for
341: -- pre collection hook to differentiate between oracle source and other source
342: -- -----------------------------------------------------------------------------
343: edw_log.put_line('Pushing GL calendar');
344: edw_log.put_line('===================');
345:
346: -- --------------------------------------------------------------
347: -- Populating different parts into calendar day level
348: -- --------------------------------------------------------------

Line 352: edw_log.put_line('Pushing Calendar Day');

348: -- --------------------------------------------------------------
349:
350: /* Population of GL Calendar Day */
351:
352: edw_log.put_line('Pushing Calendar Day');
353: fii_util.start_timer;
354:
355: OPEN gl_date_cursor;
356:

Line 477: edw_log.put_line(' ');

473: END LOOP;
474:
475: fii_util.stop_timer;
476: fii_util.print_timer('Process Time');
477: edw_log.put_line(' ');
478:
479: CLOSE gl_date_cursor;
480:
481:

Line 483: edw_log.put_line('Pushing Future Calendar Days');

479: CLOSE gl_date_cursor;
480:
481:
482:
483: edw_log.put_line('Pushing Future Calendar Days');
484:
485: fii_util.start_timer;
486:
487:

Line 577: edw_log.put_line(' ');

573:
574:
575: fii_util.stop_timer;
576: fii_util.print_timer('Process Time');
577: edw_log.put_line(' ');
578:
579: CLOSE gl_future_date_cursor;
580:
581:

Line 585: edw_log.put_line('Pushing PA Calendar Day');

581:
582:
583: /* Population of PA Calendar Day */
584:
585: edw_log.put_line('Pushing PA Calendar Day');
586: fii_util.start_timer;
587:
588: OPEN pa_date_cursor;
589:

Line 666: edw_log.put_line(' ');

662:
663: commit;
664: fii_util.stop_timer;
665: fii_util.print_timer('Process Time');
666: edw_log.put_line(' ');
667:
668: CLOSE pa_date_cursor;
669:
670:

Line 673: edw_log.put_line('Pushing PA Period push down');

669:
670:
671: /* Population of PA Period push down */
672:
673: edw_log.put_line('Pushing PA Period push down');
674: fii_util.start_timer;
675:
676: OPEN pa_period_cursor;
677:

Line 743: edw_log.put_line(' ');

739:
740: commit;
741: fii_util.stop_timer;
742: fii_util.print_timer('Process Time');
743: edw_log.put_line(' ');
744:
745: CLOSE pa_period_cursor;
746:
747:

Line 750: edw_log.put_line('Pushing GL Period push down to Calendar Day');

746:
747:
748: /* Population of GL Period push down*/
749:
750: edw_log.put_line('Pushing GL Period push down to Calendar Day');
751: fii_util.start_timer;
752:
753: OPEN cal_period_cursor;
754:

Line 817: edw_log.put_line(' ');

813:
814: commit;
815: fii_util.stop_timer;
816: fii_util.print_timer('Process Time');
817: edw_log.put_line(' ');
818:
819: CLOSE cal_period_cursor;
820:
821:

Line 828: edw_log.put_line('Pushing PA Period');

824: -- --------------------------------------------------
825:
826: /* Population of PA Period */
827:
828: edw_log.put_line('Pushing PA Period');
829: fii_util.start_timer;
830:
831: OPEN pa_period_cursor;
832:

Line 874: edw_log.put_line(' ');

870:
871: commit;
872: fii_util.stop_timer;
873: fii_util.print_timer('Process Time');
874: edw_log.put_line(' ');
875:
876: CLOSE pa_period_cursor;
877:
878:

Line 881: edw_log.put_line('Pushing GL Period push down to PA Period');

877:
878:
879: /* Population of GL Period pushed down to PA period level*/
880:
881: edw_log.put_line('Pushing GL Period push down to PA Period');
882: fii_util.start_timer;
883:
884: OPEN cal_period_cursor;
885:

Line 929: edw_log.put_line(' ');

925:
926: commit;
927: fii_util.stop_timer;
928: fii_util.print_timer('Process Time');
929: edw_log.put_line(' ');
930:
931: CLOSE cal_period_cursor;
932:
933:

Line 938: edw_log.put_line('Pushing GL Period');

934: -- --------------------------------------------------
935: -- Populating GL Period Level
936: -- --------------------------------------------------
937:
938: edw_log.put_line('Pushing GL Period');
939: fii_util.start_timer;
940:
941: OPEN cal_period_cursor;
942:

Line 986: edw_log.put_line(' ');

982:
983: commit;
984: fii_util.stop_timer;
985: fii_util.print_timer('Process Time');
986: edw_log.put_line(' ');
987:
988: CLOSE cal_period_cursor;
989:
990: -- --------------------------------------------------

Line 994: edw_log.put_line('Pushing GL Quarter');

990: -- --------------------------------------------------
991: -- Populating GL Quarter Level
992: -- --------------------------------------------------
993:
994: edw_log.put_line('Pushing GL Quarter');
995: fii_util.start_timer;
996: l_quarter_name:=fnd_message.get_string('FII', 'FII_AR_QUARTER');
997:
998: OPEN gl_quarters;

Line 1043: edw_log.put_line(' ');

1039:
1040: commit;
1041: fii_util.stop_timer;
1042: fii_util.print_timer('Process Time');
1043: edw_log.put_line(' ');
1044:
1045: CLOSE gl_quarters;
1046:
1047:

Line 1052: edw_log.put_line('Pushing GL Year');

1048: -- --------------------------------------------------
1049: -- Populating GL Year Level
1050: -- --------------------------------------------------
1051:
1052: edw_log.put_line('Pushing GL Year');
1053: fii_util.start_timer;
1054:
1055: OPEN gl_years;
1056:

Line 1097: edw_log.put_line(' ');

1093:
1094: commit;
1095: fii_util.stop_timer;
1096: fii_util.print_timer('Process Time');
1097: edw_log.put_line(' ');
1098:
1099: CLOSE gl_years;
1100:
1101:

Line 1106: edw_log.put_line('Pushing GL Calendar Name');

1102: -- --------------------------------------------------
1103: -- Populating GL Calendar Name Level
1104: -- --------------------------------------------------
1105:
1106: edw_log.put_line('Pushing GL Calendar Name');
1107: fii_util.start_timer;
1108:
1109: insert into EDW_TIME_CAL_NAME_LSTG(
1110: CAL_NAME_PK ,

Line 1139: edw_log.put_line(' ');

1135: l_row_name:=l_row_name+sql%rowcount;
1136: commit;
1137: fii_util.stop_timer;
1138: fii_util.print_timer('Process Time');
1139: edw_log.put_line(' ');
1140:
1141: -- -----------------------------------------------------------------------------
1142: -- Write result to log file
1143: -- -----------------------------------------------------------------------------

Line 1148: edw_log.put_line(' ');

1144:
1145: /* for Status Viewer to verify the pushed record number */
1146: g_rows_inserted:=l_row_cday;
1147:
1148: edw_log.put_line(' ');
1149: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');
1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');

Line 1149: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');

1145: /* for Status Viewer to verify the pushed record number */
1146: g_rows_inserted:=l_row_cday;
1147:
1148: edw_log.put_line(' ');
1149: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');
1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');
1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');

Line 1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');

1146: g_rows_inserted:=l_row_cday;
1147:
1148: edw_log.put_line(' ');
1149: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');
1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');
1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');
1154: edw_log.put_line(to_char(l_row_name)||' records has been pushed to Calendar Name');

Line 1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');

1147:
1148: edw_log.put_line(' ');
1149: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');
1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');
1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');
1154: edw_log.put_line(to_char(l_row_name)||' records has been pushed to Calendar Name');
1155: edw_log.put_line(' ');

Line 1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');

1148: edw_log.put_line(' ');
1149: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');
1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');
1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');
1154: edw_log.put_line(to_char(l_row_name)||' records has been pushed to Calendar Name');
1155: edw_log.put_line(' ');
1156:

Line 1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');

1149: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');
1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');
1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');
1154: edw_log.put_line(to_char(l_row_name)||' records has been pushed to Calendar Name');
1155: edw_log.put_line(' ');
1156:
1157: -- -----------------------------------------------------------------------------

Line 1154: edw_log.put_line(to_char(l_row_name)||' records has been pushed to Calendar Name');

1150: edw_log.put_line(to_char(l_row_pa)||' records has been pushed to PA Period');
1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');
1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');
1154: edw_log.put_line(to_char(l_row_name)||' records has been pushed to Calendar Name');
1155: edw_log.put_line(' ');
1156:
1157: -- -----------------------------------------------------------------------------
1158: -- Pushing Enterprise calendar

Line 1155: edw_log.put_line(' ');

1151: edw_log.put_line(to_char(l_row_cal)||' records has been pushed to GL Period');
1152: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to GL Quarter');
1153: edw_log.put_line(to_char(l_row_year)||' records has been pushed to GL Year');
1154: edw_log.put_line(to_char(l_row_name)||' records has been pushed to Calendar Name');
1155: edw_log.put_line(' ');
1156:
1157: -- -----------------------------------------------------------------------------
1158: -- Pushing Enterprise calendar
1159: -- -----------------------------------------------------------------------------

Line 1166: edw_log.put_line('Pushing Enterprise calendar');

1162: from edw_local_system_parameters;
1163:
1164: /* Enterprise hierarchy will only be populated if this is the master instance*/
1165: if l_master_instance=l_instance then
1166: edw_log.put_line('Pushing Enterprise calendar');
1167: edw_log.put_line('===========================');
1168:
1169: /* Population of Enterprise Calendar Period */
1170: edw_log.put_line('Pushing Enterprise Calendar Period');

Line 1167: edw_log.put_line('===========================');

1163:
1164: /* Enterprise hierarchy will only be populated if this is the master instance*/
1165: if l_master_instance=l_instance then
1166: edw_log.put_line('Pushing Enterprise calendar');
1167: edw_log.put_line('===========================');
1168:
1169: /* Population of Enterprise Calendar Period */
1170: edw_log.put_line('Pushing Enterprise Calendar Period');
1171: fii_util.start_timer;

Line 1170: edw_log.put_line('Pushing Enterprise Calendar Period');

1166: edw_log.put_line('Pushing Enterprise calendar');
1167: edw_log.put_line('===========================');
1168:
1169: /* Population of Enterprise Calendar Period */
1170: edw_log.put_line('Pushing Enterprise Calendar Period');
1171: fii_util.start_timer;
1172:
1173: INSERT INTO EDW_TIME_EP_CAL_PERIOD_LSTG
1174: (CAL_PERIOD_PK,

Line 1202: edw_log.put_line(' ');

1198:
1199: l_row_ep_cal_period:=l_row_ep_cal_period+sql%rowcount;
1200: fii_util.stop_timer;
1201: fii_util.print_timer('Process Time');
1202: edw_log.put_line(' ');
1203:
1204: /* Population of Enterprise Calendar Quarter */
1205:
1206: edw_log.put_line('Pushing Enterprise Calendar Quarter');

Line 1206: edw_log.put_line('Pushing Enterprise Calendar Quarter');

1202: edw_log.put_line(' ');
1203:
1204: /* Population of Enterprise Calendar Quarter */
1205:
1206: edw_log.put_line('Pushing Enterprise Calendar Quarter');
1207: fii_util.start_timer;
1208: l_quarter_name:=fnd_message.get_string('FII', 'FII_AR_QUARTER');
1209:
1210: INSERT INTO EDW_TIME_EP_CAL_QTR_LSTG

Line 1238: edw_log.put_line(' ');

1234:
1235: l_row_ep_cal_qtr:=l_row_ep_cal_qtr+sql%rowcount;
1236: fii_util.stop_timer;
1237: fii_util.print_timer('Process Time');
1238: edw_log.put_line(' ');
1239:
1240: /* Population of Enterprise Calendar Year */
1241:
1242: edw_log.put_line('Pushing Enterprise Calendar Year');

Line 1242: edw_log.put_line('Pushing Enterprise Calendar Year');

1238: edw_log.put_line(' ');
1239:
1240: /* Population of Enterprise Calendar Year */
1241:
1242: edw_log.put_line('Pushing Enterprise Calendar Year');
1243: fii_util.start_timer;
1244:
1245: INSERT INTO EDW_TIME_EP_CAL_YEAR_LSTG
1246: (CAL_YEAR_PK,

Line 1273: edw_log.put_line(' ');

1269:
1270: l_row_ep_cal_year:=l_row_ep_cal_year+sql%rowcount;
1271: fii_util.stop_timer;
1272: fii_util.print_timer('Process Time');
1273: edw_log.put_line(' ');
1274:
1275: /* Population of Enterprise Calendar Name */
1276:
1277: edw_log.put_line('Pushing Enterprise Calendar Name');

Line 1277: edw_log.put_line('Pushing Enterprise Calendar Name');

1273: edw_log.put_line(' ');
1274:
1275: /* Population of Enterprise Calendar Name */
1276:
1277: edw_log.put_line('Pushing Enterprise Calendar Name');
1278: fii_util.start_timer;
1279:
1280: INSERT INTO EDW_TIME_EP_CAL_NAME_LSTG
1281: (CAL_NAME_PK,

Line 1307: edw_log.put_line(' ');

1303:
1304: l_row_ep_cal_name:=l_row_ep_cal_name+sql%rowcount;
1305: fii_util.stop_timer;
1306: fii_util.print_timer('Process Time');
1307: edw_log.put_line(' ');
1308:
1309: -- -----------------------------------------------------------------------------
1310: -- Write result to log file
1311: -- -----------------------------------------------------------------------------

Line 1313: edw_log.put_line(' ');

1309: -- -----------------------------------------------------------------------------
1310: -- Write result to log file
1311: -- -----------------------------------------------------------------------------
1312:
1313: edw_log.put_line(' ');
1314: edw_log.put_line(to_char(l_row_ep_cal_period)||' records has been pushed to Enterprise Calendar Period');
1315: edw_log.put_line(to_char(l_row_ep_cal_qtr)||' records has been pushed to Enterprise Calendar Quarter');
1316: edw_log.put_line(to_char(l_row_ep_cal_year)||' records has been pushed to Enterprise Calendar Year');
1317: edw_log.put_line(to_char(l_row_ep_cal_name)||' records has been pushed to Enterprise Calendar Name');

Line 1314: edw_log.put_line(to_char(l_row_ep_cal_period)||' records has been pushed to Enterprise Calendar Period');

1310: -- Write result to log file
1311: -- -----------------------------------------------------------------------------
1312:
1313: edw_log.put_line(' ');
1314: edw_log.put_line(to_char(l_row_ep_cal_period)||' records has been pushed to Enterprise Calendar Period');
1315: edw_log.put_line(to_char(l_row_ep_cal_qtr)||' records has been pushed to Enterprise Calendar Quarter');
1316: edw_log.put_line(to_char(l_row_ep_cal_year)||' records has been pushed to Enterprise Calendar Year');
1317: edw_log.put_line(to_char(l_row_ep_cal_name)||' records has been pushed to Enterprise Calendar Name');
1318: edw_log.put_line(' ');

Line 1315: edw_log.put_line(to_char(l_row_ep_cal_qtr)||' records has been pushed to Enterprise Calendar Quarter');

1311: -- -----------------------------------------------------------------------------
1312:
1313: edw_log.put_line(' ');
1314: edw_log.put_line(to_char(l_row_ep_cal_period)||' records has been pushed to Enterprise Calendar Period');
1315: edw_log.put_line(to_char(l_row_ep_cal_qtr)||' records has been pushed to Enterprise Calendar Quarter');
1316: edw_log.put_line(to_char(l_row_ep_cal_year)||' records has been pushed to Enterprise Calendar Year');
1317: edw_log.put_line(to_char(l_row_ep_cal_name)||' records has been pushed to Enterprise Calendar Name');
1318: edw_log.put_line(' ');
1319:

Line 1316: edw_log.put_line(to_char(l_row_ep_cal_year)||' records has been pushed to Enterprise Calendar Year');

1312:
1313: edw_log.put_line(' ');
1314: edw_log.put_line(to_char(l_row_ep_cal_period)||' records has been pushed to Enterprise Calendar Period');
1315: edw_log.put_line(to_char(l_row_ep_cal_qtr)||' records has been pushed to Enterprise Calendar Quarter');
1316: edw_log.put_line(to_char(l_row_ep_cal_year)||' records has been pushed to Enterprise Calendar Year');
1317: edw_log.put_line(to_char(l_row_ep_cal_name)||' records has been pushed to Enterprise Calendar Name');
1318: edw_log.put_line(' ');
1319:
1320: end if;

Line 1317: edw_log.put_line(to_char(l_row_ep_cal_name)||' records has been pushed to Enterprise Calendar Name');

1313: edw_log.put_line(' ');
1314: edw_log.put_line(to_char(l_row_ep_cal_period)||' records has been pushed to Enterprise Calendar Period');
1315: edw_log.put_line(to_char(l_row_ep_cal_qtr)||' records has been pushed to Enterprise Calendar Quarter');
1316: edw_log.put_line(to_char(l_row_ep_cal_year)||' records has been pushed to Enterprise Calendar Year');
1317: edw_log.put_line(to_char(l_row_ep_cal_name)||' records has been pushed to Enterprise Calendar Name');
1318: edw_log.put_line(' ');
1319:
1320: end if;
1321:

Line 1318: edw_log.put_line(' ');

1314: edw_log.put_line(to_char(l_row_ep_cal_period)||' records has been pushed to Enterprise Calendar Period');
1315: edw_log.put_line(to_char(l_row_ep_cal_qtr)||' records has been pushed to Enterprise Calendar Quarter');
1316: edw_log.put_line(to_char(l_row_ep_cal_year)||' records has been pushed to Enterprise Calendar Year');
1317: edw_log.put_line(to_char(l_row_ep_cal_name)||' records has been pushed to Enterprise Calendar Name');
1318: edw_log.put_line(' ');
1319:
1320: end if;
1321:
1322: Exception When others then