DBA Data[Home] [Help]

APPS.BIS_RL_PKG dependencies on HTP

Line 399: htp.p(SQLERRM);

395: end if;
396:
397: exception
398: when others then
399: htp.p(SQLERRM);
400:
401: end;
402:
403:

Line 461: htp.p(SQLERRM);

457: p_entries => p_entries);
458:
459: exception
460: when others then
461: htp.p(SQLERRM);
462:
463: end;
464:
465:

Line 529: htp.p(SQLERRM);

525: end if;
526:
527: exception
528: when others then
529: htp.p(SQLERRM);
530:
531: end;
532:
533: procedure FavoriteCreate is

Line 544: htp.p('');

540: if(icx_sec.validateSession)
541: then
542: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_CREATE', l_title, l_prompts);
543: --l_title := FND_MESSAGE.get_string('BIS', 'BIS_ADD_URL');
544: htp.p('');
545: htp.p('');
546: htp.p(''||l_title||'');
547: htp.p('

Web Analytics Made Easy -StatCounter
');
548:

Line 545: htp.p('');

541: then
542: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_CREATE', l_title, l_prompts);
543: --l_title := FND_MESSAGE.get_string('BIS', 'BIS_ADD_URL');
544: htp.p('');
545: htp.p('');
546: htp.p(''||l_title||'');
547: htp.p('

Web Analytics Made Easy -StatCounter
');
548:
549: --- This standardizes the fonts and colors

Line 546: htp.p(''||l_title||'');

542: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_CREATE', l_title, l_prompts);
543: --l_title := FND_MESSAGE.get_string('BIS', 'BIS_ADD_URL');
544: htp.p('');
545: htp.p('');
546: htp.p(''||l_title||'');
547: htp.p('

Web Analytics Made Easy -StatCounter
');
548:
549: --- This standardizes the fonts and colors
550: --- correct spelling of Javascript (1307419)

Line 547: htp.p('');

543: --l_title := FND_MESSAGE.get_string('BIS', 'BIS_ADD_URL');
544: htp.p('');
545: htp.p('');
546: htp.p(''||l_title||'');
547: htp.p('

Web Analytics Made Easy -StatCounter
');
548:
549: --- This standardizes the fonts and colors
550: --- correct spelling of Javascript (1307419)
551: htp.p('');

Line 551: htp.p('');

547: htp.p('

Web Analytics Made Easy -StatCounter
');
548:
549: --- This standardizes the fonts and colors
550: --- correct spelling of Javascript (1307419)
551: htp.p('');
552: BIS_UTILITIES_PVT.putStyle;
553:
554: htp.p('');

Line 588: htp.p('');

584: htp.p('window.close();
585: };
586: }');
587:
588: htp.p('');
589:
590: htp.formOpen('javascript:saveCreate()','POST','','','NAME="createFavorite"');
591: htp.tableOpen;
592: htp.tableRowOpen;

Line 590: htp.formOpen('javascript:saveCreate()','POST','','','NAME="createFavorite"');

586: }');
587:
588: htp.p('');
589:
590: htp.formOpen('javascript:saveCreate()','POST','','','NAME="createFavorite"');
591: htp.tableOpen;
592: htp.tableRowOpen;
593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
594: htp.tableData(htf.formText(cname => 'LOCATION',

Line 591: htp.tableOpen;

587:
588: htp.p('');
589:
590: htp.formOpen('javascript:saveCreate()','POST','','','NAME="createFavorite"');
591: htp.tableOpen;
592: htp.tableRowOpen;
593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
594: htp.tableData(htf.formText(cname => 'LOCATION',
595: csize => '50'), 'LEFT');

Line 592: htp.tableRowOpen;

588: htp.p('');
589:
590: htp.formOpen('javascript:saveCreate()','POST','','','NAME="createFavorite"');
591: htp.tableOpen;
592: htp.tableRowOpen;
593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
594: htp.tableData(htf.formText(cname => 'LOCATION',
595: csize => '50'), 'LEFT');
596: htp.tableRowClose;

Line 593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');

589:
590: htp.formOpen('javascript:saveCreate()','POST','','','NAME="createFavorite"');
591: htp.tableOpen;
592: htp.tableRowOpen;
593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
594: htp.tableData(htf.formText(cname => 'LOCATION',
595: csize => '50'), 'LEFT');
596: htp.tableRowClose;
597: htp.tableRowOpen;

Line 594: htp.tableData(htf.formText(cname => 'LOCATION',

590: htp.formOpen('javascript:saveCreate()','POST','','','NAME="createFavorite"');
591: htp.tableOpen;
592: htp.tableRowOpen;
593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
594: htp.tableData(htf.formText(cname => 'LOCATION',
595: csize => '50'), 'LEFT');
596: htp.tableRowClose;
597: htp.tableRowOpen;
598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');

Line 596: htp.tableRowClose;

592: htp.tableRowOpen;
593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
594: htp.tableData(htf.formText(cname => 'LOCATION',
595: csize => '50'), 'LEFT');
596: htp.tableRowClose;
597: htp.tableRowOpen;
598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');
599: htp.tableData(htf.formText(cname => 'NAME',
600: csize => '50'), 'LEFT');

Line 597: htp.tableRowOpen;

593: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
594: htp.tableData(htf.formText(cname => 'LOCATION',
595: csize => '50'), 'LEFT');
596: htp.tableRowClose;
597: htp.tableRowOpen;
598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');
599: htp.tableData(htf.formText(cname => 'NAME',
600: csize => '50'), 'LEFT');
601: htp.tableRowClose;

Line 598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');

594: htp.tableData(htf.formText(cname => 'LOCATION',
595: csize => '50'), 'LEFT');
596: htp.tableRowClose;
597: htp.tableRowOpen;
598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');
599: htp.tableData(htf.formText(cname => 'NAME',
600: csize => '50'), 'LEFT');
601: htp.tableRowClose;
602: htp.tableRowOpen;

Line 599: htp.tableData(htf.formText(cname => 'NAME',

595: csize => '50'), 'LEFT');
596: htp.tableRowClose;
597: htp.tableRowOpen;
598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');
599: htp.tableData(htf.formText(cname => 'NAME',
600: csize => '50'), 'LEFT');
601: htp.tableRowClose;
602: htp.tableRowOpen;
603: htp.p('');

Line 601: htp.tableRowClose;

597: htp.tableRowOpen;
598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');
599: htp.tableData(htf.formText(cname => 'NAME',
600: csize => '50'), 'LEFT');
601: htp.tableRowClose;
602: htp.tableRowOpen;
603: htp.p('');
604: htp.p('');
605: htp.p('');
613: htp.tableRowClose;
614: htp.tableClose;
615: htp.formClose;
616:
617: htp.bodyClose;
618: htp.htmlClose;

Line 615: htp.formClose;

611: htp.p('

');

Line 602: htp.tableRowOpen;

598: htp.tableData(htf.bold(l_prompts(2)), 'RIGHT');
599: htp.tableData(htf.formText(cname => 'NAME',
600: csize => '50'), 'LEFT');
601: htp.tableRowClose;
602: htp.tableRowOpen;
603: htp.p('

');
604: htp.p('');
605: htp.p('');
613: htp.tableRowClose;
614: htp.tableClose;
615: htp.formClose;
616:
617: htp.bodyClose;

Line 614: htp.tableClose;

610: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
611: htp.p('

');
606: --icx_plug_utilities.buttonLeft(l_prompts(3),'javascript:saveCreate()','FNDJLFOK.gif');

Line 603: htp.p('
');

599: htp.tableData(htf.formText(cname => 'NAME',
600: csize => '50'), 'LEFT');
601: htp.tableRowClose;
602: htp.tableRowOpen;
603: htp.p('

');
604: htp.p('');
605: htp.p('');
613: htp.tableRowClose;
614: htp.tableClose;
615: htp.formClose;
616:

Line 613: htp.tableRowClose;

609: --icx_plug_utilities.buttonRight(l_prompts(4),'javascript:window.close()','FNDJLFCN.gif');
610: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
611: htp.p('

');
606: --icx_plug_utilities.buttonLeft(l_prompts(3),'javascript:saveCreate()','FNDJLFOK.gif');
607: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveCreate()');

Line 604: htp.p('');

600: csize => '50'), 'LEFT');
601: htp.tableRowClose;
602: htp.tableRowOpen;
603: htp.p('

');
613: htp.tableRowClose;
614: htp.tableClose;
615: htp.formClose;

Line 612: htp.p('');

608: htp.p('

');
604: htp.p('');
605: htp.p('
');
606: --icx_plug_utilities.buttonLeft(l_prompts(3),'javascript:saveCreate()','FNDJLFOK.gif');
607: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveCreate()');
608: htp.p('
');

Line 605: htp.p('
');

601: htp.tableRowClose;
602: htp.tableRowOpen;
603: htp.p('

');
604: htp.p('');
605: htp.p('');

Line 611: htp.p('
');
606: --icx_plug_utilities.buttonLeft(l_prompts(3),'javascript:saveCreate()','FNDJLFOK.gif');
607: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveCreate()');
608: htp.p('
');
609: --icx_plug_utilities.buttonRight(l_prompts(4),'javascript:window.close()','FNDJLFCN.gif');

Line 608: htp.p('
');

604: htp.p('');
605: htp.p('
');
606: --icx_plug_utilities.buttonLeft(l_prompts(3),'javascript:saveCreate()','FNDJLFOK.gif');
607: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveCreate()');
608: htp.p('
');
609: --icx_plug_utilities.buttonRight(l_prompts(4),'javascript:window.close()','FNDJLFCN.gif');
610: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
611: htp.p('
');
612: htp.p('

');

607: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveCreate()');
608: htp.p('

');
609: --icx_plug_utilities.buttonRight(l_prompts(4),'javascript:window.close()','FNDJLFCN.gif');
610: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
611: htp.p('
');
612: htp.p('
');
609: --icx_plug_utilities.buttonRight(l_prompts(4),'javascript:window.close()','FNDJLFCN.gif');
610: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
611: htp.p('
');
612: htp.p('
');
612: htp.p('
');
612: htp.p('
');
612: htp.p('');
613: htp.tableRowClose;
614: htp.tableClose;
615: htp.formClose;
616:
617: htp.bodyClose;
618: htp.htmlClose;
619:

Line 617: htp.bodyClose;

613: htp.tableRowClose;
614: htp.tableClose;
615: htp.formClose;
616:
617: htp.bodyClose;
618: htp.htmlClose;
619:
620: end if;
621:

Line 618: htp.htmlClose;

614: htp.tableClose;
615: htp.formClose;
616:
617: htp.bodyClose;
618: htp.htmlClose;
619:
620: end if;
621:
622: exception

Line 624: htp.p(SQLERRM);

620: end if;
621:
622: exception
623: when others then
624: htp.p(SQLERRM);
625: end;
626:
627: procedure FavoriteRename is
628:

Line 638: htp.p('');

634: if(icx_sec.validateSession)
635: then
636: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_RENAME', l_title, l_prompts);
637: --l_title := FND_MESSAGE.get_string('BIS','BIS_RENAME_LINK');
638: htp.p('');
639: htp.p('');
640: htp.p(''||l_title||'');
641: htp.p('

Web Analytics Made Easy -StatCounter
');
642:

Line 639: htp.p('');

635: then
636: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_RENAME', l_title, l_prompts);
637: --l_title := FND_MESSAGE.get_string('BIS','BIS_RENAME_LINK');
638: htp.p('');
639: htp.p('');
640: htp.p(''||l_title||'');
641: htp.p('

Web Analytics Made Easy -StatCounter
');
642:
643: --- This standardizes the fonts and colors

Line 640: htp.p(''||l_title||'');

636: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_RENAME', l_title, l_prompts);
637: --l_title := FND_MESSAGE.get_string('BIS','BIS_RENAME_LINK');
638: htp.p('');
639: htp.p('');
640: htp.p(''||l_title||'');
641: htp.p('

Web Analytics Made Easy -StatCounter
');
642:
643: --- This standardizes the fonts and colors
644: --- correct spelling of Javascript (1307419)

Line 641: htp.p('');

637: --l_title := FND_MESSAGE.get_string('BIS','BIS_RENAME_LINK');
638: htp.p('');
639: htp.p('');
640: htp.p(''||l_title||'');
641: htp.p('

Web Analytics Made Easy -StatCounter
');
642:
643: --- This standardizes the fonts and colors
644: --- correct spelling of Javascript (1307419)
645: htp.p('');

Line 645: htp.p('');

641: htp.p('

Web Analytics Made Easy -StatCounter
');
642:
643: --- This standardizes the fonts and colors
644: --- correct spelling of Javascript (1307419)
645: htp.p('');
646: BIS_UTILITIES_PVT.putStyle;
647:
648: htp.p('');

Line 669: htp.p('');

665: htp.p('window.close();
666: };
667: }');
668:
669: htp.p('');
670:
671: htp.formOpen('javascript:saveRename()','POST','','','NAME="renameFavorite"');
672: htp.tableOpen;
673: htp.tableRowOpen;

Line 671: htp.formOpen('javascript:saveRename()','POST','','','NAME="renameFavorite"');

667: }');
668:
669: htp.p('');
670:
671: htp.formOpen('javascript:saveRename()','POST','','','NAME="renameFavorite"');
672: htp.tableOpen;
673: htp.tableRowOpen;
674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
675: htp.tableData(htf.formText(cname => 'NAME',

Line 672: htp.tableOpen;

668:
669: htp.p('');
670:
671: htp.formOpen('javascript:saveRename()','POST','','','NAME="renameFavorite"');
672: htp.tableOpen;
673: htp.tableRowOpen;
674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
675: htp.tableData(htf.formText(cname => 'NAME',
676: csize => '35'), 'LEFT');

Line 673: htp.tableRowOpen;

669: htp.p('');
670:
671: htp.formOpen('javascript:saveRename()','POST','','','NAME="renameFavorite"');
672: htp.tableOpen;
673: htp.tableRowOpen;
674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
675: htp.tableData(htf.formText(cname => 'NAME',
676: csize => '35'), 'LEFT');
677: htp.tableRowClose;

Line 674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');

670:
671: htp.formOpen('javascript:saveRename()','POST','','','NAME="renameFavorite"');
672: htp.tableOpen;
673: htp.tableRowOpen;
674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
675: htp.tableData(htf.formText(cname => 'NAME',
676: csize => '35'), 'LEFT');
677: htp.tableRowClose;
678: htp.tableRowOpen;

Line 675: htp.tableData(htf.formText(cname => 'NAME',

671: htp.formOpen('javascript:saveRename()','POST','','','NAME="renameFavorite"');
672: htp.tableOpen;
673: htp.tableRowOpen;
674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
675: htp.tableData(htf.formText(cname => 'NAME',
676: csize => '35'), 'LEFT');
677: htp.tableRowClose;
678: htp.tableRowOpen;
679: htp.p('');

Line 677: htp.tableRowClose;

673: htp.tableRowOpen;
674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
675: htp.tableData(htf.formText(cname => 'NAME',
676: csize => '35'), 'LEFT');
677: htp.tableRowClose;
678: htp.tableRowOpen;
679: htp.p('');
680: htp.p('');
681: htp.p('');
689: htp.tableRowClose;
690: htp.tableClose;
691: htp.formClose;
692:
693: htp.p('');
694:

Line 691: htp.formClose;

687: htp.p('

');

Line 678: htp.tableRowOpen;

674: htp.tableData(htf.bold(l_prompts(1)), 'RIGHT');
675: htp.tableData(htf.formText(cname => 'NAME',
676: csize => '35'), 'LEFT');
677: htp.tableRowClose;
678: htp.tableRowOpen;
679: htp.p('

');
680: htp.p('');
681: htp.p('');
689: htp.tableRowClose;
690: htp.tableClose;
691: htp.formClose;
692:
693: htp.p('');

Line 690: htp.tableClose;

686: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
687: htp.p('

');
682: --icx_plug_utilities.buttonLeft(l_prompts(2),'javascript:saveRename()','FNDJLFOK.gif');

Line 679: htp.p('
');

675: htp.tableData(htf.formText(cname => 'NAME',
676: csize => '35'), 'LEFT');
677: htp.tableRowClose;
678: htp.tableRowOpen;
679: htp.p('

');
680: htp.p('');
681: htp.p('');
689: htp.tableRowClose;
690: htp.tableClose;
691: htp.formClose;
692:

Line 689: htp.tableRowClose;

685: --icx_plug_utilities.buttonRight(l_prompts(3),'javascript:window.close()','FNDJLFCN.gif');
686: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
687: htp.p('

');
682: --icx_plug_utilities.buttonLeft(l_prompts(2),'javascript:saveRename()','FNDJLFOK.gif');
683: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');

Line 680: htp.p('');

676: csize => '35'), 'LEFT');
677: htp.tableRowClose;
678: htp.tableRowOpen;
679: htp.p('

');
689: htp.tableRowClose;
690: htp.tableClose;
691: htp.formClose;

Line 688: htp.p('');

684: htp.p('

');
680: htp.p('');
681: htp.p('
');
682: --icx_plug_utilities.buttonLeft(l_prompts(2),'javascript:saveRename()','FNDJLFOK.gif');
683: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
684: htp.p('
');

Line 681: htp.p('
');

677: htp.tableRowClose;
678: htp.tableRowOpen;
679: htp.p('

');
680: htp.p('');
681: htp.p('');

Line 687: htp.p('
');
682: --icx_plug_utilities.buttonLeft(l_prompts(2),'javascript:saveRename()','FNDJLFOK.gif');
683: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
684: htp.p('
');
685: --icx_plug_utilities.buttonRight(l_prompts(3),'javascript:window.close()','FNDJLFCN.gif');

Line 684: htp.p('
');

680: htp.p('');
681: htp.p('
');
682: --icx_plug_utilities.buttonLeft(l_prompts(2),'javascript:saveRename()','FNDJLFOK.gif');
683: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
684: htp.p('
');
685: --icx_plug_utilities.buttonRight(l_prompts(3),'javascript:window.close()','FNDJLFCN.gif');
686: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
687: htp.p('
');
688: htp.p('

');

683: icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
684: htp.p('

');
685: --icx_plug_utilities.buttonRight(l_prompts(3),'javascript:window.close()','FNDJLFCN.gif');
686: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
687: htp.p('
');
688: htp.p('
');
685: --icx_plug_utilities.buttonRight(l_prompts(3),'javascript:window.close()','FNDJLFCN.gif');
686: icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
687: htp.p('
');
688: htp.p('
');
688: htp.p('
');
688: htp.p('
');
688: htp.p('');
689: htp.tableRowClose;
690: htp.tableClose;
691: htp.formClose;
692:
693: htp.p('');
694:
695: htp.bodyClose;

Line 693: htp.p('');

689: htp.tableRowClose;
690: htp.tableClose;
691: htp.formClose;
692:
693: htp.p('');
694:
695: htp.bodyClose;
696: htp.htmlClose;
697:

Line 695: htp.bodyClose;

691: htp.formClose;
692:
693: htp.p('');
694:
695: htp.bodyClose;
696: htp.htmlClose;
697:
698: end if;
699:

Line 696: htp.htmlClose;

692:
693: htp.p('');
694:
695: htp.bodyClose;
696: htp.htmlClose;
697:
698: end if;
699:
700: exception

Line 702: htp.p(SQLERRM);

698: end if;
699:
700: exception
701: when others then
702: htp.p(SQLERRM);
703:
704: end;
705:
706: --serao - 02/25/02 - pvt function to do the actual insert into the table

Line 2629: htp.p(SQLERRM);

2625: p_bind_count := l_bind_count;
2626:
2627: exception
2628: when others then
2629: htp.p(SQLERRM);
2630:
2631: end getAllRespFuncnSQLWrap;
2632:
2633: --msaran: SQL Literals projects