DBA Data[Home] [Help]

APPS.ICX_ON_UTILITIES dependencies on FND_MESSAGE

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

346: and REGION_CODE = l_region_code;
347:
348: if instr(l_icx_custom_call,'LONG') > 0
349: then
350: fnd_message.set_name('ICX','ICX_OPEN_QUERY2');
351: l_message := icx_util.replace_quotes(fnd_message.get);
352:
353: if p_lines_now = 1
354: then

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

347:
348: if instr(l_icx_custom_call,'LONG') > 0
349: then
350: fnd_message.set_name('ICX','ICX_OPEN_QUERY2');
351: l_message := icx_util.replace_quotes(fnd_message.get);
352:
353: if p_lines_now = 1
354: then
355: --added findform0 and supporting lines for 1570530 mputman.

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

423: }
424: }');
425: end if; -- lines
426: else -- not block blind
427: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
428: l_message := icx_util.replace_quotes(fnd_message.get);
429:
430: if p_lines_now = 1
431: then

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

424: }');
425: end if; -- lines
426: else -- not block blind
427: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
428: l_message := icx_util.replace_quotes(fnd_message.get);
429:
430: if p_lines_now = 1
431: then
432:

Line 633: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');

629: and REGION_APPLICATION_ID = p_region_appl_id;
630:
631: if l_data_type1 = 'V'
632: then
633: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
634: l_message := fnd_message.get;
635: else
636: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
637: l_message := fnd_message.get;

Line 634: l_message := fnd_message.get;

630:
631: if l_data_type1 = 'V'
632: then
633: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
634: l_message := fnd_message.get;
635: else
636: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
637: l_message := fnd_message.get;
638: end if;

Line 636: fnd_message.set_name('ICX','ICX_FIND_NUMBER');

632: then
633: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
634: l_message := fnd_message.get;
635: else
636: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
637: l_message := fnd_message.get;
638: end if;
639:
640: htp.tableOpen('BORDER=0');

Line 637: l_message := fnd_message.get;

633: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
634: l_message := fnd_message.get;
635: else
636: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
637: l_message := fnd_message.get;
638: end if;
639:
640: htp.tableOpen('BORDER=0');
641: htp.tableRowOpen;

Line 711: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');

707: else
708:
709: if p_lines_now > 1
710: then
711: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
712: htp.p(fnd_message.get);htp.nl;
713:
714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;

Line 712: htp.p(fnd_message.get);htp.nl;

708:
709: if p_lines_now > 1
710: then
711: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
712: htp.p(fnd_message.get);htp.nl;
713:
714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:

Line 714: fnd_message.set_name('ICX','ICX_FIND_AND');

710: then
711: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
712: htp.p(fnd_message.get);htp.nl;
713:
714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:
717: fnd_message.set_name('ICX','ICX_FIND_OR');
718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;

Line 715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;

711: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
712: htp.p(fnd_message.get);htp.nl;
713:
714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:
717: fnd_message.set_name('ICX','ICX_FIND_OR');
718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
719: end if;

Line 717: fnd_message.set_name('ICX','ICX_FIND_OR');

713:
714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:
717: fnd_message.set_name('ICX','ICX_FIND_OR');
718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
719: end if;
720:
721: for i in 1..p_lines_now loop

Line 718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;

714: fnd_message.set_name('ICX','ICX_FIND_AND');
715: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
716:
717: fnd_message.set_name('ICX','ICX_FIND_OR');
718: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
719: end if;
720:
721: for i in 1..p_lines_now loop
722:

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

1192: end loop;
1193:
1194: exception
1195: when e_max_rows then
1196: fnd_message.set_name('ICX','ICX_MAX_ROWS');
1197: l_err_mesg := fnd_message.get;
1198: icx_util.add_error(l_err_mesg);
1199: icx_admin_sig.error_screen(l_err_mesg);
1200: c_type := 'Z';

Line 1197: l_err_mesg := fnd_message.get;

1193:
1194: exception
1195: when e_max_rows then
1196: fnd_message.set_name('ICX','ICX_MAX_ROWS');
1197: l_err_mesg := fnd_message.get;
1198: icx_util.add_error(l_err_mesg);
1199: icx_admin_sig.error_screen(l_err_mesg);
1200: c_type := 'Z';
1201: c_continue := FALSE;

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

1293:
1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then
1296: htp.p('');
1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
1299: l_message := fnd_message.get;
1300:
1301: htp.strong(l_message);htp.nl;

Line 1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);

1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then
1296: htp.p('');
1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
1299: l_message := fnd_message.get;
1300:
1301: htp.strong(l_message);htp.nl;
1302:

Line 1299: l_message := fnd_message.get;

1295: then
1296: htp.p('');
1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
1299: l_message := fnd_message.get;
1300:
1301: htp.strong(l_message);htp.nl;
1302:
1303: else

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

1360: htp.p('');
1361:
1362: if ak_query_pkg.g_regions_table(r).total_result_count = 0
1363: then
1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1365: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
1366: l_message := fnd_message.get;
1367:
1368: htp.strong(l_message);htp.nl;

Line 1365: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);

1361:
1362: if ak_query_pkg.g_regions_table(r).total_result_count = 0
1363: then
1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1365: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
1366: l_message := fnd_message.get;
1367:
1368: htp.strong(l_message);htp.nl;
1369:

Line 1366: l_message := fnd_message.get;

1362: if ak_query_pkg.g_regions_table(r).total_result_count = 0
1363: then
1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1365: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
1366: l_message := fnd_message.get;
1367:
1368: htp.strong(l_message);htp.nl;
1369:
1370: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'

Line 1373: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');

1369:
1370: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
1371: and ak_query_pkg.g_regions_table(r).total_result_count > 1
1372: then
1373: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
1374: l_message := fnd_message.get;
1375:
1376: htp.strong(l_message);
1377: l_continue := FALSE;

Line 1374: l_message := fnd_message.get;

1370: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
1371: and ak_query_pkg.g_regions_table(r).total_result_count > 1
1372: then
1373: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
1374: l_message := fnd_message.get;
1375:
1376: htp.strong(l_message);
1377: l_continue := FALSE;
1378: else