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 86: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 180: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

176: END IF;
177:
178:
179: BEGIN
180: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
181: COMMIT;
182: ELSE
183: ROLLBACK;
184: END IF;

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

182: ELSE
183: ROLLBACK;
184: END IF;
185: EXCEPTION
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: RAISE invalid_commit_param;
188: END;
189:
190:

Line 205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

Line 230: 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;
231: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
232:
233: WHEN OTHERS THEN
234: ROLLBACK;

Line 237: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 247: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

243: -- INSERT_LOG Procedure - To insert the log
244:
245: PROCEDURE INSERT_LOG (
246: P_API_VERSION IN NUMBER DEFAULT 1.0,
247: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: P_CUSTOMER_TRX_ID IN NUMBER,
249: P_OCCURRENCE_DATE IN DATE,
250: P_ELECT_INV_STATUS IN VARCHAR2,
251: P_MESSAGE_TEXT IN VARCHAR2,

Line 289: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

285: val_for_token value_for_token;
286:
287: BEGIN
288:
289: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
290:
291: -- Standard call to check for call compatibility
292:
293: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

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

289: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
290:
291: -- Standard call to check for call compatibility
292:
293: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN
294: tok_arr(1) := '&'||'CURR_VER_NUM';
295: tok_arr(2) := '&'||'API_NAME';
296: tok_arr(3) := '&'||'PKG_NAME';
297: tok_arr(4) := '&'||'CALLER_VER_NUM';

Line 358: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

354: SYSDATE,
355: -1);
356:
357: BEGIN
358: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
359: COMMIT;
360: ELSE
361: ROLLBACK;
362: END IF;

Line 364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

360: ELSE
361: ROLLBACK;
362: END IF;
363: EXCEPTION
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: RAISE invalid_commit_param;
366: END;
367:
368: ELSE /* If Invalid Electronic Invoice Status is passed */

Line 383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

Line 408: 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;
409: X_MSG_DATA := FND_MESSAGE.GET_STRING('JL','JL_BR_API_COMMIT',NULL);
410:
411: WHEN OTHERS THEN
412: ROLLBACK;

Line 415: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 498: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

494: val_for_token value_for_token;
495:
496: BEGIN
497:
498: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
499:
500: -- Standard call to check for call compatibility
501:
502: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN

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

498: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
499:
500: -- Standard call to check for call compatibility
501:
502: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, P_API_VERSION, l_api_name, G_PKG_NAME) THEN
503: tok_arr(1) := '&'||'CURR_VER_NUM';
504: tok_arr(2) := '&'||'API_NAME';
505: tok_arr(3) := '&'||'PKG_NAME';
506: tok_arr(4) := '&'||'CALLER_VER_NUM';

Line 551: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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

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

Line 569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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