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 300: IF (x_event_id = cn_global.inv_event_id) THEN

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

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

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

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

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

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

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

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

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

Line 324: ELSIF (x_event_id = cn_global.aia_event_id) THEN

320: cn_utils.appindcr(code, ',debug_level => debug_level');
321: cn_utils.appindcr(code, ',x_org_id => '||x_org_id ||' );');
322: cn_utils.unindent(code, 8);
323:
324: ELSIF (x_event_id = cn_global.aia_event_id) THEN
325: cn_utils.appindcr(code, 'cn_notify_aia.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
326: ELSIF (x_event_id = cn_global.aia_om_event_id) THEN
327: cn_utils.appindcr(code, 'cn_notify_aia_om.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
328:

Line 326: ELSIF (x_event_id = cn_global.aia_om_event_id) THEN

322: cn_utils.unindent(code, 8);
323:
324: ELSIF (x_event_id = cn_global.aia_event_id) THEN
325: cn_utils.appindcr(code, 'cn_notify_aia.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
326: ELSIF (x_event_id = cn_global.aia_om_event_id) THEN
327: cn_utils.appindcr(code, 'cn_notify_aia_om.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
328:
329: END IF;
330: cn_utils.appendcr(code);

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

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

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

496: cn_utils.appindcr(code, ' SET negated_flag = ''Y''');
497: cn_utils.appindcr(code, ' WHERE ctl.adjusted_flag = ''Y'' and');
498: cn_utils.appindcr(code, ' ctl.negated_flag = ''N'' and');
499: cn_utils.appindcr(code, ' ctl.collected_flag = ''N'' and');
500: cn_utils.appindcr(code, ' ctl.event_id = cn_global.inv_event_id');
501: cn_utils.appindcr(code, ' AND ctl.org_id = '||x_org_id||' ;');
502: cn_utils.appendcr(code);
503: cn_utils.appindcr(code, 'END IF;');
504: cn_utils.appendcr(code);

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

536: BEGIN
537:
538:
539:
540: IF (x_event_id = cn_global.ram_event_id) THEN
541:
542: cn_debug.print_msg('local_variables>>', 1);
543: fnd_file.put_line(fnd_file.Log, 'local_variables>>');
544:

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

577: cn_utils.appindcr(code, ' FROM cn_trx_lines');
578: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' AND');
579: cn_utils.appindcr(code, ' negated_flag = ''Y'' AND');
580: cn_utils.appindcr(code, ' collected_flag = ''N'' AND');
581: cn_utils.appindcr(code, ' event_id = cn_global.inv_event_id AND ');
582: cn_utils.appindcr(code, ' org_id = '||x_org_id||' ;');
583: cn_utils.appendcr(code);
584:
585: cn_utils.unindent(code, 1);

Line 632: IF (x_event_id = cn_global.aia_event_id or x_event_id = cn_global.aia_om_event_id) THEN

628: -- Change made to fix bug 6203234
629: -- Fix for bug 8371984
630: -- if(x_event_id < 0)
631: -- then
632: IF (x_event_id = cn_global.aia_event_id or x_event_id = cn_global.aia_om_event_id) THEN
633: cn_utils.appindcr(code, 'CURSOR batches IS');
634: cn_utils.appindcr(code, ' SELECT DISTINCT batch_id');
635: cn_utils.appindcr(code, ' FROM cn_not_trx');
636: cn_utils.appindcr(code, ' WHERE collected_flag = ''N''');

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

794: p_location_name => 'Pre-Notification',
795: code => body_code,
796: X_ORG_ID => X_ORG_ID);
797:
798: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process
799: call_identify(x_package_id, x_procedure_name, x_module_id,x_repository_id, x_event_id, body_code,X_ORG_ID);
800: ELSE -- other notify process
801: call_notify(x_package_id, x_procedure_name, x_module_id,x_repository_id, x_event_id, body_code,X_ORG_ID);
802: END IF;

Line 804: ELSIF (x_event_id = cn_global.aia_event_id or x_event_id = cn_global.aia_om_event_id) THEN

800: ELSE -- other notify process
801: call_notify(x_package_id, x_procedure_name, x_module_id,x_repository_id, x_event_id, body_code,X_ORG_ID);
802: END IF;
803:
804: ELSIF (x_event_id = cn_global.aia_event_id or x_event_id = cn_global.aia_om_event_id) THEN
805: -- Insert any User Code specified for the 'Pre-Notification' location
806: cn_utils.unset_org_id();
807:
808: cn_collection_custom_gen.Generate_User_Code(

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

829: p_location_name => 'Post-Notification',
830: code => body_code,
831: X_ORG_ID => X_ORG_ID);
832:
833: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process
834: call_negate(x_package_id, x_procedure_name, x_module_id,x_repository_id, x_event_id, body_code,X_org_id);
835: END IF;
836:
837: cn_utils.set_org_id(X_org_id);

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

858: cn_utils.appindcr(body_code, 'FOR b IN batches LOOP');
859: cn_utils.appendcr(body_code);
860: cn_utils.indent(body_code, 1);
861:
862: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM identify process
863: cn_utils.appindcr(body_code, 'x_adj_batch_id := b.adj_batch_id;');
864: cn_utils.appendcr(body_code);
865: cn_utils.record_process_start('COL', '''RAM Adjustments Collection run for batch '' || x_adj_batch_id', 'x_col_audit_id', body_code);
866: ELSE

Line 912: x_event_id = cn_global.ord_event_id THEN

908: cn_debug.print_msg('collect_stmts>>', 1);
909: fnd_file.put_line(fnd_file.Log, 'collect_stmts>>');
910:
911: IF x_generic OR
912: x_event_id = cn_global.ord_event_id THEN
913: IF x_generic THEN
914:
915: -- This is a package whose contents are comletely data-driven
916: -- Generate code to insert into API table for collection.

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

959: code => code,
960: X_ORG_ID => X_ORG_ID);
961:
962: ELSE -- Receivables package
963: IF (x_event_id = cn_global.ram_event_id) THEN -- RAM Collection
964:
965: cn_utils.set_org_id(X_org_id);
966: cn_utils.appendcr(code);
967: cn_utils.appendcr(code, '--******** UPDATE CN_TRX CN_TRX_LINES ********-- ');

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

973: cn_utils.appindcr(code, ' WHERE trx_id IN (SELECT trx_id from cn_trx_lines ');
974: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' ');
975: cn_utils.appindcr(code, ' AND negated_flag = ''Y'' ');
976: cn_utils.appindcr(code, ' AND collected_flag = ''N'' ');
977: cn_utils.appindcr(code, ' AND event_id = cn_global.inv_event_id ');
978: cn_utils.appindcr(code, ' AND adj_batch_id = x_adj_batch_id ');
979: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||')');
980: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
981: cn_utils.appendcr(code);

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

987: cn_utils.appindcr(code, ' SET adj_collection_run_id = x_proc_audit_id ');
988: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' ');
989: cn_utils.appindcr(code, ' AND negated_flag = ''Y'' ');
990: cn_utils.appindcr(code, ' AND collected_flag = ''N'' ');
991: cn_utils.appindcr(code, ' AND event_id = cn_global.inv_event_id ');
992: cn_utils.appindcr(code, ' AND adj_batch_id = x_adj_batch_id ');
993: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
994: cn_utils.appendcr(code);
995: cn_utils.appindcr(code, 'trx_line_update_count := SQL%ROWCOUNT; ');

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

1021:
1022: -- Generate code to update lines
1023: cn_collection_ar_gen.update_lines(x_procedure_name, x_module_id, x_event_id, code,X_org_id);
1024:
1025: END IF; --IF (x_event_id = cn_global.ram_event_id)
1026:
1027: cn_utils.unset_org_id();
1028: -- Generate code to insert into sales lines --AE 11-16-95
1029: cn_collection_ar_gen.insert_sales_lines(x_procedure_name, x_module_id, x_event_id, code,X_org_id);

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

1062: p_location_name => 'Post-Api-Filter',
1063: code => code,
1064: X_ORG_ID => X_ORG_ID);
1065:
1066: IF (x_event_id <> cn_global.ram_event_id) THEN
1067: cn_utils.set_org_id(X_org_id);
1068: cn_utils.unindent(code, 1);
1069: cn_utils.appindcr(code, 'END IF; -- Any New Transactions?');
1070: cn_utils.appendcr(code);

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

1101: -- Generate code to record success or failure of batch
1102: -- Fix for bug 8371984
1103: --IF(x_event_id < 0)
1104: --THEN
1105: IF (x_event_id = cn_global.ram_event_id) THEN
1106: cn_utils.record_process_success('''Finished collection run for batch '' || x_adj_batch_id', code);
1107: ELSE
1108: cn_utils.record_process_success('''Finished collection run for batch '' || x_batch_id', code);
1109: END IF;

Line 1163: IF (x_event_id = cn_global.aia_om_event_id) THEN

1159: -- cn_utils.proc_end(x_procedure_name, 'Y', code);
1160:
1161: --proc_exception(x_procedure_name, NULL, 'outside the loop', code);
1162:
1163: IF (x_event_id = cn_global.aia_om_event_id) THEN
1164: cn_utils.unindent(code, 1);
1165: cn_utils.appindcr(code, 'exception when others then');
1166: cn_utils.appendcr(code, 'errbuf := SQLCODE||'' ''||SQLERRM;' );
1167: cn_utils.appendcr(code, 'retcode := 2;' );

Line 1229: ELSIF (event_id = cn_global.aia_event_id or event_id = cn_global.aia_om_event_id) THEN

1225:
1226: IF NOT x_generic THEN
1227: parameter_list := parameter_list ||
1228: ', x_start_period_name IN VARCHAR2, x_end_period_name IN VARCHAR2, x_org_id IN NUMBER ';
1229: ELSIF (event_id = cn_global.aia_event_id or event_id = cn_global.aia_om_event_id) THEN
1230: parameter_list := parameter_list ||
1231: ', x_start_period_name IN VARCHAR2, x_end_period_name IN VARCHAR2, x_org_id IN NUMBER ';
1232: ELSE
1233: parameter_list := parameter_list ||