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
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: -- ---------------------------------------------------------------------------
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
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.
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: --
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: -- ---------------------------------------------------------------------------
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
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.
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: --
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: --
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'
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;
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: -- ---------------------------------------------------------------------------+
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'
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;
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);
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: -- ----------------------------------------------------------------------------
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:
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 >----------------------------|
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
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 >----------------------------|
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);
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;