APPS.CN_NOTIFY_CLAWBACKS dependencies on CN_MESSAGE_PKG

Line 40: cn_message_pkg.debug('notify_clawbacks>>');

36: END IF;
37: cn_debug.print_msg('>>notify_clawbacks', 1);
38: -- who.set_program_name('notify_clawbacks');
39:
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,

Line 79: cn_message_pkg.debug('notify_clawbacks: Is collecting clawbacks for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

75: -- Note: Here we are looking for payment schedules against transactions
76: -- that would have initially been picked up by the invoice notification
77: -- code= cnnoinvb.pls.
78:
79: cn_message_pkg.debug('notify_clawbacks: Is collecting clawbacks for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
80: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks: Is collecting clawbacks for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
81:
82: OPEN batch_size;
83: FETCH batch_size INTO l_sys_batch_size;

Line 149: cn_message_pkg.debug('notify_clawbacks: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');

145: 'Finished notification run: Notified ' || x_trx_count || ' clawbacks.');
146:
147: IF ( x_trx_count = 0 ) THEN
148:
149: cn_message_pkg.debug('notify_clawbacks: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
150: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
151:
152: END IF;
153:

Line 156: cn_message_pkg.debug('notify_clawbacks: Finished notification run: Notified ' || x_trx_count || ' clawbacks.');

152: END IF;
153:
154: COMMIT;
155:
156: cn_message_pkg.debug('notify_clawbacks: Finished notification run: Notified ' || x_trx_count || ' clawbacks.');
157: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks: Finished notification run: Notified ' || x_trx_count || ' clawbacks.');
158:
159: cn_debug.print_msg('< 160:

Line 161: cn_message_pkg.debug('notify_clawbacks<<');

157: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks: Finished notification run: Notified ' || x_trx_count || ' clawbacks.');
158:
159: cn_debug.print_msg('< 160:
161: cn_message_pkg.debug('notify_clawbacks<<');
162: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks<<');
163:
164: cn_message_pkg.end_batch (x_proc_audit_id);
165:

Line 164: cn_message_pkg.end_batch (x_proc_audit_id);

160:
161: cn_message_pkg.debug('notify_clawbacks<<');
162: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks<<');
163:
164: cn_message_pkg.end_batch (x_proc_audit_id);
165:
166: EXCEPTION
167: WHEN OTHERS THEN ROLLBACK;
168:

Line 169: cn_message_pkg.debug('notify_clawbacks: in exception handler');

165:
166: EXCEPTION
167: WHEN OTHERS THEN ROLLBACK;
168:
169: cn_message_pkg.debug('notify_clawbacks: in exception handler');
170: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks: in exception handler');
171:
172: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
173: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

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

168:
169: cn_message_pkg.debug('notify_clawbacks: in exception handler');
170: fnd_file.put_line(fnd_file.Log, 'notify_clawbacks: in exception handler');
171:
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,

Line 178: cn_message_pkg.end_batch (x_proc_audit_id);

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;
181:
182: END notify;