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 158: fnd_message.clear;

154: --dbms_output.put_line('l_qual_num, l_qual_name: '|| l_qual_num ||', '|| l_qual_name);
155: CASE l_qual_name
156: WHEN 'COUNTRY' THEN
157: x_retcode := fnd_api.g_ret_sts_error;
158: fnd_message.clear;
159: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
160: x_errbuf := fnd_message.GET();
161: ELSE
162: INSERT

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

155: CASE l_qual_name
156: WHEN 'COUNTRY' THEN
157: x_retcode := fnd_api.g_ret_sts_error;
158: fnd_message.clear;
159: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
160: x_errbuf := fnd_message.GET();
161: ELSE
162: INSERT
163: INTO jty_webadi_oth_terr_intf(interface_type, org_id, usage_id, user_id, user_sequence,

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

156: WHEN 'COUNTRY' THEN
157: x_retcode := fnd_api.g_ret_sts_error;
158: fnd_message.clear;
159: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
160: x_errbuf := fnd_message.GET();
161: ELSE
162: INSERT
163: INTO jty_webadi_oth_terr_intf(interface_type, org_id, usage_id, user_id, user_sequence,
164: qual1_value1, qual2_value1, qual3_value1, qual4_value1, qual5_value1, qual6_value1,

Line 233: fnd_message.clear;

229:
230: EXCEPTION
231: WHEN no_data_found THEN
232: x_retcode := fnd_api.g_ret_sts_error;
233: fnd_message.clear;
234: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
235: x_errbuf := fnd_message.GET();
236: --raise_application_error(-20000, 'No geography defined for this territory');
237: WHEN others THEN

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

230: EXCEPTION
231: WHEN no_data_found THEN
232: x_retcode := fnd_api.g_ret_sts_error;
233: fnd_message.clear;
234: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
235: x_errbuf := fnd_message.GET();
236: --raise_application_error(-20000, 'No geography defined for this territory');
237: WHEN others THEN
238: x_retcode := fnd_api.g_ret_sts_error;

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

231: WHEN no_data_found THEN
232: x_retcode := fnd_api.g_ret_sts_error;
233: fnd_message.clear;
234: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
235: x_errbuf := fnd_message.GET();
236: --raise_application_error(-20000, 'No geography defined for this territory');
237: WHEN others THEN
238: x_retcode := fnd_api.g_ret_sts_error;
239: fnd_message.clear;

Line 239: fnd_message.clear;

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

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

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

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

237: WHEN others THEN
238: x_retcode := fnd_api.g_ret_sts_error;
239: fnd_message.clear;
240: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
241: fnd_message.set_token('POSITION', sqlerrm);
242: x_errbuf := fnd_message.GET();
243:
244: END dl_unassign_geography;
245:

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

238: x_retcode := fnd_api.g_ret_sts_error;
239: fnd_message.clear;
240: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
241: fnd_message.set_token('POSITION', sqlerrm);
242: x_errbuf := fnd_message.GET();
243:
244: END dl_unassign_geography;
245:
246: 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 1258: fnd_message.clear;

1254:
1255: --dbms_output.put_line('get_qual_details: Returns l_no_of_qualifiers ' || l_no_of_qualifiers);
1256:
1257: IF(l_no_of_qualifiers > 25) THEN
1258: fnd_message.clear;
1259: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1260: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1261: x_retcode := fnd_api.g_ret_sts_error;
1262: x_errbuf := fnd_message.GET();

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

1255: --dbms_output.put_line('get_qual_details: Returns l_no_of_qualifiers ' || l_no_of_qualifiers);
1256:
1257: IF(l_no_of_qualifiers > 25) THEN
1258: fnd_message.clear;
1259: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1260: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1261: x_retcode := fnd_api.g_ret_sts_error;
1262: x_errbuf := fnd_message.GET();
1263:

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

1256:
1257: IF(l_no_of_qualifiers > 25) THEN
1258: fnd_message.clear;
1259: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1260: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1261: x_retcode := fnd_api.g_ret_sts_error;
1262: x_errbuf := fnd_message.GET();
1263:
1264: --APP_EXCEPTION.RAISE_EXCEPTION;

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

1258: fnd_message.clear;
1259: fnd_message.set_name('JTF', 'JTY_OTH_TERR_TOO_MANY_QUAL');
1260: fnd_message.set_token('POSITION', l_no_of_qualifiers);
1261: x_retcode := fnd_api.g_ret_sts_error;
1262: x_errbuf := fnd_message.GET();
1263:
1264: --APP_EXCEPTION.RAISE_EXCEPTION;
1265: ELSIF(l_no_of_qualifiers = 0) THEN
1266: fnd_message.clear;

Line 1266: fnd_message.clear;

1262: x_errbuf := fnd_message.GET();
1263:
1264: --APP_EXCEPTION.RAISE_EXCEPTION;
1265: ELSIF(l_no_of_qualifiers = 0) THEN
1266: fnd_message.clear;
1267: fnd_message.set_name('JTF', 'JTY_OTH_TERR_NO_QUAL_ENABLED');
1268: x_retcode := fnd_api.g_ret_sts_error;
1269: x_errbuf := fnd_message.GET();
1270:

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

1263:
1264: --APP_EXCEPTION.RAISE_EXCEPTION;
1265: ELSIF(l_no_of_qualifiers = 0) THEN
1266: fnd_message.clear;
1267: fnd_message.set_name('JTF', 'JTY_OTH_TERR_NO_QUAL_ENABLED');
1268: x_retcode := fnd_api.g_ret_sts_error;
1269: x_errbuf := fnd_message.GET();
1270:
1271: --APP_EXCEPTION.RAISE_EXCEPTION;

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

1265: ELSIF(l_no_of_qualifiers = 0) THEN
1266: fnd_message.clear;
1267: fnd_message.set_name('JTF', 'JTY_OTH_TERR_NO_QUAL_ENABLED');
1268: x_retcode := fnd_api.g_ret_sts_error;
1269: x_errbuf := fnd_message.GET();
1270:
1271: --APP_EXCEPTION.RAISE_EXCEPTION;
1272: ELSE
1273: -- start populating terr detail