31: --
32: l_proc := g_package||'constraint_error';
33: --
34: If (p_constraint_name = 'PAY_AU_PROCESS_MODULES_CHK1') Then
35: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK1') Then
38: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
39: fnd_message.raise_error;
32: l_proc := g_package||'constraint_error';
33: --
34: If (p_constraint_name = 'PAY_AU_PROCESS_MODULES_CHK1') Then
35: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK1') Then
38: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK2') Then
34: If (p_constraint_name = 'PAY_AU_PROCESS_MODULES_CHK1') Then
35: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK1') Then
38: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK2') Then
41: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
42: fnd_message.raise_error;
35: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK1') Then
38: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK2') Then
41: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_PK') Then
37: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK1') Then
38: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK2') Then
41: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK2') Then
41: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','20');
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_FK2') Then
41: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','20');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_UK1') Then
41: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','20');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_UK1') Then
49: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','20');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_UK1') Then
49: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
50: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','20');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_UK1') Then
49: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
50: fnd_message.raise_error;
51: Else
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','20');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_UK1') Then
49: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','20');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_UK1') Then
49: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
48: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_MODULES_UK1') Then
49: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
49: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
58: End constraint_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
58: End constraint_error;
59: --
113: Close C_Sel1;
114: --
115: -- The primary key is invalid therefore we must error
116: --
117: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
118: fnd_message.raise_error;
119: End If;
120: Close C_Sel1;
121: If (p_object_version_number
114: --
115: -- The primary key is invalid therefore we must error
116: --
117: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
118: fnd_message.raise_error;
119: End If;
120: Close C_Sel1;
121: If (p_object_version_number
122: <> pay_apm_shd.g_old_rec.object_version_number) Then
119: End If;
120: Close C_Sel1;
121: If (p_object_version_number
122: <> pay_apm_shd.g_old_rec.object_version_number) Then
123: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
124: fnd_message.raise_error;
125: End If;
126: l_fct_ret := true;
127: End If;
120: Close C_Sel1;
121: If (p_object_version_number
122: <> pay_apm_shd.g_old_rec.object_version_number) Then
123: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
124: fnd_message.raise_error;
125: End If;
126: l_fct_ret := true;
127: End If;
128: End If;
177: Close C_Sel1;
178: --
179: -- The primary key is invalid therefore we must error
180: --
181: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
182: fnd_message.raise_error;
183: End If;
184: Close C_Sel1;
185: If (p_object_version_number
178: --
179: -- The primary key is invalid therefore we must error
180: --
181: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
182: fnd_message.raise_error;
183: End If;
184: Close C_Sel1;
185: If (p_object_version_number
186: <> pay_apm_shd.g_old_rec.object_version_number) Then
183: End If;
184: Close C_Sel1;
185: If (p_object_version_number
186: <> pay_apm_shd.g_old_rec.object_version_number) Then
187: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
188: fnd_message.raise_error;
189: End If;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
184: Close C_Sel1;
185: If (p_object_version_number
186: <> pay_apm_shd.g_old_rec.object_version_number) Then
187: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
188: fnd_message.raise_error;
189: End If;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: --
197: --
198: -- The object is locked therefore we need to supply a meaningful
199: -- error message.
200: --
201: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
202: fnd_message.set_token('TABLE_NAME', 'pay_au_process_modules');
203: fnd_message.raise_error;
204: End lck;
205: --
198: -- The object is locked therefore we need to supply a meaningful
199: -- error message.
200: --
201: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
202: fnd_message.set_token('TABLE_NAME', 'pay_au_process_modules');
203: fnd_message.raise_error;
204: End lck;
205: --
206: -- ----------------------------------------------------------------------------
199: -- error message.
200: --
201: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
202: fnd_message.set_token('TABLE_NAME', 'pay_au_process_modules');
203: fnd_message.raise_error;
204: End lck;
205: --
206: -- ----------------------------------------------------------------------------
207: -- |-----------------------------< convert_args >-----------------------------|