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

Line 337: l_subject := fnd_message.get_string('OE', 'OE_BIS_SUBJECT') || ' - ' || cr.target_level_name;

333:
334: -- Messages are seeded using Oracle Apps screens - so that customer can change the heading on the messages
335: -- as per requirements
336:
337: l_subject := fnd_message.get_string('OE', 'OE_BIS_SUBJECT') || ' - ' || cr.target_level_name;
338: l_set_of_books_id := fnd_message.get_string('OE', 'OE_BIS_SET_OF_BOOKS') || ': ' || cr.org_level_value_id ||
339: ' - ' || l_org_name;
340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;
341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;

Line 338: l_set_of_books_id := fnd_message.get_string('OE', 'OE_BIS_SET_OF_BOOKS') || ': ' || cr.org_level_value_id ||

334: -- Messages are seeded using Oracle Apps screens - so that customer can change the heading on the messages
335: -- as per requirements
336:
337: l_subject := fnd_message.get_string('OE', 'OE_BIS_SUBJECT') || ' - ' || cr.target_level_name;
338: l_set_of_books_id := fnd_message.get_string('OE', 'OE_BIS_SET_OF_BOOKS') || ': ' || cr.org_level_value_id ||
339: ' - ' || l_org_name;
340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;
341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;
342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;

Line 340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;

336:
337: l_subject := fnd_message.get_string('OE', 'OE_BIS_SUBJECT') || ' - ' || cr.target_level_name;
338: l_set_of_books_id := fnd_message.get_string('OE', 'OE_BIS_SET_OF_BOOKS') || ': ' || cr.org_level_value_id ||
339: ' - ' || l_org_name;
340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;
341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;
342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;
343: l_period := fnd_message.get_string('OE', 'OE_BIS_PERIOD')|| ': ' || p_time_period;
344: l_actual := fnd_message.get_string('OE', 'OE_BIS_ACTUAL')|| ': ' || round(actual, 2);

Line 341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;

337: l_subject := fnd_message.get_string('OE', 'OE_BIS_SUBJECT') || ' - ' || cr.target_level_name;
338: l_set_of_books_id := fnd_message.get_string('OE', 'OE_BIS_SET_OF_BOOKS') || ': ' || cr.org_level_value_id ||
339: ' - ' || l_org_name;
340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;
341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;
342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;
343: l_period := fnd_message.get_string('OE', 'OE_BIS_PERIOD')|| ': ' || p_time_period;
344: l_actual := fnd_message.get_string('OE', 'OE_BIS_ACTUAL')|| ': ' || round(actual, 2);
345: l_target := fnd_message.get_string('OE', 'OE_BIS_TARGET')|| ': ' || round(target, 2);

Line 342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;

338: l_set_of_books_id := fnd_message.get_string('OE', 'OE_BIS_SET_OF_BOOKS') || ': ' || cr.org_level_value_id ||
339: ' - ' || l_org_name;
340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;
341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;
342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;
343: l_period := fnd_message.get_string('OE', 'OE_BIS_PERIOD')|| ': ' || p_time_period;
344: l_actual := fnd_message.get_string('OE', 'OE_BIS_ACTUAL')|| ': ' || round(actual, 2);
345: l_target := fnd_message.get_string('OE', 'OE_BIS_TARGET')|| ': ' || round(target, 2);
346:

Line 343: l_period := fnd_message.get_string('OE', 'OE_BIS_PERIOD')|| ': ' || p_time_period;

339: ' - ' || l_org_name;
340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;
341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;
342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;
343: l_period := fnd_message.get_string('OE', 'OE_BIS_PERIOD')|| ': ' || p_time_period;
344: l_actual := fnd_message.get_string('OE', 'OE_BIS_ACTUAL')|| ': ' || round(actual, 2);
345: l_target := fnd_message.get_string('OE', 'OE_BIS_TARGET')|| ': ' || round(target, 2);
346:
347: -- Reverting back because the report needs to be called with the right parameters.

Line 344: l_actual := fnd_message.get_string('OE', 'OE_BIS_ACTUAL')|| ': ' || round(actual, 2);

340: l_area := fnd_message.get_string('OE', 'OE_BIS_AREA') || ': ' || dim3_name;
341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;
342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;
343: l_period := fnd_message.get_string('OE', 'OE_BIS_PERIOD')|| ': ' || p_time_period;
344: l_actual := fnd_message.get_string('OE', 'OE_BIS_ACTUAL')|| ': ' || round(actual, 2);
345: l_target := fnd_message.get_string('OE', 'OE_BIS_TARGET')|| ': ' || round(target, 2);
346:
347: -- Reverting back because the report needs to be called with the right parameters.
348:

Line 345: l_target := fnd_message.get_string('OE', 'OE_BIS_TARGET')|| ': ' || round(target, 2);

341: l_prod_catg := fnd_message.get_string('OE', 'OE_BIS_PROD_CATEGORY') || ': ' || dim2_name;
342: l_sales_channel := fnd_message.get_string('OE', 'OE_BIS_SALES_CHANNEL') || ': ' || dim1_name;
343: l_period := fnd_message.get_string('OE', 'OE_BIS_PERIOD')|| ': ' || p_time_period;
344: l_actual := fnd_message.get_string('OE', 'OE_BIS_ACTUAL')|| ': ' || round(actual, 2);
345: l_target := fnd_message.get_string('OE', 'OE_BIS_TARGET')|| ': ' || round(target, 2);
346:
347: -- Reverting back because the report needs to be called with the right parameters.
348:
349: if cr.dim1_level_value_id = '-1' then