eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_NOTIFY_INVOICES dependencies on CN_NOT_TRX

Line 10: -- This procedure collects data for invoices for cn_not_trx

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

Line 51: cn_message_pkg.debug('notify_invoices: Is collecting invoices for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

47:
48: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,
49: x_start_date, x_end_date);
50:
51: cn_message_pkg.debug('notify_invoices: Is collecting invoices for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
52: fnd_file.put_line(fnd_file.Log, 'notify_invoices: Is collecting invoices for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
53:
54:
55: -- Check if the profile option CN_COLLECT_ON_ACCT_CREDITS is turned on

Line 52: fnd_file.put_line(fnd_file.Log, 'notify_invoices: Is collecting invoices for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

48: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,
49: x_start_date, x_end_date);
50:
51: cn_message_pkg.debug('notify_invoices: Is collecting invoices for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
52: fnd_file.put_line(fnd_file.Log, 'notify_invoices: Is collecting invoices for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
53:
54:
55: -- Check if the profile option CN_COLLECT_ON_ACCT_CREDITS is turned on
56: -- or not

Line 68: INSERT INTO cn_not_trx (

64: -- collecting On Account Credits purpose. So basicly, we do not
65: -- distinguish among INV, CM or On Account Credits here. We will be
66: -- collecting all of these three when we collect invoices.
67:
68: INSERT INTO cn_not_trx (
69: not_trx_id,
70: batch_id,
71: notified_date,
72: processed_date,

Line 81: cn_not_trx_s.NEXTVAL,

77: source_doc_type,
78: event_id,
79: org_id)
80: SELECT
81: cn_not_trx_s.NEXTVAL,
82: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
83: SYSDATE,
84: rctlgd.gl_date, --AE 02-22-96
85: x_proc_audit_id,

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

78: event_id,
79: org_id)
80: SELECT
81: cn_not_trx_s.NEXTVAL,
82: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
83: SYSDATE,
84: rctlgd.gl_date, --AE 02-22-96
85: x_proc_audit_id,
86: 'N',

Line 112: FROM cn_not_trx

108: AND rctlgd.org_id = rctt.org_id
109: AND cr.org_id = rctlgd.org_id
110: AND NOT EXISTS (
111: SELECT 1
112: FROM cn_not_trx
113: WHERE source_trx_id = rct.customer_trx_id
114: AND event_id= cn_global.inv_event_id
115: AND org_id = x_org_id) ;
116:

Line 119: INSERT INTO cn_not_trx (

115: AND org_id = x_org_id) ;
116:
117: ELSE -- CN_COLLECT_ON_ACCT_CREDITS = 'N'
118:
119: INSERT INTO cn_not_trx (
120: not_trx_id,
121: batch_id,
122: notified_date,
123: processed_date,

Line 132: cn_not_trx_s.NEXTVAL,

128: source_doc_type,
129: event_id,
130: org_id)
131: SELECT
132: cn_not_trx_s.NEXTVAL,
133: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
134: SYSDATE,
135: rctlgd.gl_date, --AE 02-22-96
136: x_proc_audit_id,

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

129: event_id,
130: org_id)
131: SELECT
132: cn_not_trx_s.NEXTVAL,
133: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
134: SYSDATE,
135: rctlgd.gl_date, --AE 02-22-96
136: x_proc_audit_id,
137: 'N',

Line 166: FROM cn_not_trx

162: AND rctlgd.org_id = rctt.org_id
163: AND cr.org_id = rctlgd.org_id
164: AND NOT EXISTS (
165: SELECT 1
166: FROM cn_not_trx
167: WHERE source_trx_id = rct.customer_trx_id
168: AND event_id= cn_global.inv_event_id
169: AND org_id = x_org_id) ;
170:

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

178:
179:
180: IF ( x_trx_count = 0 ) THEN
181:
182: cn_message_pkg.debug('notify_invoices: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
183: fnd_file.put_line(fnd_file.Log, 'notify_invoices: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
184:
185: END IF;
186:

Line 183: fnd_file.put_line(fnd_file.Log, 'notify_invoices: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');

179:
180: IF ( x_trx_count = 0 ) THEN
181:
182: cn_message_pkg.debug('notify_invoices: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
183: fnd_file.put_line(fnd_file.Log, 'notify_invoices: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to GL or they have already been collected.');
184:
185: END IF;
186:
187: COMMIT;