DBA Data[Home] [Help]

APPS.PQP_GAP_BUS dependencies on HR_UTILITY

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

43: l_legislation_code varchar2(150);
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error

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

83: --
84: hr_api.set_legislation_context(l_legislation_code);
85: end if;
86: --
87: hr_utility.set_location(' Leaving:'|| l_proc, 20);
88: --
89: end set_security_group_id;
90: --
91: -- ---------------------------------------------------------------------------

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

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

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

130: -- call to this function. Just return the value in the global
131: -- variable.
132: --
133: l_legislation_code := pqp_gap_bus.g_legislation_code;
134: hr_utility.set_location(l_proc, 20);
135: else
136: --
137: -- The ID is different to the last call to this function
138: -- or this is the first call to this function.

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

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

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

156: close csr_leg_code;
157: pqp_gap_bus.g_assignment_id := p_assignment_id;
158: pqp_gap_bus.g_legislation_code := l_legislation_code;
159: end if;
160: hr_utility.set_location(' Leaving:'|| l_proc, 40);
161: return l_legislation_code;
162: end return_legislation_code;
163: --
164: -- ---------------------------------------------------------------------------

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

187: l_proc varchar2(72) := g_package||'return_legislation_code';
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'|| l_proc, 10);
192: --
193: -- Ensure that all the mandatory parameter are not null
194: --
195: hr_api.mandatory_arg_error

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

205: -- call to this function. Just return the value in the global
206: -- variable.
207: --
208: l_legislation_code := pqp_gap_bus.g_legislation_code;
209: hr_utility.set_location(l_proc, 20);
210: else
211: --
212: -- The ID is different to the last call to this function
213: -- or this is the first call to this function.

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

222: close csr_leg_code;
223: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
224: fnd_message.raise_error;
225: end if;
226: hr_utility.set_location(l_proc,30);
227: --
228: -- Set the global variables so the values are
229: -- available for the next call to this function.
230: --

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

231: close csr_leg_code;
232: pqp_gap_bus.g_gap_absence_plan_id := p_gap_absence_plan_id;
233: pqp_gap_bus.g_legislation_code := l_legislation_code;
234: end if;
235: hr_utility.set_location(' Leaving:'|| l_proc, 40);
236: return l_legislation_code;
237: end return_gap_legislation_code;
238:
239: --

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

337: l_AAValid char(1) := 'N';
338: --
339: Begin
340: --
341: hr_utility.set_location(' Entering: '|| l_proc, 10);
342: --
343: hr_api.mandatory_arg_error
344: (p_api_name => l_proc
345: ,p_argument => 'absence_attendance_id'

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

345: ,p_argument => 'absence_attendance_id'
346: ,p_argument_value => p_absence_attendance_id
347: );
348: --
349: hr_utility.set_location(l_proc, 20);
350: --
351: open ChkAbsAttId;
352: fetch ChkAbsAttId into l_AAValid;
353: close ChkAbsAttId;

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

357: fnd_message.set_name('PQP', 'PQP_230947_INVALID_PAA_ID');
358: fnd_message.raise_error;
359: end if; -- l_AAValid = 'N'
360: --
361: hr_utility.set_location(' Leaving: '|| l_proc, 30);
362: --
363: end chk_absence_attendance_id;
364: --
365: -- ---------------------------------------------------------------------------+

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

399: l_PlValid char(1) := 'N';
400: --
401: Begin
402: --
403: hr_utility.set_location(' Entering: '|| l_proc, 10);
404: --
405: hr_api.mandatory_arg_error
406: (p_api_name => l_proc
407: ,p_argument => 'pl_id'

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

414: or
415: (p_gap_absence_plan_id is null)
416: ) then
417:
418: hr_utility.set_location(l_proc, 20);
419: --
420: begin
421: open ChkPlId;
422: fetch ChkPlId into l_PlValid;

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

433: fnd_message.raise_error;
434:
435: end if; -- l_PlValid = 'N'
436: --
437: hr_utility.set_location(l_proc, 30);
438: --
439: end if; -- (((p_gap_absence_plan_id is not null) and...
440: --
441: hr_utility.set_location(' Leaving: '|| l_proc, 40);

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

437: hr_utility.set_location(l_proc, 30);
438: --
439: end if; -- (((p_gap_absence_plan_id is not null) and...
440: --
441: hr_utility.set_location(' Leaving: '|| l_proc, 40);
442: --
443: end chk_pl_id;
444: --
445: -- ----------------------------------------------------------------------------

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

452: --
453: l_proc varchar2(72) := g_package||'insert_validate';
454: --
455: Begin
456: hr_utility.set_location('Entering:'||l_proc, 5);
457: --
458: -- Call all supporting business operations
459: --
460:

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

475: (p_gap_absence_plan_id => p_rec.absence_attendance_id
476: ,p_pl_id => p_rec.pl_id
477: );
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 10);
480: End insert_validate;
481: --
482: -- ----------------------------------------------------------------------------
483: -- |---------------------------< update_validate >----------------------------|

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

489: --
490: l_proc varchar2(72) := g_package||'update_validate';
491: --
492: Begin
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- Call all supporting business operations
496: --
497: pqp_gap_bus.set_security_group_id

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

513: (p_gap_absence_plan_id => p_rec.absence_attendance_id
514: ,p_pl_id => p_rec.pl_id
515: );
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 10);
518: End update_validate;
519: --
520: -- ----------------------------------------------------------------------------
521: -- |---------------------------< delete_validate >----------------------------|

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

526: --
527: l_proc varchar2(72) := g_package||'delete_validate';
528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Call all supporting business operations
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Call all supporting business operations
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 10);
535: End delete_validate;
536: --
537: end pqp_gap_bus;