APPS.OTA_CUS_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_cus_ins.g_chat_id_i := p_chat_id;
31: ota_cus_ins.g_person_id_i := p_person_id;
32: ota_cus_ins.g_contact_id_i := p_contact_id;

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

30: ota_cus_ins.g_chat_id_i := p_chat_id;
31: ota_cus_ins.g_person_id_i := p_person_id;
32: ota_cus_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: --
92: --

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 193: hr_utility.set_location('Entering:'||l_proc, 5);

189: l_proc varchar2(72) := g_package||'pre_insert';
190: -- l_exists varchar2(1);
191: --
192: Begin
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: -- If (ota_cus_ins.g_chat_id_i is not null or
196: -- ota_cus_ins.g_person_id_i is not null or
197: -- ota_cus_ins.g_contact_id_i is not null) Then

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

233: -- Fetch C_Sel1 Into p_rec.contact_id;
234: -- Close C_Sel1;
235: -- End If;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: End pre_insert;
239: --
240: -- ----------------------------------------------------------------------------
241: -- |-----------------------------< post_insert >------------------------------|

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

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

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

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

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

322: l_person_id number;
323: l_contact_id number;
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- Call the supporting insert validate operations
329: --
330: l_chat_id := p_rec.chat_id;

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

361: --
362: -- Call to raise any errors on multi-message list
363: hr_multi_message.end_validation_set;
364: --
365: hr_utility.set_location('Leaving:'||l_proc, 20);
366: end ins;
367: --
368: -- ----------------------------------------------------------------------------
369: -- |---------------------------------< ins >----------------------------------|

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

381: l_rec ota_cus_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'ins';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Call conversion function to turn arguments into the
388: -- p_rec structure.
389: --

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

412: -- p_person_id := l_rec.person_id;
413: -- p_contact_id := l_rec.contact_id;
414: p_object_version_number := l_rec.object_version_number;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: End ins;
418: --
419: end ota_cus_ins;