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.PQH_PTE_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_pte_shd.api_updating
47: (p_ptx_extra_info_id => p_ptx_extra_info_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_ptx_extra_info_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.position_transaction_id = p_position_transaction_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_pte_shd.api_updating
119: (p_ptx_extra_info_id => p_ptx_extra_info_id,
120: p_object_version_number => p_object_version_number);

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

143: close c1;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: End chk_position_transaction_id;
150: --
151: -- ----------------------------------------------------------------------------

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

187: where a.information_type = p_information_type;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := pqh_pte_shd.api_updating
194: (p_ptx_extra_info_id => p_ptx_extra_info_id,
195: p_object_version_number => p_object_version_number);

Line 214: hr_utility.set_message(800, 'PQH_INVALID_POS_INFO_TYPE');

210: --
211: -- raise error as FK does not relate to PK in pqh_ptx_info_types
212: -- table.
213: --
214: hr_utility.set_message(800, 'PQH_INVALID_POS_INFO_TYPE');
215: hr_utility.set_message_token('POS_INFO_TYPE',p_information_type );
216: hr_utility.raise_error;
217: -- pqh_pte_shd.constraint_error('PQH_PTX_EXTRA_INFO_FK1');
218: --

Line 215: hr_utility.set_message_token('POS_INFO_TYPE',p_information_type );

211: -- raise error as FK does not relate to PK in pqh_ptx_info_types
212: -- table.
213: --
214: hr_utility.set_message(800, 'PQH_INVALID_POS_INFO_TYPE');
215: hr_utility.set_message_token('POS_INFO_TYPE',p_information_type );
216: hr_utility.raise_error;
217: -- pqh_pte_shd.constraint_error('PQH_PTX_EXTRA_INFO_FK1');
218: --
219: end if;

Line 216: hr_utility.raise_error;

212: -- table.
213: --
214: hr_utility.set_message(800, 'PQH_INVALID_POS_INFO_TYPE');
215: hr_utility.set_message_token('POS_INFO_TYPE',p_information_type );
216: hr_utility.raise_error;
217: -- pqh_pte_shd.constraint_error('PQH_PTX_EXTRA_INFO_FK1');
218: --
219: end if;
220: --

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

221: close c1;
222: --
223: end if;
224: --
225: hr_utility.set_location('Leaving:'||l_proc,10);
226: --
227: End chk_information_type;
228:
229: --

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

240: select *
241: from pqh_position_transactions
242: where position_transaction_id = p_position_transaction_id;
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: open c_ptx(p_rec.position_transaction_id);
247: fetch c_ptx into l_ptx_rec;
248: --

Line 253: hr_utility.set_message(800, 'HR_INV_POSN_TRAN');

249: -- Validate Position Id
250: --
251: if c_ptx%notfound then
252: close c_ptx;
253: hr_utility.set_message(800, 'HR_INV_POSN_TRAN');
254: hr_utility.raise_error;
255: end if;
256: --
257: close c_ptx;

Line 254: hr_utility.raise_error;

250: --
251: if c_ptx%notfound then
252: close c_ptx;
253: hr_utility.set_message(800, 'HR_INV_POSN_TRAN');
254: hr_utility.raise_error;
255: end if;
256: --
257: close c_ptx;
258: --

Line 282: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');

278: --
279: if (p_rec.information_type = 'PER_SEASONAL') then
280: if (nvl(l_ptx_rec.seasonal_flag,'N') = 'N' )then
281: -- Cannot add Seasonal dates to PTX Extra Info if seasonal_flag<>'Y'
282: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');
283: hr_utility.raise_error;
284: end if;
285: if (p_rec.information3 > p_rec.information4) then
286: -- Overlap end date should be later than overlap start date

Line 283: hr_utility.raise_error;

279: if (p_rec.information_type = 'PER_SEASONAL') then
280: if (nvl(l_ptx_rec.seasonal_flag,'N') = 'N' )then
281: -- Cannot add Seasonal dates to PTX Extra Info if seasonal_flag<>'Y'
282: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');
283: hr_utility.raise_error;
284: end if;
285: if (p_rec.information3 > p_rec.information4) then
286: -- Overlap end date should be later than overlap start date
287: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');

Line 287: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');

283: hr_utility.raise_error;
284: end if;
285: if (p_rec.information3 > p_rec.information4) then
286: -- Overlap end date should be later than overlap start date
287: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
288: hr_utility.raise_error;
289: end if;
290: end if;
291: --

Line 288: hr_utility.raise_error;

284: end if;
285: if (p_rec.information3 > p_rec.information4) then
286: -- Overlap end date should be later than overlap start date
287: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
288: hr_utility.raise_error;
289: end if;
290: end if;
291: --
292: -- Validate Overlap Dates for PTX Extra Info

Line 297: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');

293: --
294: if (p_rec.information_type = 'PER_OVERLAP') then
295: if ( l_ptx_rec.overlap_period is null )then
296: -- Cannot add Overlap dates to PTX Extra Info if overlap_period is null
297: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');
298: hr_utility.raise_error;
299: end if;
300: if (p_rec.information3 > p_rec.information4) then
301: -- Overlap end date should be later than overlap start date

Line 298: hr_utility.raise_error;

294: if (p_rec.information_type = 'PER_OVERLAP') then
295: if ( l_ptx_rec.overlap_period is null )then
296: -- Cannot add Overlap dates to PTX Extra Info if overlap_period is null
297: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');
298: hr_utility.raise_error;
299: end if;
300: if (p_rec.information3 > p_rec.information4) then
301: -- Overlap end date should be later than overlap start date
302: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');

Line 302: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');

298: hr_utility.raise_error;
299: end if;
300: if (p_rec.information3 > p_rec.information4) then
301: -- Overlap end date should be later than overlap start date
302: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
303: hr_utility.raise_error;
304: end if;
305: end if;
306: --

Line 303: hr_utility.raise_error;

299: end if;
300: if (p_rec.information3 > p_rec.information4) then
301: -- Overlap end date should be later than overlap start date
302: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
303: hr_utility.raise_error;
304: end if;
305: end if;
306: --
307: -- Validate Reservation Info for PTX Extra Info

Line 312: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');

308: --
309: if (p_rec.information_type = 'PER_RESERVED') then
310: if (p_rec.information3 > p_rec.information4) then
311: -- Reservation end date should be later than reservation start date
312: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
313: hr_utility.raise_error;
314: end if;
315: if (p_rec.information6 <= 0) then
316: -- Reservation end date should be later than reservation start date

Line 313: hr_utility.raise_error;

309: if (p_rec.information_type = 'PER_RESERVED') then
310: if (p_rec.information3 > p_rec.information4) then
311: -- Reservation end date should be later than reservation start date
312: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
313: hr_utility.raise_error;
314: end if;
315: if (p_rec.information6 <= 0) then
316: -- Reservation end date should be later than reservation start date
317: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');

Line 317: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');

313: hr_utility.raise_error;
314: end if;
315: if (p_rec.information6 <= 0) then
316: -- Reservation end date should be later than reservation start date
317: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');
318: hr_utility.raise_error;
319: end if;
320: end if;
321: --

Line 318: hr_utility.raise_error;

314: end if;
315: if (p_rec.information6 <= 0) then
316: -- Reservation end date should be later than reservation start date
317: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');
318: hr_utility.raise_error;
319: end if;
320: end if;
321: --
322: --

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

320: end if;
321: --
322: --
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End insert_validate;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |---------------------------< update_validate >----------------------------|

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

331: --
332: l_proc varchar2(72) := g_package||'update_validate';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- Call all supporting business operations
338: --
339: chk_ptx_extra_info_id

Line 360: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');

356: --
357: if (p_rec.information_type = 'PER_SEASONAL') then
358: if (p_rec.information3 > p_rec.information4) then
359: -- Overlap end date should be later than overlap start date
360: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
361: hr_utility.raise_error;
362: end if;
363: end if;
364: --

Line 361: hr_utility.raise_error;

357: if (p_rec.information_type = 'PER_SEASONAL') then
358: if (p_rec.information3 > p_rec.information4) then
359: -- Overlap end date should be later than overlap start date
360: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
361: hr_utility.raise_error;
362: end if;
363: end if;
364: --
365: -- Validate Overlap Dates for PTX Extra Info

Line 370: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');

366: --
367: if (p_rec.information_type = 'PER_OVERLAP') then
368: if (p_rec.information3 > p_rec.information4) then
369: -- Overlap end date should be later than overlap start date
370: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
371: hr_utility.raise_error;
372: end if;
373: end if;
374: --

Line 371: hr_utility.raise_error;

367: if (p_rec.information_type = 'PER_OVERLAP') then
368: if (p_rec.information3 > p_rec.information4) then
369: -- Overlap end date should be later than overlap start date
370: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
371: hr_utility.raise_error;
372: end if;
373: end if;
374: --
375: -- Validate Reservation Info for PTX Extra Info

Line 380: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');

376: --
377: if (p_rec.information_type = 'PER_RESERVED') then
378: if (p_rec.information3 > p_rec.information4) then
379: -- Reservation end date should be later than reservation start date
380: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
381: hr_utility.raise_error;
382: end if;
383: end if;
384: --

Line 381: hr_utility.raise_error;

377: if (p_rec.information_type = 'PER_RESERVED') then
378: if (p_rec.information3 > p_rec.information4) then
379: -- Reservation end date should be later than reservation start date
380: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
381: hr_utility.raise_error;
382: end if;
383: end if;
384: --
385: --

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

383: end if;
384: --
385: --
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: End update_validate;
389: --
390: -- ----------------------------------------------------------------------------
391: -- |---------------------------< delete_validate >----------------------------|

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

394: --
395: l_proc varchar2(72) := g_package||'delete_validate';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Call all supporting business operations
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Call all supporting business operations
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End delete_validate;
404: --
405: end pqh_pte_bus;