197: EXCEPTION
198:
199: WHEN invalid_apiversion THEN
200: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
201: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INVALID_VER_NUM',NULL);
202: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
203:
204: WHEN incompatible_apiversion THEN
205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
202: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
203:
204: WHEN incompatible_apiversion THEN
205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
206: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INCOMPATIBLE_API_CALL',NULL);
207: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
208:
209: WHEN invalid_cust_trx_id THEN
210: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
207: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
208:
209: WHEN invalid_cust_trx_id THEN
210: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
211: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_CUST_TRX_ID',NULL);
212: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
213:
214: WHEN invalid_ei_status THEN
215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
212: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
213:
214: WHEN invalid_ei_status THEN
215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
216: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_EI_STATUS',NULL);
217: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
218:
219: WHEN inv_status_final THEN
220: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
217: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
218:
219: WHEN inv_status_final THEN
220: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
221: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_EI_FINALIZED',NULL);
222:
223: WHEN invalid_commit_param THEN
224: ROLLBACK;
225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
222:
223: WHEN invalid_commit_param THEN
224: ROLLBACK;
225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
226: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
227:
228: WHEN OTHERS THEN
229: ROLLBACK;
230: tok_arr(1) := 'ERRMSG';
229: ROLLBACK;
230: tok_arr(1) := 'ERRMSG';
231: val_for_token(1) := SQLERRM;
232: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
233: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_ERROR',NULL);
234: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
235:
236: END UPDATE_ATTRIBUTES;
237:
374: EXCEPTION
375:
376: WHEN invalid_apiversion THEN
377: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
378: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INVALID_VER_NUM',NULL);
379: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
380:
381: WHEN incompatible_apiversion THEN
382: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
379: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
380:
381: WHEN incompatible_apiversion THEN
382: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
383: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INCOMPATIBLE_API_CALL',NULL);
384: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
385:
386: WHEN invalid_cust_trx_id THEN
387: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
384: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
385:
386: WHEN invalid_cust_trx_id THEN
387: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
388: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_CUST_TRX_ID',NULL);
389: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
390:
391: WHEN invalid_ei_status THEN
392: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
389: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
390:
391: WHEN invalid_ei_status THEN
392: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
393: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_EI_STATUS',NULL);
394: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
395:
396: WHEN inv_status_differs THEN
397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
394: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
395:
396: WHEN inv_status_differs THEN
397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
398: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INV_STATUS_DIFFERS',NULL);
399:
400: WHEN invalid_commit_param THEN
401: ROLLBACK;
402: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
399:
400: WHEN invalid_commit_param THEN
401: ROLLBACK;
402: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
403: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
404:
405: WHEN OTHERS THEN
406: ROLLBACK;
407: tok_arr(0) := 'ERRMSG';
406: ROLLBACK;
407: tok_arr(0) := 'ERRMSG';
408: val_for_token(0) := SQLERRM;
409: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
410: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_ERROR',NULL);
411: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
412:
413: END INSERT_LOG;
414:
542: EXCEPTION
543:
544: WHEN invalid_apiversion THEN
545: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
546: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INVALID_VER_NUM',NULL);
547: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
548:
549: WHEN incompatible_apiversion THEN
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
547: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
548:
549: WHEN incompatible_apiversion THEN
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
551: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INCOMPATIBLE_API_CALL',NULL);
552: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
553:
554: WHEN invalid_loc_id THEN
555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
552: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
553:
554: WHEN invalid_loc_id THEN
555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
556: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_LOC_ID',NULL);
557: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
558:
559: WHEN OTHERS THEN
560: ROLLBACK;
560: ROLLBACK;
561: tok_arr(1) := 'ERRMSG';
562: val_for_token(1) := SQLERRM;
563: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
564: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_ERROR',NULL);
565: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
566:
567: END GET_IBGE_CODES;
568: