33: --
34: Begin
35: Hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK1') Then
38: hr_utility.set_message(800, 'HR_52251_CEL_COMP_ID_INVL');
39: hr_utility.set_location(l_proc,10);
40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');
41: hr_utility.raise_error;
36: --
37: If (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK1') Then
38: hr_utility.set_message(800, 'HR_52251_CEL_COMP_ID_INVL');
39: hr_utility.set_location(l_proc,10);
40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');
41: hr_utility.raise_error;
42:
43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
39: hr_utility.set_location(l_proc,10);
40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');
41: hr_utility.raise_error;
42:
43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
45: hr_utility.set_location(l_proc,15);
46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');
47: hr_utility.raise_error;
42:
43: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK2') Then
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
45: hr_utility.set_location(l_proc,15);
46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then
49:
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
44: hr_utility.set_message(801, 'HR_51612_CEL_BUS_GROUP_ID_INVL');
45: hr_utility.set_location(l_proc,15);
46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then
49:
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
51: hr_utility.set_location(l_proc,30);
52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
48: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK5') Then
49:
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
51: hr_utility.set_location(l_proc,30);
52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
50: hr_utility.set_message(801, 'HR_51615_CEL_PROF_ID_INVL');
51: hr_utility.set_location(l_proc,30);
52: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK6') Then
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
55: hr_utility.set_message(801, 'HR_51616_CEL_HG_PROF_ID_INVL');
56: hr_utility.set_location(l_proc,35);
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK7') Then
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
60: hr_utility.set_message(801, 'HR_51621_CEL_PERSON_ID_INVL');
61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');
62: hr_utility.set_location(l_proc,40);
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
63: hr_utility.raise_error;
64: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK8') Then
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
65: hr_utility.set_message(801, 'HR_51620_CEL_JOB_ID_INVL');
66: hr_utility.set_location(l_proc,45);
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');
68: hr_utility.raise_error;
69: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK9') Then
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
70: hr_utility.set_message(801, 'HR_51622_CEL_POSITION_ID_INVL');
71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');
72: hr_utility.set_location(l_proc,50);
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
76: hr_utility.set_location(l_proc,55);
77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');
78: hr_utility.raise_error;
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK10') Then
75: hr_utility.set_message(801, 'HR_51623_CEL_ORG_ID_INVL');
76: hr_utility.set_location(l_proc,55);
77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');
78: hr_utility.raise_error;
79:
80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
76: hr_utility.set_location(l_proc,55);
77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');
78: hr_utility.raise_error;
79:
80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
82: hr_utility.set_location(l_proc,70);
83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
79:
80: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK14') Then
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
82: hr_utility.set_location(l_proc,70);
83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
81: hr_utility.set_message(801, 'HR_51628_CEL_ASS_ID_INVL');
82: hr_utility.set_location(l_proc,70);
83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');
89: hr_utility.raise_error;
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK15') Then
86: hr_utility.set_message(801, 'HR_51748_CEL_ASS_TYPE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');
89: hr_utility.raise_error;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
87: hr_utility.set_location(l_proc,75);
88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID');
89: hr_utility.raise_error;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
93: hr_utility.set_location(l_proc,80);
94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
93: hr_utility.set_location(l_proc,80);
94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');
93: hr_utility.set_location(l_proc,80);
94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK17') Then
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
97: hr_utility.set_message(801, 'HR_51632_CEL_WEG_ID_INVL');
98: hr_utility.set_location(l_proc,85);
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID');
100: hr_utility.raise_error;
101: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK18') Then
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
102: hr_utility.set_message(801, 'HR_51633_CEL_PARENT_ID_INVL');
103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
104: hr_utility.set_location(l_proc,90);
105: hr_utility.raise_error;
106: Elsif (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK19') Then
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
107: hr_utility.set_message(800, 'HR_52341_PER_DATE_INVL');
108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);
115: hr_utility.raise_error;
109: hr_utility.set_location(l_proc,90);
110: hr_utility.raise_error;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);
115: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');
113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID');
114: hr_utility.set_location(l_proc,90);
115: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');
118: hr_multi_message.add(
119: p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
120: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
115: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');
118: hr_multi_message.add(
119: p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
120: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
121: );
122: hr_utility.set_location(l_proc,90);
123: hr_utility.raise_error;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');
118: hr_multi_message.add(
119: p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
120: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
121: );
122: hr_utility.set_location(l_proc,90);
123: hr_utility.raise_error;
124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
120: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
121: );
122: hr_utility.set_location(l_proc,90);
123: hr_utility.raise_error;
124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
127: hr_utility.set_location(l_proc,90);
128: hr_utility.raise_error;
122: hr_utility.set_location(l_proc,90);
123: hr_utility.raise_error;
124: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK22') Then
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
127: hr_utility.set_location(l_proc,90);
128: hr_utility.raise_error;
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then
130:
125: hr_utility.set_message(800, 'HR_52342_GRD_DATE_INVL');
126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
127: hr_utility.set_location(l_proc,90);
128: hr_utility.raise_error;
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then
130:
131: hr_utility.set_message(801, 'HR_51634_CEL_PRI_KEY_ID_INVL');
132: hr_utility.set_location(l_proc,95);
133: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
129: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_PK') Then
130:
131: hr_utility.set_message(801, 'HR_51634_CEL_PRI_KEY_ID_INVL');
132: hr_utility.set_location(l_proc,95);
133: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
134: hr_utility.raise_error;
135: Else
136: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
137: hr_utility.set_message_token('PROCEDURE', l_proc);
244: ,information19
245: ,information20
246: ,achieved_date
247: ,appr_line_score
248: from per_competence_elements
249: where competence_element_id = p_competence_element_id;
250: --
251: l_proc varchar2(72) := g_package||'api_updating';
252: l_fct_ret boolean;
403: ,information19
404: ,information20
405: ,achieved_date
406: ,appr_line_score
407: from per_competence_elements
408: where competence_element_id = p_competence_element_id
409: for update nowait;
410: --
411: l_proc varchar2(72) := g_package||'lck';
449: -- The object is locked therefore we need to supply a meaningful
450: -- error message.
451: --
452: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
453: hr_utility.set_message_token('TABLE_NAME', 'per_competence_elements');
454: hr_utility.raise_error;
455: End lck;
456: --
457: -- ----------------------------------------------------------------------------