APPS.CN_NOTIFY_WRITEOFFS dependencies on CN_NOT_TRX

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

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

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

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

Line 56: INSERT INTO cn_not_trx (

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

Line 69: cn_not_trx_s.NEXTVAL,

65: source_doc_type,
66: event_id,
67: org_id)
68: SELECT
69: cn_not_trx_s.NEXTVAL,
70: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
71: SYSDATE,
72: aa.gl_date, --AE 02-22-96
73: x_proc_audit_id,

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

66: event_id,
67: org_id)
68: SELECT
69: cn_not_trx_s.NEXTVAL,
70: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
71: SYSDATE,
72: aa.gl_date, --AE 02-22-96
73: x_proc_audit_id,
74: 'N',

Line 93: FROM cn_not_trx

89: AND aa.org_id = x_org_id
90: AND cr.org_id = aa.org_id
91: AND NOT EXISTS (
92: SELECT 1
93: FROM cn_not_trx
94: WHERE source_trx_id = aa.adjustment_id
95: AND event_id= cn_global.wo_event_id
96: AND org_id = x_org_id) ;
97:

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

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