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_COLLECTION_GEN dependencies on CN_GLOBAL

Line 184: IF (x_event_id = cn_global.inv_event_id) THEN

180: cn_utils.appendcr(code);
181:
182: cn_utils.appindcr(code, 'x_proc_audit_id := NULL; -- Will get a value in the call below FOR TESTING');
183:
184: IF (x_event_id = cn_global.inv_event_id) THEN
185: x_event_name := 'INV';
186:
187: ELSIF (x_event_id = cn_global.pmt_event_id) THEN
188: x_event_name := 'PMT/GB';

Line 187: ELSIF (x_event_id = cn_global.pmt_event_id) THEN

183:
184: IF (x_event_id = cn_global.inv_event_id) THEN
185: x_event_name := 'INV';
186:
187: ELSIF (x_event_id = cn_global.pmt_event_id) THEN
188: x_event_name := 'PMT/GB';
189:
190: ELSIF (x_event_id = cn_global.cbk_event_id) THEN
191: x_event_name := 'CB';

Line 190: ELSIF (x_event_id = cn_global.cbk_event_id) THEN

186:
187: ELSIF (x_event_id = cn_global.pmt_event_id) THEN
188: x_event_name := 'PMT/GB';
189:
190: ELSIF (x_event_id = cn_global.cbk_event_id) THEN
191: x_event_name := 'CB';
192:
193: ELSIF (x_event_id = cn_global.wo_event_id) THEN
194: x_event_name := 'WO';

Line 193: ELSIF (x_event_id = cn_global.wo_event_id) THEN

189:
190: ELSIF (x_event_id = cn_global.cbk_event_id) THEN
191: x_event_name := 'CB';
192:
193: ELSIF (x_event_id = cn_global.wo_event_id) THEN
194: x_event_name := 'WO';
195:
196: ELSIF (x_event_id = cn_global.ram_event_id) THEN
197: x_event_name := 'RAM';

Line 196: ELSIF (x_event_id = cn_global.ram_event_id) THEN

192:
193: ELSIF (x_event_id = cn_global.wo_event_id) THEN
194: x_event_name := 'WO';
195:
196: ELSIF (x_event_id = cn_global.ram_event_id) THEN
197: x_event_name := 'RAM';
198:
199: ELSIF (x_event_id = cn_global.ord_event_id) THEN
200: x_event_name := 'ORD';

Line 199: ELSIF (x_event_id = cn_global.ord_event_id) THEN

195:
196: ELSIF (x_event_id = cn_global.ram_event_id) THEN
197: x_event_name := 'RAM';
198:
199: ELSIF (x_event_id = cn_global.ord_event_id) THEN
200: x_event_name := 'ORD';
201:
202: END IF;
203:

Line 298: IF (x_event_id = cn_global.inv_event_id) THEN

294: cn_utils.set_org_id(x_org_id);
295: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': entering notify.'');');
296: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': entering notify.'');');
297:
298: IF (x_event_id = cn_global.inv_event_id) THEN
299: cn_utils.appindcr(code, 'cn_notify_invoices.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
300:
301: ELSIF (x_event_id = cn_global.pmt_event_id) THEN
302: cn_utils.appindcr(code, 'cn_notify_payments.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );

Line 301: ELSIF (x_event_id = cn_global.pmt_event_id) THEN

297:
298: IF (x_event_id = cn_global.inv_event_id) THEN
299: cn_utils.appindcr(code, 'cn_notify_invoices.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
300:
301: ELSIF (x_event_id = cn_global.pmt_event_id) THEN
302: cn_utils.appindcr(code, 'cn_notify_payments.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
303:
304: ELSIF (x_event_id = cn_global.cbk_event_id) THEN
305: cn_utils.appindcr(code, 'cn_notify_clawbacks.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );

Line 304: ELSIF (x_event_id = cn_global.cbk_event_id) THEN

300:
301: ELSIF (x_event_id = cn_global.pmt_event_id) THEN
302: cn_utils.appindcr(code, 'cn_notify_payments.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
303:
304: ELSIF (x_event_id = cn_global.cbk_event_id) THEN
305: cn_utils.appindcr(code, 'cn_notify_clawbacks.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
306:
307: ELSIF (x_event_id = cn_global.wo_event_id) THEN
308: cn_utils.appindcr(code, 'cn_notify_writeoffs.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );

Line 307: ELSIF (x_event_id = cn_global.wo_event_id) THEN

303:
304: ELSIF (x_event_id = cn_global.cbk_event_id) THEN
305: cn_utils.appindcr(code, 'cn_notify_clawbacks.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
306:
307: ELSIF (x_event_id = cn_global.wo_event_id) THEN
308: cn_utils.appindcr(code, 'cn_notify_writeoffs.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
309:
310: ELSIF (x_event_id = cn_global.ord_event_id) THEN
311: cn_utils.appindcr(code, 'cn_notify_orders.regular_col_notify(');

Line 310: ELSIF (x_event_id = cn_global.ord_event_id) THEN

306:
307: ELSIF (x_event_id = cn_global.wo_event_id) THEN
308: cn_utils.appindcr(code, 'cn_notify_writeoffs.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
309:
310: ELSIF (x_event_id = cn_global.ord_event_id) THEN
311: cn_utils.appindcr(code, 'cn_notify_orders.regular_col_notify(');
312: cn_utils.indent(code, 8);
313: cn_utils.appindcr(code, ' x_start_period => x_start_period_id');
314: cn_utils.appindcr(code, ',x_end_period => x_end_period_id');

Line 333: IF (x_event_id = cn_global.ord_event_id) THEN

329: cn_utils.set_org_id(x_org_id);
330: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': exit from notify and start collection run.'');');
331: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': exit from notify and start collection run.'');');
332:
333: IF (x_event_id = cn_global.ord_event_id) THEN
334: cn_utils.appendcr(code, '--******** COLLECT AJUSTMENTS (NEGATE IN API) ********-- ');
335: cn_utils.appindcr(code, '-- This will negate those adjusted trx in the API table');
336: cn_utils.appindcr(code, 'cn_not_trx_grp.col_adjustments(p_api_version => 1.0,');
337: cn_utils.appindcr(code, ' x_return_status => x_return_status,');

Line 493: cn_utils.appindcr(code, ' ctl.event_id = cn_global.inv_event_id');

489: cn_utils.appindcr(code, ' SET negated_flag = ''Y''');
490: cn_utils.appindcr(code, ' WHERE ctl.adjusted_flag = ''Y'' and');
491: cn_utils.appindcr(code, ' ctl.negated_flag = ''N'' and');
492: cn_utils.appindcr(code, ' ctl.collected_flag = ''N'' and');
493: cn_utils.appindcr(code, ' ctl.event_id = cn_global.inv_event_id');
494: cn_utils.appindcr(code, ' AND ctl.org_id = '||x_org_id||' ;');
495: cn_utils.appendcr(code);
496: cn_utils.appindcr(code, 'END IF;');
497: cn_utils.appendcr(code);

Line 533: IF (x_event_id = cn_global.ram_event_id) THEN

529: BEGIN
530:
531:
532:
533: IF (x_event_id = cn_global.ram_event_id) THEN
534:
535: cn_debug.print_msg('local_variables>>', 1);
536: fnd_file.put_line(fnd_file.Log, 'local_variables>>');
537:

Line 574: cn_utils.appindcr(code, ' event_id = cn_global.inv_event_id AND ');

570: cn_utils.appindcr(code, ' FROM cn_trx_lines');
571: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' AND');
572: cn_utils.appindcr(code, ' negated_flag = ''Y'' AND');
573: cn_utils.appindcr(code, ' collected_flag = ''N'' AND');
574: cn_utils.appindcr(code, ' event_id = cn_global.inv_event_id AND ');
575: cn_utils.appindcr(code, ' org_id = '||x_org_id||' ;');
576: cn_utils.appendcr(code);
577:
578: cn_utils.unindent(code, 1);

Line 779: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process

775: p_location_name => 'Pre-Notification',
776: code => body_code,
777: X_ORG_ID => X_ORG_ID);
778:
779: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process
780: call_identify(x_package_id, x_procedure_name, x_module_id,x_repository_id, x_event_id, body_code,X_ORG_ID);
781: ELSE -- other notify process
782: call_notify(x_package_id, x_procedure_name, x_module_id,x_repository_id, x_event_id, body_code,X_ORG_ID);
783: END IF;

Line 803: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process

799: p_location_name => 'Post-Notification',
800: code => body_code,
801: X_ORG_ID => X_ORG_ID);
802:
803: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process
804: call_negate(x_package_id, x_procedure_name, x_module_id,x_repository_id, x_event_id, body_code,X_org_id);
805: END IF;
806:
807: cn_utils.set_org_id(X_org_id);

Line 831: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process

827: cn_utils.appindcr(body_code, 'FOR b IN batches LOOP');
828: cn_utils.appendcr(body_code);
829: cn_utils.indent(body_code, 1);
830:
831: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process
832: cn_utils.appindcr(body_code, 'x_adj_batch_id := b.adj_batch_id;');
833: cn_utils.appendcr(body_code);
834: cn_utils.record_process_start('COL', '''RAM Adjustments Collection run for batch '' || x_adj_batch_id', 'x_col_audit_id', body_code);
835: ELSE

Line 881: x_event_id = cn_global.ord_event_id THEN

877: cn_debug.print_msg('collect_stmts>>', 1);
878: fnd_file.put_line(fnd_file.Log, 'collect_stmts>>');
879:
880: IF x_generic OR
881: x_event_id = cn_global.ord_event_id THEN
882: IF x_generic THEN
883:
884: -- This is a package whose contents are comletely data-driven
885: -- Generate code to insert into API table for collection.

Line 932: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM Collection

928: code => code,
929: X_ORG_ID => X_ORG_ID);
930:
931: ELSE -- Receivables package
932: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM Collection
933:
934: cn_utils.set_org_id(X_org_id);
935: cn_utils.appendcr(code);
936: cn_utils.appendcr(code, '--******** UPDATE CN_TRX CN_TRX_LINES ********-- ');

Line 946: cn_utils.appindcr(code, ' AND event_id = cn_global.inv_event_id ');

942: cn_utils.appindcr(code, ' WHERE trx_id IN (SELECT trx_id from cn_trx_lines ');
943: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' ');
944: cn_utils.appindcr(code, ' AND negated_flag = ''Y'' ');
945: cn_utils.appindcr(code, ' AND collected_flag = ''N'' ');
946: cn_utils.appindcr(code, ' AND event_id = cn_global.inv_event_id ');
947: cn_utils.appindcr(code, ' AND adj_batch_id = x_adj_batch_id ');
948: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||')');
949: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
950: cn_utils.appendcr(code);

Line 960: cn_utils.appindcr(code, ' AND event_id = cn_global.inv_event_id ');

956: cn_utils.appindcr(code, ' SET adj_collection_run_id = x_proc_audit_id ');
957: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' ');
958: cn_utils.appindcr(code, ' AND negated_flag = ''Y'' ');
959: cn_utils.appindcr(code, ' AND collected_flag = ''N'' ');
960: cn_utils.appindcr(code, ' AND event_id = cn_global.inv_event_id ');
961: cn_utils.appindcr(code, ' AND adj_batch_id = x_adj_batch_id ');
962: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
963: cn_utils.appendcr(code);
964: cn_utils.appindcr(code, 'trx_line_update_count := SQL%ROWCOUNT; ');

Line 994: END IF; --IF (x_event_id = cn_global.ram_event_id)

990:
991: -- Generate code to update lines
992: cn_collection_ar_gen.update_lines(x_procedure_name, x_module_id, x_event_id, code,X_org_id);
993:
994: END IF; --IF (x_event_id = cn_global.ram_event_id)
995:
996: cn_utils.unset_org_id();
997: -- Generate code to insert into sales lines --AE 11-16-95
998: cn_collection_ar_gen.insert_sales_lines(x_procedure_name, x_module_id, x_event_id, code,X_org_id);

Line 1035: IF (x_event_id <> cn_global.ram_event_id) THEN

1031: p_location_name => 'Post-Api-Filter',
1032: code => code,
1033: X_ORG_ID => X_ORG_ID);
1034:
1035: IF (x_event_id <> cn_global.ram_event_id) THEN
1036: cn_utils.set_org_id(X_org_id);
1037: cn_utils.unindent(code, 1);
1038: cn_utils.appindcr(code, 'END IF; -- Any New Transactions?');
1039: cn_utils.appendcr(code);

Line 1073: IF (x_event_id = cn_global.ram_event_id) THEN

1069: cn_utils.set_org_id(x_org_id);
1070: -- Generate code to record success or failure of batch
1071: IF(x_event_id < 0)
1072: THEN
1073: IF (x_event_id = cn_global.ram_event_id) THEN
1074: cn_utils.record_process_success('''Finished collection run for batch '' || x_adj_batch_id', code);
1075: ELSE
1076: cn_utils.record_process_success('''Finished collection run for batch '' || x_batch_id', code);
1077: END IF;