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 CN_MESSAGE_PKG

Line 39: cn_message_pkg.debug('notify_aia_om>>');

35: END IF;
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,

Line 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 ||'.');

59: x_org_id,
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 ||'.');

Line 66: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');

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:
69:
70: OPEN batch_size;

Line 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.');

135: 'Finished notification run: Notified ' || x_trx_count || ' aia order records.');
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;

Line 147: cn_message_pkg.debug('notify_aia_om: Finished notification run: Notified ' || x_trx_count || ' aia order records.');

143: END IF;
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:

Line 152: cn_message_pkg.debug('notify_aia_om<<');

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<<');
153: fnd_file.put_line(fnd_file.Log, 'notify_aia_om<<');
154:
155: cn_message_pkg.end_batch (x_proc_audit_id);
156:

Line 155: cn_message_pkg.end_batch (x_proc_audit_id);

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
158: WHEN OTHERS THEN ROLLBACK;
159: cn_debug.print_msg('notify_aia_om: in exception handler', 1);

Line 163: cn_message_pkg.debug('notify_aia_om: in exception handler');

159: cn_debug.print_msg('notify_aia_om: in exception handler', 1);
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);

Line 166: cn_message_pkg.debug(SQLCODE||' '||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:
169: cn_message_pkg.end_batch (x_proc_audit_id);
170:

Line 169: cn_message_pkg.end_batch (x_proc_audit_id);

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;
172:
173: END notify;

Line 216: cn_message_pkg.debug('notify_aia_om : notify_failed_trx>>');

212: cn_debug.init_pipe(debug_pipe, debug_level);
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,

Line 227: cn_message_pkg.debug('notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected

223: x_start_date,
224: x_end_date);
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:

Line 234: cn_message_pkg.debug('notify_aia_om: Is collecting failed aia order records for notification batch id '|| p_batch_id ||'.');

230: in CN_COMM_LINES_API from period '||x_start_date ||' to period '||x_end_date ||'.');
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);

Line 247: cn_message_pkg.debug('notify_aia_om : notify_failed_trx : Original_order_number : ' || fl_trx_Ord_tbl(indx).original_order_number ||

243:
244: FOR indx IN 1 .. fl_trx_Ord_tbl.COUNT
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:

Line 261: cn_message_pkg.debug('notify_aia_om : notify_failed_trx<<');

257:
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

Line 269: cn_message_pkg.debug('notify_aia_om: notify_failed_trx : in exception handler');

265: EXCEPTION
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);

Line 272: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);

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:
275: app_exception.raise_exception;
276: