DBA Data[Home] [Help]

APPS.HR_QSA_INS dependencies on HR_UTILITY

Line 23: hr_utility.set_location('Entering:'||l_proc, 10);

19: --
20: l_proc varchar2(72) := g_package||'set_base_key_value';
21: --
22: Begin
23: hr_utility.set_location('Entering:'||l_proc, 10);
24: --
25: hr_qsa_ins.g_questionnaire_answer_id_i := p_questionnaire_answer_id;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 27: hr_utility.set_location(' Leaving:'||l_proc, 20);

23: hr_utility.set_location('Entering:'||l_proc, 10);
24: --
25: hr_qsa_ins.g_questionnaire_answer_id_i := p_questionnaire_answer_id;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 20);
28: End set_base_key_value;
29: --
30: -- ----------------------------------------------------------------------------
31: -- |------------------------------< insert_dml >------------------------------|

Line 78: hr_utility.set_location('Entering:'||l_proc, 5);

74: --
75: l_proc varchar2(72) := g_package||'insert_dml';
76: --
77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: --
80: --
81: -- Insert the row into: hr_quest_answers
82: --

Line 98: hr_utility.set_location(' Leaving:'||l_proc, 10);

94: p_rec.type_object_id,
95: p_rec.business_group_id
96: );
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 10);
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: hr_qsa_shd.constraint_error

Line 166: hr_utility.set_location('Entering:'||l_proc, 5);

162: from hr_quest_answers
163: where questionnaire_answer_id = hr_qsa_ins.g_questionnaire_answer_id_i;
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: if hr_qsa_ins.g_questionnaire_answer_id_i is not null then
169: --
170: -- Verify registered primary key values not already in use

Line 199: hr_utility.set_location(' Leaving:'||l_proc, 10);

195: Close C_Sel1;
196: --
197: end if;
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: End pre_insert;
201: --
202: -- ----------------------------------------------------------------------------
203: -- |-----------------------------< post_insert >------------------------------|

Line 241: hr_utility.set_location('Entering: '||l_proc, 5);

237: --
238: l_proc varchar2(72) := g_package||'post_insert';
239: --
240: Begin
241: hr_utility.set_location('Entering: '||l_proc, 5);
242: --
243: begin
244: hr_qsa_rki.after_insert
245: (p_questionnaire_answer_id => p_rec.questionnaire_answer_id

Line 260: hr_utility.set_location(' Leaving:'||l_proc, 10);

256: ,p_hook_type => 'AI'
257: );
258: end;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End post_insert;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |---------------------------------< ins >----------------------------------|

Line 275: hr_utility.set_location('Entering:'||l_proc, 5);

271: --
272: l_proc varchar2(72) := g_package||'ins';
273: --
274: Begin
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: --
277: -- Call the supporting insert validate operations
278: --
279: hr_qsa_bus.insert_validate(p_rec, p_effective_date);

Line 311: hr_utility.set_location('Entering:'||l_proc, 5);

307: l_rec hr_qsa_shd.g_rec_type;
308: l_proc varchar2(72) := g_package||'ins';
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: -- Call conversion function to turn arguments into the
314: -- p_rec structure.
315: --

Line 337: hr_utility.set_location(' Leaving:'||l_proc, 10);

333: --
334: p_questionnaire_answer_id := l_rec.questionnaire_answer_id;
335: --
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 10);
338: End ins;
339: --
340: end hr_qsa_ins;