DBA Data[Home] [Help]

APPS.HR_QSV_INS dependencies on HR_UTILITY

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

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_qsv_ins.g_quest_answer_val_id_i := p_quest_answer_val_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_qsv_ins.g_quest_answer_val_id_i := p_quest_answer_val_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|

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

75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: -- Insert the row into: hr_quest_answer_values
83: --

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

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

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

163: from hr_quest_answer_values
164: where quest_answer_val_id = hr_qsv_ins.g_quest_answer_val_id_i;
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: if hr_qsv_ins.g_quest_answer_val_id_i is not null then
170: --
171: -- Verify registered primary key values not already in use

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

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

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

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

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

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

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

268: --
269: l_proc varchar2(72) := g_package||'ins';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Call the supporting insert validate operations
275: --
276: hr_qsv_bus.insert_validate(p_rec);

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

303: l_rec hr_qsv_shd.g_rec_type;
304: l_proc varchar2(72) := g_package||'ins';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- Call conversion function to turn arguments into the
310: -- p_rec structure.
311: --

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

329: --
330: p_quest_answer_val_id := l_rec.quest_answer_val_id;
331: p_object_version_number := l_rec.object_version_number;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: End ins;
335: --
336: end hr_qsv_ins;