DBA Data[Home] [Help]

APPS.PER_PSE_UPD dependencies on HR_UTILITY

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

57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --

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

82: where pos_structure_element_id = p_rec.pos_structure_element_id;
83: --
84: per_pse_shd.g_api_dml := false; -- Unset the api dml status
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated

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

144: --
145: l_proc varchar2(72) := g_package||'pre_update';
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --

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

146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --
153: -- ----------------------------------------------------------------------------
154: -- |-----------------------------< post_update >------------------------------|

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

188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: begin
194: --
195: per_pse_rku.after_update
196: (p_pos_structure_element_id

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

242: ,p_hook_type => 'AU');
243: --
244: end;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
247: End post_update;
248: --
249: -- ----------------------------------------------------------------------------
250: -- |-----------------------------< convert_defs >-----------------------------|

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

351: l_myexception Exception;
352: --Bug no 3888749 ends here
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: -- We must lock the row which we need to update.
358: --
359: per_pse_shd.lck

Line 403: hr_utility.set_location('old_parent_id '||l_old_parent_pos_id||'new_parent_id '||l_new_parent_pos_id,10);

399: and not exists (select null from per_pos_structure_elements
400: where SUBORDINATE_POSITION_ID = x.PARENT_POSITION_ID)
401: and rownum=1;
402:
403: hr_utility.set_location('old_parent_id '||l_old_parent_pos_id||'new_parent_id '||l_new_parent_pos_id,10);
404:
405: if (l_old_parent_pos_id<>l_new_parent_pos_id) then
406: raise l_myexception;
407: end if;

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

436: l_rec per_pse_shd.g_rec_type;
437: l_proc varchar2(72) := g_package||'upd';
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: -- Call conversion function to turn arguments into the
443: -- l_rec structure.
444: --

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

465: ,p_effective_date
466: );
467: p_object_version_number := l_rec.object_version_number;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 10);
470: End upd;
471: --
472: end per_pse_upd;