20: --
21: If (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK1') Then
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_CRT_RT_ELMNT');
23: hr_utility.raise_error;
24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
21: If (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK1') Then
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_CRT_RT_ELMNT');
23: hr_utility.raise_error;
24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_CRT_RT_ELMNT');
23: hr_utility.raise_error;
24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
23: hr_utility.raise_error;
24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
53:
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
53:
54: End constraint_error;
111: Close C_Sel1;
112: --
113: -- The primary key is invalid therefore we must error
114: --
115: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
116: fnd_message.raise_error;
117: End If;
118: Close C_Sel1;
119: If (p_object_version_number
112: --
113: -- The primary key is invalid therefore we must error
114: --
115: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
116: fnd_message.raise_error;
117: End If;
118: Close C_Sel1;
119: If (p_object_version_number
120: <> pqh_rer_shd.g_old_rec.object_version_number) Then
117: End If;
118: Close C_Sel1;
119: If (p_object_version_number
120: <> pqh_rer_shd.g_old_rec.object_version_number) Then
121: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
122: fnd_message.raise_error;
123: End If;
124: l_fct_ret := true;
125: End If;
118: Close C_Sel1;
119: If (p_object_version_number
120: <> pqh_rer_shd.g_old_rec.object_version_number) Then
121: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
122: fnd_message.raise_error;
123: End If;
124: l_fct_ret := true;
125: End If;
126: End If;
175: Close C_Sel1;
176: --
177: -- The primary key is invalid therefore we must error
178: --
179: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
180: fnd_message.raise_error;
181: End If;
182: Close C_Sel1;
183: If (p_object_version_number
176: --
177: -- The primary key is invalid therefore we must error
178: --
179: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
180: fnd_message.raise_error;
181: End If;
182: Close C_Sel1;
183: If (p_object_version_number
184: <> pqh_rer_shd.g_old_rec.object_version_number) Then
181: End If;
182: Close C_Sel1;
183: If (p_object_version_number
184: <> pqh_rer_shd.g_old_rec.object_version_number) Then
185: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
186: fnd_message.raise_error;
187: End If;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: Close C_Sel1;
183: If (p_object_version_number
184: <> pqh_rer_shd.g_old_rec.object_version_number) Then
185: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
186: fnd_message.raise_error;
187: End If;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: --
195: --
196: -- The object is locked therefore we need to supply a meaningful
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'pqh_rate_element_relations');
201: fnd_message.raise_error;
202: End lck;
203: --
196: -- The object is locked therefore we need to supply a meaningful
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'pqh_rate_element_relations');
201: fnd_message.raise_error;
202: End lck;
203: --
204: -- ----------------------------------------------------------------------------
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'pqh_rate_element_relations');
201: fnd_message.raise_error;
202: End lck;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------------< convert_args >-----------------------------|