APPS.FF_FCU_SHD dependencies on FF_FUNCTION_CONTEXT_USAGES

Line 32: If (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_FK1') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_FK1') Then
33: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
34: fnd_message.set_token('PARENT' , 'Function Id' );
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_FK2') Then

Line 36: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_FK2') Then

32: If (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_FK1') Then
33: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
34: fnd_message.set_token('PARENT' , 'Function Id' );
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_FK2') Then
37: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
38: fnd_message.set_token('COLUMN_NAME', 'Context');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_PK') Then

Line 40: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_PK') Then

36: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_FK2') Then
37: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
38: fnd_message.set_token('COLUMN_NAME', 'Context');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','15');
44: fnd_message.raise_error;

Line 45: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_UK2') Then

41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','15');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'FF_FUNCTION_CONTEXT_USAGES_UK2') Then
46: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
47: fnd_message.raise_error;
48: Else
49: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 76: from ff_function_context_usages

72: function_id
73: ,sequence_number
74: ,context_id
75: ,object_version_number
76: from ff_function_context_usages
77: where function_id = p_function_id
78: and sequence_number = p_sequence_number;
79: --
80:

Line 152: from ff_function_context_usages

148: function_id
149: ,sequence_number
150: ,context_id
151: ,object_version_number
152: from ff_function_context_usages
153: where function_id = p_function_id
154: and sequence_number = p_sequence_number
155: for update nowait;
156: --

Line 208: fnd_message.set_token('TABLE_NAME', 'ff_function_context_usages');

204: -- The object is locked therefore we need to supply a meaningful
205: -- error message.
206: --
207: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
208: fnd_message.set_token('TABLE_NAME', 'ff_function_context_usages');
209: fnd_message.raise_error;
210: End lck;
211: --
212: -- ----------------------------------------------------------------------------