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;
45: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK6') Then
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;
45: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_FK6') Then
46: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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;
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);
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;
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');
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;
50: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_PK') Then
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;
50: ElsIf (p_constraint_name = 'PER_APPRAISAL_TEMPLATES_PK') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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;
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);
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;
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');