97: --
98: Begin
99: --
100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
98: Begin
99: --
100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: --
100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;
126: --
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;
126: --
127: End constraint_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;
126: --
127: End constraint_error;
128: --
184: Close C_Sel1;
185: --
186: -- The primary key is invalid therefore we must error
187: --
188: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
189: fnd_message.raise_error;
190: End If;
191: Close C_Sel1;
192: If (p_object_version_number
185: --
186: -- The primary key is invalid therefore we must error
187: --
188: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
189: fnd_message.raise_error;
190: End If;
191: Close C_Sel1;
192: If (p_object_version_number
193: <> pay_put_shd.g_old_rec.object_version_number) Then
190: End If;
191: Close C_Sel1;
192: If (p_object_version_number
193: <> pay_put_shd.g_old_rec.object_version_number) Then
194: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
195: fnd_message.raise_error;
196: End If;
197: l_fct_ret := true;
198: End If;
191: Close C_Sel1;
192: If (p_object_version_number
193: <> pay_put_shd.g_old_rec.object_version_number) Then
194: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
195: fnd_message.raise_error;
196: End If;
197: l_fct_ret := true;
198: End If;
199: End If;
248: Close C_Sel1;
249: --
250: -- The primary key is invalid therefore we must error
251: --
252: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
249: --
250: -- The primary key is invalid therefore we must error
251: --
252: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
257: <> pay_put_shd.g_old_rec.object_version_number) Then
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
257: <> pay_put_shd.g_old_rec.object_version_number) Then
258: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
259: fnd_message.raise_error;
260: End If;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: Close C_Sel1;
256: If (p_object_version_number
257: <> pay_put_shd.g_old_rec.object_version_number) Then
258: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
259: fnd_message.raise_error;
260: End If;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: --
268: --
269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'pay_user_tables');
274: fnd_message.raise_error;
275: End lck;
276: --
269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'pay_user_tables');
274: fnd_message.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'pay_user_tables');
274: fnd_message.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |-----------------------------< convert_args >-----------------------------|