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.

[Home] [Help]

APPS.PQP_VAL_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: 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 112: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

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

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

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

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

152: close csr_leg_code;
153: pqp_val_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;
154: pqp_val_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_ddf';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.vehicle_allocation_id is not null) and (
198: nvl(pqp_val_shd.g_old_rec.val_information_category, hr_api.g_varchar2) <>
199: nvl(p_rec.val_information_category, hr_api.g_varchar2) or

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

290: ,p_attribute20_value => p_rec.val_information20
291: );
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: end chk_ddf;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |------------------------------< chk_df >----------------------------------|

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

328: --
329: l_proc varchar2(72) := g_package || 'chk_df';
330: --
331: begin
332: hr_utility.set_location('Entering:'||l_proc,10);
333: --
334: if ((p_rec.vehicle_allocation_id is not null) and (
335: nvl(pqp_val_shd.g_old_rec.val_attribute_category, hr_api.g_varchar2) <>
336: nvl(p_rec.val_attribute_category, hr_api.g_varchar2) or

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

427: ,p_attribute20_value => p_rec.val_attribute20
428: );
429: end if;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc,20);
432: end chk_df;
433: --
434: -- ----------------------------------------------------------------------------
435: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 739: hr_utility.set_location('Entering pqp_get_max_allowed_veh', 21);

735: pvr.effective_start_date and pvr.effective_end_date;
736:
737: l_rowcount NUMBER;
738: BEGIN
739: hr_utility.set_location('Entering pqp_get_max_allowed_veh', 21);
740: OPEN c_alloc_count_cursor;
741: FETCH c_alloc_count_cursor INTO l_rowcount;
742: CLOSE c_alloc_count_cursor;
743: hr_utility.set_location('maximum vehicles till now:'||l_rowcount, 25);

Line 743: hr_utility.set_location('maximum vehicles till now:'||l_rowcount, 25);

739: hr_utility.set_location('Entering pqp_get_max_allowed_veh', 21);
740: OPEN c_alloc_count_cursor;
741: FETCH c_alloc_count_cursor INTO l_rowcount;
742: CLOSE c_alloc_count_cursor;
743: hr_utility.set_location('maximum vehicles till now:'||l_rowcount, 25);
744: RETURN l_rowcount ;
745: END pqp_get_max_allowed_veh;
746: -- end function
747:

Line 931: hr_utility.set_location('Entering pqp_check_veh_alloc_process', 16);

927:
928: l_rowcount NUMBER ;
929:
930: BEGIN
931: hr_utility.set_location('Entering pqp_check_veh_alloc_process', 16);
932: OPEN c_alloc_count_cursor;
933: FETCH c_alloc_count_cursor INTO l_rowcount;
934: CLOSE c_alloc_count_cursor ;
935:

Line 941: hr_utility.set_location('Count for P or E:'||l_rowcount, 20);

937: IF p_rec.usage_type = 'P' THEN
938: -- if 0 then allowedrec
939: IF l_rowcount > 0 THEN
940: --This is max ,so user canot allocate
941: hr_utility.set_location('Count for P or E:'||l_rowcount, 20);
942: p_message :='Only one Primary vehicle is allocated to the user';
943: RETURN -1;
944: END IF;
945:

Line 1073: hr_utility.set_location('Entering pqp_config_shared_veh',32);

1069: l_rowcount NUMBER ;
1070: l_veh_shared VARCHAR2(20);
1071:
1072: BEGIN
1073: hr_utility.set_location('Entering pqp_config_shared_veh',32);
1074: OPEN c_person_alloc_count_cursor;
1075: FETCH c_person_alloc_count_cursor INTO l_rowcount ;
1076: CLOSE c_person_alloc_count_cursor ;
1077: hr_utility.set_location('alloc count persons :'||l_rowcount,35);

Line 1077: hr_utility.set_location('alloc count persons :'||l_rowcount,35);

1073: hr_utility.set_location('Entering pqp_config_shared_veh',32);
1074: OPEN c_person_alloc_count_cursor;
1075: FETCH c_person_alloc_count_cursor INTO l_rowcount ;
1076: CLOSE c_person_alloc_count_cursor ;
1077: hr_utility.set_location('alloc count persons :'||l_rowcount,35);
1078: IF l_rowcount > 0 THEN
1079:
1080: --Checking the shared vehicle flag for this repositoryId
1081: IF p_shared_vehicle = 'N' THEN

Line 1134: hr_utility.set_location('Entering chk_reg_exist_for_alloc', 7);

1130:
1131: l_rowcount NUMBER;
1132:
1133: BEGIN
1134: hr_utility.set_location('Entering chk_reg_exist_for_alloc', 7);
1135: OPEN c_alloc_count_cursor;
1136: FETCH c_alloc_count_cursor INTO l_rowcount;
1137: CLOSE c_alloc_count_cursor;
1138: hr_utility.set_location('Vehicle Reg Exist:'||l_rowcount, 10);

Line 1138: hr_utility.set_location('Vehicle Reg Exist:'||l_rowcount, 10);

1134: hr_utility.set_location('Entering chk_reg_exist_for_alloc', 7);
1135: OPEN c_alloc_count_cursor;
1136: FETCH c_alloc_count_cursor INTO l_rowcount;
1137: CLOSE c_alloc_count_cursor;
1138: hr_utility.set_location('Vehicle Reg Exist:'||l_rowcount, 10);
1139: IF l_rowcount > 0 THEN
1140: p_message := 'Registration number is already exist in this date tracks';
1141: RETURN -1 ;
1142: END IF;

Line 1246: hr_utility.set_location('Entering pqp_check_veh_alloc_process', 16);

1242:
1243: l_rowcount NUMBER ;
1244:
1245: BEGIN
1246: hr_utility.set_location('Entering pqp_check_veh_alloc_process', 16);
1247: OPEN c_alloc_count_cursor;
1248: FETCH c_alloc_count_cursor INTO l_rowcount;
1249: CLOSE c_alloc_count_cursor ;
1250:

Line 1253: hr_utility.set_location('Count for default:'||l_rowcount, 20);

1249: CLOSE c_alloc_count_cursor ;
1250:
1251: IF l_rowcount > 0 THEN
1252: --This is max default vehicle ,so user canot allocate
1253: hr_utility.set_location('Count for default:'||l_rowcount, 20);
1254: p_message :='Only one Default vehicle allocated to the user';
1255: RETURN -1;
1256: END IF;
1257: RETURN 0;

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

1405: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1406: --
1407:
1408: Begin
1409: hr_utility.set_location('Entering:'||l_proc, 5);
1410: --
1411: -- Call all supporting business operations
1412: --
1413: hr_api.validate_bus_grp_id

Line 1577: hr_utility.set_location('Count conf maximum count:'||l_max_conf_count,23);

1573: p_legislation_code => l_legislation_code,
1574: p_seg_col_name =>'MaxCmyVehAllow',
1575: p_table_name =>'p_table_name',
1576: p_information_category =>'PQP_VEHICLE_MILEAGE');
1577: hr_utility.set_location('Count conf maximum count:'||l_max_conf_count,23);
1578: --if null then no limit
1579: IF l_max_conf_count IS NOT NULL THEN
1580: Begin
1581: l_number_value := fnd_number.CANONICAL_TO_NUMBER(l_max_conf_count);

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

1691: pqp_val_bus.chk_ddf(p_rec);
1692: --
1693: pqp_val_bus.chk_df(p_rec);
1694: --
1695: hr_utility.set_location(' Leaving:'||l_proc, 10);
1696: End insert_validate;
1697: --
1698: -- ----------------------------------------------------------------------------
1699: -- |---------------------------< update_validate >----------------------------|

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

1733:
1734:
1735: --
1736: Begin
1737: hr_utility.set_location('Entering:'||l_proc, 5);
1738: --
1739: -- Call all supporting business operations
1740: --
1741: hr_api.validate_bus_grp_id

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

1919: --
1920: pqp_val_bus.chk_df(p_rec);
1921: --
1922: hr_multi_message.end_validation_set;
1923: hr_utility.set_location(' Leaving:'||l_proc, 10);
1924: End update_validate;
1925: --
1926: -- ----------------------------------------------------------------------------
1927: -- |---------------------------< delete_validate >----------------------------|

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

1939: l_message VARCHAR2(2500) ;
1940:
1941: --
1942: Begin
1943: hr_utility.set_location('Entering:'||l_proc, 5);
1944: --
1945: -- Call all supporting business operations
1946: --
1947: dt_delete_validate

Line 1963: hr_utility.set_location('Purge delete status:'||l_return_status,40);

1959: l_return_status := pqp_purge_veh_alloc
1960: (p_rec =>p_rec
1961: ,p_effective_date =>p_effective_date
1962: ,p_message => l_message );
1963: hr_utility.set_location('Purge delete status:'||l_return_status,40);
1964: IF l_return_status = -1 THEN
1965: fnd_message.set_name('PQP', 'PQP_230724_DEL_ALLOC_RESTRICT');
1966: fnd_message.raise_error;
1967: END IF;

Line 1975: hr_utility.set_location('En date delete status :'||l_return_status,45);

1971: l_return_status := pqp_enddate_veh_alloc
1972: (p_rec =>p_rec
1973: ,p_effective_date =>p_effective_date
1974: ,p_message => l_message );
1975: hr_utility.set_location('En date delete status :'||l_return_status,45);
1976: IF l_return_status = -1 THEN
1977: fnd_message.set_name('PQP', 'PQP_230700_CANCEL_INFO');
1978: fnd_message.raise_error;
1979: END IF;

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

1978: fnd_message.raise_error;
1979: END IF;
1980: END IF;
1981:
1982: hr_utility.set_location(' Leaving:'||l_proc, 10);
1983: End delete_validate;
1984: --
1985: end pqp_val_bus;