APPS.PER_BBT_SHD dependencies on PER_BF_BALANCE_TYPES

Line 22: If (p_constraint_name = 'PER_BF_BALANCE_TYPES_FK1') Then

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_BF_BALANCE_TYPES_FK1') Then
23: fnd_message.set_name('PER', 'PER_289357_BF_BG_ID_INVALID');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 27: ElsIf (p_constraint_name = 'PER_BF_BALANCE_TYPES_PK') Then

23: fnd_message.set_name('PER', 'PER_289357_BF_BG_ID_INVALID');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_BALANCE_TYPES_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;

Line 32: ElsIf (p_constraint_name = 'PER_BF_BALANCE_TYPES_UK1') Then

28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_BALANCE_TYPES_UK1') Then
33: fnd_message.set_name('PER', 'HR_52611_DISPLAYED_NOT_UNQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','10');
36: fnd_message.raise_error;

Line 37: ElsIf (p_constraint_name = 'PER_BF_BALANCE_TYPES_UK2') Then

33: fnd_message.set_name('PER', 'HR_52611_DISPLAYED_NOT_UNQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','10');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_BALANCE_TYPES_UK2') Then
38: fnd_message.set_name('PER', 'HR_52613_INTERNAL_NOT_UNQ');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;

Line 77: from per_bf_balance_types

73: ,category
74: ,date_from
75: ,date_to
76: ,object_version_number
77: from per_bf_balance_types
78: where balance_type_id = p_balance_type_id;
79: --
80: l_proc varchar2(72) := g_package||'api_updating';
81: l_fct_ret boolean;

Line 155: from per_bf_balance_types

151: ,category
152: ,date_from
153: ,date_to
154: ,object_version_number
155: from per_bf_balance_types
156: where balance_type_id = p_balance_type_id
157: for update nowait;
158: --
159: l_proc varchar2(72) := g_package||'lck';

Line 202: fnd_message.set_token('TABLE_NAME', 'per_bf_balance_types');

198: -- The object is locked therefore we need to supply a meaningful
199: -- error message.
200: --
201: fnd_message.set_name('PER', 'HR_7165_OBJECT_LOCKED');
202: fnd_message.set_token('TABLE_NAME', 'per_bf_balance_types');
203: fnd_message.raise_error;
204: End lck;
205: --
206: -- ----------------------------------------------------------------------------