APPS.OTA_FTU_INS dependencies on HR_UTILITY

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

26: --
27: l_proc varchar2(72) := g_package||'set_base_key_value';
28: --
29: Begin
30: hr_utility.set_location('Entering:'||l_proc, 10);
31: --
32: ota_ftu_ins.g_forum_thread_id_i := p_forum_thread_id;
33: ota_ftu_ins.g_forum_id_i := p_forum_id;
34: ota_ftu_ins.g_person_id_i := p_person_id;

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

33: ota_ftu_ins.g_forum_id_i := p_forum_id;
34: ota_ftu_ins.g_person_id_i := p_person_id;
35: ota_ftu_ins.g_contact_id_i := p_contact_id;
36: --
37: hr_utility.set_location(' Leaving:'||l_proc, 20);
38: End set_base_key_value;
39: --
40: --
41: -- ----------------------------------------------------------------------------

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

87: --
88: l_proc varchar2(72) := g_package||'insert_dml';
89: --
90: Begin
91: hr_utility.set_location('Entering:'||l_proc, 5);
92: p_rec.object_version_number := 1; -- Initialise the object version
93: --
94: --
95: --

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

117: );
118: --
119: --
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: Exception
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: --

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

200: l_proc varchar2(72) := g_package||'pre_insert';
201: l_exists varchar2(1);
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: /*
207: If (ota_ftu_ins.g_forum_thread_id_i is not null or
208: ota_ftu_ins.g_forum_id_i is not null or

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

250: Close C_Sel1;
251: End If;
252: */
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: End pre_insert;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |-----------------------------< post_insert >------------------------------|

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

293: --
294: l_proc varchar2(72) := g_package||'post_insert';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: begin
299: --
300: ota_ftu_rki.after_insert
301: (p_effective_date => p_effective_date

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

326: ,p_hook_type => 'AI');
327: --
328: end;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End post_insert;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |---------------------------------< ins >----------------------------------|

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

345: l_contact_id ota_pvt_frm_thread_users.contact_id%TYPE;
346:
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: l_forum_id := p_rec.forum_id;
352: l_forum_thread_id := p_rec.forum_thread_id;
353: l_person_id := p_rec.person_id;

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

395: --
396: -- Call to raise any errors on multi-message list
397: hr_multi_message.end_validation_set;
398: --
399: hr_utility.set_location('Leaving:'||l_proc, 20);
400: end ins;
401: --
402: -- ----------------------------------------------------------------------------
403: -- |---------------------------------< ins >----------------------------------|

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

421: l_rec ota_ftu_shd.g_rec_type;
422: l_proc varchar2(72) := g_package||'ins';
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: -- Call conversion function to turn arguments into the
428: -- p_rec structure.
429: --

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

461: --p_contact_id := l_rec.contact_id;
462: p_object_version_number := l_rec.object_version_number;
463:
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 10);
466: End ins;
467: --
468: end ota_ftu_ins;