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.IEX_STRATEGY_DIAG_REPORT dependencies on FND_PROFILE

Line 100: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

96: where resource_id = p_resource_id;
97:
98: begin
99: writelog('Begin get_resource');
100: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
101:
102: l_default_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
103: l_resource_id := l_default_resource_id;
104:

Line 102: l_default_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

98: begin
99: writelog('Begin get_resource');
100: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
101:
102: l_default_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
103: l_resource_id := l_default_resource_id;
104:
105: l_party_id := p_strategy_rec.party_id;
106: l_cust_acct_id := p_strategy_rec.cust_account_id;

Line 199: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');

195: into l_report_date
196: from dual;
197: writelog('gen_xml_header_data_strategy: l_report_date: ' || l_report_date);
198:
199: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');
200: writelog('gen_xml_header_data_strategy: l_terr_acc_level: ' || l_terr_acc_level);
201:
202: l_lookup_code := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
203: writelog('gen_xml_header_data_strategy: l_lookup_code: ' || l_lookup_code);

Line 202: l_lookup_code := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');

198:
199: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');
200: writelog('gen_xml_header_data_strategy: l_terr_acc_level: ' || l_terr_acc_level);
201:
202: l_lookup_code := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
203: writelog('gen_xml_header_data_strategy: l_lookup_code: ' || l_lookup_code);
204:
205: open c_get_lookup_meaning (l_lookup_code);
206: fetch c_get_lookup_meaning into l_pro_sty_by_ou;

Line 211: l_lookup_code := NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');

207: close c_get_lookup_meaning;
208:
209: writelog('gen_xml_header_data_strategy: l_pro_sty_by_ou: '|| l_pro_sty_by_ou);
210:
211: l_lookup_code := NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');
212: open c_get_lookup_meaning (l_lookup_code);
213: fetch c_get_lookup_meaning into l_skip_def_sty_assign;
214: close c_get_lookup_meaning;
215: writelog('gen_xml_header_data_strategy: l_skip_def_sty_assign: '|| l_skip_def_sty_assign);

Line 217: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);

213: fetch c_get_lookup_meaning into l_skip_def_sty_assign;
214: close c_get_lookup_meaning;
215: writelog('gen_xml_header_data_strategy: l_skip_def_sty_assign: '|| l_skip_def_sty_assign);
216:
217: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
218: open c_resource_name (l_resource_id);
219: fetch c_resource_name into l_fulfilment_rs;
220: close c_resource_name;
221: writelog('gen_xml_header_data_strategy: l_fulfilment_rs: '|| l_fulfilment_rs);

Line 224: l_grace_preiod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);

220: close c_resource_name;
221: writelog('gen_xml_header_data_strategy: l_fulfilment_rs: '|| l_fulfilment_rs);
222:
223:
224: l_grace_preiod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
225:
226: writelog('Start constructing the XML Header data');
227: l_new_line := '
228: ';

Line 238: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');

234:
235: /* Prepare the tag for the report heading */
236: --l_xml_header := '';
237: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.
238: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
239: l_xml_header := '';
240: l_xml_header := l_xml_header ||l_new_line||'';
241: l_xml_header := l_xml_header ||l_new_line||' '||l_report_date||'';
242: l_xml_header := l_xml_header ||l_new_line||' '|| l_StrategyLevelName ||'';