43: --
44: l_proc varchar2(72) := g_package||'val_info_type_y';
45: --
46: begin
47: hr_utility.set_location('Entering:'||l_proc, 1);
48: --
49: -- Enter procedure code here
50: --
51: hr_utility.set_location(' Leaving:'||l_proc, 2);
47: hr_utility.set_location('Entering:'||l_proc, 1);
48: --
49: -- Enter procedure code here
50: --
51: hr_utility.set_location(' Leaving:'||l_proc, 2);
52: end val_info_type_y;
53: -- ----------------------------------------------------------------------------
54: -- |--------------------------< val_info_type_x >------------------------------|
55: -- ----------------------------------------------------------------------------
85: --
86: l_proc varchar2(72) := g_package||'val_info_type_x';
87: --
88: begin
89: hr_utility.set_location('Entering:'||l_proc, 1);
90: --
91: -- Enter procedure code here
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 2);
89: hr_utility.set_location('Entering:'||l_proc, 1);
90: --
91: -- Enter procedure code here
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 2);
94: end val_info_type_x;
95: -- ----------------------------------------------------------------------------
96: -- |-------------------------------< ddf >-------------------------------------|
97: -- ----------------------------------------------------------------------------
102: l_proc varchar2(72) := g_package||'ddf';
103: l_error exception;
104: --
105: Begin
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: --
108: /*
109: -- Check for value of reference field an then
110: -- call relevant validation procedure.
125: else
126: --
127: -- Reference field values is not supported
128: --
129: hr_utility.set_message(801, 'HR_7438_FLEX_INV_REF_FIELD_VAL');
130: hr_utility.raise_error;
131: end if;
132: else
133: --
126: --
127: -- Reference field values is not supported
128: --
129: hr_utility.set_message(801, 'HR_7438_FLEX_INV_REF_FIELD_VAL');
130: hr_utility.raise_error;
131: end if;
132: else
133: --
134: -- When the reference field is null, check
200: --
201: /*
202: endif;
203: */
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: --
206: exception
207: when l_error then
208: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: --
206: exception
207: when l_error then
208: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
209: hr_utility.raise_error;
210: hr_utility.set_location(' Leaving:'||l_proc, 10);
211: end ddf;
212:
205: --
206: exception
207: when l_error then
208: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
209: hr_utility.raise_error;
210: hr_utility.set_location(' Leaving:'||l_proc, 10);
211: end ddf;
212:
213: --
206: exception
207: when l_error then
208: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
209: hr_utility.raise_error;
210: hr_utility.set_location(' Leaving:'||l_proc, 10);
211: end ddf;
212:
213: --
214: end pe_jei_flex_ddf;