APPS.HR_QSF_SHD dependencies on HR_QUEST_FIELDS

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

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_FIELDS_FK') Then
22: fnd_message.set_name('PER', 'PER_52416_QSF_INVAL_TEMP_ID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_PK') Then
25: -- Unlikely to fail.

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

20: --
21: If (p_constraint_name = 'HR_QUEST_FIELDS_FK') Then
22: fnd_message.set_name('PER', 'PER_52416_QSF_INVAL_TEMP_ID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_PK') Then
25: -- Unlikely to fail.
26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');

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

26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then
31: fnd_message.set_name('PER', 'PER_52417_QSF_REQD_FLAG_INVAL');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_TYPE_CHK') Then
34: fnd_message.set_name('PER', 'PER_52418_QSF_TYPE_INVALID');

Line 33: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_TYPE_CHK') Then

29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then
31: fnd_message.set_name('PER', 'PER_52417_QSF_REQD_FLAG_INVAL');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_TYPE_CHK') Then
34: fnd_message.set_name('PER', 'PER_52418_QSF_TYPE_INVALID');
35: fnd_message.raise_error;
36: Else
37: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');

Line 71: from hr_quest_fields

67: object_version_number
68: ,validation_type
69: ,validation_detail
70: ,display_sequence
71: from hr_quest_fields
72: where field_id = p_field_id;
73: --
74: l_proc varchar2(72) := g_package||'api_updating';
75: l_fct_ret boolean;

Line 151: from hr_quest_fields

147: object_version_number
148: ,validation_type
149: ,validation_detail
150: ,display_sequence
151: from hr_quest_fields
152: where field_id = p_field_id
153: for update nowait;
154: --
155: l_proc varchar2(72) := g_package||'lck';

Line 197: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');

193: -- The object is locked therefore we need to supply a meaningful
194: -- error message.
195: --
196: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
197: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');
198: hr_utility.raise_error;
199: End lck;
200: --
201: -- ----------------------------------------------------------------------------