APPS.IRC_IDT_SHD dependencies on HR_UTILITY

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

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

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

179: (p_api_name => l_proc
180: ,p_argument => 'DEFAULT_POSTING_ID'
181: ,p_argument_value => p_default_posting_id
182: );
183: hr_utility.set_location(l_proc,6);
184: hr_api.mandatory_arg_error
185: (p_api_name => l_proc
186: ,p_argument => 'LANGUAGE'
187: ,p_argument_value => p_language

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

215: irc_idt_shd.g_old_rec.image_url_alt
216: :=dbms_lob.substr(irc_idt_shd.g_old_rec.image_url_alt_c);
217: --
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: --
221: -- We need to trap the ORA LOCK exception
222: --
223: Exception

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

420: --
421: l_api_updating boolean;
422:
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: open get_rec;
427: fetch get_rec into
428: l_org_description

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

442: close get_rec;
443: --
444: l_api_updating:=p_api_updating;
445: --
446: hr_utility.set_location(l_proc, 10);
447: --
448: if (g_org_description_upd
449: and l_api_updating
450: and dbms_lob.getlength(l_org_description)<=32767

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

457: ,1
458: ,p_rec.org_description);
459: end if;
460: --
461: hr_utility.set_location(l_proc, 20);
462: --
463: if (g_brief_description_upd
464: and l_api_updating
465: and dbms_lob.getlength(l_brief_description)<=32767

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

472: ,1
473: ,p_rec.brief_description);
474: end if;
475: --
476: hr_utility.set_location(l_proc, 30);
477: --
478: if (g_detailed_description_upd
479: and l_api_updating
480: and dbms_lob.getlength(l_detailed_description)<=32767

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

487: ,1
488: ,p_rec.detailed_description);
489: end if;
490: --
491: hr_utility.set_location(l_proc, 40);
492: --
493: if (g_job_requirements_upd
494: and l_api_updating
495: and dbms_lob.getlength(l_job_requirements)<=32767

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

502: ,1
503: ,p_rec.job_requirements);
504: end if;
505: --
506: hr_utility.set_location(l_proc, 50);
507: --
508: if (g_additional_details_upd
509: and l_api_updating
510: and dbms_lob.getlength(l_additional_details)<=32767

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

517: ,1
518: ,p_rec.additional_details);
519: end if;
520: --
521: hr_utility.set_location(l_proc, 60);
522: --
523: if (g_how_to_apply_upd
524: and l_api_updating
525: and dbms_lob.getlength(l_how_to_apply)<=32767

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

532: ,1
533: ,p_rec.how_to_apply);
534: end if;
535: --
536: hr_utility.set_location(l_proc, 70);
537: --
538: if (g_image_url_upd
539: and l_api_updating
540: and dbms_lob.getlength(l_image_url)<=32767

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

547: ,1
548: ,p_rec.image_url);
549: end if;
550: --
551: hr_utility.set_location(l_proc, 80);
552: --
553: if (g_image_url_alt_upd
554: and l_api_updating
555: and dbms_lob.getlength(l_image_url_alt)<=32767

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

562: ,1
563: ,p_rec.image_url_alt);
564: end if;
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 100);
567: --
568: Exception
569: When hr_api.check_integrity_violated Then
570: -- A check constraint has been violated