DBA Data[Home] [Help]

APPS.WIP_BIS_UTZ_ALERT dependencies on FND_MESSAGE

Line 277: fnd_message.get_string('BOM', 'CST_UNASSIGNED_LABEL');

273: l_pg_id VARCHAR2(100) := NULL;
274: l_item_id VARCHAR2(100) := NULL;
275:
276: l_unassigned VARCHAR2(100) :=
277: fnd_message.get_string('BOM', 'CST_UNASSIGNED_LABEL');
278:
279: BEGIN
280:
281: l_subject := fnd_message.get_string('WIP', 'RESOURCE_UTILIZATION') ||

Line 281: l_subject := fnd_message.get_string('WIP', 'RESOURCE_UTILIZATION') ||

277: fnd_message.get_string('BOM', 'CST_UNASSIGNED_LABEL');
278:
279: BEGIN
280:
281: l_subject := fnd_message.get_string('WIP', 'RESOURCE_UTILIZATION') ||
282: ' ' || fnd_message.get_string('WIP', 'WIP_ALERT');
283: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
284: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||

Line 282: ' ' || fnd_message.get_string('WIP', 'WIP_ALERT');

278:
279: BEGIN
280:
281: l_subject := fnd_message.get_string('WIP', 'RESOURCE_UTILIZATION') ||
282: ' ' || fnd_message.get_string('WIP', 'WIP_ALERT');
283: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
284: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
286: ': ' || ou;

Line 283: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;

279: BEGIN
280:
281: l_subject := fnd_message.get_string('WIP', 'RESOURCE_UTILIZATION') ||
282: ' ' || fnd_message.get_string('WIP', 'WIP_ALERT');
283: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
284: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
286: ': ' || ou;
287: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||

Line 284: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;

280:
281: l_subject := fnd_message.get_string('WIP', 'RESOURCE_UTILIZATION') ||
282: ' ' || fnd_message.get_string('WIP', 'WIP_ALERT');
283: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
284: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
286: ': ' || ou;
287: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
288: ': ' || org;

Line 285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||

281: l_subject := fnd_message.get_string('WIP', 'RESOURCE_UTILIZATION') ||
282: ' ' || fnd_message.get_string('WIP', 'WIP_ALERT');
283: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
284: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
286: ': ' || ou;
287: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
288: ': ' || org;
289: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;

Line 287: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||

283: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
284: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
286: ': ' || ou;
287: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
288: ': ' || org;
289: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
290: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
291: ': ' || country;

Line 289: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;

285: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
286: ': ' || ou;
287: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
288: ': ' || org;
289: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
290: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
291: ': ' || country;
292: /* James 7/8/99 */
293: l_region := fnd_message.get_string('BOM', 'CST_REGION_LABEL') ||

Line 290: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||

286: ': ' || ou;
287: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
288: ': ' || org;
289: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
290: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
291: ': ' || country;
292: /* James 7/8/99 */
293: l_region := fnd_message.get_string('BOM', 'CST_REGION_LABEL') ||
294: ': ' || region;

Line 293: l_region := fnd_message.get_string('BOM', 'CST_REGION_LABEL') ||

289: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
290: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
291: ': ' || country;
292: /* James 7/8/99 */
293: l_region := fnd_message.get_string('BOM', 'CST_REGION_LABEL') ||
294: ': ' || region;
295: /* end James */
296: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
297: || ': ' || prod;

Line 296: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')

292: /* James 7/8/99 */
293: l_region := fnd_message.get_string('BOM', 'CST_REGION_LABEL') ||
294: ': ' || region;
295: /* end James */
296: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
297: || ': ' || prod;
298: l_prod := fnd_message.get_string('BOM', 'ITEM_CAP') ||
299: ': ' || item;
300: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')

Line 298: l_prod := fnd_message.get_string('BOM', 'ITEM_CAP') ||

294: ': ' || region;
295: /* end James */
296: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
297: || ': ' || prod;
298: l_prod := fnd_message.get_string('BOM', 'ITEM_CAP') ||
299: ': ' || item;
300: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
301: || ': ' || time_level_value;
302: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')

Line 300: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')

296: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
297: || ': ' || prod;
298: l_prod := fnd_message.get_string('BOM', 'ITEM_CAP') ||
299: ': ' || item;
300: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
301: || ': ' || time_level_value;
302: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
303: || ': ' || round(actual, 2);
304: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')

Line 302: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')

298: l_prod := fnd_message.get_string('BOM', 'ITEM_CAP') ||
299: ': ' || item;
300: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
301: || ': ' || time_level_value;
302: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
303: || ': ' || round(actual, 2);
304: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')
305: || ': ' || round(target, 2);
306:

Line 304: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')

300: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
301: || ': ' || time_level_value;
302: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
303: || ': ' || round(actual, 2);
304: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')
305: || ': ' || round(target, 2);
306:
307: IF(org_level = 1) /* SOB */ THEN
308: l_org_level := 'SET OF BOOKS';

Line 540: all_text := '''' || FND_MESSAGE.get_string('WIP', 'WIP_ALL') || '''';

536: l_resp_name VARCHAR2(100);
537: BEGIN
538:
539: /* initialize all text */
540: all_text := '''' || FND_MESSAGE.get_string('WIP', 'WIP_ALL') || '''';
541:
542: p_select_sob_name := all_text;
543: p_select_le_name := all_text;
544: p_select_ou_name := all_text;