DBA Data[Home] [Help]

APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on HR_GENERAL

Line 60: and p_effective_date between ver.date_from and nvl(date_to, hr_general.end_of_time);

56: str.position_control_structure_flg = 'Y'
57: and str.business_group_id = p_business_group_id
58: and ver.business_group_id = p_business_group_id
59: and str.organization_structure_id = ver.organization_structure_id
60: and p_effective_date between ver.date_from and nvl(date_to, hr_general.end_of_time);
61:
62: --
63: -- Cursor toFetch the Organizations for the given Organization Hierarchy
64: --

Line 259: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE','MONEY'));

255: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
256: --
257: l_message_type_cd := pqh_utility.get_message_type_cd;
258: pqh_utility.set_message_token('UOM',
259: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE','MONEY'));
260: pqh_utility.set_message_token('ENTITY',
261: hr_general.decode_lookup('PQH_BUDGET_ENTITY','POSITION'));
262:
263: l_message := pqh_utility.get_message;

Line 261: hr_general.decode_lookup('PQH_BUDGET_ENTITY','POSITION'));

257: l_message_type_cd := pqh_utility.get_message_type_cd;
258: pqh_utility.set_message_token('UOM',
259: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE','MONEY'));
260: pqh_utility.set_message_token('ENTITY',
261: hr_general.decode_lookup('PQH_BUDGET_ENTITY','POSITION'));
262:
263: l_message := pqh_utility.get_message;
264: --
265: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);

Line 282: hr_general.decode_organization(l_organization.organization_id), 105);

278: l_table_route_id, 105);
279: hr_utility.set_location('l_orglevel1: '||
280: l_organization.level1, 105);
281: hr_utility.set_location('org name: '||
282: hr_general.decode_organization(l_organization.organization_id), 105);
283: --
284: -- Set the Process Log Context level for the Organization
285: --
286: pqh_process_batch_log.set_context_level

Line 291: p_log_context =>hr_general.decode_organization(l_organization.organization_id)

287: (
288: p_txn_id =>l_organization.organization_id,
289: p_txn_table_route_id =>l_table_route_id,
290: p_level =>l_organization.level1 + 1,
291: p_log_context =>hr_general.decode_organization(l_organization.organization_id)
292: );
293: --
294: hr_utility.set_location('Organization : '||l_organization.organization_id
295: || ' ' ||l_proc_name, 110);

Line 396: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)

392: (
393: p_txn_id =>l_position.position_id,
394: p_txn_table_route_id =>l_table_route_id,
395: p_level =>l_organization.level1+2,
396: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)
397: );
398:
399: --
400: -- Insert the Log for the position

Line 432: hr_general.decode_position_latest_name(l_position.position_id);

428: --
429: hr_utility.set_location('l_user_name : '|| l_user_name, 1112);
430: --
431: l_parameter1_value :=
432: hr_general.decode_position_latest_name(l_position.position_id);
433: l_parameter2_value := p_batch_name;
434: l_parameter3_value := l_effective_date;
435: l_parameter4_value :=
436: hr_general.decode_organization(l_organization.organization_id);

Line 436: hr_general.decode_organization(l_organization.organization_id);

432: hr_general.decode_position_latest_name(l_position.position_id);
433: l_parameter2_value := p_batch_name;
434: l_parameter3_value := l_effective_date;
435: l_parameter4_value :=
436: hr_general.decode_organization(l_organization.organization_id);
437: l_parameter5_value :=
438: hr_general.decode_job(l_position.job_id);
439: l_parameter6_value := l_budgeted_sal;
440: l_parameter7_value := l_reallocation_sal;

Line 438: hr_general.decode_job(l_position.job_id);

434: l_parameter3_value := l_effective_date;
435: l_parameter4_value :=
436: hr_general.decode_organization(l_organization.organization_id);
437: l_parameter5_value :=
438: hr_general.decode_job(l_position.job_id);
439: l_parameter6_value := l_budgeted_sal;
440: l_parameter7_value := l_reallocation_sal;
441: l_parameter8_value := l_actual_sal;
442: l_parameter9_value := l_commitment_sal;

Line 754: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));

750: --
751: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', p_organization_id);
752: --
753: pqh_utility.set_message_token('UOM',
754: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
755: pqh_utility.set_message_token('ENTITY',
756: hr_general.decode_lookup('PQH_BUDGET_ENTITY','POSITION'));
757:
758: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);

Line 756: hr_general.decode_lookup('PQH_BUDGET_ENTITY','POSITION'));

752: --
753: pqh_utility.set_message_token('UOM',
754: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
755: pqh_utility.set_message_token('ENTITY',
756: hr_general.decode_lookup('PQH_BUDGET_ENTITY','POSITION'));
757:
758: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
759: --
760: l_message_type_cd := pqh_utility.get_message_type_cd;

Line 780: hr_general.decode_organization(p_organization_id), 105);

776: l_table_route_id, 105);
777: hr_utility.set_location('l_orglevel1: '||
778: p_level1, 105);
779: hr_utility.set_location('org name: '||
780: hr_general.decode_organization(p_organization_id), 105);
781: --
782: -- Set the Process Log Context level for the Organization
783: --
784: pqh_process_batch_log.set_context_level

Line 789: p_log_context =>hr_general.decode_organization(p_organization_id)

785: (
786: p_txn_id =>p_organization_id,
787: p_txn_table_route_id =>l_table_route_id,
788: p_level =>p_level1 + 1,
789: p_log_context =>hr_general.decode_organization(p_organization_id)
790: );
791: --
792: hr_utility.set_location('Organization : '||p_organization_id
793: || ' ' ||l_proc_name, 110);

Line 912: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)

908: (
909: p_txn_id =>l_position.position_id,
910: p_txn_table_route_id =>l_table_route_id,
911: p_level =>p_level1+2,
912: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)
913: );
914:
915: --
916: -- Insert the Log for the position

Line 954: hr_general.decode_position_latest_name(l_position.position_id);

950: --
951: hr_utility.set_location('l_user_name : '|| l_user_name, 1112);
952: --
953: l_parameter1_value :=
954: hr_general.decode_position_latest_name(l_position.position_id);
955: l_parameter2_value := p_batch_name;
956: l_parameter3_value := p_effective_date;
957: l_parameter4_value :=
958: hr_general.decode_organization(p_organization_id);

Line 958: hr_general.decode_organization(p_organization_id);

954: hr_general.decode_position_latest_name(l_position.position_id);
955: l_parameter2_value := p_batch_name;
956: l_parameter3_value := p_effective_date;
957: l_parameter4_value :=
958: hr_general.decode_organization(p_organization_id);
959: l_parameter5_value :=
960: hr_general.decode_job(l_position.job_id);
961: l_parameter6_value := l_budgeted_val;
962: l_parameter7_value := l_reallocation_val;

Line 960: hr_general.decode_job(l_position.job_id);

956: l_parameter3_value := p_effective_date;
957: l_parameter4_value :=
958: hr_general.decode_organization(p_organization_id);
959: l_parameter5_value :=
960: hr_general.decode_job(l_position.job_id);
961: l_parameter6_value := l_budgeted_val;
962: l_parameter7_value := l_reallocation_val;
963: l_parameter8_value := l_actual_val;
964: l_parameter9_value := l_commitment_val;

Line 1082: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)

1078: (
1079: p_txn_id =>l_position.position_id,
1080: p_txn_table_route_id =>l_table_route_id,
1081: p_level =>p_level1+2,
1082: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)
1083: );
1084:
1085: --
1086: -- Insert the Log for the position

Line 1121: hr_general.decode_position_latest_name(l_position.position_id);

1117: --
1118: hr_utility.set_location('l_user_name : '|| l_user_name, 1112);
1119: --
1120: l_parameter1_value :=
1121: hr_general.decode_position_latest_name(l_position.position_id);
1122: l_parameter2_value := p_batch_name;
1123: l_parameter3_value := p_effective_date;
1124: l_parameter4_value :=
1125: hr_general.decode_organization(p_organization_id);

Line 1125: hr_general.decode_organization(p_organization_id);

1121: hr_general.decode_position_latest_name(l_position.position_id);
1122: l_parameter2_value := p_batch_name;
1123: l_parameter3_value := p_effective_date;
1124: l_parameter4_value :=
1125: hr_general.decode_organization(p_organization_id);
1126: l_parameter5_value :=
1127: hr_general.decode_job(l_position.job_id);
1128: l_parameter6_value := l_budgeted_val;
1129: l_parameter7_value := l_reallocation_val;

Line 1127: hr_general.decode_job(l_position.job_id);

1123: l_parameter3_value := p_effective_date;
1124: l_parameter4_value :=
1125: hr_general.decode_organization(p_organization_id);
1126: l_parameter5_value :=
1127: hr_general.decode_job(l_position.job_id);
1128: l_parameter6_value := l_budgeted_val;
1129: l_parameter7_value := l_reallocation_val;
1130: l_parameter8_value := l_actual_val;
1131: --

Line 1252: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)

1248: (
1249: p_txn_id =>l_position.position_id,
1250: p_txn_table_route_id =>l_table_route_id,
1251: p_level =>p_level1+2,
1252: p_log_context =>hr_general.decode_position_latest_name(l_position.position_id)
1253: );
1254:
1255: --
1256: -- Insert the Log for the position

Line 1291: hr_general.decode_position_latest_name(l_position.position_id);

1287: --
1288: hr_utility.set_location('l_user_name : '|| l_user_name, 1112);
1289: --
1290: l_parameter1_value :=
1291: hr_general.decode_position_latest_name(l_position.position_id);
1292: l_parameter2_value := p_batch_name;
1293: l_parameter3_value := p_effective_date;
1294: l_parameter4_value :=
1295: hr_general.decode_organization(p_organization_id);

Line 1295: hr_general.decode_organization(p_organization_id);

1291: hr_general.decode_position_latest_name(l_position.position_id);
1292: l_parameter2_value := p_batch_name;
1293: l_parameter3_value := p_effective_date;
1294: l_parameter4_value :=
1295: hr_general.decode_organization(p_organization_id);
1296: l_parameter5_value :=
1297: hr_general.decode_job(l_position.job_id);
1298: l_parameter6_value := l_budgeted_val;
1299: l_parameter7_value := l_reallocation_val;

Line 1297: hr_general.decode_job(l_position.job_id);

1293: l_parameter3_value := p_effective_date;
1294: l_parameter4_value :=
1295: hr_general.decode_organization(p_organization_id);
1296: l_parameter5_value :=
1297: hr_general.decode_job(l_position.job_id);
1298: l_parameter6_value := l_budgeted_val;
1299: l_parameter7_value := l_reallocation_val;
1300: l_parameter8_value := l_actual_val;
1301: --

Line 1373: and p_effective_date between ver.date_from and nvl(date_to, hr_general.end_of_time);

1369: and str.organization_structure_id = p_org_structure_id
1370: and str.business_group_id = p_business_group_id
1371: and ver.business_group_id = p_business_group_id
1372: and str.organization_structure_id = ver.organization_structure_id
1373: and p_effective_date between ver.date_from and nvl(date_to, hr_general.end_of_time);
1374: --
1375: -- Cursor to fetch the top Org of Hierarchy
1376: --
1377: cursor c_top_org(p_org_structure_version_id number) is

Line 1431: and p_effective_date between date_from and nvl(date_to, hr_general.end_of_time);

1427: organization_id
1428: from hr_all_organization_units
1429: where business_group_id = p_business_group_id
1430: and INTERNAL_EXTERNAL_FLAG ='INT'
1431: and p_effective_date between date_from and nvl(date_to, hr_general.end_of_time);
1432: --
1433: -- Cursor that checks the batch existance
1434: --
1435: cursor check_batch_name(p_batch_name varchar2) is

Line 1753: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));

1749: --
1750: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', 200);
1751: --
1752: pqh_utility.set_message_token('UOM',
1753: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
1754: pqh_utility.set_message_token('ENTITY',
1755: hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));
1756:
1757: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);

Line 1755: hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));

1751: --
1752: pqh_utility.set_message_token('UOM',
1753: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
1754: pqh_utility.set_message_token('ENTITY',
1755: hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));
1756:
1757: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
1758: --
1759: l_message_type_cd := pqh_utility.get_message_type_cd;

Line 1782: p_log_context =>hr_general.decode_organization(l_organization.organization_id)

1778: (
1779: p_txn_id =>l_organization.organization_id,
1780: p_txn_table_route_id =>l_table_route_id,
1781: p_level =>l_organization.level1 + 1,
1782: p_log_context =>hr_general.decode_organization(l_organization.organization_id)
1783: ); */
1784: --
1785: -- Fetch Jobs
1786: --

Line 1900: p_log_context =>hr_general.decode_job(l_job.job_id)

1896: (
1897: p_txn_id =>l_job.job_id,
1898: p_txn_table_route_id =>l_table_route_id, -- later
1899: p_level =>1,
1900: p_log_context =>hr_general.decode_job(l_job.job_id)
1901: );
1902:
1903: --
1904: -- Insert the Log for the job

Line 2019: p_log_context =>hr_general.decode_job(l_job.job_id)

2015: (
2016: p_txn_id =>l_job.job_id,
2017: p_txn_table_route_id =>l_table_route_id,
2018: p_level =>1,
2019: p_log_context =>hr_general.decode_job(l_job.job_id)
2020: );
2021:
2022: --
2023: -- Insert the Log for the Job

Line 2140: p_log_context =>hr_general.decode_job(l_job.job_id)

2136: (
2137: p_txn_id =>l_job.job_id,
2138: p_txn_table_route_id =>l_table_route_id,
2139: p_level =>1,
2140: p_log_context =>hr_general.decode_job(l_job.job_id)
2141: );
2142:
2143: --
2144: -- Insert the Log for the job

Line 2357: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));

2353: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
2354: --
2355: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS',200);
2356: pqh_utility.set_message_token('UOM',
2357: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
2358: pqh_utility.set_message_token('ENTITY',
2359: hr_general.decode_lookup('PQH_BUDGET_ENTITY','GRADE'));
2360:
2361: --

Line 2359: hr_general.decode_lookup('PQH_BUDGET_ENTITY','GRADE'));

2355: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS',200);
2356: pqh_utility.set_message_token('UOM',
2357: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
2358: pqh_utility.set_message_token('ENTITY',
2359: hr_general.decode_lookup('PQH_BUDGET_ENTITY','GRADE'));
2360:
2361: --
2362: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
2363: --

Line 2387: p_log_context =>hr_general.decode_organization(l_organization.organization_id)

2383: (
2384: p_txn_id =>l_organization.organization_id,
2385: p_txn_table_route_id =>l_table_route_id,
2386: p_level =>l_organization.level1 + 1,
2387: p_log_context =>hr_general.decode_organization(l_organization.organization_id)
2388: ); */
2389: --
2390: --
2391: fnd_file.put_line(FND_FILE.LOG,'Primary Entity => ''GRADE''' || ' Unit of Measure => '||p_unit_of_measure);

Line 2502: p_log_context =>hr_general.decode_grade(l_grade.grade_id)

2498: (
2499: p_txn_id =>l_grade.grade_id,
2500: p_txn_table_route_id =>l_table_route_id, -- later
2501: p_level =>1,
2502: p_log_context =>hr_general.decode_grade(l_grade.grade_id)
2503: );
2504:
2505: --
2506: -- Insert the Log for the grade

Line 2621: p_log_context =>hr_general.decode_grade(l_grade.grade_id)

2617: (
2618: p_txn_id =>l_grade.grade_id,
2619: p_txn_table_route_id =>l_table_route_id,
2620: p_level =>1,
2621: p_log_context =>hr_general.decode_grade(l_grade.grade_id)
2622: );
2623:
2624: --
2625: -- Insert the Log for the Grade

Line 2740: p_log_context =>hr_general.decode_grade(l_grade.grade_id)

2736: (
2737: p_txn_id =>l_grade.grade_id,
2738: p_txn_table_route_id =>l_table_route_id,
2739: p_level =>1,
2740: p_log_context =>hr_general.decode_grade(l_grade.grade_id)
2741: );
2742:
2743: --
2744: -- Insert the Log for the grade

Line 2865: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));

2861: --
2862: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', p_organization_id);
2863: --
2864: pqh_utility.set_message_token('UOM',
2865: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
2866: pqh_utility.set_message_token('ENTITY',
2867: hr_general.decode_lookup('PQH_BUDGET_ENTITY','ORGANIZATION'));
2868:
2869: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);

Line 2867: hr_general.decode_lookup('PQH_BUDGET_ENTITY','ORGANIZATION'));

2863: --
2864: pqh_utility.set_message_token('UOM',
2865: hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',p_unit_of_measure));
2866: pqh_utility.set_message_token('ENTITY',
2867: hr_general.decode_lookup('PQH_BUDGET_ENTITY','ORGANIZATION'));
2868:
2869: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
2870: --
2871: l_message_type_cd := pqh_utility.get_message_type_cd;

Line 2891: hr_general.decode_organization(p_organization_id), 105);

2887: l_table_route_id, 105);
2888: hr_utility.set_location('l_orglevel1: '||
2889: p_level1, 105);
2890: hr_utility.set_location('org name: '||
2891: hr_general.decode_organization(p_organization_id), 105);
2892: --
2893: -- Set the Process Log Context level for the Organization
2894: --
2895: pqh_process_batch_log.set_context_level

Line 2900: p_log_context =>hr_general.decode_organization(P_organization_id)

2896: (
2897: p_txn_id =>p_organization_id,
2898: p_txn_table_route_id =>l_table_route_id,
2899: p_level =>p_level1 + 1,
2900: p_log_context =>hr_general.decode_organization(P_organization_id)
2901: );
2902: --
2903: hr_utility.set_location('Organization : '||p_organization_id
2904: || ' ' ||l_proc_name, 110);

Line 2995: p_log_context =>hr_general.decode_organization(l_organization.organization_id)

2991: (
2992: p_txn_id =>l_organization.organization_id,
2993: p_txn_table_route_id =>l_table_route_id,
2994: p_level =>l_organization.level1+2,
2995: p_log_context =>hr_general.decode_organization(l_organization.organization_id)
2996: );
2997: */
2998: --
2999: -- Insert the Log for the organization

Line 3099: p_log_context =>hr_general.decode_organization(l_organization.organization_id)

3095: (
3096: p_txn_id =>l_organization.organization_id,
3097: p_txn_table_route_id =>l_table_route_id,
3098: p_level =>l_organization.level1+2,
3099: p_log_context =>hr_general.decode_organization(l_organization.organization_id)
3100: );
3101: */
3102: --
3103: -- Insert the Log for the organization

Line 3202: p_log_context =>hr_general.decode_organization(l_organization.organization_id)

3198: (
3199: p_txn_id =>l_organization.organization_id,
3200: p_txn_table_route_id =>l_table_route_id,
3201: p_level =>l_organization.level1+2,
3202: p_log_context =>hr_general.decode_organization(l_organization.organization_id)
3203: );
3204: */
3205: --
3206: -- Insert the Log for the organization

Line 3283: and p_effective_date between ver.date_from and nvl(date_to, hr_general.end_of_time);

3279: and str.organization_structure_id = p_org_structure_id
3280: and str.business_group_id = p_business_group_id
3281: and ver.business_group_id = p_business_group_id
3282: and str.organization_structure_id = ver.organization_structure_id
3283: and p_effective_date between ver.date_from and nvl(date_to, hr_general.end_of_time);
3284: --
3285: -- Cursor to fetch the top Org of Hierarchy
3286: --
3287: cursor c_top_org(p_org_structure_version_id number) is

Line 3339: and p_effective_date between date_from and nvl(date_to, hr_general.end_of_time);

3335: organization_id
3336: from hr_all_organization_units
3337: where business_group_id = p_business_group_id
3338: and INTERNAL_EXTERNAL_FLAG ='INT'
3339: and p_effective_date between date_from and nvl(date_to, hr_general.end_of_time);
3340: --
3341: -- Cursor that checks the batch existance
3342: --
3343: cursor check_batch_name(p_batch_name varchar2) is

Line 3536: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');

3532:
3533:
3534: If p_entity_code ='POSITION' then
3535: --
3536: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3537: --
3538: Elsif p_entity_code ='ORGANIZATION' then
3539: --
3540: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');

Line 3540: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');

3536: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3537: --
3538: Elsif p_entity_code ='ORGANIZATION' then
3539: --
3540: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3541: --
3542: Else
3543: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('UNDER_BDGT_EXTRA_TYPES',p_entity_code));
3544: End if;

Line 3543: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('UNDER_BDGT_EXTRA_TYPES',p_entity_code));

3539: --
3540: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3541: --
3542: Else
3543: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('UNDER_BDGT_EXTRA_TYPES',p_entity_code));
3544: End if;
3545: --
3546: errbuf := fnd_message.get;
3547: retcode := -1;