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

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

45: l_legislation_code varchar2(150);
46: --
47: begin
48: --
49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error

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

85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
91: end set_security_group_id;
92: --
93: -- ---------------------------------------------------------------------------

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

120: l_proc varchar2(72) := g_package||'return_legislation_code';
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'|| l_proc, 10);
125: --
126: -- Ensure that all the mandatory parameter are not null
127: --
128: hr_api.mandatory_arg_error

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

138: -- call to this function. Just return the value in the global
139: -- variable.
140: --
141: l_legislation_code := irc_ita_bus.g_legislation_code;
142: hr_utility.set_location(l_proc, 20);
143: else
144: --
145: -- The ID is different to the last call to this function
146: -- or this is the first call to this function.

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

155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Set the global variables so the values are
162: -- available for the next call to this function.
163: --

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

164: close csr_leg_code;
165: irc_ita_bus.g_template_association_id := p_template_association_id;
166: irc_ita_bus.g_legislation_code := l_legislation_code;
167: end if;
168: hr_utility.set_location(' Leaving:'|| l_proc, 40);
169: return l_legislation_code;
170: end return_legislation_code;
171: --
172: -- ----------------------------------------------------------------------------

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

276: from xdo_templates_b
277: where template_id = p_template_id;
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc,10);
281: --
282: l_api_updating := irc_ita_shd.api_updating
283: (p_template_association_id => p_template_association_id
284: ,p_object_version_number => p_object_version_number);

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

281: --
282: l_api_updating := irc_ita_shd.api_updating
283: (p_template_association_id => p_template_association_id
284: ,p_object_version_number => p_object_version_number);
285: hr_utility.set_location(l_proc,20);
286: if ((l_api_updating
287: and
288: nvl(irc_ita_shd.g_old_rec.template_id,hr_api.g_number) <>
289: nvl(p_template_id, hr_api.g_number))

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

293: if(p_template_id is not null)
294: then
295: open csr_template;
296: fetch csr_template into l_template_id;
297: hr_utility.set_location(l_proc,30);
298: if(csr_template%notfound)
299: then
300: close csr_template;
301: fnd_message.set_name('PER','IRC_412326_OFFER_INV_TEMPLT_ID');

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

313:
314: end if;
315: end if;
316: --
317: hr_utility.set_location(' Leaving:'||l_proc,40);
318: --
319: exception
320: when app_exception.application_exception then
321: if hr_multi_message.exception_add

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

320: when app_exception.application_exception then
321: if hr_multi_message.exception_add
322: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
323: ) then
324: hr_utility.set_location(' Leaving:'|| l_proc, 50);
325: raise;
326: end if;
327: hr_utility.set_location(' Leaving:'|| l_proc, 60);
328: End chk_template_id;

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

323: ) then
324: hr_utility.set_location(' Leaving:'|| l_proc, 50);
325: raise;
326: end if;
327: hr_utility.set_location(' Leaving:'|| l_proc, 60);
328: End chk_template_id;
329: --
330: -- ---------------------------------------------------------------------------
331: -- |---------------------------< chk_organization_id >--------------------------|

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

366: where haou.organization_id = p_organization_id;
367: --
368: --
369: begin
370: hr_utility.set_location('Entering:'|| l_proc, 10);
371: --
372: if hr_multi_message.no_exclusive_error
373: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
374: ) then

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

378: or (irc_ita_shd.g_old_rec.template_association_id is not null
379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)
380: <> nvl(p_organization_id, hr_api.g_number))) then
381: --
382: hr_utility.set_location(l_proc, 20);
383: --
384: -- Check that the organization ID is linked to a
385: -- valid organization on HR_ALL_ORGANIZATON_UNITS
386: --

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

393: fnd_message.raise_error;
394: end if;
395: close csr_org;
396: --
397: hr_utility.set_location(l_proc, 30);
398: --
399: end if;
400: end if; -- no exclusive error
401: --

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

398: --
399: end if;
400: end if; -- no exclusive error
401: --
402: hr_utility.set_location(' Leaving:'|| l_proc, 40);
403: --
404: exception
405: when app_exception.application_exception then
406: if hr_multi_message.exception_add

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

405: when app_exception.application_exception then
406: if hr_multi_message.exception_add
407: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.ORGANIZATION_ID'
408: ) then
409: hr_utility.set_location(' Leaving:'|| l_proc, 50);
410: raise;
411: end if;
412: hr_utility.set_location(' Leaving:'|| l_proc, 60);
413: end chk_organization_id;

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

408: ) then
409: hr_utility.set_location(' Leaving:'|| l_proc, 50);
410: raise;
411: end if;
412: hr_utility.set_location(' Leaving:'|| l_proc, 60);
413: end chk_organization_id;
414: --
415: -- ---------------------------------------------------------------------------
416: -- |-----------------------------< chk_job_id >-----------------------------|

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

450: from per_jobs pj
451: where pj.job_id = p_job_id;
452: --
453: begin
454: hr_utility.set_location('Entering:'|| l_proc, 10);
455: --
456: if hr_multi_message.no_exclusive_error
457: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
458: ) then

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

462: or (irc_ita_shd.g_old_rec.template_association_id is not null
463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)
464: <> nvl(p_job_id, hr_api.g_number))) then
465: --
466: hr_utility.set_location(l_proc, 20);
467: --
468: -- Check that the job ID is linked to a
469: -- valid job on per_jobs
470: --

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

479: --
480: end if;
481: --
482: close csr_job;
483: hr_utility.set_location(l_proc, 30);
484: --
485: end if;
486: end if; -- no exclusive error
487: --

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

484: --
485: end if;
486: end if; -- no exclusive error
487: --
488: hr_utility.set_location(' Leaving:'|| l_proc, 40);
489: --
490: exception
491: when app_exception.application_exception then
492: if hr_multi_message.exception_add

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

491: when app_exception.application_exception then
492: if hr_multi_message.exception_add
493: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.JOB_ID'
494: ) then
495: hr_utility.set_location(' Leaving:'|| l_proc, 50);
496: raise;
497: end if;
498: hr_utility.set_location(' Leaving:'|| l_proc, 60);
499: end chk_job_id;

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

494: ) then
495: hr_utility.set_location(' Leaving:'|| l_proc, 50);
496: raise;
497: end if;
498: hr_utility.set_location(' Leaving:'|| l_proc, 60);
499: end chk_job_id;
500: --
501: -- ---------------------------------------------------------------------------
502: -- |---------------------------< chk_position_id >--------------------------|

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

538: and trunc(sysdate) between hapf.effective_start_date
539: and hapf.effective_end_date;
540: --
541: begin
542: hr_utility.set_location('Entering:'|| l_proc, 10);
543: --
544: if hr_multi_message.no_exclusive_error
545: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
546: ) then

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

550: or (irc_ita_shd.g_old_rec.template_association_id is not null
551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)
552: <> nvl(p_position_id, hr_api.g_number))) then
553: --
554: hr_utility.set_location(l_proc, 20);
555: --
556: -- Check that the Position ID is linked to a
557: -- valid position on HR_ALL_POSITIONS_F
558: --

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

567: --
568: end if;
569: --
570: close csr_pos;
571: hr_utility.set_location(l_proc, 30);
572: --
573: end if;
574: end if; -- no exclusive error
575: --

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

572: --
573: end if;
574: end if; -- no exclusive error
575: --
576: hr_utility.set_location(' Leaving:'|| l_proc, 40);
577: --
578: exception
579: when app_exception.application_exception then
580: if hr_multi_message.exception_add

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

579: when app_exception.application_exception then
580: if hr_multi_message.exception_add
581: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.POSITION_ID'
582: ) then
583: hr_utility.set_location(' Leaving:'|| l_proc, 50);
584: raise;
585: end if;
586: hr_utility.set_location(' Leaving:'|| l_proc, 60);
587: end chk_position_id;

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

582: ) then
583: hr_utility.set_location(' Leaving:'|| l_proc, 50);
584: raise;
585: end if;
586: hr_utility.set_location(' Leaving:'|| l_proc, 60);
587: end chk_position_id;
588: --
589: -- ---------------------------------------------------------------------------
590: -- |----------------------< chk_job_position_organization >------------------|

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

624: l_flag varchar2(1);
625: --
626:
627: begin
628: hr_utility.set_location('Entering:'|| l_proc, 10);
629: --
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
632: ) then

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

651: fnd_message.raise_error;
652: end if;
653: end if; -- no exclusive error
654: --
655: hr_utility.set_location(' Leaving:'|| l_proc, 40);
656: --
657: exception
658: when app_exception.application_exception then
659: if hr_multi_message.exception_add

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

660: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.JOB_ID'
661: ,p_associated_column2 => 'IRC_TEMPLATE_ASSOCIATIONS.ORGANIZATION_ID'
662: ,p_associated_column3 => 'IRC_TEMPLATE_ASSOCIATIONS.POSITION_ID'
663: ) then
664: hr_utility.set_location(' Leaving:'|| l_proc, 50);
665: raise;
666: end if;
667: hr_utility.set_location(' Leaving:'|| l_proc, 60);
668: end chk_job_position_organization;

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

663: ) then
664: hr_utility.set_location(' Leaving:'|| l_proc, 50);
665: raise;
666: end if;
667: hr_utility.set_location(' Leaving:'|| l_proc, 60);
668: end chk_job_position_organization;
669:
670: --
671: -- ---------------------------------------------------------------------------

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

725: and ita.template_id = p_template_id;
726: --
727:
728: begin
729: hr_utility.set_location('Entering:'|| l_proc, 10);
730: --
731: if hr_multi_message.no_exclusive_error
732: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
733: ) then

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

780: end if;
781: --
782: end if; -- no exclusive error
783: --
784: hr_utility.set_location(' Leaving:'|| l_proc, 40);
785: --
786: exception
787: when app_exception.application_exception then
788: if hr_multi_message.exception_add

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

789: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.JOB_ID'
790: ,p_associated_column2 => 'IRC_TEMPLATE_ASSOCIATIONS.ORGANIZATION_ID'
791: ,p_associated_column3 => 'IRC_TEMPLATE_ASSOCIATIONS.POSITION_ID'
792: ) then
793: hr_utility.set_location(' Leaving:'|| l_proc, 50);
794: raise;
795: end if;
796: hr_utility.set_location(' Leaving:'|| l_proc, 60);
797: end chk_duplicate_template_id;

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

792: ) then
793: hr_utility.set_location(' Leaving:'|| l_proc, 50);
794: raise;
795: end if;
796: hr_utility.set_location(' Leaving:'|| l_proc, 60);
797: end chk_duplicate_template_id;
798:
799: --
800: -- ---------------------------------------------------------------------------

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

835: l_proc VARCHAR2(72) := g_package||'chk_default_association';
836: l_api_updating boolean;
837: Begin
838: --
839: hr_utility.set_location('Entering:'|| l_proc, 10);
840: --
841: if hr_multi_message.no_exclusive_error
842: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
843: ) then

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

845: l_api_updating := irc_ita_shd.api_updating
846: (p_template_association_id => p_template_association_id
847: ,p_object_version_number => p_object_version_number);
848: --
849: hr_utility.set_location(l_proc,20);
850: --
851: -- Check if the value for default_association is set on insert or has
852: -- changed on update.
853: --

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

860: --
861: -- Check that default_association exists in hr_lookups for the
862: -- lookup type 'YES_NO' with an enabled flag set to 'Y'.
863: --
864: hr_utility.set_location(l_proc,30);
865: if hr_api.not_exists_in_hr_lookups
866: (p_lookup_type => 'YES_NO'
867: ,p_lookup_code => p_default_association
868: ,p_effective_date => p_creation_date

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

868: ,p_effective_date => p_creation_date
869: )
870: then
871: --
872: hr_utility.set_location(l_proc,40);
873: fnd_message.set_name('PER','IRC_412329_OFR_INV_DEF_TMP_ASS');
874: fnd_message.raise_error;
875: --
876: end if;

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

875: --
876: end if;
877: end if;
878: end if; -- no exclusive error
879: hr_utility.set_location('Leaving: '||l_proc,50);
880: --
881: exception
882: when app_exception.application_exception then
883: if hr_multi_message.exception_add

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

882: when app_exception.application_exception then
883: if hr_multi_message.exception_add
884: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.DEFAULT_ASSOCIATION'
885: ) then
886: hr_utility.set_location(' Leaving:'|| l_proc, 60);
887: raise;
888: end if;
889: hr_utility.set_location(' Leaving:'|| l_proc, 70);
890: End chk_default_association;

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

885: ) then
886: hr_utility.set_location(' Leaving:'|| l_proc, 60);
887: raise;
888: end if;
889: hr_utility.set_location(' Leaving:'|| l_proc, 70);
890: End chk_default_association;
891: --
892: -- ----------------------------------------------------------------------------
893: -- |---------------------------< chk_dates >----------------------------------|

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

924: l_proc varchar2(72) := g_package || 'chk_dates';
925: l_api_updating boolean;
926: --
927: Begin
928: hr_utility.set_location('Entering:'||l_proc,10);
929: --
930: if hr_multi_message.no_exclusive_error
931: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
932: ) then

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

934: l_api_updating := irc_ita_shd.api_updating
935: (p_template_association_id => p_template_association_id
936: ,p_object_version_number => p_object_version_number);
937: --
938: hr_utility.set_location(l_proc,20);
939: if ((l_api_updating
940: and
941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>
942: nvl(p_start_date, hr_api.g_date) or

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

944: nvl(p_end_date, hr_api.g_date)))
945: or
946: (NOT l_api_updating)) then
947: --
948: hr_utility.set_location(l_proc,30);
949: if (p_start_date is not null)
950: then
951: hr_utility.set_location(l_proc,40);
952: --

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

947: --
948: hr_utility.set_location(l_proc,30);
949: if (p_start_date is not null)
950: then
951: hr_utility.set_location(l_proc,40);
952: --
953: if (p_start_date > nvl(p_end_date,hr_api.g_eot))
954: then
955: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');

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

961: end if;
962: end if;
963: end if; -- no exclusive error
964: --
965: hr_utility.set_location(' Leaving:'||l_proc,50);
966: --
967: exception
968: when app_exception.application_exception then
969: if hr_multi_message.exception_add

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

969: if hr_multi_message.exception_add
970: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.START_DATE'
971: ,p_associated_column2 => 'IRC_TEMPLATE_ASSOCIATIONS.END_DATE'
972: ) then
973: hr_utility.set_location(' Leaving:'|| l_proc, 60);
974: raise;
975: end if;
976: hr_utility.set_location(' Leaving:'|| l_proc, 70);
977: End chk_dates;

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

972: ) then
973: hr_utility.set_location(' Leaving:'|| l_proc, 60);
974: raise;
975: end if;
976: hr_utility.set_location(' Leaving:'|| l_proc, 70);
977: End chk_dates;
978: --
979: -- ----------------------------------------------------------------------------
980: -- |---------------------------< insert_validate >----------------------------|

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

986: --
987: l_proc varchar2(72) := g_package||'insert_validate';
988: --
989: Begin
990: hr_utility.set_location('Entering:'||l_proc, 5);
991: --
992: -- Call all supporting business operations
993: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.
994:

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

1060: ,p_object_version_number => p_rec.object_version_number
1061: ,p_start_date => p_rec.start_date
1062: ,p_end_date => p_rec.end_date
1063: );
1064: hr_utility.set_location(' Leaving:'||l_proc, 10);
1065: End insert_validate;
1066: --
1067: -- ----------------------------------------------------------------------------
1068: -- |---------------------------< update_validate >----------------------------|

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

1074: --
1075: l_proc varchar2(72) := g_package||'update_validate';
1076: --
1077: Begin
1078: hr_utility.set_location('Entering:'||l_proc, 5);
1079: --
1080: -- Call all supporting business operations
1081: --
1082:

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

1149: ,p_end_date => p_rec.end_date
1150: );
1151:
1152:
1153: hr_utility.set_location(' Leaving:'||l_proc, 10);
1154: End update_validate;
1155: --
1156: -- ----------------------------------------------------------------------------
1157: -- |---------------------------< delete_validate >----------------------------|

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

1162: --
1163: l_proc varchar2(72) := g_package||'delete_validate';
1164: --
1165: Begin
1166: hr_utility.set_location('Entering:'||l_proc, 5);
1167: --
1168: -- Call all supporting business operations
1169: --
1170: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1166: hr_utility.set_location('Entering:'||l_proc, 5);
1167: --
1168: -- Call all supporting business operations
1169: --
1170: hr_utility.set_location(' Leaving:'||l_proc, 10);
1171: End delete_validate;
1172: --
1173: end irc_ita_bus;