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.MSC_PHUB_UTIL dependencies on FND_MESSAGE

Line 39: FND_MESSAGE.SET_NAME('MSC', p_mesg_code);

35:
36: function get_planning_hub_message(p_mesg_code varchar2) return varchar2 is
37: l_message varchar2(100);
38: begin
39: FND_MESSAGE.SET_NAME('MSC', p_mesg_code);
40: l_message :=FND_MESSAGE.GET;
41: return l_message;
42: end get_planning_hub_message;
43:

Line 40: l_message :=FND_MESSAGE.GET;

36: function get_planning_hub_message(p_mesg_code varchar2) return varchar2 is
37: l_message varchar2(100);
38: begin
39: FND_MESSAGE.SET_NAME('MSC', p_mesg_code);
40: l_message :=FND_MESSAGE.GET;
41: return l_message;
42: end get_planning_hub_message;
43:
44: function get_reporting_currency_code return varchar2 is

Line 208: return fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED');

204: return l_user_name;
205:
206: exception
207: when others then
208: return fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED');
209: end get_user_name;
210:
211: procedure validate_icx_session(p_icx_cookie varchar2, p_user varchar2, p_pwd varchar2) is
212: l_retval varchar2(1);

Line 404: fnd_message.set_name('MSC', 'MSC_APCC_CONV_E02');

400: commit;
401:
402: if (l_rowcount > 0) then
403: l_result := 1;
404: fnd_message.set_name('MSC', 'MSC_APCC_CONV_E02');
405: fnd_message.set_token('COLUMNS', p_columns);
406: log(fnd_message.get);
407: dbms_utility.comma_to_table(p_columns, n, t);
408: l_merged_columns := t(1); i := 2;

Line 405: fnd_message.set_token('COLUMNS', p_columns);

401:
402: if (l_rowcount > 0) then
403: l_result := 1;
404: fnd_message.set_name('MSC', 'MSC_APCC_CONV_E02');
405: fnd_message.set_token('COLUMNS', p_columns);
406: log(fnd_message.get);
407: dbms_utility.comma_to_table(p_columns, n, t);
408: l_merged_columns := t(1); i := 2;
409: while (i <= n) loop

Line 406: log(fnd_message.get);

402: if (l_rowcount > 0) then
403: l_result := 1;
404: fnd_message.set_name('MSC', 'MSC_APCC_CONV_E02');
405: fnd_message.set_token('COLUMNS', p_columns);
406: log(fnd_message.get);
407: dbms_utility.comma_to_table(p_columns, n, t);
408: l_merged_columns := t(1); i := 2;
409: while (i <= n) loop
410: l_merged_columns := l_merged_columns||'||'',''||'||t(i);

Line 574: l_unassigned varchar2(30) := fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED');

570: p_zone_col varchar2)
571: return number
572: is
573: l_sql varchar2(16384);
574: l_unassigned varchar2(30) := fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED');
575: l_result_cols varchar2(100) := '';
576: l_source_cols varchar2(100) := '';
577: l_report_cols varchar2(100) := '';
578: l_where1 varchar2(1024) := '';

Line 646: l_unassigned varchar2(30) := fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED');

642: p_supplier_site_code_col varchar2)
643: return number
644: is
645: l_sql varchar2(1000);
646: l_unassigned varchar2(30) := fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED');
647: begin
648: l_sql :=
649: ' update '||p_staging_table||' f set (error_code, '||p_supplier_id_col||', '||p_supplier_site_id_col||') ='||
650: ' (select 0, d.supplier_id, d.supplier_site_id'||

Line 1129: log(fnd_message.get_string('MSC', 'MSC_PART_UNDEFINED_SCHEMA'));

1125: e_truncate_tale exception;
1126: begin
1127: log('msc_phub_util.truncate_table('||p_table||')');
1128: if (fnd_installation.get_app_info('FND', dummy1, dummy2, l_applsys_schema) = false) then
1129: log(fnd_message.get_string('MSC', 'MSC_PART_UNDEFINED_SCHEMA'));
1130: raise e_truncate_tale;
1131: end if;
1132:
1133: l_ddl := 'truncate table '||p_table;