APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on FND_API

Line 157: x_retcode := fnd_api.g_ret_sts_error;

153:
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

Line 225: x_retcode := fnd_api.g_ret_sts_success;

221: ;
222: END
223: CASE;
224:
225: x_retcode := fnd_api.g_ret_sts_success;
226: x_errbuf := 'Success';
227:
228: COMMIT;
229:

Line 232: x_retcode := fnd_api.g_ret_sts_error;

228: COMMIT;
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');

Line 238: x_retcode := fnd_api.g_ret_sts_error;

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;
240: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
241: fnd_message.set_token('POSITION', sqlerrm);
242: x_errbuf := fnd_message.GET();

Line 916: x_retcode := fnd_api.g_ret_sts_success;

912: AND jwr.terr_id = p_terr_rec.terr_id(i);
913:
914: END IF;
915:
916: x_retcode := fnd_api.g_ret_sts_success;
917: x_errbuf := 'Success';
918:
919: COMMIT;
920:

Line 923: x_retcode := fnd_api.g_ret_sts_error;

919: COMMIT;
920:
921: EXCEPTION
922: WHEN others THEN
923: x_retcode := fnd_api.g_ret_sts_error;
924: x_errbuf := 'Other errors in download territory definition: ' || SQLCODE || ': ' || sqlerrm;
925:
926: END dl_all_territories;
927:

Line 1261: x_retcode := fnd_api.g_ret_sts_error;

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;
1265: ELSIF(l_no_of_qualifiers = 0) THEN

Line 1268: x_retcode := fnd_api.g_ret_sts_error;

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;
1272: ELSE