49: -- Internal Row Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy ben_bnr_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: l_last_update_date date := sysdate;
57: l_last_updated_by number := fnd_global.user_id;
61: Begin
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: p_rec.object_version_number := 1; -- Initialise the object version
64: --
65: ben_bnr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Insert the row into: ben_rptg_grp
68: --
69: insert into ben_rptg_grp
182: from ben_rptg_grp_tl t
183: where t.rptg_grp_id = p_rec.rptg_grp_id
184: and t.language = l.language_code);
185: --
186: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
193: ben_bnr_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
193: ben_bnr_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
193: ben_bnr_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
198: ben_bnr_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
198: ben_bnr_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
198: ben_bnr_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
203: ben_bnr_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
203: ben_bnr_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
207: Raise;
202: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
203: ben_bnr_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
207: Raise;
208: End insert_dml;
209: --
210: -- ----------------------------------------------------------------------------
243: -- Internal Row Handler Use Only.
244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure pre_insert(p_rec in out nocopy ben_bnr_shd.g_rec_type) is
248: --
249: l_proc varchar2(72) := g_package||'pre_insert';
250: --
251: Cursor C_Sel1 is select ben_rptg_grp_s.nextval from sys.dual;
304: --
305: -- {End Of Comments}
306: -- ----------------------------------------------------------------------------
307: Procedure post_insert(
308: p_effective_date in date,p_rec in ben_bnr_shd.g_rec_type) is
309: --
310: l_proc varchar2(72) := g_package||'post_insert';
311: --
312: Begin
383: -- ----------------------------------------------------------------------------
384: Procedure ins
385: (
386: p_effective_date in date,
387: p_rec in out nocopy ben_bnr_shd.g_rec_type
388: ) is
389: --
390: l_proc varchar2(72) := g_package||'ins';
391: --
458: p_object_version_number out nocopy number,
459: p_ordr_num in number default null --iRec
460: ) is
461: --
462: l_rec ben_bnr_shd.g_rec_type;
463: l_proc varchar2(72) := g_package||'ins';
464: --
465: Begin
466: hr_utility.set_location('Entering:'||l_proc, 5);
468: -- Call conversion function to turn arguments into the
469: -- p_rec structure.
470: --
471: l_rec :=
472: ben_bnr_shd.convert_args
473: (
474: null,
475: p_name,
476: p_business_group_id,