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

Line 324: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),

320: AND gl.conversion_type (+) = NVL(poa.rate_type, 'Corporate')
321: AND poa.purchase_creation_date < p_end_date + 1
322: AND poa.purchase_creation_date >= p_start_date;
323:
324: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
325: l_leakage_percent, p_value_tbl);
326: insert_row('L_CHAR_ATTR1',
327: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
328: l_total_purchases, p_value_tbl);

Line 327: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),

323:
324: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
325: l_leakage_percent, p_value_tbl);
326: insert_row('L_CHAR_ATTR1',
327: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
328: l_total_purchases, p_value_tbl);
329: insert_row('L_CHAR_ATTR2',
330: fnd_message.get_string('POA', 'POA_LEAKAGE'),
331: l_leakage_amount, p_value_tbl);

Line 330: fnd_message.get_string('POA', 'POA_LEAKAGE'),

326: insert_row('L_CHAR_ATTR1',
327: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
328: l_total_purchases, p_value_tbl);
329: insert_row('L_CHAR_ATTR2',
330: fnd_message.get_string('POA', 'POA_LEAKAGE'),
331: l_leakage_amount, p_value_tbl);
332: insert_row('L_CHAR_ATTR3',
333: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
334: l_potential_savings, p_value_tbl);

Line 333: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),

329: insert_row('L_CHAR_ATTR2',
330: fnd_message.get_string('POA', 'POA_LEAKAGE'),
331: l_leakage_amount, p_value_tbl);
332: insert_row('L_CHAR_ATTR3',
333: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
334: l_potential_savings, p_value_tbl);
335: insert_row('L_CURRENCY',
336: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
337:

Line 336: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);

332: insert_row('L_CHAR_ATTR3',
333: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
334: l_potential_savings, p_value_tbl);
335: insert_row('L_CURRENCY',
336: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
337:
338: EXCEPTION
339: WHEN others THEN
340: POA_LOG.put_line('Error getting Actual:');

Line 382: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),

378: AND poa.operating_unit_id = p_org_id
379: AND poa.purchase_creation_date < p_end_date + 1
380: AND poa.purchase_creation_date >= p_start_date;
381:
382: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
383: l_leakage_percent, p_value_tbl);
384: insert_row('L_CHAR_ATTR1',
385: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
386: l_total_purchases, p_value_tbl);

Line 385: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),

381:
382: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
383: l_leakage_percent, p_value_tbl);
384: insert_row('L_CHAR_ATTR1',
385: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
386: l_total_purchases, p_value_tbl);
387: insert_row('L_CHAR_ATTR2',
388: fnd_message.get_string('POA', 'POA_LEAKAGE'),
389: l_leakage_amount, p_value_tbl);

Line 388: fnd_message.get_string('POA', 'POA_LEAKAGE'),

384: insert_row('L_CHAR_ATTR1',
385: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
386: l_total_purchases, p_value_tbl);
387: insert_row('L_CHAR_ATTR2',
388: fnd_message.get_string('POA', 'POA_LEAKAGE'),
389: l_leakage_amount, p_value_tbl);
390: insert_row('L_CHAR_ATTR3',
391: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
392: l_potential_savings, p_value_tbl);

Line 391: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),

387: insert_row('L_CHAR_ATTR2',
388: fnd_message.get_string('POA', 'POA_LEAKAGE'),
389: l_leakage_amount, p_value_tbl);
390: insert_row('L_CHAR_ATTR3',
391: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
392: l_potential_savings, p_value_tbl);
393: insert_row('L_CURRENCY',
394: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
395:

Line 394: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);

390: insert_row('L_CHAR_ATTR3',
391: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
392: l_potential_savings, p_value_tbl);
393: insert_row('L_CURRENCY',
394: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
395:
396: EXCEPTION
397: WHEN others THEN
398: POA_LOG.put_line('Error getting Actual:');

Line 440: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),

436: AND poa.ship_to_organization_id = p_org_id
437: AND poa.purchase_creation_date < p_end_date + 1
438: AND poa.purchase_creation_date >= p_start_date;
439:
440: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
441: l_leakage_percent, p_value_tbl);
442: insert_row('L_CHAR_ATTR1',
443: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
444: l_total_purchases, p_value_tbl);

Line 443: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),

439:
440: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
441: l_leakage_percent, p_value_tbl);
442: insert_row('L_CHAR_ATTR1',
443: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
444: l_total_purchases, p_value_tbl);
445: insert_row('L_CHAR_ATTR2',
446: fnd_message.get_string('POA', 'POA_LEAKAGE'),
447: l_leakage_amount, p_value_tbl);

Line 446: fnd_message.get_string('POA', 'POA_LEAKAGE'),

442: insert_row('L_CHAR_ATTR1',
443: fnd_message.get_string('POA', 'POA_TOTAL_PURCHASES'),
444: l_total_purchases, p_value_tbl);
445: insert_row('L_CHAR_ATTR2',
446: fnd_message.get_string('POA', 'POA_LEAKAGE'),
447: l_leakage_amount, p_value_tbl);
448: insert_row('L_CHAR_ATTR3',
449: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
450: l_potential_savings, p_value_tbl);

Line 449: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),

445: insert_row('L_CHAR_ATTR2',
446: fnd_message.get_string('POA', 'POA_LEAKAGE'),
447: l_leakage_amount, p_value_tbl);
448: insert_row('L_CHAR_ATTR3',
449: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
450: l_potential_savings, p_value_tbl);
451: insert_row('L_CURRENCY',
452: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
453:

Line 452: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);

448: insert_row('L_CHAR_ATTR3',
449: fnd_message.get_string('POA', 'POA_TOTAL_SAVINGS'),
450: l_potential_savings, p_value_tbl);
451: insert_row('L_CURRENCY',
452: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
453:
454: EXCEPTION
455: WHEN others THEN
456: POA_LOG.put_line('Error getting Actual:');

Line 487: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),

483: and poa.transaction_date < p_end_date + 1
484: and poa.transaction_date >= p_start_date
485: and poa.ou_id = p_org_id;
486:
487: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
488: l_actual, p_value_tbl);
489: insert_row('L_CURRENCY',
490: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
491:

Line 490: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);

486:
487: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
488: l_actual, p_value_tbl);
489: insert_row('L_CURRENCY',
490: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
491:
492: EXCEPTION
493: WHEN others THEN
494: POA_LOG.put_line('Error getting Actual:');

Line 523: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),

519: and gl.conversion_type (+) = 'Corporate'
520: and poa.transaction_date < p_end_date + 1
521: and poa.transaction_date >= p_start_date;
522:
523: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
524: l_actual, p_value_tbl);
525: insert_row('L_CURRENCY',
526: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
527:

Line 526: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);

522:
523: insert_row('L_ACTUAL', fnd_message.get_string('PO', 'POA_ACTUAL'),
524: l_actual, p_value_tbl);
525: insert_row('L_CURRENCY',
526: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
527:
528: EXCEPTION
529: WHEN others THEN
530: POA_LOG.put_line('Error getting Actual:');

Line 866: insert_row('L_SUBJECT', fnd_message.get_string('POA',

862: l_range_high := l_target_rec.target*(1+l_target_rec.range1_high/100);
863:
864: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
865: POA_LOG.debug_line('Outside Range 1');
866: insert_row('L_SUBJECT', fnd_message.get_string('POA',
867: 'POA_' || UPPER(l_measure_short_name) || '_SUBJECT'), '(' ||
868: fnd_message.get_string('PO','POA_ACTUAL') || ': ' || l_value ||
869: ' ' || fnd_message.get_string('PO','POA_TARGET') || ': ' ||
870: to_char(l_target_rec.target,POA_BIS_ALERTS.g_percent_mask) || ')',

Line 868: fnd_message.get_string('PO','POA_ACTUAL') || ': ' || l_value ||

864: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
865: POA_LOG.debug_line('Outside Range 1');
866: insert_row('L_SUBJECT', fnd_message.get_string('POA',
867: 'POA_' || UPPER(l_measure_short_name) || '_SUBJECT'), '(' ||
868: fnd_message.get_string('PO','POA_ACTUAL') || ': ' || l_value ||
869: ' ' || fnd_message.get_string('PO','POA_TARGET') || ': ' ||
870: to_char(l_target_rec.target,POA_BIS_ALERTS.g_percent_mask) || ')',
871: l_value_tbl);
872: insert_row('L_TARGET_LEVEL',

Line 869: ' ' || fnd_message.get_string('PO','POA_TARGET') || ': ' ||

865: POA_LOG.debug_line('Outside Range 1');
866: insert_row('L_SUBJECT', fnd_message.get_string('POA',
867: 'POA_' || UPPER(l_measure_short_name) || '_SUBJECT'), '(' ||
868: fnd_message.get_string('PO','POA_ACTUAL') || ': ' || l_value ||
869: ' ' || fnd_message.get_string('PO','POA_TARGET') || ': ' ||
870: to_char(l_target_rec.target,POA_BIS_ALERTS.g_percent_mask) || ')',
871: l_value_tbl);
872: insert_row('L_TARGET_LEVEL',
873: fnd_message.get_string('POA','POA_TARGET_LEVEL'),

Line 873: fnd_message.get_string('POA','POA_TARGET_LEVEL'),

869: ' ' || fnd_message.get_string('PO','POA_TARGET') || ': ' ||
870: to_char(l_target_rec.target,POA_BIS_ALERTS.g_percent_mask) || ')',
871: l_value_tbl);
872: insert_row('L_TARGET_LEVEL',
873: fnd_message.get_string('POA','POA_TARGET_LEVEL'),
874: l_target_level_name, l_value_tbl);
875: get_org_name(to_number(l_target_orgs(l_index).org_level_value_id),
876: l_org_name);
877: insert_row('L_ORG',

Line 878: fnd_message.get_string('PO','POA_ORGANIZATION'), l_org_name,

874: l_target_level_name, l_value_tbl);
875: get_org_name(to_number(l_target_orgs(l_index).org_level_value_id),
876: l_org_name);
877: insert_row('L_ORG',
878: fnd_message.get_string('PO','POA_ORGANIZATION'), l_org_name,
879: l_value_tbl);
880: insert_row('L_PERIOD',
881: fnd_message.get_string('PO','POA_PERIOD'), l_period_name,
882: l_value_tbl);

Line 881: fnd_message.get_string('PO','POA_PERIOD'), l_period_name,

877: insert_row('L_ORG',
878: fnd_message.get_string('PO','POA_ORGANIZATION'), l_org_name,
879: l_value_tbl);
880: insert_row('L_PERIOD',
881: fnd_message.get_string('PO','POA_PERIOD'), l_period_name,
882: l_value_tbl);
883: insert_row('L_TARGET',
884: fnd_message.get_string('PO','POA_TARGET'),
885: to_char(l_target_rec.target, POA_BIS_ALERTS.g_percent_mask),

Line 884: fnd_message.get_string('PO','POA_TARGET'),

880: insert_row('L_PERIOD',
881: fnd_message.get_string('PO','POA_PERIOD'), l_period_name,
882: l_value_tbl);
883: insert_row('L_TARGET',
884: fnd_message.get_string('PO','POA_TARGET'),
885: to_char(l_target_rec.target, POA_BIS_ALERTS.g_percent_mask),
886: l_value_tbl);
887: insert_row('L_TARGET_RANGE',
888: fnd_message.get_string('POA','POA_TARGET_RANGE'),

Line 888: fnd_message.get_string('POA','POA_TARGET_RANGE'),

884: fnd_message.get_string('PO','POA_TARGET'),
885: to_char(l_target_rec.target, POA_BIS_ALERTS.g_percent_mask),
886: l_value_tbl);
887: insert_row('L_TARGET_RANGE',
888: fnd_message.get_string('POA','POA_TARGET_RANGE'),
889: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
890: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
891: insert_row('L_THANKS',
892: fnd_message.get_string('POA','POA_THANKS'), NULL, l_value_tbl);

Line 892: fnd_message.get_string('POA','POA_THANKS'), NULL, l_value_tbl);

888: fnd_message.get_string('POA','POA_TARGET_RANGE'),
889: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
890: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
891: insert_row('L_THANKS',
892: fnd_message.get_string('POA','POA_THANKS'), NULL, l_value_tbl);
893: insert_row('L_SENDER', l_app_name, NULL, l_value_tbl);
894: get_report_param(p_target_level_short_name,
895: to_number(l_target_orgs(l_index).org_level_value_id),
896: l_start_date, l_end_date, l_period_type, l_param);

Line 916: fnd_message.get_string('POA','POA_TARGET_RANGE'),

912:
913: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
914: POA_LOG.debug_line('Outside Range 2');
915: set_value('L_TARGET_RANGE',
916: fnd_message.get_string('POA','POA_TARGET_RANGE'),
917: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
918: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
919: get_report_param(p_target_level_short_name,
920: to_number(l_target_orgs(l_index).org_level_value_id),

Line 942: fnd_message.get_string('POA','POA_TARGET_RANGE'),

938:
939: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
940: POA_LOG.debug_line('Outside Range 3');
941: set_value('L_TARGET_RANGE',
942: fnd_message.get_string('POA','POA_TARGET_RANGE'),
943: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
944: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
945: get_report_param(p_target_level_short_name,
946: to_number(l_target_orgs(l_index).org_level_value_id),