APPS.PER_ELC_SHD dependencies on PER_ELECTIONS

Line 36: If (p_constraint_name = 'PER_ELECTIONS_FK1') Then

32: l_proc varchar2(72) := g_package||'constraint_error';
33: --
34: Begin
35: --
36: If (p_constraint_name = 'PER_ELECTIONS_FK1') Then
37: fnd_message.set_name('PER', 'PER_289093_ELC_FK1_INVALID');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'PER_ELECTIONS_FK2') Then

37: fnd_message.set_name('PER', 'PER_289093_ELC_FK1_INVALID');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTIONS_FK2') Then
42: fnd_message.set_name('PER', 'PER_289094_ELC_FK2_INVALID');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 46: ElsIf (p_constraint_name = 'PER_ELECTIONS_PK') Then

42: fnd_message.set_name('PER', 'PER_289094_ELC_FK2_INVALID');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTIONS_PK') Then
47: fnd_message.set_name('PER', 'PER_289095_ELC_PK_INVALID');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;

Line 147: from per_elections

143: ,election_information28
144: ,election_information29
145: ,election_information30
146: ,object_version_number
147: from per_elections
148: where election_id = p_election_id;
149: --
150: l_fct_ret boolean;
151: --

Line 284: from per_elections

280: ,election_information28
281: ,election_information29
282: ,election_information30
283: ,object_version_number
284: from per_elections
285: where election_id = p_election_id
286: for update nowait;
287: --
288: l_proc varchar2(72) := g_package||'lck';

Line 327: fnd_message.set_token('TABLE_NAME', 'per_elections');

323: -- The object is locked therefore we need to supply a meaningful
324: -- error message.
325: --
326: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
327: fnd_message.set_token('TABLE_NAME', 'per_elections');
328: fnd_message.raise_error;
329: End lck;
330: --
331: -- ----------------------------------------------------------------------------