DBA Data[Home] [Help]

APPS.PER_ABB_BUS dependencies on HR_UTILITY

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

38: l_proc varchar2(72) := g_package||'return_legislation_code';
39: --
40: Begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error

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

56: -- call to this function. Just return the value in the global
57: -- variable.
58: --
59: l_legislation_code := per_abb_bus.g_legislation_code;
60: hr_utility.set_location(l_proc, 20);
61: else
62: --
63: -- The ID is different to the last call to this function
64: -- or this is the first call to this function.

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

73: close csr_leg_code;
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: fnd_message.raise_error;
76: end if;
77: hr_utility.set_location(l_proc,30);
78: --
79: -- Set the global variables so the values are
80: -- available for the next call to this function.
81: --

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

85: per_abb_bus.g_legislation_code := l_legislation_code;
86: end if;
87: --
88: end if;
89: hr_utility.set_location(' Leaving:'|| l_proc, 40);
90: return l_legislation_code;
91: end return_legislation_code;
92: --
93: -- ----------------------------------------------------------------------------

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

137: --
138: l_dummy number;
139: --
140: begin
141: hr_utility.set_location('Entering:'||l_proc,10);
142: --
143: -- Check mandatory parameters have been set
144: --
145: hr_api.mandatory_arg_error

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

178: end if;
179: --
180: end if;
181: --
182: hr_utility.set_location('Leaving:'||l_proc,10);
183: --
184: exception
185: when app_exception.application_exception then
186: if hr_multi_message.exception_add

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

186: if hr_multi_message.exception_add
187: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_EFFECTIVE'
188: ,p_associated_column2 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_END'
189: ) then
190: hr_utility.set_location(' Leaving:'||l_proc, 50);
191: raise;
192: end if;
193: hr_utility.set_location(' Leaving:'||l_proc,60);
194: end chk_absence_type_dates;

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

189: ) then
190: hr_utility.set_location(' Leaving:'||l_proc, 50);
191: raise;
192: end if;
193: hr_utility.set_location(' Leaving:'||l_proc,60);
194: end chk_absence_type_dates;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------------< chk_input_value_id >-----------------------|

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

283: or (pet.processing_type= 'R' and pet.proration_group_id is not null));
284: --
285: begin
286: --
287: hr_utility.set_location('Entering:'||l_proc,10);
288: --
289: if hr_multi_message.no_all_inclusive_error
290: (p_check_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_EFFECTIVE'
291: ,p_check_column2 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_END'

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

307: nvl(p_date_end,hr_api.g_eot)))
308: or not l_api_updating)
309: then
310: --
311: hr_utility.set_location(l_proc,20);
312: --
313: -- input value cannot be specified unless BG is specified
314: --
315: if p_business_group_id is null

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

317: fnd_message.set_name('PER','PER_449173_ABB_NO_BG_NO_INPUT');
318: fnd_message.raise_error;
319: end if;
320: --
321: hr_utility.set_location(l_proc,30);
322: --
323: -- input value cannot change once it is not null
324: --
325: if (p_input_value_id is not null

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

341: else
342: close csr_valid_input_value_bg;
343: end if;
344: --
345: hr_utility.set_location(l_proc,40);
346: --
347: open csr_input_end;
348: fetch csr_input_end into l_input_end;
349: close csr_input_end;

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

366: else
367: close csr_valid_input_value_dates;
368: end if;
369: --
370: hr_utility.set_location(l_proc,50);
371: --
372: open csr_valid_input_value_uom;
373: fetch csr_valid_input_value_uom into l_dummy;
374: if csr_valid_input_value_uom%notfound then

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

378: else
379: close csr_valid_input_value_uom;
380: end if;
381: --
382: hr_utility.set_location(l_proc,60);
383: --
384: open csr_valid_element_type;
385: fetch csr_valid_element_type into l_dummy;
386: if csr_valid_element_type%notfound then

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

390: else
391: close csr_valid_element_type;
392: end if;
393: --
394: hr_utility.set_location(l_proc,70);
395: --
396: end if; --input_value_id is not null
397: end if; --api_updating check
398: end if; --no_all_inclusive_error check

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

396: end if; --input_value_id is not null
397: end if; --api_updating check
398: end if; --no_all_inclusive_error check
399: --
400: hr_utility.set_location('Leaving:'||l_proc,80);
401: --
402: --set the OUT arguments
403: --
404: p_date_end := l_date_end;

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

409: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_EFFECTIVE'
410: ,p_associated_column2 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_END'
411: ,p_associated_column3 => 'PER_ABSENCE_ATTENDANCE_TYPES.INPUT_VALUE_ID'
412: ) then
413: hr_utility.set_location(' Leaving:'||l_proc, 90);
414: raise;
415: end if;
416: hr_utility.set_location(' Leaving:'||l_proc,100);
417: end chk_input_value_id;

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

412: ) then
413: hr_utility.set_location(' Leaving:'||l_proc, 90);
414: raise;
415: end if;
416: hr_utility.set_location(' Leaving:'||l_proc,100);
417: end chk_input_value_id;
418: --
419: --
420: -- ----------------------------------------------------------------------------

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

463:
464:
465: --
466: begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468:
469: open csr_abs_overlap_flag(p_absence_overlap_flag);
470: fetch csr_abs_overlap_flag into l_absence_overlap_flag;
471: if csr_abs_overlap_flag%notfound then

Line 474: hr_utility.set_message(800, 'HR_449758_INVL_ABS_OVERLAP_FLG');

470: fetch csr_abs_overlap_flag into l_absence_overlap_flag;
471: if csr_abs_overlap_flag%notfound then
472: close csr_abs_overlap_flag;
473:
474: hr_utility.set_message(800, 'HR_449758_INVL_ABS_OVERLAP_FLG');
475: hr_utility.set_message_token('OBJECT', 'ABSENCE_OVERLAP_FLAG');
476: hr_utility.set_message_token('TABLE', 'HR_LOOKUPS');
477: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
478:

Line 475: hr_utility.set_message_token('OBJECT', 'ABSENCE_OVERLAP_FLAG');

471: if csr_abs_overlap_flag%notfound then
472: close csr_abs_overlap_flag;
473:
474: hr_utility.set_message(800, 'HR_449758_INVL_ABS_OVERLAP_FLG');
475: hr_utility.set_message_token('OBJECT', 'ABSENCE_OVERLAP_FLAG');
476: hr_utility.set_message_token('TABLE', 'HR_LOOKUPS');
477: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
478:
479: hr_utility.set_location(l_proc, 10);

Line 476: hr_utility.set_message_token('TABLE', 'HR_LOOKUPS');

472: close csr_abs_overlap_flag;
473:
474: hr_utility.set_message(800, 'HR_449758_INVL_ABS_OVERLAP_FLG');
475: hr_utility.set_message_token('OBJECT', 'ABSENCE_OVERLAP_FLAG');
476: hr_utility.set_message_token('TABLE', 'HR_LOOKUPS');
477: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
478:
479: hr_utility.set_location(l_proc, 10);
480: --

Line 477: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');

473:
474: hr_utility.set_message(800, 'HR_449758_INVL_ABS_OVERLAP_FLG');
475: hr_utility.set_message_token('OBJECT', 'ABSENCE_OVERLAP_FLAG');
476: hr_utility.set_message_token('TABLE', 'HR_LOOKUPS');
477: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
478:
479: hr_utility.set_location(l_proc, 10);
480: --
481: else

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

475: hr_utility.set_message_token('OBJECT', 'ABSENCE_OVERLAP_FLAG');
476: hr_utility.set_message_token('TABLE', 'HR_LOOKUPS');
477: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
478:
479: hr_utility.set_location(l_proc, 10);
480: --
481: else
482: close csr_abs_overlap_flag;
483: end if;

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

480: --
481: else
482: close csr_abs_overlap_flag;
483: end if;
484: hr_utility.set_location(l_proc, 20);
485:
486: exception
487: when app_exception.application_exception then
488: if hr_multi_message.exception_add

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

487: when app_exception.application_exception then
488: if hr_multi_message.exception_add
489: (p_same_associated_columns => 'Y'
490: ) then
491: hr_utility.set_location('Leaving:'||l_proc, 50);
492: raise;
493: end if;
494: hr_utility.set_location('Leaving:'||l_proc,60);
495: end chk_abs_overlap_flag;

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

490: ) then
491: hr_utility.set_location('Leaving:'||l_proc, 50);
492: raise;
493: end if;
494: hr_utility.set_location('Leaving:'||l_proc,60);
495: end chk_abs_overlap_flag;
496: --
497: -- ----------------------------------------------------------------------------
498: -- |-----------------------------< chk_inc_or_dec_flag >----------------------|

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

534: l_api_updating boolean;
535: --
536: begin
537: --
538: hr_utility.set_location('Entering:'||l_proc,10);
539: --
540: l_api_updating := per_abb_shd.api_updating
541: (p_absence_attendance_type_id => p_absence_attendance_type_id
542: ,p_object_version_number => p_object_version_number);

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

558: fnd_message.set_name('PER','PER_449183_ABB_NO_INPUT_NO_INC');
559: fnd_message.raise_error;
560: end if;
561: --
562: hr_utility.set_location(l_proc,20);
563: --
564: else
565: -- input_value_id is not null so inc_or_dec_flag must be specified
566: --

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

568: fnd_message.set_name('PER','HR_7583_ALL_MAN_INC_FIELD');
569: fnd_message.raise_error;
570: end if;
571: --
572: hr_utility.set_location(l_proc,30);
573: --
574: if l_api_updating
575: and per_abb_shd.g_old_rec.increasing_or_decreasing_flag is not null
576: and nvl(p_inc_or_dec_flag,hr_api.g_varchar2) <>

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

582: fnd_message.raise_error;
583: end if;
584: end if;
585: end if;
586: hr_utility.set_location('Leaving:'||l_proc,70);
587: --
588: exception
589: when app_exception.application_exception then
590: if hr_multi_message.exception_add

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

589: when app_exception.application_exception then
590: if hr_multi_message.exception_add
591: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.INCREASING_OR_DECREASING_FLAG'
592: ) then
593: hr_utility.set_location(' Leaving:'||l_proc, 80);
594: raise;
595: end if;
596: hr_utility.set_location(' Leaving:'||l_proc,90);
597: end chk_inc_or_dec_flag;

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

592: ) then
593: hr_utility.set_location(' Leaving:'||l_proc, 80);
594: raise;
595: end if;
596: hr_utility.set_location(' Leaving:'||l_proc,90);
597: end chk_inc_or_dec_flag;
598: --
599: -- ----------------------------------------------------------------------------
600: -- |-----------------------------< chk_hours_or_days >------------------------|

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

638: l_input_uom pay_input_values_f.uom%type;
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'||l_proc,10);
643: --
644: if hr_multi_message.no_all_inclusive_error
645: (p_check_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.INPUT_VALUE_ID'
646: ) then

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

668: fnd_message.raise_error;
669: end if;
670: --
671: else -- input_value_id is not null
672: hr_utility.set_location(l_proc,20);
673: --
674: if l_api_updating
675: and per_abb_shd.g_old_rec.hours_or_days is not null
676: and nvl(p_hours_or_days,hr_api.g_varchar2) <>

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

681: fnd_message.set_name('PER','PER_449179_ABB_NO_CHANGE_HOURS');
682: fnd_message.raise_error;
683: end if;
684: --
685: hr_utility.set_location(l_proc,30);
686: --
687: -- flag must have the correct value (uom of input value is already validated)
688: --
689: if p_hours_or_days is null

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

694: end if; --input_value_id is null check
695: --
696: end if; --api updating check
697: end if; --no_all_inclusive_error
698: hr_utility.set_location('Leaving:'||l_proc,70);
699: --
700: exception
701: when app_exception.application_exception then
702: if hr_multi_message.exception_add

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

701: when app_exception.application_exception then
702: if hr_multi_message.exception_add
703: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.HOURS_OR_DAYS'
704: ) then
705: hr_utility.set_location(' Leaving:'||l_proc, 80);
706: raise;
707: end if;
708: hr_utility.set_location(' Leaving:'||l_proc,90);
709: --

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

704: ) then
705: hr_utility.set_location(' Leaving:'||l_proc, 80);
706: raise;
707: end if;
708: hr_utility.set_location(' Leaving:'||l_proc,90);
709: --
710: end chk_hours_or_days;
711: --
712: -- ----------------------------------------------------------------------------

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

756: l_dummy number;
757: --
758: begin
759: --
760: hr_utility.set_location('Entering:'||l_proc,10);
761: --
762: l_api_updating := per_abb_shd.api_updating
763: (p_absence_attendance_type_id => p_absence_attendance_type_id
764: ,p_object_version_number => p_object_version_number);

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

772: (nvl(per_abb_shd.g_old_rec.absence_category,hr_api.g_varchar2) <> nvl(p_absence_category,hr_api.g_varchar2))
773: or not l_api_updating)
774: then
775: --
776: hr_utility.set_location(l_proc,20);
777: --
778: if p_absence_category is not null
779: and hr_api.not_exists_in_leg_lookups
780: (p_effective_date => p_date_effective

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

786: fnd_message.set_name('PER','PER_449185_ABB_CAT_NOT_EXIST');
787: fnd_message.raise_error;
788: end if;
789: --
790: hr_utility.set_location(l_proc,30);
791: --
792: if l_api_updating then
793: open csr_absence_attendance;
794: fetch csr_absence_attendance into l_dummy;

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

801: close csr_absence_attendance;
802: fnd_message.set_name('PER','HR_6383_ABS_DET_NO_CHANGE');
803: fnd_message.raise_error;
804: else
805: hr_utility.set_location(l_proc,40);
806: --
807: close csr_absence_attendance;
808: end if;
809: --

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

809: --
810: end if;
811: end if;
812: --
813: hr_utility.set_location('Leaving:'||l_proc,70);
814: --
815: exception
816: when app_exception.application_exception then
817: if hr_multi_message.exception_add

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

816: when app_exception.application_exception then
817: if hr_multi_message.exception_add
818: (p_associated_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.ABSENCE_CATEGORY'
819: ) then
820: hr_utility.set_location(' Leaving:'||l_proc, 80);
821: raise;
822: end if;
823: hr_utility.set_location(' Leaving:'||l_proc,90);
824: --

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

819: ) then
820: hr_utility.set_location(' Leaving:'||l_proc, 80);
821: raise;
822: end if;
823: hr_utility.set_location(' Leaving:'||l_proc,90);
824: --
825: end chk_absence_category;
826: --
827: -- ----------------------------------------------------------------------------

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

881: and fdfc.descriptive_flex_context_code = p_legislation_code;
882: --
883: begin
884: --
885: hr_utility.set_location('Entering:'||l_proc,10);
886: --
887: l_api_updating := per_abb_shd.api_updating
888: (p_absence_attendance_type_id => p_absence_attendance_type_id
889: ,p_object_version_number => p_object_version_number);

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

897: (nvl(per_abb_shd.g_old_rec.information_category,hr_api.g_varchar2) <> nvl(p_information_category,hr_api.g_varchar2))
898: or not l_api_updating)
899: then
900: --
901: hr_utility.set_location(l_proc,10);
902: --
903: if p_information_category is not null then
904: if p_business_group_id is null then
905: fnd_message.set_name('PER','PER_449181_ABB_INFO_CAT_BG');

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

905: fnd_message.set_name('PER','PER_449181_ABB_INFO_CAT_BG');
906: fnd_message.raise_error;
907: else
908: --
909: hr_utility.set_location(l_proc,20);
910: --
911: open csr_bg_legislation;
912: fetch csr_bg_legislation into l_leg;
913: close csr_bg_legislation;

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

920: end if;
921: else
922: if p_business_group_id is not null then
923: --
924: hr_utility.set_location(l_proc,30);
925: --
926: open csr_bg_legislation;
927: fetch csr_bg_legislation into l_leg;
928: close csr_bg_legislation;

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

931: fetch csr_ddf_exist into l_dummy;
932: if csr_ddf_exist%found then
933: close csr_ddf_exist;
934: --
935: hr_utility.set_location(l_proc,40);
936: --
937: p_information_category := l_leg;
938: else
939: close csr_ddf_exist;

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

937: p_information_category := l_leg;
938: else
939: close csr_ddf_exist;
940: --
941: hr_utility.set_location(l_proc,50);
942: --
943: p_information_category := null;
944: end if;
945: else

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

943: p_information_category := null;
944: end if;
945: else
946: --
947: hr_utility.set_location(l_proc,60);
948: --
949: p_information_category := null;
950: end if;
951: --

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

952: end if; -- p_information_category is not null
953: --
954: end if; --api updating
955: --
956: hr_utility.set_location('Leaving:'||l_proc,70);
957: --
958: end chk_information_category;
959: --
960: -- ----------------------------------------------------------------------------

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

999: where absence_attendance_type_id = p_absence_attendance_type_id;
1000: --
1001: begin
1002: --
1003: hr_utility.set_location('Entering:'||l_proc,10);
1004: --
1005: open csr_attendance;
1006: fetch csr_attendance into l_dummy;
1007: if csr_attendance%found then

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

1011: else
1012: close csr_attendance;
1013: end if;
1014: --
1015: hr_utility.set_location(l_proc,20);
1016: --
1017: open csr_reason;
1018: fetch csr_reason into l_dummy;
1019: if csr_reason%found then

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

1023: else
1024: close csr_reason;
1025: end if;
1026: --
1027: hr_utility.set_location('Leaving:'||l_proc,30);
1028: --
1029: end chk_absence_type_delete;
1030: --
1031: -- ----------------------------------------------------------------------------

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

1062: --
1063: l_proc varchar2(72) := g_package || 'chk_ddf';
1064: --
1065: begin
1066: hr_utility.set_location('Entering:'||l_proc,10);
1067: --
1068: if ((p_rec.absence_attendance_type_id is not null) and (
1069: nvl(per_abb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1070: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

1161: ,p_attribute20_value => p_rec.information20
1162: );
1163: end if;
1164: --
1165: hr_utility.set_location(' Leaving:'||l_proc,20);
1166: end chk_ddf;
1167: --
1168: -- ----------------------------------------------------------------------------
1169: -- |------------------------------< chk_df >----------------------------------|

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

1199: --
1200: l_proc varchar2(72) := g_package || 'chk_df';
1201: --
1202: begin
1203: hr_utility.set_location('Entering:'||l_proc,10);
1204: --
1205: if ((p_rec.absence_attendance_type_id is not null) and (
1206: nvl(per_abb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1298: ,p_attribute20_value => p_rec.attribute20
1299: );
1300: end if;
1301: --
1302: hr_utility.set_location(' Leaving:'||l_proc,20);
1303: end chk_df;
1304: --
1305: -- ----------------------------------------------------------------------------
1306: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1337: l_error exception;
1338: l_argument varchar2(30);
1339: --
1340: Begin
1341: hr_utility.set_location('Entering:'||l_proc, 5);
1342: --
1343: -- Only proceed with the validation if a row exists for the current
1344: -- record in the HR Schema.
1345: --

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

1352: fnd_message.set_token('STEP ', '5');
1353: fnd_message.raise_error;
1354: END IF;
1355: --
1356: hr_utility.set_location(l_proc, 10);
1357: --
1358: if nvl(per_abb_shd.g_old_rec.business_group_id,-1) <>
1359: nvl(p_rec.business_group_id,-1) then
1360: l_argument := 'business_group_id';

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

1360: l_argument := 'business_group_id';
1361: raise l_error;
1362: end if;
1363: --
1364: hr_utility.set_location(l_proc, 20);
1365: --
1366: if nvl(per_abb_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
1367: nvl(p_rec.information_category,hr_api.g_varchar2) then
1368: l_argument := 'information_category';

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

1369: raise l_error;
1370: end if;
1371: --
1372: --
1373: hr_utility.set_location(l_proc, 30);
1374: --
1375: if per_abb_shd.g_old_rec.absence_attendance_type_id <>
1376: p_rec.absence_attendance_type_id then
1377: l_argument := 'absence_attendance_type_id';

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

1377: l_argument := 'absence_attendance_type_id';
1378: raise l_error;
1379: end if;
1380: --
1381: hr_utility.set_location(' Leaving:'||l_proc, 40);
1382: --
1383: exception
1384: when l_error then
1385: hr_api.argument_changed_error

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

1386: (p_api_name => l_proc
1387: ,p_argument => l_argument);
1388: when others then
1389: raise;
1390: hr_utility.set_location(' Leaving:'||l_proc, 90);
1391: End chk_non_updateable_args;
1392: --
1393: -- ----------------------------------------------------------------------------
1394: -- |---------------------------< insert_validate >----------------------------|

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

1399: --
1400: l_proc varchar2(72) := g_package||'insert_validate';
1401: --
1402: Begin
1403: hr_utility.set_location('Entering:'||l_proc, 5);
1404: --
1405: -- Call all supporting business operations
1406: --
1407: if p_rec.business_group_id is not null then

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

1470: per_abb_bus.chk_ddf(p_rec);
1471: --
1472: per_abb_bus.chk_df(p_rec);
1473: --
1474: hr_utility.set_location(' Leaving:'||l_proc, 10);
1475: End insert_validate;
1476: --
1477: -- ----------------------------------------------------------------------------
1478: -- |---------------------------< update_validate >----------------------------|

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

1483: --
1484: l_proc varchar2(72) := g_package||'update_validate';
1485: --
1486: Begin
1487: hr_utility.set_location('Entering:'||l_proc, 5);
1488: --
1489: -- Call all supporting business operations
1490: --
1491: if p_rec.business_group_id is not null then

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

1554: per_abb_bus.chk_ddf(p_rec);
1555: --
1556: per_abb_bus.chk_df(p_rec);
1557: --
1558: hr_utility.set_location(' Leaving:'||l_proc, 10);
1559: End update_validate;
1560: --
1561: -- ----------------------------------------------------------------------------
1562: -- |---------------------------< delete_validate >----------------------------|

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

1567: --
1568: l_proc varchar2(72) := g_package||'delete_validate';
1569: --
1570: Begin
1571: hr_utility.set_location('Entering:'||l_proc, 5);
1572: --
1573: -- Call all supporting business operations
1574: --
1575: per_abb_bus.chk_absence_type_delete

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

1575: per_abb_bus.chk_absence_type_delete
1576: (p_absence_attendance_type_id => p_rec.absence_attendance_type_id
1577: );
1578: --
1579: hr_utility.set_location(' Leaving:'||l_proc, 10);
1580: End delete_validate;
1581: --
1582: end per_abb_bus;