APPS.HR_QSV_SHD dependencies on HR_QUEST_ANSWER_VALUES

Line 21: If (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_FK1') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_FK1') Then
22: fnd_message.set_name('PER','PER_52443_QSV_INVAL_ANSWER_ID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_FK2') Then
25: fnd_message.set_name('PER','PER_52444_QSV_INVAL_ANSWER_FLD');

Line 24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_FK2') Then

20: --
21: If (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_FK1') Then
22: fnd_message.set_name('PER','PER_52443_QSV_INVAL_ANSWER_ID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_FK2') Then
25: fnd_message.set_name('PER','PER_52444_QSV_INVAL_ANSWER_FLD');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_PK') Then
28: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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

23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_FK2') Then
25: fnd_message.set_name('PER','PER_52444_QSV_INVAL_ANSWER_FLD');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_PK') Then
28: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','15');
31: hr_utility.raise_error;

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

28: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','15');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'HR_QUEST_ANSWER_VALUES_UK1') Then
33: fnd_message.set_name('PER','PER_52445_QSV_ANSWER_EXISTS');
34: fnd_message.raise_error;
35: Else
36: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');

Line 64: from hr_quest_answer_values

60: questionnaire_answer_id,
61: field_id,
62: object_version_number,
63: value
64: from hr_quest_answer_values
65: where quest_answer_val_id = p_quest_answer_val_id;
66: --
67: l_proc varchar2(72) := g_package||'api_updating';
68: l_fct_ret boolean;

Line 138: from hr_quest_answer_values

134: questionnaire_answer_id,
135: field_id,
136: object_version_number,
137: value
138: from hr_quest_answer_values
139: where quest_answer_val_id = p_quest_answer_val_id
140: for update nowait;
141: --
142: l_proc varchar2(72) := g_package||'lck';

Line 191: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answer_values');

187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
191: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answer_values');
192: hr_utility.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------