eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APT_SHD dependencies on PER_APPRAISAL_TEMPLATES

Line 20: If (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK1') Then

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

Line 25: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK2') Then

21: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;
25: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK2') Then
26: hr_utility.set_message(801, 'HR_51912_APT_AST_NOT_EXIST');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;

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

26: hr_utility.set_message(801, 'HR_51912_APT_AST_NOT_EXIST');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK3') Then
31: hr_utility.set_message(801, 'HR_51928_APT_RSC_NOT_EXIST');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;

Line 35: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK4') Then

31: hr_utility.set_message(801, 'HR_51928_APT_RSC_NOT_EXIST');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;
35: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK4') Then
36: hr_utility.set_message(801, 'HR_51915_APT_QST_NOT_EXIST');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','20');
39: hr_utility.raise_error;

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

36: hr_utility.set_message(801, 'HR_51915_APT_QST_NOT_EXIST');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','20');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK5') Then
41: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','25');
44: fnd_message.raise_error;

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

41: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','25');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK6') Then
46: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','30');
49: fnd_message.raise_error;

Line 50: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_PK') Then

46: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','30');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_PK') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','25');
54: hr_utility.raise_error;

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

51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','25');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_UK2') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','30');
59: hr_utility.raise_error;

Line 145: from per_appraisal_templates

141: ,show_term_contigent
142: ,disp_term_emp_period_from
143: ,show_future_term_employee
144:
145: from per_appraisal_templates
146: where appraisal_template_id = p_appraisal_template_id;
147:
148: l_proc varchar2(72) := g_package||'api_updating';
149: l_fct_ret boolean;

Line 275: from per_appraisal_templates

271: ,show_term_contigent
272: ,disp_term_emp_period_from
273: ,show_future_term_employee
274:
275: from per_appraisal_templates
276: where appraisal_template_id = p_appraisal_template_id
277: for update nowait;
278:
279: l_proc varchar2(72) := g_package||'lck';

Line 318: hr_utility.set_message_token('TABLE_NAME', 'per_appraisal_templates');

314: -- The object is locked therefore we need to supply a meaningful
315: -- error message.
316:
317: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
318: hr_utility.set_message_token('TABLE_NAME', 'per_appraisal_templates');
319: hr_utility.raise_error;
320: End lck;
321:
322: -- ---------------------------------------------------------------------------+