202: EXCEPTION
203:
204: WHEN invalid_apiversion THEN
205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
206: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INVALID_VER_NUM',NULL);
207: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
208:
209: WHEN incompatible_apiversion 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 incompatible_apiversion THEN
210: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
211: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INCOMPATIBLE_API_CALL',NULL);
212: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
213:
214: WHEN invalid_cust_trx_id 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_cust_trx_id THEN
215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
216: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_CUST_TRX_ID',NULL);
217: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
218:
219: WHEN invalid_ei_status 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 invalid_ei_status THEN
220: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
221: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_EI_STATUS',NULL);
222: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
223:
224: WHEN inv_status_final THEN
225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
222: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
223:
224: WHEN inv_status_final THEN
225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
226: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_EI_FINALIZED',NULL);
227:
228: WHEN invalid_commit_param THEN
229: ROLLBACK;
230: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
227:
228: WHEN invalid_commit_param THEN
229: ROLLBACK;
230: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
231: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
232:
233: WHEN OTHERS THEN
234: ROLLBACK;
235: tok_arr(1) := 'ERRMSG';
234: ROLLBACK;
235: tok_arr(1) := 'ERRMSG';
236: val_for_token(1) := SQLERRM;
237: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
238: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_ERROR',NULL);
239: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
240:
241: END UPDATE_ATTRIBUTES;
242:
380: EXCEPTION
381:
382: WHEN invalid_apiversion THEN
383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
384: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INVALID_VER_NUM',NULL);
385: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
386:
387: WHEN incompatible_apiversion THEN
388: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
385: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
386:
387: WHEN incompatible_apiversion THEN
388: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
389: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INCOMPATIBLE_API_CALL',NULL);
390: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
391:
392: WHEN invalid_cust_trx_id THEN
393: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
390: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
391:
392: WHEN invalid_cust_trx_id THEN
393: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
394: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_CUST_TRX_ID',NULL);
395: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
396:
397: WHEN invalid_ei_status THEN
398: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
395: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
396:
397: WHEN invalid_ei_status THEN
398: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
399: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_EI_STATUS',NULL);
400: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
401:
402: WHEN inv_status_differs THEN
403: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
400: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
401:
402: WHEN inv_status_differs THEN
403: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
404: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INV_STATUS_DIFFERS',NULL);
405:
406: WHEN invalid_commit_param THEN
407: ROLLBACK;
408: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
405:
406: WHEN invalid_commit_param THEN
407: ROLLBACK;
408: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
409: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
410:
411: WHEN OTHERS THEN
412: ROLLBACK;
413: tok_arr(0) := 'ERRMSG';
412: ROLLBACK;
413: tok_arr(0) := 'ERRMSG';
414: val_for_token(0) := SQLERRM;
415: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
416: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_ERROR',NULL);
417: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
418:
419: END INSERT_LOG;
420:
548: EXCEPTION
549:
550: WHEN invalid_apiversion THEN
551: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
552: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INVALID_VER_NUM',NULL);
553: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
554:
555: WHEN incompatible_apiversion THEN
556: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
553: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
554:
555: WHEN incompatible_apiversion THEN
556: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
557: X_MSG_DATA := FND_MESSAGE.GET_STRING('FND','FND_AS_INCOMPATIBLE_API_CALL',NULL);
558: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
559:
560: WHEN invalid_loc_id THEN
561: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
558: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
559:
560: WHEN invalid_loc_id THEN
561: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
562: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INVALID_LOC_ID',NULL);
563: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
564:
565: WHEN OTHERS THEN
566: ROLLBACK;
566: ROLLBACK;
567: tok_arr(1) := 'ERRMSG';
568: val_for_token(1) := SQLERRM;
569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
570: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_ERROR',NULL);
571: X_MSG_DATA := REPLACE_TOKEN(X_MSG_DATA,tok_arr,val_for_token);
572:
573: END GET_IBGE_CODES;
574: