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.PER_PSP_DEL dependencies on HR_UTILITY

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

54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: per_psp_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the per_spinal_points row.

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

65: where spinal_point_id = p_rec.spinal_point_id;
66: --
67: per_psp_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated

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

117: l_return varchar2(30);
118: l_message varchar2(2000) := null;
119: --
120: Begin
121: hr_utility.set_location('Entering:'||l_proc, 5);
122: --
123: -- Call pqh_gsp_sync_compensation_obj.delete_option_for_point
124: --
125: hr_utility.trace('prec.spinal_point_id : ' || p_rec.spinal_point_id);

Line 125: hr_utility.trace('prec.spinal_point_id : ' || p_rec.spinal_point_id);

121: hr_utility.set_location('Entering:'||l_proc, 5);
122: --
123: -- Call pqh_gsp_sync_compensation_obj.delete_option_for_point
124: --
125: hr_utility.trace('prec.spinal_point_id : ' || p_rec.spinal_point_id);
126: --
127: l_return := pqh_gsp_sync_compensation_obj.delete_option_for_point
128: (p_spinal_point_id => p_rec.spinal_point_id
129: );

Line 131: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_option_for_point : '

127: l_return := pqh_gsp_sync_compensation_obj.delete_option_for_point
128: (p_spinal_point_id => p_rec.spinal_point_id
129: );
130: --
131: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_option_for_point : '
132: || l_return);
133: if l_return <> 'SUCCESS' Then
134: l_message := fnd_message.get;
135: hr_utility.trace('error message : ' || l_message);

Line 135: hr_utility.trace('error message : ' || l_message);

131: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_option_for_point : '
132: || l_return);
133: if l_return <> 'SUCCESS' Then
134: l_message := fnd_message.get;
135: hr_utility.trace('error message : ' || l_message);
136:
137: fnd_message.set_name('PER','HR_289569_DEL_OPTION_FOR_POINT');
138: if l_message is not null then
139: fnd_message.set_token('ERR_CODE',l_message);

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

143: --
144: fnd_message.raise_error;
145: End if;
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148: End pre_delete;
149: --
150: -- ----------------------------------------------------------------------------
151: -- |-----------------------------< post_delete >------------------------------|

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

183: --
184: l_proc varchar2(72) := g_package||'post_delete';
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: begin
189: --
190: per_psp_rkd.after_delete
191: (p_spinal_point_id

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

283: ,p_hook_type => 'AD');
284: --
285: end;
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End post_delete;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------------< del >----------------------------------|

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

296: --
297: l_proc varchar2(72) := g_package||'del';
298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 10);
301: --
302: -- We must lock the row which we need to delete.
303: --
304: per_psp_shd.lck

Line 313: hr_utility.set_location(l_proc, 20);

309: -- Call the supporting delete validate operation
310: --
311: per_psp_bus.delete_validate(p_rec);
312:
313: hr_utility.set_location(l_proc, 20);
314:
315: --
316: -- Call to raise any errors on multi-message list
317: hr_multi_message.end_validation_set;

Line 323: hr_utility.set_location(l_proc, 30);

319: -- Call the supporting pre-delete operation
320: --
321: per_psp_del.pre_delete(p_rec);
322:
323: hr_utility.set_location(l_proc, 30);
324:
325: --
326: -- Delete the row.
327: --

Line 330: hr_utility.set_location(l_proc, 40);

326: -- Delete the row.
327: --
328: per_psp_del.delete_dml(p_rec);
329:
330: hr_utility.set_location(l_proc, 40);
331:
332: --
333: -- Call the supporting post-delete operation
334: --

Line 337: hr_utility.set_location(l_proc, 50);

333: -- Call the supporting post-delete operation
334: --
335: per_psp_del.post_delete(p_rec);
336:
337: hr_utility.set_location(l_proc, 50);
338:
339: --
340: -- Call to raise any errors on multi-message list
341: hr_multi_message.end_validation_set;

Line 344: hr_utility.set_location(l_proc, 60);

340: -- Call to raise any errors on multi-message list
341: hr_multi_message.end_validation_set;
342: --
343:
344: hr_utility.set_location(l_proc, 60);
345: End del;
346: --
347: -- ----------------------------------------------------------------------------
348: -- |---------------------------------< del >----------------------------------|

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

355: l_rec per_psp_shd.g_rec_type;
356: l_proc varchar2(72) := g_package||'del';
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- As the delete procedure accepts a plsql record structure we do need to
362: -- convert the arguments into the record structure.
363: -- We don't need to call the supplied conversion argument routine as we

Line 375: hr_utility.set_location(' Leaving:'||l_proc, 100);

371: -- business process
372: --
373: per_psp_del.del(l_rec);
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 100);
376: End del;
377: --
378: end per_psp_del;