DBA Data[Home] [Help]

APPS.BEN_CCM_INS dependencies on HR_UTILITY

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

79: l_last_updated_by ben_cvg_amt_calc_mthd_f.last_updated_by%TYPE;
80: l_last_update_login ben_cvg_amt_calc_mthd_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=

Line 103: hr_utility.set_location(l_proc, 10);

99: -- If the datetrack_mode is not INSERT then we must populate the WHO
100: -- columns with the 'old' creation values and 'new' updated values.
101: --
102: If (p_datetrack_mode <> 'INSERT') then
103: hr_utility.set_location(l_proc, 10);
104: --
105: -- Select the 'old' created values
106: --
107: Open C_Sel1;

Line 115: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

111: -- The previous 'old' created row has not been found. We need
112: -- to error as an internal datetrack problem exists.
113: --
114: Close C_Sel1;
115: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;

Line 116: hr_utility.set_message_token('PROCEDURE', l_proc);

112: -- to error as an internal datetrack problem exists.
113: --
114: Close C_Sel1;
115: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;
120: Close C_Sel1;

Line 117: hr_utility.set_message_token('STEP','10');

113: --
114: Close C_Sel1;
115: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;
120: Close C_Sel1;
121: --

Line 118: hr_utility.raise_error;

114: Close C_Sel1;
115: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;
120: Close C_Sel1;
121: --
122: -- Set the AOL updated WHO values

Line 277: hr_utility.set_location(' Leaving:'||l_proc, 15);

273: l_last_update_login
274: );
275: --
276: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
277: hr_utility.set_location(' Leaving:'||l_proc, 15);
278: --
279: Exception
280: When hr_api.check_integrity_violated Then
281: -- A check constraint has been violated

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

304: --
305: l_proc varchar2(72) := g_package||'insert_dml';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: dt_insert_dml(p_rec => p_rec,
311: p_effective_date => p_effective_date,
312: p_datetrack_mode => p_datetrack_mode,

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

312: p_datetrack_mode => p_datetrack_mode,
313: p_validation_start_date => p_validation_start_date,
314: p_validation_end_date => p_validation_end_date);
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);
317: End insert_dml;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |------------------------------< pre_insert >------------------------------|

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

366: --
367: Cursor C_Sel1 is select ben_cvg_amt_calc_mthd_f_s.nextval from sys.dual;
368: --
369: Begin
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: -- Select the next sequence number
373: --
374: Open C_Sel1;

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

374: Open C_Sel1;
375: Fetch C_Sel1 Into p_rec.cvg_amt_calc_mthd_id;
376: Close C_Sel1;
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: End pre_insert;
380: --
381: -- ----------------------------------------------------------------------------
382: -- |-----------------------------< post_insert >------------------------------|

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

419: --
420: l_proc varchar2(72) := g_package||'post_insert';
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: --
426: -- Start of API User Hook for post_insert.
427: --

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

510: --
511: -- End of API User Hook for post_insert.
512: --
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: End post_insert;
516: --
517: -- ----------------------------------------------------------------------------
518: -- |-------------------------------< ins_lck >--------------------------------|

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

562: l_validation_start_date date;
563: l_validation_end_date date;
564: --
565: Begin
566: hr_utility.set_location('Entering:'||l_proc, 5);
567: --
568: -- Validate the datetrack mode mode getting the validation start
569: -- and end dates for the specified datetrack operation.
570: --

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

591: --
592: p_validation_start_date := l_validation_start_date;
593: p_validation_end_date := l_validation_end_date;
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: --
597: End ins_lck;
598: --
599: -- ----------------------------------------------------------------------------

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

610: l_validation_start_date date;
611: l_validation_end_date date;
612: --
613: Begin
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- Call the lock operation
617: --
618: ins_lck

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

734: l_rec ben_ccm_shd.g_rec_type;
735: l_proc varchar2(72) := g_package||'ins';
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: -- Call conversion function to turn arguments into the
741: -- p_rec structure.
742: --

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

822: p_effective_end_date := l_rec.effective_end_date;
823: p_object_version_number := l_rec.object_version_number;
824: --
825: --
826: hr_utility.set_location(' Leaving:'||l_proc, 10);
827: End ins;
828: --
829: end ben_ccm_ins;