DBA Data[Home] [Help]

APPS.PQH_RAP_INS dependencies on HR_UTILITY

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

21: l_proc constant varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24:
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: pqh_rap_ins.g_rank_process_approval_id_i := p_rank_process_approval_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: pqh_rap_ins.g_rank_process_approval_id_i := p_rank_process_approval_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --
32: --
33: -- ----------------------------------------------------------------------------

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

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

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

110: );
111: --
112: --
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --

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

186: l_exists varchar2(1);
187: --
188: Begin
189:
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: If (pqh_rap_ins.g_rank_process_approval_id_i is not null) Then
193: --
194: -- Verify registered primary key values not already in use

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

222: Fetch C_Sel1 Into p_rec.rank_process_approval_id;
223: Close C_Sel1;
224: End If;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: End pre_insert;
228: --
229: -- ----------------------------------------------------------------------------
230: -- |-----------------------------< post_insert >------------------------------|

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

266: l_proc constant varchar2(72):= g_package||'post_insert';
267: --
268: Begin
269:
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: begin
272: --
273: pqh_rap_rki.after_insert
274: (p_effective_date => p_effective_date

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

299: ,p_hook_type => 'AI');
300: --
301: end;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: End post_insert;
305: --
306: -- ----------------------------------------------------------------------------
307: -- |---------------------------------< ins >----------------------------------|

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

314: l_proc constant varchar2(72):= g_package||'ins';
315: --
316: Begin
317:
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- Call the supporting insert validate operations
321: --
322: pqh_rap_bus.insert_validate

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

344: --
345: -- Call to raise any errors on multi-message list
346: hr_multi_message.end_validation_set;
347: --
348: hr_utility.set_location('Leaving:'||l_proc, 20);
349: end ins;
350: --
351: -- ----------------------------------------------------------------------------
352: -- |---------------------------------< ins >----------------------------------|

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

367: l_proc constant varchar2(72):= g_package||'ins';
368: --
369: Begin
370:
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: -- Call conversion function to turn arguments into the
374: -- p_rec structure.
375: --

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

398: --
399: p_rank_process_approval_id := l_rec.rank_process_approval_id;
400: p_object_version_number := l_rec.object_version_number;
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End ins;
404: --
405: end pqh_rap_ins;