30: Begin
31: l_proc := g_package||'constraint_error';
32: --
33: If (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK1') Then
34: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
31: l_proc := g_package||'constraint_error';
32: --
33: If (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK1') Then
34: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
33: If (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK1') Then
34: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
34: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
67: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
67: fnd_message.raise_error;
68: Else
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;
74: --
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;
74: --
75: End constraint_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;
74: --
75: End constraint_error;
76: --
139: Close C_Sel1;
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: End If;
146: Close C_Sel1;
147: If (p_object_version_number
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: End If;
146: Close C_Sel1;
147: If (p_object_version_number
148: <> pay_amp_shd.g_old_rec.object_version_number) Then
145: End If;
146: Close C_Sel1;
147: If (p_object_version_number
148: <> pay_amp_shd.g_old_rec.object_version_number) Then
149: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
150: fnd_message.raise_error;
151: End If;
152: l_fct_ret := true;
153: End If;
146: Close C_Sel1;
147: If (p_object_version_number
148: <> pay_amp_shd.g_old_rec.object_version_number) Then
149: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
150: fnd_message.raise_error;
151: End If;
152: l_fct_ret := true;
153: End If;
154: End If;
212: Close C_Sel1;
213: --
214: -- The primary key is invalid therefore we must error
215: --
216: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
217: fnd_message.raise_error;
218: End If;
219: Close C_Sel1;
220: If (p_object_version_number
213: --
214: -- The primary key is invalid therefore we must error
215: --
216: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
217: fnd_message.raise_error;
218: End If;
219: Close C_Sel1;
220: If (p_object_version_number
221: <> pay_amp_shd.g_old_rec.object_version_number) Then
218: End If;
219: Close C_Sel1;
220: If (p_object_version_number
221: <> pay_amp_shd.g_old_rec.object_version_number) Then
222: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
223: fnd_message.raise_error;
224: End If;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: Close C_Sel1;
220: If (p_object_version_number
221: <> pay_amp_shd.g_old_rec.object_version_number) Then
222: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
223: fnd_message.raise_error;
224: End If;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: --
232: --
233: -- The object is locked therefore we need to supply a meaningful
234: -- error message.
235: --
236: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
237: fnd_message.set_token('TABLE_NAME', 'pay_au_module_parameters');
238: fnd_message.raise_error;
239: End lck;
240: --
233: -- The object is locked therefore we need to supply a meaningful
234: -- error message.
235: --
236: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
237: fnd_message.set_token('TABLE_NAME', 'pay_au_module_parameters');
238: fnd_message.raise_error;
239: End lck;
240: --
241: -- ----------------------------------------------------------------------------
234: -- error message.
235: --
236: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
237: fnd_message.set_token('TABLE_NAME', 'pay_au_module_parameters');
238: fnd_message.raise_error;
239: End lck;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |-----------------------------< convert_args >-----------------------------|