APPS.FII_AP_TRANS_BACKLOG_SUM_C dependencies on EDW_LOG

Line 22: edw_log.put_line('Truncate table FII_AP_TRANS_BACKLOG_SUMMARY');

18: l_state VARCHAR2(100);
19: Begin
20:
21: if g_debug_flag = 'Y' then
22: edw_log.put_line('Truncate table FII_AP_TRANS_BACKLOG_SUMMARY');
23: end if;
24:
25: l_state := 'Truncate FII_AP_TRANS_BACKLOG_SUMMARY';
26: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_TRANS_BACKLOG_SUMMARY';

Line 29: edw_log.debug_line('');

25: l_state := 'Truncate FII_AP_TRANS_BACKLOG_SUMMARY';
26: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_TRANS_BACKLOG_SUMMARY';
27:
28: if g_debug_flag = 'Y' then
29: edw_log.debug_line('');
30: edw_log.debug_line(l_stmt);
31: end if;
32: execute immediate l_stmt;
33:

Line 30: edw_log.debug_line(l_stmt);

26: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_TRANS_BACKLOG_SUMMARY';
27:
28: if g_debug_flag = 'Y' then
29: edw_log.debug_line('');
30: edw_log.debug_line(l_stmt);
31: end if;
32: execute immediate l_stmt;
33:
34: if g_debug_flag = 'Y' then

Line 35: edw_log.put_line('Populate table FII_AP_TRANS_BACKLOG_SUMMARY');

31: end if;
32: execute immediate l_stmt;
33:
34: if g_debug_flag = 'Y' then
35: edw_log.put_line('Populate table FII_AP_TRANS_BACKLOG_SUMMARY');
36: end if;
37: l_state := 'Insert into FII_AP_TRANS_BACKLOG_SUMMARY';
38: l_stmt := 'insert into '||g_fii_schema||'.FII_AP_TRANS_BACKLOG_SUMMARY (
39: operating_unit_pk_key,

Line 79: edw_log.debug_line('');

75: AND schp.supplier_fk_key > 0
76: AND schp.inv_fk_key > 0';
77:
78: if g_debug_flag = 'Y' then
79: edw_log.debug_line('');
80: edw_log.debug_line(l_stmt);
81: end if;
82: execute immediate l_stmt;
83:

Line 80: edw_log.debug_line(l_stmt);

76: AND schp.inv_fk_key > 0';
77:
78: if g_debug_flag = 'Y' then
79: edw_log.debug_line('');
80: edw_log.debug_line(l_stmt);
81: end if;
82: execute immediate l_stmt;
83:
84: if g_debug_flag = 'Y' then

Line 85: edw_log.put_line('Inserted ' || sql%rowcount || ' rows into FII_AP_TRANS_BACKLOG_SUMMARY');

81: end if;
82: execute immediate l_stmt;
83:
84: if g_debug_flag = 'Y' then
85: edw_log.put_line('Inserted ' || sql%rowcount || ' rows into FII_AP_TRANS_BACKLOG_SUMMARY');
86: end if;
87:
88: EXCEPTION
89: WHEN OTHERS THEN

Line 94: edw_log.put_line('Error occured while ' || l_state);

90: g_errbuf:=sqlerrm;
91: g_retcode:=sqlcode;
92: g_exception_msg := g_retcode || ':' || g_errbuf;
93: if g_debug_flag = 'Y' then
94: edw_log.put_line('Error occured while ' || l_state);
95: edw_log.put_line(g_exception_msg);
96: end if;
97: raise;
98:

Line 95: edw_log.put_line(g_exception_msg);

91: g_retcode:=sqlcode;
92: g_exception_msg := g_retcode || ':' || g_errbuf;
93: if g_debug_flag = 'Y' then
94: edw_log.put_line('Error occured while ' || l_state);
95: edw_log.put_line(g_exception_msg);
96: end if;
97: raise;
98:
99: END POPULATE_FII_AP_TR_BLG_SUMMARY;

Line 117: edw_log.g_debug := TRUE;

113: EXECUTE IMMEDIATE l_stmt;
114:
115: -- DEBUG
116: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
117: edw_log.g_debug := TRUE;
118: END IF;
119:
120: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
121: if l_dir is null then

Line 120: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

116: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
117: edw_log.g_debug := TRUE;
118: END IF;
119:
120: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
121: if l_dir is null then
122: l_dir:='/sqlcom/log';
123: end if;
124:

Line 126: edw_log.put_names('FII_AP_TR_BKLG_SUMMARY.log','FII_AP_TR_BKLG_SUMMARY.out',l_dir);

122: l_dir:='/sqlcom/log';
123: end if;
124:
125: if g_debug_flag = 'Y' then
126: edw_log.put_names('FII_AP_TR_BKLG_SUMMARY.log','FII_AP_TR_BKLG_SUMMARY.out',l_dir);
127:
128:
129: fii_util.put_timestamp;
130: end if;