DBA Data[Home] [Help]

APPS.PQH_OPG_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: pqh_opg_ins.g_operation_group_id_i := p_operation_group_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: pqh_opg_ins.g_operation_group_id_i := p_operation_group_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

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

78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --

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

102: );
103: --
104: --
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --

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

177: l_proc varchar2(72) := g_package||'pre_insert';
178: l_exists varchar2(1);
179: --
180: Begin
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: If (pqh_opg_ins.g_operation_group_id_i is not null) Then
184: --
185: -- Verify registered primary key values not already in use

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

213: Fetch C_Sel1 Into p_rec.operation_group_id;
214: Close C_Sel1;
215: End If;
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: End pre_insert;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |-----------------------------< post_insert >------------------------------|

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

256: --
257: l_proc varchar2(72) := g_package||'post_insert';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: begin
262: --
263: pqh_opg_rki.after_insert
264: (p_effective_date => p_effective_date

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

283: ,p_hook_type => 'AI');
284: --
285: end;
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End post_insert;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------------< ins >----------------------------------|

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

297: --
298: l_proc varchar2(72) := g_package||'ins';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Call the supporting insert validate operations
304: --
305:

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

333: --
334: -- Call to raise any errors on multi-message list
335: hr_multi_message.end_validation_set;
336: --
337: hr_utility.set_location('Leaving:'||l_proc, 20);
338: end ins;
339: --
340: -- ----------------------------------------------------------------------------
341: -- |---------------------------------< ins >----------------------------------|

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

352: l_rec pqh_opg_shd.g_rec_type;
353: l_proc varchar2(72) := g_package||'ins';
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: -- Call conversion function to turn arguments into the
359: -- p_rec structure.
360: --

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

380: --
381: p_operation_group_id := l_rec.operation_group_id;
382: p_object_version_number := l_rec.object_version_number;
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 10);
385: End ins;
386: --
387: end pqh_opg_ins;