DBA Data[Home] [Help]

APPS.CN_NOTIFY_AIA_OM dependencies on CN_PROCESS_AUDITS_PKG

Line 43: cn_process_audits_pkg.insert_row(x_rowid,

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,
45: NULL,
46: 'NOT',
47: 'Notification run',

Line 131: cn_process_audits_pkg.update_row(x_proc_audit_id,

127:
128:
129: x_trx_count := SQL%ROWCOUNT;
130:
131: cn_process_audits_pkg.update_row(x_proc_audit_id,
132: NULL,
133: SYSDATE,
134: 0,
135: 'Finished notification run: Notified ' || x_trx_count || ' aia order records.');

Line 160: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,

156:
157: EXCEPTION
158: WHEN OTHERS THEN ROLLBACK;
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');