DBA Data[Home] [Help]

APPS.GL_AS_POST_UPG_CHK_PKG dependencies on FND_FILE

Line 355: FND_FILE.put_line

351:
352: -- Write the HTML header section
353: v_status_code := 'WRITE_HTML_HDR';
354:
355: FND_FILE.put_line
356: (FND_FILE.output,
357: ''
358: ||pv_nl||''
359: ||pv_nl||''<br> </p> <h5>Line 356: (FND_FILE.output,<br> </h5><p> 352: -- Write the HTML header section<br> 353: v_status_code := 'WRITE_HTML_HDR';<br> 354: <br> 355: FND_FILE.put_line<br> <b>356: (FND_FILE.output,<br> </b>357: '<html>'<br> 358: ||pv_nl||'<head><meta name="viewport" content="width=device-width, initial-scale=1.0"><script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-2769267478437092" crossorigin="anonymous"></script>'<br> 359: ||pv_nl||'<title>'<br> 360: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_RPT_TITLE')<br> </p> <h5>Line 365: FND_FILE.put_line<br> </h5><p> 361: ||''
362: ||pv_nl||'');
364:
365: FND_FILE.put_line
366: (FND_FILE.output,
367: pv_nl||'');
381:
382: FND_FILE.put_line
383: (FND_FILE.output,
384: pv_nl||'

Web Analytics Made Easy -StatCounter
'
385: ||pv_nl||'');
386:

Line 383: (FND_FILE.output,

379: ||'sans-serif; font-size:10pt; color:#000000}'
380: ||pv_nl||' .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } ');
381:
382: FND_FILE.put_line
383: (FND_FILE.output,
384: pv_nl||'

Web Analytics Made Easy -StatCounter
'
385: ||pv_nl||'');
386:
387: -- Write the report title

Line 390: FND_FILE.put_line

386:
387: -- Write the report title
388: v_status_code := 'WRITE_RPT_TITLE';
389:
390: FND_FILE.put_line
391: (FND_FILE.output,
392: pv_nl||'

'
393: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_RPT_TITLE')
394: ||'

'

Line 391: (FND_FILE.output,

387: -- Write the report title
388: v_status_code := 'WRITE_RPT_TITLE';
389:
390: FND_FILE.put_line
391: (FND_FILE.output,
392: pv_nl||'

'
393: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_RPT_TITLE')
394: ||'

'
395: ||pv_nl||'

As of '

Line 399: FND_FILE.put_line

395: ||pv_nl||'

As of '
396: ||TO_CHAR(SYSDATE, 'DD-MON-YY HH:MM:SS')||'

');
397:
398: -- Print the message GL_ASU_ADDITIONAL_INFO
399: FND_FILE.put_line
400: (FND_FILE.output,
401: pv_nl||'
'
402: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_ADDITIONAL_INFO')
403: ||'
');

Line 400: (FND_FILE.output,

396: ||TO_CHAR(SYSDATE, 'DD-MON-YY HH:MM:SS')||'

');
397:
398: -- Print the message GL_ASU_ADDITIONAL_INFO
399: FND_FILE.put_line
400: (FND_FILE.output,
401: pv_nl||'
'
402: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_ADDITIONAL_INFO')
403: ||'
');
404:

Line 409: FND_FILE.put_line

405: v_status_code := 'CHECK_UNASSIGNED_ALC';
406: -- Check if there are any unassigned ALCs
407:
408: -- Print section title
409: FND_FILE.put_line
410: (FND_FILE.output,
411: pv_nl||'
'
412: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_UNASSIGN_RC')
413: ||'
');

Line 410: (FND_FILE.output,

406: -- Check if there are any unassigned ALCs
407:
408: -- Print section title
409: FND_FILE.put_line
410: (FND_FILE.output,
411: pv_nl||'
'
412: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_UNASSIGN_RC')
413: ||'
');
414:

Line 442: FND_FILE.put_line(FND_FILE.output, pv_nl||v_unassigned_alc.row_text);

438:
439: END IF;
440:
441: -- Print the row text
442: FND_FILE.put_line(FND_FILE.output, pv_nl||v_unassigned_alc.row_text);
443:
444: END LOOP;
445:
446: -- Check if we have print Unassigned ALC table

Line 450: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

446: -- Check if we have print Unassigned ALC table
447: IF (v_status_code = 'PRINT_UNASSIGNED_ALC_ROW')
448: THEN
449: -- Some rows are printed
450: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
451: ELSE
452: -- No setup issues are found
453: FND_FILE.put_line(FND_FILE.output,
454: pv_nl||''

Line 453: FND_FILE.put_line(FND_FILE.output,

449: -- Some rows are printed
450: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
451: ELSE
452: -- No setup issues are found
453: FND_FILE.put_line(FND_FILE.output,
454: pv_nl||''
455: ||FND_MESSAGE.Get_String('SQLGL',
456: 'GL_ASU_NO_ISSUES')
457: ||'
');

Line 464: FND_FILE.put_line

460: v_status_code := 'CHECK_MULTI_SRC_ALC';
461: -- Check if there are any ALCs assigned to multiple Sources
462:
463: -- Print section title
464: FND_FILE.put_line
465: (FND_FILE.output,
466: pv_nl||'
'
467: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_MULTI_SRC_RC')
468: ||'
');

Line 465: (FND_FILE.output,

461: -- Check if there are any ALCs assigned to multiple Sources
462:
463: -- Print section title
464: FND_FILE.put_line
465: (FND_FILE.output,
466: pv_nl||'
'
467: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_MULTI_SRC_RC')
468: ||'
');
469:

Line 501: FND_FILE.put_line(FND_FILE.output, pv_nl||v_multi_src_alc.row_text);

497:
498: END IF;
499:
500: -- Print the row text
501: FND_FILE.put_line(FND_FILE.output, pv_nl||v_multi_src_alc.row_text);
502:
503: END LOOP;
504:
505: -- Check if we have print Multi-Source ALC table

Line 509: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

505: -- Check if we have print Multi-Source ALC table
506: IF (v_status_code = 'PRINT_MULTI_SRC_ALC_ROW')
507: THEN
508: -- Some rows are printed
509: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
510: ELSE
511: -- No setup issues are found
512: FND_FILE.put_line(FND_FILE.output,
513: pv_nl||''

Line 512: FND_FILE.put_line(FND_FILE.output,

508: -- Some rows are printed
509: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
510: ELSE
511: -- No setup issues are found
512: FND_FILE.put_line(FND_FILE.output,
513: pv_nl||''
514: ||FND_MESSAGE.Get_String('SQLGL',
515: 'GL_ASU_NO_ISSUES')
516: ||'
');

Line 523: FND_FILE.put_line

519: v_status_code := 'CHECK_ALC_TCURR';
520: -- Check if any ALC Ledgers have Balance Level ALC
521:
522: -- Print section title
523: FND_FILE.put_line
524: (FND_FILE.output,
525: pv_nl||'
'
526: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BLRC_SRC')
527: ||'
');

Line 524: (FND_FILE.output,

520: -- Check if any ALC Ledgers have Balance Level ALC
521:
522: -- Print section title
523: FND_FILE.put_line
524: (FND_FILE.output,
525: pv_nl||'
'
526: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BLRC_SRC')
527: ||'
');
528:

Line 559: FND_FILE.put_line(FND_FILE.output, pv_nl||v_alc_tcurr.row_text);

555:
556: END IF;
557:
558: -- Print the row text
559: FND_FILE.put_line(FND_FILE.output, pv_nl||v_alc_tcurr.row_text);
560:
561: END LOOP;
562:
563: -- Check if we have print RSOB Translated Currencies table

Line 567: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

563: -- Check if we have print RSOB Translated Currencies table
564: IF (v_status_code = 'PRINT_ALC_TCURR_ROW')
565: THEN
566: -- Some rows are printed
567: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
568: ELSE
569: -- No setup issues are found
570: FND_FILE.put_line(FND_FILE.output,
571: pv_nl||''

Line 570: FND_FILE.put_line(FND_FILE.output,

566: -- Some rows are printed
567: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
568: ELSE
569: -- No setup issues are found
570: FND_FILE.put_line(FND_FILE.output,
571: pv_nl||''
572: ||FND_MESSAGE.Get_String('SQLGL',
573: 'GL_ASU_NO_ISSUES')
574: ||'
');

Line 581: FND_FILE.put_line

577: v_status_code := 'CHECK_JOURNAL_ALC';
578: -- Check if there are any journal level ALC Ledgers
579:
580: -- Print section title
581: FND_FILE.put_line
582: (FND_FILE.output,
583: pv_nl||'
'
584: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_JLRC_REVIEW')
585: ||'
');

Line 582: (FND_FILE.output,

578: -- Check if there are any journal level ALC Ledgers
579:
580: -- Print section title
581: FND_FILE.put_line
582: (FND_FILE.output,
583: pv_nl||'
'
584: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_JLRC_REVIEW')
585: ||'
');
586:

Line 618: FND_FILE.put_line(FND_FILE.output, pv_nl||v_journal_alc.row_text);

614:
615: END IF;
616:
617: -- Print the row text
618: FND_FILE.put_line(FND_FILE.output, pv_nl||v_journal_alc.row_text);
619:
620: END LOOP;
621:
622: -- Check if we have print Journal Level ALC Ledgers table

Line 626: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

622: -- Check if we have print Journal Level ALC Ledgers table
623: IF (v_status_code = 'PRINT_JOURNAL_ALC_ROW')
624: THEN
625: -- Some rows are printed
626: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
627: ELSE
628: -- No setup issues are found
629: FND_FILE.put_line(FND_FILE.output,
630: pv_nl||''

Line 629: FND_FILE.put_line(FND_FILE.output,

625: -- Some rows are printed
626: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
627: ELSE
628: -- No setup issues are found
629: FND_FILE.put_line(FND_FILE.output,
630: pv_nl||''
631: ||FND_MESSAGE.Get_String('SQLGL',
632: 'GL_ASU_NO_ISSUES')
633: ||'
');

Line 641: FND_FILE.put_line

637: -- Check if there are any Subledger Level ALC GL relationships created by
638: -- the Upgrade
639:
640: -- Print section title
641: FND_FILE.put_line
642: (FND_FILE.output,
643: pv_nl||'
'
644: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_GL_CRT')
645: ||'
');

Line 642: (FND_FILE.output,

638: -- the Upgrade
639:
640: -- Print section title
641: FND_FILE.put_line
642: (FND_FILE.output,
643: pv_nl||'
'
644: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_GL_CRT')
645: ||'
');
646:

Line 687: FND_FILE.put_line(FND_FILE.output, pv_nl||v_crt_gl_rs.row_text);

683: v_status_code := 'PRINT_CRT_GL_RS_ROW';
684:
685: END IF;
686:
687: FND_FILE.put_line(FND_FILE.output, pv_nl||v_crt_gl_rs.row_text);
688:
689: END LOOP;
690:
691: -- Check if we have print GL Setup Created by Upgrade table

Line 695: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

691: -- Check if we have print GL Setup Created by Upgrade table
692: IF (v_status_code = 'PRINT_CRT_GL_RS_ROW')
693: THEN
694: -- Some rows are printed
695: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
696: ELSE
697: -- No setup issues are found
698: FND_FILE.put_line(FND_FILE.output,
699: pv_nl||''

Line 698: FND_FILE.put_line(FND_FILE.output,

694: -- Some rows are printed
695: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
696: ELSE
697: -- No setup issues are found
698: FND_FILE.put_line(FND_FILE.output,
699: pv_nl||''
700: ||FND_MESSAGE.Get_String('SQLGL',
701: 'GL_ASU_NO_ISSUES')
702: ||'
');

Line 709: FND_FILE.put_line

705: v_status_code := 'CHECK_INVALID_JRULE';
706: -- Check if there are any invalid journal inclusion rules setup
707:
708: -- Print section title
709: FND_FILE.put_line
710: (FND_FILE.output,
711: pv_nl||'
'
712: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_JRULE')
713: ||'
');

Line 710: (FND_FILE.output,

706: -- Check if there are any invalid journal inclusion rules setup
707:
708: -- Print section title
709: FND_FILE.put_line
710: (FND_FILE.output,
711: pv_nl||'
'
712: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_JRULE')
713: ||'
');
714:

Line 746: FND_FILE.put_line(FND_FILE.output, pv_nl||v_invalid_jrule.row_text);

742:
743: END IF;
744:
745: -- Print the row text
746: FND_FILE.put_line(FND_FILE.output, pv_nl||v_invalid_jrule.row_text);
747:
748: END LOOP;
749:
750: -- Check if we have print Invalid Journal Inclusion Rules table

Line 754: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

750: -- Check if we have print Invalid Journal Inclusion Rules table
751: IF (v_status_code = 'PRINT_INVALID_JRULE_ROW')
752: THEN
753: -- Some rows are printed
754: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
755: ELSE
756: -- No setup issues are found
757: FND_FILE.put_line(FND_FILE.output,
758: pv_nl||''

Line 757: FND_FILE.put_line(FND_FILE.output,

753: -- Some rows are printed
754: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
755: ELSE
756: -- No setup issues are found
757: FND_FILE.put_line(FND_FILE.output,
758: pv_nl||''
759: ||FND_MESSAGE.Get_String('SQLGL',
760: 'GL_ASU_NO_ISSUES')
761: ||'
');

Line 768: FND_FILE.put_line

764: v_status_code := 'CHECK_DIFF_SETUP_ALC';
765: -- Check if there are any ALC with inconsistent setup
766:
767: -- Print section title
768: FND_FILE.put_line
769: (FND_FILE.output,
770: pv_nl||'
'
771: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_DIFF')
772: ||'
');

Line 769: (FND_FILE.output,

765: -- Check if there are any ALC with inconsistent setup
766:
767: -- Print section title
768: FND_FILE.put_line
769: (FND_FILE.output,
770: pv_nl||'
'
771: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_DIFF')
772: ||'
');
773:

Line 809: FND_FILE.put_line(FND_FILE.output, pv_nl||v_diff_setup_alc.row_text);

805:
806: END IF;
807:
808: -- Print the row text
809: FND_FILE.put_line(FND_FILE.output, pv_nl||v_diff_setup_alc.row_text);
810:
811: END LOOP;
812:
813: -- Check if we have print Inconsisent ALC Setup table

Line 817: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

813: -- Check if we have print Inconsisent ALC Setup table
814: IF (v_status_code = 'PRINT_DIFF_SETUP_ALC_ROW')
815: THEN
816: -- Some rows are printed
817: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
818: ELSE
819: -- No setup issues are found
820: FND_FILE.put_line(FND_FILE.output,
821: pv_nl||''

Line 820: FND_FILE.put_line(FND_FILE.output,

816: -- Some rows are printed
817: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
818: ELSE
819: -- No setup issues are found
820: FND_FILE.put_line(FND_FILE.output,
821: pv_nl||''
822: ||FND_MESSAGE.Get_String('SQLGL',
823: 'GL_ASU_NO_ISSUES')
824: ||'
');

Line 831: FND_FILE.put_line

827: v_status_code := 'CHECK_PARTIAL_SETUP_ALC';
828: -- Check if there are any ALC Ledgers with partial setup only
829:
830: -- Print section title
831: FND_FILE.put_line
832: (FND_FILE.output,
833: pv_nl||'
'
834: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_PARTIAL')
835: ||'
');

Line 832: (FND_FILE.output,

828: -- Check if there are any ALC Ledgers with partial setup only
829:
830: -- Print section title
831: FND_FILE.put_line
832: (FND_FILE.output,
833: pv_nl||'
'
834: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_PARTIAL')
835: ||'
');
836:

Line 866: FND_FILE.put_line(FND_FILE.output, pv_nl||v_partial_setup_alc.row_text);

862:
863: END IF;
864:
865: -- Print the row text
866: FND_FILE.put_line(FND_FILE.output, pv_nl||v_partial_setup_alc.row_text);
867:
868: END LOOP;
869:
870: -- Check if we have print Incomplete ALC Setup table

Line 874: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');

870: -- Check if we have print Incomplete ALC Setup table
871: IF (v_status_code = 'PRINT_PARTIAL_SETUP_ALC_ROW')
872: THEN
873: -- Some rows are printed
874: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
875: ELSE
876: -- No setup issues are found
877: FND_FILE.put_line(FND_FILE.output,
878: pv_nl||''

Line 877: FND_FILE.put_line(FND_FILE.output,

873: -- Some rows are printed
874: FND_FILE.put_line(FND_FILE.output, pv_nl||'
');
875: ELSE
876: -- No setup issues are found
877: FND_FILE.put_line(FND_FILE.output,
878: pv_nl||''
879: ||FND_MESSAGE.Get_String('SQLGL',
880: 'GL_ASU_NO_ISSUES')
881: ||'
');

Line 885: FND_FILE.put_line(FND_FILE.output, pv_nl||'');

881: ||'
');
882: END IF;
883:
884: -- Complete the HTML report
885: FND_FILE.put_line(FND_FILE.output, pv_nl||'');
886:
887: -- Log the success exit
888: GL_MESSAGE.Func_Succ(func_name => v_func_name,
889: log_level => pc_log_level_procedure,

Line 908: FND_FILE.put_line

904: x_errbuf := SQLERRM;
905: x_retcode := SQLCODE;
906:
907: -- Print the fatal error message
908: FND_FILE.put_line
909: (FND_FILE.output,
910: pv_nl||'
'
911: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')
912: ||'
');

Line 909: (FND_FILE.output,

905: x_retcode := SQLCODE;
906:
907: -- Print the fatal error message
908: FND_FILE.put_line
909: (FND_FILE.output,
910: pv_nl||'
'
911: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')
912: ||'
');
913: -- Complete the HTML report

Line 914: FND_FILE.put_line(FND_FILE.output, pv_nl||'');

910: pv_nl||'
'
911: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')
912: ||'
');
913: -- Complete the HTML report
914: FND_FILE.put_line(FND_FILE.output, pv_nl||'');
915:
916: -- Log the error exit
917: GL_MESSAGE.Func_Fail(func_name => v_func_name,
918: log_level => pc_log_level_procedure,

Line 934: FND_FILE.put_line(FND_FILE.log, x_errbuf);

930: x_errbuf := SQLERRM;
931: x_retcode := SQLCODE;
932:
933: -- Print the error message to program log file
934: FND_FILE.put_line(FND_FILE.log, x_errbuf);
935: -- Print the error message to FND Log
936: GL_MESSAGE.Write_Fndlog_String(log_level => pc_log_leveL_unexpected,
937: module => v_module,
938: message => x_errbuf);

Line 941: FND_FILE.put_line

937: module => v_module,
938: message => x_errbuf);
939:
940: -- Print the fatal error message
941: FND_FILE.put_line
942: (FND_FILE.output,
943: pv_nl||'
'
944: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')
945: ||'
');

Line 942: (FND_FILE.output,

938: message => x_errbuf);
939:
940: -- Print the fatal error message
941: FND_FILE.put_line
942: (FND_FILE.output,
943: pv_nl||'
'
944: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')
945: ||'
');
946: -- Complete the HTML report

Line 947: FND_FILE.put_line(FND_FILE.output, pv_nl||'');

943: pv_nl||'
'
944: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')
945: ||'
');
946: -- Complete the HTML report
947: FND_FILE.put_line(FND_FILE.output, pv_nl||'');
948:
949: -- Log the error exit
950: GL_MESSAGE.Func_Fail(func_name => v_func_name,
951: log_level => pc_log_level_procedure,

Line 982: FND_FILE.put_line

978: module => v_module);
979:
980: IF (p_info_msg_name IS NOT NULL)
981: THEN
982: FND_FILE.put_line
983: (FND_FILE.output,
984: pv_nl||''
985: ||FND_MESSAGE.Get_String('SQLGL', p_info_msg_name)
986: ||'
');

Line 983: (FND_FILE.output,

979:
980: IF (p_info_msg_name IS NOT NULL)
981: THEN
982: FND_FILE.put_line
983: (FND_FILE.output,
984: pv_nl||''
985: ||FND_MESSAGE.Get_String('SQLGL', p_info_msg_name)
986: ||'
');
987: END IF;

Line 991: FND_FILE.put_line

987: END IF;
988:
989: IF (p_column_text IS NOT NULL)
990: THEN
991: FND_FILE.put_line
992: (FND_FILE.output,
993: pv_nl||'');
994: FND_FILE.put_line
995: (FND_FILE.output,

Line 992: (FND_FILE.output,

988:
989: IF (p_column_text IS NOT NULL)
990: THEN
991: FND_FILE.put_line
992: (FND_FILE.output,
993: pv_nl||'

');
994: FND_FILE.put_line
995: (FND_FILE.output,
996: pv_nl||'');

Line 994: FND_FILE.put_line

990: THEN
991: FND_FILE.put_line
992: (FND_FILE.output,
993: pv_nl||'

');
994: FND_FILE.put_line
995: (FND_FILE.output,
996: pv_nl||'');
997: FND_FILE.put_line
998: (FND_FILE.output,

Line 995: (FND_FILE.output,

991: FND_FILE.put_line
992: (FND_FILE.output,
993: pv_nl||'

');
994: FND_FILE.put_line
995: (FND_FILE.output,
996: pv_nl||'');
997: FND_FILE.put_line
998: (FND_FILE.output,
999: pv_nl||p_column_text||'');

Line 997: FND_FILE.put_line

993: pv_nl||'

');
994: FND_FILE.put_line
995: (FND_FILE.output,
996: pv_nl||'');
997: FND_FILE.put_line
998: (FND_FILE.output,
999: pv_nl||p_column_text||'');
1000: END IF;
1001:

Line 998: (FND_FILE.output,

994: FND_FILE.put_line
995: (FND_FILE.output,
996: pv_nl||'

');
997: FND_FILE.put_line
998: (FND_FILE.output,
999: pv_nl||p_column_text||'');
1000: END IF;
1001:
1002: -- Log the success exit

Line 1011: FND_FILE.put_line(FND_FILE.log, SQLERRM);

1007: WHEN Others THEN
1008: -- <<< Unexpected database exceptions >>>
1009:
1010: -- Print the error message to program log file
1011: FND_FILE.put_line(FND_FILE.log, SQLERRM);
1012: -- Print the error message to FND Log
1013: GL_MESSAGE.Write_Fndlog_String(log_level => pc_log_leveL_unexpected,
1014: module => v_module,
1015: message => SQLERRM);