DBA Data[Home] [Help]

APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on PQH_UTILITY

Line 253: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', l_organization.organization_id);

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;

Line 255: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);

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'));

Line 257: l_message_type_cd := pqh_utility.get_message_type_cd;

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'));

Line 258: pqh_utility.set_message_token('UOM',

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:

Line 260: pqh_utility.set_message_token('ENTITY',

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: --

Line 263: l_message := pqh_utility.get_message;

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

Line 265: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);

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';

Line 751: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', p_organization_id);

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',

Line 753: pqh_utility.set_message_token('UOM',

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:

Line 755: pqh_utility.set_message_token('ENTITY',

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: --

Line 758: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);

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: --

Line 760: l_message_type_cd := pqh_utility.get_message_type_cd;

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: --

Line 761: l_message := pqh_utility.get_message;

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

Line 763: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);

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';

Line 1750: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', 200);

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',

Line 1752: pqh_utility.set_message_token('UOM',

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:

Line 1754: pqh_utility.set_message_token('ENTITY',

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: --

Line 1757: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);

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: --

Line 1759: l_message_type_cd := pqh_utility.get_message_type_cd;

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: --

Line 1760: l_message := pqh_utility.get_message;

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

Line 1762: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);

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';

Line 2355: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS',200);

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'));

Line 2356: pqh_utility.set_message_token('UOM',

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:

Line 2358: pqh_utility.set_message_token('ENTITY',

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);

Line 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: --

Line 2364: l_message_type_cd := pqh_utility.get_message_type_cd;

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: --

Line 2365: l_message := pqh_utility.get_message;

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

Line 2367: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);

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';

Line 2862: pqh_utility.set_message(8302,'PQH_UNDER_BGT_POSITIONS', p_organization_id);

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',

Line 2864: pqh_utility.set_message_token('UOM',

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:

Line 2866: pqh_utility.set_message_token('ENTITY',

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: --

Line 2869: hr_utility.set_location('after pqh_utility.set_message : '|| l_proc_name, 103);

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: --

Line 2871: l_message_type_cd := pqh_utility.get_message_type_cd;

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: --

Line 2872: l_message := pqh_utility.get_message;

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

Line 2874: hr_utility.set_location('after pqh_utility.get_message : '||l_message_type_cd|| l_proc_name, 104);

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';