APPS.CN_NOTIFY_WRITEOFFS dependencies on CN_MESSAGE_PKG

Line 38: cn_message_pkg.debug('notify_writeoffs>>');

34: END IF;
35: cn_debug.print_msg('>>notify_writeoffs', 1);
36: -- who.set_program_name('notify_writeoffs');
37:
38: cn_message_pkg.debug('notify_writeoffs>>');
39: fnd_file.put_line(fnd_file.Log, 'notify_writeoffs>>');
40:
41: x_proc_audit_id := NULL; -- Will get a value in the call below
42: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,

Line 48: cn_message_pkg.debug('notify_writeoffs: Is collecting writeoffs for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

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

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

102: 'Finished notification run: Notified ' || x_trx_count || ' writeoffs.');
103:
104: IF ( x_trx_count = 0 ) THEN
105:
106: cn_message_pkg.debug('notify_writeoffs: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
107: fnd_file.put_line(fnd_file.Log, 'notify_writeoffs: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
108:
109: END IF;
110:

Line 113: cn_message_pkg.debug('notify_writeoffs: Finished notification run: Notified ' || x_trx_count || ' writeoffs.');

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

Line 118: cn_message_pkg.debug('notify_writeoffs<<');

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

Line 121: cn_message_pkg.end_batch (x_proc_audit_id);

117:
118: cn_message_pkg.debug('notify_writeoffs<<');
119: fnd_file.put_line(fnd_file.Log, 'notify_writeoffs<<');
120:
121: cn_message_pkg.end_batch (x_proc_audit_id);
122:
123: EXCEPTION
124: WHEN OTHERS THEN ROLLBACK;
125:

Line 126: cn_message_pkg.debug('notify_writeoffs: in exception handler');

122:
123: EXCEPTION
124: WHEN OTHERS THEN ROLLBACK;
125:
126: cn_message_pkg.debug('notify_writeoffs: in exception handler');
127: fnd_file.put_line(fnd_file.Log, 'notify_writeoffs: in exception handler');
128:
129: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
130: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

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

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

Line 136: cn_message_pkg.end_batch (x_proc_audit_id);

132: cn_debug.print_msg('notify_writeoffs: in exception handler', 1);
133: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
134: SQLERRM);
135:
136: cn_message_pkg.end_batch (x_proc_audit_id);
137:
138: app_exception.raise_exception;
139:
140: END notify;