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

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

42: --
43: l_proc varchar2(72) := g_package || 'chk_df';
44: --
45: begin
46: hr_utility.set_location('Entering:'||l_proc,10);
47: --
48: if ((p_rec.recruiting_site_id is not null) and (
49: nvl(irc_rse_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 113: hr_utility.set_location('Inside the ff stuff',20);

109: nvl(irc_rse_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
110: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
111: or (p_rec.recruiting_site_id is null) then
112: --
113: hr_utility.set_location('Inside the ff stuff',20);
114: --
115: -- Only execute the validation if absolutely necessary:
116: -- a) During update, the structure column value or any
117: -- of the attribute values have actually changed.

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

183: ,p_attribute30_value => p_rec.attribute30
184: );
185: end if;
186: --
187: hr_utility.set_location(' Leaving:'||l_proc,20);
188: end chk_df;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |-----------------------< chk_non_updateable_args >------------------------|

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

272: l_proc varchar2(72) := g_package || 'chk_internal';
273: l_api_updating boolean;
274: --
275: begin
276: hr_utility.set_location('Entering:'||l_proc,10);
277: l_api_updating := irc_rse_shd.api_updating
278: (p_recruiting_site_id => p_recruiting_site_id
279: ,p_object_version_number => p_object_version_number
280: );

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

278: (p_recruiting_site_id => p_recruiting_site_id
279: ,p_object_version_number => p_object_version_number
280: );
281: --
282: hr_utility.set_location(l_proc,20);
283: if (l_api_updating and
284: p_internal <>
285: NVL(irc_rse_shd.g_old_rec.internal,hr_api.g_varchar2)
286: ) or (NOT l_api_updating) then

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

284: p_internal <>
285: NVL(irc_rse_shd.g_old_rec.internal,hr_api.g_varchar2)
286: ) or (NOT l_api_updating) then
287: -- Check that internal has a valid value of either 'Y' or 'N'
288: hr_utility.set_location(l_proc,30);
289: if not p_internal in ('Y','N') then
290: hr_utility.set_location(l_proc,40);
291: fnd_message.set_name('PER','IRC_412093_BAD_INTERNAL');
292: fnd_message.raise_error;

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

286: ) or (NOT l_api_updating) then
287: -- Check that internal has a valid value of either 'Y' or 'N'
288: hr_utility.set_location(l_proc,30);
289: if not p_internal in ('Y','N') then
290: hr_utility.set_location(l_proc,40);
291: fnd_message.set_name('PER','IRC_412093_BAD_INTERNAL');
292: fnd_message.raise_error;
293: end if;
294: end if;

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

291: fnd_message.set_name('PER','IRC_412093_BAD_INTERNAL');
292: fnd_message.raise_error;
293: end if;
294: end if;
295: hr_utility.set_location(' Leaving:'||l_proc,50);
296: exception
297: when app_exception.application_exception then
298: if hr_multi_message.exception_add
299: (p_associated_column1 =>

Line 302: hr_utility.set_location(' Leaving:'||l_proc,60);

298: if hr_multi_message.exception_add
299: (p_associated_column1 =>
300: 'IRC_ALL_RECRUITING_SITES.INTERNAL'
301: ) then
302: hr_utility.set_location(' Leaving:'||l_proc,60);
303: raise;
304: end if;
305: hr_utility.set_location(' Leaving:'||l_proc,70);
306: end chk_internal;

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

301: ) then
302: hr_utility.set_location(' Leaving:'||l_proc,60);
303: raise;
304: end if;
305: hr_utility.set_location(' Leaving:'||l_proc,70);
306: end chk_internal;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |--------------------------------< chk_external >--------------------------|

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

339: l_proc varchar2(72) := g_package || 'chk_external';
340: l_api_updating boolean;
341: --
342: begin
343: hr_utility.set_location('Entering:'||l_proc,10);
344: l_api_updating := irc_rse_shd.api_updating
345: (p_recruiting_site_id => p_recruiting_site_id
346: ,p_object_version_number => p_object_version_number
347: );

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

345: (p_recruiting_site_id => p_recruiting_site_id
346: ,p_object_version_number => p_object_version_number
347: );
348: --
349: hr_utility.set_location(l_proc,20);
350: if (l_api_updating and
351: p_external <>
352: NVL(irc_rse_shd.g_old_rec.external,hr_api.g_varchar2)
353: ) or (NOT l_api_updating) then

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

351: p_external <>
352: NVL(irc_rse_shd.g_old_rec.external,hr_api.g_varchar2)
353: ) or (NOT l_api_updating) then
354: -- Check that external has a valid value of either 'Y' or 'N'
355: hr_utility.set_location(l_proc,30);
356: if not p_external in ('Y','N') then
357: hr_utility.set_location(l_proc,40);
358: fnd_message.set_name('PER','IRC_412094_BAD_EXTERNAL');
359: fnd_message.raise_error;

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

353: ) or (NOT l_api_updating) then
354: -- Check that external has a valid value of either 'Y' or 'N'
355: hr_utility.set_location(l_proc,30);
356: if not p_external in ('Y','N') then
357: hr_utility.set_location(l_proc,40);
358: fnd_message.set_name('PER','IRC_412094_BAD_EXTERNAL');
359: fnd_message.raise_error;
360: end if;
361: end if;

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

358: fnd_message.set_name('PER','IRC_412094_BAD_EXTERNAL');
359: fnd_message.raise_error;
360: end if;
361: end if;
362: hr_utility.set_location(' Leaving:'||l_proc,50);
363: exception
364: when app_exception.application_exception then
365: if hr_multi_message.exception_add
366: (p_associated_column1 =>

Line 369: hr_utility.set_location(' Leaving:'||l_proc,60);

365: if hr_multi_message.exception_add
366: (p_associated_column1 =>
367: 'IRC_ALL_RECRUITING_SITES.EXTERNAL'
368: ) then
369: hr_utility.set_location(' Leaving:'||l_proc,60);
370: raise;
371: end if;
372: hr_utility.set_location(' Leaving:'||l_proc,70);
373: end chk_external;

Line 372: hr_utility.set_location(' Leaving:'||l_proc,70);

368: ) then
369: hr_utility.set_location(' Leaving:'||l_proc,60);
370: raise;
371: end if;
372: hr_utility.set_location(' Leaving:'||l_proc,70);
373: end chk_external;
374: --
375: -- ----------------------------------------------------------------------------
376: -- |-----------------------------< chk_third_party >--------------------------|

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

408: l_proc varchar2(72) := g_package || 'chk_third_party';
409: l_api_updating boolean;
410: --
411: begin
412: hr_utility.set_location('Entering:'||l_proc,10);
413: l_api_updating := irc_rse_shd.api_updating
414: (p_recruiting_site_id => p_recruiting_site_id
415: ,p_object_version_number => p_object_version_number
416: );

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

414: (p_recruiting_site_id => p_recruiting_site_id
415: ,p_object_version_number => p_object_version_number
416: );
417: --
418: hr_utility.set_location(l_proc,20);
419: if (l_api_updating and
420: p_third_party <>
421: NVL(irc_rse_shd.g_old_rec.third_party,hr_api.g_varchar2)
422: ) or (NOT l_api_updating) then

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

420: p_third_party <>
421: NVL(irc_rse_shd.g_old_rec.third_party,hr_api.g_varchar2)
422: ) or (NOT l_api_updating) then
423: -- Check that third_party has a valid value of either 'Y' or 'N'
424: hr_utility.set_location(l_proc,30);
425: if not p_third_party in ('Y','N') then
426: hr_utility.set_location(l_proc,40);
427: fnd_message.set_name('PER','IRC_412095_BAD_THIRD_PARTY');
428: fnd_message.raise_error;

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

422: ) or (NOT l_api_updating) then
423: -- Check that third_party has a valid value of either 'Y' or 'N'
424: hr_utility.set_location(l_proc,30);
425: if not p_third_party in ('Y','N') then
426: hr_utility.set_location(l_proc,40);
427: fnd_message.set_name('PER','IRC_412095_BAD_THIRD_PARTY');
428: fnd_message.raise_error;
429: end if;
430: if((p_internal = 'Y' or p_external = 'Y')

Line 434: hr_utility.set_location(l_proc,45);

430: if((p_internal = 'Y' or p_external = 'Y')
431: AND
432: (p_third_party = 'Y')
433: ) then
434: hr_utility.set_location(l_proc,45);
435: fnd_message.set_name('PER','IRC_412095_BAD_THIRD_PARTY');
436: fnd_message.raise_error;
437: end if;
438: end if;

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

435: fnd_message.set_name('PER','IRC_412095_BAD_THIRD_PARTY');
436: fnd_message.raise_error;
437: end if;
438: end if;
439: hr_utility.set_location(' Leaving:'||l_proc,50);
440: exception
441: when app_exception.application_exception then
442: if hr_multi_message.exception_add
443: (p_associated_column1 =>

Line 446: hr_utility.set_location(' Leaving:'||l_proc,60);

442: if hr_multi_message.exception_add
443: (p_associated_column1 =>
444: 'IRC_ALL_RECRUITING_SITES.THIRD_PARTY'
445: ) then
446: hr_utility.set_location(' Leaving:'||l_proc,60);
447: raise;
448: end if;
449: hr_utility.set_location(' Leaving:'||l_proc,70);
450: end chk_third_party;

Line 449: hr_utility.set_location(' Leaving:'||l_proc,70);

445: ) then
446: hr_utility.set_location(' Leaving:'||l_proc,60);
447: raise;
448: end if;
449: hr_utility.set_location(' Leaving:'||l_proc,70);
450: end chk_third_party;
451: --
452: -- ----------------------------------------------------------------------------
453: -- |------------------< chk_posting_cost_period >----------------------------|

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

487: l_proc varchar2(72):=g_package||'chk_posting_cost_period';
488: l_api_updating boolean;
489: --
490: begin
491: hr_utility.set_location('Entering:'|| l_proc, 1);
492: --
493: -- Check mandatory parameters have been set
494: --
495: hr_api.mandatory_arg_error

Line 519: hr_utility.set_location(l_proc, 2);

515: or
516: (NOT l_api_updating and
517: p_posting_cost_period is not null)) then
518: --
519: hr_utility.set_location(l_proc, 2);
520: --
521: -- Check the value in p_posting_cost_period exists in hr_lookups
522: --
523: if hr_api.not_exists_in_hr_lookups

Line 528: hr_utility.set_location(l_proc, 10);

524: (p_effective_date => p_effective_date
525: ,p_lookup_type => 'IRC_POSTING_COST_FREQ'
526: ,p_lookup_code => p_posting_cost_period
527: ) then
528: hr_utility.set_location(l_proc, 10);
529: hr_utility.set_location(p_posting_cost_period, 10);
530: hr_utility.set_location(to_char(p_effective_date,'DD/MM/YYYY'), 10);
531: hr_utility.set_message(800,'IRC_412103_BAD_LOOKUP_PERIOD');
532: hr_utility.raise_error;

Line 529: hr_utility.set_location(p_posting_cost_period, 10);

525: ,p_lookup_type => 'IRC_POSTING_COST_FREQ'
526: ,p_lookup_code => p_posting_cost_period
527: ) then
528: hr_utility.set_location(l_proc, 10);
529: hr_utility.set_location(p_posting_cost_period, 10);
530: hr_utility.set_location(to_char(p_effective_date,'DD/MM/YYYY'), 10);
531: hr_utility.set_message(800,'IRC_412103_BAD_LOOKUP_PERIOD');
532: hr_utility.raise_error;
533: end if;

Line 530: hr_utility.set_location(to_char(p_effective_date,'DD/MM/YYYY'), 10);

526: ,p_lookup_code => p_posting_cost_period
527: ) then
528: hr_utility.set_location(l_proc, 10);
529: hr_utility.set_location(p_posting_cost_period, 10);
530: hr_utility.set_location(to_char(p_effective_date,'DD/MM/YYYY'), 10);
531: hr_utility.set_message(800,'IRC_412103_BAD_LOOKUP_PERIOD');
532: hr_utility.raise_error;
533: end if;
534: --

Line 531: hr_utility.set_message(800,'IRC_412103_BAD_LOOKUP_PERIOD');

527: ) then
528: hr_utility.set_location(l_proc, 10);
529: hr_utility.set_location(p_posting_cost_period, 10);
530: hr_utility.set_location(to_char(p_effective_date,'DD/MM/YYYY'), 10);
531: hr_utility.set_message(800,'IRC_412103_BAD_LOOKUP_PERIOD');
532: hr_utility.raise_error;
533: end if;
534: --
535: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 532: hr_utility.raise_error;

528: hr_utility.set_location(l_proc, 10);
529: hr_utility.set_location(p_posting_cost_period, 10);
530: hr_utility.set_location(to_char(p_effective_date,'DD/MM/YYYY'), 10);
531: hr_utility.set_message(800,'IRC_412103_BAD_LOOKUP_PERIOD');
532: hr_utility.raise_error;
533: end if;
534: --
535: hr_utility.set_location(' Leaving:'|| l_proc, 15);
536: end if;

Line 535: hr_utility.set_location(' Leaving:'|| l_proc, 15);

531: hr_utility.set_message(800,'IRC_412103_BAD_LOOKUP_PERIOD');
532: hr_utility.raise_error;
533: end if;
534: --
535: hr_utility.set_location(' Leaving:'|| l_proc, 15);
536: end if;
537: exception
538: when app_exception.application_exception then
539: if hr_multi_message.exception_add

Line 543: hr_utility.set_location(' Leaving:'||l_proc,80);

539: if hr_multi_message.exception_add
540: (p_associated_column1 =>
541: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'
542: ) then
543: hr_utility.set_location(' Leaving:'||l_proc,80);
544: raise;
545: end if;
546: hr_utility.set_location(' Leaving exception handler:'||l_proc,90);
547: end chk_posting_cost_period;

Line 546: hr_utility.set_location(' Leaving exception handler:'||l_proc,90);

542: ) then
543: hr_utility.set_location(' Leaving:'||l_proc,80);
544: raise;
545: end if;
546: hr_utility.set_location(' Leaving exception handler:'||l_proc,90);
547: end chk_posting_cost_period;
548: --
549: -- ----------------------------------------------------------------------------
550: -- |-------------------------< chk_posting_cost >----------------------------|

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

592: l_posting_cost irc_all_recruiting_sites.posting_cost%TYPE;
593: l_posting_cost_period irc_all_recruiting_sites.posting_cost_period%TYPE;
594: l_posting_cost_currency irc_all_recruiting_sites.posting_cost_currency%TYPE;
595: begin
596: hr_utility.set_location('Entering:'|| l_proc, 1);
597: --
598: -- Check mandatory parameters have been set
599: --
600: hr_api.mandatory_arg_error

Line 606: hr_utility.set_location(l_proc, 2);

602: ,p_argument => 'effective_date'
603: ,p_argument_value => p_effective_date
604: );
605: --
606: hr_utility.set_location(l_proc, 2);
607: -- Only proceed with the validation if :
608: -- a) The current g_old_rec is current
609: -- b) The value has changed.
610: -- c) A record is being inserted

Line 617: hr_utility.set_location(l_proc, 3);

613: (p_recruiting_site_id => p_recruiting_site_id
614: ,p_object_version_number => p_object_version_number
615: );
616: --
617: hr_utility.set_location(l_proc, 3);
618: if ((l_api_updating and (nvl(irc_rse_shd.g_old_rec.posting_cost,
619: hr_api.g_number)
620: <> nvl(p_posting_cost , hr_api.g_number)
621: or nvl(irc_rse_shd.g_old_rec.posting_cost_period,

Line 631: hr_utility.set_location(l_proc, 4);

627: )
628: )
629: or
630: (NOT l_api_updating)) then
631: hr_utility.set_location(l_proc, 4);
632: --
633: -- Now, we know we're either inserting or updating one of the three
634: -- values has changed.
635: --

Line 639: hr_utility.set_location(l_proc, 10);

635: --
636: if ((l_api_updating and p_posting_cost <> hr_api.g_number)
637: or p_posting_cost is null
638: or not l_api_updating) then
639: hr_utility.set_location(l_proc, 10);
640: l_posting_cost := p_posting_cost;
641: else
642: hr_utility.set_location(l_proc, 20);
643: l_posting_cost := irc_rse_shd.g_old_rec.posting_cost;

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

638: or not l_api_updating) then
639: hr_utility.set_location(l_proc, 10);
640: l_posting_cost := p_posting_cost;
641: else
642: hr_utility.set_location(l_proc, 20);
643: l_posting_cost := irc_rse_shd.g_old_rec.posting_cost;
644: end if;
645: --
646: if ((l_api_updating and p_posting_cost_period <> hr_api.g_varchar2)

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

645: --
646: if ((l_api_updating and p_posting_cost_period <> hr_api.g_varchar2)
647: or p_posting_cost_period is null
648: or not l_api_updating) then
649: hr_utility.set_location(l_proc, 30);
650: l_posting_cost_period := p_posting_cost_period;
651: else
652: hr_utility.set_location(l_proc, 40);
653: l_posting_cost_period := irc_rse_shd.g_old_rec.posting_cost_period;

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

648: or not l_api_updating) then
649: hr_utility.set_location(l_proc, 30);
650: l_posting_cost_period := p_posting_cost_period;
651: else
652: hr_utility.set_location(l_proc, 40);
653: l_posting_cost_period := irc_rse_shd.g_old_rec.posting_cost_period;
654: end if;
655: --
656: hr_utility.set_location('posting_cost_currency:'||p_posting_cost_currency, 10);

Line 656: hr_utility.set_location('posting_cost_currency:'||p_posting_cost_currency, 10);

652: hr_utility.set_location(l_proc, 40);
653: l_posting_cost_period := irc_rse_shd.g_old_rec.posting_cost_period;
654: end if;
655: --
656: hr_utility.set_location('posting_cost_currency:'||p_posting_cost_currency, 10);
657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);
658: if ((l_api_updating and p_posting_cost_currency <> hr_api.g_varchar2)
659: or p_posting_cost_currency is null
660: or not l_api_updating) then

Line 657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);

653: l_posting_cost_period := irc_rse_shd.g_old_rec.posting_cost_period;
654: end if;
655: --
656: hr_utility.set_location('posting_cost_currency:'||p_posting_cost_currency, 10);
657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);
658: if ((l_api_updating and p_posting_cost_currency <> hr_api.g_varchar2)
659: or p_posting_cost_currency is null
660: or not l_api_updating) then
661: hr_utility.set_location(l_proc, 50);

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

657: hr_utility.set_location('hr_api.g_varchar2:'||hr_api.g_varchar2, 10);
658: if ((l_api_updating and p_posting_cost_currency <> hr_api.g_varchar2)
659: or p_posting_cost_currency is null
660: or not l_api_updating) then
661: hr_utility.set_location(l_proc, 50);
662: l_posting_cost_currency := p_posting_cost_currency;
663: else
664: hr_utility.set_location(l_proc, 60);
665: l_posting_cost_currency := irc_rse_shd.g_old_rec.posting_cost_currency;

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

660: or not l_api_updating) then
661: hr_utility.set_location(l_proc, 50);
662: l_posting_cost_currency := p_posting_cost_currency;
663: else
664: hr_utility.set_location(l_proc, 60);
665: l_posting_cost_currency := irc_rse_shd.g_old_rec.posting_cost_currency;
666: end if;
667: --
668: if ( l_posting_cost_currency

Line 676: hr_utility.set_location(l_proc,70);

672: or l_posting_cost is null
673: or l_posting_cost_period is null)
674: ) then
675: --
676: hr_utility.set_location(l_proc,70);
677: fnd_message.set_name('PER','IRC_412104_BAD_CURRENCY_COMBO');
678: fnd_message.raise_error;
679: end if;
680: --

Line 682: hr_utility.set_location(' Leaving:'|| l_proc, 80);

678: fnd_message.raise_error;
679: end if;
680: --
681: end if;
682: hr_utility.set_location(' Leaving:'|| l_proc, 80);
683: exception
684: when app_exception.application_exception then
685: hr_utility.set_location('exception handler'||l_proc, 90);
686: if hr_multi_message.exception_add

Line 685: hr_utility.set_location('exception handler'||l_proc, 90);

681: end if;
682: hr_utility.set_location(' Leaving:'|| l_proc, 80);
683: exception
684: when app_exception.application_exception then
685: hr_utility.set_location('exception handler'||l_proc, 90);
686: if hr_multi_message.exception_add
687: (p_associated_column1 =>
688: 'IRC_ALL_RECRUITING_SITES.POSTING_COST'
689: ,p_associated_column2 =>

Line 694: hr_utility.set_location(' Leaving:'||l_proc,90);

690: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'
691: ,p_associated_column3 =>
692: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_CURRENCY'
693: ) then
694: hr_utility.set_location(' Leaving:'||l_proc,90);
695: raise;
696: end if;
697: hr_utility.set_location(' Leaving exception handler:'||l_proc,100);
698: end chk_posting_cost;

Line 697: hr_utility.set_location(' Leaving exception handler:'||l_proc,100);

693: ) then
694: hr_utility.set_location(' Leaving:'||l_proc,90);
695: raise;
696: end if;
697: hr_utility.set_location(' Leaving exception handler:'||l_proc,100);
698: end chk_posting_cost;
699: --
700: -- ----------------------------------------------------------------------------
701: -- |-----------------------------< chk_date_from_to>-------------------------|

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

733: l_proc varchar2(72):=g_package||'chk_date_from_to';
734: l_api_updating boolean;
735: --
736: begin
737: hr_utility.set_location('Entering:'|| l_proc, 1);
738: --
739: --
740: -- Only proceed with the validation if :
741: -- a) The current g_old_rec is current.

Line 767: hr_utility.set_message(800,'IRC_412107_RSE_DATE_FR_DATE_T0');

763: --
764: if ((p_date_from is not null) and (p_date_to is not null)
765: and (p_date_from > p_date_to)) then
766: --
767: hr_utility.set_message(800,'IRC_412107_RSE_DATE_FR_DATE_T0');
768: hr_utility.raise_error;
769: --
770: end if;
771: --

Line 768: hr_utility.raise_error;

764: if ((p_date_from is not null) and (p_date_to is not null)
765: and (p_date_from > p_date_to)) then
766: --
767: hr_utility.set_message(800,'IRC_412107_RSE_DATE_FR_DATE_T0');
768: hr_utility.raise_error;
769: --
770: end if;
771: --
772: end if;

Line 774: hr_utility.set_location(' Leaving:'|| l_proc, 15);

770: end if;
771: --
772: end if;
773: --
774: hr_utility.set_location(' Leaving:'|| l_proc, 15);
775: --
776: exception
777: when app_exception.application_exception then
778: if hr_multi_message.exception_add

Line 784: hr_utility.set_location(' Leaving:'||l_proc,80);

780: 'IRC_ALL_RECRUITING_SITES.DATE_FROM'
781: ,p_associated_column2 =>
782: 'IRC_ALL_RECRUITING_SITES.DATE_TO'
783: ) then
784: hr_utility.set_location(' Leaving:'||l_proc,80);
785: raise;
786: end if;
787: hr_utility.set_location(' Leaving exception handler:'||l_proc,90);
788: end chk_date_from_to;

Line 787: hr_utility.set_location(' Leaving exception handler:'||l_proc,90);

783: ) then
784: hr_utility.set_location(' Leaving:'||l_proc,80);
785: raise;
786: end if;
787: hr_utility.set_location(' Leaving exception handler:'||l_proc,90);
788: end chk_date_from_to;
789: --
790: --
791: -- ----------------------------------------------------------------------------

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

798: --
799: l_proc varchar2(72) := g_package||'insert_validate';
800: --
801: Begin
802: hr_utility.set_location('Entering:'||l_proc, 5);
803: --
804: -- Call all supporting business operations
805: --
806: --

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

851: );
852: --
853: irc_rse_bus.chk_df(p_rec);
854: --
855: hr_utility.set_location(' Leaving:'||l_proc, 10);
856: End insert_validate;
857: --
858: -- ----------------------------------------------------------------------------
859: -- |---------------------------< update_validate >----------------------------|

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

865: --
866: l_proc varchar2(72) := g_package||'update_validate';
867: --
868: Begin
869: hr_utility.set_location('Entering:'||l_proc, 5);
870: --
871: -- Call all supporting business operations
872: --
873: --

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

923: );
924: --
925: irc_rse_bus.chk_df(p_rec);
926: --
927: hr_utility.set_location(' Leaving:'||l_proc, 10);
928: End update_validate;
929: --
930: -- ----------------------------------------------------------------------------
931: -- |---------------------------< delete_validate >----------------------------|

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

936: --
937: l_proc varchar2(72) := g_package||'delete_validate';
938: --
939: Begin
940: hr_utility.set_location('Entering:'||l_proc, 5);
941: --
942: -- Call all supporting business operations
943: --
944: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

940: hr_utility.set_location('Entering:'||l_proc, 5);
941: --
942: -- Call all supporting business operations
943: --
944: hr_utility.set_location(' Leaving:'||l_proc, 10);
945: End delete_validate;
946: --
947: end irc_rse_bus;