DBA Data[Home] [Help]

APPS.ICX_ON dependencies on FND_MESSAGE

Line 155: fnd_message.set_name('ICX','ICX_USE_NUMBER');

151: -- select HSECS into l_timer from v$timer;htp.p('end get_page @ '||l_timer);htp.nl;
152:
153: exception
154: when VALUE_ERROR or INVALID_NUMBER then
155: fnd_message.set_name('ICX','ICX_USE_NUMBER');
156: l_message := fnd_message.get;
157: icx_util.add_error(l_message) ;
158: icx_admin_sig.error_screen(l_message);
159: when others then

Line 156: l_message := fnd_message.get;

152:
153: exception
154: when VALUE_ERROR or INVALID_NUMBER then
155: fnd_message.set_name('ICX','ICX_USE_NUMBER');
156: l_message := fnd_message.get;
157: icx_util.add_error(l_message) ;
158: icx_admin_sig.error_screen(l_message);
159: when others then
160: l_err_num := SQLCODE;

Line 165: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');

161: l_message := SQLERRM;
162: select substr(l_message,12,512) into l_err_mesg from dual;
163: if (abs(l_err_num) between 1800 and 1899)
164: then
165: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
166: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);
167: fnd_message.set_token('FORMAT_MASK_TOKEN',nvl(l_web_user_date_format,'DD-MON-YYYY'));
168: l_message := l_err_mesg||'
'||fnd_message.get;
169: icx_util.add_error(l_message) ;

Line 167: fnd_message.set_token('FORMAT_MASK_TOKEN',nvl(l_web_user_date_format,'DD-MON-YYYY'));

163: if (abs(l_err_num) between 1800 and 1899)
164: then
165: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
166: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);
167: fnd_message.set_token('FORMAT_MASK_TOKEN',nvl(l_web_user_date_format,'DD-MON-YYYY'));
168: l_message := l_err_mesg||'
'||fnd_message.get;
169: icx_util.add_error(l_message) ;
170: icx_admin_sig.error_screen(l_err_mesg);
171: else

Line 168: l_message := l_err_mesg||'
'||fnd_message.get;

164: then
165: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
166: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);
167: fnd_message.set_token('FORMAT_MASK_TOKEN',nvl(l_web_user_date_format,'DD-MON-YYYY'));
168: l_message := l_err_mesg||'
'||fnd_message.get;
169: icx_util.add_error(l_message) ;
170: icx_admin_sig.error_screen(l_err_mesg);
171: else
172: icx_util.add_error(l_err_mesg);

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

336: -- icx_on_utilities2.printPLSQLtables;
337:
338: if ak_query_pkg.g_results_table.COUNT = 0
339: then
340: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
341: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
342: l_message := fnd_message.get;
343:
344: htp.p(l_message);

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

337:
338: if ak_query_pkg.g_results_table.COUNT = 0
339: then
340: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
341: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
342: l_message := fnd_message.get;
343:
344: htp.p(l_message);
345: else

Line 342: l_message := fnd_message.get;

338: if ak_query_pkg.g_results_table.COUNT = 0
339: then
340: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
341: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
342: l_message := fnd_message.get;
343:
344: htp.p(l_message);
345: else
346:

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

476:
477: end if; -- region style
478:
479: else
480: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
481: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
482: l_message := fnd_message.get;
483: htp.p(l_message);
484:

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

477: end if; -- region style
478:
479: else
480: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
481: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
482: l_message := fnd_message.get;
483: htp.p(l_message);
484:
485: end if; -- no row in region

Line 482: l_message := fnd_message.get;

478:
479: else
480: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
481: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
482: l_message := fnd_message.get;
483: htp.p(l_message);
484:
485: end if; -- no row in region
486: