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.ICX_REQ_COPY_REQ dependencies on ICX_UTIL

Line 9: c_prompts icx_util.g_prompts_table;

5: PROCEDURE welcome_page IS
6:
7: v_lang varchar2(5);
8: c_title varchar2(80);
9: c_prompts icx_util.g_prompts_table;
10: v_dcdName varchar2(1000);
11: v_message_caption varchar2(200);
12: v_message_text varchar2(1000);
13: v_0_encrypt varchar2(100);

Line 41: icx_util.copyright;

37: htp.bodyOpen;
38:
39: htp.headOpen;
40:
41: icx_util.copyright;
42:
43: js.scriptOpen;
44:
45: htp.p('function help_window(){

Line 216: y_table icx_util.char240_table;

212: v_session_id NUMBER := NULL;
213: v_end_row NUMBER := 0;
214: v_encrypted_where NUMBER := NULL;
215: v_param VARCHAR2(240) := NULL;
216: y_table icx_util.char240_table;
217: v_row_id VARCHAR2(25) := NULL;
218:
219: l_message VARCHAR2(2000) := NULL;
220: l_err_num NUMBER := 0;

Line 307: icx_util.copyright;

303:
304: IF v_total_rows = 0 THEN
305: htp.htmlOpen;
306: htp.headOpen;
307: icx_util.copyright;
308: js.scriptOpen;
309: icx_admin_sig.help_win_script(v_help_url, v_language_code);
310: js.scriptClose;
311: htp.title(ak_query_pkg.g_regions_table(0).name);

Line 330: icx_util.copyright;

326:
327: ELSE
328: htp.htmlOpen;
329: htp.headOpen;
330: icx_util.copyright;
331:
332: js.scriptOpen;
333: icx_admin_sig.help_win_script(v_help_url, v_language_code);
334: js.scriptClose;

Line 370: htp.p('');

366: END IF; /* (v_total_rows > 5) */
367:
368: -- Print table header
369: htp.tableOpen('BORDER=2','','','', 'CELLPADDING=2');
370: htp.p('');
371:
372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN

Line 376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);

372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN
375:
376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);
377: htp.p('');
378:
379: END IF; /* if ak_query_pkg.... */
380:

Line 387: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);

383: htp.tableData(''); -- ?
384:
385: -- FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
386: FOR r IN p_start_row -1..v_end_row - 1 LOOP
387: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
388:
389: htp.tableRowOpen;
390:
391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP

Line 448: -- icx_util.add_error(substr(SQLERRM, 12, 512));

444:
445: EXCEPTION
446: WHEN OTHERS THEN
447: -- htp.p('Error in display reqs ' || substr(SQLERRM, 1, 512));
448: -- icx_util.add_error(substr(SQLERRM, 12, 512));
449: -- icx_util.error_page_print;
450:
451: l_err_num := SQLCODE;
452: l_message := SQLERRM;

Line 449: -- icx_util.error_page_print;

445: EXCEPTION
446: WHEN OTHERS THEN
447: -- htp.p('Error in display reqs ' || substr(SQLERRM, 1, 512));
448: -- icx_util.add_error(substr(SQLERRM, 12, 512));
449: -- icx_util.error_page_print;
450:
451: l_err_num := SQLCODE;
452: l_message := SQLERRM;
453: select substr(l_message,12,512) into l_err_mesg from dual;

Line 460: icx_util.add_error(l_message) ;

456: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
457: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);
458: fnd_message.set_token('FORMAT_MASK_TOKEN',nvl(l_web_user_date_format,'DD-MON-YYYY'));
459: l_message := l_err_mesg||'
'||fnd_message.get;
460: icx_util.add_error(l_message) ;
461: icx_admin_sig.error_screen(l_err_mesg);
462: else
463: icx_util.add_error(l_err_mesg);
464: icx_admin_sig.error_screen(l_err_mesg);

Line 463: icx_util.add_error(l_err_mesg);

459: l_message := l_err_mesg||'
'||fnd_message.get;
460: icx_util.add_error(l_message) ;
461: icx_admin_sig.error_screen(l_err_mesg);
462: else
463: icx_util.add_error(l_err_mesg);
464: icx_admin_sig.error_screen(l_err_mesg);
465: end if;
466:
467: END display_reqs;

Line 925: icx_util.add_error(substr(SQLERRM, 12, 512));

921:
922: EXCEPTION
923: WHEN OTHERS THEN
924: -- htp.p('Error in copy req ' || substr(SQLERRM, 1, 512));
925: icx_util.add_error(substr(SQLERRM, 12, 512));
926: icx_util.error_page_print;
927:
928: END copy_req;
929:

Line 926: icx_util.error_page_print;

922: EXCEPTION
923: WHEN OTHERS THEN
924: -- htp.p('Error in copy req ' || substr(SQLERRM, 1, 512));
925: icx_util.add_error(substr(SQLERRM, 12, 512));
926: icx_util.error_page_print;
927:
928: END copy_req;
929:
930: END icx_req_copy_req;