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_POI_FLEX_DDF dependencies on HR_UTILITY

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

97: where session_id = (select userenv('sessionid') from dual);
98:
99: l_session_date date;
100: Begin
101: hr_utility.set_location('Entering:'||l_proc, 5);
102:
103: if ghr_utility.is_ghr = 'TRUE' then
104: -- Added by Dinkar Karumuri
105: if p_information_type is not null

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

99: l_session_date date;
100: Begin
101: hr_utility.set_location('Entering:'||l_proc, 5);
102:
103: if ghr_utility.is_ghr = 'TRUE' then
104: -- Added by Dinkar Karumuri
105: if p_information_type is not null
106: then
107: if p_information_type = 'GHR_US_POSITION_DESCRIPTION'

Line 125: if ghr_utility.is_ghr_nfc = 'TRUE' then

121: );
122: end if;
123: end if;
124:
125: if ghr_utility.is_ghr_nfc = 'TRUE' then
126: -- Get Session Date
127: l_session_date := trunc(sysdate);
128: for ses_rec in c_get_session_date loop
129: l_session_date := ses_rec.session_date;

Line 139: hr_utility.set_message(8301, 'GHR_38945_NFC_ERROR1');

135: -- GHR_US_POS_GRP1 --> Personnel Officer ID
136:
137: if p_information_type = 'GHR_US_POS_GRP1' then
138: if c_pos_rec.segment4 <> p_poei_information3 then
139: hr_utility.set_message(8301, 'GHR_38945_NFC_ERROR1');
140: hr_utility.raise_error;
141: end if;
142: end if;
143: -- GHR_US_POS_GRP3 --> NFC Agency Code

Line 140: hr_utility.raise_error;

136:
137: if p_information_type = 'GHR_US_POS_GRP1' then
138: if c_pos_rec.segment4 <> p_poei_information3 then
139: hr_utility.set_message(8301, 'GHR_38945_NFC_ERROR1');
140: hr_utility.raise_error;
141: end if;
142: end if;
143: -- GHR_US_POS_GRP3 --> NFC Agency Code
144: if p_information_type = 'GHR_US_POS_GRP3' then

Line 146: hr_utility.set_message(8301, 'GHR_38947_NFC_ERROR3');

142: end if;
143: -- GHR_US_POS_GRP3 --> NFC Agency Code
144: if p_information_type = 'GHR_US_POS_GRP3' then
145: if c_pos_rec.segment3 <> p_poei_information21 then
146: hr_utility.set_message(8301, 'GHR_38947_NFC_ERROR3');
147: hr_utility.raise_error;
148: end if;
149: end if;
150: -- GHR_US_POS_VALID_GRADE --> Grade From

Line 147: hr_utility.raise_error;

143: -- GHR_US_POS_GRP3 --> NFC Agency Code
144: if p_information_type = 'GHR_US_POS_GRP3' then
145: if c_pos_rec.segment3 <> p_poei_information21 then
146: hr_utility.set_message(8301, 'GHR_38947_NFC_ERROR3');
147: hr_utility.raise_error;
148: end if;
149: end if;
150: -- GHR_US_POS_VALID_GRADE --> Grade From
151: if p_information_type = 'GHR_US_POS_VALID_GRADE' then

Line 153: hr_utility.set_message(8301, 'GHR_38946_NFC_ERROR2');

149: end if;
150: -- GHR_US_POS_VALID_GRADE --> Grade From
151: if p_information_type = 'GHR_US_POS_VALID_GRADE' then
152: if c_pos_rec.segment7 <> p_poei_information3 then
153: hr_utility.set_message(8301, 'GHR_38946_NFC_ERROR2');
154: hr_utility.raise_error;
155: end if;
156: end if;
157: end loop;

Line 154: hr_utility.raise_error;

150: -- GHR_US_POS_VALID_GRADE --> Grade From
151: if p_information_type = 'GHR_US_POS_VALID_GRADE' then
152: if c_pos_rec.segment7 <> p_poei_information3 then
153: hr_utility.set_message(8301, 'GHR_38946_NFC_ERROR2');
154: hr_utility.raise_error;
155: end if;
156: end if;
157: end loop;
158:

Line 159: end if; -- ghr_utility.is_ghr_nfc

155: end if;
156: end if;
157: end loop;
158:
159: end if; -- ghr_utility.is_ghr_nfc
160: end if; -- ghr_utility.is_ghr
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: exception
163: when l_error then

Line 160: end if; -- ghr_utility.is_ghr

156: end if;
157: end loop;
158:
159: end if; -- ghr_utility.is_ghr_nfc
160: end if; -- ghr_utility.is_ghr
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: exception
163: when l_error then
164: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');

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

157: end loop;
158:
159: end if; -- ghr_utility.is_ghr_nfc
160: end if; -- ghr_utility.is_ghr
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: exception
163: when l_error then
164: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
165: hr_utility.raise_error;

Line 164: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');

160: end if; -- ghr_utility.is_ghr
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: exception
163: when l_error then
164: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
165: hr_utility.raise_error;
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167:
168: end ddf;

Line 165: hr_utility.raise_error;

161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: exception
163: when l_error then
164: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
165: hr_utility.raise_error;
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167:
168: end ddf;
169:

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

162: exception
163: when l_error then
164: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
165: hr_utility.raise_error;
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167:
168: end ddf;
169:
170:

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

244: from fnd_sessions
245: where session_id = (select userenv('sessionid') from dual);
246: l_session_date date;
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249:
250: if ghr_utility.is_ghr_nfc = 'TRUE' then
251: -- Get Session Date
252: l_session_date := trunc(sysdate);

Line 250: if ghr_utility.is_ghr_nfc = 'TRUE' then

246: l_session_date date;
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249:
250: if ghr_utility.is_ghr_nfc = 'TRUE' then
251: -- Get Session Date
252: l_session_date := trunc(sysdate);
253: for ses_rec in c_get_session_date loop
254: l_session_date := ses_rec.session_date;

Line 264: hr_utility.set_message(8301, 'GHR_38945_NFC_ERROR1');

260: -- from the Position KFF
261: -- GHR_US_POS_GRP1 --> Personnel Officer ID
262: if p_information_type = 'GHR_US_POS_GRP1' then
263: if c_pos_rec.segment4 <> p_poei_information3 then
264: hr_utility.set_message(8301, 'GHR_38945_NFC_ERROR1');
265: hr_utility.raise_error;
266: end if;
267: end if;
268: -- GHR_US_POS_GRP3 --> NFC Agency Code

Line 265: hr_utility.raise_error;

261: -- GHR_US_POS_GRP1 --> Personnel Officer ID
262: if p_information_type = 'GHR_US_POS_GRP1' then
263: if c_pos_rec.segment4 <> p_poei_information3 then
264: hr_utility.set_message(8301, 'GHR_38945_NFC_ERROR1');
265: hr_utility.raise_error;
266: end if;
267: end if;
268: -- GHR_US_POS_GRP3 --> NFC Agency Code
269: if p_information_type = 'GHR_US_POS_GRP3' then

Line 271: hr_utility.set_message(8301, 'GHR_38947_NFC_ERROR3');

267: end if;
268: -- GHR_US_POS_GRP3 --> NFC Agency Code
269: if p_information_type = 'GHR_US_POS_GRP3' then
270: if c_pos_rec.segment3 <> p_poei_information21 then
271: hr_utility.set_message(8301, 'GHR_38947_NFC_ERROR3');
272: hr_utility.raise_error;
273: end if;
274: end if;
275: -- GHR_US_POS_VALID_GRADE --> Grade From

Line 272: hr_utility.raise_error;

268: -- GHR_US_POS_GRP3 --> NFC Agency Code
269: if p_information_type = 'GHR_US_POS_GRP3' then
270: if c_pos_rec.segment3 <> p_poei_information21 then
271: hr_utility.set_message(8301, 'GHR_38947_NFC_ERROR3');
272: hr_utility.raise_error;
273: end if;
274: end if;
275: -- GHR_US_POS_VALID_GRADE --> Grade From
276: if p_information_type = 'GHR_US_POS_VALID_GRADE' then

Line 278: hr_utility.set_message(8301, 'GHR_38946_NFC_ERROR2');

274: end if;
275: -- GHR_US_POS_VALID_GRADE --> Grade From
276: if p_information_type = 'GHR_US_POS_VALID_GRADE' then
277: if c_pos_rec.segment7 <> p_poei_information3 then
278: hr_utility.set_message(8301, 'GHR_38946_NFC_ERROR2');
279: hr_utility.raise_error;
280: end if;
281: end if;
282: end loop;

Line 279: hr_utility.raise_error;

275: -- GHR_US_POS_VALID_GRADE --> Grade From
276: if p_information_type = 'GHR_US_POS_VALID_GRADE' then
277: if c_pos_rec.segment7 <> p_poei_information3 then
278: hr_utility.set_message(8301, 'GHR_38946_NFC_ERROR2');
279: hr_utility.raise_error;
280: end if;
281: end if;
282: end loop;
283: end if; -- ghr_utility.is_nfc_ghr

Line 283: end if; -- ghr_utility.is_nfc_ghr

279: hr_utility.raise_error;
280: end if;
281: end if;
282: end loop;
283: end if; -- ghr_utility.is_nfc_ghr
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: exception
286: when l_error then
287: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');

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

280: end if;
281: end if;
282: end loop;
283: end if; -- ghr_utility.is_nfc_ghr
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: exception
286: when l_error then
287: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
288: hr_utility.raise_error;

Line 287: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');

283: end if; -- ghr_utility.is_nfc_ghr
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: exception
286: when l_error then
287: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
288: hr_utility.raise_error;
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290:
291: end create_ddf;

Line 288: hr_utility.raise_error;

284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: exception
286: when l_error then
287: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
288: hr_utility.raise_error;
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290:
291: end create_ddf;
292:

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

285: exception
286: when l_error then
287: hr_utility.set_message(999, 'HR_9999_FLEX_INV_INFO_ARG');
288: hr_utility.raise_error;
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290:
291: end create_ddf;
292:
293:

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

303: l_proc varchar2(72) := 'chk_date_from';
304: l_api_updating boolean;
305: --
306: begin
307: hr_utility.set_location('Entering: '|| l_proc, 10);
308: --
309: if p_position_description_id is not null and p_date_from is null
310: then
311: hr_utility.set_message(8301, 'GHR_DATE_FROM_INVALID');

Line 311: hr_utility.set_message(8301, 'GHR_DATE_FROM_INVALID');

307: hr_utility.set_location('Entering: '|| l_proc, 10);
308: --
309: if p_position_description_id is not null and p_date_from is null
310: then
311: hr_utility.set_message(8301, 'GHR_DATE_FROM_INVALID');
312: hr_utility.raise_error;
313: end if;
314: hr_utility.set_location('Leaving: '|| l_proc, 20);
315: end chk_date_from;

Line 312: hr_utility.raise_error;

308: --
309: if p_position_description_id is not null and p_date_from is null
310: then
311: hr_utility.set_message(8301, 'GHR_DATE_FROM_INVALID');
312: hr_utility.raise_error;
313: end if;
314: hr_utility.set_location('Leaving: '|| l_proc, 20);
315: end chk_date_from;
316: --

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

310: then
311: hr_utility.set_message(8301, 'GHR_DATE_FROM_INVALID');
312: hr_utility.raise_error;
313: end if;
314: hr_utility.set_location('Leaving: '|| l_proc, 20);
315: end chk_date_from;
316: --
317: -- ---------------------------------------------------------------------------------------------------
318: -- |------------------------------- < chk_pos_desc_id > ---------------------------------------------|

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

331: from ghr_position_descriptions
332: where position_description_id = to_number(p_pos_desc_id);
333: --
334: begin
335: hr_utility.set_location('Entering: '|| l_proc, 10);
336: --
337: -- Check mandatory parameters have been set
338: --
339: hr_api.mandatory_arg_error

Line 346: hr_utility.set_message(8301, 'GHR_POS_DESC_ID_INVALID');

342: ,p_argument_value => p_pos_desc_id
343: );
344: if p_pos_desc_id is null
345: then
346: hr_utility.set_message(8301, 'GHR_POS_DESC_ID_INVALID');
347: hr_utility.raise_error;
348: end if;
349: open csr_pos_desc;
350: fetch csr_pos_desc into l_exists;

Line 347: hr_utility.raise_error;

343: );
344: if p_pos_desc_id is null
345: then
346: hr_utility.set_message(8301, 'GHR_POS_DESC_ID_INVALID');
347: hr_utility.raise_error;
348: end if;
349: open csr_pos_desc;
350: fetch csr_pos_desc into l_exists;
351: if csr_pos_desc%notfound then

Line 353: hr_utility.set_message(8301, 'GHR_PD_FOREIGN_KEY_CONSTRAINT');

349: open csr_pos_desc;
350: fetch csr_pos_desc into l_exists;
351: if csr_pos_desc%notfound then
352: close csr_pos_desc;
353: hr_utility.set_message(8301, 'GHR_PD_FOREIGN_KEY_CONSTRAINT');
354: hr_utility.raise_error;
355: end if ;
356: hr_utility.set_location(' Leaving: '|| l_proc, 20);
357: end chk_pos_desc_id;

Line 354: hr_utility.raise_error;

350: fetch csr_pos_desc into l_exists;
351: if csr_pos_desc%notfound then
352: close csr_pos_desc;
353: hr_utility.set_message(8301, 'GHR_PD_FOREIGN_KEY_CONSTRAINT');
354: hr_utility.raise_error;
355: end if ;
356: hr_utility.set_location(' Leaving: '|| l_proc, 20);
357: end chk_pos_desc_id;
358: --

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

352: close csr_pos_desc;
353: hr_utility.set_message(8301, 'GHR_PD_FOREIGN_KEY_CONSTRAINT');
354: hr_utility.raise_error;
355: end if ;
356: hr_utility.set_location(' Leaving: '|| l_proc, 20);
357: end chk_pos_desc_id;
358: --
359: -- ---------------------------------------------------------------------------------------------------
360: -- |------------------------------------ < chk_date_to >---------------------------------------------|

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

369: l_proc varchar2(72) := 'chk_date_to';
370: l_api_updating boolean;
371: --
372: begin
373: hr_utility.set_location('Entering: '|| l_proc, 10);
374: if p_date_to is not null and p_date_from is not null
375: then
376: if not(fnd_date.canonical_to_date(p_date_to) > fnd_date.canonical_to_date(p_date_from))
377: then

Line 378: hr_utility.set_message(8301, 'GHR_DATE_TO_INVALID');

374: if p_date_to is not null and p_date_from is not null
375: then
376: if not(fnd_date.canonical_to_date(p_date_to) > fnd_date.canonical_to_date(p_date_from))
377: then
378: hr_utility.set_message(8301, 'GHR_DATE_TO_INVALID');
379: hr_utility.raise_error;
380: end if;
381: end if;
382: hr_utility.set_location('Leaving: '|| l_proc, 10);

Line 379: hr_utility.raise_error;

375: then
376: if not(fnd_date.canonical_to_date(p_date_to) > fnd_date.canonical_to_date(p_date_from))
377: then
378: hr_utility.set_message(8301, 'GHR_DATE_TO_INVALID');
379: hr_utility.raise_error;
380: end if;
381: end if;
382: hr_utility.set_location('Leaving: '|| l_proc, 10);
383: end chk_date_to;

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

378: hr_utility.set_message(8301, 'GHR_DATE_TO_INVALID');
379: hr_utility.raise_error;
380: end if;
381: end if;
382: hr_utility.set_location('Leaving: '|| l_proc, 10);
383: end chk_date_to;
384: --
385:
386: --