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

Line 165: fnd_message.clear;

161: --dbms_output.put_line('l_qual_num, l_qual_name: '|| l_qual_num ||', '|| l_qual_name);
162: CASE l_qual_name
163: WHEN 'COUNTRY' THEN
164: x_retcode := fnd_api.g_ret_sts_error;
165: fnd_message.clear;
166: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
167: x_errbuf := fnd_message.GET();
168: ELSE
169: INSERT

Line 166: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');

162: CASE l_qual_name
163: WHEN 'COUNTRY' THEN
164: x_retcode := fnd_api.g_ret_sts_error;
165: fnd_message.clear;
166: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
167: x_errbuf := fnd_message.GET();
168: ELSE
169: INSERT
170: INTO jty_webadi_oth_terr_intf(interface_type, org_id, usage_id, user_id, user_sequence,

Line 167: x_errbuf := fnd_message.GET();

163: WHEN 'COUNTRY' THEN
164: x_retcode := fnd_api.g_ret_sts_error;
165: fnd_message.clear;
166: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
167: x_errbuf := fnd_message.GET();
168: ELSE
169: INSERT
170: INTO jty_webadi_oth_terr_intf(interface_type, org_id, usage_id, user_id, user_sequence,
171: qual1_value1, qual2_value1, qual3_value1, qual4_value1, qual5_value1, qual6_value1,

Line 240: fnd_message.clear;

236:
237: EXCEPTION
238: WHEN no_data_found THEN
239: x_retcode := fnd_api.g_ret_sts_error;
240: fnd_message.clear;
241: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
242: x_errbuf := fnd_message.GET();
243: --raise_application_error(-20000, 'No geography defined for this territory');
244: WHEN others THEN

Line 241: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');

237: EXCEPTION
238: WHEN no_data_found THEN
239: x_retcode := fnd_api.g_ret_sts_error;
240: fnd_message.clear;
241: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
242: x_errbuf := fnd_message.GET();
243: --raise_application_error(-20000, 'No geography defined for this territory');
244: WHEN others THEN
245: x_retcode := fnd_api.g_ret_sts_error;

Line 242: x_errbuf := fnd_message.GET();

238: WHEN no_data_found THEN
239: x_retcode := fnd_api.g_ret_sts_error;
240: fnd_message.clear;
241: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
242: x_errbuf := fnd_message.GET();
243: --raise_application_error(-20000, 'No geography defined for this territory');
244: WHEN others THEN
245: x_retcode := fnd_api.g_ret_sts_error;
246: fnd_message.clear;

Line 246: fnd_message.clear;

242: x_errbuf := fnd_message.GET();
243: --raise_application_error(-20000, 'No geography defined for this territory');
244: WHEN others THEN
245: x_retcode := fnd_api.g_ret_sts_error;
246: fnd_message.clear;
247: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
248: fnd_message.set_token('POSITION', sqlerrm);
249: x_errbuf := fnd_message.GET();
250:

Line 247: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');

243: --raise_application_error(-20000, 'No geography defined for this territory');
244: WHEN others THEN
245: x_retcode := fnd_api.g_ret_sts_error;
246: fnd_message.clear;
247: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
248: fnd_message.set_token('POSITION', sqlerrm);
249: x_errbuf := fnd_message.GET();
250:
251: END dl_unassign_geography;

Line 248: fnd_message.set_token('POSITION', sqlerrm);

244: WHEN others THEN
245: x_retcode := fnd_api.g_ret_sts_error;
246: fnd_message.clear;
247: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
248: fnd_message.set_token('POSITION', sqlerrm);
249: x_errbuf := fnd_message.GET();
250:
251: END dl_unassign_geography;
252:

Line 249: x_errbuf := fnd_message.GET();

245: x_retcode := fnd_api.g_ret_sts_error;
246: fnd_message.clear;
247: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
248: fnd_message.set_token('POSITION', sqlerrm);
249: x_errbuf := fnd_message.GET();
250:
251: END dl_unassign_geography;
252:
253: FUNCTION get_resource_name(p_resource_type VARCHAR2, p_resource_id NUMBER, p_group_id NUMBER, p_role_id VARCHAR2, p_role VARCHAR2) RETURN VARCHAR IS

Line 1716: fnd_message.clear;

1712:
1713: --dbms_output.put_line('get_qual_details: Returns l_no_of_qualifiers ' || l_no_of_qualifiers);
1714:
1715: IF(l_no_of_qualifiers > 75) THEN
1716: fnd_message.clear;
1717: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1718: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1719: x_retcode := fnd_api.g_ret_sts_error;
1720: x_errbuf := fnd_message.GET();

Line 1717: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');

1713: --dbms_output.put_line('get_qual_details: Returns l_no_of_qualifiers ' || l_no_of_qualifiers);
1714:
1715: IF(l_no_of_qualifiers > 75) THEN
1716: fnd_message.clear;
1717: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1718: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1719: x_retcode := fnd_api.g_ret_sts_error;
1720: x_errbuf := fnd_message.GET();
1721:

Line 1718: fnd_message.set_token('POSITION', l_no_of_qualifiers);

1714:
1715: IF(l_no_of_qualifiers > 75) THEN
1716: fnd_message.clear;
1717: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1718: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1719: x_retcode := fnd_api.g_ret_sts_error;
1720: x_errbuf := fnd_message.GET();
1721:
1722: --APP_EXCEPTION.RAISE_EXCEPTION;

Line 1720: x_errbuf := fnd_message.GET();

1716: fnd_message.clear;
1717: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1718: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1719: x_retcode := fnd_api.g_ret_sts_error;
1720: x_errbuf := fnd_message.GET();
1721:
1722: --APP_EXCEPTION.RAISE_EXCEPTION;
1723: ELSIF(l_no_of_qualifiers = 0) THEN
1724: fnd_message.clear;

Line 1724: fnd_message.clear;

1720: x_errbuf := fnd_message.GET();
1721:
1722: --APP_EXCEPTION.RAISE_EXCEPTION;
1723: ELSIF(l_no_of_qualifiers = 0) THEN
1724: fnd_message.clear;
1725: fnd_message.set_name('JTF', 'JTY_OTH_TERR_NO_QUAL_ENABLED');
1726: x_retcode := fnd_api.g_ret_sts_error;
1727: x_errbuf := fnd_message.GET();
1728:

Line 1725: fnd_message.set_name('JTF', 'JTY_OTH_TERR_NO_QUAL_ENABLED');

1721:
1722: --APP_EXCEPTION.RAISE_EXCEPTION;
1723: ELSIF(l_no_of_qualifiers = 0) THEN
1724: fnd_message.clear;
1725: fnd_message.set_name('JTF', 'JTY_OTH_TERR_NO_QUAL_ENABLED');
1726: x_retcode := fnd_api.g_ret_sts_error;
1727: x_errbuf := fnd_message.GET();
1728:
1729: --APP_EXCEPTION.RAISE_EXCEPTION;

Line 1727: x_errbuf := fnd_message.GET();

1723: ELSIF(l_no_of_qualifiers = 0) THEN
1724: fnd_message.clear;
1725: fnd_message.set_name('JTF', 'JTY_OTH_TERR_NO_QUAL_ENABLED');
1726: x_retcode := fnd_api.g_ret_sts_error;
1727: x_errbuf := fnd_message.GET();
1728:
1729: --APP_EXCEPTION.RAISE_EXCEPTION;
1730: ELSE
1731: -- start populating terr detail