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.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on FND_MESSAGE

Line 551: fnd_message.set_name ('JTF', 'JTY_TTY_EMPTY_TERR_NAME');

547:
548:
549: IF p_geo_terr_name IS NULL THEN
550: /*trim(p_postal_code) is null means the pc is to be removed */
551: fnd_message.set_name ('JTF', 'JTY_TTY_EMPTY_TERR_NAME');
552: x_msg_data := fnd_message.get();
553: fnd_message.set_name ('JTF', x_msg_data);
554: RETURN;
555: END IF;

Line 552: x_msg_data := fnd_message.get();

548:
549: IF p_geo_terr_name IS NULL THEN
550: /*trim(p_postal_code) is null means the pc is to be removed */
551: fnd_message.set_name ('JTF', 'JTY_TTY_EMPTY_TERR_NAME');
552: x_msg_data := fnd_message.get();
553: fnd_message.set_name ('JTF', x_msg_data);
554: RETURN;
555: END IF;
556:

Line 553: fnd_message.set_name ('JTF', x_msg_data);

549: IF p_geo_terr_name IS NULL THEN
550: /*trim(p_postal_code) is null means the pc is to be removed */
551: fnd_message.set_name ('JTF', 'JTY_TTY_EMPTY_TERR_NAME');
552: x_msg_data := fnd_message.get();
553: fnd_message.set_name ('JTF', x_msg_data);
554: RETURN;
555: END IF;
556:
557: --insert into tmp values('glb userid',l_user_id); commit;

Line 601: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');

597:
598: end if;
599: if in_reg_terr=0 and in_def_terr =0 and trim(p_postal_code) is not null then
600: /*trim(p_postal_code) is null means the pc is to be removed */
601: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');
602: x_msg_data := fnd_message.get();
603: fnd_message.set_name ('JTF', x_msg_data);
604: return;
605: end if;

Line 602: x_msg_data := fnd_message.get();

598: end if;
599: if in_reg_terr=0 and in_def_terr =0 and trim(p_postal_code) is not null then
600: /*trim(p_postal_code) is null means the pc is to be removed */
601: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');
602: x_msg_data := fnd_message.get();
603: fnd_message.set_name ('JTF', x_msg_data);
604: return;
605: end if;
606: /* Does the Geography territory attached to the postal codes is created by the current user?

Line 603: fnd_message.set_name ('JTF', x_msg_data);

599: if in_reg_terr=0 and in_def_terr =0 and trim(p_postal_code) is not null then
600: /*trim(p_postal_code) is null means the pc is to be removed */
601: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');
602: x_msg_data := fnd_message.get();
603: fnd_message.set_name ('JTF', x_msg_data);
604: return;
605: end if;
606: /* Does the Geography territory attached to the postal codes is created by the current user?
607: check the ownership */

Line 616: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');

612: and upper(terr.geo_terr_name) = upper(p_geo_terr_name);
613: -- and terr.parent_geo_terr_id = terr_id; removed (sgkumar) parent terr can be default terr
614:
615:
616: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
617: x_msg_data := fnd_message.get();
618: fnd_message.set_name ('JTF', x_msg_data);
619: return;
620: end if;

Line 617: x_msg_data := fnd_message.get();

613: -- and terr.parent_geo_terr_id = terr_id; removed (sgkumar) parent terr can be default terr
614:
615:
616: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
617: x_msg_data := fnd_message.get();
618: fnd_message.set_name ('JTF', x_msg_data);
619: return;
620: end if;
621: end if;

Line 618: fnd_message.set_name ('JTF', x_msg_data);

614:
615:
616: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
617: x_msg_data := fnd_message.get();
618: fnd_message.set_name ('JTF', x_msg_data);
619: return;
620: end if;
621: end if;
622:

Line 635: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');

631: and upper(terr1.geo_terr_name) = upper(p_manager_terr_name)
632: and terr2.geo_terr_name = p_geo_terr_name;
633: -- and terr.parent_geo_terr_id = terr_id;
634:
635: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
636: x_msg_data := fnd_message.get();
637: fnd_message.set_name ('JTF', x_msg_data);
638: return;
639: end if;

Line 636: x_msg_data := fnd_message.get();

632: and terr2.geo_terr_name = p_geo_terr_name;
633: -- and terr.parent_geo_terr_id = terr_id;
634:
635: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
636: x_msg_data := fnd_message.get();
637: fnd_message.set_name ('JTF', x_msg_data);
638: return;
639: end if;
640: end if;

Line 637: fnd_message.set_name ('JTF', x_msg_data);

633: -- and terr.parent_geo_terr_id = terr_id;
634:
635: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
636: x_msg_data := fnd_message.get();
637: fnd_message.set_name ('JTF', x_msg_data);
638: return;
639: end if;
640: end if;
641:

Line 718: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');

714: --and owner_resource_id = rsc_id; --10121
715: exception
716: when no_data_found then
717:
718: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
719: x_msg_data := fnd_message.get();
720: fnd_message.set_name ('JTF', x_msg_data);
721: return;
722:

Line 719: x_msg_data := fnd_message.get();

715: exception
716: when no_data_found then
717:
718: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
719: x_msg_data := fnd_message.get();
720: fnd_message.set_name ('JTF', x_msg_data);
721: return;
722:
723: when others then

Line 720: fnd_message.set_name ('JTF', x_msg_data);

716: when no_data_found then
717:
718: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
719: x_msg_data := fnd_message.get();
720: fnd_message.set_name ('JTF', x_msg_data);
721: return;
722:
723: when others then
724: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');

Line 724: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');

720: fnd_message.set_name ('JTF', x_msg_data);
721: return;
722:
723: when others then
724: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');
725: x_msg_data := fnd_message.get();
726: fnd_message.set_name ('JTF', x_msg_data);
727: return;
728: end;

Line 725: x_msg_data := fnd_message.get();

721: return;
722:
723: when others then
724: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');
725: x_msg_data := fnd_message.get();
726: fnd_message.set_name ('JTF', x_msg_data);
727: return;
728: end;
729:

Line 726: fnd_message.set_name ('JTF', x_msg_data);

722:
723: when others then
724: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');
725: x_msg_data := fnd_message.get();
726: fnd_message.set_name ('JTF', x_msg_data);
727: return;
728: end;
729:
730:

Line 980: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

976: commit;
977:
978: exception
979: when others then
980: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
981: x_msg_data := fnd_message.get();
982: fnd_message.set_name ('JTF', x_msg_data);
983: end UPDATE_GEO_TERR;
984:

Line 981: x_msg_data := fnd_message.get();

977:
978: exception
979: when others then
980: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
981: x_msg_data := fnd_message.get();
982: fnd_message.set_name ('JTF', x_msg_data);
983: end UPDATE_GEO_TERR;
984:
985:

Line 982: fnd_message.set_name ('JTF', x_msg_data);

978: exception
979: when others then
980: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
981: x_msg_data := fnd_message.get();
982: fnd_message.set_name ('JTF', x_msg_data);
983: end UPDATE_GEO_TERR;
984:
985:
986: END JTF_TTY_GEO_WEBADI_INT_PKG;