DBA Data[Home] [Help]

APPS.PAY_PAP_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: pay_pap_shd.g_api_dml := true; -- Set the api dml status
62: --

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

180: );
181: --
182: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 10);
185: Exception
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: pay_pap_shd.g_api_dml := false; -- Unset the api dml status

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

246:
247: Cursor C_Sel1 is select pay_accrual_plans_s.nextval from sys.dual;
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251:
252: --
253: -- Select the next sequence number
254: --

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

256: Fetch C_Sel1 Into p_rec.accrual_plan_id;
257: Close C_Sel1;
258: --
259:
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End pre_insert;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |-----------------------------< post_insert >------------------------------|

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

296: --
297: l_proc varchar2(72) := g_package||'post_insert';
298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301:
302: --
303: -- Start of API User Hook for post_insert.
304: --

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

375: --
376: -- End of API User Hook for post_insert.
377: --
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: End post_insert;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |---------------------------------< ins >----------------------------------|

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

391: l_proc varchar2(72) := g_package||'ins';
392:
393: BEGIN
394:
395: hr_utility.set_location('Entering:'||l_proc, 10);
396:
397: --
398: -- Call the supporting insert validate operations
399: --

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

401: (p_effective_date => p_effective_date
402: ,p_rec => p_rec
403: ,p_check_accrual_ff => p_check_accrual_ff);
404:
405: hr_utility.set_location(l_proc, 20);
406:
407: --
408: -- Call the supporting pre-insert operation
409: --

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

408: -- Call the supporting pre-insert operation
409: --
410: pre_insert(p_rec);
411:
412: hr_utility.set_location(l_proc, 30);
413:
414: --
415: -- Insert the row
416: --

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

415: -- Insert the row
416: --
417: insert_dml(p_rec);
418:
419: hr_utility.set_location(l_proc, 40);
420:
421: --
422: -- Call the supporting post-insert operation
423: --

Line 426: hr_utility.set_location('Leaving:'||l_proc, 50);

422: -- Call the supporting post-insert operation
423: --
424: post_insert(p_rec);
425:
426: hr_utility.set_location('Leaving:'||l_proc, 50);
427:
428: END ins;
429: --
430: -- ----------------------------------------------------------------------------

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

494: l_proc varchar2(72) := g_package||'ins';
495:
496: BEGIN
497:
498: hr_utility.set_location('Entering:'||l_proc, 10);
499:
500: --
501: -- Call conversion function to turn arguments into the
502: -- p_rec structure.

Line 580: hr_utility.set_location('PK = '||to_char(p_accrual_plan_id), 9);

576: --
577: p_accrual_plan_id := l_rec.accrual_plan_id;
578: p_object_version_number := l_rec.object_version_number;
579:
580: hr_utility.set_location('PK = '||to_char(p_accrual_plan_id), 9);
581:
582: hr_utility.set_location(' Leaving:'||l_proc, 10);
583:
584: END ins;

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

578: p_object_version_number := l_rec.object_version_number;
579:
580: hr_utility.set_location('PK = '||to_char(p_accrual_plan_id), 9);
581:
582: hr_utility.set_location(' Leaving:'||l_proc, 10);
583:
584: END ins;
585:
586: END pay_pap_ins;