APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on FND_API

Line 189: x_retcode := FND_API.G_RET_STS_ERROR;

185: --dbms_output.put_line('template_id: '||l_terr_type_id);
186:
187: exception
188: when no_data_found then
189: x_retcode := FND_API.G_RET_STS_ERROR;
190: x_errbuf := 'Exception in get template id: ' || sqlcode||': '||SQLERRM;
191: end;
192:
193: -- get source_id

Line 203: x_retcode := FND_API.G_RET_STS_ERROR;

199: --dbms_output.put_line('source_id: '||l_source_id);
200:
201: exception
202: when no_data_found then
203: x_retcode := FND_API.G_RET_STS_ERROR;
204: x_errbuf := 'Exception in get source_id: ' || sqlcode||': '||SQLERRM;
205: end;
206:
207: -- get qual_type_usgs_id

Line 219: x_retcode := FND_API.G_RET_STS_ERROR;

215: --dbms_output.put_line('qual_type_usgs_id,qual_type_id: '||l_qtype_usg_id ||', '|| l_qual_type_id);
216:
217: exception
218: when no_data_found then
219: x_retcode := FND_API.G_RET_STS_ERROR;
220: x_errbuf := 'Exception in get qual_type_usgs_id: ' || sqlcode||': '||SQLERRM;
221: end;
222:
223: -- get access_type

Line 234: x_retcode := FND_API.G_RET_STS_ERROR;

230: --dbms_output.put_line('access_type: '|| l_access_type);
231:
232: exception
233: when no_data_found then
234: x_retcode := FND_API.G_RET_STS_ERROR;
235: x_errbuf := 'Exception in get access_type: ' || sqlcode||': '||SQLERRM;
236: end;
237:
238: open get_terr_def_csr (p_terr_id);

Line 494: x_retcode := FND_API.G_RET_STS_SUCCESS;

490: end loop;
491: END IF; --l_terr_def_rec
492:
493: commit;
494: x_retcode := FND_API.G_RET_STS_SUCCESS;
495: x_errbuf := 'UPDATE_TERR_RECORD completed successfully';
496:
497: EXCEPTION
498: WHEN OTHERS THEN

Line 499: x_retcode := FND_API.G_RET_STS_ERROR;

495: x_errbuf := 'UPDATE_TERR_RECORD completed successfully';
496:
497: EXCEPTION
498: WHEN OTHERS THEN
499: x_retcode := FND_API.G_RET_STS_ERROR;
500: x_errbuf := 'Exception in UPDATE_TERR_RECORD: ' || sqlcode||': '||SQLERRM;
501:
502: END UPDATE_TERR_RECORD;
503: