DBA Data[Home] [Help]

APPS.WIP_BIS_YDSP_ALERT dependencies on FND_MESSAGE

Line 279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');

275: status Varchar2(30);
276: l_param varchar2(2000);
277: BEGIN
278:
279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;

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

276: l_param varchar2(2000);
277: BEGIN
278:
279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||

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

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

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

278:
279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;

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

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

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

282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;

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

283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||

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

285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')

Line 291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||

287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')

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

289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
296: || ': ' || round(actual, 2);
297: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')

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

291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
296: || ': ' || round(actual, 2);
297: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')
298: || ': ' || round(target, 2);
299:

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

293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
296: || ': ' || round(actual, 2);
297: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')
298: || ': ' || round(target, 2);
299:
300: l_param := 'P_PARAM_FROM_DATE=' ||
301: to_char(start_date, 'DD-MON-YYYY') ||

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

442: l_resp_name VARCHAR2(100);
443: BEGIN
444:
445: /* initialize the all text */
446: all_text := '''' || FND_MESSAGE.get_string('WIP', 'WIP_ALL') || '''';
447:
448: p_select_sob_name := all_text;
449: p_select_le_name := all_text;
450: p_select_ou_name := all_text;