eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_REI_FLEX_DDF dependencies on HR_UTILITY

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

16: l_proc varchar2(72) := g_package||'ddf';
17: l_error exception;
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_location('Entering:'||l_proc, 5);
23: --
24: -- Call check procedures to validate reason for submission, explanation and

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

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_location('Entering:'||l_proc, 5);
23: --
24: -- Call check procedures to validate reason for submission, explanation and
25: -- service only
26: -- when information type is 'GHR_US_PD_GEN_EMP'.

Line 63: hr_utility.set_message(8301, 'GHR_38117_FLEX_INV_REF_FIELD_V');

59: else
60: --
61: -- Reference field values is not supported
62: --
63: hr_utility.set_message(8301, 'GHR_38117_FLEX_INV_REF_FIELD_V');
64: hr_utility.raise_error;
65: end if;
66: else
67: --

Line 64: hr_utility.raise_error;

60: --
61: -- Reference field values is not supported
62: --
63: hr_utility.set_message(8301, 'GHR_38117_FLEX_INV_REF_FIELD_V');
64: hr_utility.raise_error;
65: end if;
66: else
67: --
68: -- When the reference field is null, check

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

134: end if;
135: */
136: --
137:
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: exception
140: when l_error then
141: hr_utility.set_message(8301, 'GHR_38118_FLEX_INV_ATTRIBUTE_A');
142: hr_utility.raise_error;

Line 141: hr_utility.set_message(8301, 'GHR_38118_FLEX_INV_ATTRIBUTE_A');

137:
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: exception
140: when l_error then
141: hr_utility.set_message(8301, 'GHR_38118_FLEX_INV_ATTRIBUTE_A');
142: hr_utility.raise_error;
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: end ddf;
145: --

Line 142: hr_utility.raise_error;

138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: exception
140: when l_error then
141: hr_utility.set_message(8301, 'GHR_38118_FLEX_INV_ATTRIBUTE_A');
142: hr_utility.raise_error;
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: end ddf;
145: --
146:

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

139: exception
140: when l_error then
141: hr_utility.set_message(8301, 'GHR_38118_FLEX_INV_ATTRIBUTE_A');
142: hr_utility.raise_error;
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: end ddf;
145: --
146:
147: -- -------------------------------------------------------------------------

Line 162: hr_utility.set_location('Entering: '|| l_proc, 10);

158: l_proc varchar2(72) := 'chk_reason_for_submission';
159: l_api_updating boolean;
160: --
161: begin
162: hr_utility.set_location('Entering: '|| l_proc, 10);
163: --
164: -- Check mandatory parameters have been set
165: --
166: hr_api.mandatory_arg_error

Line 186: hr_utility.set_location(l_proc, 20);

182: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
183: <> nvl(p_reason_for_submission, hr_api.g_varchar2)) or
184: (not l_api_updating))
185: then
186: hr_utility.set_location(l_proc, 20);
187: --
188: -- If reason_for_submission is not null then
189: -- Check if the reason_for_submission value exists in hr_lookups
190: -- where the lookup_type is 'GHR_US_SUBMISSION_REASON'

Line 201: hr_utility.set_message(8301, 'GHR_REASON_FOR_SUB_INVALID');

197: ,p_lookup_code => p_reason_for_submission
198: )
199: then
200: -- Error: Invalid reason_for_submission
201: hr_utility.set_message(8301, 'GHR_REASON_FOR_SUB_INVALID');
202: hr_utility.raise_error;
203: end if;
204: hr_utility.set_location(l_proc, 30);
205: end if;

Line 202: hr_utility.raise_error;

198: )
199: then
200: -- Error: Invalid reason_for_submission
201: hr_utility.set_message(8301, 'GHR_REASON_FOR_SUB_INVALID');
202: hr_utility.raise_error;
203: end if;
204: hr_utility.set_location(l_proc, 30);
205: end if;
206: end if;

Line 204: hr_utility.set_location(l_proc, 30);

200: -- Error: Invalid reason_for_submission
201: hr_utility.set_message(8301, 'GHR_REASON_FOR_SUB_INVALID');
202: hr_utility.raise_error;
203: end if;
204: hr_utility.set_location(l_proc, 30);
205: end if;
206: end if;
207: hr_utility.set_location(' Leavig:'|| l_proc, 40);
208: end chk_reason_for_submission;

Line 207: hr_utility.set_location(' Leavig:'|| l_proc, 40);

203: end if;
204: hr_utility.set_location(l_proc, 30);
205: end if;
206: end if;
207: hr_utility.set_location(' Leavig:'|| l_proc, 40);
208: end chk_reason_for_submission;
209: --
210: -- ----------------------------------------------------------------------------------------------------
211: -- |------------------------------- < chk_explanation > ----------------------------------------------|

Line 225: hr_utility.set_location('Entering: '|| l_proc, 10);

221: l_proc varchar2(72) := 'chk_explanation';
222: l_api_updating boolean;
223: --
224: begin
225: hr_utility.set_location('Entering: '|| l_proc, 10);
226: --
227: -- Only proceed with validation if a record is being inserted
228: --
229: l_api_updating := ghr_rei_shd.api_updating

Line 237: hr_utility.set_message(8301, 'GHR_NO_EXPLANATION');

233: if (not l_api_updating)
234: then
235: if (p_reason_for_submission = '4' and (p_explanation is null))
236: then
237: hr_utility.set_message(8301, 'GHR_NO_EXPLANATION');
238: hr_utility.raise_error;
239: end if;
240: end if;
241: hr_utility.set_location('Leaving: '|| l_proc, 20);

Line 238: hr_utility.raise_error;

234: then
235: if (p_reason_for_submission = '4' and (p_explanation is null))
236: then
237: hr_utility.set_message(8301, 'GHR_NO_EXPLANATION');
238: hr_utility.raise_error;
239: end if;
240: end if;
241: hr_utility.set_location('Leaving: '|| l_proc, 20);
242: end chk_explanation;

Line 241: hr_utility.set_location('Leaving: '|| l_proc, 20);

237: hr_utility.set_message(8301, 'GHR_NO_EXPLANATION');
238: hr_utility.raise_error;
239: end if;
240: end if;
241: hr_utility.set_location('Leaving: '|| l_proc, 20);
242: end chk_explanation;
243: --
244: -- ---------------------------------------------------------------------------------------------------
245: -- |-------------------------------- < chk_service > ------------------------------------------------|

Line 259: hr_utility.set_location('Entering: '|| l_proc, 10);

255: l_proc varchar2(72) := 'chk_service';
256: l_api_updating boolean;
257: --
258: begin
259: hr_utility.set_location('Entering: '|| l_proc, 10);
260: --
261: -- Check mandatory parameters have been set
262: --
263: hr_api.mandatory_arg_error

Line 284: hr_utility.set_location(l_proc, 20);

280: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)
281: <> nvl(p_service, hr_api.g_varchar2)) or
282: (not l_api_updating))
283: then
284: hr_utility.set_location(l_proc, 20);
285: --
286: -- If service is not null then
287: -- Check if the service value exists in hr_lookups
288: -- where the lookup type is 'GHR_US_SERVICE'

Line 299: hr_utility.set_message(8301, 'GHR_SERVICE_INVALID');

295: ,p_lookup_code => p_service
296: )
297: then
298: -- Error: Invalid Service
299: hr_utility.set_message(8301, 'GHR_SERVICE_INVALID');
300: hr_utility.raise_error;
301: end if;
302: hr_utility.set_location(l_proc, 30);
303: end if;

Line 300: hr_utility.raise_error;

296: )
297: then
298: -- Error: Invalid Service
299: hr_utility.set_message(8301, 'GHR_SERVICE_INVALID');
300: hr_utility.raise_error;
301: end if;
302: hr_utility.set_location(l_proc, 30);
303: end if;
304: end if;

Line 302: hr_utility.set_location(l_proc, 30);

298: -- Error: Invalid Service
299: hr_utility.set_message(8301, 'GHR_SERVICE_INVALID');
300: hr_utility.raise_error;
301: end if;
302: hr_utility.set_location(l_proc, 30);
303: end if;
304: end if;
305: hr_utility.set_location(' Leaving:'|| l_proc, 40);
306: end chk_service;

Line 305: hr_utility.set_location(' Leaving:'|| l_proc, 40);

301: end if;
302: hr_utility.set_location(l_proc, 30);
303: end if;
304: end if;
305: hr_utility.set_location(' Leaving:'|| l_proc, 40);
306: end chk_service;
307: --
308: end ghr_rei_flex_ddf;