DBA Data[Home] [Help]

APPS.GL_AS_POST_UPG_CHK_PKG dependencies on FND_MESSAGE

Line 360: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_RPT_TITLE')

356: (FND_FILE.output,
357: ''
358: ||pv_nl||''
359: ||pv_nl||''<br> <b>360: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_RPT_TITLE')<br> </b>361: ||''
362: ||pv_nl||'');
364:

Line 393: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_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 '
396: ||TO_CHAR(SYSDATE, 'DD-MON-YY HH:MM:SS')||'

');
397:

Line 402: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_ADDITIONAL_INFO')

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:
405: v_status_code := 'CHECK_UNASSIGNED_ALC';
406: -- Check if there are any unassigned ALCs

Line 412: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_UNASSIGN_RC')

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:
415: FOR v_unassigned_alc IN c_unassigned_alc
416: LOOP

Line 424: ''||FND_MESSAGE.Get_String('SQLGL',

420: v_status_code := 'PRINT_UNASSIGNED_ALC_HDR';
421:
422: -- Build the column text
423: v_column_text :=
424: ''||FND_MESSAGE.Get_String('SQLGL',
425: 'GL_ASU_PRIMARY_LEDGER')
426: ||''||FND_MESSAGE.Get_String('SQLGL',
427: 'MRC_CURRSETUP_CURR')
428: ||''||FND_MESSAGE.Get_String('FND',

Line 426: ||''||FND_MESSAGE.Get_String('SQLGL',

422: -- Build the column text
423: v_column_text :=
424: ''||FND_MESSAGE.Get_String('SQLGL',
425: 'GL_ASU_PRIMARY_LEDGER')
426: ||''||FND_MESSAGE.Get_String('SQLGL',
427: 'MRC_CURRSETUP_CURR')
428: ||''||FND_MESSAGE.Get_String('FND',
429: 'FND_MENU_DESC_LABEL')
430: ||'';

Line 428: ||''||FND_MESSAGE.Get_String('FND',

424: ''||FND_MESSAGE.Get_String('SQLGL',
425: 'GL_ASU_PRIMARY_LEDGER')
426: ||''||FND_MESSAGE.Get_String('SQLGL',
427: 'MRC_CURRSETUP_CURR')
428: ||''||FND_MESSAGE.Get_String('FND',
429: 'FND_MENU_DESC_LABEL')
430: ||'';
431:
432: -- Print the info text and table column

Line 455: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
458: END IF;
459:

Line 467: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_MULTI_SRC_RC')

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:
470: FOR v_multi_src_alc IN c_multi_src_alc
471: LOOP

Line 479: ''||FND_MESSAGE.Get_String('SQLGL',

475: v_status_code := 'PRINT_MUTLI_SRC_ALC_HDR';
476:
477: -- Build the column text
478: v_column_text :=
479: ''||FND_MESSAGE.Get_String('SQLGL',
480: 'GL_ASU_RCURR')
481: ||''||FND_MESSAGE.Get_String('SQLGL',
482: 'MRC_CURRSETUP_CURR')
483: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 481: ||''||FND_MESSAGE.Get_String('SQLGL',

477: -- Build the column text
478: v_column_text :=
479: ''||FND_MESSAGE.Get_String('SQLGL',
480: 'GL_ASU_RCURR')
481: ||''||FND_MESSAGE.Get_String('SQLGL',
482: 'MRC_CURRSETUP_CURR')
483: ||''||FND_MESSAGE.Get_String('SQLGL',
484: 'GL_ASU_POST_RC_LEVEL')
485: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 483: ||''||FND_MESSAGE.Get_String('SQLGL',

479: ''||FND_MESSAGE.Get_String('SQLGL',
480: 'GL_ASU_RCURR')
481: ||''||FND_MESSAGE.Get_String('SQLGL',
482: 'MRC_CURRSETUP_CURR')
483: ||''||FND_MESSAGE.Get_String('SQLGL',
484: 'GL_ASU_POST_RC_LEVEL')
485: ||''||FND_MESSAGE.Get_String('SQLGL',
486: 'GL_ASU_POST_SRC_LG')
487: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 485: ||''||FND_MESSAGE.Get_String('SQLGL',

481: ||''||FND_MESSAGE.Get_String('SQLGL',
482: 'MRC_CURRSETUP_CURR')
483: ||''||FND_MESSAGE.Get_String('SQLGL',
484: 'GL_ASU_POST_RC_LEVEL')
485: ||''||FND_MESSAGE.Get_String('SQLGL',
486: 'GL_ASU_POST_SRC_LG')
487: ||''||FND_MESSAGE.Get_String('SQLGL',
488: 'GL_ASU_POST_SRC_CURR')
489: ||'';

Line 487: ||''||FND_MESSAGE.Get_String('SQLGL',

483: ||''||FND_MESSAGE.Get_String('SQLGL',
484: 'GL_ASU_POST_RC_LEVEL')
485: ||''||FND_MESSAGE.Get_String('SQLGL',
486: 'GL_ASU_POST_SRC_LG')
487: ||''||FND_MESSAGE.Get_String('SQLGL',
488: 'GL_ASU_POST_SRC_CURR')
489: ||'';
490:
491: -- Print the info text and table column

Line 514: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
517: END IF;
518:

Line 526: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BLRC_SRC')

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:
529: FOR v_alc_tcurr IN c_alc_tcurr
530: LOOP

Line 538: ''||FND_MESSAGE.Get_String('SQLGL',

534: v_status_code := 'PRINT_ALC_TCURR_HDR';
535:
536: -- Build the column text
537: v_column_text :=
538: ''||FND_MESSAGE.Get_String('SQLGL',
539: 'GL_ASU_RCURR')||' '
540: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BALANCE_LEVEL')
541: ||''||FND_MESSAGE.Get_String('SQLGL',
542: 'MRC_CURRSETUP_CURR')

Line 540: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BALANCE_LEVEL')

536: -- Build the column text
537: v_column_text :=
538: ''||FND_MESSAGE.Get_String('SQLGL',
539: 'GL_ASU_RCURR')||' '
540: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BALANCE_LEVEL')
541: ||''||FND_MESSAGE.Get_String('SQLGL',
542: 'MRC_CURRSETUP_CURR')
543: ||''||FND_MESSAGE.Get_String('SQLGL',
544: 'GL_ASU_POST_SRC_RC_JL_SL')

Line 541: ||''||FND_MESSAGE.Get_String('SQLGL',

537: v_column_text :=
538: ''||FND_MESSAGE.Get_String('SQLGL',
539: 'GL_ASU_RCURR')||' '
540: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BALANCE_LEVEL')
541: ||''||FND_MESSAGE.Get_String('SQLGL',
542: 'MRC_CURRSETUP_CURR')
543: ||''||FND_MESSAGE.Get_String('SQLGL',
544: 'GL_ASU_POST_SRC_RC_JL_SL')
545: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 543: ||''||FND_MESSAGE.Get_String('SQLGL',

539: 'GL_ASU_RCURR')||' '
540: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_BALANCE_LEVEL')
541: ||''||FND_MESSAGE.Get_String('SQLGL',
542: 'MRC_CURRSETUP_CURR')
543: ||''||FND_MESSAGE.Get_String('SQLGL',
544: 'GL_ASU_POST_SRC_RC_JL_SL')
545: ||''||FND_MESSAGE.Get_String('SQLGL',
546: 'GL_ASU_POST_SRC_CURR')
547: ||'';

Line 545: ||''||FND_MESSAGE.Get_String('SQLGL',

541: ||''||FND_MESSAGE.Get_String('SQLGL',
542: 'MRC_CURRSETUP_CURR')
543: ||''||FND_MESSAGE.Get_String('SQLGL',
544: 'GL_ASU_POST_SRC_RC_JL_SL')
545: ||''||FND_MESSAGE.Get_String('SQLGL',
546: 'GL_ASU_POST_SRC_CURR')
547: ||'';
548:
549: -- Print the info text and table column

Line 572: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
575: END IF;
576:

Line 584: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_JLRC_REVIEW')

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:
587: FOR v_journal_alc IN c_journal_alc
588: LOOP

Line 596: ''||FND_MESSAGE.Get_String('SQLGL',

592: v_status_code := 'PRINT_JOURNAL_ALC_HDR';
593:
594: -- Build the column text
595: v_column_text :=
596: ''||FND_MESSAGE.Get_String('SQLGL',
597: 'GL_ASU_RCURR')
598: ||''||FND_MESSAGE.Get_String('SQLGL',
599: 'MRC_CURRSETUP_CURR')
600: ||''||FND_MESSAGE.Get_String('FND',

Line 598: ||''||FND_MESSAGE.Get_String('SQLGL',

594: -- Build the column text
595: v_column_text :=
596: ''||FND_MESSAGE.Get_String('SQLGL',
597: 'GL_ASU_RCURR')
598: ||''||FND_MESSAGE.Get_String('SQLGL',
599: 'MRC_CURRSETUP_CURR')
600: ||''||FND_MESSAGE.Get_String('FND',
601: 'FND_MENU_DESC_LABEL')
602: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 600: ||''||FND_MESSAGE.Get_String('FND',

596: ''||FND_MESSAGE.Get_String('SQLGL',
597: 'GL_ASU_RCURR')
598: ||''||FND_MESSAGE.Get_String('SQLGL',
599: 'MRC_CURRSETUP_CURR')
600: ||''||FND_MESSAGE.Get_String('FND',
601: 'FND_MENU_DESC_LABEL')
602: ||''||FND_MESSAGE.Get_String('SQLGL',
603: 'GL_ASU_POST_SRC_LG')
604: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 602: ||''||FND_MESSAGE.Get_String('SQLGL',

598: ||''||FND_MESSAGE.Get_String('SQLGL',
599: 'MRC_CURRSETUP_CURR')
600: ||''||FND_MESSAGE.Get_String('FND',
601: 'FND_MENU_DESC_LABEL')
602: ||''||FND_MESSAGE.Get_String('SQLGL',
603: 'GL_ASU_POST_SRC_LG')
604: ||''||FND_MESSAGE.Get_String('SQLGL',
605: 'GL_ASU_POST_SRC_CURR')
606: ||'';

Line 604: ||''||FND_MESSAGE.Get_String('SQLGL',

600: ||''||FND_MESSAGE.Get_String('FND',
601: 'FND_MENU_DESC_LABEL')
602: ||''||FND_MESSAGE.Get_String('SQLGL',
603: 'GL_ASU_POST_SRC_LG')
604: ||''||FND_MESSAGE.Get_String('SQLGL',
605: 'GL_ASU_POST_SRC_CURR')
606: ||'';
607:
608: -- Print the info text and table column

Line 631: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
634: END IF;
635:

Line 644: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_GL_CRT')

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:
647: FOR v_crt_gl_rs IN c_crt_gl_rs
648: LOOP

Line 656: ''||FND_MESSAGE.Get_String('SQLGL',

652: v_status_code := 'PRINT_CRT_GL_RS_HDR';
653:
654: -- Build the column text
655: v_column_text :=
656: ''||FND_MESSAGE.Get_String('SQLGL',
657: 'GL_ASU_RCURR')
658: ||''||FND_MESSAGE.Get_String('SQLGL',
659: 'GL_ASU_POST_SRC_LG')
660: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 658: ||''||FND_MESSAGE.Get_String('SQLGL',

654: -- Build the column text
655: v_column_text :=
656: ''||FND_MESSAGE.Get_String('SQLGL',
657: 'GL_ASU_RCURR')
658: ||''||FND_MESSAGE.Get_String('SQLGL',
659: 'GL_ASU_POST_SRC_LG')
660: ||''||FND_MESSAGE.Get_String('SQLGL',
661: 'GL_ASU_POST_ENABLED')
662: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 660: ||''||FND_MESSAGE.Get_String('SQLGL',

656: ''||FND_MESSAGE.Get_String('SQLGL',
657: 'GL_ASU_RCURR')
658: ||''||FND_MESSAGE.Get_String('SQLGL',
659: 'GL_ASU_POST_SRC_LG')
660: ||''||FND_MESSAGE.Get_String('SQLGL',
661: 'GL_ASU_POST_ENABLED')
662: ||''||FND_MESSAGE.Get_String('SQLGL',
663: 'GL_ASU_POST_DEFAULT_RTYPE')
664: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 662: ||''||FND_MESSAGE.Get_String('SQLGL',

658: ||''||FND_MESSAGE.Get_String('SQLGL',
659: 'GL_ASU_POST_SRC_LG')
660: ||''||FND_MESSAGE.Get_String('SQLGL',
661: 'GL_ASU_POST_ENABLED')
662: ||''||FND_MESSAGE.Get_String('SQLGL',
663: 'GL_ASU_POST_DEFAULT_RTYPE')
664: ||''||FND_MESSAGE.Get_String('SQLGL',
665: 'GL_ASU_POST_MISSING_RATE')
666: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 664: ||''||FND_MESSAGE.Get_String('SQLGL',

660: ||''||FND_MESSAGE.Get_String('SQLGL',
661: 'GL_ASU_POST_ENABLED')
662: ||''||FND_MESSAGE.Get_String('SQLGL',
663: 'GL_ASU_POST_DEFAULT_RTYPE')
664: ||''||FND_MESSAGE.Get_String('SQLGL',
665: 'GL_ASU_POST_MISSING_RATE')
666: ||''||FND_MESSAGE.Get_String('SQLGL',
667: 'GL_ASU_POST_INHERIT_RTYPE')
668: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 666: ||''||FND_MESSAGE.Get_String('SQLGL',

662: ||''||FND_MESSAGE.Get_String('SQLGL',
663: 'GL_ASU_POST_DEFAULT_RTYPE')
664: ||''||FND_MESSAGE.Get_String('SQLGL',
665: 'GL_ASU_POST_MISSING_RATE')
666: ||''||FND_MESSAGE.Get_String('SQLGL',
667: 'GL_ASU_POST_INHERIT_RTYPE')
668: ||''||FND_MESSAGE.Get_String('SQLGL',
669: 'GL_ASU_POST_INIT_CONV_OPT')
670: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 668: ||''||FND_MESSAGE.Get_String('SQLGL',

664: ||''||FND_MESSAGE.Get_String('SQLGL',
665: 'GL_ASU_POST_MISSING_RATE')
666: ||''||FND_MESSAGE.Get_String('SQLGL',
667: 'GL_ASU_POST_INHERIT_RTYPE')
668: ||''||FND_MESSAGE.Get_String('SQLGL',
669: 'GL_ASU_POST_INIT_CONV_OPT')
670: ||''||FND_MESSAGE.Get_String('SQLGL',
671: 'GL_ASU_POST_INIT_PERIOD')
672: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 670: ||''||FND_MESSAGE.Get_String('SQLGL',

666: ||''||FND_MESSAGE.Get_String('SQLGL',
667: 'GL_ASU_POST_INHERIT_RTYPE')
668: ||''||FND_MESSAGE.Get_String('SQLGL',
669: 'GL_ASU_POST_INIT_CONV_OPT')
670: ||''||FND_MESSAGE.Get_String('SQLGL',
671: 'GL_ASU_POST_INIT_PERIOD')
672: ||''||FND_MESSAGE.Get_String('SQLGL',
673: 'GL_ASU_POST_INIT_RDATE')
674: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 672: ||''||FND_MESSAGE.Get_String('SQLGL',

668: ||''||FND_MESSAGE.Get_String('SQLGL',
669: 'GL_ASU_POST_INIT_CONV_OPT')
670: ||''||FND_MESSAGE.Get_String('SQLGL',
671: 'GL_ASU_POST_INIT_PERIOD')
672: ||''||FND_MESSAGE.Get_String('SQLGL',
673: 'GL_ASU_POST_INIT_RDATE')
674: ||''||FND_MESSAGE.Get_String('SQLGL',
675: 'GL_ASU_POST_INIT_RTYPE')
676: ||'';

Line 674: ||''||FND_MESSAGE.Get_String('SQLGL',

670: ||''||FND_MESSAGE.Get_String('SQLGL',
671: 'GL_ASU_POST_INIT_PERIOD')
672: ||''||FND_MESSAGE.Get_String('SQLGL',
673: 'GL_ASU_POST_INIT_RDATE')
674: ||''||FND_MESSAGE.Get_String('SQLGL',
675: 'GL_ASU_POST_INIT_RTYPE')
676: ||'';
677:
678: -- Print the info text and table column

Line 700: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
703: END IF;
704:

Line 712: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_JRULE')

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:
715: FOR v_invalid_jrule IN c_invalid_jrule
716: LOOP

Line 724: ''||FND_MESSAGE.Get_String('SQLGL',

720: v_status_code := 'PRINT_INVALID_JRULE_HDR';
721:
722: -- Build the column text
723: v_column_text :=
724: ''||FND_MESSAGE.Get_String('SQLGL',
725: 'GL_ASU_RCURR')
726: ||''||FND_MESSAGE.Get_String('SQLGL',
727: 'GL_ASU_POST_SRC_LG')
728: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 726: ||''||FND_MESSAGE.Get_String('SQLGL',

722: -- Build the column text
723: v_column_text :=
724: ''||FND_MESSAGE.Get_String('SQLGL',
725: 'GL_ASU_RCURR')
726: ||''||FND_MESSAGE.Get_String('SQLGL',
727: 'GL_ASU_POST_SRC_LG')
728: ||''||FND_MESSAGE.Get_String('SQLGL',
729: 'GL_ASU_PRODUCT')
730: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 728: ||''||FND_MESSAGE.Get_String('SQLGL',

724: ''||FND_MESSAGE.Get_String('SQLGL',
725: 'GL_ASU_RCURR')
726: ||''||FND_MESSAGE.Get_String('SQLGL',
727: 'GL_ASU_POST_SRC_LG')
728: ||''||FND_MESSAGE.Get_String('SQLGL',
729: 'GL_ASU_PRODUCT')
730: ||''||FND_MESSAGE.Get_String('SQLGL',
731: 'GL_ASU_JE_SOURCE')
732: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 730: ||''||FND_MESSAGE.Get_String('SQLGL',

726: ||''||FND_MESSAGE.Get_String('SQLGL',
727: 'GL_ASU_POST_SRC_LG')
728: ||''||FND_MESSAGE.Get_String('SQLGL',
729: 'GL_ASU_PRODUCT')
730: ||''||FND_MESSAGE.Get_String('SQLGL',
731: 'GL_ASU_JE_SOURCE')
732: ||''||FND_MESSAGE.Get_String('SQLGL',
733: 'GL_ASU_JE_CATEGORY')
734: ||'';

Line 732: ||''||FND_MESSAGE.Get_String('SQLGL',

728: ||''||FND_MESSAGE.Get_String('SQLGL',
729: 'GL_ASU_PRODUCT')
730: ||''||FND_MESSAGE.Get_String('SQLGL',
731: 'GL_ASU_JE_SOURCE')
732: ||''||FND_MESSAGE.Get_String('SQLGL',
733: 'GL_ASU_JE_CATEGORY')
734: ||'';
735:
736: -- Print the info text and table column

Line 759: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
762: END IF;
763:

Line 771: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_DIFF')

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:
774: FOR v_diff_setup_alc IN c_diff_setup_alc
775: LOOP

Line 783: ''||FND_MESSAGE.Get_String('SQLGL',

779: v_status_code := 'PRINT_DIFF_SETUP_ALC_HDR';
780:
781: -- Build the column text
782: v_column_text :=
783: ''||FND_MESSAGE.Get_String('SQLGL',
784: 'GL_ASU_RCURR')
785: ||''||FND_MESSAGE.Get_String('SQLGL',
786: 'GL_ASU_POST_SRC_LG')
787: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 785: ||''||FND_MESSAGE.Get_String('SQLGL',

781: -- Build the column text
782: v_column_text :=
783: ''||FND_MESSAGE.Get_String('SQLGL',
784: 'GL_ASU_RCURR')
785: ||''||FND_MESSAGE.Get_String('SQLGL',
786: 'GL_ASU_POST_SRC_LG')
787: ||''||FND_MESSAGE.Get_String('SQLGL',
788: 'GL_ASU_PRODUCT')
789: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 787: ||''||FND_MESSAGE.Get_String('SQLGL',

783: ''||FND_MESSAGE.Get_String('SQLGL',
784: 'GL_ASU_RCURR')
785: ||''||FND_MESSAGE.Get_String('SQLGL',
786: 'GL_ASU_POST_SRC_LG')
787: ||''||FND_MESSAGE.Get_String('SQLGL',
788: 'GL_ASU_PRODUCT')
789: ||''||FND_MESSAGE.Get_String('SQLGL',
790: 'GL_ASU_OU')
791: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 789: ||''||FND_MESSAGE.Get_String('SQLGL',

785: ||''||FND_MESSAGE.Get_String('SQLGL',
786: 'GL_ASU_POST_SRC_LG')
787: ||''||FND_MESSAGE.Get_String('SQLGL',
788: 'GL_ASU_PRODUCT')
789: ||''||FND_MESSAGE.Get_String('SQLGL',
790: 'GL_ASU_OU')
791: ||''||FND_MESSAGE.Get_String('SQLGL',
792: 'GL_ASU_POST_DEFAULT_RTYPE')
793: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 791: ||''||FND_MESSAGE.Get_String('SQLGL',

787: ||''||FND_MESSAGE.Get_String('SQLGL',
788: 'GL_ASU_PRODUCT')
789: ||''||FND_MESSAGE.Get_String('SQLGL',
790: 'GL_ASU_OU')
791: ||''||FND_MESSAGE.Get_String('SQLGL',
792: 'GL_ASU_POST_DEFAULT_RTYPE')
793: ||''||FND_MESSAGE.Get_String('SQLGL',
794: 'GL_ASU_POST_MISSING_RATE')
795: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 793: ||''||FND_MESSAGE.Get_String('SQLGL',

789: ||''||FND_MESSAGE.Get_String('SQLGL',
790: 'GL_ASU_OU')
791: ||''||FND_MESSAGE.Get_String('SQLGL',
792: 'GL_ASU_POST_DEFAULT_RTYPE')
793: ||''||FND_MESSAGE.Get_String('SQLGL',
794: 'GL_ASU_POST_MISSING_RATE')
795: ||''||FND_MESSAGE.Get_String('SQLGL',
796: 'GL_ASU_POST_INHERIT_RTYPE')
797: ||'';

Line 795: ||''||FND_MESSAGE.Get_String('SQLGL',

791: ||''||FND_MESSAGE.Get_String('SQLGL',
792: 'GL_ASU_POST_DEFAULT_RTYPE')
793: ||''||FND_MESSAGE.Get_String('SQLGL',
794: 'GL_ASU_POST_MISSING_RATE')
795: ||''||FND_MESSAGE.Get_String('SQLGL',
796: 'GL_ASU_POST_INHERIT_RTYPE')
797: ||'';
798:
799: -- Print the info text and table column

Line 822: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
825: END IF;
826:

Line 834: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_POST_SLRC_PARTIAL')

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:
837: FOR v_partial_setup_alc IN c_partial_setup_alc
838: LOOP

Line 846: ''||FND_MESSAGE.Get_String('SQLGL',

842: v_status_code := 'PRINT_PARTIAL_SETUP_ALC_HDR';
843:
844: -- Build the column text
845: v_column_text :=
846: ''||FND_MESSAGE.Get_String('SQLGL',
847: 'GL_ASU_RCURR')
848: ||''||FND_MESSAGE.Get_String('SQLGL',
849: 'GL_ASU_POST_SRC_LG')
850: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 848: ||''||FND_MESSAGE.Get_String('SQLGL',

844: -- Build the column text
845: v_column_text :=
846: ''||FND_MESSAGE.Get_String('SQLGL',
847: 'GL_ASU_RCURR')
848: ||''||FND_MESSAGE.Get_String('SQLGL',
849: 'GL_ASU_POST_SRC_LG')
850: ||''||FND_MESSAGE.Get_String('SQLGL',
851: 'GL_ASU_PRODUCT')
852: ||''||FND_MESSAGE.Get_String('SQLGL',

Line 850: ||''||FND_MESSAGE.Get_String('SQLGL',

846: ''||FND_MESSAGE.Get_String('SQLGL',
847: 'GL_ASU_RCURR')
848: ||''||FND_MESSAGE.Get_String('SQLGL',
849: 'GL_ASU_POST_SRC_LG')
850: ||''||FND_MESSAGE.Get_String('SQLGL',
851: 'GL_ASU_PRODUCT')
852: ||''||FND_MESSAGE.Get_String('SQLGL',
853: 'GL_ASU_OU')
854: ||'';

Line 852: ||''||FND_MESSAGE.Get_String('SQLGL',

848: ||''||FND_MESSAGE.Get_String('SQLGL',
849: 'GL_ASU_POST_SRC_LG')
850: ||''||FND_MESSAGE.Get_String('SQLGL',
851: 'GL_ASU_PRODUCT')
852: ||''||FND_MESSAGE.Get_String('SQLGL',
853: 'GL_ASU_OU')
854: ||'';
855:
856: -- Print the info text and table column

Line 879: ||FND_MESSAGE.Get_String('SQLGL',

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: ||'

');
882: END IF;
883:

Line 911: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')

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
914: FND_FILE.put_line(FND_FILE.output, pv_nl||'');
915:

Line 944: ||FND_MESSAGE.Get_String('SQLGL', 'GL_ASU_FATAL_ERROR')

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
947: FND_FILE.put_line(FND_FILE.output, pv_nl||'');
948:

Line 985: ||FND_MESSAGE.Get_String('SQLGL', p_info_msg_name)

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;
988:
989: IF (p_column_text IS NOT NULL)