249: hr_utility.set_location('l_table_route_id : '||l_table_route_id ||' '|| l_proc_name, 102);
250: --
251: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
252: --
253: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', l_organization.organization_id);
254: --
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;
251: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
252: --
253: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', l_organization.organization_id);
254: --
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'));
253: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', l_organization.organization_id);
254: --
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'));
254: --
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:
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;
264: --
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);
266: --
267: if l_message_type_cd in ('E','W') then
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);
266: --
267: if l_message_type_cd in ('E','W') then
268: if l_message_type_cd = 'E' then
269: l_message_type := 'ERROR';
747: hr_utility.set_location('l_table_route_id : '||l_table_route_id ||' '|| l_proc_name, 102);
748: --
749: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
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',
749: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
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:
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);
759: --
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;
761: l_message := pqh_utility.get_message;
762: --
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;
761: l_message := pqh_utility.get_message;
762: --
763: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
764: --
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;
761: l_message := pqh_utility.get_message;
762: --
763: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
764: --
765: if l_message_type_cd in ('E','W') then
759: --
760: l_message_type_cd := pqh_utility.get_message_type_cd;
761: l_message := pqh_utility.get_message;
762: --
763: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
764: --
765: if l_message_type_cd in ('E','W') then
766: if l_message_type_cd = 'E' then
767: l_message_type := 'ERROR';
1746: hr_utility.set_location('l_table_route_id : '||l_table_route_id ||' '|| l_proc_name, 102);
1747: --
1748: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
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',
1748: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
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:
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);
1758: --
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;
1760: l_message := pqh_utility.get_message;
1761: --
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;
1760: l_message := pqh_utility.get_message;
1761: --
1762: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
1763: --
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;
1760: l_message := pqh_utility.get_message;
1761: --
1762: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
1763: --
1764: if l_message_type_cd in ('E','W') then
1758: --
1759: l_message_type_cd := pqh_utility.get_message_type_cd;
1760: l_message := pqh_utility.get_message;
1761: --
1762: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
1763: --
1764: if l_message_type_cd in ('E','W') then
1765: if l_message_type_cd = 'E' then
1766: l_message_type := 'ERROR';
2351: hr_utility.set_location('l_table_route_id : '||l_table_route_id ||' '|| l_proc_name, 102);
2352: --
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'));
2352: --
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:
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: --
2362: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
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: --
2364: l_message_type_cd := pqh_utility.get_message_type_cd;
2365: l_message := pqh_utility.get_message;
2366: --
2360:
2361: --
2362: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
2363: --
2364: l_message_type_cd := pqh_utility.get_message_type_cd;
2365: l_message := pqh_utility.get_message;
2366: --
2367: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
2368: --
2361: --
2362: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);
2363: --
2364: l_message_type_cd := pqh_utility.get_message_type_cd;
2365: l_message := pqh_utility.get_message;
2366: --
2367: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
2368: --
2369: if l_message_type_cd in ('E','W') then
2363: --
2364: l_message_type_cd := pqh_utility.get_message_type_cd;
2365: l_message := pqh_utility.get_message;
2366: --
2367: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
2368: --
2369: if l_message_type_cd in ('E','W') then
2370: if l_message_type_cd = 'E' then
2371: l_message_type := 'ERROR';
2858: hr_utility.set_location('l_table_route_id : '||l_table_route_id ||' '|| l_proc_name, 102);
2859: --
2860: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
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',
2860: -- Check for the type of the cofigurable message(PQH_UNDER_BGT_POSITIONS)
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:
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);
2870: --
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;
2872: l_message := pqh_utility.get_message;
2873: --
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;
2872: l_message := pqh_utility.get_message;
2873: --
2874: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
2875: --
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;
2872: l_message := pqh_utility.get_message;
2873: --
2874: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
2875: --
2876: if l_message_type_cd in ('E','W') then
2870: --
2871: l_message_type_cd := pqh_utility.get_message_type_cd;
2872: l_message := pqh_utility.get_message;
2873: --
2874: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);
2875: --
2876: if l_message_type_cd in ('E','W') then
2877: if l_message_type_cd = 'E' then
2878: l_message_type := 'ERROR';