APPS.CN_NOTIFY_AIA dependencies on CN_MESSAGE_PKG

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

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

Line 49: cn_message_pkg.debug('notify_aia: Is collecting aia records 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_aia: Is collecting aia records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
50: fnd_file.put_line(fnd_file.Log, 'notify_aia: Is collecting aia records 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 102: cn_message_pkg.debug('notify_aia: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');

98: 'Finished notification run: Notified ' || x_trx_count || ' aia records.');
99:
100: IF ( x_trx_count = 0 ) THEN
101:
102: cn_message_pkg.debug('notify_aia: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
103: fnd_file.put_line(fnd_file.Log, 'notify_aia: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
104:
105:
106: END IF;

Line 110: cn_message_pkg.debug('notify_aia: Finished notification run: Notified ' || x_trx_count || ' aia records.');

106: END IF;
107:
108: COMMIT;
109:
110: cn_message_pkg.debug('notify_aia: Finished notification run: Notified ' || x_trx_count || ' aia records.');
111: fnd_file.put_line(fnd_file.Log, 'notify_aia: Finished notification run: Notified ' || x_trx_count || ' aia records.');
112:
113: cn_debug.print_msg('< 114:

Line 115: cn_message_pkg.debug('notify_aia<<');

111: fnd_file.put_line(fnd_file.Log, 'notify_aia: Finished notification run: Notified ' || x_trx_count || ' aia records.');
112:
113: cn_debug.print_msg('< 114:
115: cn_message_pkg.debug('notify_aia<<');
116: fnd_file.put_line(fnd_file.Log, 'notify_aia<<');
117:
118: cn_message_pkg.end_batch (x_proc_audit_id);
119:

Line 118: cn_message_pkg.end_batch (x_proc_audit_id);

114:
115: cn_message_pkg.debug('notify_aia<<');
116: fnd_file.put_line(fnd_file.Log, 'notify_aia<<');
117:
118: cn_message_pkg.end_batch (x_proc_audit_id);
119:
120: EXCEPTION
121: WHEN OTHERS THEN ROLLBACK;
122: cn_debug.print_msg('notify_aia: in exception handler', 1);

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

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');
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_aia: in exception handler');
127: fnd_file.put_line(fnd_file.Log, 'notify_aia: in exception handler');
128:
129: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
130: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
131:
132: cn_message_pkg.end_batch (x_proc_audit_id);
133:

Line 132: cn_message_pkg.end_batch (x_proc_audit_id);

128:
129: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
130: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
131:
132: cn_message_pkg.end_batch (x_proc_audit_id);
133:
134: app_exception.raise_exception;
135:
136: END notify;