APPS.PER_CPN_SHD dependencies on PER_COMPETENCES

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

18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: hr_utility.set_location(p_constraint_name,9999);
21: --
22: If (p_constraint_name = 'PER_COMPETENCES_FK1') Then
23: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;

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

23: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_COMPETENCES_FK2') Then
28: hr_utility.set_message(801, 'HR_51452_COMP_RAT_SC_NOT_EXIST');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_COMPETENCES_PK') Then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 30: ElsIf (p_constraint_name = 'PER_COMPETENCES_PK') Then

26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_COMPETENCES_FK2') Then
28: hr_utility.set_message(801, 'HR_51452_COMP_RAT_SC_NOT_EXIST');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_COMPETENCES_PK') Then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;

Line 37: --ElsIf (p_constraint_name = 'PER_COMPETENCES_UK2') Then

33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;
35: --
36: -- pmfletch - Replaced with procedure chk_definition_id
37: --ElsIf (p_constraint_name = 'PER_COMPETENCES_UK2') Then
38: -- hr_utility.set_message(801, 'HR_51436_COMP_NOT_UNIQUE');
39: -- hr_utility.raise_error;
40: --
41: ElsIf (p_constraint_name = 'PER_CPN_CERT_REQ_CHK') Then

Line 52: -- ElsIf (p_constraint_name = 'PER_COMPETENCES_UK3') Then

48: hr_utility.raise_error;
49: --
50: -- pmfletch Replaced with procedure chk_alias in TL row handler
51: -- -- ngundura changes done for pa requirements
52: -- ElsIf (p_constraint_name = 'PER_COMPETENCES_UK3') Then
53: -- fnd_message.set_name('PER', 'HR_52700_ALIAS_NOT_UNIQUE');
54: -- --hr_utility.set_message_token('PROCEDURE', l_proc);
55: -- --hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
56: -- fnd_message.raise_error;

Line 151: from per_competences

147: ,information17
148: ,information18
149: ,information19
150: ,information20
151: from per_competences
152: where competence_id = p_competence_id;
153: --
154: l_proc varchar2(72) := g_package||'api_updating';
155: l_fct_ret boolean;

Line 289: from per_competences

285: ,information17
286: ,information18
287: ,information19
288: ,information20
289: from per_competences
290: where competence_id = p_competence_id
291: for update nowait;
292: --
293: l_proc varchar2(72) := g_package||'lck';

Line 332: hr_utility.set_message_token('TABLE_NAME', 'per_competences');

328: -- The object is locked therefore we need to supply a meaningful
329: -- error message.
330: --
331: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
332: hr_utility.set_message_token('TABLE_NAME', 'per_competences');
333: hr_utility.raise_error;
334: End lck;
335: --
336: -- ----------------------------------------------------------------------------