16: l_proc varchar2(72) := g_package||'df';
17: l_error exception;
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: /*
23: -- Check for value of reference field an then
24: -- call relevant validation procedure.
31: else
32: --
33: -- Reference field values is not supported
34: --
35: hr_utility.set_message(8301, 'GHR_38123_FLEX_INV_REF_FIELD_V');
36: hr_utility.raise_error;
37: end if;
38: else
39: --
32: --
33: -- Reference field values is not supported
34: --
35: hr_utility.set_message(8301, 'GHR_38123_FLEX_INV_REF_FIELD_V');
36: hr_utility.raise_error;
37: end if;
38: else
39: --
40: -- When the reference field is null, check
84: elsif p_rec.rei_attribute20 is not null then
85: raise l_error;
86: end if;
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: exception
90: when l_error then
91: hr_utility.set_message(8301, 'GHR_38124_FLEX_INV_ATTRIB_ARG');
92: hr_utility.raise_error;
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: exception
90: when l_error then
91: hr_utility.set_message(8301, 'GHR_38124_FLEX_INV_ATTRIB_ARG');
92: hr_utility.raise_error;
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: end df;
95:
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: exception
90: when l_error then
91: hr_utility.set_message(8301, 'GHR_38124_FLEX_INV_ATTRIB_ARG');
92: hr_utility.raise_error;
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: end df;
95:
96: end ghr_rei_flex;
89: exception
90: when l_error then
91: hr_utility.set_message(8301, 'GHR_38124_FLEX_INV_ATTRIB_ARG');
92: hr_utility.raise_error;
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: end df;
95:
96: end ghr_rei_flex;