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.JAI_OPEN_API_PKG dependencies on JAI_INTERFACE_ERR_LINES

Line 119: FROM jai_interface_err_lines

115: ORDER BY import_status;
116:
117: CURSOR get_error_cur(pn_interface_line_id IN NUMBER) IS
118: SELECT error_message
119: FROM jai_interface_err_lines
120: WHERE interface_line_id = pn_interface_line_id;
121:
122: lv_err_name varchar2(1000);
123: lv_err_message VARCHAR2(1000);

Line 178: delete from jai_interface_err_lines

174: and import_process= GV_PROCESS_ACCOUNTING
175: );
176:
177: --Delete error lines thirdly
178: delete from jai_interface_err_lines
179: where interface_line_id in
180: (
181: select interface_line_id
182: from jai_interface_lines_all

Line 202: delete from jai_interface_err_lines

198: PROCEDURE del_line_reference(pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE)
199: IS
200: BEGIN
201:
202: delete from jai_interface_err_lines
203: where interface_line_id = pn_interface_line_id;
204:
205: END del_line_reference;
206:

Line 377: pv_fnd_log IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE

373:
374:
375:
376: PROCEDURE record_fnd_log(
377: pv_fnd_log IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE
378: )
379: IS
380: BEGIN
381:

Line 388: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,

384: END record_fnd_log;
385:
386:
387: /*
388: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,
389: */
390: PROCEDURE log_error(
391: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' or 'TAX'
392: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

Line 391: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' or 'TAX'

387: /*
388: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,
389: */
390: PROCEDURE log_error(
391: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' or 'TAX'
392: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
393: pn_source_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_SOURCE_LINE_ID%TYPE,
394: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
395: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE

Line 392: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

388: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,
389: */
390: PROCEDURE log_error(
391: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' or 'TAX'
392: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
393: pn_source_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_SOURCE_LINE_ID%TYPE,
394: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
395: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE
396: )

Line 393: pn_source_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_SOURCE_LINE_ID%TYPE,

389: */
390: PROCEDURE log_error(
391: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' or 'TAX'
392: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
393: pn_source_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_SOURCE_LINE_ID%TYPE,
394: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
395: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE
396: )
397: IS

Line 394: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,

390: PROCEDURE log_error(
391: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' or 'TAX'
392: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
393: pn_source_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_SOURCE_LINE_ID%TYPE,
394: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
395: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE
396: )
397: IS
398: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

Line 395: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE

391: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' or 'TAX'
392: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
393: pn_source_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_SOURCE_LINE_ID%TYPE,
394: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
395: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE
396: )
397: IS
398: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
399: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

Line 405: INSERT INTO JAI_INTERFACE_ERR_LINES

401:
402: ln_user_id := fnd_global.user_id ;
403: ln_login_id := fnd_global.login_id ;
404:
405: INSERT INTO JAI_INTERFACE_ERR_LINES
406: (
407: INTERFACE_ERROR_ID,
408: ERROR_TYPE,
409: INTERFACE_LINE_ID,

Line 426: JAI_INTERFACE_ERR_LINES_S.nextval,

422: --Added by zhiwei for bug#12425101 end
423: )
424: VALUES
425: (
426: JAI_INTERFACE_ERR_LINES_S.nextval,
427: pv_err_level,
428: pn_line_id,
429: pn_source_line_id,
430: pv_err_mess,

Line 10298: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,

10294: END ja_in_calc_prec_taxes;
10295:
10296:
10297: /*
10298: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,
10299: */
10300: /*PROCEDURE log_err(
10301: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' OR 'TAX' OR 'DIS'
10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

Line 10301: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' OR 'TAX' OR 'DIS'

10297: /*
10298: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,
10299: */
10300: /*PROCEDURE log_err(
10301: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' OR 'TAX' OR 'DIS'
10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

Line 10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

10298: ||When occurred error, populate table jai_interface_err_lines and fnd log error info ,
10299: */
10300: /*PROCEDURE log_err(
10301: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' OR 'TAX' OR 'DIS'
10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,

Line 10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

10299: */
10300: /*PROCEDURE log_err(
10301: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' OR 'TAX' OR 'DIS'
10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
10307: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE,

Line 10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

10300: /*PROCEDURE log_err(
10301: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' OR 'TAX' OR 'DIS'
10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
10307: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE,
10308: pn_request_id IN JAI_INTERFACE_ERR_LINES.REQUEST_ID%TYPE

Line 10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,

10301: pv_err_level IN JAI_INTERFACE_ERR_LINES.ERROR_TYPE%TYPE, --'LINE' OR 'TAX' OR 'DIS'
10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
10307: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE,
10308: pn_request_id IN JAI_INTERFACE_ERR_LINES.REQUEST_ID%TYPE
10309: )

Line 10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,

10302: pn_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
10307: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE,
10308: pn_request_id IN JAI_INTERFACE_ERR_LINES.REQUEST_ID%TYPE
10309: )
10310: IS

Line 10307: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE,

10303: pn_interface_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
10307: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE,
10308: pn_request_id IN JAI_INTERFACE_ERR_LINES.REQUEST_ID%TYPE
10309: )
10310: IS
10311: BEGIN

Line 10308: pn_request_id IN JAI_INTERFACE_ERR_LINES.REQUEST_ID%TYPE

10304: pn_interface_tax_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10305: pn_interface_dis_line_id IN JAI_INTERFACE_ERR_LINES.INTERFACE_ERROR_ID%TYPE,
10306: pv_err_mess IN JAI_INTERFACE_ERR_LINES.ERROR_MESSAGE%TYPE,
10307: pv_invalid_value IN JAI_INTERFACE_ERR_LINES.INVALID_VALUE%TYPE,
10308: pn_request_id IN JAI_INTERFACE_ERR_LINES.REQUEST_ID%TYPE
10309: )
10310: IS
10311: BEGIN
10312: INSERT INTO JAI_INTERFACE_ERR_LINES

Line 10312: INSERT INTO JAI_INTERFACE_ERR_LINES

10308: pn_request_id IN JAI_INTERFACE_ERR_LINES.REQUEST_ID%TYPE
10309: )
10310: IS
10311: BEGIN
10312: INSERT INTO JAI_INTERFACE_ERR_LINES
10313: ( --LINE_ID,
10314: ERROR_TYPE,
10315: INTERFACE_LINE_ID,
10316: INTERFACE_TAX_LINE_ID,

Line 12157: delete from jai_interface_err_lines

12153:
12154: BEGIN
12155: IF(NVL(pv_line_status,GV_LINE_STATUS_ALL)=GV_LINE_STATUS_ALL)THEN
12156:
12157: delete from jai_interface_err_lines
12158: where 1=1
12159: and interface_line_id in
12160: (
12161: select interface_line_id

Line 12217: delete from jai_interface_err_lines

12213: AND party_site_id = nvl(pn_party_site,party_site_id);
12214: end if;
12215: ELSIF (NVL(pv_line_status,GV_LINE_STATUS_ALL)=GV_LINE_STATUS_ERROR)THEN
12216:
12217: delete from jai_interface_err_lines
12218: where 1=1
12219: and interface_line_id in
12220: (
12221: SELECT interface_line_id

Line 12273: delete from jai_interface_err_lines

12269: and (request_id is null or request_id='');
12270:
12271: ELSIF (NVL(pv_line_status,GV_LINE_STATUS_SUCCESS)=GV_LINE_STATUS_SUCCESS)THEN
12272:
12273: delete from jai_interface_err_lines
12274: where 1=1
12275: and interface_line_id in
12276: (
12277: SELECT interface_line_id