APPS.FII_PA_BUDGET_M_C dependencies on EDW_LOG

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

42: FII_PA_BUDGET_M_C.g_push_date_range2 :=
43: 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_PA_BUDGET_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PA_BUDGET_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_PA_BUDGET_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PA_BUDGET_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 70: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

66:
67: l_duration := sysdate - l_temp_date;
68:
69: if g_debug_flag = 'Y' then
70: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
71: edw_log.put_line(' ');
72: end if;
73:
74: -- ---------------------------------------------------------------------------

Line 71: edw_log.put_line(' ');

67: l_duration := sysdate - l_temp_date;
68:
69: if g_debug_flag = 'Y' then
70: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
71: edw_log.put_line(' ');
72: end if;
73:
74: -- ---------------------------------------------------------------------------
75: -- END OF Collection , Developer Customizable Section

Line 99: edw_log.put_line('Starting Push_FII_PA_PABU_BUDGET_LSTG');

95: l_rows_inserted NUMBER :=0;
96: BEGIN
97:
98: if g_debug_flag = 'Y' then
99: edw_log.put_line('Starting Push_FII_PA_PABU_BUDGET_LSTG');
100: end if;
101:
102: l_date1 := p_from_date;
103: l_date2 := p_to_date;

Line 153: edw_log.put_line('Commiting records for FII_PA_PABU_BUDGET_LSTG');

149: l_rows_inserted := sql%rowcount;
150: g_row_count := g_row_count + l_rows_inserted ;
151:
152: if g_debug_flag = 'Y' then
153: edw_log.put_line('Commiting records for FII_PA_PABU_BUDGET_LSTG');
154: end if;
155:
156: commit;
157:

Line 159: edw_log.put_line('Completed Push_FII_PA_PABU_BUDGET_LSTG');

155:
156: commit;
157:
158: if g_debug_flag = 'Y' then
159: edw_log.put_line('Completed Push_FII_PA_PABU_BUDGET_LSTG');
160: end if;
161:
162: Exception When others then
163: raise;