29: --
30: Begin
31: --
32: If (p_constraint_name = 'FF_FP_CLASS_CHK') Then
33: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
34: fnd_message.set_token('COLUMN', 'CLASS');
35: fnd_message.set_token('LOOKUP_TYPE','PARAMETER_CLASS');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
30: Begin
31: --
32: If (p_constraint_name = 'FF_FP_CLASS_CHK') Then
33: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
34: fnd_message.set_token('COLUMN', 'CLASS');
35: fnd_message.set_token('LOOKUP_TYPE','PARAMETER_CLASS');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: --
32: If (p_constraint_name = 'FF_FP_CLASS_CHK') Then
33: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
34: fnd_message.set_token('COLUMN', 'CLASS');
35: fnd_message.set_token('LOOKUP_TYPE','PARAMETER_CLASS');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: If (p_constraint_name = 'FF_FP_CLASS_CHK') Then
33: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
34: fnd_message.set_token('COLUMN', 'CLASS');
35: fnd_message.set_token('LOOKUP_TYPE','PARAMETER_CLASS');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','35');
34: fnd_message.set_token('COLUMN', 'CLASS');
35: fnd_message.set_token('LOOKUP_TYPE','PARAMETER_CLASS');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','35');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_FP_CONTINUING_PARAMETER_CHK') Then
35: fnd_message.set_token('LOOKUP_TYPE','PARAMETER_CLASS');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','35');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_FP_CONTINUING_PARAMETER_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','35');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_FP_CONTINUING_PARAMETER_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME', 'Continuing Parameter');
37: ElsIf (p_constraint_name = 'FF_FP_CLASS_RULE_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','35');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_FP_CONTINUING_PARAMETER_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME', 'Continuing Parameter');
45: fnd_message.raise_error;
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','35');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_FP_CONTINUING_PARAMETER_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME', 'Continuing Parameter');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'FF_FP_DATA_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
40: fnd_message.set_token('STEP','35');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_FP_CONTINUING_PARAMETER_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME', 'Continuing Parameter');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'FF_FP_DATA_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
48: fnd_message.set_token('COLUMN', 'DATA_TYPE');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_FP_CONTINUING_PARAMETER_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME', 'Continuing Parameter');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'FF_FP_DATA_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
48: fnd_message.set_token('COLUMN', 'DATA_TYPE');
49: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME', 'Continuing Parameter');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'FF_FP_DATA_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
48: fnd_message.set_token('COLUMN', 'DATA_TYPE');
49: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'FF_FP_OPTIONAL_CHK') Then
44: fnd_message.set_token('COLUMN_NAME', 'Continuing Parameter');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'FF_FP_DATA_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
48: fnd_message.set_token('COLUMN', 'DATA_TYPE');
49: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'FF_FP_OPTIONAL_CHK') Then
52: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'FF_FP_DATA_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
48: fnd_message.set_token('COLUMN', 'DATA_TYPE');
49: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'FF_FP_OPTIONAL_CHK') Then
52: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
53: fnd_message.set_token('COLUMN_NAME', 'Optional');
46: ElsIf (p_constraint_name = 'FF_FP_DATA_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
48: fnd_message.set_token('COLUMN', 'DATA_TYPE');
49: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'FF_FP_OPTIONAL_CHK') Then
52: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
53: fnd_message.set_token('COLUMN_NAME', 'Optional');
54: fnd_message.raise_error;
48: fnd_message.set_token('COLUMN', 'DATA_TYPE');
49: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'FF_FP_OPTIONAL_CHK') Then
52: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
53: fnd_message.set_token('COLUMN_NAME', 'Optional');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_FK1') Then
56: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
49: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'FF_FP_OPTIONAL_CHK') Then
52: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
53: fnd_message.set_token('COLUMN_NAME', 'Optional');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_FK1') Then
56: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
57: fnd_message.set_token('PARENT' , 'Function Id' );
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'FF_FP_OPTIONAL_CHK') Then
52: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
53: fnd_message.set_token('COLUMN_NAME', 'Optional');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_FK1') Then
56: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
57: fnd_message.set_token('PARENT' , 'Function Id' );
58: fnd_message.raise_error;
52: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
53: fnd_message.set_token('COLUMN_NAME', 'Optional');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_FK1') Then
56: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
57: fnd_message.set_token('PARENT' , 'Function Id' );
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then
60: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('COLUMN_NAME', 'Optional');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_FK1') Then
56: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
57: fnd_message.set_token('PARENT' , 'Function Id' );
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then
60: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
61: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_FK1') Then
56: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
57: fnd_message.set_token('PARENT' , 'Function Id' );
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then
60: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('STEP','35');
56: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
57: fnd_message.set_token('PARENT' , 'Function Id' );
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then
60: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('STEP','35');
63: fnd_message.raise_error;
64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') Then
57: fnd_message.set_token('PARENT' , 'Function Id' );
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then
60: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('STEP','35');
63: fnd_message.raise_error;
64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') Then
65: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then
60: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('STEP','35');
63: fnd_message.raise_error;
64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') Then
65: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
66: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then
60: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('STEP','35');
63: fnd_message.raise_error;
64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') Then
65: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
66: fnd_message.raise_error;
67: Else
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('STEP','35');
63: fnd_message.raise_error;
64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') Then
65: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
66: fnd_message.raise_error;
67: Else
68: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
69: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('STEP','35');
63: fnd_message.raise_error;
64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') Then
65: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
66: fnd_message.raise_error;
67: Else
68: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') Then
65: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
66: fnd_message.raise_error;
67: Else
68: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
71: fnd_message.raise_error;
72: End If;
65: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
66: fnd_message.raise_error;
67: Else
68: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
71: fnd_message.raise_error;
72: End If;
73: --
66: fnd_message.raise_error;
67: Else
68: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
71: fnd_message.raise_error;
72: End If;
73: --
74: End constraint_error;
67: Else
68: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
71: fnd_message.raise_error;
72: End If;
73: --
74: End constraint_error;
75: --
136: Close C_Sel1;
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: If (p_object_version_number
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: If (p_object_version_number
145: <> ff_ffp_shd.g_old_rec.object_version_number) Then
142: End If;
143: Close C_Sel1;
144: If (p_object_version_number
145: <> ff_ffp_shd.g_old_rec.object_version_number) Then
146: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
147: fnd_message.raise_error;
148: End If;
149: l_fct_ret := true;
150: End If;
143: Close C_Sel1;
144: If (p_object_version_number
145: <> ff_ffp_shd.g_old_rec.object_version_number) Then
146: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
147: fnd_message.raise_error;
148: End If;
149: l_fct_ret := true;
150: End If;
151: End If;
208: Close C_Sel1;
209: --
210: -- The primary key is invalid therefore we must error
211: --
212: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
213: fnd_message.raise_error;
214: End If;
215: Close C_Sel1;
216: If (p_object_version_number
209: --
210: -- The primary key is invalid therefore we must error
211: --
212: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
213: fnd_message.raise_error;
214: End If;
215: Close C_Sel1;
216: If (p_object_version_number
217: <> ff_ffp_shd.g_old_rec.object_version_number) Then
214: End If;
215: Close C_Sel1;
216: If (p_object_version_number
217: <> ff_ffp_shd.g_old_rec.object_version_number) Then
218: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
219: fnd_message.raise_error;
220: End If;
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: Close C_Sel1;
216: If (p_object_version_number
217: <> ff_ffp_shd.g_old_rec.object_version_number) Then
218: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
219: fnd_message.raise_error;
220: End If;
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
223: --
228: --
229: -- The object is locked therefore we need to supply a meaningful
230: -- error message.
231: --
232: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
233: fnd_message.set_token('TABLE_NAME', 'ff_function_parameters');
234: fnd_message.raise_error;
235: End lck;
236: --
229: -- The object is locked therefore we need to supply a meaningful
230: -- error message.
231: --
232: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
233: fnd_message.set_token('TABLE_NAME', 'ff_function_parameters');
234: fnd_message.raise_error;
235: End lck;
236: --
237: -- ----------------------------------------------------------------------------
230: -- error message.
231: --
232: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
233: fnd_message.set_token('TABLE_NAME', 'ff_function_parameters');
234: fnd_message.raise_error;
235: End lck;
236: --
237: -- ----------------------------------------------------------------------------
238: -- |-----------------------------< convert_args >-----------------------------|