APPS.OTA_TPL_INS dependencies on HR_UTILITY

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

54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ota_tpl_shd.g_api_dml := true; -- Set the api dml status
62: --

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

136: );
137: --
138: ota_tpl_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ota_tpl_shd.g_api_dml := false; -- Unset the api dml status

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

202: --
203: Cursor C_Sel1 is select ota_price_lists_s.nextval from sys.dual;
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: --
209: -- Select the next sequence number
210: --

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

211: Open C_Sel1;
212: Fetch C_Sel1 Into p_rec.price_list_id;
213: Close C_Sel1;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: End pre_insert;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |-----------------------------< post_insert >------------------------------|

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

251: --
252: l_proc varchar2(72) := g_package||'post_insert';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: End post_insert;
259: --

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

253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: End post_insert;
259: --
260: -- ----------------------------------------------------------------------------
261: -- |---------------------------------< ins >----------------------------------|

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

268: --
269: l_proc varchar2(72) := g_package||'ins';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Determine if the business process is to be validated.
275: --
276: If p_validate then

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

301: If p_validate then
302: Raise HR_Api.Validate_Enabled;
303: End If;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: Exception
307: When HR_Api.Validate_Enabled Then
308: --
309: -- As the Validate_Enabled exception has been raised

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

357: l_rec ota_tpl_shd.g_rec_type;
358: l_proc varchar2(72) := g_package||'ins';
359: --
360: Begin
361: hr_utility.set_location('Entering:'||l_proc, 5);
362: --
363: -- Call conversion function to turn arguments into the
364: -- p_rec structure.
365: --

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

412: --
413: p_price_list_id := l_rec.price_list_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_tpl_ins;