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.CN_NOTIFY_AIA_OM dependencies on FND_FILE

Line 40: fnd_file.put_line(fnd_file.Log, 'notify_aia_om>>');

36: cn_debug.print_msg('>>notify_aia_om', 1);
37: -- who.set_program_name('notify_aia_om');
38:
39: cn_message_pkg.debug('notify_aia_om>>');
40: fnd_file.put_line(fnd_file.Log, 'notify_aia_om>>');
41: --
42: x_proc_audit_id := NULL; -- Will get a value in the call below
43: cn_process_audits_pkg.insert_row(x_rowid,
44: x_proc_audit_id,

Line 64: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

60: x_start_date,
61: x_end_date);
62: --
63: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
64: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
65: --
66: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');
67: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');
68:

Line 67: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');

63: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
64: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
65: --
66: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');
67: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');
68:
69:
70: OPEN batch_size;
71: FETCH batch_size INTO l_sys_batch_size;

Line 140: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');

136:
137: IF ( x_trx_count = 0 ) THEN
138:
139: cn_message_pkg.debug('notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
140: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
141:
142:
143: END IF;
144:

Line 148: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Finished notification run: Notified ' || x_trx_count || ' aia order records.');

144:
145: COMMIT;
146:
147: cn_message_pkg.debug('notify_aia_om: Finished notification run: Notified ' || x_trx_count || ' aia order records.');
148: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Finished notification run: Notified ' || x_trx_count || ' aia order records.');
149:
150: cn_debug.print_msg('< 151:
152: cn_message_pkg.debug('notify_aia_om<<');

Line 153: fnd_file.put_line(fnd_file.Log, 'notify_aia_om<<');

149:
150: cn_debug.print_msg('< 151:
152: cn_message_pkg.debug('notify_aia_om<<');
153: fnd_file.put_line(fnd_file.Log, 'notify_aia_om<<');
154:
155: cn_message_pkg.end_batch (x_proc_audit_id);
156:
157: EXCEPTION

Line 164: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: in exception handler');

160: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
161: SQLERRM);
162:
163: cn_message_pkg.debug('notify_aia_om: in exception handler');
164: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: in exception handler');
165:
166: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
167: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
168:

Line 167: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

163: cn_message_pkg.debug('notify_aia_om: in exception handler');
164: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: in exception handler');
165:
166: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
167: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
168:
169: cn_message_pkg.end_batch (x_proc_audit_id);
170:
171: app_exception.raise_exception;

Line 217: fnd_file.put_line(fnd_file.Log, 'notify_aia_om : notify_failed_trx>>');

213: END IF;
214: cn_debug.print_msg('>>notify_aia_om : notify_failed_trx', 1);
215:
216: cn_message_pkg.debug('notify_aia_om : notify_failed_trx>>');
217: fnd_file.put_line(fnd_file.Log, 'notify_aia_om : notify_failed_trx>>');
218:
219: --
220: cn_periods_api.set_dates(x_start_period,
221: x_end_period,

Line 229: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected

225:
226: --
227: cn_message_pkg.debug('notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected
228: in CN_COMM_LINES_API from period '||x_start_date ||' to period '||x_end_date ||'.');
229: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected
230: in CN_COMM_LINES_API from period '||x_start_date ||' to period '||x_end_date ||'.');
231:
232: --
233:

Line 235: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting failed aia order records for notification batch id '|| p_batch_id ||'.');

231:
232: --
233:
234: cn_message_pkg.debug('notify_aia_om: Is collecting failed aia order records for notification batch id '|| p_batch_id ||'.');
235: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting failed aia order records for notification batch id '|| p_batch_id ||'.');
236:
237:
238: OPEN get_failed_trx_cr(x_start_date,x_end_date);
239:

Line 249: fnd_file.put_line(fnd_file.Log, 'notify_aia_om :notify_failed_trx : Original_order_number : ' || fl_trx_Ord_tbl(indx).original_order_number ||

245: LOOP
246:
247: cn_message_pkg.debug('notify_aia_om : notify_failed_trx : Original_order_number : ' || fl_trx_Ord_tbl(indx).original_order_number ||
248: ' : Line Number : ' || fl_trx_Ord_tbl(indx).ln_num);
249: fnd_file.put_line(fnd_file.Log, 'notify_aia_om :notify_failed_trx : Original_order_number : ' || fl_trx_Ord_tbl(indx).original_order_number ||
250: ' : Line Number : ' || fl_trx_Ord_tbl(indx).ln_num);
251:
252: END LOOP;
253:

Line 262: fnd_file.put_line(fnd_file.Log, 'notify_aia_om : notify_failed_trx<<');

258: CLOSE get_failed_trx_cr;
259:
260:
261: cn_message_pkg.debug('notify_aia_om : notify_failed_trx<<');
262: fnd_file.put_line(fnd_file.Log, 'notify_aia_om : notify_failed_trx<<');
263:
264:
265: EXCEPTION
266: WHEN OTHERS THEN

Line 270: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: notify_failed_trx : in exception handler');

266: WHEN OTHERS THEN
267: cn_debug.print_msg('notify_aia_om: notify_failed_trx : in exception handler', 1);
268:
269: cn_message_pkg.debug('notify_aia_om: notify_failed_trx : in exception handler');
270: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: notify_failed_trx : in exception handler');
271:
272: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
273: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
274:

Line 273: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

269: cn_message_pkg.debug('notify_aia_om: notify_failed_trx : in exception handler');
270: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: notify_failed_trx : in exception handler');
271:
272: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
273: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
274:
275: app_exception.raise_exception;
276:
277: END notify_failed_trx;