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

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

38: l_proc varchar2(72) := g_package||'return_legislation_code';
39: --
40: Begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error

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

56: -- call to this function. Just return the value in the global
57: -- variable.
58: --
59: l_legislation_code := irc_ios_bus.g_legislation_code;
60: hr_utility.set_location(l_proc, 20);
61: else
62: --
63: -- The ID is different to the last call to this function
64: -- or this is the first call to this function.

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

73: close csr_leg_code;
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: fnd_message.raise_error;
76: end if;
77: hr_utility.set_location(l_proc,30);
78: --
79: -- Set the global variables so the values are
80: -- available for the next call to this function.
81: --

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

82: close csr_leg_code;
83: irc_ios_bus.g_offer_status_history_id := p_offer_status_history_id;
84: irc_ios_bus.g_legislation_code := l_legislation_code;
85: end if;
86: hr_utility.set_location(' Leaving:'|| l_proc, 40);
87: return l_legislation_code;
88: end return_legislation_code;
89: --
90: -- ----------------------------------------------------------------------------

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

221: where offer_id = p_offer_id;
222: --
223: begin
224: --
225: hr_utility.set_location('Entering:'|| l_proc, 10);
226: hr_api.mandatory_arg_error
227: (p_api_name => l_proc
228: ,p_argument => 'OFFER_ID'
229: ,p_argument_value => p_offer_id

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

230: );
231: --
232: open csr_offer;
233: fetch csr_offer into l_offer_id;
234: hr_utility.set_location(l_proc,20);
235: if csr_offer%NOTFOUND then
236: close csr_offer;
237: fnd_message.set_name ('PER','IRC_412322_INVALID_OFFER_ID');
238: fnd_message.raise_error;

Line 242: hr_utility.set_location(' Leaving:'|| l_proc, 30);

238: fnd_message.raise_error;
239: end if;
240: close csr_offer;
241: --
242: hr_utility.set_location(' Leaving:'|| l_proc, 30);
243: --
244: exception
245: when app_exception.application_exception then
246: if hr_multi_message.exception_add

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

246: if hr_multi_message.exception_add
247: (p_associated_column1=>
248: 'IRC_OFFER_STATUS_HISTORY.OFFER_ID'
249: ) then
250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
251: raise;
252: end if;
253: hr_utility.set_location(' Leaving:'|| l_proc, 50);
254: end chk_offer_id;

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

249: ) then
250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
251: raise;
252: end if;
253: hr_utility.set_location(' Leaving:'|| l_proc, 50);
254: end chk_offer_id;
255: --
256: -- ----------------------------------------------------------------------------
257: -- |---------------------------< chk_offer_status >---------------------------|

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

289:
290: --
291: begin
292: --
293: hr_utility.set_location('Entering:'|| l_proc, 10);
294: --
295: -- Check mandatory parameters have been set
296: --
297: hr_api.mandatory_arg_error

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

306: );
307: --
308:
309: --
310: hr_utility.set_location(l_proc,20);
311: if hr_api.not_exists_in_hr_lookups
312: (p_effective_date => p_effective_date,
313: p_lookup_type => 'IRC_OFFER_STATUSES',
314: p_lookup_code => p_offer_status

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

313: p_lookup_type => 'IRC_OFFER_STATUSES',
314: p_lookup_code => p_offer_status
315: ) then
316:
317: hr_utility.set_message(800, 'IRC_412323_INV_OFFER_STATUS');
318: hr_utility.raise_error;
319: end if;
320: --
321: hr_utility.set_location(' Leaving:' || l_proc, 30);

Line 318: hr_utility.raise_error;

314: p_lookup_code => p_offer_status
315: ) then
316:
317: hr_utility.set_message(800, 'IRC_412323_INV_OFFER_STATUS');
318: hr_utility.raise_error;
319: end if;
320: --
321: hr_utility.set_location(' Leaving:' || l_proc, 30);
322:

Line 321: hr_utility.set_location(' Leaving:' || l_proc, 30);

317: hr_utility.set_message(800, 'IRC_412323_INV_OFFER_STATUS');
318: hr_utility.raise_error;
319: end if;
320: --
321: hr_utility.set_location(' Leaving:' || l_proc, 30);
322:
323: --
324: exception
325: when app_exception.application_exception then

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

326: if hr_multi_message.exception_add
327: (p_associated_column1=>
328: 'IRC_OFFER_STATUS_HISTORY.OFFER_STATUS'
329: ) then
330: hr_utility.set_location(' Leaving:'|| l_proc, 40);
331: raise;
332: end if;
333: hr_utility.set_location(' Leaving:'|| l_proc, 50);
334: end chk_offer_status;

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

329: ) then
330: hr_utility.set_location(' Leaving:'|| l_proc, 40);
331: raise;
332: end if;
333: hr_utility.set_location(' Leaving:'|| l_proc, 50);
334: end chk_offer_status;
335: --
336: -- ----------------------------------------------------------------------------
337: -- |--------------------------< chk_change_reason >---------------------------|

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

370:
371: --
372: begin
373: --
374: hr_utility.set_location('Entering:'|| l_proc, 10);
375: --
376: if (p_change_reason is not null)
377: then
378: hr_utility.set_location(l_proc,20);

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

374: hr_utility.set_location('Entering:'|| l_proc, 10);
375: --
376: if (p_change_reason is not null)
377: then
378: hr_utility.set_location(l_proc,20);
379: if hr_api.not_exists_in_hr_lookups
380: (p_effective_date => p_effective_date,
381: p_lookup_type => 'IRC_OFFER_STATUS_CHANGE_REASON',
382: p_lookup_code => p_change_reason

Line 385: hr_utility.set_message(800, 'IRC_412347_INV_CHANGE_REASON');

381: p_lookup_type => 'IRC_OFFER_STATUS_CHANGE_REASON',
382: p_lookup_code => p_change_reason
383: ) then
384:
385: hr_utility.set_message(800, 'IRC_412347_INV_CHANGE_REASON');
386: hr_utility.raise_error;
387: end if;
388: end if;
389: --

Line 386: hr_utility.raise_error;

382: p_lookup_code => p_change_reason
383: ) then
384:
385: hr_utility.set_message(800, 'IRC_412347_INV_CHANGE_REASON');
386: hr_utility.raise_error;
387: end if;
388: end if;
389: --
390: hr_utility.set_location(' Leaving:' || l_proc, 30);

Line 390: hr_utility.set_location(' Leaving:' || l_proc, 30);

386: hr_utility.raise_error;
387: end if;
388: end if;
389: --
390: hr_utility.set_location(' Leaving:' || l_proc, 30);
391:
392: --
393: exception
394: when app_exception.application_exception then

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

395: if hr_multi_message.exception_add
396: (p_associated_column1=>
397: 'IRC_OFFER_STATUS_HISTORY.CHANGE_REASON'
398: ) then
399: hr_utility.set_location(' Leaving:'|| l_proc, 40);
400: raise;
401: end if;
402: hr_utility.set_location(' Leaving:'|| l_proc, 50);
403: end chk_change_reason;

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

398: ) then
399: hr_utility.set_location(' Leaving:'|| l_proc, 40);
400: raise;
401: end if;
402: hr_utility.set_location(' Leaving:'|| l_proc, 50);
403: end chk_change_reason;
404: --
405: -- ----------------------------------------------------------------------------
406: -- |--------------------------< chk_decline_reason >--------------------------|

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

439:
440: --
441: begin
442: --
443: hr_utility.set_location('Entering:'|| l_proc, 10);
444: --
445: -- Check mandatory parameters have been set
446: --
447: hr_api.mandatory_arg_error

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

458:
459: --
460: if (p_decline_reason is not null)
461: then
462: hr_utility.set_location(l_proc,20);
463: if hr_api.not_exists_in_hr_lookups
464: (p_effective_date => p_effective_date,
465: p_lookup_type => 'IRC_OFFER_DECLINE_REASON',
466: p_lookup_code => p_decline_reason

Line 469: hr_utility.set_message(800, 'IRC_412324_INV_DECLINE_REASON');

465: p_lookup_type => 'IRC_OFFER_DECLINE_REASON',
466: p_lookup_code => p_decline_reason
467: ) then
468:
469: hr_utility.set_message(800, 'IRC_412324_INV_DECLINE_REASON');
470: hr_utility.raise_error;
471: end if;
472: end if;
473: --

Line 470: hr_utility.raise_error;

466: p_lookup_code => p_decline_reason
467: ) then
468:
469: hr_utility.set_message(800, 'IRC_412324_INV_DECLINE_REASON');
470: hr_utility.raise_error;
471: end if;
472: end if;
473: --
474: hr_utility.set_location(' Leaving:' || l_proc, 30);

Line 474: hr_utility.set_location(' Leaving:' || l_proc, 30);

470: hr_utility.raise_error;
471: end if;
472: end if;
473: --
474: hr_utility.set_location(' Leaving:' || l_proc, 30);
475:
476: --
477: exception
478: when app_exception.application_exception then

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

479: if hr_multi_message.exception_add
480: (p_associated_column1=>
481: 'IRC_OFFER_STATUS_HISTORY.DECLINE_REASON'
482: ) then
483: hr_utility.set_location(' Leaving:'|| l_proc, 40);
484: raise;
485: end if;
486: hr_utility.set_location(' Leaving:'|| l_proc, 50);
487: end chk_decline_reason;

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

482: ) then
483: hr_utility.set_location(' Leaving:'|| l_proc, 40);
484: raise;
485: end if;
486: hr_utility.set_location(' Leaving:'|| l_proc, 50);
487: end chk_decline_reason;
488: --
489: -- ----------------------------------------------------------------------------
490: -- |--------------------------< chk_withdraw_reason >--------------------------|

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

523:
524: --
525: begin
526: --
527: hr_utility.set_location('Entering:'|| l_proc, 10);
528: --
529: -- Check mandatory parameters have been set
530: --
531: hr_api.mandatory_arg_error

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

542:
543: --
544: if (p_withdraw_reason is not null)
545: then
546: hr_utility.set_location(l_proc,20);
547: if hr_api.not_exists_in_hr_lookups
548: (p_effective_date => p_effective_date,
549: p_lookup_type => 'IRC_OFFER_WITHDRAWAL_REASON',
550: p_lookup_code => p_withdraw_reason

Line 553: hr_utility.set_message(800, 'IRC_412551_INV_WITHDRAW_REASON');

549: p_lookup_type => 'IRC_OFFER_WITHDRAWAL_REASON',
550: p_lookup_code => p_withdraw_reason
551: ) then
552:
553: hr_utility.set_message(800, 'IRC_412551_INV_WITHDRAW_REASON');
554: hr_utility.raise_error;
555: end if;
556: end if;
557: --

Line 554: hr_utility.raise_error;

550: p_lookup_code => p_withdraw_reason
551: ) then
552:
553: hr_utility.set_message(800, 'IRC_412551_INV_WITHDRAW_REASON');
554: hr_utility.raise_error;
555: end if;
556: end if;
557: --
558: hr_utility.set_location(' Leaving:' || l_proc, 30);

Line 558: hr_utility.set_location(' Leaving:' || l_proc, 30);

554: hr_utility.raise_error;
555: end if;
556: end if;
557: --
558: hr_utility.set_location(' Leaving:' || l_proc, 30);
559:
560: --
561: exception
562: when app_exception.application_exception then

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

563: if hr_multi_message.exception_add
564: (p_associated_column1=>
565: 'IRC_OFFER_STATUS_HISTORY.DECLINE_REASON'
566: ) then
567: hr_utility.set_location(' Leaving:'|| l_proc, 40);
568: raise;
569: end if;
570: hr_utility.set_location(' Leaving:'|| l_proc, 50);
571: end chk_withdraw_reason;

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

566: ) then
567: hr_utility.set_location(' Leaving:'|| l_proc, 40);
568: raise;
569: end if;
570: hr_utility.set_location(' Leaving:'|| l_proc, 50);
571: end chk_withdraw_reason;
572: --
573: -- ----------------------------------------------------------------------------
574: -- |---------------------------< insert_validate >----------------------------|

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

580: --
581: l_proc varchar2(72) := g_package||'insert_validate';
582: --
583: Begin
584: hr_utility.set_location(' Leaving:'||l_proc, 10);
585: --
586: -- Call all supporting business operations
587: --
588:

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

586: -- Call all supporting business operations
587: --
588:
589: --
590: hr_utility.set_location(l_proc, 20);
591: --
592: chk_offer_id
593: (p_offer_id => p_rec.offer_id
594: );

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

592: chk_offer_id
593: (p_offer_id => p_rec.offer_id
594: );
595: --
596: hr_utility.set_location(l_proc, 30);
597: --
598: chk_offer_status
599: (p_offer_status => p_rec.offer_status,
600: p_effective_date => p_effective_date

Line 603: hr_utility.set_location(l_proc, 40);

599: (p_offer_status => p_rec.offer_status,
600: p_effective_date => p_effective_date
601: );
602: --
603: hr_utility.set_location(l_proc, 40);
604: --
605: if (p_rec.change_reason is not null) then
606: chk_change_reason
607: (p_change_reason => p_rec.change_reason,

Line 612: hr_utility.set_location(l_proc, 50);

608: p_effective_date => p_effective_date
609: );
610: end if;
611: --
612: hr_utility.set_location(l_proc, 50);
613: --
614: if (p_rec.decline_reason is not null) then
615: if(p_rec.change_reason='MGR_WITHDRAW') then
616: chk_withdraw_reason

Line 628: hr_utility.set_location(l_proc, 60);

624: );
625: end if;
626: end if;
627: --
628: hr_utility.set_location(l_proc, 60);
629: --
630: End insert_validate;
631: --
632: -- ----------------------------------------------------------------------------

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

639: --
640: l_proc varchar2(72) := g_package||'update_validate';
641: --
642: Begin
643: hr_utility.set_location('Entering:'||l_proc, 10);
644: --
645: -- Call all supporting business operations
646: --
647: chk_non_updateable_args

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

647: chk_non_updateable_args
648: (p_effective_date => p_effective_date
649: ,p_rec => p_rec
650: );
651: hr_utility.set_location(l_proc, 20);
652: --
653: if (p_rec.change_reason is not null) then
654: chk_change_reason
655: (p_change_reason => p_rec.change_reason,

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

656: p_effective_date => p_effective_date
657: );
658: end if;
659: --
660: hr_utility.set_location(l_proc, 30);
661: --
662: if (p_rec.decline_reason is not null) then
663: if(p_rec.change_reason='MGR_WITHDRAW') then
664: chk_withdraw_reason

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

672: );
673: end if;
674: end if;
675: --
676: hr_utility.set_location(' Leaving:'||l_proc, 40);
677: End update_validate;
678: --
679: -- ----------------------------------------------------------------------------
680: -- |---------------------------< delete_validate >----------------------------|

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

685: --
686: l_proc varchar2(72) := g_package||'delete_validate';
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Call all supporting business operations
692: --
693: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Call all supporting business operations
692: --
693: hr_utility.set_location(' Leaving:'||l_proc, 10);
694: End delete_validate;
695: --
696: end irc_ios_bus;