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_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 1074: hr_utility.set_location('Entering pqp_config_shared_veh',32);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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