APPS.CN_NOTIFY_PAYMENTS dependencies on CN_MESSAGE_PKG

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

35: END IF;
36: cn_debug.print_msg('>>notify_payments', 1);
37: -- who.set_program_name('notify_payments');
38:
39: cn_message_pkg.debug('notify_payments>>');
40: fnd_file.put_line(fnd_file.Log, 'notify_payments>>');
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,

Line 49: cn_message_pkg.debug('notify_payments: Is collecting payments for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

45:
46: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,
47: x_start_date, x_end_date);
48:
49: cn_message_pkg.debug('notify_payments: Is collecting payments for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
50: fnd_file.put_line(fnd_file.Log, 'notify_payments: Is collecting payments for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
51:
52: OPEN batch_size;
53: FETCH batch_size INTO l_sys_batch_size;

Line 106: cn_message_pkg.debug('notify_payments: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL and gl_date is null.');

102: 'Finished notification run: Notified ' || x_trx_count || ' payments.');
103:
104: IF ( x_trx_count = 0 ) THEN
105:
106: cn_message_pkg.debug('notify_payments: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL and gl_date is null.');
107: fnd_file.put_line(fnd_file.Log, 'notify_payments: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL and gl_date is null.');
108:
109:
110: END IF;

Line 114: cn_message_pkg.debug('notify_payments: Finished notification run: Notified ' || x_trx_count || ' payments.');

110: END IF;
111:
112: COMMIT;
113:
114: cn_message_pkg.debug('notify_payments: Finished notification run: Notified ' || x_trx_count || ' payments.');
115: fnd_file.put_line(fnd_file.Log, 'notify_payments: Finished notification run: Notified ' || x_trx_count || ' payments.');
116:
117: cn_debug.print_msg('< 118:

Line 119: cn_message_pkg.debug('notify_payments<<');

115: fnd_file.put_line(fnd_file.Log, 'notify_payments: Finished notification run: Notified ' || x_trx_count || ' payments.');
116:
117: cn_debug.print_msg('< 118:
119: cn_message_pkg.debug('notify_payments<<');
120: fnd_file.put_line(fnd_file.Log, 'notify_payments<<');
121:
122: cn_message_pkg.end_batch (x_proc_audit_id);
123:

Line 122: cn_message_pkg.end_batch (x_proc_audit_id);

118:
119: cn_message_pkg.debug('notify_payments<<');
120: fnd_file.put_line(fnd_file.Log, 'notify_payments<<');
121:
122: cn_message_pkg.end_batch (x_proc_audit_id);
123:
124: EXCEPTION
125: WHEN OTHERS THEN ROLLBACK;
126: cn_debug.print_msg('notify_payments: in exception handler', 1);

Line 130: cn_message_pkg.debug('notify_payments: in exception handler');

126: cn_debug.print_msg('notify_payments: in exception handler', 1);
127: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
128: SQLERRM);
129:
130: cn_message_pkg.debug('notify_payments: in exception handler');
131: fnd_file.put_line(fnd_file.Log, 'notify_payments: in exception handler');
132:
133: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
134: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

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

129:
130: cn_message_pkg.debug('notify_payments: in exception handler');
131: fnd_file.put_line(fnd_file.Log, 'notify_payments: in exception handler');
132:
133: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
134: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
135:
136: cn_message_pkg.end_batch (x_proc_audit_id);
137:

Line 136: cn_message_pkg.end_batch (x_proc_audit_id);

132:
133: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
134: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
135:
136: cn_message_pkg.end_batch (x_proc_audit_id);
137:
138: app_exception.raise_exception;
139:
140: END notify;