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_TEMPLATES dependencies on HTP

Line 13: htp.htmlOpen;

9: procedure createDummyPage(p_where number, nodeId varchar2, nodeIndex varchar2, v_string long,v_first_time_flag varchar2) is
10: ------------------------------------------------------------
11: begin
12: -- open html
13: htp.htmlOpen;
14: htp.headOpen;
15: htp.headClose;
16:
17: if (v_first_time_flag = 'Y') then

Line 14: htp.headOpen;

10: ------------------------------------------------------------
11: begin
12: -- open html
13: htp.htmlOpen;
14: htp.headOpen;
15: htp.headClose;
16:
17: if (v_first_time_flag = 'Y') then
18: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.openTemplate(''' || icx_util.replace_quotes(nodeId) ||''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

Line 15: htp.headClose;

11: begin
12: -- open html
13: htp.htmlOpen;
14: htp.headOpen;
15: htp.headClose;
16:
17: if (v_first_time_flag = 'Y') then
18: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.openTemplate(''' || icx_util.replace_quotes(nodeId) ||''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
19: else

Line 18: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.openTemplate(''' || icx_util.replace_quotes(nodeId) ||''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

14: htp.headOpen;
15: htp.headClose;
16:
17: if (v_first_time_flag = 'Y') then
18: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.openTemplate(''' || icx_util.replace_quotes(nodeId) ||''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
19: else
20: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
21: end if;
22:

Line 20: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

16:
17: if (v_first_time_flag = 'Y') then
18: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.openTemplate(''' || icx_util.replace_quotes(nodeId) ||''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
19: else
20: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
21: end if;
22:
23: htp.formOpen(curl =>'ICX_REQ_TEMPLATES.GetTemplateChildren',
24: cmethod => 'POST',

Line 23: htp.formOpen(curl =>'ICX_REQ_TEMPLATES.GetTemplateChildren',

19: else
20: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
21: end if;
22:
23: htp.formOpen(curl =>'ICX_REQ_TEMPLATES.GetTemplateChildren',
24: cmethod => 'POST',
25: cattributes => 'name=''GetChildren'''
26: );
27:

Line 28: htp.formHidden('nodeId', cvalue => v_string);

24: cmethod => 'POST',
25: cattributes => 'name=''GetChildren'''
26: );
27:
28: htp.formHidden('nodeId', cvalue => v_string);
29: htp.formHidden('p_where', cvalue => p_where);
30: htp.formHidden('nodeIndex', cvalue => nodeIndex);
31:
32: htp.formClose;

Line 29: htp.formHidden('p_where', cvalue => p_where);

25: cattributes => 'name=''GetChildren'''
26: );
27:
28: htp.formHidden('nodeId', cvalue => v_string);
29: htp.formHidden('p_where', cvalue => p_where);
30: htp.formHidden('nodeIndex', cvalue => nodeIndex);
31:
32: htp.formClose;
33:

Line 30: htp.formHidden('nodeIndex', cvalue => nodeIndex);

26: );
27:
28: htp.formHidden('nodeId', cvalue => v_string);
29: htp.formHidden('p_where', cvalue => p_where);
30: htp.formHidden('nodeIndex', cvalue => nodeIndex);
31:
32: htp.formClose;
33:
34:

Line 32: htp.formClose;

28: htp.formHidden('nodeId', cvalue => v_string);
29: htp.formHidden('p_where', cvalue => p_where);
30: htp.formHidden('nodeIndex', cvalue => nodeIndex);
31:
32: htp.formClose;
33:
34:
35: htp.bodyClose;
36: htp.htmlClose;

Line 35: htp.bodyClose;

31:
32: htp.formClose;
33:
34:
35: htp.bodyClose;
36: htp.htmlClose;
37:
38: end createDummyPage;
39:

Line 36: htp.htmlClose;

32: htp.formClose;
33:
34:
35: htp.bodyClose;
36: htp.htmlClose;
37:
38: end createDummyPage;
39:
40:

Line 146: htp.comment(where_clause);

142: where_clause_binds(v_index).value := 'OPTIONAL';
143: v_index := v_index + 1;
144: end if;
145:
146: htp.comment(where_clause);
147:
148: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
149: P_PARENT_REGION_CODE => 'ICX_RELATED_TEMPLATES_DISPLAY',
150: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

Line 166: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');

162:
163:
164:
165: if ak_query_pkg.g_results_table.count > 0 then
166: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
167: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
168:
169: /* desmond */
170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id

Line 195: htp.p('TOP_TEMPLATES[' || counter || ']= new node("' || v_node_id || '","' ||

191: else
192: v_children_loaded := 'true';
193: end if;
194:
195: htp.p('TOP_TEMPLATES[' || counter || ']= new node("' || v_node_id || '","' ||
196: v_name || '",' || v_children_loaded || ',"' ||
197: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
198: || '","' || p_where || '");');
199: counter := counter + 1;

Line 226: htp.comment(where_clause);

222: v_index := v_index + 1;
223:
224: end if;
225:
226: htp.comment(where_clause);
227:
228: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
229: P_PARENT_REGION_CODE => 'ICX_REQ_TEMPLATES',
230: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

Line 238: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');

234: P_RETURN_CHILDREN => 'F',
235: P_WHERE_BINDS => where_clause_binds);
236:
237: if ak_query_pkg.g_results_table.count > 0 then
238: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
239: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
240:
241:
242: v_node_id := ak_query_pkg.g_results_table(i).value1; -- template id

Line 254: htp.p('TOP_TEMPLATES[' || counter || ']= new node("' || v_node_id || '","' ||

250:
251: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '**]');
252:
253: v_children_loaded := 'true';
254: htp.p('TOP_TEMPLATES[' || counter || ']= new node("' || v_node_id || '","' ||
255: v_name || '",' || v_children_loaded || ',"' ||
256: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
257: || '","' || p_where || '");');
258: counter := counter + 1;

Line 265: -- htp.p('TOP_TEMPLATES = new MakeArray(1);');

261:
262:
263: else -- No TEmplates
264: -- if v_default_template is not NULL then
265: -- htp.p('TOP_TEMPLATES = new MakeArray(1);');
266: -- else
267: htp.p('TOP_TEMPLATES = new MakeArray(0);');
268: -- end if;
269: end if;

Line 267: htp.p('TOP_TEMPLATES = new MakeArray(0);');

263: else -- No TEmplates
264: -- if v_default_template is not NULL then
265: -- htp.p('TOP_TEMPLATES = new MakeArray(1);');
266: -- else
267: htp.p('TOP_TEMPLATES = new MakeArray(0);');
268: -- end if;
269: end if;
270:
271: end if; -- No hierchy setup

Line 292: htp.p('new_TOP_TEMPLATES = new MakeArray(' || counter || ');');

288: else
289: v_children_loaded := 'true';
290: end if;
291:
292: htp.p('new_TOP_TEMPLATES = new MakeArray(' || counter || ');');
293: htp.p('for (var i = 1; i <= ' || to_char(counter - 1) || '; i ++) {'
294: || 'new_TOP_TEMPLATES[i] = TOP_TEMPLATES[i]; }');
295: htp.p('new_TOP_TEMPLATES[' || counter || ']= new node("' || v_default_template || '","' ||
296: v_default_template || '",' || v_children_loaded || ',"' ||

Line 293: htp.p('for (var i = 1; i <= ' || to_char(counter - 1) || '; i ++) {'

289: v_children_loaded := 'true';
290: end if;
291:
292: htp.p('new_TOP_TEMPLATES = new MakeArray(' || counter || ');');
293: htp.p('for (var i = 1; i <= ' || to_char(counter - 1) || '; i ++) {'
294: || 'new_TOP_TEMPLATES[i] = TOP_TEMPLATES[i]; }');
295: htp.p('new_TOP_TEMPLATES[' || counter || ']= new node("' || v_default_template || '","' ||
296: v_default_template || '",' || v_children_loaded || ',"' ||
297: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link

Line 295: htp.p('new_TOP_TEMPLATES[' || counter || ']= new node("' || v_default_template || '","' ||

291:
292: htp.p('new_TOP_TEMPLATES = new MakeArray(' || counter || ');');
293: htp.p('for (var i = 1; i <= ' || to_char(counter - 1) || '; i ++) {'
294: || 'new_TOP_TEMPLATES[i] = TOP_TEMPLATES[i]; }');
295: htp.p('new_TOP_TEMPLATES[' || counter || ']= new node("' || v_default_template || '","' ||
296: v_default_template || '",' || v_children_loaded || ',"' ||
297: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
298: || '","' || p_where || '");');
299: htp.p('TOP_TEMPLATES = new MakeArray(' || counter || ');');

Line 299: htp.p('TOP_TEMPLATES = new MakeArray(' || counter || ');');

295: htp.p('new_TOP_TEMPLATES[' || counter || ']= new node("' || v_default_template || '","' ||
296: v_default_template || '",' || v_children_loaded || ',"' ||
297: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
298: || '","' || p_where || '");');
299: htp.p('TOP_TEMPLATES = new MakeArray(' || counter || ');');
300: htp.p('for (var i = 1; i <= ' || to_char(counter) || '; i ++) {'
301: || 'TOP_TEMPLATES[i] = new_TOP_TEMPLATES[i];}');
302:
303: end if;

Line 300: htp.p('for (var i = 1; i <= ' || to_char(counter) || '; i ++) {'

296: v_default_template || '",' || v_children_loaded || ',"' ||
297: v_dcdName || '/ICX_REQ_TEMPLATES.template_items?p_where=' || p_where -- Node Link
298: || '","' || p_where || '");');
299: htp.p('TOP_TEMPLATES = new MakeArray(' || counter || ');');
300: htp.p('for (var i = 1; i <= ' || to_char(counter) || '; i ++) {'
301: || 'TOP_TEMPLATES[i] = new_TOP_TEMPLATES[i];}');
302:
303: end if;
304:

Line 330: htp.htmlOpen;

326:
327: --get dcd name
328: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
329:
330: htp.htmlOpen;
331: htp.headOpen;
332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');

Line 331: htp.headOpen;

327: --get dcd name
328: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
329:
330: htp.htmlOpen;
331: htp.headOpen;
332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');
335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');

Line 332: htp.headClose;

328: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
329:
330: htp.htmlOpen;
331: htp.headOpen;
332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');
335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');
336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL

Line 333: htp.framesetOpen('','250,*','BORDER=5');

329:
330: htp.htmlOpen;
331: htp.headOpen;
332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');
335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');
336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL
337: cname => 'dummy', --Window Name

Line 334: htp.framesetOpen('*,0','','BORDER=0');

330: htp.htmlOpen;
331: htp.headOpen;
332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');
335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');
336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL
337: cname => 'dummy', --Window Name
338: cmarginwidth => '0', -- Value in pixels

Line 335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');

331: htp.headOpen;
332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');
335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');
336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL
337: cname => 'dummy', --Window Name
338: cmarginwidth => '0', -- Value in pixels
339: cmarginheight => '0', -- Value in pixels

Line 336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL

332: htp.headClose;
333: htp.framesetOpen('','250,*','BORDER=5');
334: htp.framesetOpen('*,0','','BORDER=0');
335: htp.frame('/OA_HTML/' || v_lang || '/ICXTEMH.htm', 'left_frame', '0','0', cscrolling=>'auto',cnoresize => '');
336: htp.frame(csrc => v_dcdName || '/ICX_REQ_TEMPLATES.GetTemplateChildren?p_where=' || p_where, -- URL
337: cname => 'dummy', --Window Name
338: cmarginwidth => '0', -- Value in pixels
339: cmarginheight => '0', -- Value in pixels
340: -- cscrolling => 'NO',-- yes | no | auto

Line 342: htp.framesetClose;

338: cmarginwidth => '0', -- Value in pixels
339: cmarginheight => '0', -- Value in pixels
340: -- cscrolling => 'NO',-- yes | no | auto
341: cattributes => 'FRAMEBORDER=NO');
342: htp.framesetClose;
343:
344: v_frame_location := v_dcdName || '/ICX_REQ_TEMPLATES.template_items?';
345:
346: if c_end_row is not null then

Line 351: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');

347: v_frame_location := v_frame_location || 'p_start_row=' || start_row ||'&p_end_row=' || c_end_row || '&p_where=' || p_where;
348: else
349: v_frame_location := v_frame_location || 'p_where=' || p_where;
350: end if;
351: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');
352: htp.framesetClose;
353: htp.htmlClose;
354:
355:

Line 352: htp.framesetClose;

348: else
349: v_frame_location := v_frame_location || 'p_where=' || p_where;
350: end if;
351: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');
352: htp.framesetClose;
353: htp.htmlClose;
354:
355:
356: end templates;

Line 353: htp.htmlClose;

349: v_frame_location := v_frame_location || 'p_where=' || p_where;
350: end if;
351: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');
352: htp.framesetClose;
353: htp.htmlClose;
354:
355:
356: end templates;
357:

Line 623: htp.p('function openButWin(start_row, end_row, total_row, where) {

619:
620: -- We need to split into 2 frames
621:
622: js.scriptOpen;
623: htp.p('function openButWin(start_row, end_row, total_row, where) {
624:
625: var result = "' || v_dcdName ||
626: '/ICX_REQ_TEMPLATES.template_items_buttons?p_start_row=" +
627: start_row + "&p_end_row=" + end_row + "&p_total_rows=" +

Line 634: htp.p('');

630: }
631: ');
632:
633: js.scriptClose;
634: htp.p('');
635: htp.p('

631: ');
632:
633: js.scriptClose;
634: htp.p('');
635: htp.p('');

Line 641: htp.p('');
640:
641: htp.p('');
644:
645: htp.p('');

Line 645: htp.p('');

641: htp.p('');
644:
645: htp.p('');
646:
647: end;
648:
649: ------------------------------------------------------------

Line 666: htp.p('');

662:
663: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
664:
665: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
666: htp.p('');
667:
668: htp.p('');
669: htp.p('
');
670: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,

Line 668: htp.p('');
664:
665: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
666: htp.p('');
667:
668: htp.p('

');
669: htp.p('
');
670: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
671: p_packproc => 'ICX_REQ_TEMPLATES.template_items',
672: p_start_row => p_start_row,

Line 669: htp.p('
');

665: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
666: htp.p('');
667:
668: htp.p('');
669: htp.p('');

674: p_encrypted_where => p_where,
675: p_query_set => c_query_size,
676: p_target => 'parent',
677: p_row_count => p_total_rows);
678: htp.p('');
679: htp.p('
');
679: htp.p('

');
670: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
671: p_packproc => 'ICX_REQ_TEMPLATES.template_items',
672: p_start_row => p_start_row,
673: p_stop_row => p_end_row,

Line 678: htp.p('
');
680: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
681: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
682: P_ImageFileName => 'FNDBNEW.gif',

Line 679: htp.p('
');

675: p_query_set => c_query_size,
676: p_target => 'parent',
677: p_row_count => p_total_rows);
678: htp.p('
');
680: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
681: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
682: P_ImageFileName => 'FNDBNEW.gif',
683: P_OnMouseOverText => FND_MESSAGE.GET,

Line 688: htp.p('
');

684: P_HyperTextCall => 'javascript:parent.frames[0].submit()',
685: P_LanguageCode => v_lang,
686: P_JavaScriptFlag => FALSE);
687:
688: htp.p('
');
689: htp.p('');
690:
691: end if;
692:

Line 689: htp.p('');

685: P_LanguageCode => v_lang,
686: P_JavaScriptFlag => FALSE);
687:
688: htp.p('
');
689: htp.p('');
690:
691: end if;
692:
693: end;

Line 781: htp.htmlOpen;

777:
778: -- If no template is selected then display a blank right frame
779:
780: IF (v_express_name is NULL or v_express_name = 'none') THEN
781: htp.htmlOpen;
782: htp.headOpen;
783: icx_util.copyright;
784: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
785: htp.bodyClose;

Line 782: htp.headOpen;

778: -- If no template is selected then display a blank right frame
779:
780: IF (v_express_name is NULL or v_express_name = 'none') THEN
781: htp.htmlOpen;
782: htp.headOpen;
783: icx_util.copyright;
784: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
785: htp.bodyClose;
786: htp.headClose;

Line 784: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');

780: IF (v_express_name is NULL or v_express_name = 'none') THEN
781: htp.htmlOpen;
782: htp.headOpen;
783: icx_util.copyright;
784: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
785: htp.bodyClose;
786: htp.headClose;
787: htp.htmlClose;
788: return;

Line 785: htp.bodyClose;

781: htp.htmlOpen;
782: htp.headOpen;
783: icx_util.copyright;
784: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
785: htp.bodyClose;
786: htp.headClose;
787: htp.htmlClose;
788: return;
789: END IF;

Line 786: htp.headClose;

782: htp.headOpen;
783: icx_util.copyright;
784: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
785: htp.bodyClose;
786: htp.headClose;
787: htp.htmlClose;
788: return;
789: END IF;
790:

Line 787: htp.htmlClose;

783: icx_util.copyright;
784: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
785: htp.bodyClose;
786: htp.headClose;
787: htp.htmlClose;
788: return;
789: END IF;
790:
791: ICX_REQ_NAVIGATION.get_currency(v_org, c_currency, c_money_precision,

Line 840: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');

836: END IF;
837:
838:
839: IF ak_query_pkg.g_results_table.COUNT = 0 then
840: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
841: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
842: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
843: htp.p('
' || fnd_message.get || '
');
844: htp.bodyClose;

Line 843: htp.p('
' || fnd_message.get || '
');

839: IF ak_query_pkg.g_results_table.COUNT = 0 then
840: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
841: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
842: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
843: htp.p('
' || fnd_message.get || '
');
844: htp.bodyClose;
845: return;
846: END IF;
847:

Line 844: htp.bodyClose;

840: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
841: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
842: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
843: htp.p('
' || fnd_message.get || '
');
844: htp.bodyClose;
845: return;
846: END IF;
847:
848: --- Display the template

Line 849: htp.htmlOpen;

845: return;
846: END IF;
847:
848: --- Display the template
849: htp.htmlOpen;
850: htp.headOpen;
851: icx_util.copyright;
852: js.scriptOpen;
853:

Line 850: htp.headOpen;

846: END IF;
847:
848: --- Display the template
849: htp.htmlOpen;
850: htp.headOpen;
851: icx_util.copyright;
852: js.scriptOpen;
853:
854: htp.p('function submit() {

Line 854: htp.p('function submit() {

850: htp.headOpen;
851: icx_util.copyright;
852: js.scriptOpen;
853:
854: htp.p('function submit() {
855: document.template_items.cartId.value = parent.parent.parent.cartId;
856: document.template_items.p_emergency.value = parent.parent.parent.emergency;
857: document.template_items.submit();
858: }');

Line 860: htp.p('function get_parent_values(cartId,emerg) {

856: document.template_items.p_emergency.value = parent.parent.parent.emergency;
857: document.template_items.submit();
858: }');
859:
860: htp.p('function get_parent_values(cartId,emerg) {
861: cartId.value = parent.parent.parent.cartId;
862: emerg.value = parent.parent.parent.emergency;
863: }');
864:

Line 866: htp.title(c_title);

862: emerg.value = parent.parent.parent.emergency;
863: }');
864:
865: js.scriptClose;
866: htp.title(c_title);
867: htp.headClose;
868:
869:
870: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template''); top.lastTemplate.start_row='|| p_start_row ||

Line 867: htp.headClose;

863: }');
864:
865: js.scriptClose;
866: htp.title(c_title);
867: htp.headClose;
868:
869:
870: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template''); top.lastTemplate.start_row='|| p_start_row ||
871: ';top.lastTemplate.end_row='|| end_row ||

Line 870: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template''); top.lastTemplate.start_row='|| p_start_row ||

866: htp.title(c_title);
867: htp.headClose;
868:
869:
870: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template''); top.lastTemplate.start_row='|| p_start_row ||
871: ';top.lastTemplate.end_row='|| end_row ||
872: ';parent.openButWin(' || p_start_row || ',' ||
873: end_row || ',' || total_rows || ',' || p_where || ')"');
874: htp.br;

Line 874: htp.br;

870: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template''); top.lastTemplate.start_row='|| p_start_row ||
871: ';top.lastTemplate.end_row='|| end_row ||
872: ';parent.openButWin(' || p_start_row || ',' ||
873: end_row || ',' || total_rows || ',' || p_where || ')"');
874: htp.br;
875:
876:
877:
878: htp.p('
');

Line 878: htp.p('');

874: htp.br;
875:
876:
877:
878: htp.p('');
879:
880: htp.formHidden('cartId','');
881: htp.formHidden('p_emergency','');
882: js.scriptOpen;

Line 880: htp.formHidden('cartId','');

876:
877:
878: htp.p('');
879:
880: htp.formHidden('cartId','');
881: htp.formHidden('p_emergency','');
882: js.scriptOpen;
883:
884: htp.p('get_parent_values(document.template_items.cartId,document.template_items.p_emergency);');

Line 881: htp.formHidden('p_emergency','');

877:
878: htp.p('');
879:
880: htp.formHidden('cartId','');
881: htp.formHidden('p_emergency','');
882: js.scriptOpen;
883:
884: htp.p('get_parent_values(document.template_items.cartId,document.template_items.p_emergency);');
885: js.scriptClose;

Line 884: htp.p('get_parent_values(document.template_items.cartId,document.template_items.p_emergency);');

880: htp.formHidden('cartId','');
881: htp.formHidden('p_emergency','');
882: js.scriptOpen;
883:
884: htp.p('get_parent_values(document.template_items.cartId,document.template_items.p_emergency);');
885: js.scriptClose;
886:
887:
888:

Line 889: htp.formHidden('p_start_row', p_start_row);

885: js.scriptClose;
886:
887:
888:
889: htp.formHidden('p_start_row', p_start_row);
890: htp.formHidden('p_end_row', p_end_row);
891: htp.formHidden('p_where', p_where);
892: /* expressName required to identify a cart line uniquely */
893: htp.formHidden('v_express_name', v_express_name);

Line 890: htp.formHidden('p_end_row', p_end_row);

886:
887:
888:
889: htp.formHidden('p_start_row', p_start_row);
890: htp.formHidden('p_end_row', p_end_row);
891: htp.formHidden('p_where', p_where);
892: /* expressName required to identify a cart line uniquely */
893: htp.formHidden('v_express_name', v_express_name);
894: -- htp.formHidden('p_emergency','');

Line 891: htp.formHidden('p_where', p_where);

887:
888:
889: htp.formHidden('p_start_row', p_start_row);
890: htp.formHidden('p_end_row', p_end_row);
891: htp.formHidden('p_where', p_where);
892: /* expressName required to identify a cart line uniquely */
893: htp.formHidden('v_express_name', v_express_name);
894: -- htp.formHidden('p_emergency','');
895: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');

Line 893: htp.formHidden('v_express_name', v_express_name);

889: htp.formHidden('p_start_row', p_start_row);
890: htp.formHidden('p_end_row', p_end_row);
891: htp.formHidden('p_where', p_where);
892: /* expressName required to identify a cart line uniquely */
893: htp.formHidden('v_express_name', v_express_name);
894: -- htp.formHidden('p_emergency','');
895: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
896: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
897: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');

Line 894: -- htp.formHidden('p_emergency','');

890: htp.formHidden('p_end_row', p_end_row);
891: htp.formHidden('p_where', p_where);
892: /* expressName required to identify a cart line uniquely */
893: htp.formHidden('v_express_name', v_express_name);
894: -- htp.formHidden('p_emergency','');
895: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
896: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
897: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
898:

Line 895: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');

891: htp.formHidden('p_where', p_where);
892: /* expressName required to identify a cart line uniquely */
893: htp.formHidden('v_express_name', v_express_name);
894: -- htp.formHidden('p_emergency','');
895: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
896: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
897: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
898:
899:

Line 896: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');

892: /* expressName required to identify a cart line uniquely */
893: htp.formHidden('v_express_name', v_express_name);
894: -- htp.formHidden('p_emergency','');
895: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
896: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
897: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
898:
899:
900: l_pos := l_pos + 9;

Line 897: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');

893: htp.formHidden('v_express_name', v_express_name);
894: -- htp.formHidden('p_emergency','');
895: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
896: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
897: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
898:
899:
900: l_pos := l_pos + 9;
901:

Line 903: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_

899:
900: l_pos := l_pos + 9;
901:
902: -- Print the table column headings
903: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_
904: DATA_MULTIROW') );
905:
906: htp.p('');
907:

Line 906: htp.p('');

902: -- Print the table column headings
903: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_
904: DATA_MULTIROW') );
905:
906: htp.p('');
907:
908: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL
910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'

Line 917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
914:
915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2
917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');
920: ELSE
921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');

Line 919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');

915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2
917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');
920: ELSE
921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');
922: END IF;
923: END IF;

Line 921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');

917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');
920: ELSE
921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');
922: END IF;
923: END IF;
924:
925: -- Find line id, urls value id

Line 947: htp.tableRowClose;

943:
944: END LOOP;
945:
946:
947: htp.tableRowClose;
948:
949: counter := 0;
950: -- Print the table data
951:

Line 1074: htp.p(temp_table);

1070: display_text := display_text || '';
1071: display_text := display_text || htf.tableRowClose;
1072: temp_table := temp_table || display_text;
1073:
1074: htp.p(temp_table);
1075:
1076: counter := counter + 1;
1077:
1078: END LOOP; -- for j in 1 .. g_results_table.COUNT loop

Line 1080: htp.tableClose;

1076: counter := counter + 1;
1077:
1078: END LOOP; -- for j in 1 .. g_results_table.COUNT loop
1079:
1080: htp.tableClose;
1081:
1082:
1083:
1084:

Line 1085: htp.p('');

1081:
1082:
1083:
1084:
1085: htp.p('');
1086: htp.bodyClose;
1087: htp.htmlClose;
1088:
1089: END IF; /* validate session */

Line 1086: htp.bodyClose;

1082:
1083:
1084:
1085: htp.p('');
1086: htp.bodyClose;
1087: htp.htmlClose;
1088:
1089: END IF; /* validate session */
1090: EXCEPTION

Line 1087: htp.htmlClose;

1083:
1084:
1085: htp.p('');
1086: htp.bodyClose;
1087: htp.htmlClose;
1088:
1089: END IF; /* validate session */
1090: EXCEPTION
1091: WHEN OTHERS THEN

Line 1455: -- htp.p('Error in Submit Items.');

1451:
1452: EXCEPTION
1453:
1454: WHEN OTHERS THEN
1455: -- htp.p('Error in Submit Items.');
1456: -- htp.br;
1457: -- htp.p(substr(SQLERRM, 1, 512));
1458: -- htp.br;
1459: icx_util.add_error(substr(SQLERRM, 12, 512));

Line 1456: -- htp.br;

1452: EXCEPTION
1453:
1454: WHEN OTHERS THEN
1455: -- htp.p('Error in Submit Items.');
1456: -- htp.br;
1457: -- htp.p(substr(SQLERRM, 1, 512));
1458: -- htp.br;
1459: icx_util.add_error(substr(SQLERRM, 12, 512));
1460: icx_util.error_page_print;

Line 1457: -- htp.p(substr(SQLERRM, 1, 512));

1453:
1454: WHEN OTHERS THEN
1455: -- htp.p('Error in Submit Items.');
1456: -- htp.br;
1457: -- htp.p(substr(SQLERRM, 1, 512));
1458: -- htp.br;
1459: icx_util.add_error(substr(SQLERRM, 12, 512));
1460: icx_util.error_page_print;
1461:

Line 1458: -- htp.br;

1454: WHEN OTHERS THEN
1455: -- htp.p('Error in Submit Items.');
1456: -- htp.br;
1457: -- htp.p(substr(SQLERRM, 1, 512));
1458: -- htp.br;
1459: icx_util.add_error(substr(SQLERRM, 12, 512));
1460: icx_util.error_page_print;
1461:
1462: END submit_items;

Line 1543: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');

1539: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT');
1540: l_return_to_next_message := FND_MESSAGE.GET;
1541:
1542:
1543: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
1544:
1545: htp.p('
');
1546: htp.p(l_print_message);
1547: htp.br;

Line 1545: htp.p('
');

1541:
1542:
1543: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
1544:
1545: htp.p('
');
1546: htp.p(l_print_message);
1547: htp.br;
1548: htp.br; -- add line between update and total message
1549: htp.p(l_order_total_message);

Line 1546: htp.p(l_print_message);

1542:
1543: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
1544:
1545: htp.p('
');
1546: htp.p(l_print_message);
1547: htp.br;
1548: htp.br; -- add line between update and total message
1549: htp.p(l_order_total_message);
1550: htp.br;

Line 1547: htp.br;

1543: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
1544:
1545: htp.p('
');
1546: htp.p(l_print_message);
1547: htp.br;
1548: htp.br; -- add line between update and total message
1549: htp.p(l_order_total_message);
1550: htp.br;
1551: htp.br; -- leave two line between the messages

Line 1548: htp.br; -- add line between update and total message

1544:
1545: htp.p('
');
1546: htp.p(l_print_message);
1547: htp.br;
1548: htp.br; -- add line between update and total message
1549: htp.p(l_order_total_message);
1550: htp.br;
1551: htp.br; -- leave two line between the messages
1552: htp.br;

Line 1549: htp.p(l_order_total_message);

1545: htp.p('
');
1546: htp.p(l_print_message);
1547: htp.br;
1548: htp.br; -- add line between update and total message
1549: htp.p(l_order_total_message);
1550: htp.br;
1551: htp.br; -- leave two line between the messages
1552: htp.br;
1553: htp.p(l_template_selected_message);

Line 1550: htp.br;

1546: htp.p(l_print_message);
1547: htp.br;
1548: htp.br; -- add line between update and total message
1549: htp.p(l_order_total_message);
1550: htp.br;
1551: htp.br; -- leave two line between the messages
1552: htp.br;
1553: htp.p(l_template_selected_message);
1554: l_navigation_message := '';
Line 1552: htp.br;

1548: htp.br; -- add line between update and total message
1549: htp.p(l_order_total_message);
1550: htp.br;
1551: htp.br; -- leave two line between the messages
1552: htp.br;
1553: htp.p(l_template_selected_message);
1554: l_navigation_message := '

' || ' 1555: '/ICX_REQ_TEMPLATES.template_items?p_start_row=' || p_start_row || '&p_end_row=' || p_end_row || '&p_where=' || p_where || '">' || l_return_to_current_message || '

';
1556: /*
Line 1553: htp.p(l_template_selected_message);

1549: htp.p(l_order_total_message);
1550: htp.br;
1551: htp.br; -- leave two line between the messages
1552: htp.br;
1553: htp.p(l_template_selected_message);
1554: l_navigation_message := '

' || '' || l_return_to_current_message || '

';
1556: /*
1557: htp.p('
');

Line 1557: htp.p('
');

1553: htp.p(l_template_selected_message);
1554: l_navigation_message := '

' || '' || l_return_to_current_message || '
';
1556: /*
1557: htp.p('
');
1558: htp.p('
' || l_template_selected_message);
1559: htp.p('
');
1560: htp.p('
' || '' || l_return_to_current_message || '');
1561: htp.p('
');

Line 1558: htp.p('
' || l_template_selected_message);

1554: l_navigation_message := '

' || '' || l_return_to_current_message || '

';
1556: /*
1557: htp.p('
');
1558: htp.p('
' || l_template_selected_message);
1559: htp.p('
');
1560: htp.p('
' || '' || l_return_to_current_message || '');
1561: htp.p('
');
1562: */

Line 1559: htp.p('
');

1555: '/ICX_REQ_TEMPLATES.template_items?p_start_row=' || p_start_row || '&p_end_row=' || p_end_row || '&p_where=' || p_where || '">' || l_return_to_current_message || '';
1556: /*
1557: htp.p('
');
1558: htp.p('
' || l_template_selected_message);
1559: htp.p('
');
1560: htp.p('
' || '' || l_return_to_current_message || '');
1561: htp.p('
');
1562: */
1563:

Line 1560: htp.p('
' || '' || l_return_to_current_message || '');

1556: /*
1557: htp.p('
');
1558: htp.p('
' || l_template_selected_message);
1559: htp.p('
');
1560: htp.p('
' || '' || l_return_to_current_message || '');
1561: htp.p('
');
1562: */
1563:
1564: /* find next set start row and next set end row */

Line 1561: htp.p('
');

1557: htp.p('
');
1558: htp.p('
' || l_template_selected_message);
1559: htp.p('
');
1560: htp.p('
' || '' || l_return_to_current_message || '');
1561: htp.p('
');
1562: */
1563:
1564: /* find next set start row and next set end row */
1565: if end_row < p_row_count

Line 1579: htp.p('
');

1575: '/ICX_REQ_TEMPLATES.template_items?p_start_row=' || next_start_row || '&p_end_row=' || next_end_row || '&p_where=' || p_where || '">' || l_return_to_next_message || '';
1576:
1577:
1578: /*
1579: htp.p('
');
1580: htp.p('
' || '' || l_return_to_next_message || '');
1581:
1582: -- htp.p('
' || l_return_to_next_message);
1583: htp.p('
');

Line 1580: htp.p('
' || '' || l_return_to_next_message || '');

1576:
1577:
1578: /*
1579: htp.p('
');
1580: htp.p('
' || '' || l_return_to_next_message || '');
1581:
1582: -- htp.p('
' || l_return_to_next_message);
1583: htp.p('
');
1584: */

Line 1582: -- htp.p('
' || l_return_to_next_message);

1578: /*
1579: htp.p('
');
1580: htp.p('
' || '' || l_return_to_next_message || '');
1581:
1582: -- htp.p('
' || l_return_to_next_message);
1583: htp.p('
');
1584: */
1585:
1586: end if;

Line 1583: htp.p('
');

1579: htp.p('
');
1580: htp.p('
' || '' || l_return_to_next_message || '');
1581:
1582: -- htp.p('
' || l_return_to_next_message);
1583: htp.p('
');
1584: */
1585:
1586: end if;
1587:

Line 1597: -- htp.p('
');

1593:
1594: l_navigation_message := l_navigation_message || '

' || '' || l_return_to_current_message || '
';
1595:
1596:
1597: -- htp.p('');
1598: htp.p(l_navigation_message);
1599: htp.p('');
1600:
1601: htp.bodyClose;

Line 1598: htp.p(l_navigation_message);

1594: l_navigation_message := l_navigation_message || '';
1595:
1596:
1597: -- htp.p('');
1598: htp.p(l_navigation_message);
1599: htp.p('');
1600:
1601: htp.bodyClose;
1602:

Line 1599: htp.p('
');

1595:
1596:
1597: -- htp.p('');
1598: htp.p(l_navigation_message);
1599: htp.p('');
1600:
1601: htp.bodyClose;
1602:
1603:

Line 1601: htp.bodyClose;

1597: -- htp.p('');
1598: htp.p(l_navigation_message);
1599: htp.p('');
1600:
1601: htp.bodyClose;
1602:
1603:
1604: EXCEPTION
1605:

Line 1607: -- htp.p('Error in Total print message page.');

1603:
1604: EXCEPTION
1605:
1606: WHEN OTHERS THEN
1607: -- htp.p('Error in Total print message page.');
1608: -- htp.br;
1609: -- htp.p(substr(SQLERRM, 1, 512));
1610: -- htp.br;
1611: icx_util.add_error(substr(SQLERRM, 12, 512));

Line 1608: -- htp.br;

1604: EXCEPTION
1605:
1606: WHEN OTHERS THEN
1607: -- htp.p('Error in Total print message page.');
1608: -- htp.br;
1609: -- htp.p(substr(SQLERRM, 1, 512));
1610: -- htp.br;
1611: icx_util.add_error(substr(SQLERRM, 12, 512));
1612: icx_util.error_page_print;

Line 1609: -- htp.p(substr(SQLERRM, 1, 512));

1605:
1606: WHEN OTHERS THEN
1607: -- htp.p('Error in Total print message page.');
1608: -- htp.br;
1609: -- htp.p(substr(SQLERRM, 1, 512));
1610: -- htp.br;
1611: icx_util.add_error(substr(SQLERRM, 12, 512));
1612: icx_util.error_page_print;
1613: END total_page;

Line 1610: -- htp.br;

1606: WHEN OTHERS THEN
1607: -- htp.p('Error in Total print message page.');
1608: -- htp.br;
1609: -- htp.p(substr(SQLERRM, 1, 512));
1610: -- htp.br;
1611: icx_util.add_error(substr(SQLERRM, 12, 512));
1612: icx_util.error_page_print;
1613: END total_page;
1614: