152: retcode := 0;
153:
154: /* Setting concurrent program values */
155:
156: l_n_request_id := fnd_global.conc_request_id;
157: l_n_prog_appl_id := fnd_global.prog_appl_id;
158: l_n_prog_id := fnd_global.conc_program_id;
159: l_d_prog_upd_dt := SYSDATE;
160: IF l_n_request_id = -1 THEN
153:
154: /* Setting concurrent program values */
155:
156: l_n_request_id := fnd_global.conc_request_id;
157: l_n_prog_appl_id := fnd_global.prog_appl_id;
158: l_n_prog_id := fnd_global.conc_program_id;
159: l_d_prog_upd_dt := SYSDATE;
160: IF l_n_request_id = -1 THEN
161: l_n_request_id := NULL;
154: /* Setting concurrent program values */
155:
156: l_n_request_id := fnd_global.conc_request_id;
157: l_n_prog_appl_id := fnd_global.prog_appl_id;
158: l_n_prog_id := fnd_global.conc_program_id;
159: l_d_prog_upd_dt := SYSDATE;
160: IF l_n_request_id = -1 THEN
161: l_n_request_id := NULL;
162: l_n_prog_appl_id := NULL;
307: 'GL_IMP_COA_SEG_VAL_INTERFACE',
308: v_gl_flex_values_tbl(i).interface_id,
309: l_n_msg_num,
310: l_c_msg_txt,
311: NVL(fnd_global.user_id,-1),
312: SYSDATE,
313: NVL(fnd_global.user_id,-1),
314: SYSDATE,
315: NVL(fnd_global.login_id,-1),
309: l_n_msg_num,
310: l_c_msg_txt,
311: NVL(fnd_global.user_id,-1),
312: SYSDATE,
313: NVL(fnd_global.user_id,-1),
314: SYSDATE,
315: NVL(fnd_global.login_id,-1),
316: l_n_request_id,
317: l_n_prog_appl_id,
311: NVL(fnd_global.user_id,-1),
312: SYSDATE,
313: NVL(fnd_global.user_id,-1),
314: SYSDATE,
315: NVL(fnd_global.login_id,-1),
316: l_n_request_id,
317: l_n_prog_appl_id,
318: l_n_prog_id,
319: l_d_prog_upd_dt
386: 'GL_IMP_COA_NORM_HIER_INTERFACE',
387: v_gl_flex_values_nh_tbl(i).interface_id,
388: l_n_msg_num,
389: l_c_msg_txt,
390: NVL(fnd_global.user_id,-1),
391: SYSDATE,
392: NVL(fnd_global.user_id,-1),
393: SYSDATE,
394: NVL(fnd_global.login_id,-1),
388: l_n_msg_num,
389: l_c_msg_txt,
390: NVL(fnd_global.user_id,-1),
391: SYSDATE,
392: NVL(fnd_global.user_id,-1),
393: SYSDATE,
394: NVL(fnd_global.login_id,-1),
395: l_n_request_id,
396: l_n_prog_appl_id,
390: NVL(fnd_global.user_id,-1),
391: SYSDATE,
392: NVL(fnd_global.user_id,-1),
393: SYSDATE,
394: NVL(fnd_global.login_id,-1),
395: l_n_request_id,
396: l_n_prog_appl_id,
397: l_n_prog_id,
398: l_d_prog_upd_dt