DBA Data[Home] [Help]

APPS.PER_PCE_INS dependencies on HR_UTILITY

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

56: --
57: l_proc VARCHAR2(72) := g_package||'insert_dml';
58: --
59: BEGIN
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --

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

92: );
93: --
94: --
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: EXCEPTION
98: WHEN hr_api.check_integrity_violated THEN
99: -- A check constraint has been violated
100: --

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

160: --
161: Cursor C_Sel1 IS select per_cagr_entitlements_s.nextval from sys.dual;
162: --
163: BEGIN
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: --
167: -- Select the next sequence NUMBER
168: --

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

169: Open C_Sel1;
170: Fetch C_Sel1 Into p_rec.cagr_entitlement_id;
171: Close C_Sel1;
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: END pre_insert;
175: --
176: -- ----------------------------------------------------------------------------
177: -- |-----------------------------< post_insert >------------------------------|

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

212: --
213: l_proc VARCHAR2(72) := g_package||'post_insert';
214: --
215: BEGIN
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: begin
218: --
219: per_pce_rki.after_insert
220: (p_effective_date => p_effective_date

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

240: ,p_hook_type => 'AI');
241: --
242: end;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
245: END post_insert;
246: --
247: -- ----------------------------------------------------------------------------
248: -- |---------------------------------< ins >----------------------------------|

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

255: l_proc VARCHAR2(72) := g_package||'ins';
256: --
257: BEGIN
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: p_rec.start_date := TRUNC(p_effective_date);
262: --
263: -- Call the supporting insert validate operations

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

281: (p_effective_date
282: ,p_rec
283: );
284: --
285: hr_utility.set_location('Leaving:'||l_proc, 20);
286: end ins;
287: --
288: -- ----------------------------------------------------------------------------
289: -- |---------------------------------< ins >----------------------------------|

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

307: l_start_date DATE;
308: --
309: BEGIN
310: --
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: l_start_Date := TRUNC(p_effective_date);
314: --
315: -- Call conversion function to turn arguments into the

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

343: --
344: p_cagr_entitlement_id := l_rec.cagr_entitlement_id;
345: p_object_version_number := l_rec.object_version_number;
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 10);
348: END ins;
349: --
350: end per_pce_ins;