APPS.OTA_FNS_INS dependencies on HR_UTILITY

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

24: --
25: l_proc varchar2(72) := g_package||'set_base_key_value';
26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_fns_ins.g_forum_id_i := p_forum_id;
31: ota_fns_ins.g_person_id_i := p_person_id;
32: ota_fns_ins.g_contact_id_i := p_contact_id;

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

30: ota_fns_ins.g_forum_id_i := p_forum_id;
31: ota_fns_ins.g_person_id_i := p_person_id;
32: ota_fns_ins.g_contact_id_i := p_contact_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --
37: --
38: -- ----------------------------------------------------------------------------

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

84: --
85: l_proc varchar2(72) := g_package||'insert_dml';
86: --
87: Begin
88: hr_utility.set_location('Entering:'||l_proc, 5);
89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: ota_fns_shd.g_api_dml := true; -- Set the api dml status
92: --

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

108: );
109: --
110: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

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

188: l_proc varchar2(72) := g_package||'pre_insert';
189: l_exists varchar2(1);
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: /*
195: If (ota_fns_ins.g_forum_id_i is not null or
196: ota_fns_ins.g_person_id_i is not null or

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

234: Close C_Sel1;
235: End If;
236: */
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: End pre_insert;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |-----------------------------< post_insert >------------------------------|

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

277: --
278: l_proc varchar2(72) := g_package||'post_insert';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: begin
283: --
284: ota_fns_rki.after_insert
285: (p_effective_date => p_effective_date

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

304: ,p_hook_type => 'AI');
305: --
306: end;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: End post_insert;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |---------------------------------< ins >----------------------------------|

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

322: l_contact_id ota_frm_notif_subscribers.contact_id%TYPE;
323:
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: l_forum_id := p_rec.forum_id;
328: l_person_id := p_rec.person_id;
329: l_contact_id := p_rec.contact_id;
330:

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

368: --
369: -- Call to raise any errors on multi-message list
370: hr_multi_message.end_validation_set;
371: --
372: hr_utility.set_location('Leaving:'||l_proc, 20);
373: end ins;
374: --
375: -- ----------------------------------------------------------------------------
376: -- |---------------------------------< ins >----------------------------------|

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

390: l_rec ota_fns_shd.g_rec_type;
391: l_proc varchar2(72) := g_package||'ins';
392: --
393: Begin
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: -- Call conversion function to turn arguments into the
397: -- p_rec structure.
398: --

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

423: --p_person_id := l_rec.person_id;
424: --p_contact_id := l_rec.contact_id;
425: p_object_version_number := l_rec.object_version_number;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: End ins;
429: --
430: end ota_fns_ins;