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

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

25: l_proc varchar2(72) := g_package||'set_security_group_id';
26: --
27: begin
28: --
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: select business_group_id
32: into p_business_group_id
33: from per_position_structures

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

33: from per_position_structures
34: where p_position_structure_id = position_structure_id;
35:
36: --
37: hr_utility.set_location(' Leaving:'|| l_proc, 20);
38: --
39: exception
40: when no_data_found then
41: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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

66: l_proc varchar2(72) := g_package||'set_security_group_id';
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: --
72: -- Ensure that all the mandatory parameter are not null
73: --
74: hr_api.mandatory_arg_error

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

97: hr_api.set_security_group_id
98: (p_security_group_id => l_security_group_id
99: );
100: --
101: hr_utility.set_location(' Leaving:'|| l_proc, 20);
102: --
103: end set_security_group_id;
104: --
105: -- ---------------------------------------------------------------------------

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

126: l_proc varchar2(72) := g_package||'return_legislation_code';
127: --
128: Begin
129: --
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Ensure that all the mandatory parameter are not null
133: --
134: hr_api.mandatory_arg_error

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

144: -- call to this function. Just return the value in the global
145: -- variable.
146: --
147: l_legislation_code := per_psv_bus.g_legislation_code;
148: hr_utility.set_location(l_proc, 20);
149: else
150: --
151: -- The ID is different to the last call to this function
152: -- or this is the first call to this function.

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

161: close csr_leg_code;
162: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: end if;
165: hr_utility.set_location(l_proc,30);
166: --
167: -- Set the global variables so the values are
168: -- available for the next call to this function.
169: --

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

170: close csr_leg_code;
171: per_psv_bus.g_pos_structure_version_id := p_pos_structure_version_id;
172: per_psv_bus.g_legislation_code := l_legislation_code;
173: end if;
174: hr_utility.set_location(' Leaving:'|| l_proc, 40);
175: return l_legislation_code;
176: end return_legislation_code;
177:
178: -- ---------------------------------------------------------------------------

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

198: l_rowid VARCHAR2(20);
199: l_count number(2);
200: begin
201: --
202: hr_utility.set_location('Entering:'|| l_proc, 10);
203: --
204: --
205: hr_api.mandatory_arg_error
206: (p_api_name => l_proc

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

259: l_min_start_date DATE;
260: l_proc VARCHAR2(72) := g_package||'chk_dates';
261: begin
262: --
263: hr_utility.set_location('Entering:'|| l_proc, 10);
264: --
265: --
266:
267: --

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

265: --
266:
267: --
268: --
269: hr_utility.set_location(l_proc, 20);
270: --
271: -- Checks that date from is earlier than date to and neither
272: -- are before or after beginning/end of time
273: --

Line 278: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');

274:
275: if p_date_from > p_date_to
276: or p_date_from < hr_api.g_sot
277: or p_date_from > hr_api.g_eot then
278: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');
279: hr_utility.raise_error;
280: end if;
281:
282: -- The code below checks for a gap between different versions

Line 279: hr_utility.raise_error;

275: if p_date_from > p_date_to
276: or p_date_from < hr_api.g_sot
277: or p_date_from > hr_api.g_eot then
278: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');
279: hr_utility.raise_error;
280: end if;
281:
282: -- The code below checks for a gap between different versions
283: --

Line 328: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');

324: --
325:
326: --
327: --
328: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
329: hr_utility.raise_error;
330: --
331:
332: end;

Line 329: hr_utility.raise_error;

325:
326: --
327: --
328: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
329: hr_utility.raise_error;
330: --
331:
332: end;
333: exception

Line 337: hr_utility.set_location('Leaving:'||l_proc, 30);

333: exception
334: when no_data_found then
335: null;
336: --
337: hr_utility.set_location('Leaving:'||l_proc, 30);
338: --
339:
340: end chk_dates;
341: --

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

361: and nvl(p_pos_structure_version_id,-1) <> pos_structure_version_id
362: and p_position_structure_id = position_structure_id;
363: begin
364: --
365: hr_utility.set_location('Entering:'|| l_proc, 10);
366: --
367: --
368: --
369: --

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

366: --
367: --
368: --
369: --
370: hr_utility.set_location(l_proc, 20);
371: --
372: --
373: for Crec in csr_pos_version loop
374: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');

Line 374: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');

370: hr_utility.set_location(l_proc, 20);
371: --
372: --
373: for Crec in csr_pos_version loop
374: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');
375: hr_utility.raise_error;
376: end loop;
377: --
378: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 375: hr_utility.raise_error;

371: --
372: --
373: for Crec in csr_pos_version loop
374: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');
375: hr_utility.raise_error;
376: end loop;
377: --
378: hr_utility.set_location('Leaving:'||l_proc, 30);
379: --

Line 378: hr_utility.set_location('Leaving:'||l_proc, 30);

374: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');
375: hr_utility.raise_error;
376: end loop;
377: --
378: hr_utility.set_location('Leaving:'||l_proc, 30);
379: --
380: end chk_version_number;
381:
382: --

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

392: select 'N' from dual
393: where not exists (select 'Y' from per_position_structures where position_structure_id = p_position_structure_id);
394: begin
395: --
396: hr_utility.set_location('Entering:'|| l_proc, 10);
397: --
398: --
399: hr_api.mandatory_arg_error
400: (p_api_name => l_proc

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

401: ,p_argument => 'p_position_structure_id'
402: ,p_argument_value => p_position_structure_id);
403:
404: --
405: hr_utility.set_location(l_proc, 20);
406: --
407: --
408: for c1 in csr_pos_Str loop
409: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');

Line 409: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');

405: hr_utility.set_location(l_proc, 20);
406: --
407: --
408: for c1 in csr_pos_Str loop
409: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');
410: hr_utility.raise_error;
411: end loop;
412:
413: --

Line 410: hr_utility.raise_error;

406: --
407: --
408: for c1 in csr_pos_Str loop
409: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');
410: hr_utility.raise_error;
411: end loop;
412:
413: --
414: --

Line 415: hr_utility.set_location('Leaving:'||l_proc, 30);

411: end loop;
412:
413: --
414: --
415: hr_utility.set_location('Leaving:'||l_proc, 30);
416: --
417: end chk_position_structure_id;
418:
419:

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

493: --
494: l_proc varchar2(72) := g_package||'insert_validate';
495: --
496: Begin
497: hr_utility.set_location('Entering:'||l_proc, 5);
498: --
499: -- Call all supporting business operations
500: --
501: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

517: p_gap_warning => p_gap_warning);
518:
519: --
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 10);
522: End insert_validate;
523: --
524: -- ----------------------------------------------------------------------------
525: -- |---------------------------< update_validate >----------------------------|

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

532: --
533: l_proc varchar2(72) := g_package||'update_validate';
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Call all supporting business operations
539: --
540: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

557: p_position_structure_id => p_rec.position_structure_id,
558: p_gap_warning => p_gap_warning);
559:
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: End update_validate;
563: --
564: -- ----------------------------------------------------------------------------
565: -- |---------------------------< delete_validate >----------------------------|

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

570: --
571: l_proc varchar2(72) := g_package||'delete_validate';
572: --
573: Begin
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- Call all supporting business operations
577: --
578: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- Call all supporting business operations
577: --
578: hr_utility.set_location(' Leaving:'||l_proc, 10);
579: End delete_validate;
580: --
581: end per_psv_bus;