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_AIA_OM dependencies on CN_NOT_TRX

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

6:
7: -- Procedure Name
8: -- notify_aia_om
9: -- Purpose
10: -- This procedure collects data for aia order records for cn_not_trx
11: -- History
12: --
13:
14:

Line 63: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

59: x_org_id,
60: x_start_date,
61: x_end_date);
62: --
63: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
64: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
65: --
66: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');
67: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');

Line 64: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');

60: x_start_date,
61: x_end_date);
62: --
63: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
64: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for CN_NOT_TRX from period '||x_start_date ||' to period '||x_end_date ||'.');
65: --
66: cn_message_pkg.debug('notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');
67: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting aia order records for notification batch id '|| x_proc_audit_id ||'.');
68:

Line 75: INSERT INTO cn_not_trx (

71: FETCH batch_size INTO l_sys_batch_size;
72: CLOSE batch_size;
73:
74:
75: INSERT INTO cn_not_trx (
76: not_trx_id,
77: batch_id,
78: processed_date,
79: notified_date,

Line 88: cn_not_trx_s.NEXTVAL,

84: source_trx_line_id,
85: source_doc_type,
86: org_id)
87: SELECT
88: cn_not_trx_s.NEXTVAL,
89: cnot.t_batch_id,
90: cnot.t_processed_date,
91: cnot.t_notified_date,
92: cnot.t_notification_run_id,

Line 121: FROM cn_not_trx

117: AND preprocess_flag = FND_API.G_FALSE
118: AND org_id = x_org_id
119: AND NOT EXISTS (
120: SELECT 1
121: FROM cn_not_trx
122: WHERE source_trx_line_id = cco10145.trans_seq_id --*** Line.Primary_Key
123: AND event_id = -1030
124: AND org_id = x_org_id)
125: ) cnot;

Line 139: cn_message_pkg.debug('notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');

135: 'Finished notification run: Notified ' || x_trx_count || ' aia order records.');
136:
137: IF ( x_trx_count = 0 ) THEN
138:
139: cn_message_pkg.debug('notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
140: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
141:
142:
143: END IF;

Line 140: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');

136:
137: IF ( x_trx_count = 0 ) THEN
138:
139: cn_message_pkg.debug('notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
140: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');
141:
142:
143: END IF;
144:

Line 178: -- This procedure collects failed records for aia order for cn_not_trx

174:
175: -- Procedure Name
176: -- notify_failed_trx
177: -- Purpose
178: -- This procedure collects failed records for aia order for cn_not_trx
179: -- History
180: --
181:
182: PROCEDURE notify_failed_trx (

Line 183: p_batch_id cn_not_trx_all.batch_id%TYPE,

179: -- History
180: --
181:
182: PROCEDURE notify_failed_trx (
183: p_batch_id cn_not_trx_all.batch_id%TYPE,
184: x_start_period cn_periods.period_id%TYPE,
185: x_end_period cn_periods.period_id%TYPE,
186: debug_pipe VARCHAR2 DEFAULT NULL,
187: debug_level NUMBER DEFAULT 1,

Line 195: FROM cn_not_trx_all

191: SELECT distinct original_order_number, ln_num
192: FROM CN_AIA_ORDER_CAPTURE
193: WHERE org_id = x_org_id and trans_seq_id in
194: ( SELECT source_trx_line_id
195: FROM cn_not_trx_all
196: WHERE batch_id = p_batch_id and org_id = x_org_id and source_trx_line_id not in
197: (SELECT source_trx_line_id
198: FROM cn_comm_lines_api_all
199: WHERE process_batch_id = p_batch_id and org_id = x_org_id)

Line 227: cn_message_pkg.debug('notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected

223: x_start_date,
224: x_end_date);
225:
226: --
227: cn_message_pkg.debug('notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected
228: in CN_COMM_LINES_API from period '||x_start_date ||' to period '||x_end_date ||'.');
229: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected
230: in CN_COMM_LINES_API from period '||x_start_date ||' to period '||x_end_date ||'.');
231:

Line 229: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected

225:
226: --
227: cn_message_pkg.debug('notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected
228: in CN_COMM_LINES_API from period '||x_start_date ||' to period '||x_end_date ||'.');
229: fnd_file.put_line(fnd_file.Log, 'notify_aia_om: Is collecting failed aia orders records which exist in CN_NOT_TRX but not collected
230: in CN_COMM_LINES_API from period '||x_start_date ||' to period '||x_end_date ||'.');
231:
232: --
233: