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

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

48: --
49: l_proc varchar2(72) := g_package || 'chk_df';
50: --
51: begin
52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: if ((p_rec.notification_preference_id is not null) and (
55: nvl(irc_inp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

187: ,p_attribute30_value => p_rec.attribute30
188: );
189: end if;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc,20);
192: end chk_df;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |-----------------------< chk_non_updateable_args >------------------------|

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

294: --
295: --
296: Begin
297: --
298: hr_utility.set_location(' Entering:'||l_proc,10);
299: --
300: open l_person;
301: fetch l_person into l_party_id;
302: if l_person%notfound

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

314: else
315: p_party_id:=l_party_id;
316: end if;
317: --
318: hr_utility.set_location(l_proc,30);
319: --
320: --
321: hr_utility.set_location(' Leaving:'||l_proc,50);
322: --

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

317: --
318: hr_utility.set_location(l_proc,30);
319: --
320: --
321: hr_utility.set_location(' Leaving:'||l_proc,50);
322: --
323: exception
324: when app_exception.application_exception then
325: if hr_multi_message.exception_add

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

325: if hr_multi_message.exception_add
326: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'
327: ) then
328: --
329: hr_utility.set_location(' Leaving:'||l_proc,60);
330: --
331: raise;
332: end if;
333: --

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

330: --
331: raise;
332: end if;
333: --
334: hr_utility.set_location(' Leaving:'||l_proc,70);
335: --
336: End chk_person_id;
337: --
338: --

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

382: where party_id = p_party_id;
383: --
384: Begin
385: --
386: hr_utility.set_location(' Entering:'||l_proc,10);
387: --
388: hr_api.mandatory_arg_error
389: (p_api_name => l_proc
390: ,p_argument => 'PARTY_ID'

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

393: --
394: open csr_party_id;
395: fetch csr_party_id into l_party_id;
396: --
397: hr_utility.set_location(l_proc,20);
398: --
399: if csr_party_id%notfound then
400: close csr_party_id;
401: fnd_message.set_name('PER','IRC_412000_BAD_PARTY_PERSON_ID');

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

401: fnd_message.set_name('PER','IRC_412000_BAD_PARTY_PERSON_ID');
402: fnd_message.raise_error;
403: end if;
404: --
405: hr_utility.set_location(l_proc,30);
406: --
407: close csr_party_id;
408: --
409: open csr_chk_inp_pk;

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

408: --
409: open csr_chk_inp_pk;
410: fetch csr_chk_inp_pk into l_inp_pk;
411: --
412: hr_utility.set_location(l_proc,40);
413: --
414: if csr_chk_inp_pk%found then
415: close csr_chk_inp_pk;
416: fnd_message.set_name('PER','HR_6123_ALL_UNIQUE_NAME');

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

419: end if;
420: --
421: close csr_chk_inp_pk;
422: --
423: hr_utility.set_location(' Leaving:'||l_proc,50);
424: --
425: exception
426: when app_exception.application_exception then
427: if hr_multi_message.exception_add

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

427: if hr_multi_message.exception_add
428: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PARTY_ID'
429: ) then
430: --
431: hr_utility.set_location(' Leaving:'||l_proc,60);
432: --
433: raise;
434: end if;
435: --

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

432: --
433: raise;
434: end if;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc,70);
437: --
438: End chk_party_id;
439: --
440: -- ----------------------------------------------------------------------------

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

487: and address_id = p_address_id;
488: --
489: Begin
490: --
491: hr_utility.set_location(' Entering:'||l_proc,10);
492: --
493: -- Only proceed with person_id, address_id validation when
494: -- multi message list does not already contain an error with
495: -- person_id

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

499: ,p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'
500: ) then
501: if p_address_id is not null then
502: --
503: hr_utility.set_location(l_proc,20);
504: --
505: l_api_updating := irc_inp_shd.api_updating
506: (p_notification_preference_id => p_notification_preference_id
507: ,p_object_version_number => p_object_version_number);

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

505: l_api_updating := irc_inp_shd.api_updating
506: (p_notification_preference_id => p_notification_preference_id
507: ,p_object_version_number => p_object_version_number);
508: --
509: hr_utility.set_location(l_proc,30);
510: --
511: if(l_api_updating and nvl(p_address_id, hr_api.g_number)
512: <> nvl(irc_inp_shd.g_old_rec.address_id, hr_api.g_number))
513: or (not l_api_updating) then

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

511: if(l_api_updating and nvl(p_address_id, hr_api.g_number)
512: <> nvl(irc_inp_shd.g_old_rec.address_id, hr_api.g_number))
513: or (not l_api_updating) then
514: --
515: hr_utility.set_location(l_proc,40);
516: --
517: open csr_address_id;
518: fetch csr_address_id into l_address_id;
519: --

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

516: --
517: open csr_address_id;
518: fetch csr_address_id into l_address_id;
519: --
520: hr_utility.set_location(l_proc,50);
521: --
522: if csr_address_id%notfound then
523: close csr_address_id;
524: fnd_message.set_name('PER','IRC_412001_BAD_ADDRESS_ID');

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

524: fnd_message.set_name('PER','IRC_412001_BAD_ADDRESS_ID');
525: fnd_message.raise_error;
526: end if;
527: --
528: hr_utility.set_location(l_proc,60);
529: --
530: close csr_address_id;
531: --
532: end if;

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

534: end if;
535: --
536: end if;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc,70);
539: --
540: exception
541: when app_exception.application_exception then
542: if hr_multi_message.exception_add

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

542: if hr_multi_message.exception_add
543: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ADDRESS_ID'
544: ) then
545: --
546: hr_utility.set_location(' Leaving:'||l_proc,80);
547: --
548: raise;
549: end if;
550: --

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

547: --
548: raise;
549: end if;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc,90);
552: --
553: End chk_address_id;
554: --
555: -- ----------------------------------------------------------------------------

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

592: l_api_updating boolean;
593: --
594: Begin
595: --
596: hr_utility.set_location(' Entering:'||l_proc,10);
597: --
598: hr_api.mandatory_arg_error
599: (p_api_name => l_proc
600: ,p_argument => 'MATCHING_JOBS'

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

604: l_api_updating := irc_inp_shd.api_updating
605: (p_notification_preference_id => p_notification_preference_id
606: ,p_object_version_number => p_object_version_number);
607: --
608: hr_utility.set_location(l_proc,20);
609: --
610: if (l_api_updating
611: and nvl(p_matching_jobs, hr_api.g_varchar2)
612: <> nvl(irc_inp_shd.g_old_rec.matching_jobs, hr_api.g_varchar2))

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

611: and nvl(p_matching_jobs, hr_api.g_varchar2)
612: <> nvl(irc_inp_shd.g_old_rec.matching_jobs, hr_api.g_varchar2))
613: or (not l_api_updating) then
614: --
615: hr_utility.set_location(l_proc,30);
616: --
617: if (p_matching_jobs not in ('Y','N')) then
618: fnd_message.set_name('PER','IRC_412002_BAD_MATCHING_JOBS');
619: fnd_message.raise_error;

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

619: fnd_message.raise_error;
620: end if;
621: end if;
622: --
623: hr_utility.set_location(' Leaving:'||l_proc,40);
624: --
625: exception
626: when app_exception.application_exception then
627: if hr_multi_message.exception_add

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

627: if hr_multi_message.exception_add
628: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.MATCHING_JOBS'
629: ) then
630: --
631: hr_utility.set_location(' Leaving:'||l_proc,50);
632: --
633: raise;
634: end if;
635: --

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

632: --
633: raise;
634: end if;
635: --
636: hr_utility.set_location(' Leaving:'||l_proc,60);
637: --
638: End chk_matching_jobs;
639: --
640: -- ----------------------------------------------------------------------------

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

681: l_api_updating boolean;
682: --
683: Begin
684: --
685: hr_utility.set_location(' Entering:'||l_proc,10);
686: --
687: hr_api.mandatory_arg_error
688: (p_api_name => l_proc
689: ,p_argument => 'MATCHING_JOB_FREQ'

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

693: l_api_updating := irc_inp_shd.api_updating
694: (p_notification_preference_id => p_notification_preference_id
695: ,p_object_version_number => p_object_version_number);
696: --
697: hr_utility.set_location(l_proc,20);
698: --
699: if (l_api_updating
700: and nvl(p_matching_job_freq, hr_api.g_varchar2)
701: <> nvl(irc_inp_shd.g_old_rec.matching_job_freq, hr_api.g_varchar2))

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

700: and nvl(p_matching_job_freq, hr_api.g_varchar2)
701: <> nvl(irc_inp_shd.g_old_rec.matching_job_freq, hr_api.g_varchar2))
702: or (not l_api_updating) then
703: --
704: hr_utility.set_location(l_proc,30);
705: --
706: if hr_api.not_exists_in_hr_lookups
707: ( p_effective_date => p_effective_date
708: , p_lookup_type => 'IRC_MESSAGE_FREQ'

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

711: fnd_message.raise_error;
712: end if;
713: end if;
714: --
715: hr_utility.set_location(' Leaving:'||l_proc,40);
716: --
717: exception
718: when app_exception.application_exception then
719: if hr_multi_message.exception_add

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

719: if hr_multi_message.exception_add
720: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.MATCHING_JOB_FREQ'
721: ) then
722: --
723: hr_utility.set_location(' Leaving:'||l_proc,50);
724: --
725: raise;
726: end if;
727: --

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

724: --
725: raise;
726: end if;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc,60);
729: --
730: End chk_matching_job_freq;
731: --
732: -- ----------------------------------------------------------------------------

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

769: l_api_updating boolean;
770: --
771: Begin
772: --
773: hr_utility.set_location(' Entering:'||l_proc,10);
774: --
775: hr_api.mandatory_arg_error
776: (p_api_name => l_proc
777: ,p_argument => 'RECEIVE_INFO_MAIL'

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

781: l_api_updating := irc_inp_shd.api_updating
782: (p_notification_preference_id => p_notification_preference_id
783: ,p_object_version_number => p_object_version_number);
784: --
785: hr_utility.set_location(l_proc,20);
786: --
787: if (l_api_updating
788: and nvl(p_receive_info_mail, hr_api.g_varchar2)
789: <> nvl(irc_inp_shd.g_old_rec.receive_info_mail, hr_api.g_varchar2))

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

788: and nvl(p_receive_info_mail, hr_api.g_varchar2)
789: <> nvl(irc_inp_shd.g_old_rec.receive_info_mail, hr_api.g_varchar2))
790: or (not l_api_updating) then
791: --
792: hr_utility.set_location(l_proc,30);
793: --
794: if p_receive_info_mail not in ('Y','N') then
795: fnd_message.set_name('PER','IRC_412004_BAD_REC_INFO_MAIL');
796: fnd_message.raise_error;

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

796: fnd_message.raise_error;
797: end if;
798: end if;
799: --
800: hr_utility.set_location(' Leaving:'||l_proc,40);
801: --
802: exception
803: when app_exception.application_exception then
804: if hr_multi_message.exception_add

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

804: if hr_multi_message.exception_add
805: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.RECEIVE_INFO_MAIL'
806: ) then
807: --
808: hr_utility.set_location(' Leaving:'||l_proc,50);
809: --
810: raise;
811: end if;
812: --

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

809: --
810: raise;
811: end if;
812: --
813: hr_utility.set_location(' Leaving:'||l_proc,60);
814: --
815: End chk_receive_info_mail;
816: --
817: -- ----------------------------------------------------------------------------

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

854: l_api_updating boolean;
855: --
856: Begin
857: --
858: hr_utility.set_location(' Entering:'||l_proc,10);
859: --
860: hr_api.mandatory_arg_error
861: (p_api_name => l_proc
862: ,p_argument => 'ALLOW_ACCESS'

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

866: l_api_updating := irc_inp_shd.api_updating
867: (p_notification_preference_id => p_notification_preference_id
868: ,p_object_version_number => p_object_version_number);
869: --
870: hr_utility.set_location(l_proc,20);
871: --
872: if (l_api_updating
873: and nvl(p_allow_access, hr_api.g_varchar2)
874: <> nvl(irc_inp_shd.g_old_rec.allow_access, hr_api.g_varchar2))

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

878: fnd_message.raise_error;
879: end if;
880: end if;
881: --
882: hr_utility.set_location(' Leaving:'||l_proc,30);
883: --
884: exception
885: when app_exception.application_exception then
886: if hr_multi_message.exception_add

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

886: if hr_multi_message.exception_add
887: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ALLOW_ACCESS'
888: ) then
889: --
890: hr_utility.set_location(' Leaving:'||l_proc,40);
891: --
892: raise;
893: end if;
894: --

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

891: --
892: raise;
893: end if;
894: --
895: hr_utility.set_location(' Leaving:'||l_proc,50);
896: --
897: End chk_allow_access;
898: --
899: -- ----------------------------------------------------------------------------

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

936: and vendor_type_lookup_code = 'IRC_JOB_AGENCY';
937: --
938: Begin
939: --
940: hr_utility.set_location(' Entering:'||l_proc,10);
941: --
942: open csr_agency_id;
943: fetch csr_agency_id into l_agency_id;
944: --

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

941: --
942: open csr_agency_id;
943: fetch csr_agency_id into l_agency_id;
944: --
945: hr_utility.set_location(l_proc,20);
946:
947: if csr_agency_id%notfound then
948: close csr_agency_id;
949: fnd_message.set_name('PER','IRC_BAD_AGENCY_ID');

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

949: fnd_message.set_name('PER','IRC_BAD_AGENCY_ID');
950: fnd_message.raise_error;
951: end if;
952: --
953: hr_utility.set_location(l_proc,30);
954: --
955: close csr_agency_id;
956: --
957: hr_utility.set_location(' Leaving:'||l_proc,50);

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

953: hr_utility.set_location(l_proc,30);
954: --
955: close csr_agency_id;
956: --
957: hr_utility.set_location(' Leaving:'||l_proc,50);
958: --
959: exception
960: when app_exception.application_exception then
961: if hr_multi_message.exception_add

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

961: if hr_multi_message.exception_add
962: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.AGENCY_ID'
963: ) then
964: --
965: hr_utility.set_location(' Leaving:'||l_proc,60);
966: --
967: raise;
968: end if;
969: --

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

966: --
967: raise;
968: end if;
969: --
970: hr_utility.set_location(' Leaving:'||l_proc,70);
971: --
972: End chk_agency_id;
973: --
974: -- ----------------------------------------------------------------------------

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

1014: where attempt_id = p_attempt_id;
1015: --
1016: Begin
1017: --
1018: hr_utility.set_location(' Entering:'||l_proc,10);
1019: --
1020: l_api_updating := irc_inp_shd.api_updating
1021: (p_notification_preference_id => p_notification_preference_id
1022: ,p_object_version_number => p_object_version_number

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

1021: (p_notification_preference_id => p_notification_preference_id
1022: ,p_object_version_number => p_object_version_number
1023: );
1024: --
1025: hr_utility.set_location(l_proc, 20);
1026: if ((l_api_updating and
1027: nvl(irc_inp_shd.g_old_rec.attempt_id, hr_api.g_number) <>
1028: nvl(p_attempt_id, hr_api.g_number))
1029: or

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

1028: nvl(p_attempt_id, hr_api.g_number))
1029: or
1030: (NOT l_api_updating)) then
1031: --
1032: hr_utility.set_location(l_proc, 30);
1033: --
1034: -- Check if attempt_id is not null
1035: --
1036: if p_attempt_id IS NOT NULL then

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

1039: --
1040: open csr_attempt_exists;
1041: fetch csr_attempt_exists into l_attempt_exists;
1042: --
1043: hr_utility.set_location(l_proc,40);
1044: --
1045: if csr_attempt_exists%notfound then
1046: close csr_attempt_exists;
1047: hr_utility.set_location(l_proc,50);

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

1043: hr_utility.set_location(l_proc,40);
1044: --
1045: if csr_attempt_exists%notfound then
1046: close csr_attempt_exists;
1047: hr_utility.set_location(l_proc,50);
1048: fnd_message.set_name('PER','IRC_412233_INV_OTA_ATTEMPT');
1049: fnd_message.raise_error;
1050: else
1051: close csr_attempt_exists;

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

1053: --
1054: end if;
1055: end if;
1056: --
1057: hr_utility.set_location(' Leaving:'||l_proc,60);
1058: --
1059: exception
1060: when app_exception.application_exception then
1061: if hr_multi_message.exception_add

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

1061: if hr_multi_message.exception_add
1062: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ATTEMPT_ID'
1063: ) then
1064: --
1065: hr_utility.set_location(' Leaving:'||l_proc,70);
1066: --
1067: raise;
1068: end if;
1069: --

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

1066: --
1067: raise;
1068: end if;
1069: --
1070: hr_utility.set_location(' Leaving:'||l_proc,80);
1071: --
1072: End chk_attempt_id;
1073: --
1074: -- ----------------------------------------------------------------------------

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

1081: --
1082: l_proc varchar2(72) := g_package||'insert_validate';
1083: --
1084: Begin
1085: hr_utility.set_location('Entering:'||l_proc, 5);
1086: --
1087: -- Call all supporting business operations
1088: --
1089: chk_person_id

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

1091: ,p_party_id => p_rec.party_id
1092: ,p_effective_date=>p_effective_date
1093: );
1094: --
1095: hr_utility.set_location(l_proc, 10);
1096: --
1097: chk_address_id
1098: (p_address_id => p_rec.address_id
1099: ,p_notification_preference_id => p_rec.notification_preference_id

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

1099: ,p_notification_preference_id => p_rec.notification_preference_id
1100: ,p_person_id => p_rec.person_id
1101: ,p_object_version_number => p_rec.object_version_number);
1102: --
1103: hr_utility.set_location(l_proc, 20);
1104: --
1105: chk_matching_jobs
1106: (p_matching_jobs => p_rec.matching_jobs
1107: ,p_notification_preference_id => p_rec.notification_preference_id

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

1106: (p_matching_jobs => p_rec.matching_jobs
1107: ,p_notification_preference_id => p_rec.notification_preference_id
1108: ,p_object_version_number => p_rec.object_version_number);
1109: --
1110: hr_utility.set_location(l_proc, 30);
1111: --
1112: chk_matching_job_freq
1113: (p_matching_job_freq => p_rec.matching_job_freq
1114: ,p_effective_date => p_effective_date

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

1114: ,p_effective_date => p_effective_date
1115: ,p_notification_preference_id => p_rec.notification_preference_id
1116: ,p_object_version_number => p_rec.object_version_number);
1117: --
1118: hr_utility.set_location(l_proc, 40);
1119: --
1120: chk_receive_info_mail
1121: (p_receive_info_mail => p_rec.receive_info_mail
1122: ,p_notification_preference_id => p_rec.notification_preference_id

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

1121: (p_receive_info_mail => p_rec.receive_info_mail
1122: ,p_notification_preference_id => p_rec.notification_preference_id
1123: ,p_object_version_number => p_rec.object_version_number);
1124: --
1125: hr_utility.set_location(l_proc, 50);
1126: --
1127: chk_allow_access
1128: (p_allow_access => p_rec.allow_access
1129: ,p_notification_preference_id => p_rec.notification_preference_id

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

1128: (p_allow_access => p_rec.allow_access
1129: ,p_notification_preference_id => p_rec.notification_preference_id
1130: ,p_object_version_number => p_rec.object_version_number);
1131: --
1132: hr_utility.set_location(l_proc, 60);
1133: --
1134: if p_rec.agency_id is not null then
1135: chk_agency_id
1136: (p_agency_id => p_rec.agency_id);

Line 1139: hr_utility.set_location(l_proc, 65);

1135: chk_agency_id
1136: (p_agency_id => p_rec.agency_id);
1137: end if;
1138: --
1139: hr_utility.set_location(l_proc, 65);
1140: chk_attempt_id
1141: (p_attempt_id => p_rec.attempt_id
1142: ,p_notification_preference_id => p_rec.notification_preference_id
1143: ,p_object_version_number => p_rec.object_version_number);

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

1141: (p_attempt_id => p_rec.attempt_id
1142: ,p_notification_preference_id => p_rec.notification_preference_id
1143: ,p_object_version_number => p_rec.object_version_number);
1144: --
1145: hr_utility.set_location(l_proc, 70);
1146: --
1147: irc_inp_bus.chk_df(p_rec);
1148: --
1149: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

1145: hr_utility.set_location(l_proc, 70);
1146: --
1147: irc_inp_bus.chk_df(p_rec);
1148: --
1149: hr_utility.set_location(' Leaving:'||l_proc, 80);
1150: End insert_validate;
1151: --
1152: -- ----------------------------------------------------------------------------
1153: -- |---------------------------< update_validate >----------------------------|

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

1159: --
1160: l_proc varchar2(72) := g_package||'update_validate';
1161: --
1162: Begin
1163: hr_utility.set_location('Entering:'||l_proc, 5);
1164: --
1165: -- Call all supporting business operations
1166: --
1167: chk_person_id

Line 1174: hr_utility.set_location('Entering:'||l_proc, 6);

1170: ,p_effective_date=>p_effective_date
1171: );
1172: --
1173: --
1174: hr_utility.set_location('Entering:'||l_proc, 6);
1175: --
1176: chk_address_id
1177: (p_address_id => p_rec.address_id
1178: ,p_notification_preference_id => p_rec.notification_preference_id

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

1178: ,p_notification_preference_id => p_rec.notification_preference_id
1179: ,p_person_id => p_rec.person_id
1180: ,p_object_version_number => p_rec.object_version_number);
1181: --
1182: hr_utility.set_location(l_proc, 10);
1183: --
1184: chk_matching_jobs
1185: (p_matching_jobs => p_rec.matching_jobs
1186: ,p_notification_preference_id => p_rec.notification_preference_id

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

1185: (p_matching_jobs => p_rec.matching_jobs
1186: ,p_notification_preference_id => p_rec.notification_preference_id
1187: ,p_object_version_number => p_rec.object_version_number);
1188: --
1189: hr_utility.set_location(l_proc, 20);
1190: --
1191: chk_matching_job_freq
1192: (p_matching_job_freq => p_rec.matching_job_freq
1193: ,p_effective_date => p_effective_date

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

1193: ,p_effective_date => p_effective_date
1194: ,p_notification_preference_id => p_rec.notification_preference_id
1195: ,p_object_version_number => p_rec.object_version_number);
1196: --
1197: hr_utility.set_location(l_proc, 30);
1198: --
1199: chk_receive_info_mail
1200: (p_receive_info_mail => p_rec.receive_info_mail
1201: ,p_notification_preference_id => p_rec.notification_preference_id

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

1200: (p_receive_info_mail => p_rec.receive_info_mail
1201: ,p_notification_preference_id => p_rec.notification_preference_id
1202: ,p_object_version_number => p_rec.object_version_number);
1203: --
1204: hr_utility.set_location(l_proc, 40);
1205: --
1206: chk_allow_access
1207: (p_allow_access => p_rec.allow_access
1208: ,p_notification_preference_id => p_rec.notification_preference_id

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

1207: (p_allow_access => p_rec.allow_access
1208: ,p_notification_preference_id => p_rec.notification_preference_id
1209: ,p_object_version_number => p_rec.object_version_number);
1210: --
1211: hr_utility.set_location(l_proc, 50);
1212: --
1213: if p_rec.agency_id is not null then
1214: chk_agency_id
1215: (p_agency_id => p_rec.agency_id);

Line 1218: hr_utility.set_location(l_proc, 55);

1214: chk_agency_id
1215: (p_agency_id => p_rec.agency_id);
1216: end if;
1217: --
1218: hr_utility.set_location(l_proc, 55);
1219: chk_attempt_id
1220: (p_attempt_id => p_rec.attempt_id
1221: ,p_notification_preference_id => p_rec.notification_preference_id
1222: ,p_object_version_number => p_rec.object_version_number);

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

1220: (p_attempt_id => p_rec.attempt_id
1221: ,p_notification_preference_id => p_rec.notification_preference_id
1222: ,p_object_version_number => p_rec.object_version_number);
1223: --
1224: hr_utility.set_location(l_proc, 60);
1225: --
1226: chk_non_updateable_args
1227: (p_effective_date => p_effective_date
1228: ,p_rec => p_rec

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

1229: );
1230: --
1231: irc_inp_bus.chk_df(p_rec);
1232: --
1233: hr_utility.set_location(' Leaving:'||l_proc, 60);
1234: End update_validate;
1235: --
1236: -- ----------------------------------------------------------------------------
1237: -- |---------------------------< delete_validate >----------------------------|

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

1242: --
1243: l_proc varchar2(72) := g_package||'delete_validate';
1244: --
1245: Begin
1246: hr_utility.set_location('Entering:'||l_proc, 5);
1247: --
1248: -- Call all supporting business operations
1249: --
1250: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1246: hr_utility.set_location('Entering:'||l_proc, 5);
1247: --
1248: -- Call all supporting business operations
1249: --
1250: hr_utility.set_location(' Leaving:'||l_proc, 10);
1251: End delete_validate;
1252: --
1253: end irc_inp_bus;