DBA Data[Home] [Help]

APPS.GHR_LEI_FLEX_DDF dependencies on HR_UTILITY

Line 46: hr_utility.set_location('Entering:'||l_proc, 1);

42: --
43: l_proc varchar2(72) := g_package||'val_info_type_y';
44: --
45: begin
46: hr_utility.set_location('Entering:'||l_proc, 1);
47: --
48: -- Enter procedure code here
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 2);

Line 50: hr_utility.set_location(' Leaving:'||l_proc, 2);

46: hr_utility.set_location('Entering:'||l_proc, 1);
47: --
48: -- Enter procedure code here
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 2);
51: end val_info_type_y;
52: -- ----------------------------------------------------------------------------
53: -- |--------------------------< val_info_type_x >------------------------------|
54: -- ----------------------------------------------------------------------------

Line 88: hr_utility.set_location('Entering:'||l_proc, 1);

84: --
85: l_proc varchar2(72) := g_package||'val_info_type_x';
86: --
87: begin
88: hr_utility.set_location('Entering:'||l_proc, 1);
89: --
90: -- Enter procedure code here
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 2);

Line 92: hr_utility.set_location(' Leaving:'||l_proc, 2);

88: hr_utility.set_location('Entering:'||l_proc, 1);
89: --
90: -- Enter procedure code here
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 2);
93: end val_info_type_x;
94: -- ----------------------------------------------------------------------------
95: -- |-------------------------------< ddf >-------------------------------------|
96: -- ----------------------------------------------------------------------------

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

175: and trunc(p_effective_date) between(effective_start_date) and
176: nvl(effective_end_date,p_effective_date);
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: if ghr_utility.is_ghr = 'TRUE' then
182: /*
183: -- Check for value of reference field an then

Line 181: if ghr_utility.is_ghr = 'TRUE' then

177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: if ghr_utility.is_ghr = 'TRUE' then
182: /*
183: -- Check for value of reference field an then
184: -- call relevant validation procedure.
185: --

Line 203: hr_utility.set_message(801, 'HR_7438_FLEX_INV_REF_FIELD_VAL');

199: else
200: --
201: -- Reference field values is not supported
202: --
203: hr_utility.set_message(801, 'HR_7438_FLEX_INV_REF_FIELD_VAL');
204: hr_utility.raise_error;
205: end if;
206: else
207: --

Line 204: hr_utility.raise_error;

200: --
201: -- Reference field values is not supported
202: --
203: hr_utility.set_message(801, 'HR_7438_FLEX_INV_REF_FIELD_VAL');
204: hr_utility.raise_error;
205: end if;
206: else
207: --
208: -- When the reference field is null, check

Line 223: hr_utility.set_message(8301, 'GHR_38277_DUTY_STATION_NOT_FND');

219: open c2(nvl(l_effective_date,sysdate));
220: fetch c2 into l_duty_station;
221: if c2%NOTFOUND then
222: close c2;
223: hr_utility.set_message(8301, 'GHR_38277_DUTY_STATION_NOT_FND');
224: hr_utility.raise_error;
225: else
226: close c2;
227: end if;

Line 224: hr_utility.raise_error;

220: fetch c2 into l_duty_station;
221: if c2%NOTFOUND then
222: close c2;
223: hr_utility.set_message(8301, 'GHR_38277_DUTY_STATION_NOT_FND');
224: hr_utility.raise_error;
225: else
226: close c2;
227: end if;
228: elsif p_lei_information1 is not null then

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

289: --
290: /*
291: endif;
292: */
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294:
295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then

Line 295: end if; -- ghr_utility.is_ghr

291: endif;
292: */
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294:
295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;

Line 298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');

294:
295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301:
302: end ddf;

Line 299: hr_utility.raise_error;

295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301:
302: end ddf;
303: --

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

296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301:
302: end ddf;
303: --
304: end ghr_lei_flex_ddf;