DBA Data[Home] [Help]

APPS.ICX_UTIL dependencies on FND_MESSAGE

Line 412: fnd_message.set_name('ICX','ICX_LOV_IS_NOT_DEFINED');

408: end if; -- validateSession
409:
410: exception
411: when no_data_found then
412: fnd_message.set_name('ICX','ICX_LOV_IS_NOT_DEFINED');
413: icx_util.add_error(fnd_message.get);
414: icx_util.error_page_print;
415:
416: when others then

Line 413: icx_util.add_error(fnd_message.get);

409:
410: exception
411: when no_data_found then
412: fnd_message.set_name('ICX','ICX_LOV_IS_NOT_DEFINED');
413: icx_util.add_error(fnd_message.get);
414: icx_util.error_page_print;
415:
416: when others then
417: err_num := SQLCODE;

Line 618: fnd_message.set_name('ICX','ICX_RECORDS_RANGE');

614: IF (p_list_count = TRUE) THEN
615:
616: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%"');
617: htp.tableRowOpen;
618: fnd_message.set_name('ICX','ICX_RECORDS_RANGE');
619: fnd_message.set_token('FROM_ROW_TOKEN',p_start_row);
620: fnd_message.set_token('TO_ROW_TOKEN',p_stop_row);
621: fnd_message.set_token('TOTAL_ROW_TOKEN',''||
622: p_row_count||'');

Line 619: fnd_message.set_token('FROM_ROW_TOKEN',p_start_row);

615:
616: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%"');
617: htp.tableRowOpen;
618: fnd_message.set_name('ICX','ICX_RECORDS_RANGE');
619: fnd_message.set_token('FROM_ROW_TOKEN',p_start_row);
620: fnd_message.set_token('TO_ROW_TOKEN',p_stop_row);
621: fnd_message.set_token('TOTAL_ROW_TOKEN',''||
622: p_row_count||'');
623: l_message := fnd_message.get;

Line 620: fnd_message.set_token('TO_ROW_TOKEN',p_stop_row);

616: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%"');
617: htp.tableRowOpen;
618: fnd_message.set_name('ICX','ICX_RECORDS_RANGE');
619: fnd_message.set_token('FROM_ROW_TOKEN',p_start_row);
620: fnd_message.set_token('TO_ROW_TOKEN',p_stop_row);
621: fnd_message.set_token('TOTAL_ROW_TOKEN',''||
622: p_row_count||'');
623: l_message := fnd_message.get;
624: htp.p(''||l_message||'');

Line 621: fnd_message.set_token('TOTAL_ROW_TOKEN',''||

617: htp.tableRowOpen;
618: fnd_message.set_name('ICX','ICX_RECORDS_RANGE');
619: fnd_message.set_token('FROM_ROW_TOKEN',p_start_row);
620: fnd_message.set_token('TO_ROW_TOKEN',p_stop_row);
621: fnd_message.set_token('TOTAL_ROW_TOKEN',''||
622: p_row_count||'');
623: l_message := fnd_message.get;
624: htp.p(''||l_message||'');
625: htp.tableRowClose;

Line 623: l_message := fnd_message.get;

619: fnd_message.set_token('FROM_ROW_TOKEN',p_start_row);
620: fnd_message.set_token('TO_ROW_TOKEN',p_stop_row);
621: fnd_message.set_token('TOTAL_ROW_TOKEN',''||
622: p_row_count||'');
623: l_message := fnd_message.get;
624: htp.p(''||l_message||'');
625: htp.tableRowClose;
626: htp.tableClose;
627:

Line 680: fnd_message.set_name('ICX','ICX_PREVIOUS');

676: to_char(l_stop_row)||''''||')">');
677:
678: htp.p('');
679:
680: fnd_message.set_name('ICX','ICX_PREVIOUS');
681:
682: htp.p(''||fnd_message.get||'');
683:
684: htp.p('');

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

678: htp.p('');
679:
680: fnd_message.set_name('ICX','ICX_PREVIOUS');
681:
682: htp.p(''||fnd_message.get||'');
683:
684: htp.p('');
685:
686: END IF;

Line 720: fnd_message.set_name('ICX','ICX_NEXT');

716: htp.p('');
719:
720: fnd_message.set_name('ICX','ICX_NEXT');
721:
722: htp.p(''||fnd_message.get||'');
723:
724: htp.p('');

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

718: ''''||')">');
719:
720: fnd_message.set_name('ICX','ICX_NEXT');
721:
722: htp.p(''||fnd_message.get||'');
723:
724: htp.p('');
725:
726: htp.p('');

Line 859: fnd_message.set_name('ICX','ICX_OPEN_QUERY2');

855: and REGION_CODE = p_LOV_region;
856:
857: if instr(l_icx_custom_call,'LONG') > 0
858: then
859: fnd_message.set_name('ICX','ICX_OPEN_QUERY2');
860: l_message := icx_util.replace_quotes(fnd_message.get);
861:
862: htp.p('function LOV_check(attributes) {
863: if (search == "Y") {

Line 860: l_message := icx_util.replace_quotes(fnd_message.get);

856:
857: if instr(l_icx_custom_call,'LONG') > 0
858: then
859: fnd_message.set_name('ICX','ICX_OPEN_QUERY2');
860: l_message := icx_util.replace_quotes(fnd_message.get);
861:
862: htp.p('function LOV_check(attributes) {
863: if (search == "Y") {
864: if (document.LOVHeader.i_1.value == "") {

Line 873: fnd_message.set_name('ICX','ICX_OPEN_QUERY');

869: }
870: }
871: }');
872: else
873: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
874: l_message := icx_util.replace_quotes(fnd_message.get);
875:
876: htp.p('function LOV_check(attributes) {
877: if (search == "Y") {

Line 874: l_message := icx_util.replace_quotes(fnd_message.get);

870: }
871: }');
872: else
873: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
874: l_message := icx_util.replace_quotes(fnd_message.get);
875:
876: htp.p('function LOV_check(attributes) {
877: if (search == "Y") {
878: if (document.LOVHeader.i_1.value == "") {

Line 899: fnd_message.set_name('ICX','ICX_CASE_QUERY');

895: LOV_submit(attributes);
896: }');
897: else
898: -- javascript to pop alert box if case-sensitive is
899: fnd_message.set_name('ICX','ICX_CASE_QUERY');
900: l_message := icx_util.replace_quotes(fnd_message.get);
901: htp.p('function case_check(attributes) {
902: if (!(document.LOVHeader.case_sensitive.checked)) {
903: if (confirm("'||l_message||'")) {

Line 900: l_message := icx_util.replace_quotes(fnd_message.get);

896: }');
897: else
898: -- javascript to pop alert box if case-sensitive is
899: fnd_message.set_name('ICX','ICX_CASE_QUERY');
900: l_message := icx_util.replace_quotes(fnd_message.get);
901: htp.p('function case_check(attributes) {
902: if (!(document.LOVHeader.case_sensitive.checked)) {
903: if (confirm("'||l_message||'")) {
904: LOV_submit(attributes);

Line 1189: fnd_message.set_name('ICX','ICX_MATCHCASE_LOV');

1185:
1186: if l_matchcase_lov = 'Hidden'
1187: then
1188:
1189: fnd_message.set_name('ICX','ICX_MATCHCASE_LOV');
1190: l_message := fnd_message.get;
1191:
1192: htp.tableRowOpen;
1193: htp.tableData(htf.italic(l_message),NULL,NULL,NULL,NULL,3,NULL);

Line 1190: l_message := fnd_message.get;

1186: if l_matchcase_lov = 'Hidden'
1187: then
1188:
1189: fnd_message.set_name('ICX','ICX_MATCHCASE_LOV');
1190: l_message := fnd_message.get;
1191:
1192: htp.tableRowOpen;
1193: htp.tableData(htf.italic(l_message),NULL,NULL,NULL,NULL,3,NULL);
1194: htp.tableData(htf.formHidden('case_sensitive', 'on'));

Line 1523: fnd_message.set_name('ICX','ICX_LOV_HINT');

1519: else
1520: htp.p('if (parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value != "") {
1521: document.LOVValues.i_1.value = parent.opener.parent.'||c_frame_name||'.document.'||c_form_name||'.'||p_attribute_code||'.value');
1522: end if;
1523: fnd_message.set_name('ICX','ICX_LOV_HINT');
1524: htp.p('document.LOVValues.a_1.value = "'||temp_a_1||'"
1525: document.LOVValues.submit()
1526: } else {
1527: document.write("

")

Line 1528: document.write("

'||icx_util.replace_quotes(fnd_message.get)||'

")

1524: htp.p('document.LOVValues.a_1.value = "'||temp_a_1||'"
1525: document.LOVValues.submit()
1526: } else {
1527: document.write("

")
1528: document.write("

'||icx_util.replace_quotes(fnd_message.get)||'

")
1529: document.write("
")
1530: }
1531: }');
1532:

Line 1863: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');

1859: where region_application_id = p_region_app_id
1860: and region_code = p_region_code
1861: and attribute_application_id = p_attribute_app_id
1862: and attribute_code = p_attribute_code;
1863: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1864: fnd_message.set_token('NAME_OF_REGION_TOKEN',l_attribute_name);
1865: htp.p('

'||fnd_message.get||'

');
1866: end if;
1867:

Line 1864: fnd_message.set_token('NAME_OF_REGION_TOKEN',l_attribute_name);

1860: and region_code = p_region_code
1861: and attribute_application_id = p_attribute_app_id
1862: and attribute_code = p_attribute_code;
1863: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1864: fnd_message.set_token('NAME_OF_REGION_TOKEN',l_attribute_name);
1865: htp.p('

'||fnd_message.get||'

');
1866: end if;
1867:
1868: end if; -- Display results

Line 1865: htp.p('

'||fnd_message.get||'

');

1861: and attribute_application_id = p_attribute_app_id
1862: and attribute_code = p_attribute_code;
1863: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1864: fnd_message.set_token('NAME_OF_REGION_TOKEN',l_attribute_name);
1865: htp.p('

'||fnd_message.get||'

');
1866: end if;
1867:
1868: end if; -- Display results
1869:

Line 1871: fnd_message.set_name('ICX','ICX_MAX_ROWS');

1867:
1868: end if; -- Display results
1869:
1870: else -- ak_query generated an error
1871: fnd_message.set_name('ICX','ICX_MAX_ROWS');
1872: htp.p('

');
1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');
1874: htp.p('
');
1875: end if; -- check if error messages were generated by the ak query

Line 1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');

1869:
1870: else -- ak_query generated an error
1871: fnd_message.set_name('ICX','ICX_MAX_ROWS');
1872: htp.p('

');
1873: htp.p('

'||icx_util.replace_quotes(fnd_message.get)||'

');
1874: htp.p('
');
1875: end if; -- check if error messages were generated by the ak query
1876:
1877: htp.formClose;

Line 2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');

2110: begin
2111:
2112: htp.htmlOpen;
2113: htp.bodyOpen(icx_admin_sig.background);
2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
2115: htp.p('

'||FND_MESSAGE.GET || '

');
2116: htp.p('
    ');
    2117: for j in 1..TOTAL_ERRORS loop
    2118: htp.p('
  • '||error_table(j));

    Line 2115: htp.p('

    '||FND_MESSAGE.GET || '

    ');

    2111:
    2112: htp.htmlOpen;
    2113: htp.bodyOpen(icx_admin_sig.background);
    2114: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
    2115: htp.p('

    '||FND_MESSAGE.GET || '

    ');
    2116: htp.p('
      ');
      2117: for j in 1..TOTAL_ERRORS loop
      2118: htp.p('
    • '||error_table(j));
      2119: end loop;

      Line 2132: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');

      2128: ----------------------------------------------------------------------------
      2129:
      2130: j BINARY_INTEGER;
      2131: begin
      2132: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
      2133: htp.p(FND_MESSAGE.GET);
      2134: htp.p('---------------------------------------------------------');
      2135: for j in 1..TOTAL_ERRORS loop
      2136: htp.p(error_table(j));

      Line 2133: htp.p(FND_MESSAGE.GET);

      2129:
      2130: j BINARY_INTEGER;
      2131: begin
      2132: FND_MESSAGE.SET_NAME('ICX', 'ICX_ERROR');
      2133: htp.p(FND_MESSAGE.GET);
      2134: htp.p('---------------------------------------------------------');
      2135: for j in 1..TOTAL_ERRORS loop
      2136: htp.p(error_table(j));
      2137: end loop;