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_AR_GEN dependencies on FND_FILE

Line 63: fnd_file.put_line(fnd_file.Log, 'insert_trx>>');

59: cn_utils.appendcr(code, '--******** INSERT CN_TRX ********-- ');
60: cn_utils.unset_org_id();
61:
62: cn_debug.print_msg('insert_trx>>', 1);
63: fnd_file.put_line(fnd_file.Log, 'insert_trx>>');
64:
65: SELECT module_type --AE 11-16-95
66: INTO x_module_type
67: FROM cn_modules

Line 76: fnd_file.put_line(fnd_file.Log, 'insert_trx: Generating INSERT statement. ');

72: cn_debug.print_msg('insert_trx: x_module_id = ' || x_module_id, 1);
73:
74: -- Generate the insert statement
75: cn_debug.print_msg('insert_trx: Generating INSERT statement. ', 1);
76: fnd_file.put_line(fnd_file.Log, 'insert_trx: Generating INSERT statement. ');
77:
78: cn_utils.set_org_id(p_org_id => l_org_id);
79: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': Inserting into CN_TRX.'');');
80: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Inserting into CN_TRX.'');');

Line 80: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Inserting into CN_TRX.'');');

76: fnd_file.put_line(fnd_file.Log, 'insert_trx: Generating INSERT statement. ');
77:
78: cn_utils.set_org_id(p_org_id => l_org_id);
79: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': Inserting into CN_TRX.'');');
80: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Inserting into CN_TRX.'');');
81: cn_utils.appendcr(code);
82: cn_utils.appindcr(code, 'INSERT INTO cn_trx(');
83: cn_utils.indent(code, 1);
84:

Line 343: fnd_file.put_line(fnd_file.Log, 'insert_trx: Generated INSERT statement.');

339: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
340:
341: cn_utils.unset_org_id();
342: cn_debug.print_msg('insert_trx: Generated INSERT statement.', 1);
343: fnd_file.put_line(fnd_file.Log, 'insert_trx: Generated INSERT statement.');
344:
345: cn_utils.set_org_id(p_org_id => l_org_id);
346: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || trx_count || '' records into cn_trx.'');');
347: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_count || '' records into cn_trx.'');');

Line 347: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_count || '' records into cn_trx.'');');

343: fnd_file.put_line(fnd_file.Log, 'insert_trx: Generated INSERT statement.');
344:
345: cn_utils.set_org_id(p_org_id => l_org_id);
346: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || trx_count || '' records into cn_trx.'');');
347: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_count || '' records into cn_trx.'');');
348: cn_utils.appendcr(code);
349: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating collected_flag in CN_NOT_TRX .'');');
350: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updating collected_flag in CN_NOT_TRX .'');');
351: cn_utils.appendcr(code);

Line 350: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updating collected_flag in CN_NOT_TRX .'');');

346: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || trx_count || '' records into cn_trx.'');');
347: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_count || '' records into cn_trx.'');');
348: cn_utils.appendcr(code);
349: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating collected_flag in CN_NOT_TRX .'');');
350: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updating collected_flag in CN_NOT_TRX .'');');
351: cn_utils.appendcr(code);
352:
353: cn_utils.appindcr(code, 'UPDATE cn_not_trx cnt');
354: cn_utils.appindcr(code, ' SET collected_flag = ''Y''');

Line 363: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updated collected_flag in cn_not_trx.'');');

359: cn_utils.appindcr(code, ' AND cnt.collected_flag = ''N''');
360: cn_utils.appindcr(code, ' AND cnt.batch_id = x_batch_id;');
361: cn_utils.appendcr(code);
362: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated collected_flag in cn_not_trx.'');');
363: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updated collected_flag in cn_not_trx.'');');
364: cn_utils.appendcr(code);
365: cn_utils.unset_org_id();
366:
367: cn_debug.print_msg('insert_trx<<', 1);

Line 368: fnd_file.put_line(fnd_file.Log, 'insert_trx<<');

364: cn_utils.appendcr(code);
365: cn_utils.unset_org_id();
366:
367: cn_debug.print_msg('insert_trx<<', 1);
368: fnd_file.put_line(fnd_file.Log, 'insert_trx<<');
369:
370: EXCEPTION
371: WHEN NO_DATA_FOUND THEN
372: cn_debug.print_msg('insert_trx: in exception handler for NO_DATA_FOUND', 1);

Line 373: fnd_file.put_line(fnd_file.Log, 'insert_trx: in exception handler for NO_DATA_FOUND');

369:
370: EXCEPTION
371: WHEN NO_DATA_FOUND THEN
372: cn_debug.print_msg('insert_trx: in exception handler for NO_DATA_FOUND', 1);
373: fnd_file.put_line(fnd_file.Log, 'insert_trx: in exception handler for NO_DATA_FOUND');
374: RETURN;
375: END insert_trx;
376:
377:

Line 420: fnd_file.put_line(fnd_file.Log, 'update_trx>>');

416: cn_utils.appendcr(code, '--******** UPDATE CN_TRX ********-- ');
417: cn_utils.unset_org_id();
418:
419: cn_debug.print_msg('update_trx>>', 1);
420: fnd_file.put_line(fnd_file.Log, 'update_trx>>');
421: -- Initialize value of table_map_id
422: -- Note: This assumes that there is exactly one header table in the
423: -- repository
424:

Line 430: fnd_file.put_line(fnd_file.Log, 'update_trx: Generating UPDATE statement. ');

426:
427:
428: -- Generate the update statement
429: cn_debug.print_msg('update_trx: Generating UPDATE statement. ', 1);
430: fnd_file.put_line(fnd_file.Log, 'update_trx: Generating UPDATE statement. ');
431:
432: cn_utils.set_org_id(p_org_id => l_org_id);
433: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX .'');');
434: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX .'');');

Line 434: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX .'');');

430: fnd_file.put_line(fnd_file.Log, 'update_trx: Generating UPDATE statement. ');
431:
432: cn_utils.set_org_id(p_org_id => l_org_id);
433: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX .'');');
434: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX .'');');
435: cn_utils.appendcr(code);
436:
437:
438: IF (x_event_id = cn_global.inv_event_id) THEN

Line 537: fnd_file.put_line(fnd_file.Log, 'update_trx: Generated UPDATE statement.');

533: cn_utils.appendcr(code);
534: cn_utils.appindcr(code, 'trx_update_count := SQL%ROWCOUNT;');
535: cn_utils.unset_org_id();
536: cn_debug.print_msg('update_trx: Generated UPDATE statement.', 1);
537: fnd_file.put_line(fnd_file.Log, 'update_trx: Generated UPDATE statement.');
538: cn_utils.set_org_id(p_org_id => l_org_id);
539: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated '' || trx_update_count || '' cn_trx.'');');
540: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updated '' || trx_update_count || '' cn_trx.'');');
541: cn_utils.appendcr(code);

Line 540: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updated '' || trx_update_count || '' cn_trx.'');');

536: cn_debug.print_msg('update_trx: Generated UPDATE statement.', 1);
537: fnd_file.put_line(fnd_file.Log, 'update_trx: Generated UPDATE statement.');
538: cn_utils.set_org_id(p_org_id => l_org_id);
539: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated '' || trx_update_count || '' cn_trx.'');');
540: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updated '' || trx_update_count || '' cn_trx.'');');
541: cn_utils.appendcr(code);
542: cn_utils.unset_org_id();
543: cn_debug.print_msg('update_trx<<', 1);
544: fnd_file.put_line(fnd_file.Log, 'update_trx<<');

Line 544: fnd_file.put_line(fnd_file.Log, 'update_trx<<');

540: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Updated '' || trx_update_count || '' cn_trx.'');');
541: cn_utils.appendcr(code);
542: cn_utils.unset_org_id();
543: cn_debug.print_msg('update_trx<<', 1);
544: fnd_file.put_line(fnd_file.Log, 'update_trx<<');
545: EXCEPTION
546: WHEN NO_DATA_FOUND THEN
547: cn_debug.print_msg('update_trx: in exception handler for NO_DATA_FOUND', 1);
548: fnd_file.put_line(fnd_file.Log, 'update_trx: in exception handler for NO_DATA_FOUND');

Line 548: fnd_file.put_line(fnd_file.Log, 'update_trx: in exception handler for NO_DATA_FOUND');

544: fnd_file.put_line(fnd_file.Log, 'update_trx<<');
545: EXCEPTION
546: WHEN NO_DATA_FOUND THEN
547: cn_debug.print_msg('update_trx: in exception handler for NO_DATA_FOUND', 1);
548: fnd_file.put_line(fnd_file.Log, 'update_trx: in exception handler for NO_DATA_FOUND');
549: RETURN;
550: END update_trx;
551:
552:

Line 592: fnd_file.put_line(fnd_file.Log, 'insert_lines>>');

588: cn_utils.appendcr(code);
589: cn_utils.appendcr(code, '--******** INSERT CN_TRX_LINES *********-- ');
590:
591: cn_debug.print_msg('insert_lines>>', 1);
592: fnd_file.put_line(fnd_file.Log, 'insert_lines>>');
593: cn_debug.print_msg('insert_lines: x_module_id = ' || x_module_id, 1);
594:
595: -- Generate the INSERT statement
596: cn_debug.print_msg('insert_lines: Generating INSERT statement.', 1);

Line 597: fnd_file.put_line(fnd_file.Log, 'insert_lines: Generating INSERT statement.');

593: cn_debug.print_msg('insert_lines: x_module_id = ' || x_module_id, 1);
594:
595: -- Generate the INSERT statement
596: cn_debug.print_msg('insert_lines: Generating INSERT statement.', 1);
597: fnd_file.put_line(fnd_file.Log, 'insert_lines: Generating INSERT statement.');
598:
599: cn_utils.set_org_id(p_org_id => l_org_id);
600:
601: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserting into CN_TRX_LINES .'');');

Line 602: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserting into CN_TRX_LINES .'');');

598:
599: cn_utils.set_org_id(p_org_id => l_org_id);
600:
601: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserting into CN_TRX_LINES .'');');
602: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserting into CN_TRX_LINES .'');');
603: cn_utils.appendcr(code);
604:
605: cn_utils.appindcr(code, 'INSERT INTO cn_trx_lines(');
606: cn_utils.indent(code, 1);

Line 664: fnd_file.put_line(fnd_file.Log, 'insert_lines: Generated INSERT statement.');

660: -- Generate code to update the trx_line_count variable
661: cn_utils.appendcr(code);
662: cn_utils.appindcr(code, 'trx_line_count := SQL%ROWCOUNT;');
663: cn_debug.print_msg('insert_lines: Generated INSERT statement.', 1);
664: fnd_file.put_line(fnd_file.Log, 'insert_lines: Generated INSERT statement.');
665: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || trx_line_count || '' records into cn_trx_lines.'');');
666: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_line_count || '' records into cn_trx_lines.'');');
667: cn_utils.appendcr(code);
668:

Line 666: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_line_count || '' records into cn_trx_lines.'');');

662: cn_utils.appindcr(code, 'trx_line_count := SQL%ROWCOUNT;');
663: cn_debug.print_msg('insert_lines: Generated INSERT statement.', 1);
664: fnd_file.put_line(fnd_file.Log, 'insert_lines: Generated INSERT statement.');
665: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || trx_line_count || '' records into cn_trx_lines.'');');
666: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_line_count || '' records into cn_trx_lines.'');');
667: cn_utils.appendcr(code);
668:
669: cn_debug.print_msg('insert_lines<<', 1);
670: fnd_file.put_line(fnd_file.Log, 'insert_lines<<');

Line 670: fnd_file.put_line(fnd_file.Log, 'insert_lines<<');

666: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || procedure_name || ': Inserted '' || trx_line_count || '' records into cn_trx_lines.'');');
667: cn_utils.appendcr(code);
668:
669: cn_debug.print_msg('insert_lines<<', 1);
670: fnd_file.put_line(fnd_file.Log, 'insert_lines<<');
671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN
673: cn_debug.print_msg('insert_lines: in exception handler for NO_DATA_FOUND', 1);
674: fnd_file.put_line(fnd_file.Log, 'insert_lines: in exception handler for NO_DATA_FOUND');

Line 674: fnd_file.put_line(fnd_file.Log, 'insert_lines: in exception handler for NO_DATA_FOUND');

670: fnd_file.put_line(fnd_file.Log, 'insert_lines<<');
671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN
673: cn_debug.print_msg('insert_lines: in exception handler for NO_DATA_FOUND', 1);
674: fnd_file.put_line(fnd_file.Log, 'insert_lines: in exception handler for NO_DATA_FOUND');
675: RETURN;
676: END insert_lines;
677:
678:

Line 702: fnd_file.put_line(fnd_file.Log, 'update_lines>>');

698: cn_utils.appendcr(code);
699: cn_utils.appendcr(code, '--******** UPDATE CN_TRX_LINES ********-- ');
700:
701: cn_debug.print_msg('update_lines>>', 1);
702: fnd_file.put_line(fnd_file.Log, 'update_lines>>');
703: cn_debug.print_msg('update_lines: x_module_id = ' || x_module_id, 1);
704:
705:
706: -- Generate the UPDATE statement

Line 708: fnd_file.put_line(fnd_file.Log, 'update_lines: Generating UPDATE statement.');

704:
705:
706: -- Generate the UPDATE statement
707: cn_debug.print_msg('update_lines: Generating UPDATE statement.', 1);
708: fnd_file.put_line(fnd_file.Log, 'update_lines: Generating UPDATE statement.');
709:
710: cn_utils.set_org_id(p_org_id => l_org_id);
711: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX_LINES .'');');
712: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX_LINES .'');');

Line 712: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX_LINES .'');');

708: fnd_file.put_line(fnd_file.Log, 'update_lines: Generating UPDATE statement.');
709:
710: cn_utils.set_org_id(p_org_id => l_org_id);
711: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX_LINES .'');');
712: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX_LINES .'');');
713: cn_utils.appendcr(code);
714:
715: IF x_event_id <> cn_global.inv_event_id THEN
716:

Line 744: fnd_file.put_line(fnd_file.Log, 'update_lines: Generated UPDATE statement.');

740: -- Generate code to update the trx_line_update_count variable
741: cn_utils.appendcr(code);
742: cn_utils.appindcr(code, 'trx_line_update_count := SQL%ROWCOUNT;');
743: cn_debug.print_msg('update_lines: Generated UPDATE statement.', 1);
744: fnd_file.put_line(fnd_file.Log, 'update_lines: Generated UPDATE statement.');
745: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated '' || trx_line_update_count || '' cn_trx_lines.'');');
746: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_line_update_count || '' cn_trx_lines.'');');
747: cn_utils.appendcr(code);
748:

Line 746: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_line_update_count || '' cn_trx_lines.'');');

742: cn_utils.appindcr(code, 'trx_line_update_count := SQL%ROWCOUNT;');
743: cn_debug.print_msg('update_lines: Generated UPDATE statement.', 1);
744: fnd_file.put_line(fnd_file.Log, 'update_lines: Generated UPDATE statement.');
745: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated '' || trx_line_update_count || '' cn_trx_lines.'');');
746: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_line_update_count || '' cn_trx_lines.'');');
747: cn_utils.appendcr(code);
748:
749: cn_debug.print_msg('update_lines<<', 1);
750: fnd_file.put_line(fnd_file.Log, 'update_lines<<');

Line 750: fnd_file.put_line(fnd_file.Log, 'update_lines<<');

746: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_line_update_count || '' cn_trx_lines.'');');
747: cn_utils.appendcr(code);
748:
749: cn_debug.print_msg('update_lines<<', 1);
750: fnd_file.put_line(fnd_file.Log, 'update_lines<<');
751: EXCEPTION
752: WHEN NO_DATA_FOUND THEN
753: cn_debug.print_msg('update_lines: in exception handler for NO_DATA_FOUND', 1);
754: fnd_file.put_line(fnd_file.Log, 'update_lines: in exception handler for NO_DATA_FOUND');

Line 754: fnd_file.put_line(fnd_file.Log, 'update_lines: in exception handler for NO_DATA_FOUND');

750: fnd_file.put_line(fnd_file.Log, 'update_lines<<');
751: EXCEPTION
752: WHEN NO_DATA_FOUND THEN
753: cn_debug.print_msg('update_lines: in exception handler for NO_DATA_FOUND', 1);
754: fnd_file.put_line(fnd_file.Log, 'update_lines: in exception handler for NO_DATA_FOUND');
755: RETURN;
756: END update_lines;
757:
758:

Line 801: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines>>');

797: cn_utils.appendcr(code);
798: cn_utils.appendcr(code, '--******** INSERT CN_TRX_SALES_LINES ********-- ');
799:
800: cn_debug.print_msg('insert_sales_lines>>', 1);
801: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines>>');
802: -- Initialize value of table_map_id, etc.
803: -- Assumption: there is exactly 1 table at the sales credit level
804: -- in each repository.
805:

Line 808: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Updating object dependencies and module object maps.');

804: -- in each repository.
805:
806: cn_debug.print_msg('insert_sales_lines: x_module_id = ' || x_module_id, 1);
807: cn_debug.print_msg('insert_sales_lines: Updating object dependencies and module object maps.', 1);
808: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Updating object dependencies and module object maps.');
809:
810: -- Generate the insert clause
811: cn_debug.print_msg('insert_sales_lines: Generating INSERT statement.', 1);
812: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generating INSERT statement.');

Line 812: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generating INSERT statement.');

808: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Updating object dependencies and module object maps.');
809:
810: -- Generate the insert clause
811: cn_debug.print_msg('insert_sales_lines: Generating INSERT statement.', 1);
812: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generating INSERT statement.');
813:
814: cn_utils.set_org_id(p_org_id => l_org_id);
815: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserting into CN_TRX_SALES_LINES .'');');
816: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserting into CN_TRX_SALES_LINES .'');');

Line 816: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserting into CN_TRX_SALES_LINES .'');');

812: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generating INSERT statement.');
813:
814: cn_utils.set_org_id(p_org_id => l_org_id);
815: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserting into CN_TRX_SALES_LINES .'');');
816: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserting into CN_TRX_SALES_LINES .'');');
817: cn_utils.appendcr(code);
818:
819: cn_utils.appindcr(code, 'INSERT INTO cn_trx_sales_lines (');
820: cn_utils.indent(code, 1);

Line 985: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generated INSERT statement.');

981: -- Update trx_sales_line_count variable
982: cn_utils.appendcr(code);
983: cn_utils.appindcr(code, 'trx_sales_line_count := SQL%ROWCOUNT;');
984: cn_debug.print_msg('insert_sales_lines: Generated INSERT statement.', 1);
985: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generated INSERT statement.');
986: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || trx_sales_line_count || '' records into cn_trx_sales_lines.'');');
987: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserted '' || trx_sales_line_count || '' records into cn_trx_sales_lines.'');');
988: cn_utils.appendcr(code);
989:

Line 987: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserted '' || trx_sales_line_count || '' records into cn_trx_sales_lines.'');');

983: cn_utils.appindcr(code, 'trx_sales_line_count := SQL%ROWCOUNT;');
984: cn_debug.print_msg('insert_sales_lines: Generated INSERT statement.', 1);
985: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generated INSERT statement.');
986: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || trx_sales_line_count || '' records into cn_trx_sales_lines.'');');
987: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserted '' || trx_sales_line_count || '' records into cn_trx_sales_lines.'');');
988: cn_utils.appendcr(code);
989:
990: cn_debug.print_msg('insert_sales_lines<<', 1);
991: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines<<');

Line 991: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines<<');

987: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserted '' || trx_sales_line_count || '' records into cn_trx_sales_lines.'');');
988: cn_utils.appendcr(code);
989:
990: cn_debug.print_msg('insert_sales_lines<<', 1);
991: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines<<');
992:
993: IF (x_event_id = cn_global.ram_event_id) THEN
994: cn_utils.appindcr(code, 'UPDATE cn_trx_lines');
995: cn_utils.appindcr(code, ' SET collected_flag = ''Y''');

Line 1005: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated collected_flag in cn_trx_lines.'');');

1001: cn_utils.appindcr(code, ' AND event_id = cn_global.inv_event_id ');
1002: cn_utils.appindcr(code, ' AND adj_batch_id = x_adj_batch_id;');
1003: cn_utils.appendcr(code);
1004: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated collected_flag in cn_trx_lines.'');');
1005: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated collected_flag in cn_trx_lines.'');');
1006: END IF; --IF (x_event_id = cn_global.ram_event_id)
1007:
1008: EXCEPTION
1009: WHEN NO_DATA_FOUND THEN

Line 1011: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: in exception handler for NO_DATA_FOUND');

1007:
1008: EXCEPTION
1009: WHEN NO_DATA_FOUND THEN
1010: cn_debug.print_msg('insert_sales_lines: in exception handler for NO_DATA_FOUND', 1);
1011: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: in exception handler for NO_DATA_FOUND');
1012: RETURN;
1013: END insert_sales_lines;
1014:
1015:

Line 1040: fnd_file.put_line(fnd_file.Log, 'update_sales_lines>>');

1036: cn_utils.appendcr(code);
1037: cn_utils.appendcr(code, '--******** UPDATE CN_TRX_SALES_LINES ********-- ');
1038:
1039: cn_debug.print_msg('update_sales_lines>>', 1);
1040: fnd_file.put_line(fnd_file.Log, 'update_sales_lines>>');
1041: cn_debug.print_msg('update_sales_lines: x_module_id = ' || x_module_id, 1);
1042:
1043: cn_debug.print_msg('update_sales_lines: Generating UPDATE statement.', 1);
1044: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: Generating UPDATE statement.');

Line 1044: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: Generating UPDATE statement.');

1040: fnd_file.put_line(fnd_file.Log, 'update_sales_lines>>');
1041: cn_debug.print_msg('update_sales_lines: x_module_id = ' || x_module_id, 1);
1042:
1043: cn_debug.print_msg('update_sales_lines: Generating UPDATE statement.', 1);
1044: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: Generating UPDATE statement.');
1045:
1046: cn_utils.set_org_id(p_org_id => l_org_id);
1047: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX_SALES_LINES .'');');
1048: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX_SALES_LINES .'');');

Line 1048: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX_SALES_LINES .'');');

1044: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: Generating UPDATE statement.');
1045:
1046: cn_utils.set_org_id(p_org_id => l_org_id);
1047: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX_SALES_LINES .'');');
1048: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX_SALES_LINES .'');');
1049: cn_utils.appendcr(code);
1050:
1051: -- Generate the UPDATE statement
1052: cn_utils.appindcr(code, 'UPDATE cn_trx_sales_lines ctsl');

Line 1134: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: Generated UPDATE statement.');

1130: -- Update trx_sales_line_update_count variable
1131: cn_utils.appendcr(code);
1132: cn_utils.appindcr(code, 'trx_sales_line_update_count := SQL%ROWCOUNT;');
1133: cn_debug.print_msg('update_sales_lines: Generated UPDATE statement.', 1);
1134: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: Generated UPDATE statement.');
1135: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated '' || trx_sales_line_update_count || '' records in cn_trx_sales_lines.'');');
1136: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_sales_line_update_count || '' records in cn_trx_sales_lines.'');');
1137: cn_utils.appendcr(code);
1138:

Line 1136: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_sales_line_update_count || '' records in cn_trx_sales_lines.'');');

1132: cn_utils.appindcr(code, 'trx_sales_line_update_count := SQL%ROWCOUNT;');
1133: cn_debug.print_msg('update_sales_lines: Generated UPDATE statement.', 1);
1134: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: Generated UPDATE statement.');
1135: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated '' || trx_sales_line_update_count || '' records in cn_trx_sales_lines.'');');
1136: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_sales_line_update_count || '' records in cn_trx_sales_lines.'');');
1137: cn_utils.appendcr(code);
1138:
1139: cn_debug.print_msg('update_sales_lines<<', 1);
1140: fnd_file.put_line(fnd_file.Log, 'update_sales_lines<<');

Line 1140: fnd_file.put_line(fnd_file.Log, 'update_sales_lines<<');

1136: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated '' || trx_sales_line_update_count || '' records in cn_trx_sales_lines.'');');
1137: cn_utils.appendcr(code);
1138:
1139: cn_debug.print_msg('update_sales_lines<<', 1);
1140: fnd_file.put_line(fnd_file.Log, 'update_sales_lines<<');
1141: EXCEPTION
1142: WHEN NO_DATA_FOUND THEN
1143: cn_debug.print_msg('update_sales_lines: in exception handler for NO_DATA_FOUND', 1);
1144: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: in exception handler for NO_DATA_FOUND');

Line 1144: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: in exception handler for NO_DATA_FOUND');

1140: fnd_file.put_line(fnd_file.Log, 'update_sales_lines<<');
1141: EXCEPTION
1142: WHEN NO_DATA_FOUND THEN
1143: cn_debug.print_msg('update_sales_lines: in exception handler for NO_DATA_FOUND', 1);
1144: fnd_file.put_line(fnd_file.Log, 'update_sales_lines: in exception handler for NO_DATA_FOUND');
1145: RETURN;
1146: END update_sales_lines;
1147:
1148:

Line 1173: fnd_file.put_line(fnd_file.Log, 'update_invoice_total: Generating UPDATE statement.');

1169: -- Generate the update statement for updating invoice_total.
1170: -- This could not be done when we updated cn_trx earlier since we had not
1171: -- collected lines then
1172: cn_debug.print_msg('update_invoice_total: Generating UPDATE statement.', 1);
1173: fnd_file.put_line(fnd_file.Log, 'update_invoice_total: Generating UPDATE statement.');
1174:
1175: cn_utils.set_org_id(p_org_id => l_org_id);
1176: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX invoice_total.'');');
1177: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX invoice_total.'');');

Line 1177: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX invoice_total.'');');

1173: fnd_file.put_line(fnd_file.Log, 'update_invoice_total: Generating UPDATE statement.');
1174:
1175: cn_utils.set_org_id(p_org_id => l_org_id);
1176: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updating CN_TRX invoice_total.'');');
1177: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updating CN_TRX invoice_total.'');');
1178: cn_utils.appindcr(code, '-- This could not be done when we updated cn_trx earlier ');
1179: cn_utils.appindcr(code, '-- since we had not collected lines then');
1180: cn_utils.appendcr(code);
1181: cn_utils.appindcr(code, 'UPDATE cn_trx ct');

Line 1195: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated cn_trx invoice_total.'');');

1191: cn_utils.appindcr(code, ' AND ct.org_id = '||x_org_id||';');
1192:
1193: cn_utils.appendcr(code);
1194: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated cn_trx invoice_total.'');');
1195: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated cn_trx invoice_total.'');');
1196: cn_utils.appendcr(code);
1197: cn_debug.print_msg('update_invoice_total: Generated UPDATE statement.', 1);
1198: fnd_file.put_line(fnd_file.Log, 'update_invoice_total: Generated UPDATE statement.');
1199:

Line 1198: fnd_file.put_line(fnd_file.Log, 'update_invoice_total: Generated UPDATE statement.');

1194: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated cn_trx invoice_total.'');');
1195: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated cn_trx invoice_total.'');');
1196: cn_utils.appendcr(code);
1197: cn_debug.print_msg('update_invoice_total: Generated UPDATE statement.', 1);
1198: fnd_file.put_line(fnd_file.Log, 'update_invoice_total: Generated UPDATE statement.');
1199:
1200: END update_invoice_total;
1201:
1202:

Line 1256: fnd_file.put_line(fnd_file.Log, 'insert_comm_lines_api>>');

1252: cn_utils.appendcr(code);
1253: cn_utils.appendcr(code, '--******** INSERT CN_COMM_LINES_API ********-- ');
1254:
1255: cn_debug.print_msg('insert_comm_lines_api>>', 1);
1256: fnd_file.put_line(fnd_file.Log, 'insert_comm_lines_api>>');
1257:
1258: -- Generate the insert statement.
1259:
1260: cn_debug.print_msg('insert_sales_lines: Generating INSERT statement.', 1);

Line 1261: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generating INSERT statement.');

1257:
1258: -- Generate the insert statement.
1259:
1260: cn_debug.print_msg('insert_sales_lines: Generating INSERT statement.', 1);
1261: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generating INSERT statement.');
1262:
1263: cn_utils.set_org_id(p_org_id => l_org_id);
1264: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserting into CN_COMM_LINES_API .'');');
1265: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserting into CN_COMM_LINES_API .'');');

Line 1265: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserting into CN_COMM_LINES_API .'');');

1261: fnd_file.put_line(fnd_file.Log, 'insert_sales_lines: Generating INSERT statement.');
1262:
1263: cn_utils.set_org_id(p_org_id => l_org_id);
1264: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserting into CN_COMM_LINES_API .'');');
1265: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserting into CN_COMM_LINES_API .'');');
1266: cn_utils.appendcr(code);
1267: cn_utils.appindcr(code, 'INSERT INTO cn_comm_lines_api (');
1268: cn_utils.indent(code, 1);
1269: cn_utils.appindcr(code, 'comm_lines_api_id,');

Line 1404: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserted '' || comm_lines_api_count || '' records into CN_COMM_LINES_API.'');');

1400: cn_utils.appendcr(code);
1401: cn_utils.appindcr(code, 'comm_lines_api_count := SQL%ROWCOUNT;');
1402:
1403: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserted '' || comm_lines_api_count || '' records into CN_COMM_LINES_API.'');');
1404: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserted '' || comm_lines_api_count || '' records into CN_COMM_LINES_API.'');');
1405: cn_utils.appendcr(code);
1406:
1407:
1408: -- Update columns populated by user-defined DIRECT mappings. We do this with a query

Line 1488: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': For user DIRECT mappings, updated '' || comm_lines_api_update_count || '' records in CN_COMM_LINES_API.'');');

1484: cn_utils.appendcr(code);
1485: cn_utils.appindcr(code, 'comm_lines_api_update_count := SQL%ROWCOUNT;');
1486:
1487: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': For user DIRECT mappings, updated '' || comm_lines_api_update_count || '' records in CN_COMM_LINES_API.'');');
1488: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': For user DIRECT mappings, updated '' || comm_lines_api_update_count || '' records in CN_COMM_LINES_API.'');');
1489: cn_utils.appendcr(code);
1490: END IF;
1491:
1492: EXCEPTION

Line 1495: fnd_file.put_line(fnd_file.Log, 'insert_comm_lines: in exception handler for NO_DATA_FOUND');

1491:
1492: EXCEPTION
1493: WHEN NO_DATA_FOUND THEN
1494: cn_debug.print_msg('insert_comm_lines: in exception handler for NO_DATA_FOUND', 1);
1495: fnd_file.put_line(fnd_file.Log, 'insert_comm_lines: in exception handler for NO_DATA_FOUND');
1496: RETURN;
1497: END insert_comm_lines;
1498:
1499: END cn_collection_ar_gen;