APPS.CN_NOTIFY_CLAWBACKS dependencies on CN_NOT_TRX

Line 9: -- This procedure collects data for clawbacks for cn_not_trx

5:
6: -- Procedure Name
7: -- notify_clawbacks
8: -- Purpose
9: -- This procedure collects data for clawbacks for cn_not_trx
10: -- History
11: -- 01-05-96 A. Erickson Created
12:
13:

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

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

Line 87: INSERT INTO cn_not_trx (

83: FETCH batch_size INTO l_sys_batch_size;
84: CLOSE batch_size;
85:
86:
87: INSERT INTO cn_not_trx (
88: not_trx_id,
89: batch_id,
90: notified_date,
91: processed_date,

Line 100: cn_not_trx_s.NEXTVAL,

96: source_doc_type,
97: event_id,
98: org_id)
99: SELECT
100: cn_not_trx_s.NEXTVAL,
101: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
102: SYSDATE,
103: x_end_date,
104: x_proc_audit_id,

Line 101: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),

97: event_id,
98: org_id)
99: SELECT
100: cn_not_trx_s.NEXTVAL,
101: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
102: SYSDATE,
103: x_end_date,
104: x_proc_audit_id,
105: 'N',

Line 136: FROM cn_not_trx

132: AND rctlgd.org_id = rctt.org_id
133: AND cr.org_id = rctlgd.org_id
134: AND NOT EXISTS (
135: SELECT 1
136: FROM cn_not_trx
137: WHERE source_trx_id = aps.payment_schedule_id
138: AND event_id= cn_global.cbk_event_id
139: AND org_id = x_org_id) ;
140:

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

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:
154: COMMIT;