701:
702:
703: function translate_all RETURN VARCHAR2 IS
704: BEGIN
705: fnd_message.set_name ('HRI','HR_BIS_ALL');
706: RETURN fnd_message.get;
707: END;
708:
709:
702:
703: function translate_all RETURN VARCHAR2 IS
704: BEGIN
705: fnd_message.set_name ('HRI','HR_BIS_ALL');
706: RETURN fnd_message.get;
707: END;
708:
709:
710: -------------------------------------------------------------------------
1373: -- ---------------------------------------------------------------------
1374: --
1375: -- Build subject message text
1376: --
1377: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_SUBJECT');
1378: l_subject := fnd_message.get;
1379: --
1380: -- Build the body message text
1381: --
1374: --
1375: -- Build subject message text
1376: --
1377: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_SUBJECT');
1378: l_subject := fnd_message.get;
1379: --
1380: -- Build the body message text
1381: --
1382: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_MSG');
1378: l_subject := fnd_message.get;
1379: --
1380: -- Build the body message text
1381: --
1382: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_MSG');
1383: fnd_message.set_token('ORGANIZATION',l_org_name);
1384: fnd_message.set_token('PERIOD', l_period_name);
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1379: --
1380: -- Build the body message text
1381: --
1382: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_MSG');
1383: fnd_message.set_token('ORGANIZATION',l_org_name);
1384: fnd_message.set_token('PERIOD', l_period_name);
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1387: fnd_message.set_token('ACTUAL',p_actual);
1380: -- Build the body message text
1381: --
1382: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_MSG');
1383: fnd_message.set_token('ORGANIZATION',l_org_name);
1384: fnd_message.set_token('PERIOD', l_period_name);
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1387: fnd_message.set_token('ACTUAL',p_actual);
1388: --fnd_message.set_token('ROLE',l_resp_name);
1381: --
1382: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_MSG');
1383: fnd_message.set_token('ORGANIZATION',l_org_name);
1384: fnd_message.set_token('PERIOD', l_period_name);
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1387: fnd_message.set_token('ACTUAL',p_actual);
1388: --fnd_message.set_token('ROLE',l_resp_name);
1389: l_message := fnd_message.get;
1382: fnd_message.set_name('HRI','HR_BIS_PMF_HRMSP_MSG');
1383: fnd_message.set_token('ORGANIZATION',l_org_name);
1384: fnd_message.set_token('PERIOD', l_period_name);
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1387: fnd_message.set_token('ACTUAL',p_actual);
1388: --fnd_message.set_token('ROLE',l_resp_name);
1389: l_message := fnd_message.get;
1390: pl(' Message:',l_message);
1383: fnd_message.set_token('ORGANIZATION',l_org_name);
1384: fnd_message.set_token('PERIOD', l_period_name);
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1387: fnd_message.set_token('ACTUAL',p_actual);
1388: --fnd_message.set_token('ROLE',l_resp_name);
1389: l_message := fnd_message.get;
1390: pl(' Message:',l_message);
1391: -- ---------------------------------------------------------------------
1384: fnd_message.set_token('PERIOD', l_period_name);
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1387: fnd_message.set_token('ACTUAL',p_actual);
1388: --fnd_message.set_token('ROLE',l_resp_name);
1389: l_message := fnd_message.get;
1390: pl(' Message:',l_message);
1391: -- ---------------------------------------------------------------------
1392: -- 4. build the report parameter string
1385: fnd_message.set_token('BUDGET',l_bmt_name);
1386: fnd_message.set_token('TARGET',p_target);
1387: fnd_message.set_token('ACTUAL',p_actual);
1388: --fnd_message.set_token('ROLE',l_resp_name);
1389: l_message := fnd_message.get;
1390: pl(' Message:',l_message);
1391: -- ---------------------------------------------------------------------
1392: -- 4. build the report parameter string
1393: -- ---------------------------------------------------------------------
1847: --
1848: -- Build subject message text
1849: --
1850: IF p_type = 'ABOVE' THEN
1851: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_HIGH_SUBJECT');
1852: l_subject := fnd_message.get;
1853: ELSE
1854: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_SUBJECT');
1855: l_subject := fnd_message.get;
1848: -- Build subject message text
1849: --
1850: IF p_type = 'ABOVE' THEN
1851: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_HIGH_SUBJECT');
1852: l_subject := fnd_message.get;
1853: ELSE
1854: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_SUBJECT');
1855: l_subject := fnd_message.get;
1856: END IF;
1850: IF p_type = 'ABOVE' THEN
1851: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_HIGH_SUBJECT');
1852: l_subject := fnd_message.get;
1853: ELSE
1854: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_SUBJECT');
1855: l_subject := fnd_message.get;
1856: END IF;
1857: --
1858: -- Build the body message text
1851: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_HIGH_SUBJECT');
1852: l_subject := fnd_message.get;
1853: ELSE
1854: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_SUBJECT');
1855: l_subject := fnd_message.get;
1856: END IF;
1857: --
1858: -- Build the body message text
1859: --
1857: --
1858: -- Build the body message text
1859: --
1860: IF p_type = 'ABOVE' THEN
1861: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_HIGH_MSG');
1862: ELSE
1863: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_MSG');
1864: END IF;
1865: fnd_message.set_token('ORGANIZATION',l_org_name);
1859: --
1860: IF p_type = 'ABOVE' THEN
1861: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_HIGH_MSG');
1862: ELSE
1863: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_MSG');
1864: END IF;
1865: fnd_message.set_token('ORGANIZATION',l_org_name);
1866: fnd_message.set_token('JOB',l_job_name);
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1861: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_HIGH_MSG');
1862: ELSE
1863: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_MSG');
1864: END IF;
1865: fnd_message.set_token('ORGANIZATION',l_org_name);
1866: fnd_message.set_token('JOB',l_job_name);
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1862: ELSE
1863: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_MSG');
1864: END IF;
1865: fnd_message.set_token('ORGANIZATION',l_org_name);
1866: fnd_message.set_token('JOB',l_job_name);
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1863: fnd_message.set_name('HRI','HR_BIS_PMF_HRMVR_LOW_MSG');
1864: END IF;
1865: fnd_message.set_token('ORGANIZATION',l_org_name);
1866: fnd_message.set_token('JOB',l_job_name);
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1864: END IF;
1865: fnd_message.set_token('ORGANIZATION',l_org_name);
1866: fnd_message.set_token('JOB',l_job_name);
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1872: fnd_message.set_token('ACTUAL',p_actual);
1865: fnd_message.set_token('ORGANIZATION',l_org_name);
1866: fnd_message.set_token('JOB',l_job_name);
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1872: fnd_message.set_token('ACTUAL',p_actual);
1873: --fnd_message.set_token('ROLE',l_resp_name);
1866: fnd_message.set_token('JOB',l_job_name);
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1872: fnd_message.set_token('ACTUAL',p_actual);
1873: --fnd_message.set_token('ROLE',l_resp_name);
1874: l_message := fnd_message.get;
1867: fnd_message.set_token('CATEGORY',l_job_cat);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1872: fnd_message.set_token('ACTUAL',p_actual);
1873: --fnd_message.set_token('ROLE',l_resp_name);
1874: l_message := fnd_message.get;
1875: pl(' Message:',l_message);
1868: fnd_message.set_token('LOCATION',l_loc_name);
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1872: fnd_message.set_token('ACTUAL',p_actual);
1873: --fnd_message.set_token('ROLE',l_resp_name);
1874: l_message := fnd_message.get;
1875: pl(' Message:',l_message);
1876:
1869: fnd_message.set_token('PERIOD',l_period_name);
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1872: fnd_message.set_token('ACTUAL',p_actual);
1873: --fnd_message.set_token('ROLE',l_resp_name);
1874: l_message := fnd_message.get;
1875: pl(' Message:',l_message);
1876:
1877: -- ---------------------------------------------------------------------
1870: fnd_message.set_token('BUDGET',l_bmt_name);
1871: fnd_message.set_token('TARGET',p_target);
1872: fnd_message.set_token('ACTUAL',p_actual);
1873: --fnd_message.set_token('ROLE',l_resp_name);
1874: l_message := fnd_message.get;
1875: pl(' Message:',l_message);
1876:
1877: -- ---------------------------------------------------------------------
1878: -- 4. build the report parameter string
2489: -- ---------------------------------------------------------------------
2490: --
2491: -- Build subject message text
2492: --
2493: fnd_message.set_name('HRI','HR_BIS_PMF_HRRCS_SUBJECT');
2494: l_subject := fnd_message.get;
2495: --
2496: -- Add Percent signs to actual values
2497: --
2490: --
2491: -- Build subject message text
2492: --
2493: fnd_message.set_name('HRI','HR_BIS_PMF_HRRCS_SUBJECT');
2494: l_subject := fnd_message.get;
2495: --
2496: -- Add Percent signs to actual values
2497: --
2498: l_actual := to_char(p_actual)||'%';
2499: l_target := to_char(p_target)||'%';
2500: --
2501: -- Build the body message text
2502: --
2503: fnd_message.set_name('HRI','HR_BIS_PMF_HRRCS_MSG');
2504: fnd_message.set_token('ORGANIZATION',l_org_name);
2505: fnd_message.set_token('LOCATION',l_loc_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2500: --
2501: -- Build the body message text
2502: --
2503: fnd_message.set_name('HRI','HR_BIS_PMF_HRRCS_MSG');
2504: fnd_message.set_token('ORGANIZATION',l_org_name);
2505: fnd_message.set_token('LOCATION',l_loc_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2508: fnd_message.set_token('PERIOD',l_period_name);
2501: -- Build the body message text
2502: --
2503: fnd_message.set_name('HRI','HR_BIS_PMF_HRRCS_MSG');
2504: fnd_message.set_token('ORGANIZATION',l_org_name);
2505: fnd_message.set_token('LOCATION',l_loc_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2508: fnd_message.set_token('PERIOD',l_period_name);
2509: fnd_message.set_token('TARGET',l_target);
2502: --
2503: fnd_message.set_name('HRI','HR_BIS_PMF_HRRCS_MSG');
2504: fnd_message.set_token('ORGANIZATION',l_org_name);
2505: fnd_message.set_token('LOCATION',l_loc_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2508: fnd_message.set_token('PERIOD',l_period_name);
2509: fnd_message.set_token('TARGET',l_target);
2510: fnd_message.set_token('ACTUAL',l_actual);
2503: fnd_message.set_name('HRI','HR_BIS_PMF_HRRCS_MSG');
2504: fnd_message.set_token('ORGANIZATION',l_org_name);
2505: fnd_message.set_token('LOCATION',l_loc_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2508: fnd_message.set_token('PERIOD',l_period_name);
2509: fnd_message.set_token('TARGET',l_target);
2510: fnd_message.set_token('ACTUAL',l_actual);
2511: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2504: fnd_message.set_token('ORGANIZATION',l_org_name);
2505: fnd_message.set_token('LOCATION',l_loc_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2508: fnd_message.set_token('PERIOD',l_period_name);
2509: fnd_message.set_token('TARGET',l_target);
2510: fnd_message.set_token('ACTUAL',l_actual);
2511: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2512: fnd_message.set_token('BUDGET',l_bmt_name);
2505: fnd_message.set_token('LOCATION',l_loc_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2508: fnd_message.set_token('PERIOD',l_period_name);
2509: fnd_message.set_token('TARGET',l_target);
2510: fnd_message.set_token('ACTUAL',l_actual);
2511: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2512: fnd_message.set_token('BUDGET',l_bmt_name);
2513: --fnd_message.set_token('ROLE',l_resp_name);
2506: fnd_message.set_token('JOB',l_job_name);
2507: fnd_message.set_token('CATEGORY',l_job_cat);
2508: fnd_message.set_token('PERIOD',l_period_name);
2509: fnd_message.set_token('TARGET',l_target);
2510: fnd_message.set_token('ACTUAL',l_actual);
2511: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2512: fnd_message.set_token('BUDGET',l_bmt_name);
2513: --fnd_message.set_token('ROLE',l_resp_name);
2514: l_message := fnd_message.get;
2508: fnd_message.set_token('PERIOD',l_period_name);
2509: fnd_message.set_token('TARGET',l_target);
2510: fnd_message.set_token('ACTUAL',l_actual);
2511: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2512: fnd_message.set_token('BUDGET',l_bmt_name);
2513: --fnd_message.set_token('ROLE',l_resp_name);
2514: l_message := fnd_message.get;
2515: pl(' Message:',l_message);
2516:
2509: fnd_message.set_token('TARGET',l_target);
2510: fnd_message.set_token('ACTUAL',l_actual);
2511: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2512: fnd_message.set_token('BUDGET',l_bmt_name);
2513: --fnd_message.set_token('ROLE',l_resp_name);
2514: l_message := fnd_message.get;
2515: pl(' Message:',l_message);
2516:
2517: -- ---------------------------------------------------------------------
2510: fnd_message.set_token('ACTUAL',l_actual);
2511: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2512: fnd_message.set_token('BUDGET',l_bmt_name);
2513: --fnd_message.set_token('ROLE',l_resp_name);
2514: l_message := fnd_message.get;
2515: pl(' Message:',l_message);
2516:
2517: -- ---------------------------------------------------------------------
2518: -- 4. build the report parameter string
2997: -- ---------------------------------------------------------------------
2998: --
2999: -- Build subject message text
3000: --
3001: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_SUBJECT');
3002: l_subject := fnd_message.get;
3003: --
3004: -- Build the body message text
3005: --
2998: --
2999: -- Build subject message text
3000: --
3001: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_SUBJECT');
3002: l_subject := fnd_message.get;
3003: --
3004: -- Build the body message text
3005: --
3006: -- If the target has the activity version (i.e. the name of the training course) set
3008: -- training report this is because the training report does not have the activity
3009: -- version as a parameter
3010: --
3011: IF p_target_rec.dim3_level_short_name = 'TOTAL ACTIVITY VERSIONS' THEN
3012: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG');
3013: ELSE
3014: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG_NO_URL');
3015: END IF;
3016: fnd_message.set_token('ORGANIZATION',l_org_name);
3010: --
3011: IF p_target_rec.dim3_level_short_name = 'TOTAL ACTIVITY VERSIONS' THEN
3012: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG');
3013: ELSE
3014: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG_NO_URL');
3015: END IF;
3016: fnd_message.set_token('ORGANIZATION',l_org_name);
3017: fnd_message.set_token('LOCATION',l_loc_name);
3018: fnd_message.set_token('JOB',l_job_name);
3012: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG');
3013: ELSE
3014: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG_NO_URL');
3015: END IF;
3016: fnd_message.set_token('ORGANIZATION',l_org_name);
3017: fnd_message.set_token('LOCATION',l_loc_name);
3018: fnd_message.set_token('JOB',l_job_name);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3013: ELSE
3014: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG_NO_URL');
3015: END IF;
3016: fnd_message.set_token('ORGANIZATION',l_org_name);
3017: fnd_message.set_token('LOCATION',l_loc_name);
3018: fnd_message.set_token('JOB',l_job_name);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3014: fnd_message.set_name('HRI','HR_BIS_PMF_HRTRS_MSG_NO_URL');
3015: END IF;
3016: fnd_message.set_token('ORGANIZATION',l_org_name);
3017: fnd_message.set_token('LOCATION',l_loc_name);
3018: fnd_message.set_token('JOB',l_job_name);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3015: END IF;
3016: fnd_message.set_token('ORGANIZATION',l_org_name);
3017: fnd_message.set_token('LOCATION',l_loc_name);
3018: fnd_message.set_token('JOB',l_job_name);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3023: fnd_message.set_token('ACTUAL',l_actual);
3016: fnd_message.set_token('ORGANIZATION',l_org_name);
3017: fnd_message.set_token('LOCATION',l_loc_name);
3018: fnd_message.set_token('JOB',l_job_name);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3023: fnd_message.set_token('ACTUAL',l_actual);
3024: --fnd_message.set_token('ROLE',l_resp_name);
3017: fnd_message.set_token('LOCATION',l_loc_name);
3018: fnd_message.set_token('JOB',l_job_name);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3023: fnd_message.set_token('ACTUAL',l_actual);
3024: --fnd_message.set_token('ROLE',l_resp_name);
3025: l_message := fnd_message.get;
3018: fnd_message.set_token('JOB',l_job_name);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3023: fnd_message.set_token('ACTUAL',l_actual);
3024: --fnd_message.set_token('ROLE',l_resp_name);
3025: l_message := fnd_message.get;
3026: pl(' Message:', l_message);
3019: fnd_message.set_token('CATEGORY',l_job_cat);
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3023: fnd_message.set_token('ACTUAL',l_actual);
3024: --fnd_message.set_token('ROLE',l_resp_name);
3025: l_message := fnd_message.get;
3026: pl(' Message:', l_message);
3027:
3020: fnd_message.set_token('ACTIVITY',l_activity_version_name);
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3023: fnd_message.set_token('ACTUAL',l_actual);
3024: --fnd_message.set_token('ROLE',l_resp_name);
3025: l_message := fnd_message.get;
3026: pl(' Message:', l_message);
3027:
3028: -- ---------------------------------------------------------------------
3021: fnd_message.set_token('PERIOD',l_period_name);
3022: fnd_message.set_token('TARGET',l_target);
3023: fnd_message.set_token('ACTUAL',l_actual);
3024: --fnd_message.set_token('ROLE',l_resp_name);
3025: l_message := fnd_message.get;
3026: pl(' Message:', l_message);
3027:
3028: -- ---------------------------------------------------------------------
3029: -- 4. build the report parameter string