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.PQP_VRE_BUS dependencies on HR_UTILITY

Line 44: hr_utility.set_location('Entering:'|| l_proc, 10);

40: l_legislation_code VARCHAR2(150);
41: --
42: BEGIN
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error

Line 83: hr_utility.set_location(' Leaving:'|| l_proc, 20);

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: END IF;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: END set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

Line 113: hr_utility.set_location('Entering:'|| l_proc, 10);

109: l_proc varchar2(72) := g_package||'return_legislation_code';
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error

Line 131: hr_utility.set_location(l_proc, 20);

127: -- call to this function. Just return the value in the global
128: -- variable.
129: --
130: l_legislation_code := pqp_vre_bus.g_legislation_code;
131: hr_utility.set_location(l_proc, 20);
132: ELSE
133: --
134: -- The ID is different to the last call to this function
135: -- or this is the first call to this function.

Line 148: hr_utility.set_location(l_proc,30);

144: CLOSE csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: END IF;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are
151: -- available for the next call to this function.
152: --

Line 157: hr_utility.set_location(' Leaving:'|| l_proc, 40);

153: CLOSE csr_leg_code;
154: pqp_vre_bus.g_vehicle_repository_id := p_vehicle_repository_id;
155: pqp_vre_bus.g_legislation_code := l_legislation_code;
156: END IF;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;
159: END return_legislation_code;
160: --
161: -- ----------------------------------------------------------------------------

Line 196: hr_utility.set_location('Entering:'||l_proc,10);

192: --
193: l_proc varchar2(72) := g_package || 'chk_ddf';
194: --
195: BEGIN
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or

Line 295: hr_utility.set_location(' Leaving:'||l_proc,20);

291: ,p_attribute20_value => p_rec.vre_information20
292: );
293: END IF;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc,20);
296: END chk_ddf;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |------------------------------< chk_df >----------------------------------|

Line 333: hr_utility.set_location('Entering:'||l_proc,10);

329: --
330: l_proc varchar2(72) := g_package || 'chk_df';
331: --
332: BEGIN
333: hr_utility.set_location('Entering:'||l_proc,10);
334: --
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or

Line 432: hr_utility.set_location(' Leaving:'||l_proc,20);

428: ,p_attribute20_value => p_rec.vre_attribute20
429: );
430: END IF;
431: --
432: hr_utility.set_location(' Leaving:'||l_proc,20);
433: END chk_df;
434: --
435: -- ----------------------------------------------------------------------------
436: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 1095: hr_utility.set_location('Entering pqp_check_ownership_change',45);

1091:
1092: l_rowcount NUMBER;
1093:
1094: BEGIN
1095: hr_utility.set_location('Entering pqp_check_ownership_change',45);
1096: OPEN c_alloc_count_cursor;
1097: FETCH c_alloc_count_cursor INTO l_rowcount;
1098: CLOSE c_alloc_count_cursor;
1099:

Line 1207: hr_utility.set_location('Entering pqp_check_shared_veh',45);

1203: l_temp_person_id NUMBER;
1204: l_count NUMBER := 0;
1205:
1206: BEGIN
1207: hr_utility.set_location('Entering pqp_check_shared_veh',45);
1208:
1209: --If ShareVehicle is 'N' then check the value of original
1210: --shared vehicle value
1211: IF p_rec.shared_vehicle = 'N' THEN

Line 1230: hr_utility.set_location('Assigned to two different persons',45);

1226: ELSE
1227: --If Vehicle is assigned to multiple personId's
1228: --then user cannot chage the shared status
1229: IF l_temp_person_id <> l_person_id THEN
1230: hr_utility.set_location('Assigned to two different persons',45);
1231: close c_alloc_count_cursor ;
1232: p_message := 'Vehicle is allocated to multilpe personIds ' ||
1233: ' So user cannot change the Shared Status ';
1234: RETURN -1;

Line 1482: hr_utility.set_location('Entering:'||l_proc, 5);

1478: l_legislation_code varchar2(150);
1479: --
1480:
1481: BEGIN
1482: hr_utility.set_location('Entering:'||l_proc, 5);
1483:
1484: --
1485: -- Call all supporting business operations
1486: --

Line 1781: hr_utility.set_location('Config cmy veh share val:'||l_share_conf_value,40);

1777: p_seg_col_name =>'ShareCmyCar',
1778: p_table_name =>'p_table_name',
1779: p_information_category=>'PQP_VEHICLE_MILEAGE');
1780:
1781: hr_utility.set_location('Config cmy veh share val:'||l_share_conf_value,40);
1782:
1783: --If configuration value is 'N' then user shouldnot select the checkbox
1784: --If user selects then raise error
1785: IF l_share_conf_value = 'N' THEN

Line 1800: hr_utility.set_location('Config pri veh share val:'||l_share_conf_value,40);

1796: p_seg_col_name => 'SharePriCar',
1797: p_table_name => 'p_table_name',
1798: p_information_category =>'PQP_VEHICLE_MILEAGE');
1799:
1800: hr_utility.set_location('Config pri veh share val:'||l_share_conf_value,40);
1801:
1802: IF l_share_conf_value = 'N' THEN
1803: IF p_rec.shared_vehicle = 'Y' THEN
1804: fnd_message.set_name('PQP', 'PQP_230721_PVT_CAR_NT_SHARED');

Line 1829: hr_utility.set_location(' Leaving:'||l_proc, 10);

1825: pqp_vre_bus.chk_ddf(p_rec);
1826: --
1827: pqp_vre_bus.chk_df(p_rec);
1828: --
1829: hr_utility.set_location(' Leaving:'||l_proc, 10);
1830: End insert_validate;
1831: --
1832: -- ----------------------------------------------------------------------------
1833: -- |---------------------------< update_validate >----------------------------|

Line 1852: hr_utility.set_location('Entering:'||l_proc, 5);

1848: l_return_message varchar2(2000);
1849:
1850: --
1851: BEGIN
1852: hr_utility.set_location('Entering:'||l_proc, 5);
1853: --
1854: -- Call all supporting business operations
1855: --
1856:

Line 2247: hr_utility.set_location(' Leaving:'||l_proc, 10);

2243: pqp_vre_bus.chk_ddf(p_rec);
2244: --
2245: pqp_vre_bus.chk_df(p_rec);
2246: --
2247: hr_utility.set_location(' Leaving:'||l_proc, 10);
2248: End update_validate;
2249: --
2250: -- ----------------------------------------------------------------------------
2251: -- |---------------------------< delete_validate >----------------------------|

Line 2269: hr_utility.set_location('Entering:'||l_proc, 5);

2265: l_message VARCHAR2(2500) ;
2266: l_return_message varchar2(2000);
2267: --
2268: BEGIN
2269: hr_utility.set_location('Entering:'||l_proc, 5);
2270: --
2271: -- Call all supporting business operations
2272: --
2273:

Line 2292: hr_utility.set_location('Veh purge Delete Status :'||l_return_message,50);

2288: ,p_effective_date =>p_effective_date
2289: ,p_message =>l_message
2290: );
2291:
2292: hr_utility.set_location('Veh purge Delete Status :'||l_return_message,50);
2293:
2294: IF l_return_message IS NOT NULL THEN
2295: fnd_message.set_name('PQP', 'PQP_230730_VEH_DEL_RSTRICT');
2296: fnd_message.set_token('NAME',l_return_message);

Line 2307: hr_utility.set_location('Veh enddate Delete Status :'||l_return_message,55);

2303: ,p_effective_date =>p_effective_date
2304: ,p_message =>l_message
2305: );
2306:
2307: hr_utility.set_location('Veh enddate Delete Status :'||l_return_message,55);
2308:
2309: IF l_return_message IS NOT NULL THEN
2310: fnd_message.set_name('PQP', 'PQP_230729_VEH_ENDDT_RSTRICT');
2311: fnd_message.set_token('NAME',l_return_message);

Line 2317: hr_utility.set_location(' Leaving:'||l_proc, 10);

2313: END IF;
2314:
2315: END IF;
2316:
2317: hr_utility.set_location(' Leaving:'||l_proc, 10);
2318: --handling multiple messages
2319: --catching all errors and adding to multi message package.
2320: Exception
2321: when app_exception.application_exception then