DBA Data[Home] [Help]

APPS.PER_QAT_BUS dependencies on HR_UTILITY

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: per_qua_bus.set_security_group_id(p_qualification_id => p_qualification_id);
44: --
45: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: per_qua_bus.set_security_group_id(p_qualification_id => p_qualification_id);
44: --
45: hr_utility.set_location(' Leaving:'|| l_proc, 20);
46: --
47: end set_security_group_id;
48: --
49: -- ---------------------------------------------------------------------------

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

73: l_proc varchar2(72) := g_package||'return_legislation_code';
74: --
75: Begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);
78: --
79: -- Ensure that all the mandatory parameter are not null
80: --
81: hr_api.mandatory_arg_error

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

94: -- call to this function. Just return the value in the global
95: -- variable.
96: --
97: l_legislation_code := per_qat_bus.g_legislation_code;
98: hr_utility.set_location(l_proc, 20);
99: else
100: --
101: -- The ID is different to the last call to this function
102: -- or this is the first call to this function.

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

111: close csr_leg_code;
112: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
113: fnd_message.raise_error;
114: end if;
115: hr_utility.set_location(l_proc,30);
116: --
117: -- Set the global variables so the values are
118: -- available for the next call to this function.
119: --

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

121: per_qat_bus.g_qualification_id := p_qualification_id;
122: per_qat_bus.g_language := p_language;
123: per_qat_bus.g_legislation_code := l_legislation_code;
124: end if;
125: hr_utility.set_location(' Leaving:'|| l_proc, 40);
126: return l_legislation_code;
127: end return_legislation_code;
128: --
129: -- ----------------------------------------------------------------------------

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

229: l_dummy varchar2(1);
230: --
231: Begin
232: --
233: hr_utility.set_location('Entering:'||l_proc,5);
234: --
235: if hr_multi_message.no_all_inclusive_error
236: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
237: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

Line 301: hr_utility.set_message(801,'HR_51847_QUA_REC_EXISTS');

297: --
298: -- raise error as qualification record already exists within these
299: -- date boundaries.
300: --
301: hr_utility.set_message(801,'HR_51847_QUA_REC_EXISTS');
302: hr_utility.raise_error;
303: --
304: end if;
305: --

Line 302: hr_utility.raise_error;

298: -- raise error as qualification record already exists within these
299: -- date boundaries.
300: --
301: hr_utility.set_message(801,'HR_51847_QUA_REC_EXISTS');
302: hr_utility.raise_error;
303: --
304: end if;
305: --
306: close c1;

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

310: end if; -- no_all_inclusive_error 2
311: --
312: end if; -- no_all_inclusive_error 1
313: --
314: hr_utility.set_location('Leaving:'||l_proc,10);
315: --
316: End chk_qual_overlap;
317: --
318: --

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

343: l_qau_rec csr_qualification%ROWTYPE;
344: --
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc,5);
348: --
349: open csr_qualification;
350: --
351: fetch csr_qualification into l_qau_rec;

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

365: ,p_object_version_number => l_qau_rec.object_version_number
366: ,p_party_id => l_qau_rec.party_id
367: ,p_language => p_rec.language);
368: --
369: hr_utility.set_location('Leaving:'||l_proc,10);
370: --
371: End chk_qual_overlap;
372: --
373: -- ----------------------------------------------------------------------------

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

380: --
381: l_proc varchar2(72) := g_package||'insert_validate';
382: --
383: Begin
384: hr_utility.set_location('Entering:'||l_proc, 5);
385: --
386: -- Call all supporting business operations
387: --
388: chk_qual_overlap

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

390: ,p_qualification_id => p_qualification_id
391: );
392: --
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End insert_validate;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |---------------------------< update_validate >----------------------------|

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

403: --
404: l_proc varchar2(72) := g_package||'update_validate';
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Call all supporting business operations
410: --
411: --

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

420: chk_qual_overlap
421: (p_rec => p_rec
422: );
423: --
424: hr_utility.set_location(' Leaving:'||l_proc, 10);
425: End update_validate;
426: --
427: -- ----------------------------------------------------------------------------
428: -- |---------------------------< delete_validate >----------------------------|

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

433: --
434: l_proc varchar2(72) := g_package||'delete_validate';
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 5);
438: --
439: -- Call all supporting business operations
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

437: hr_utility.set_location('Entering:'||l_proc, 5);
438: --
439: -- Call all supporting business operations
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: End delete_validate;
443: --
444: -- ----------------------------------------------------------------------------
445: -- |-----------------------< set_translation_globals >------------------------|

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

458: l_proc varchar2(72) := g_package||'set_translation_globals';
459: --
460: BEGIN
461: --
462: hr_utility.set_location('Entering:'||l_proc,5);
463: --
464: g_qualification_type_id := p_qualification_type_id;
465: g_person_id := p_person_id;
466: g_attendance_id := p_attendance_id;

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

469: g_start_date := p_start_date;
470: g_end_date := p_end_date;
471: g_party_id := p_party_id;
472: --
473: hr_utility.set_location('Leaving:'||l_proc,10);
474: --
475: END;
476: --
477: -- ----------------------------------------------------------------------------

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

501: l_proc varchar2(72) := g_package||'validate_translation';
502: --
503: Begin
504: --
505: hr_utility.set_location('Entering:'||l_proc,5);
506: --
507: chk_qual_overlap
508: (p_qualification_id => p_qualification_id
509: ,p_qualification_type_id => nvl(p_qualification_type_id,

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

518: g_object_version_number)
519: ,p_party_id => nvl(p_party_id, g_party_id)
520: ,p_language => p_language);
521: --
522: hr_utility.set_location('Leaving:'||l_proc,10);
523: --
524: End validate_translation;
525: --
526: end per_qat_bus;