APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on FND_API

Line 164: x_retcode := fnd_api.g_ret_sts_error;

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

Line 232: x_retcode := fnd_api.g_ret_sts_success;

228: ;
229: END
230: CASE;
231:
232: x_retcode := fnd_api.g_ret_sts_success;
233: x_errbuf := 'Success';
234:
235: COMMIT;
236:

Line 239: x_retcode := fnd_api.g_ret_sts_error;

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

Line 245: x_retcode := fnd_api.g_ret_sts_error;

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

Line 1371: x_retcode := fnd_api.g_ret_sts_success;

1367: AND jwr.terr_id = p_terr_rec.terr_id(i);
1368:
1369: END IF;
1370:
1371: x_retcode := fnd_api.g_ret_sts_success;
1372: x_errbuf := 'Success';
1373:
1374: COMMIT;
1375:

Line 1378: x_retcode := fnd_api.g_ret_sts_error;

1374: COMMIT;
1375:
1376: EXCEPTION
1377: WHEN others THEN
1378: x_retcode := fnd_api.g_ret_sts_error;
1379: x_errbuf := 'Other errors in download territory definition: ' || SQLCODE || ': ' || sqlerrm;
1380:
1381: END dl_all_territories;
1382:

Line 1719: x_retcode := fnd_api.g_ret_sts_error;

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

Line 1726: x_retcode := fnd_api.g_ret_sts_error;

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