APPS.FF_FFP_SHD dependencies on FF_FUNCTION_PARAMETERS

Line 55: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_FK1') Then

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;
59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then

Line 59: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_PK') Then

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');
63: fnd_message.raise_error;

Line 64: ElsIf (p_constraint_name = 'FF_FUNCTION_PARAMETERS_UK2') 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
68: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 99: from ff_function_parameters

95: ,data_type
96: ,name
97: ,optional
98: ,object_version_number
99: from ff_function_parameters
100: where function_id = p_function_id
101: and sequence_number = p_sequence_number;
102: --
103: l_fct_ret boolean;

Line 177: from ff_function_parameters

173: ,data_type
174: ,name
175: ,optional
176: ,object_version_number
177: from ff_function_parameters
178: where function_id = p_function_id
179: and sequence_number = p_sequence_number
180: for update nowait;
181: --

Line 233: fnd_message.set_token('TABLE_NAME', 'ff_function_parameters');

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: -- ----------------------------------------------------------------------------