DBA Data[Home] [Help]

APPS.HXC_TER_BUS dependencies on HR_UTILITY

Line 16: g_debug boolean := hr_utility.debug_enabled;

12: --
13: g_legislation_code varchar2(150) default null;
14: g_time_entry_rule_id number default null;
15:
16: g_debug boolean := hr_utility.debug_enabled;
17: --
18: --
19: -- ----------------------------------------------------------------------------
20: -- |------------------------------< chk_df >----------------------------------|

Line 54: g_debug := hr_utility.debug_enabled;

50: --
51: l_proc varchar2(72);
52: --
53: begin
54: g_debug := hr_utility.debug_enabled;
55:
56: if g_debug then
57: l_proc := g_package || 'chk_df';
58: hr_utility.set_location('Entering:'||l_proc,10);

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

54: g_debug := hr_utility.debug_enabled;
55:
56: if g_debug then
57: l_proc := g_package || 'chk_df';
58: hr_utility.set_location('Entering:'||l_proc,10);
59: end if;
60: --
61: if ((p_rec.time_entry_rule_id is not null) and (
62: nvl(hxc_ter_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

195: );
196: end if;
197: --
198: if g_debug then
199: hr_utility.set_location(' Leaving:'||l_proc,20);
200: end if;
201: end chk_df;
202: --
203: -- ----------------------------------------------------------------------------

Line 346: g_debug := hr_utility.debug_enabled;

342: --
343: l_dup_name varchar2(5) := NULL;
344: --
345: BEGIN
346: g_debug := hr_utility.debug_enabled;
347:
348: if g_debug then
349: l_proc := g_package||'chk_name';
350: hr_utility.set_location('Entering:'||l_proc, 5);

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

346: g_debug := hr_utility.debug_enabled;
347:
348: if g_debug then
349: l_proc := g_package||'chk_name';
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: end if;
352: --
353: -- check that the name has been entered
354: --

Line 358: hr_utility.set_message(809, 'HXC_0037_DAR_NAME_MAND');

354: --
355: IF p_name IS NULL
356: THEN
357: --
358: hr_utility.set_message(809, 'HXC_0037_DAR_NAME_MAND');
359: hr_utility.raise_error;
360: --
361: END IF;
362: if g_debug then

Line 359: hr_utility.raise_error;

355: IF p_name IS NULL
356: THEN
357: --
358: hr_utility.set_message(809, 'HXC_0037_DAR_NAME_MAND');
359: hr_utility.raise_error;
360: --
361: END IF;
362: if g_debug then
363: hr_utility.set_location('Processing:'||l_proc, 10);

Line 363: hr_utility.set_location('Processing:'||l_proc, 10);

359: hr_utility.raise_error;
360: --
361: END IF;
362: if g_debug then
363: hr_utility.set_location('Processing:'||l_proc, 10);
364: end if;
365: --
366: -- check that the name is unique within the date range
367: --

Line 375: hr_utility.set_message(809, 'HXC_0038_DAR_DUP_NAME');

371: --
372: IF l_dup_name IS NOT NULL
373: THEN
374: --
375: hr_utility.set_message(809, 'HXC_0038_DAR_DUP_NAME');
376: hr_utility.raise_error;
377: --
378: END IF;
379: --

Line 376: hr_utility.raise_error;

372: IF l_dup_name IS NOT NULL
373: THEN
374: --
375: hr_utility.set_message(809, 'HXC_0038_DAR_DUP_NAME');
376: hr_utility.raise_error;
377: --
378: END IF;
379: --
380: if g_debug then

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

377: --
378: END IF;
379: --
380: if g_debug then
381: hr_utility.set_location('Leaving:'||l_proc, 20);
382: end if;
383: END chk_name;
384: --
385: --

Line 424: g_debug := hr_utility.debug_enabled;

420: --
421: l_valid_usage VARCHAR2(5) := NULL;
422: --
423: BEGIN
424: g_debug := hr_utility.debug_enabled;
425:
426: if g_debug then
427: l_proc := g_package||'chk_rule_usage';
428: hr_utility.set_location('Entering:'||l_proc, 5);

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

424: g_debug := hr_utility.debug_enabled;
425:
426: if g_debug then
427: l_proc := g_package||'chk_rule_usage';
428: hr_utility.set_location('Entering:'||l_proc, 5);
429: end if;
430: --
431: -- check that usage_name has been entered
432: --

Line 436: hr_utility.set_message(809, 'HXC_0039_DAR_USAGE_MAND');

432: --
433: IF p_rule_usage IS NULL
434: THEN
435: --
436: hr_utility.set_message(809, 'HXC_0039_DAR_USAGE_MAND');
437: hr_utility.raise_error;
438: --
439: END IF;
440: if g_debug then

Line 437: hr_utility.raise_error;

433: IF p_rule_usage IS NULL
434: THEN
435: --
436: hr_utility.set_message(809, 'HXC_0039_DAR_USAGE_MAND');
437: hr_utility.raise_error;
438: --
439: END IF;
440: if g_debug then
441: hr_utility.set_location('In:'||l_proc, 10);

Line 441: hr_utility.set_location('In:'||l_proc, 10);

437: hr_utility.raise_error;
438: --
439: END IF;
440: if g_debug then
441: hr_utility.set_location('In:'||l_proc, 10);
442: end if;
443: --
444: -- check if the rule_usage name exists in HR_LOOKUPS
445: --

Line 451: hr_utility.set_location('Processing:'||l_proc, 20);

447: FETCH csr_chk_rule_usage INTO l_valid_usage;
448: CLOSE csr_chk_rule_usage;
449: --
450: if g_debug then
451: hr_utility.set_location('Processing:'||l_proc, 20);
452: end if;
453: --
454: IF l_valid_usage IS NULL
455: THEN

Line 457: hr_utility.set_message(809, 'HXC_0040_DAR_USAGE_INVLD');

453: --
454: IF l_valid_usage IS NULL
455: THEN
456: --
457: hr_utility.set_message(809, 'HXC_0040_DAR_USAGE_INVLD');
458: hr_utility.raise_error;
459: --
460: END IF;
461: --

Line 458: hr_utility.raise_error;

454: IF l_valid_usage IS NULL
455: THEN
456: --
457: hr_utility.set_message(809, 'HXC_0040_DAR_USAGE_INVLD');
458: hr_utility.raise_error;
459: --
460: END IF;
461: --
462: if g_debug then

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

459: --
460: END IF;
461: --
462: if g_debug then
463: hr_utility.set_location('Leaving:'||l_proc, 30);
464: end if;
465: END chk_rule_usage;
466: --
467: -- ----------------------------------------------------------------------------

Line 520: hr_utility.set_message(809, 'HXC_0041_DAR_MAPPING_INVLD');

516: --
517: IF l_mapping_ok IS NULL
518: THEN
519: --
520: hr_utility.set_message(809, 'HXC_0041_DAR_MAPPING_INVLD');
521: hr_utility.raise_error;
522: --
523: END IF;
524: --

Line 521: hr_utility.raise_error;

517: IF l_mapping_ok IS NULL
518: THEN
519: --
520: hr_utility.set_message(809, 'HXC_0041_DAR_MAPPING_INVLD');
521: hr_utility.raise_error;
522: --
523: END IF;
524: --
525: END IF;

Line 588: hr_utility.set_message(809, 'HXC_0042_DAR_FF_DATE_INVLD');

584: --
585: IF l_formula_ok IS NULL
586: THEN
587: --
588: hr_utility.set_message(809, 'HXC_0042_DAR_FF_DATE_INVLD');
589: hr_utility.raise_error;
590: --
591: END IF;
592: --

Line 589: hr_utility.raise_error;

585: IF l_formula_ok IS NULL
586: THEN
587: --
588: hr_utility.set_message(809, 'HXC_0042_DAR_FF_DATE_INVLD');
589: hr_utility.raise_error;
590: --
591: END IF;
592: --
593: END IF;

Line 634: hr_utility.set_message(809, 'HXC_0043_DAR_MAP_OR_FF_MAND');

630:
631: IF ( p_formula_id IS NULL AND p_mapping_id IS NULL )
632: THEN
633:
634: hr_utility.set_message(809, 'HXC_0043_DAR_MAP_OR_FF_MAND');
635: hr_utility.raise_error;
636:
637: END IF;
638:

Line 635: hr_utility.raise_error;

631: IF ( p_formula_id IS NULL AND p_mapping_id IS NULL )
632: THEN
633:
634: hr_utility.set_message(809, 'HXC_0043_DAR_MAP_OR_FF_MAND');
635: hr_utility.raise_error;
636:
637: END IF;
638:
639: END chk_formula_mapping;

Line 684: g_debug := hr_utility.debug_enabled;

680: --
681: l_bad_start_date varchar2(5) := NULL;
682: --
683: BEGIN
684: g_debug := hr_utility.debug_enabled;
685:
686: if g_debug then
687: l_proc := g_package||'chk_start_date';
688: hr_utility.set_location('Entering:'||l_proc, 5);

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

684: g_debug := hr_utility.debug_enabled;
685:
686: if g_debug then
687: l_proc := g_package||'chk_start_date';
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: end if;
690: --
691: -- check that date from has been entered
692: --

Line 696: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');

692: --
693: IF p_start_date IS NULL
694: THEN
695: --
696: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');
697: hr_utility.raise_error;
698: --
699: END IF;
700: --

Line 697: hr_utility.raise_error;

693: IF p_start_date IS NULL
694: THEN
695: --
696: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');
697: hr_utility.raise_error;
698: --
699: END IF;
700: --
701: if g_debug then

Line 702: hr_utility.set_location('Processing: '||l_proc, 10);

698: --
699: END IF;
700: --
701: if g_debug then
702: hr_utility.set_location('Processing: '||l_proc, 10);
703: end if;
704: --
705: -- check that date from is not greater than end_date
706: --

Line 710: hr_utility.set_message(809, 'HXC_0057_DAR_FROM_MORE_THAN_TO');

706: --
707: IF p_start_date > NVL(p_end_date, HR_GENERAL.END_OF_TIME )
708: THEN
709: --
710: hr_utility.set_message(809, 'HXC_0057_DAR_FROM_MORE_THAN_TO');
711: hr_utility.raise_error;
712: --
713: END IF;
714: --

Line 711: hr_utility.raise_error;

707: IF p_start_date > NVL(p_end_date, HR_GENERAL.END_OF_TIME )
708: THEN
709: --
710: hr_utility.set_message(809, 'HXC_0057_DAR_FROM_MORE_THAN_TO');
711: hr_utility.raise_error;
712: --
713: END IF;
714: --
715: if g_debug then

Line 716: hr_utility.set_location('Processing: '||l_proc, 20);

712: --
713: END IF;
714: --
715: if g_debug then
716: hr_utility.set_location('Processing: '||l_proc, 20);
717: end if;
718: --
719: -- check that this start date does not overlap with rule of the same name
720: --

Line 726: hr_utility.set_location('Processing: '||l_proc, 30);

722: FETCH csr_chk_start_date INTO l_bad_start_date;
723: CLOSE csr_chk_start_date;
724: --
725: if g_debug then
726: hr_utility.set_location('Processing: '||l_proc, 30);
727: end if;
728: --
729: IF l_bad_start_date IS NOT NULL
730: THEN

Line 732: hr_utility.set_message(809, 'HXC_0058_DAR_FROM_OVERLAPS');

728: --
729: IF l_bad_start_date IS NOT NULL
730: THEN
731: --
732: hr_utility.set_message(809, 'HXC_0058_DAR_FROM_OVERLAPS');
733: hr_utility.raise_error;
734: --
735: END IF;
736: --

Line 733: hr_utility.raise_error;

729: IF l_bad_start_date IS NOT NULL
730: THEN
731: --
732: hr_utility.set_message(809, 'HXC_0058_DAR_FROM_OVERLAPS');
733: hr_utility.raise_error;
734: --
735: END IF;
736: --
737: if g_debug then

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

734: --
735: END IF;
736: --
737: if g_debug then
738: hr_utility.set_location('Leaving: '||l_proc, 40);
739: end if;
740: --
741: END chk_start_date;
742: --

Line 786: g_debug := hr_utility.debug_enabled;

782: --
783: l_bad_end_date varchar2(5) := NULL;
784: --
785: BEGIN
786: g_debug := hr_utility.debug_enabled;
787:
788: if g_debug then
789: l_proc := g_package||'chk_end_date';
790: hr_utility.set_location('Entering:'||l_proc, 5);

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

786: g_debug := hr_utility.debug_enabled;
787:
788: if g_debug then
789: l_proc := g_package||'chk_end_date';
790: hr_utility.set_location('Entering:'||l_proc, 5);
791: end if;
792: --
793: -- check that date to is not less than date from
794: --

Line 798: hr_utility.set_message(809, 'HXC_0059_DAR_TO_LESS_THAN_FROM');

794: --
795: IF NVL(p_end_date, HR_GENERAL.END_OF_TIME ) < p_start_date
796: THEN
797: --
798: hr_utility.set_message(809, 'HXC_0059_DAR_TO_LESS_THAN_FROM');
799: hr_utility.raise_error;
800: --
801: END IF;
802: --

Line 799: hr_utility.raise_error;

795: IF NVL(p_end_date, HR_GENERAL.END_OF_TIME ) < p_start_date
796: THEN
797: --
798: hr_utility.set_message(809, 'HXC_0059_DAR_TO_LESS_THAN_FROM');
799: hr_utility.raise_error;
800: --
801: END IF;
802: --
803: if g_debug then

Line 804: hr_utility.set_location('Processing: '||l_proc, 10);

800: --
801: END IF;
802: --
803: if g_debug then
804: hr_utility.set_location('Processing: '||l_proc, 10);
805: end if;
806: --
807: -- check that this end date does not overlap with rule of the same name
808: --

Line 814: hr_utility.set_location('Processing: '||l_proc, 20);

810: FETCH csr_chk_end_date INTO l_bad_end_date;
811: CLOSE csr_chk_end_date;
812: --
813: if g_debug then
814: hr_utility.set_location('Processing: '||l_proc, 20);
815: end if;
816: --
817: IF l_bad_end_date IS NOT NULL
818: THEN

Line 820: hr_utility.set_message(809, 'HXC_0060_DAR_TO_OVERLAPS');

816: --
817: IF l_bad_end_date IS NOT NULL
818: THEN
819: --
820: hr_utility.set_message(809, 'HXC_0060_DAR_TO_OVERLAPS');
821: hr_utility.raise_error;
822: --
823: END IF;
824: --

Line 821: hr_utility.raise_error;

817: IF l_bad_end_date IS NOT NULL
818: THEN
819: --
820: hr_utility.set_message(809, 'HXC_0060_DAR_TO_OVERLAPS');
821: hr_utility.raise_error;
822: --
823: END IF;
824: --
825: if g_debug then

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

822: --
823: END IF;
824: --
825: if g_debug then
826: hr_utility.set_location('Leaving: '||l_proc, 30);
827: end if;
828: --
829: END chk_end_date;
830: --

Line 875: g_debug := hr_utility.debug_enabled;

871:
872: l_exists VARCHAR2(6) := NULL;
873:
874: BEGIN
875: g_debug := hr_utility.debug_enabled;
876:
877: if g_debug then
878: l_proc := g_package||'chk_delete';
879: hr_utility.set_location('Entering:'||l_proc, 5);

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

875: g_debug := hr_utility.debug_enabled;
876:
877: if g_debug then
878: l_proc := g_package||'chk_delete';
879: hr_utility.set_location('Entering:'||l_proc, 5);
880: end if;
881:
882: -- check that approval rule is not being used in any
883: -- Time Entry Rule or ELP Entry Rule Group

Line 890: hr_utility.set_location('Processing: '||l_proc, 10);

886: FETCH csr_chk_teru INTO l_exists;
887: CLOSE csr_chk_teru;
888:
889: if g_debug then
890: hr_utility.set_location('Processing: '||l_proc, 10);
891: end if;
892:
893: IF l_exists IS NOT NULL
894: THEN

Line 896: hr_utility.set_message(809, 'HXC_0061_DAR_RULE_IN_USE');

892:
893: IF l_exists IS NOT NULL
894: THEN
895:
896: hr_utility.set_message(809, 'HXC_0061_DAR_RULE_IN_USE');
897: hr_utility.raise_error;
898:
899: END IF;
900:

Line 897: hr_utility.raise_error;

893: IF l_exists IS NOT NULL
894: THEN
895:
896: hr_utility.set_message(809, 'HXC_0061_DAR_RULE_IN_USE');
897: hr_utility.raise_error;
898:
899: END IF;
900:
901: -- check that the time entry rule is not being used in

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

905: FETCH csr_chk_daru INTO l_exists;
906: CLOSE csr_chk_daru;
907:
908: if g_debug then
909: hr_utility.set_location('Processing: '||l_proc, 20);
910: end if;
911:
912: IF l_exists IS NOT NULL
913: THEN

Line 915: hr_utility.set_message(809, 'HXC_TER_REF_APPROVAL');

911:
912: IF l_exists IS NOT NULL
913: THEN
914:
915: hr_utility.set_message(809, 'HXC_TER_REF_APPROVAL');
916: hr_utility.raise_error;
917:
918: END IF;
919:

Line 916: hr_utility.raise_error;

912: IF l_exists IS NOT NULL
913: THEN
914:
915: hr_utility.set_message(809, 'HXC_TER_REF_APPROVAL');
916: hr_utility.raise_error;
917:
918: END IF;
919:
920:

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

919:
920:
921:
922: if g_debug then
923: hr_utility.set_location('Leaving: '||l_proc, 30);
924: end if;
925:
926: END chk_delete;
927: --

Line 978: g_debug := hr_utility.debug_enabled;

974:
975: --
976: --
977: begin
978: g_debug := hr_utility.debug_enabled;
979:
980: if g_debug then
981: l_proc := g_package||'chk_legislation_code';
982: hr_utility.set_location('Entering: '||l_proc,5);

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

978: g_debug := hr_utility.debug_enabled;
979:
980: if g_debug then
981: l_proc := g_package||'chk_legislation_code';
982: hr_utility.set_location('Entering: '||l_proc,5);
983: end if;
984: --------------------------------
985: -- Check legislation code is valid --
986: --------------------------------

Line 993: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');

989: open csr_valid_legislation_code;
990: fetch csr_valid_legislation_code into l_territory_code;
991: if csr_valid_legislation_code%notfound then
992: close csr_valid_legislation_code;
993: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
994: hr_utility.raise_error;
995: end if; -- End cursor if
996: close csr_valid_legislation_code;
997:

Line 994: hr_utility.raise_error;

990: fetch csr_valid_legislation_code into l_territory_code;
991: if csr_valid_legislation_code%notfound then
992: close csr_valid_legislation_code;
993: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
994: hr_utility.raise_error;
995: end if; -- End cursor if
996: close csr_valid_legislation_code;
997:
998: if p_business_group_id is not null then

Line 1003: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');

999: open csr_valid_bg_lc;
1000: fetch csr_valid_bg_lc into l_lc;
1001: if csr_valid_bg_lc%notfound then
1002: close csr_valid_bg_lc;
1003: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
1004: hr_utility.raise_error;
1005: end if; -- End cursor if
1006: close csr_valid_bg_lc;
1007: end if;

Line 1004: hr_utility.raise_error;

1000: fetch csr_valid_bg_lc into l_lc;
1001: if csr_valid_bg_lc%notfound then
1002: close csr_valid_bg_lc;
1003: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
1004: hr_utility.raise_error;
1005: end if; -- End cursor if
1006: close csr_valid_bg_lc;
1007: end if;
1008:

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

1008:
1009: end if; -- end check
1010:
1011: if g_debug then
1012: hr_utility.set_location('Leaving: '||l_proc,10);
1013: end if;
1014: end chk_legislation_code;
1015: --
1016: -- ----------------------------------------------------------------------------

Line 1027: g_debug := hr_utility.debug_enabled;

1023: --
1024: l_proc varchar2(72);
1025: --
1026: Begin
1027: g_debug := hr_utility.debug_enabled;
1028:
1029: if g_debug then
1030: l_proc := g_package||' insert_validate';
1031: hr_utility.set_location('Entering:'||l_proc, 5);

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

1027: g_debug := hr_utility.debug_enabled;
1028:
1029: if g_debug then
1030: l_proc := g_package||' insert_validate';
1031: hr_utility.set_location('Entering:'||l_proc, 5);
1032: end if;
1033: --
1034: -- Call all supporting business operations
1035: --

Line 1046: hr_utility.set_location(' Processing: '||l_proc, 10);

1042: ,p_bg_id => p_rec.business_group_id
1043: );
1044: --
1045: if g_debug then
1046: hr_utility.set_location(' Processing: '||l_proc, 10);
1047: end if;
1048: --
1049: chk_rule_usage
1050: (

Line 1055: hr_utility.set_location(' Processing: '||l_proc, 30);

1051: p_rule_usage => p_rec.rule_usage
1052: );
1053: --
1054: if g_debug then
1055: hr_utility.set_location(' Processing: '||l_proc, 30);
1056: end if;
1057: --
1058: chk_mapping_id
1059: (

Line 1064: hr_utility.set_location(' Processing: '||l_proc, 40);

1060: p_mapping_id => p_rec.mapping_id
1061: );
1062: --
1063: if g_debug then
1064: hr_utility.set_location(' Processing: '||l_proc, 40);
1065: end if;
1066: --
1067: chk_formula_id
1068: (

Line 1074: hr_utility.set_location(' Processing: '||l_proc, 50);

1070: ,p_start_date => p_rec.start_date
1071: ,p_end_date => p_rec.end_date );
1072: --
1073: if g_debug then
1074: hr_utility.set_location(' Processing: '||l_proc, 50);
1075: end if;
1076: --
1077: chk_formula_mapping
1078: (

Line 1083: hr_utility.set_location(' Processing: '||l_proc, 50);

1079: p_formula_id => p_rec.formula_id
1080: , p_mapping_id => p_rec.mapping_id );
1081: --
1082: if g_debug then
1083: hr_utility.set_location(' Processing: '||l_proc, 50);
1084: end if;
1085: chk_start_date
1086: (
1087: p_name => p_rec.name

Line 1096: hr_utility.set_location(' Processing: '||l_proc, 50);

1092: ,p_bg_id => p_rec.business_group_id
1093: );
1094: --
1095: if g_debug then
1096: hr_utility.set_location(' Processing: '||l_proc, 50);
1097: end if;
1098: chk_end_date
1099: (
1100: p_name => p_rec.name

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

1115: --
1116: hxc_ter_bus.chk_df(p_rec);
1117:
1118: if g_debug then
1119: hr_utility.set_location(' Leaving: '||l_proc, 60);
1120: end if;
1121: --
1122: End insert_validate;
1123: --

Line 1135: g_debug := hr_utility.debug_enabled;

1131: --
1132: l_proc varchar2(72);
1133: --
1134: Begin
1135: g_debug := hr_utility.debug_enabled;
1136:
1137: if g_debug then
1138: l_proc := g_package||'update_validate';
1139: hr_utility.set_location('Entering:'||l_proc, 5);

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

1135: g_debug := hr_utility.debug_enabled;
1136:
1137: if g_debug then
1138: l_proc := g_package||'update_validate';
1139: hr_utility.set_location('Entering:'||l_proc, 5);
1140: end if;
1141: --
1142: -- Call all supporting business operations
1143: --

Line 1152: hr_utility.set_location(' Processing: '||l_proc, 10);

1148: );
1149: --
1150: --
1151: if g_debug then
1152: hr_utility.set_location(' Processing: '||l_proc, 10);
1153: end if;
1154: --
1155: --
1156:

Line 1168: hr_utility.set_location(' Processing: '||l_proc, 20);

1164: ,p_bg_id => p_rec.business_group_id
1165: );
1166: --
1167: if g_debug then
1168: hr_utility.set_location(' Processing: '||l_proc, 20);
1169: end if;
1170: --
1171: chk_rule_usage
1172: (

Line 1177: hr_utility.set_location(' Processing: '||l_proc, 30);

1173: p_rule_usage => p_rec.rule_usage
1174: );
1175: --
1176: if g_debug then
1177: hr_utility.set_location(' Processing: '||l_proc, 30);
1178: end if;
1179: --
1180: chk_mapping_id
1181: (

Line 1186: hr_utility.set_location(' Processing: '||l_proc, 40);

1182: p_mapping_id => p_rec.mapping_id
1183: );
1184: --
1185: if g_debug then
1186: hr_utility.set_location(' Processing: '||l_proc, 40);
1187: end if;
1188: chk_formula_id
1189: (
1190: p_formula_id => p_rec.formula_id

Line 1200: hr_utility.set_location(' Processing: '||l_proc, 50);

1196: p_formula_id => p_rec.formula_id
1197: , p_mapping_id => p_rec.mapping_id );
1198: --
1199: if g_debug then
1200: hr_utility.set_location(' Processing: '||l_proc, 50);
1201: end if;
1202: chk_start_date
1203: (
1204: p_name => p_rec.name

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

1230: --
1231: hxc_ter_bus.chk_df(p_rec);
1232: --
1233: if g_debug then
1234: hr_utility.set_location(' Leaving:'||l_proc, 60);
1235: end if;
1236: End update_validate;
1237: --
1238: -- ----------------------------------------------------------------------------

Line 1248: g_debug := hr_utility.debug_enabled;

1244: --
1245: l_proc varchar2(72);
1246: --
1247: Begin
1248: g_debug := hr_utility.debug_enabled;
1249:
1250: if g_debug then
1251: l_proc := g_package||'delete_validate';
1252: hr_utility.set_location('Entering:'||l_proc, 5);

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

1248: g_debug := hr_utility.debug_enabled;
1249:
1250: if g_debug then
1251: l_proc := g_package||'delete_validate';
1252: hr_utility.set_location('Entering:'||l_proc, 5);
1253: end if;
1254: --
1255: -- Call all supporting business operations
1256: --

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

1259: p_time_entry_rule_id => p_rec.time_entry_rule_id
1260: );
1261: --
1262: if g_debug then
1263: hr_utility.set_location(' Leaving:'||l_proc, 10);
1264: end if;
1265: End delete_validate;
1266: --
1267: end hxc_ter_bus;