APPS.CN_UPG_PMT_REASONS_PKG dependencies on FND_FILE

Line 98: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);

94: raise_application_error(-20001,
95: 'Cannot get schema name for product : '||l_product);
96: end if;
97:
98: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);
99: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
100:
101: --
102: -- Worker processing

Line 99: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);

95: 'Cannot get schema name for product : '||l_product);
96: end if;
97:
98: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);
99: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
100:
101: --
102: -- Worker processing
103: --

Line 141: fnd_file.put_line(FND_FILE.LOG, 'About to clean out dangling junk records');

137: --
138: -- Code your update logic here
139: --
140: -- clean out dangling junk records
141: fnd_file.put_line(FND_FILE.LOG, 'About to clean out dangling junk records');
142: delete /*+ ROWID(r) */ from cn_reasons_all r
143: where rowid between l_start_rowid and l_end_rowid
144: and (updated_table = 'CN_PAYMENT_WORKSHEETS' and not exists
145: (select 1 from cn_payment_worksheets_all

Line 152: fnd_file.put_line(FND_FILE.LOG, 'About to collect data to upgrade');

148: (select 1 from cn_payruns_all
149: where payrun_id = upd_table_id));
150:
151: -- collect data to upgrade
152: fnd_file.put_line(FND_FILE.LOG, 'About to collect data to upgrade');
153: open get_reasons;
154: fetch get_reasons bulk collect into
155: l_upd_id_tbl, l_upd_tbl, l_note_tbl, l_note_type_tbl, l_reas_id_tbl,
156: l_cre_by_tbl, l_cre_date_tbl, x_note_id_tbl,l_rowid_tbl;

Line 158: fnd_file.put_line(FND_FILE.LOG, 'Finished collecting data to upgrade');

154: fetch get_reasons bulk collect into
155: l_upd_id_tbl, l_upd_tbl, l_note_tbl, l_note_type_tbl, l_reas_id_tbl,
156: l_cre_by_tbl, l_cre_date_tbl, x_note_id_tbl,l_rowid_tbl;
157: close get_reasons;
158: fnd_file.put_line(FND_FILE.LOG, 'Finished collecting data to upgrade');
159:
160: -- if any records to process
161: if l_upd_id_tbl.count > 0 then
162: fnd_file.put_line(FND_FILE.LOG, 'About to create notes ' || l_upd_id_tbl.count);

Line 162: fnd_file.put_line(FND_FILE.LOG, 'About to create notes ' || l_upd_id_tbl.count);

158: fnd_file.put_line(FND_FILE.LOG, 'Finished collecting data to upgrade');
159:
160: -- if any records to process
161: if l_upd_id_tbl.count > 0 then
162: fnd_file.put_line(FND_FILE.LOG, 'About to create notes ' || l_upd_id_tbl.count);
163: for c in l_upd_id_tbl.first..l_upd_id_tbl.last loop
164: -- create JTF note
165: jtf_notes_pub.create_note
166: (p_api_version => 1.0,