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.HXC_HPH_BUS dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hph_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

Line 47: g_debug:=hr_utility.debug_enabled;

43: l_proc varchar2(72) ;
44: --
45: begin
46: --
47: g_debug:=hr_utility.debug_enabled;
48: if g_debug then
49: l_proc := g_package||'set_security_group_id';
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: end if;

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

46: --
47: g_debug:=hr_utility.debug_enabled;
48: if g_debug then
49: l_proc := g_package||'set_security_group_id';
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: end if;
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --

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

79: (p_security_group_id => l_security_group_id
80: );
81: --
82: if g_debug then
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: end if;
85: --
86: end set_security_group_id;
87: --

Line 119: g_debug:=hr_utility.debug_enabled;

115: l_proc varchar2(72);
116: --
117: Begin
118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;--

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

118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;--
124: -- Ensure that all the mandatory parameter are not null
125: --
126: hr_api.mandatory_arg_error

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

137: -- variable.
138: --
139: l_legislation_code := hxc_hph_bus.g_legislation_code;
140: if g_debug then
141: hr_utility.set_location(l_proc, 20);
142: end if;
143: else
144: --
145: -- The ID is different to the last call to this function

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

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

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

167: hxc_hph_bus.g_pref_hierarchy_id := p_pref_hierarchy_id;
168: hxc_hph_bus.g_legislation_code := l_legislation_code;
169: end if;
170: if g_debug then
171: hr_utility.set_location(' Leaving:'|| l_proc, 40);
172: end if;
173: return l_legislation_code;
174: end return_legislation_code;
175: --

Line 211: g_debug:=hr_utility.debug_enabled;

207: --
208: l_proc varchar2(72);
209: --
210: begin
211: g_debug:=hr_utility.debug_enabled;
212: if g_debug then
213: l_proc := g_package || 'chk_df';
214: hr_utility.set_location('Entering:'||l_proc,10);
215: end if;

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

210: begin
211: g_debug:=hr_utility.debug_enabled;
212: if g_debug then
213: l_proc := g_package || 'chk_df';
214: hr_utility.set_location('Entering:'||l_proc,10);
215: end if;
216: --
217: if ((p_rec.pref_hierarchy_id is not null) and (
218: nvl(hxc_hph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

353: );
354: end if;
355: --
356: if g_debug then
357: hr_utility.set_location(' Leaving:'||l_proc,20);
358: end if;
359: end chk_df;
360: --
361: -- ----------------------------------------------------------------------------

Line 480: g_debug:=hr_utility.debug_enabled;

476: --
477: l_error varchar2(5) := NULL;
478: --
479: BEGIN
480: g_debug:=hr_utility.debug_enabled;
481: if g_debug then
482: l_proc := g_package||'chk_name';
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: end if;

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

479: BEGIN
480: g_debug:=hr_utility.debug_enabled;
481: if g_debug then
482: l_proc := g_package||'chk_name';
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: end if;
485: --
486: -- Raise error if name is NULL as it is a mandatory field.
487: --

Line 491: hr_utility.set_message(809, 'HXC_0077_HPH_PREF_NAME_MAND');

487: --
488: IF p_name IS NULL
489: THEN
490: --
491: hr_utility.set_message(809, 'HXC_0077_HPH_PREF_NAME_MAND');
492: hr_utility.raise_error;
493: --
494: END IF;
495: if g_debug then

Line 492: hr_utility.raise_error;

488: IF p_name IS NULL
489: THEN
490: --
491: hr_utility.set_message(809, 'HXC_0077_HPH_PREF_NAME_MAND');
492: hr_utility.raise_error;
493: --
494: END IF;
495: if g_debug then
496: hr_utility.set_location('Processing:'||l_proc, 10);

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

492: hr_utility.raise_error;
493: --
494: END IF;
495: if g_debug then
496: hr_utility.set_location('Processing:'||l_proc, 10);
497: end if;
498: --
499: -- Raise an error if the child preference hierarchy name is not unique
500: --

Line 508: hr_utility.set_message(809, 'HXC_0078_HPH_DUP_PREF_NAME');

504: --
505: IF l_error IS NOT NULL
506: THEN
507: --
508: hr_utility.set_message(809, 'HXC_0078_HPH_DUP_PREF_NAME');
509: hr_utility.raise_error;
510: --
511: END IF;
512: --

Line 509: hr_utility.raise_error;

505: IF l_error IS NOT NULL
506: THEN
507: --
508: hr_utility.set_message(809, 'HXC_0078_HPH_DUP_PREF_NAME');
509: hr_utility.raise_error;
510: --
511: END IF;
512: --
513: if g_debug then

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

510: --
511: END IF;
512: --
513: if g_debug then
514: hr_utility.set_location('Leaving:'||l_proc, 20);
515: end if;
516: --
517: END chk_name;
518:

Line 534: hr_utility.set_message(809, 'HXC_HPH_RULES_EVALUATION');

530: IF ( p_attribute1 = 'Y' )
531: THEN
532: IF ( p_attribute2 IS NULL )
533: THEN
534: hr_utility.set_message(809, 'HXC_HPH_RULES_EVALUATION');
535: hr_utility.raise_error;
536: END IF;
537: END IF;
538:

Line 535: hr_utility.raise_error;

531: THEN
532: IF ( p_attribute2 IS NULL )
533: THEN
534: hr_utility.set_message(809, 'HXC_HPH_RULES_EVALUATION');
535: hr_utility.raise_error;
536: END IF;
537: END IF;
538:
539: END IF;

Line 552: hr_utility.set_message(809, 'HXC_DAYS_HOURS');

548: IF ( p_pref_code = 'TS_PER_DAYS_TO_HOURS' )
549: THEN
550: IF ( p_attribute1 is not null ) and (p_attribute2 is null)
551: THEN
552: hr_utility.set_message(809, 'HXC_DAYS_HOURS');
553: hr_utility.raise_error;
554: END IF;
555: END IF;
556: END chk_days_hours_factor;

Line 553: hr_utility.raise_error;

549: THEN
550: IF ( p_attribute1 is not null ) and (p_attribute2 is null)
551: THEN
552: hr_utility.set_message(809, 'HXC_DAYS_HOURS');
553: hr_utility.raise_error;
554: END IF;
555: END IF;
556: END chk_days_hours_factor;
557:

Line 568: hr_utility.set_message(809, 'HXC_TK_PERSON_NAME_NUMBER');

564: IF ( p_pref_code = 'TK_TCARD_SETUP' )
565: THEN
566: IF ( p_attribute2 = 'N' ) and (p_attribute3 = 'N')
567: THEN
568: hr_utility.set_message(809, 'HXC_TK_PERSON_NAME_NUMBER');
569: hr_utility.raise_error;
570: END IF;
571: END IF;
572: END chk_tk_person_name_number;

Line 569: hr_utility.raise_error;

565: THEN
566: IF ( p_attribute2 = 'N' ) and (p_attribute3 = 'N')
567: THEN
568: hr_utility.set_message(809, 'HXC_TK_PERSON_NAME_NUMBER');
569: hr_utility.raise_error;
570: END IF;
571: END IF;
572: END chk_tk_person_name_number;
573:

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

584: and ( p_attribute2 is Null or
585: p_attribute3 is Null or
586: (p_attribute4 is Null and p_attribute3 <>'NONE'))
587: THEN
588: hr_utility.set_message(809, 'HXC_TK_AUDIT_SEG_REQ');
589: hr_utility.raise_error;
590: END IF;
591: END IF;
592: END chk_tk_audit_segments;

Line 589: hr_utility.raise_error;

585: p_attribute3 is Null or
586: (p_attribute4 is Null and p_attribute3 <>'NONE'))
587: THEN
588: hr_utility.set_message(809, 'HXC_TK_AUDIT_SEG_REQ');
589: hr_utility.raise_error;
590: END IF;
591: END IF;
592: END chk_tk_audit_segments;
593:

Line 769: g_debug:=hr_utility.debug_enabled;

765: l_error varchar2(5) := NULL;
766: l_error2 varchar2(5) := NULL;
767: --
768: BEGIN
769: g_debug:=hr_utility.debug_enabled;
770: if g_debug then
771: l_proc := g_package||'chk_code';
772: hr_utility.set_location('Entering:'||l_proc, 5);
773: end if;

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

768: BEGIN
769: g_debug:=hr_utility.debug_enabled;
770: if g_debug then
771: l_proc := g_package||'chk_code';
772: hr_utility.set_location('Entering:'||l_proc, 5);
773: end if;
774: --
775: -- Raise error if name is NULL as it is a mandatory field.
776: --

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

776: --
777: IF p_pref_code IS NOT NULL THEN
778: --
779: if g_debug then
780: hr_utility.set_location('Processing:'||l_proc, 10);
781: end if;
782: --
783: -- Raise an error if the child preference hierarchy name is not unique
784: --

Line 792: hr_utility.set_message(809, 'HXC_HPH_DUP_PREF_CODE');

788: --
789: IF l_error IS NOT NULL
790: THEN
791: --
792: hr_utility.set_message(809, 'HXC_HPH_DUP_PREF_CODE');
793: hr_utility.raise_error;
794: --
795: END IF;
796: --

Line 793: hr_utility.raise_error;

789: IF l_error IS NOT NULL
790: THEN
791: --
792: hr_utility.set_message(809, 'HXC_HPH_DUP_PREF_CODE');
793: hr_utility.raise_error;
794: --
795: END IF;
796: --
797: END IF;

Line 806: hr_utility.set_message(809, 'HXC_HPH_NOT_PREF_PARENT');

802: --
803: IF l_error2 IS NOT NULL
804: THEN
805: --
806: hr_utility.set_message(809, 'HXC_HPH_NOT_PREF_PARENT');
807: hr_utility.raise_error;
808: --
809: END IF;
810: if g_debug then

Line 807: hr_utility.raise_error;

803: IF l_error2 IS NOT NULL
804: THEN
805: --
806: hr_utility.set_message(809, 'HXC_HPH_NOT_PREF_PARENT');
807: hr_utility.raise_error;
808: --
809: END IF;
810: if g_debug then
811: hr_utility.set_location('Leaving:'||l_proc, 20);

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

807: hr_utility.raise_error;
808: --
809: END IF;
810: if g_debug then
811: hr_utility.set_location('Leaving:'||l_proc, 20);
812: end if;
813: --
814:
815: END chk_pref_code;

Line 868: g_debug:=hr_utility.debug_enabled;

864: --
865: l_error varchar2(5) := NULL;
866: --
867: BEGIN
868: g_debug:=hr_utility.debug_enabled;
869: if g_debug then
870: l_proc := g_package||'chk_top_node';
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: end if;

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

867: BEGIN
868: g_debug:=hr_utility.debug_enabled;
869: if g_debug then
870: l_proc := g_package||'chk_top_node';
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: end if;
873: --
874: -- Raise an error if the top node preference name is not unique
875: --

Line 883: hr_utility.set_message(809, 'HXC_0149_HPH_TOP_NODE_EXIST');

879: --
880: IF l_error IS NOT NULL
881: THEN
882: --
883: hr_utility.set_message(809, 'HXC_0149_HPH_TOP_NODE_EXIST');
884: hr_utility.raise_error;
885: --
886: END IF;
887: --

Line 884: hr_utility.raise_error;

880: IF l_error IS NOT NULL
881: THEN
882: --
883: hr_utility.set_message(809, 'HXC_0149_HPH_TOP_NODE_EXIST');
884: hr_utility.raise_error;
885: --
886: END IF;
887: --
888: if g_debug then

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

885: --
886: END IF;
887: --
888: if g_debug then
889: hr_utility.set_location('Leaving:'||l_proc, 5);
890: end if;
891: --
892: END chk_top_node;
893: --

Line 952: g_debug:=hr_utility.debug_enabled;

948: l_error varchar2(5) := NULL;
949: --
950: BEGIN
951:
952: g_debug:=hr_utility.debug_enabled;
953: if g_debug then
954: l_proc := g_package||'chk_preference';
955: hr_utility.set_location('Entering:'||l_proc, 5);
956: end if;

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

951:
952: g_debug:=hr_utility.debug_enabled;
953: if g_debug then
954: l_proc := g_package||'chk_preference';
955: hr_utility.set_location('Entering:'||l_proc, 5);
956: end if;
957: --
958: -- Raise an error if the child preference definition name is not unique
959: --

Line 967: hr_utility.set_message(809, 'HXC_0147_HPH_DUP_PREF_DEF');

963: --
964: IF l_error IS NOT NULL
965: THEN
966: --
967: hr_utility.set_message(809, 'HXC_0147_HPH_DUP_PREF_DEF');
968: hr_utility.raise_error;
969: --
970: END IF;
971: --

Line 968: hr_utility.raise_error;

964: IF l_error IS NOT NULL
965: THEN
966: --
967: hr_utility.set_message(809, 'HXC_0147_HPH_DUP_PREF_DEF');
968: hr_utility.raise_error;
969: --
970: END IF;
971: --
972: if g_debug then

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

969: --
970: END IF;
971: --
972: if g_debug then
973: hr_utility.set_location('Leaving:'||l_proc, 20);
974: end if;
975: --
976: END chk_preference;
977: --

Line 1005: g_debug:=hr_utility.debug_enabled;

1001: from hxc_alias_type_components hac
1002: where hac.alias_type_id = p_alias_type_id;
1003: ind number;
1004: begin
1005: g_debug:=hr_utility.debug_enabled;
1006: if g_debug then
1007: hr_utility.trace('Mappings are');
1008: end if;
1009: open c_get_mapping_components(p_alias_type_id);

Line 1007: hr_utility.trace('Mappings are');

1003: ind number;
1004: begin
1005: g_debug:=hr_utility.debug_enabled;
1006: if g_debug then
1007: hr_utility.trace('Mappings are');
1008: end if;
1009: open c_get_mapping_components(p_alias_type_id);
1010: loop
1011: fetch c_get_mapping_components into ind;

Line 1015: hr_utility.trace('Mapping Id '|| ind);

1011: fetch c_get_mapping_components into ind;
1012: exit when c_get_mapping_components%notfound;
1013: p_mapping_id_table(ind).mapping_id := ind;
1014: if g_debug then
1015: hr_utility.trace('Mapping Id '|| ind);
1016: end if;
1017: end loop;
1018: close c_get_mapping_components;
1019: end get_mapping_components;

Line 1048: g_debug:=hr_utility.debug_enabled;

1044: l_mapping_id_table hxc_hph_shd.alias_mapping_table;
1045: i number;
1046: j number;
1047: begin
1048: g_debug:=hr_utility.debug_enabled;
1049: key_alias_type_id := p_alias_type_id_table(p_index).id;
1050: if (key_alias_type_id is not null) then
1051: if g_debug then
1052: hr_utility.trace('Key Alias Type Id' || key_alias_type_id);

Line 1052: hr_utility.trace('Key Alias Type Id' || key_alias_type_id);

1048: g_debug:=hr_utility.debug_enabled;
1049: key_alias_type_id := p_alias_type_id_table(p_index).id;
1050: if (key_alias_type_id is not null) then
1051: if g_debug then
1052: hr_utility.trace('Key Alias Type Id' || key_alias_type_id);
1053: end if;
1054: get_mapping_components(key_alias_type_id,key_mapping_id_table);
1055: for i in 1..p_index-1 loop
1056: l_alias_type_id := p_alias_type_id_table(i).id;

Line 1058: hr_utility.trace('Validate_alias_definitions' || l_alias_type_id);

1054: get_mapping_components(key_alias_type_id,key_mapping_id_table);
1055: for i in 1..p_index-1 loop
1056: l_alias_type_id := p_alias_type_id_table(i).id;
1057: if g_debug then
1058: hr_utility.trace('Validate_alias_definitions' || l_alias_type_id);
1059: end if;
1060: if (l_alias_type_id = key_alias_type_id) then
1061: return 0;
1062: else

Line 1066: hr_utility.trace('Key Maping Id');

1062: else
1063: get_mapping_components(l_alias_type_id,l_mapping_id_table);
1064: j := key_mapping_id_table.first;
1065: if g_debug then
1066: hr_utility.trace('Key Maping Id');
1067: end if;
1068: loop
1069: exit when not key_mapping_id_table.exists(j);
1070: if g_debug then

Line 1071: hr_utility.trace('Matching ID ');

1067: end if;
1068: loop
1069: exit when not key_mapping_id_table.exists(j);
1070: if g_debug then
1071: hr_utility.trace('Matching ID ');
1072: end if;
1073: if (l_mapping_id_table.exists(j)) then
1074: return 0;
1075: end if;

Line 1386: g_debug:=hr_utility.debug_enabled;

1382: where hac.alias_type_id = p_alias_type_id
1383: and hac.mapping_component_id = hmc.mapping_component_id;
1384:
1385: begin
1386: g_debug:=hr_utility.debug_enabled;
1387: n := p_alias_type_id_table.first;
1388: loop
1389: if g_debug then
1390: hr_utility.set_location('validate_alias_mapping_name' ,20);

Line 1390: hr_utility.set_location('validate_alias_mapping_name' ,20);

1386: g_debug:=hr_utility.debug_enabled;
1387: n := p_alias_type_id_table.first;
1388: loop
1389: if g_debug then
1390: hr_utility.set_location('validate_alias_mapping_name' ,20);
1391: end if;
1392: exit when not p_alias_type_id_table.exists(n);
1393: open c_get_mapping_comp_name(p_alias_type_id_table(n).id);
1394: loop

Line 1426: hr_utility.trace('l_mapping_name' || l_mapping_name);

1422: loop
1423: exit when not l_alias_mapping_name_table.exists(n);
1424: l_mapping_name := l_alias_mapping_name_table(n).mapping_comp_name;
1425: if g_debug then
1426: hr_utility.trace('l_mapping_name' || l_mapping_name);
1427: end if;
1428: n := l_alias_mapping_name_table.next(n);
1429: end loop;
1430: if g_debug then

Line 1431: hr_utility.trace('l_Inputvalue_flag= ' || l_Inputvalue_flag);

1427: end if;
1428: n := l_alias_mapping_name_table.next(n);
1429: end loop;
1430: if g_debug then
1431: hr_utility.trace('l_Inputvalue_flag= ' || l_Inputvalue_flag);
1432: end if;
1433: if ( l_Inputvalue_flag= 1 ) then
1434: succ := 0;
1435: n := l_alias_mapping_name_table.first;

Line 1450: hr_utility.trace('l_costsegment_flag ' || l_costsegment_flag);

1446: end if;
1447: end if;
1448: /*
1449: if g_debug then
1450: hr_utility.trace('l_costsegment_flag ' || l_costsegment_flag);
1451: end if;
1452: if (l_CostSegment_flag = 1 ) then
1453: succ := 0;
1454: n := l_alias_mapping_name_table.first;

Line 1464: hr_utility.trace('Succ: ' || succ);

1460: end if;
1461: n := l_alias_mapping_name_table.next(n);
1462: end loop;
1463: if g_debug then
1464: hr_utility.trace('Succ: ' || succ);
1465: end if;
1466: if (succ = 0) then
1467: return 0;
1468: end if;

Line 1471: hr_utility.trace('l_GrpSegment_flag ' || l_GrpSegment_flag);

1467: return 0;
1468: end if;
1469: end if;
1470: if g_debug then
1471: hr_utility.trace('l_GrpSegment_flag ' || l_GrpSegment_flag);
1472: end if;
1473: if (l_GrpSegment_flag = 1 ) then
1474: succ := 0;
1475: n := l_alias_mapping_name_table.first;

Line 1489: hr_utility.trace('l_JobSegment_flag ' || l_JobSegment_flag);

1485: return 0;
1486: end if;
1487: end if;
1488: if g_debug then
1489: hr_utility.trace('l_JobSegment_flag ' || l_JobSegment_flag);
1490: end if;
1491: if (l_JobSegment_flag = 1 ) then
1492: succ := 0;
1493: n := l_alias_mapping_name_table.first;

Line 1507: hr_utility.trace('l_PosSegment_flag ' || l_PosSegment_flag);

1503: return 0;
1504: end if;
1505: end if;
1506: if g_debug then
1507: hr_utility.trace('l_PosSegment_flag ' || l_PosSegment_flag);
1508: end if;
1509: if (l_PosSegment_flag = 1 ) then
1510: succ := 0;
1511: n := l_alias_mapping_name_table.first;

Line 1534: g_debug:=hr_utility.debug_enabled;

1530: succ number;
1531: l_alias_type_id_table hxc_hph_shd.alias_type_id_table;
1532: l_alias_mapping_name_table hxc_hph_shd.alias_mapping_name_table;
1533: begin
1534: g_debug:=hr_utility.debug_enabled;
1535: if g_debug then
1536: hr_utility.trace('p_rec.attribute_category' ||p_rec.attribute_category);
1537: end if;
1538: if (p_rec.attribute_category = 'TK_TCARD_ATTRIBUTES_DEFINITION') then

Line 1536: hr_utility.trace('p_rec.attribute_category' ||p_rec.attribute_category);

1532: l_alias_mapping_name_table hxc_hph_shd.alias_mapping_name_table;
1533: begin
1534: g_debug:=hr_utility.debug_enabled;
1535: if g_debug then
1536: hr_utility.trace('p_rec.attribute_category' ||p_rec.attribute_category);
1537: end if;
1538: if (p_rec.attribute_category = 'TK_TCARD_ATTRIBUTES_DEFINITION') then
1539: if g_debug then
1540: hr_utility.set_location('validate_alias',20);

Line 1540: hr_utility.set_location('validate_alias',20);

1536: hr_utility.trace('p_rec.attribute_category' ||p_rec.attribute_category);
1537: end if;
1538: if (p_rec.attribute_category = 'TK_TCARD_ATTRIBUTES_DEFINITION') then
1539: if g_debug then
1540: hr_utility.set_location('validate_alias',20);
1541: end if;
1542: populate_alias_type_id_table(p_rec,l_alias_type_id_table);
1543: n := l_alias_type_id_table.first;
1544: loop

Line 1546: hr_utility.set_location('validate_alias',30);

1542: populate_alias_type_id_table(p_rec,l_alias_type_id_table);
1543: n := l_alias_type_id_table.first;
1544: loop
1545: if g_debug then
1546: hr_utility.set_location('validate_alias',30);
1547: end if;
1548: exit when not l_alias_type_id_table.exists(n);
1549: if g_debug then
1550: hr_utility.trace('n' || n);

Line 1550: hr_utility.trace('n' || n);

1546: hr_utility.set_location('validate_alias',30);
1547: end if;
1548: exit when not l_alias_type_id_table.exists(n);
1549: if g_debug then
1550: hr_utility.trace('n' || n);
1551: end if;
1552: succ := validate_alias_definitions(l_alias_type_id_table,n);
1553: if (succ =0) then
1554: hr_utility.set_message(809,'HXC_AN_DEFN_WRG');

Line 1554: hr_utility.set_message(809,'HXC_AN_DEFN_WRG');

1550: hr_utility.trace('n' || n);
1551: end if;
1552: succ := validate_alias_definitions(l_alias_type_id_table,n);
1553: if (succ =0) then
1554: hr_utility.set_message(809,'HXC_AN_DEFN_WRG');
1555: hr_utility.raise_error;
1556: end if;
1557: n:= l_alias_type_id_table.next(n);
1558: end loop;

Line 1555: hr_utility.raise_error;

1551: end if;
1552: succ := validate_alias_definitions(l_alias_type_id_table,n);
1553: if (succ =0) then
1554: hr_utility.set_message(809,'HXC_AN_DEFN_WRG');
1555: hr_utility.raise_error;
1556: end if;
1557: n:= l_alias_type_id_table.next(n);
1558: end loop;
1559: succ := validate_alias_mapping_names(l_alias_type_id_table);

Line 1561: hr_utility.set_message(809,'HXC_AN_DEFN_WRG');

1557: n:= l_alias_type_id_table.next(n);
1558: end loop;
1559: succ := validate_alias_mapping_names(l_alias_type_id_table);
1560: if (succ = 0) then
1561: hr_utility.set_message(809,'HXC_AN_DEFN_WRG');
1562: hr_utility.raise_error;
1563: end if;
1564: end if;
1565: end validate_alias;

Line 1562: hr_utility.raise_error;

1558: end loop;
1559: succ := validate_alias_mapping_names(l_alias_type_id_table);
1560: if (succ = 0) then
1561: hr_utility.set_message(809,'HXC_AN_DEFN_WRG');
1562: hr_utility.raise_error;
1563: end if;
1564: end if;
1565: end validate_alias;
1566:

Line 1618: g_debug:=hr_utility.debug_enabled;

1614:
1615: --
1616: --
1617: begin
1618: g_debug:=hr_utility.debug_enabled;
1619: if g_debug then
1620: l_proc := g_package||'chk_legislation_code';
1621: hr_utility.set_location('Entering: '||l_proc,5);
1622: end if;

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

1617: begin
1618: g_debug:=hr_utility.debug_enabled;
1619: if g_debug then
1620: l_proc := g_package||'chk_legislation_code';
1621: hr_utility.set_location('Entering: '||l_proc,5);
1622: end if;
1623: --------------------------------
1624: -- Check legislation code is valid --
1625: --------------------------------

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

1628: open csr_valid_legislation_code;
1629: fetch csr_valid_legislation_code into l_territory_code;
1630: if csr_valid_legislation_code%notfound then
1631: close csr_valid_legislation_code;
1632: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
1633: hr_utility.raise_error;
1634: end if; -- End cursor if
1635: close csr_valid_legislation_code;
1636:

Line 1633: hr_utility.raise_error;

1629: fetch csr_valid_legislation_code into l_territory_code;
1630: if csr_valid_legislation_code%notfound then
1631: close csr_valid_legislation_code;
1632: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
1633: hr_utility.raise_error;
1634: end if; -- End cursor if
1635: close csr_valid_legislation_code;
1636:
1637: if p_business_group_id is not null then

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

1638: open csr_valid_bg_lc;
1639: fetch csr_valid_bg_lc into l_lc;
1640: if csr_valid_bg_lc%notfound then
1641: close csr_valid_bg_lc;
1642: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
1643: hr_utility.raise_error;
1644: end if; -- End cursor if
1645: close csr_valid_bg_lc;
1646: end if;

Line 1643: hr_utility.raise_error;

1639: fetch csr_valid_bg_lc into l_lc;
1640: if csr_valid_bg_lc%notfound then
1641: close csr_valid_bg_lc;
1642: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
1643: hr_utility.raise_error;
1644: end if; -- End cursor if
1645: close csr_valid_bg_lc;
1646: end if;
1647:

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

1647:
1648: end if; -- end check
1649:
1650: if g_debug then
1651: hr_utility.set_location('Leaving: '||l_proc,10);
1652: end if;
1653: end chk_legislation_code;
1654: --
1655: -- ----------------------------------------------------------------------------

Line 1666: g_debug:=hr_utility.debug_enabled;

1662: --
1663: l_proc varchar2(72);
1664: --
1665: Begin
1666: g_debug:=hr_utility.debug_enabled;
1667: if g_debug then
1668: l_proc := g_package||'insert_validate';
1669: hr_utility.set_location('Entering:'||l_proc, 5);
1670: end if;

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

1665: Begin
1666: g_debug:=hr_utility.debug_enabled;
1667: if g_debug then
1668: l_proc := g_package||'insert_validate';
1669: hr_utility.set_location('Entering:'||l_proc, 5);
1670: end if;
1671: --
1672: -- Call all supporting business operations
1673: --

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

1671: --
1672: -- Call all supporting business operations
1673: --
1674: if g_debug then
1675: hr_utility.set_location('Processing:'||l_proc, 10);
1676: end if;
1677: --
1678: -- Do check for duplicate pref hierarchy name
1679: --

Line 1681: hr_utility.trace('p_rec.attribute_category is ' || p_rec.attribute_category);

1677: --
1678: -- Do check for duplicate pref hierarchy name
1679: --
1680: if g_debug then
1681: hr_utility.trace('p_rec.attribute_category is ' || p_rec.attribute_category);
1682: end if;
1683: chk_name ( p_name => p_rec.name,
1684: p_parent_pref_hierarchy_id => p_rec.parent_pref_hierarchy_id,
1685: p_business_group_id => p_rec.business_group_id,

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

1715: , p_attribute1 => p_rec.attribute1
1716: , p_attribute2 => p_rec.attribute2 );
1717:
1718: if g_debug then
1719: hr_utility.set_location(' Leaving:'||l_proc, 10);
1720: --
1721: hr_utility.set_location('Processing:'||l_proc, 15);
1722: end if;
1723:

Line 1721: hr_utility.set_location('Processing:'||l_proc, 15);

1717:
1718: if g_debug then
1719: hr_utility.set_location(' Leaving:'||l_proc, 10);
1720: --
1721: hr_utility.set_location('Processing:'||l_proc, 15);
1722: end if;
1723:
1724: IF ( p_rec.parent_pref_hierarchy_id is null )
1725: THEN

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

1732:
1733: END IF;
1734:
1735: if g_debug then
1736: hr_utility.set_location('Processing:'||l_proc, 20);
1737: end if;
1738: --
1739: -- Check that a single hierarchy does not contain the same preference twice
1740: --

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

1744: p_object_version_number => p_rec.object_version_number );
1745: --
1746: --
1747: if g_debug then
1748: hr_utility.set_location(' Leaving:'||l_proc, 20);
1749: end if;
1750: --
1751: --
1752: -- EDIT_HERE: As this table does not have a mandatory business_group_id

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

1768: hxc_hph_bus.chk_df(p_rec);
1769: --
1770: hxc_hph_bus.validate_alias(p_rec);
1771: if g_debug then
1772: hr_utility.set_location(' Leaving:'||l_proc, 10);
1773: end if;
1774: End insert_validate;
1775: --
1776: -- ----------------------------------------------------------------------------

Line 1787: g_debug:=hr_utility.debug_enabled;

1783: --
1784: l_proc varchar2(72);
1785: --
1786: Begin
1787: g_debug:=hr_utility.debug_enabled;
1788: if g_debug then
1789: l_proc := g_package||'update_validate';
1790: hr_utility.set_location('Entering:'||l_proc, 5);
1791: end if;

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

1786: Begin
1787: g_debug:=hr_utility.debug_enabled;
1788: if g_debug then
1789: l_proc := g_package||'update_validate';
1790: hr_utility.set_location('Entering:'||l_proc, 5);
1791: end if;
1792: --
1793: -- Call all supporting business operations
1794: --

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

1807: --
1808: -- Do check for duplicate pref hierarchy name
1809: --
1810: if g_debug then
1811: hr_utility.set_location('Processing:'||l_proc, 10);
1812: end if;
1813: --
1814: chk_name ( p_name => p_rec.name,
1815: p_parent_pref_hierarchy_id => p_rec.parent_pref_hierarchy_id,

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

1816: p_business_group_id => p_rec.business_group_id,
1817: p_object_version_number => p_rec.object_version_number );
1818: --
1819: if g_debug then
1820: hr_utility.set_location(' Leaving:'||l_proc, 10);
1821: end if;
1822: --
1823: -- Do check for duplicate pref hierarchy code
1824: --

Line 1853: hr_utility.set_location('Processing:'||l_proc, 15);

1849: , p_attribute2 => p_rec.attribute2 );
1850:
1851: --
1852: if g_debug then
1853: hr_utility.set_location('Processing:'||l_proc, 15);
1854: end if;
1855: IF ( p_rec.parent_pref_hierarchy_id is null )
1856: THEN
1857:

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

1863:
1864: END IF;
1865:
1866: if g_debug then
1867: hr_utility.set_location('Processing:'||l_proc, 20);
1868: end if;
1869: --
1870: -- Check that a single hierarchy does not contain the same preference twice
1871: --

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

1875: p_object_version_number => p_rec.object_version_number );
1876: --
1877: --
1878: if g_debug then
1879: hr_utility.set_location(' Leaving:'||l_proc, 20);
1880: end if;
1881: --
1882: if p_rec.business_group_id is not null then
1883: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 1894: hr_utility.set_location(' Leaving:'||l_proc, 15);

1890: hxc_hph_bus.chk_df(p_rec);
1891: hxc_hph_bus.validate_alias(p_rec);
1892: --
1893: if g_debug then
1894: hr_utility.set_location(' Leaving:'||l_proc, 15);
1895: end if;
1896: End update_validate;
1897: --
1898: -- ----------------------------------------------------------------------------

Line 1908: g_debug:=hr_utility.debug_enabled;

1904: --
1905: l_proc varchar2(72);
1906: --
1907: Begin
1908: g_debug:=hr_utility.debug_enabled;
1909: if g_debug then
1910: l_proc := g_package||'delete_validate';
1911: hr_utility.set_location('Entering:'||l_proc, 5);
1912: end if;

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

1907: Begin
1908: g_debug:=hr_utility.debug_enabled;
1909: if g_debug then
1910: l_proc := g_package||'delete_validate';
1911: hr_utility.set_location('Entering:'||l_proc, 5);
1912: end if;
1913: --
1914: -- Call all supporting business operations
1915: --

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

1913: --
1914: -- Call all supporting business operations
1915: --
1916: if g_debug then
1917: hr_utility.set_location(' Leaving:'||l_proc, 10);
1918: end if;
1919: End delete_validate;
1920: --
1921: end hxc_hph_bus;