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 581: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');

577:
578: end if;
579: if in_reg_terr=0 and in_def_terr =0 and trim(p_postal_code) is not null then
580: /*trim(p_postal_code) is null means the pc is to be removed */
581: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');
582: x_msg_data := fnd_message.get();
583: fnd_message.set_name ('JTF', x_msg_data);
584: return;
585: end if;

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

578: end if;
579: if in_reg_terr=0 and in_def_terr =0 and trim(p_postal_code) is not null then
580: /*trim(p_postal_code) is null means the pc is to be removed */
581: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');
582: x_msg_data := fnd_message.get();
583: fnd_message.set_name ('JTF', x_msg_data);
584: return;
585: end if;
586: /* Does the Geography territory attached to the postal codes is created by the current user?

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

579: if in_reg_terr=0 and in_def_terr =0 and trim(p_postal_code) is not null then
580: /*trim(p_postal_code) is null means the pc is to be removed */
581: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_POSTAL_CODE');
582: x_msg_data := fnd_message.get();
583: fnd_message.set_name ('JTF', x_msg_data);
584: return;
585: end if;
586: /* Does the Geography territory attached to the postal codes is created by the current user?
587: check the ownership */

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

592: and upper(terr.geo_terr_name) = upper(p_geo_terr_name);
593: -- and terr.parent_geo_terr_id = terr_id; removed (sgkumar) parent terr can be default terr
594:
595:
596: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
597: x_msg_data := fnd_message.get();
598: fnd_message.set_name ('JTF', x_msg_data);
599: return;
600: end if;

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

593: -- and terr.parent_geo_terr_id = terr_id; removed (sgkumar) parent terr can be default terr
594:
595:
596: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
597: x_msg_data := fnd_message.get();
598: fnd_message.set_name ('JTF', x_msg_data);
599: return;
600: end if;
601: end if;

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

594:
595:
596: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
597: x_msg_data := fnd_message.get();
598: fnd_message.set_name ('JTF', x_msg_data);
599: return;
600: end if;
601: end if;
602:

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

611: and upper(terr1.geo_terr_name) = upper(p_manager_terr_name)
612: and terr2.geo_terr_name = p_geo_terr_name;
613: -- and terr.parent_geo_terr_id = terr_id;
614:
615: if i=0 then fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
616: x_msg_data := fnd_message.get();
617: fnd_message.set_name ('JTF', x_msg_data);
618: return;
619: end if;

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

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

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

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

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

694: --and owner_resource_id = rsc_id; --10121
695: exception
696: when no_data_found then
697:
698: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
699: x_msg_data := fnd_message.get();
700: fnd_message.set_name ('JTF', x_msg_data);
701: return;
702:

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

695: exception
696: when no_data_found then
697:
698: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
699: x_msg_data := fnd_message.get();
700: fnd_message.set_name ('JTF', x_msg_data);
701: return;
702:
703: when others then

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

696: when no_data_found then
697:
698: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TERR_NAME');
699: x_msg_data := fnd_message.get();
700: fnd_message.set_name ('JTF', x_msg_data);
701: return;
702:
703: when others then
704: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');

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

700: fnd_message.set_name ('JTF', x_msg_data);
701: return;
702:
703: when others then
704: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');
705: x_msg_data := fnd_message.get();
706: fnd_message.set_name ('JTF', x_msg_data);
707: return;
708: end;

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

701: return;
702:
703: when others then
704: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');
705: x_msg_data := fnd_message.get();
706: fnd_message.set_name ('JTF', x_msg_data);
707: return;
708: end;
709:

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

702:
703: when others then
704: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_TERRITORY_NAME');
705: x_msg_data := fnd_message.get();
706: fnd_message.set_name ('JTF', x_msg_data);
707: return;
708: end;
709:
710:

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

956: commit;
957:
958: exception
959: when others then
960: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
961: x_msg_data := fnd_message.get();
962: fnd_message.set_name ('JTF', x_msg_data);
963: end UPDATE_GEO_TERR;
964:

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

957:
958: exception
959: when others then
960: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
961: x_msg_data := fnd_message.get();
962: fnd_message.set_name ('JTF', x_msg_data);
963: end UPDATE_GEO_TERR;
964:
965:

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

958: exception
959: when others then
960: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
961: x_msg_data := fnd_message.get();
962: fnd_message.set_name ('JTF', x_msg_data);
963: end UPDATE_GEO_TERR;
964:
965:
966: END JTF_TTY_GEO_WEBADI_INT_PKG;