DBA Data[Home] [Help]

APPS.CN_NOTIFY_AIA dependencies on CN_PROCESS_AUDITS_PKG

Line 43: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,

39: cn_message_pkg.debug('notify_aia>>');
40: fnd_file.put_line(fnd_file.Log, 'notify_aia>>');
41:
42: x_proc_audit_id := NULL; -- Will get a value in the call below
43: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,
44: 'NOT', 'Notification run', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);
45:
46: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,
47: x_start_date, x_end_date);

Line 97: cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0,

93:
94:
95: x_trx_count := SQL%ROWCOUNT;
96:
97: cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0,
98: 'Finished notification run: Notified ' || x_trx_count || ' aia records.');
99:
100: IF ( x_trx_count = 0 ) THEN
101:

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

119:
120: EXCEPTION
121: WHEN OTHERS THEN ROLLBACK;
122: cn_debug.print_msg('notify_aia: in exception handler', 1);
123: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
124: SQLERRM);
125:
126: cn_message_pkg.debug('notify_aia: in exception handler');
127: fnd_file.put_line(fnd_file.Log, 'notify_aia: in exception handler');