APPS.IRC_IPT_SHD dependencies on HR_UTILITY

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

170: --
171: l_proc varchar2(72) := g_package||'lck';
172: --
173: Begin
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: hr_api.mandatory_arg_error
177: (p_api_name => l_proc
178: ,p_argument => 'POSTING_CONTENT_ID'

Line 181: hr_utility.set_location(l_proc,6);

177: (p_api_name => l_proc
178: ,p_argument => 'POSTING_CONTENT_ID'
179: ,p_argument_value => p_posting_content_id
180: );
181: hr_utility.set_location(l_proc,6);
182: hr_api.mandatory_arg_error
183: (p_api_name => l_proc
184: ,p_argument => 'LANGUAGE'
185: ,p_argument_value => p_language

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

224: g_old_rec.image_url_alt
225: := dbms_lob.substr(g_clob_old_rec.image_url_alt);
226: --
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: --
230: -- We need to trap the ORA LOCK exception
231: --
232: Exception

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

462: --
463: l_api_updating boolean;
464: --
465: Begin
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: open get_rec;
469: fetch get_rec into
470: l_org_description

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

484: close get_rec;
485: --
486: l_api_updating:=p_api_updating;
487: --
488: hr_utility.set_location(l_proc, 10);
489: --
490: if (g_org_description_upd
491: and l_api_updating
492: and dbms_lob.getlength(l_org_description)<=32767

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

499: ,1
500: ,p_rec.org_description);
501: end if;
502: --
503: hr_utility.set_location(l_proc, 20);
504: --
505: if (g_brief_description_upd
506: and l_api_updating
507: and dbms_lob.getlength(l_brief_description)<=32767

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

514: ,1
515: ,p_rec.brief_description);
516: end if;
517: --
518: hr_utility.set_location(l_proc, 30);
519: --
520: if (g_detailed_description_upd
521: and l_api_updating
522: and dbms_lob.getlength(l_detailed_description)<=32767

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

529: ,1
530: ,p_rec.detailed_description);
531: end if;
532: --
533: hr_utility.set_location(l_proc, 40);
534: --
535: if (g_job_requirements_upd
536: and l_api_updating
537: and dbms_lob.getlength(l_job_requirements)<=32767

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

544: ,1
545: ,p_rec.job_requirements);
546: end if;
547: --
548: hr_utility.set_location(l_proc, 50);
549: --
550: if (g_additional_details_upd
551: and l_api_updating
552: and dbms_lob.getlength(l_additional_details)<=32767

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

559: ,1
560: ,p_rec.additional_details);
561: end if;
562: --
563: hr_utility.set_location(l_proc, 60);
564: --
565: if (g_how_to_apply_upd
566: and l_api_updating
567: and dbms_lob.getlength(l_how_to_apply)<=32767

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

574: ,1
575: ,p_rec.how_to_apply);
576: end if;
577: --
578: hr_utility.set_location(l_proc, 70);
579: --
580: if (g_benefit_info_upd
581: and l_api_updating
582: and dbms_lob.getlength(l_benefit_info)<=32767

Line 593: hr_utility.set_location(l_proc, 80);

589: ,1
590: ,p_rec.benefit_info);
591: end if;
592: --
593: hr_utility.set_location(l_proc, 80);
594: --
595: if (g_image_url_upd
596: and l_api_updating
597: and dbms_lob.getlength(l_image_url)<=32767

Line 608: hr_utility.set_location(l_proc, 90);

604: ,1
605: ,p_rec.image_url);
606: end if;
607: --
608: hr_utility.set_location(l_proc, 90);
609: --
610: if (g_image_url_alt_upd
611: and l_api_updating
612: and dbms_lob.getlength(l_image_url_alt)<=32767

Line 623: hr_utility.set_location(' Leaving:'||l_proc, 100);

619: ,1
620: ,p_rec.image_url_alt);
621: end if;
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 100);
624: --
625: Exception
626: When hr_api.check_integrity_violated Then
627: -- A check constraint has been violated