eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TSP_INS dependencies on HR_UTILITY

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

16: --
17: l_proc varchar2(72) := g_package||'set_base_key_value';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 10);
21: --
22: ota_tsp_ins.g_skill_provision_id_i := p_skill_provision_id;
23: --
24: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

20: hr_utility.set_location('Entering:'||l_proc, 10);
21: --
22: ota_tsp_ins.g_skill_provision_id_i := p_skill_provision_id;
23: --
24: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: End set_base_key_value;
26: -- ----------------------------------------------------------------------------
27: -- |------------------------------< insert_dml >------------------------------|
28: -- ----------------------------------------------------------------------------

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

70: --
71: l_proc varchar2(72) := g_package||'insert_dml';
72: --
73: Begin
74: hr_utility.set_location('Entering:'||l_proc, 5);
75: p_rec.object_version_number := 1; -- Initialise the object version
76: --
77: ota_tsp_shd.g_api_dml := true; -- Set the api dml status
78: --

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

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

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

215: --
216: l_exists varchar2(1);
217:
218: Begin
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: If (ota_tsp_ins.g_skill_provision_id_i is not null) Then
221: --
222: -- Verify registered primary key values not already in use
223: --

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

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

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

289: --
290: l_proc varchar2(72) := g_package||'post_insert';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End post_insert;
297: --

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

291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End post_insert;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |---------------------------------< ins >----------------------------------|

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

306: --
307: l_proc varchar2(72) := g_package||'ins';
308: --
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: -- Determine if the business process is to be validated.
313: --
314: If p_validate then

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

339: If p_validate then
340: Raise HR_Api.Validate_Enabled;
341: End If;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: Exception
345: When HR_Api.Validate_Enabled Then
346: --
347: -- As the Validate_Enabled exception has been raised

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

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

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

436: --
437: p_skill_provision_id := l_rec.skill_provision_id;
438: p_object_version_number := l_rec.object_version_number;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: End ins;
442: --
443: end ota_tsp_ins;