eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_SPED_PUB dependencies on FND_API

Line 37: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

33: -- UPDATE_ATTRIBUTES Procedure - To update the attributes
34:
35: PROCEDURE UPDATE_ATTRIBUTES (
36: P_API_VERSION IN NUMBER DEFAULT 1.0,
37: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: P_CUSTOMER_TRX_ID IN NUMBER,
39: P_ELECT_INV_WEB_ADDRESS IN VARCHAR2,
40: P_ELECT_INV_STATUS IN VARCHAR2,
41: P_ELECT_INV_ACCESS_KEY IN VARCHAR2,

Line 85: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

81: val_for_token value_for_token;
82:
83: BEGIN
84:
85: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
86:
87: -- Standard call to check for call compatibility
88:
89: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

Line 89: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

85: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
86:
87: -- Standard call to check for call compatibility
88:
89: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN
90: tok_arr(1) := '&'||'CURR_VER_NUM';
91: tok_arr(2) := '&'||'API_NAME';
92: tok_arr(3) := '&'||'PKG_NAME';
93: tok_arr(4) := '&'||'CALLER_VER_NUM';

Line 175: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

171: END IF;
172:
173:
174: BEGIN
175: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
176: COMMIT;
177: ELSE
178: ROLLBACK;
179: END IF;

Line 181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

177: ELSE
178: ROLLBACK;
179: END IF;
180: EXCEPTION
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: RAISE invalid_commit_param;
183: END;
184:
185:

Line 200: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 205: 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;
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

Line 210: 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;
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

Line 215: 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;
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

Line 220: 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;
221: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_EI_FINALIZED',NULL);
222:
223: WHEN invalid_commit_param THEN
224: ROLLBACK;

Line 225: 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;
226: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
227:
228: WHEN OTHERS THEN
229: ROLLBACK;

Line 232: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

228: WHEN OTHERS THEN
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;

Line 242: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

238: -- INSERT_LOG Procedure - To insert the log
239:
240: PROCEDURE INSERT_LOG (
241: P_API_VERSION IN NUMBER DEFAULT 1.0,
242: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
243: P_CUSTOMER_TRX_ID IN NUMBER,
244: P_OCCURRENCE_DATE IN DATE,
245: P_ELECT_INV_STATUS IN VARCHAR2,
246: P_MESSAGE_TEXT IN VARCHAR2,

Line 283: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

279: val_for_token value_for_token;
280:
281: BEGIN
282:
283: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
284:
285: -- Standard call to check for call compatibility
286:
287: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

Line 287: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

283: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
284:
285: -- Standard call to check for call compatibility
286:
287: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN
288: tok_arr(1) := '&'||'CURR_VER_NUM';
289: tok_arr(2) := '&'||'API_NAME';
290: tok_arr(3) := '&'||'PKG_NAME';
291: tok_arr(4) := '&'||'CALLER_VER_NUM';

Line 352: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

348: SYSDATE,
349: -1);
350:
351: BEGIN
352: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
353: COMMIT;
354: ELSE
355: ROLLBACK;
356: END IF;

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354: ELSE
355: ROLLBACK;
356: END IF;
357: EXCEPTION
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: RAISE invalid_commit_param;
360: END;
361:
362: ELSE /* If Invalid Electronic Invoice Status is passed */

Line 377: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 382: 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;
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

Line 387: 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;
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

Line 392: 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;
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

Line 397: 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;
398: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_INV_STATUS_DIFFERS',NULL);
399:
400: WHEN invalid_commit_param THEN
401: ROLLBACK;

Line 402: 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;
403: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
404:
405: WHEN OTHERS THEN
406: ROLLBACK;

Line 409: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

405: WHEN OTHERS THEN
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;

Line 492: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

488: val_for_token value_for_token;
489:
490: BEGIN
491:
492: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
493:
494: -- Standard call to check for call compatibility
495:
496: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

Line 496: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

492: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
493:
494: -- Standard call to check for call compatibility
495:
496: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN
497: tok_arr(1) := '&'||'CURR_VER_NUM';
498: tok_arr(2) := '&'||'API_NAME';
499: tok_arr(3) := '&'||'PKG_NAME';
500: tok_arr(4) := '&'||'CALLER_VER_NUM';

Line 545: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 550: 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;
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

Line 555: 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;
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

Line 563: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

559: WHEN OTHERS THEN
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;