DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT_DIST dependencies on HTP

Line 48: -- htp.p('Error in display acct distributions ' || substr(SQLERRM, 1, 512));

44: null;
45:
46: EXCEPTION
47: WHEN OTHERS THEN
48: -- htp.p('Error in display acct distributions ' || substr(SQLERRM, 1, 512));
49: icx_util.add_error(substr(SQLERRM, 12, 512));
50:
51: END get_default_account;
52:

Line 189: htp.htmlOpen;

185: -- v_encrypted_where := p_where;
186:
187: v_where_clause := 'CART_ID =' || v_cart_id || 'AND CART_LINE_ID =' || v_cart_line_id;
188:
189: htp.htmlOpen;
190: htp.headOpen;
191: icx_util.copyright;
192: js.scriptOpen;
193:

Line 190: htp.headOpen;

186:
187: v_where_clause := 'CART_ID =' || v_cart_id || 'AND CART_LINE_ID =' || v_cart_line_id;
188:
189: htp.htmlOpen;
190: htp.headOpen;
191: icx_util.copyright;
192: js.scriptOpen;
193:
194: htp.p('function submit() {

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

190: htp.headOpen;
191: icx_util.copyright;
192: js.scriptOpen;
193:
194: htp.p('function submit() {
195: // document.ACCOUNT_DISTRIBUTION.cart_id.value = parent.parent.cartId;
196: // parent.frames[0].document.ACCOUNT_DISTRIBUTION.submit();
197: document.ACCOUNT_DISTRIBUTION.p_user_action.value ="APPLY";
198: document.ACCOUNT_DISTRIBUTION.submit();

Line 201: htp.p('function apply_to_all() {

197: document.ACCOUNT_DISTRIBUTION.p_user_action.value ="APPLY";
198: document.ACCOUNT_DISTRIBUTION.submit();
199: }');
200:
201: htp.p('function apply_to_all() {
202: document.ACCOUNT_DISTRIBUTION.p_user_action.value ="APPLY_TO_ALL";
203: // parent.frames[0].document.ACCOUNT_DISTRIBUTION.submit();
204: document.ACCOUNT_DISTRIBUTION.submit();
205: }');

Line 207: htp.p('function show_more_lines() {

203: // parent.frames[0].document.ACCOUNT_DISTRIBUTION.submit();
204: document.ACCOUNT_DISTRIBUTION.submit();
205: }');
206:
207: htp.p('function show_more_lines() {
208: document.ACCOUNT_DISTRIBUTION.p_user_action.value ="MORE_LINES";
209: // parent.frames[0].document.ACCOUNT_DISTRIBUTION.submit();
210: document.ACCOUNT_DISTRIBUTION.submit();
211: }');

Line 213: htp.p('function cancel_account() {

209: // parent.frames[0].document.ACCOUNT_DISTRIBUTION.submit();
210: document.ACCOUNT_DISTRIBUTION.submit();
211: }');
212:
213: htp.p('function cancel_account() {
214: document.ACCOUNT_DISTRIBUTION.p_user_action.value ="CANCEL";
215: parent.parent.account_dist="";
216: top.switchFrames("my_order");
217: }');

Line 220: htp.p('function checkNumber(input) {

216: top.switchFrames("my_order");
217: }');
218:
219: fnd_message.set_name('ICX','ICX_NOT_NUMBER');
220: htp.p('function checkNumber(input) {
221: var msg = input.value + " '||icx_util.replace_quotes(fnd_message.get)||'";
222:
223: var str = input.value;
224: for (var i = 0; i < str.length; i++) {

Line 236: -- htp.p('function roundDecimals (input, roundDigits) {

232: }
233: ');
234:
235: -- Round the decimal part to 'roundDigits' digits
236: -- htp.p('function roundDecimals (input, roundDigits) {
237: -- var integerPart = input.value;
238: -- var decimalPart;
239: -- var tempVal;
240: -- integerPart = Math.floor(integerPart);

Line 256: -- htp.p('function roundDecimalsValue (input, roundDigits) {

252:
253: -- }
254: -- ');
255: -- Round the decimal part to 'roundDigits' digits
256: -- htp.p('function roundDecimalsValue (input, roundDigits) {
257: -- var integerPart = input;
258: -- var decimalPart;
259: -- var tempVal;
260: -- integerPart = Math.floor(integerPart);

Line 287: htp.p('

283: -- also changed roundDecimals and roundDecimalsValue s.t b/c it
284: -- was bahaving strangely in some cases.
285:
286: --added for bug # 700664:
287: htp.p('
288: function roundDecimals (input, roundDigits)
289: {
290: var tmp= roundDecimalsValue(input.value, roundDigits);
291: input.value= tmp;

Line 296: htp.p('

292: }
293: ');
294:
295: --added for bug # 700664:
296: htp.p('
297: function roundDecimalsValue (input, roundDigits) {
298: var str= "" + Math.round(eval(input) * Math.pow(10, roundDigits));
299: while (str.length <= roundDigits)
300: {

Line 308: htp.p('function get_forward_pos(start_pos) {

304: return str.substring(0, decpoint) + "." + str.substring(decpoint, str.length);
305: }');
306:
307:
308: htp.p('function get_forward_pos(start_pos) {
309: var end_pos=0;
310: if (document.ACCOUNT_DISTRIBUTION.elements[start_pos].name == "ICX_AMOUNT") {
311: var name2 = "ICX_PERCENTAGE";
312: } else {

Line 332: htp.p('function get_backward_pos(start_pos) {

328: }
329: }
330: }');
331:
332: htp.p('function get_backward_pos(start_pos) {
333: var end_pos=0;
334: if (document.ACCOUNT_DISTRIBUTION.elements[start_pos].name == "ICX_AMOUNT") {
335: var name1 = "ICX_PERCENTAGE";
336: } else {

Line 355: htp.p('function set_percent(pos,qty,value1,direction) {

351:
352: }');
353:
354:
355: htp.p('function set_percent(pos,qty,value1,direction) {
356: if(direction == 0) {
357: var npos = get_forward_pos(pos);
358: } else {
359: var npos = get_backward_pos(pos);

Line 378: htp.p('function set_amount(pos,per,extended,direction) {

374:
375: }
376: }');
377:
378: htp.p('function set_amount(pos,per,extended,direction) {
379: if(direction == 0) {
380: var npos = get_forward_pos(pos);
381: } else {
382: var npos = get_backward_pos(pos);

Line 402: htp.p('function get_total_amount()

398:
399: }
400: }');
401:
402: htp.p('function get_total_amount()
403: {
404: var amt=0;
405: for(var i=0;
406: i

Line 417: htp.p('function get_total_percent()

413: }
414: return amt;
415: }');
416:
417: htp.p('function get_total_percent()
418: {
419: var pct=0;
420: for(var i=0;
421: i

Line 433: htp.title(v_title);

429: return pct;
430: } ');
431:
432: js.scriptClose;
433: htp.title(v_title);
434: htp.headClose;
435:
436: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="top.winOpen(''nav'', ''my_order'')"');
437:

Line 434: htp.headClose;

430: } ');
431:
432: js.scriptClose;
433: htp.title(v_title);
434: htp.headClose;
435:
436: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="top.winOpen(''nav'', ''my_order'')"');
437:
438: htp.header(3, v_title);

Line 436: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="top.winOpen(''nav'', ''my_order'')"');

432: js.scriptClose;
433: htp.title(v_title);
434: htp.headClose;
435:
436: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="top.winOpen(''nav'', ''my_order'')"');
437:
438: htp.header(3, v_title);
439:
440: htp.p('

');

Line 438: htp.header(3, v_title);

434: htp.headClose;
435:
436: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="top.winOpen(''nav'', ''my_order'')"');
437:
438: htp.header(3, v_title);
439:
440: htp.p('');
441:
442: htp.formHidden('p_cart_id', p_cart_id);

Line 440: htp.p('');

436: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="top.winOpen(''nav'', ''my_order'')"');
437:
438: htp.header(3, v_title);
439:
440: htp.p('');
441:
442: htp.formHidden('p_cart_id', p_cart_id);
443: htp.formHidden('p_cart_line_id', icx_call.encrypt2(p_cart_line_id));
444: htp.formHidden('p_user_action', '');

Line 442: htp.formHidden('p_cart_id', p_cart_id);

438: htp.header(3, v_title);
439:
440: htp.p('');
441:
442: htp.formHidden('p_cart_id', p_cart_id);
443: htp.formHidden('p_cart_line_id', icx_call.encrypt2(p_cart_line_id));
444: htp.formHidden('p_user_action', '');
445:
446: l_pos := l_pos + 3;

Line 443: htp.formHidden('p_cart_line_id', icx_call.encrypt2(p_cart_line_id));

439:
440: htp.p('');
441:
442: htp.formHidden('p_cart_id', p_cart_id);
443: htp.formHidden('p_cart_line_id', icx_call.encrypt2(p_cart_line_id));
444: htp.formHidden('p_user_action', '');
445:
446: l_pos := l_pos + 3;
447:

Line 444: htp.formHidden('p_user_action', '');

440: htp.p('');
441:
442: htp.formHidden('p_cart_id', p_cart_id);
443: htp.formHidden('p_cart_line_id', icx_call.encrypt2(p_cart_line_id));
444: htp.formHidden('p_user_action', '');
445:
446: l_pos := l_pos + 3;
447:
448: -- call error display procedure

Line 454: htp.p(htf.bold(FND_MESSAGE.GET));

450:
451: IF v_error_text IS NOT NULL THEN
452: /* Changed to new font, to be in consistent with other errors
453: FND_MESSAGE.SET_NAME('ICX','ICX_ERROR');
454: htp.p(htf.bold(FND_MESSAGE.GET));
455: htp.br;
456: htp.p(htf.bold(v_error_text));
457: htp.br;
458: htp.br;

Line 455: htp.br;

451: IF v_error_text IS NOT NULL THEN
452: /* Changed to new font, to be in consistent with other errors
453: FND_MESSAGE.SET_NAME('ICX','ICX_ERROR');
454: htp.p(htf.bold(FND_MESSAGE.GET));
455: htp.br;
456: htp.p(htf.bold(v_error_text));
457: htp.br;
458: htp.br;
459: */

Line 456: htp.p(htf.bold(v_error_text));

452: /* Changed to new font, to be in consistent with other errors
453: FND_MESSAGE.SET_NAME('ICX','ICX_ERROR');
454: htp.p(htf.bold(FND_MESSAGE.GET));
455: htp.br;
456: htp.p(htf.bold(v_error_text));
457: htp.br;
458: htp.br;
459: */
460: htp.p('');

Line 457: htp.br;

453: FND_MESSAGE.SET_NAME('ICX','ICX_ERROR');
454: htp.p(htf.bold(FND_MESSAGE.GET));
455: htp.br;
456: htp.p(htf.bold(v_error_text));
457: htp.br;
458: htp.br;
459: */
460: htp.p('

');
461: htp.p('');

Line 458: htp.br;

454: htp.p(htf.bold(FND_MESSAGE.GET));
455: htp.br;
456: htp.p(htf.bold(v_error_text));
457: htp.br;
458: htp.br;
459: */
460: htp.p('

' || v_error_text || '
');
461: htp.p('');
462: htp.p('
' || v_error_text || '
');

Line 460: htp.p('');

456: htp.p(htf.bold(v_error_text));
457: htp.br;
458: htp.br;
459: */
460: htp.p('

');
461: htp.p('');
462: htp.p('
' || v_error_text || '
');
463: htp.br;
464: END IF; /* IF v_error_text */

Line 461: htp.p('' || v_error_text || '');

457: htp.br;
458: htp.br;
459: */
460: htp.p('');
461: htp.p('');
462: htp.p('
' || v_error_text || '
');
463: htp.br;
464: END IF; /* IF v_error_text */
465:

Line 462: htp.p('');

458: htp.br;
459: */
460: htp.p('');
461: htp.p('');
462: htp.p('
' || v_error_text || '
');
463: htp.br;
464: END IF; /* IF v_error_text */
465:
466: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

Line 463: htp.br;

459: */
460: htp.p('');
461: htp.p('');
462: htp.p('
' || v_error_text || '
');
463: htp.br;
464: END IF; /* IF v_error_text */
465:
466: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
467: P_PARENT_REGION_CODE => v_distribution_header_region,

Line 523: htp.p('');

519: END IF; /* IF v_error_text */
520:
521: FOR r IN 1 .. v_display_lines LOOP
522:
523: htp.p('');
524:
525: FOR i IN 0 .. ak_query_pkg.g_items_table.LAST LOOP
526: -- FOR i IN 1 .. ak_query_pkg.g_items_table.LAST LOOP
527:

Line 543: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

539: -- distribution count will be 5.
540: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_ID' AND (icx_distribution_id.COUNT >= r) THEN
541:
542: v_value := icx_distribution_id(r);
543: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
544: l_pos := l_pos + 1;
545:
546: END IF; /* ICX_DISTRIBUTION_ID */
547: END IF; /* item_style = 'HIDDEN' */

Line 672: htp.tableData(cvalue => '', crowspan => 1);
674: ELSE
675: htp.tableData(cvalue => '', crowspan => 1);

Line 675: htp.tableData(cvalue => '', crowspan => 1);
674: ELSE
675: htp.tableData(cvalue => '', crowspan => 1);
677: END IF;
678:
679: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN

Line 681: htp.tableData(cvalue => '', crowspan => 1);
683: ELSE
684: htp.tableData(cvalue => '', crowspan => 1);

Line 684: htp.tableData(cvalue => '', crowspan => 1);
683: ELSE
684: htp.tableData(cvalue => '', crowspan => 1);
686: END IF;
687: ELSE
688: htp.tableData(cvalue => '', crowspan => 1);
686: END IF;
687: ELSE
688: htp.tableData(cvalue => '', crowspan => 1);
690: END IF;
691:
692: l_pos := l_pos + 1;

Line 760: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

756: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCOUNT_NUM' THEN
757: v_value := v_charge_account_num;
758: END IF; /* ak.. attribute_code = 'ICX_...' */
759:
760: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
761: l_pos := l_pos + 1;
762:
763: IF v_value IS NULL THEN
764: htp.tableData(cvalue => ' ', crowspan => 1);

Line 764: htp.tableData(cvalue => ' ', crowspan => 1);

760: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
761: l_pos := l_pos + 1;
762:
763: IF v_value IS NULL THEN
764: htp.tableData(cvalue => ' ', crowspan => 1);
765: ELSE
766: htp.tableData(cvalue => v_value, crowspan => 1);
767: END IF; /* IF v_value */
768:

Line 766: htp.tableData(cvalue => v_value, crowspan => 1);

762:
763: IF v_value IS NULL THEN
764: htp.tableData(cvalue => ' ', crowspan => 1);
765: ELSE
766: htp.tableData(cvalue => v_value, crowspan => 1);
767: END IF; /* IF v_value */
768:
769: END IF; /* update_flag = 'Y' */
770:

Line 775: htp.tableRowClose;

771: END IF; /* node_display_flag = 'Y' */
772:
773: END LOOP; /* FOR i in items_table */
774:
775: htp.tableRowClose;
776:
777: END LOOP; /* FOR 1 .. v_display_lines */
778:
779: ELSE

Line 823: htp.p('');

819: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
820:
821: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
822:
823: htp.p('');
824:
825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
826:
827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));

827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
828: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
829: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
830:
831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
832: l_pos := l_pos + 1;
833: END IF;
834:
835: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 856: htp.tableData(cvalue => '', crowspan => 1);
858: else
859: htp.tableData(cvalue => '', crowspan => 1);

Line 859: htp.tableData(cvalue => '', crowspan => 1);
858: else
859: htp.tableData(cvalue => '', crowspan => 1);
861: end if;
862: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then
863: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then

Line 864: htp.tableData(cvalue => '', crowspan => 1);
861: end if;
862: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then
863: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
864: htp.tableData(cvalue => '', crowspan => 1);
866: else
867: htp.tableData(cvalue => '', crowspan => 1);

Line 867: htp.tableData(cvalue => '', crowspan => 1);
866: else
867: htp.tableData(cvalue => '', crowspan => 1);
869: end if;
870: else
871: htp.tableData(cvalue => '', crowspan => 1);
869: end if;
870: else
871: htp.tableData(cvalue => '', crowspan => 1);
873: end if;
874:
875: l_pos := l_pos + 1;

Line 878: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));

874:
875: l_pos := l_pos + 1;
876:
877: ELSE
878: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
879: l_pos := l_pos + 1;
880: -- Print as display only pass that data as hidden
881: htp.tableData(cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'), crowspan => 1);
882:

Line 881: htp.tableData(cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'), crowspan => 1);

877: ELSE
878: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
879: l_pos := l_pos + 1;
880: -- Print as display only pass that data as hidden
881: htp.tableData(cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'), crowspan => 1);
882:
883: -- capture the value to be used as hidden fields later for
884: -- blank lines
885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN

Line 954: htp.tablerowClose;

950: END IF; /* node_dispaly_flag = 'Y' */
951:
952: END LOOP; /* FOR i in items_table */
953:
954: htp.tablerowClose;
955:
956: END LOOP; /* FOR r in ... */
957:
958: END IF; /* IF v_rows_returned > 1 */

Line 963: htp.p('');

959:
960: /* Show few more lines (v_fixed_line_count) as blank lines for entry */
961: FOR r IN v_rows_returned + 1 .. v_display_lines LOOP
962:
963: htp.p('');
964:
965: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
966:
967: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 979: htp.tableData(cvalue => '', crowspan => 1);
981:
982: else
983:

Line 984: htp.tableData(cvalue => '', crowspan => 1);
981:
982: else
983:
984: htp.tableData(cvalue => '', crowspan => 1);
986:
987:
988: end if;

Line 994: htp.tableData(cvalue => '', crowspan => 1);
996:
997:
998: else

Line 1002: htp.tableData(cvalue => '', crowspan => 1);
1004:
1005:
1006: end if;

Line 1009: -- htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);
1015: end if;

Line 1013: htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);
1015: end if;
1016:
1017: l_pos := l_pos + 1;

Line 1083: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

1079: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
1080: v_value := v_charge_account_seg30;
1081: END IF; /* ak.. attribute_code = 'ICX_...' */
1082:
1083: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
1084: l_pos := l_pos + 1;
1085:
1086: IF v_value IS NULL THEN
1087: htp.tableData(cvalue => ' ', crowspan => 1);

Line 1087: htp.tableData(cvalue => ' ', crowspan => 1);

1083: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
1084: l_pos := l_pos + 1;
1085:
1086: IF v_value IS NULL THEN
1087: htp.tableData(cvalue => ' ', crowspan => 1);
1088: ELSE
1089: htp.tableData(cvalue => v_value, crowspan => 1);
1090: END IF; /* IF v_value */
1091:

Line 1089: htp.tableData(cvalue => v_value, crowspan => 1);

1085:
1086: IF v_value IS NULL THEN
1087: htp.tableData(cvalue => ' ', crowspan => 1);
1088: ELSE
1089: htp.tableData(cvalue => v_value, crowspan => 1);
1090: END IF; /* IF v_value */
1091:
1092: END IF; /* update_flag = 'Y' */
1093:

Line 1098: htp.tableRowClose;

1094: END IF; /* node_display_flag = 'Y' */
1095:
1096: END LOOP; /* FOR i in items_table */
1097:
1098: htp.tableRowClose;
1099:
1100: END LOOP; /* FOR v_rows_returned + 1 */
1101:
1102: END IF; /* IF p_show_more_lines */

Line 1105: htp.tableClose;

1101:
1102: END IF; /* IF p_show_more_lines */
1103:
1104:
1105: htp.tableClose;
1106:
1107: htp.formHidden('p_show_more_lines', v_display_lines);
1108: l_pos := l_pos + 1;
1109:

Line 1107: htp.formHidden('p_show_more_lines', v_display_lines);

1103:
1104:
1105: htp.tableClose;
1106:
1107: htp.formHidden('p_show_more_lines', v_display_lines);
1108: l_pos := l_pos + 1;
1109:
1110: htp.br;
1111: htp.br;

Line 1110: htp.br;

1106:
1107: htp.formHidden('p_show_more_lines', v_display_lines);
1108: l_pos := l_pos + 1;
1109:
1110: htp.br;
1111: htp.br;
1112:
1113: htp.formClose;
1114: htp.bodyClose;

Line 1111: htp.br;

1107: htp.formHidden('p_show_more_lines', v_display_lines);
1108: l_pos := l_pos + 1;
1109:
1110: htp.br;
1111: htp.br;
1112:
1113: htp.formClose;
1114: htp.bodyClose;
1115: htp.htmlClose;

Line 1113: htp.formClose;

1109:
1110: htp.br;
1111: htp.br;
1112:
1113: htp.formClose;
1114: htp.bodyClose;
1115: htp.htmlClose;
1116:
1117: END IF; /* validate session */

Line 1114: htp.bodyClose;

1110: htp.br;
1111: htp.br;
1112:
1113: htp.formClose;
1114: htp.bodyClose;
1115: htp.htmlClose;
1116:
1117: END IF; /* validate session */
1118:

Line 1115: htp.htmlClose;

1111: htp.br;
1112:
1113: htp.formClose;
1114: htp.bodyClose;
1115: htp.htmlClose;
1116:
1117: END IF; /* validate session */
1118:
1119: EXCEPTION

Line 1121: -- htp.p('Error in display acct distributions ' || substr(SQLERRM, 1, 512));

1117: END IF; /* validate session */
1118:
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: -- htp.p('Error in display acct distributions ' || substr(SQLERRM, 1, 512));
1122: icx_util.add_error(substr(SQLERRM, 12, 512));
1123: icx_util.error_page_print;
1124:
1125: END display_acct_distributions;

Line 1153: htp.tableOpen('BORDER=0');

1149: ICX_REQ_NAVIGATION.shopper_info(v_shopper_id, v_shopper_name, v_location_id, v_location_code, v_org_id, v_org_code);
1150: ICX_REQ_NAVIGATION.get_currency(v_org_id, v_currency, v_precision, v_money_fmt_mask);
1151: v_money_fmt_mask := fnd_currency.safe_get_format_mask(v_currency, 30);
1152:
1153: htp.tableOpen('BORDER=0');
1154:
1155: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.FIRST),y_table);
1156:
1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

Line 1163: htp.tableRowOpen;

1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1160: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
1162:
1163: htp.tableRowOpen;
1164:
1165: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
1166:
1167: /* Leave a blank space between the prompt and the value */

Line 1165: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');

1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
1162:
1163: htp.tableRowOpen;
1164:
1165: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
1166:
1167: /* Leave a blank space between the prompt and the value */
1168: htp.tableData(cvalue => ' ');
1169:

Line 1168: htp.tableData(cvalue => ' ');

1164:
1165: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
1166:
1167: /* Leave a blank space between the prompt and the value */
1168: htp.tableData(cvalue => ' ');
1169:
1170: htp.p('');
1171: htp.p('');
1172: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN

Line 1170: htp.p('');

1166:
1167: /* Leave a blank space between the prompt and the value */
1168: htp.tableData(cvalue => ' ');
1169:
1170: htp.p('');
1171: htp.p('');
1172: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1173: htp.p('');
1174: END IF;

Line 1171: htp.p('');

1167: /* Leave a blank space between the prompt and the value */
1168: htp.tableData(cvalue => ' ');
1169:
1170: htp.p('');
1171: htp.p('');
1172: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1173: htp.p('');
1174: END IF;
1175:

Line 1173: htp.p('');

1169:
1170: htp.p('');
1171: htp.p('');
1172: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1173: htp.p('');
1174: END IF;
1175:
1176: /* Format ext. price before displaying */
1177: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' THEN

Line 1179: htp.p(TO_CHAR(v_ext_amount, v_money_fmt_mask));

1175:
1176: /* Format ext. price before displaying */
1177: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' THEN
1178: v_ext_amount := y_table(ak_query_pkg.g_items_table(i).value_id);
1179: htp.p(TO_CHAR(v_ext_amount, v_money_fmt_mask));
1180: ELSE
1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
1182: END IF; /* ICX_EXT_PRICE */
1183:

Line 1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));

1177: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' THEN
1178: v_ext_amount := y_table(ak_query_pkg.g_items_table(i).value_id);
1179: htp.p(TO_CHAR(v_ext_amount, v_money_fmt_mask));
1180: ELSE
1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
1182: END IF; /* ICX_EXT_PRICE */
1183:
1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');

Line 1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),

1180: ELSE
1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
1182: END IF; /* ICX_EXT_PRICE */
1183:
1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
1186:
1187: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
1188: THEN

Line 1193: htp.p('');

1189: v_extended_price := y_table(ak_query_pkg.g_items_table(i).value_id);
1190: END IF; /* ICX_EXT_PRICE */
1191:
1192: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1193: htp.p('');
1194: END IF;
1195: htp.p('');
1196: htp.p('');
1197:

Line 1195: htp.p('');

1191:
1192: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1193: htp.p('');
1194: END IF;
1195: htp.p('');
1196: htp.p('');
1197:
1198:
1199: htp.tableRowClose;

Line 1196: htp.p('');

1192: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1193: htp.p('');
1194: END IF;
1195: htp.p('');
1196: htp.p('');
1197:
1198:
1199: htp.tableRowClose;
1200:

Line 1199: htp.tableRowClose;

1195: htp.p('');
1196: htp.p('');
1197:
1198:
1199: htp.tableRowClose;
1200:
1201: END IF; /* aK_query... display_flag = 'Y' */
1202:
1203: END LOOP; /* for i in ... */

Line 1205: htp.tableClose;

1201: END IF; /* aK_query... display_flag = 'Y' */
1202:
1203: END LOOP; /* for i in ... */
1204:
1205: htp.tableClose;
1206: htp.br;
1207:
1208: END IF; /* validate session */
1209:

Line 1206: htp.br;

1202:
1203: END LOOP; /* for i in ... */
1204:
1205: htp.tableClose;
1206: htp.br;
1207:
1208: END IF; /* validate session */
1209:
1210: EXCEPTION

Line 1212: -- htp.p('Error in display acct header ' || substr(SQLERRM, 1, 512));

1208: END IF; /* validate session */
1209:
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: -- htp.p('Error in display acct header ' || substr(SQLERRM, 1, 512));
1213: icx_util.add_error(substr(SQLERRM, 12, 512));
1214: icx_util.error_page_print;
1215:
1216: END display_account_header;

Line 1228: htp.p('');

1224: BEGIN
1225:
1226: IF icx_sec.validateSession('ICX_REQS') THEN
1227:
1228: htp.p('

');
1229: htp.p('');
1230:
1231: v_table_attribute := ' COLSPAN=1';
1232:

Line 1229: htp.p('
');

1225:
1226: IF icx_sec.validateSession('ICX_REQS') THEN
1227:
1228: htp.p('

');
1229: htp.p('');
1230:
1231: v_table_attribute := ' COLSPAN=1';
1232:
1233: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

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

1234: IF (ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' AND
1235: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' AND
1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN
1237:
1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
1239:
1240: END IF; /* if ak_query_pkg ... <> HIDDEN */
1241:
1242: END LOOP; /* FOR in ak_query_pkg ... */

Line 1245: htp.p('
');

1241:
1242: END LOOP; /* FOR in ak_query_pkg ... */
1243:
1244: -- Leave a thin blank line border between the header and the table rows
1245: htp.p('

');
1246:
1247: END IF; /* validate session */
1248:
1249: EXCEPTION

Line 1251: -- htp.p('Error in print lines header ' || substr(SQLERRM, 1, 512));

1247: END IF; /* validate session */
1248:
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: -- htp.p('Error in print lines header ' || substr(SQLERRM, 1, 512));
1252: icx_util.add_error(substr(SQLERRM, 12, 512));
1253: icx_util.error_page_print;
1254:
1255: END print_lines_header;

Line 1269: htp.htmlOpen;

1265:
1266: IF icx_sec.validateSession('ICX_REQS') THEN
1267: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1268:
1269: htp.htmlOpen;
1270: htp.headOpen;
1271: htp.headClose;
1272:
1273: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="parent.parent.winOpen(''nav'',''my_order'');"');

Line 1270: htp.headOpen;

1266: IF icx_sec.validateSession('ICX_REQS') THEN
1267: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1268:
1269: htp.htmlOpen;
1270: htp.headOpen;
1271: htp.headClose;
1272:
1273: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="parent.parent.winOpen(''nav'',''my_order'');"');
1274:

Line 1271: htp.headClose;

1267: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1268:
1269: htp.htmlOpen;
1270: htp.headOpen;
1271: htp.headClose;
1272:
1273: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="parent.parent.winOpen(''nav'',''my_order'');"');
1274:
1275: htp.tableOpen('border=0');

Line 1273: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="parent.parent.winOpen(''nav'',''my_order'');"');

1269: htp.htmlOpen;
1270: htp.headOpen;
1271: htp.headClose;
1272:
1273: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="parent.parent.winOpen(''nav'',''my_order'');"');
1274:
1275: htp.tableOpen('border=0');
1276: htp.tableRowOpen;
1277:

Line 1275: htp.tableOpen('border=0');

1271: htp.headClose;
1272:
1273: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="parent.parent.winOpen(''nav'',''my_order'');"');
1274:
1275: htp.tableOpen('border=0');
1276: htp.tableRowOpen;
1277:
1278: -- Show more lines button
1279: htp.p('

');

1284: P_OnMouseOverText => v_order_button_text,
1285: P_HyperTextCall => 'javascript:parent.frames[0].show_more_lines()',
1286: P_LanguageCode => v_language_code,
1287: P_JavaScriptFlag => FALSE);
1288: htp.p('');
1289:
1290: -- Apply to all lines
1291: htp.p('

');
1289:
1290: -- Apply to all lines
1291: htp.p('');

1297: -- P_HyperTextCall => 'javascript:submit()',
1298: P_HyperTextCall => 'javascript:parent.frames[0].apply_to_all()',
1299: P_LanguageCode => v_language_code,
1300: P_JavaScriptFlag => FALSE);
1301: htp.p('');
1302:
1303: -- Cancel button
1304: htp.p('

');
1302:
1303: -- Cancel button
1304: htp.p('');

1310: -- P_HyperTextCall => 'javascript:cancel_account()',
1311: P_HyperTextCall => 'javascript:parent.frames[0].cancel_account()',
1312: P_LanguageCode => v_language_code,
1313: P_JavaScriptFlag => FALSE);
1314: htp.p('');
1315:
1316: -- Apply button
1317: htp.p('

');
1315:
1316: -- Apply button
1317: htp.p('');

1322: P_OnMouseOverText => v_order_button_text,
1323: P_HyperTextCall => 'javascript:parent.frames[0].submit()',
1324: P_LanguageCode => v_language_code,
1325: P_JavaScriptFlag => FALSE);
1326: htp.p('');
1327:
1328: htp.tableRowClose;
1329: htp.tableClose;
1330:

Line 1328: htp.tableRowClose;

1324: P_LanguageCode => v_language_code,
1325: P_JavaScriptFlag => FALSE);
1326: htp.p('');
1327:
1328: htp.tableRowClose;
1329: htp.tableClose;
1330:
1331: htp.bodyClose;
1332: htp.htmlClose;

Line 1329: htp.tableClose;

1325: P_JavaScriptFlag => FALSE);
1326: htp.p('');
1327:
1328: htp.tableRowClose;
1329: htp.tableClose;
1330:
1331: htp.bodyClose;
1332: htp.htmlClose;
1333:

Line 1331: htp.bodyClose;

1327:
1328: htp.tableRowClose;
1329: htp.tableClose;
1330:
1331: htp.bodyClose;
1332: htp.htmlClose;
1333:
1334: END IF; /* validate session */
1335:

Line 1332: htp.htmlClose;

1328: htp.tableRowClose;
1329: htp.tableClose;
1330:
1331: htp.bodyClose;
1332: htp.htmlClose;
1333:
1334: END IF; /* validate session */
1335:
1336:

Line 1339: -- htp.p('Error in print action buttons ' || substr(SQLERRM, 1, 512));

1335:
1336:
1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: -- htp.p('Error in print action buttons ' || substr(SQLERRM, 1, 512));
1340: icx_util.add_error(substr(SQLERRM, 12, 512));
1341: icx_util.error_page_print;
1342:
1343: END print_action_buttons;

Line 1539: htp.p('parent.parent.account_dist="";');

1535:
1536: ELSE
1537: -- return to my_order tab
1538: js.scriptOpen;
1539: htp.p('parent.parent.account_dist="";');
1540: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');
1541: htp.p('top.switchFrames("my_order");');
1542: js.scriptClose;
1543: RETURN;

Line 1540: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');

1536: ELSE
1537: -- return to my_order tab
1538: js.scriptOpen;
1539: htp.p('parent.parent.account_dist="";');
1540: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');
1541: htp.p('top.switchFrames("my_order");');
1542: js.scriptClose;
1543: RETURN;
1544:

Line 1541: htp.p('top.switchFrames("my_order");');

1537: -- return to my_order tab
1538: js.scriptOpen;
1539: htp.p('parent.parent.account_dist="";');
1540: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');
1541: htp.p('top.switchFrames("my_order");');
1542: js.scriptClose;
1543: RETURN;
1544:
1545: END IF; /* v_error_count */

Line 1651: htp.p('parent.parent.account_dist="";');

1647: apply_to_all(v_cart_id, v_cart_line_id);
1648:
1649: -- return to my_order tab
1650: js.scriptOpen;
1651: htp.p('parent.parent.account_dist="";');
1652: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');
1653: htp.p('top.switchFrames("my_order");');
1654: js.scriptClose;
1655: RETURN;

Line 1652: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');

1648:
1649: -- return to my_order tab
1650: js.scriptOpen;
1651: htp.p('parent.parent.account_dist="";');
1652: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');
1653: htp.p('top.switchFrames("my_order");');
1654: js.scriptClose;
1655: RETURN;
1656: END IF; /* IF v_errror_count... */

Line 1653: htp.p('top.switchFrames("my_order");');

1649: -- return to my_order tab
1650: js.scriptOpen;
1651: htp.p('parent.parent.account_dist="";');
1652: htp.p('parent.parent.cartLineId=' || v_cart_line_id || ';');
1653: htp.p('top.switchFrames("my_order");');
1654: js.scriptClose;
1655: RETURN;
1656: END IF; /* IF v_errror_count... */
1657:

Line 1662: -- htp.p('Error in submit_accounts ' || substr(SQLERRM, 1, 512));

1658: END IF; /* p_user_action = 'APPLY_TO_ALL' */
1659:
1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: -- htp.p('Error in submit_accounts ' || substr(SQLERRM, 1, 512));
1663: icx_util.add_error(substr(SQLERRM, 12, 512));
1664: icx_util.error_page_print;
1665:
1666: END submit_accounts;

Line 1929: -- htp.p('Error in apply_account_distributions ' || substr(SQLERRM, 1, 512));

1925: END IF; /* validate session */
1926:
1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: -- htp.p('Error in apply_account_distributions ' || substr(SQLERRM, 1, 512));
1930: icx_util.add_error(substr(SQLERRM, 12, 512));
1931: icx_util.error_page_print;
1932:
1933: END apply_account_distributions;

Line 2191: -- htp.p('Error in apply_to_all' || substr(SQLERRM, 1, 512));

2187: END IF; /* if v_concatenated_segment = 'N' */
2188:
2189: EXCEPTION
2190: WHEN OTHERS THEN
2191: -- htp.p('Error in apply_to_all' || substr(SQLERRM, 1, 512));
2192: icx_util.add_error(substr(SQLERRM, 12, 512));
2193: icx_util.error_page_print;
2194:
2195: END apply_to_all;

Line 2215: htp.p('
');

Line 1276: htp.tableRowOpen;

1272:
1273: htp.bodyOpen('','BGCOLOR="#CCFFFF" onLoad="parent.parent.winOpen(''nav'',''my_order'');"');
1274:
1275: htp.tableOpen('border=0');
1276: htp.tableRowOpen;
1277:
1278: -- Show more lines button
1279: htp.p('

');
1280: FND_MESSAGE.SET_NAME('ICX','ICX_SHOW_MORE_LINES');

Line 1279: htp.p('
');

1275: htp.tableOpen('border=0');
1276: htp.tableRowOpen;
1277:
1278: -- Show more lines button
1279: htp.p('

');
1280: FND_MESSAGE.SET_NAME('ICX','ICX_SHOW_MORE_LINES');
1281: v_order_button_text := FND_MESSAGE.GET;
1282: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1283: P_ImageFileName => 'FNDBSBMT.gif',

Line 1288: htp.p('
 ');
1292: FND_MESSAGE.SET_NAME('ICX','ICX_APPLY_TO_ALL_LINES');

Line 1291: htp.p('
');

1287: P_JavaScriptFlag => FALSE);
1288: htp.p('

 ');
1292: FND_MESSAGE.SET_NAME('ICX','ICX_APPLY_TO_ALL_LINES');
1293: v_order_button_text := FND_MESSAGE.GET;
1294: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1295: P_ImageFileName => 'FNDBSBMT.gif',

Line 1301: htp.p('
');
1305: FND_MESSAGE.SET_NAME('ICX','ICX_CANCEL');

Line 1304: htp.p('
');

1300: P_JavaScriptFlag => FALSE);
1301: htp.p('

');
1305: FND_MESSAGE.SET_NAME('ICX','ICX_CANCEL');
1306: v_order_button_text := FND_MESSAGE.GET;
1307: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1308: P_ImageFileName => 'FNDBCNCL.gif',

Line 1314: htp.p('
');
1318: FND_MESSAGE.SET_NAME('ICX','ICX_APPLY_CHANGES');

Line 1317: htp.p('
');

1313: P_JavaScriptFlag => FALSE);
1314: htp.p('

');
1318: FND_MESSAGE.SET_NAME('ICX','ICX_APPLY_CHANGES');
1319: v_order_button_text := FND_MESSAGE.GET;
1320: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1321: P_ImageFileName => 'FNDBAPLY.gif',

Line 1326: htp.p('
');

2211:
2212: l_first_time := 'Y';
2213: FOR prec IN get_errors(v_cart_id) LOOP
2214: IF l_first_time = 'Y' THEN
2215: htp.p('

');
2216: l_first_time := 'N';
2217: END IF;
2218:
2219: htp.p('');

Line 2219: htp.p('
');

2215: htp.p('

' || prec.error_text || '
' || prec.error_text || '
');
2216: l_first_time := 'N';
2217: END IF;
2218:
2219: htp.p('');
2220: END LOOP;
2221: IF l_first_time = 'N' THEN
2222: htp.p('
' || prec.error_text || '
');
2223: END IF;

Line 2222: htp.p('');

2218:
2219: htp.p('' || prec.error_text || '');
2220: END LOOP;
2221: IF l_first_time = 'N' THEN
2222: htp.p('');
2223: END IF;
2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN

Line 2227: -- htp.p('Error in display_account_errors' || substr(SQLERRM, 1, 512));

2223: END IF;
2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN
2227: -- htp.p('Error in display_account_errors' || substr(SQLERRM, 1, 512));
2228: icx_util.add_error(substr(SQLERRM, 12, 512));
2229: icx_util.error_page_print;
2230:
2231: END display_account_errors;