[Home] [Help]
36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------
96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_ret_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_ret_bus.g_cagr_retained_right_id := p_cagr_retained_right_id;
142: per_ret_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------
394: --
395: l_proc varchar2(72) := g_package||'insert_validate';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Call all supporting business operations
401: --
402: -- ensure lookup validation fires when BG is not null
407:
408:
409: --
410: --
411: hr_utility.set_location(' Leaving:'||l_proc, 10);
412: End insert_validate;
413: --
414: -- ----------------------------------------------------------------------------
415: -- |---------------------------< update_validate >----------------------------|
421: --
422: l_proc varchar2(72) := g_package||'update_validate';
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: -- Call all supporting business operations
428: --
429: if p_rec.business_group_id is not null then
435: ,p_rec => p_rec
436: );
437: --
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End update_validate;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |---------------------------< delete_validate >----------------------------|
448: --
449: l_proc varchar2(72) := g_package||'delete_validate';
450: --
451: Begin
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- Call all supporting business operations
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- Call all supporting business operations
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End delete_validate;
458: --
459: end per_ret_bus;