APPS.CN_NOTIFY_AIA dependencies on CN_NOT_TRX

Line 10: -- This procedure collects data for aia records for cn_not_trx

6:
7: -- Procedure Name
8: -- notify_aia
9: -- Purpose
10: -- This procedure collects data for aia records for cn_not_trx
11: -- History
12: -- 01-05-96 A. Erickson Created
13:
14:

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 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 ||'.');

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;
54: CLOSE batch_size;

Line 57: INSERT INTO cn_not_trx (

53: FETCH batch_size INTO l_sys_batch_size;
54: CLOSE batch_size;
55:
56:
57: INSERT INTO cn_not_trx (
58: not_trx_id,
59: batch_id,
60: processed_date,
61: notified_date,

Line 70: cn_not_trx_s.NEXTVAL,

66: source_trx_line_id,
67: source_doc_type,
68: org_id)
69: SELECT
70: cn_not_trx_s.NEXTVAL,
71: x_proc_audit_id,
72: cco10143.processed_date,
73: SYSDATE,
74: x_proc_audit_id,

Line 88: FROM cn_not_trx

84: 1 = 1
85: AND TRUNC(processed_date) BETWEEN x_start_date AND x_end_date
86: AND NOT EXISTS (
87: SELECT 1
88: FROM cn_not_trx
89: WHERE source_trx_line_id = cco10143.trans_seq_id --*** Line.Primary_Key
90: AND event_id = -1020
91: AND org_id = x_org_id);
92: --END Notification Insert Block

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 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.');

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;
107: