DBA Data[Home] [Help]

APPS.CN_NOTIFY_CLAWBACKS dependencies on CN_PROCESS_AUDITS_PKG

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

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

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

140:
141:
142: x_trx_count := SQL%ROWCOUNT;
143:
144: cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0,
145: 'Finished notification run: Notified ' || x_trx_count || ' clawbacks.');
146:
147: IF ( x_trx_count = 0 ) THEN
148:

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

172: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
173: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
174:
175: cn_debug.print_msg('notify_clawbacks: in exception handler', 1);
176: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
177: SQLERRM);
178: cn_message_pkg.end_batch (x_proc_audit_id);
179:
180: app_exception.raise_exception;