DBA Data[Home] [Help]

APPS.PER_CEL_SHD dependencies on HR_MULTI_MESSAGE

Line 40: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID');

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');

Line 46: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID');

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');

Line 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);

Line 57: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.HIGH_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;
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');

Line 61: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PERSON_ID');

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');

Line 67: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.JOB_ID');

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');

Line 71: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.POSITION_ID');

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');

Line 77: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID');

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');

Line 83: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID');

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);

Line 88: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_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;
90:
91: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK16') Then
92: hr_utility.set_message(801, 'HR_51631_CEL_RATE_ID_INVL');

Line 94: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID');

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);

Line 99: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.WEIGHTING_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;
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');

Line 103: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID');

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');

Line 108: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_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;
111: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK20') Then
112: hr_utility.set_message(800, 'HR_52338_COMP_DATE_INVL');

Line 113: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.ENTERPRISE_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;
116: ElsIf (p_constraint_name = 'PER_COMPETENCE_ELEMENTS_FK21') Then
117: hr_utility.set_message(800, 'HR_52339_COMP_ELMT_DATE_INVL');

Line 118: hr_multi_message.add(

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'
121: );
122: hr_utility.set_location(l_proc,90);

Line 126: hr_multi_message.add( p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');

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:

Line 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);