eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ABR_INS dependencies on HR_UTILITY

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

115: l_last_updated_by ben_acty_base_rt_f.last_updated_by%TYPE;
116: l_last_update_login ben_acty_base_rt_f.last_update_login%TYPE;
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: -- Get the object version number for the insert
122: --
123: p_rec.object_version_number :=

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

135: -- If the datetrack_mode is not INSERT then we must populate the WHO
136: -- columns with the 'old' creation values and 'new' updated values.
137: --
138: If (p_datetrack_mode <> 'INSERT') then
139: hr_utility.set_location(l_proc, 10);
140: --
141: -- Select the 'old' created values
142: --
143: Open C_Sel1;

Line 169: hr_utility.set_location('total rate befr insert '||p_rec.TTL_COMP_LVL_FCTR_ID, 99);

165: ben_abr_shd.g_api_dml := true; -- Set the api dml status
166: --
167: -- Insert the row into: ben_acty_base_rt_f
168: --
169: hr_utility.set_location('total rate befr insert '||p_rec.TTL_COMP_LVL_FCTR_ID, 99);
170:
171: --Added for Bug 6881417
172: if( p_rec.pl_id is not null) then
173: open c_pl_typ(p_rec.pl_id);

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

788:
789:
790: --
791: ben_abr_shd.g_api_dml := false; -- Unset the api dml status
792: hr_utility.set_location(' Leaving:'||l_proc, 15);
793: --
794: Exception
795: When hr_api.check_integrity_violated Then
796: -- A check constraint has been violated

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

819: --
820: l_proc varchar2(72) := g_package||'insert_dml';
821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: dt_insert_dml(p_rec => p_rec,
826: p_effective_date => p_effective_date,
827: p_datetrack_mode => p_datetrack_mode,

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

827: p_datetrack_mode => p_datetrack_mode,
828: p_validation_start_date => p_validation_start_date,
829: p_validation_end_date => p_validation_end_date);
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: End insert_dml;
833: --
834: -- ----------------------------------------------------------------------------
835: -- |------------------------------< pre_insert >------------------------------|

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

912: --
913: l_oiplip c_oiplip%rowtype;
914: --
915: Begin
916: hr_utility.set_location('Entering:'||l_proc, 5);
917: --
918: --
919: open c1;
920: --

Line 925: hr_utility.set_location(' p_rec.pgm_id :'||p_rec.pgm_id, 5);

921: fetch c1 into p_rec.acty_base_rt_id;
922: --
923: close c1;
924: --
925: hr_utility.set_location(' p_rec.pgm_id :'||p_rec.pgm_id, 5);
926: hr_utility.set_location(' p_rec.pl_id :'||p_rec.pl_id, 5);
927: hr_utility.set_location(' p_rec.opt_id :'||p_rec.opt_id, 5);
928: hr_utility.set_location(' p_rec.oipl_id :'||p_rec.oipl_id, 5);
929: hr_utility.set_location(' p_rec.oiplip_id :'||p_rec.oiplip_id, 5);

Line 926: hr_utility.set_location(' p_rec.pl_id :'||p_rec.pl_id, 5);

922: --
923: close c1;
924: --
925: hr_utility.set_location(' p_rec.pgm_id :'||p_rec.pgm_id, 5);
926: hr_utility.set_location(' p_rec.pl_id :'||p_rec.pl_id, 5);
927: hr_utility.set_location(' p_rec.opt_id :'||p_rec.opt_id, 5);
928: hr_utility.set_location(' p_rec.oipl_id :'||p_rec.oipl_id, 5);
929: hr_utility.set_location(' p_rec.oiplip_id :'||p_rec.oiplip_id, 5);
930: hr_utility.set_location(' p_rec.plip_id :'||p_rec.plip_id, 5);

Line 927: hr_utility.set_location(' p_rec.opt_id :'||p_rec.opt_id, 5);

923: close c1;
924: --
925: hr_utility.set_location(' p_rec.pgm_id :'||p_rec.pgm_id, 5);
926: hr_utility.set_location(' p_rec.pl_id :'||p_rec.pl_id, 5);
927: hr_utility.set_location(' p_rec.opt_id :'||p_rec.opt_id, 5);
928: hr_utility.set_location(' p_rec.oipl_id :'||p_rec.oipl_id, 5);
929: hr_utility.set_location(' p_rec.oiplip_id :'||p_rec.oiplip_id, 5);
930: hr_utility.set_location(' p_rec.plip_id :'||p_rec.plip_id, 5);
931:

Line 928: hr_utility.set_location(' p_rec.oipl_id :'||p_rec.oipl_id, 5);

924: --
925: hr_utility.set_location(' p_rec.pgm_id :'||p_rec.pgm_id, 5);
926: hr_utility.set_location(' p_rec.pl_id :'||p_rec.pl_id, 5);
927: hr_utility.set_location(' p_rec.opt_id :'||p_rec.opt_id, 5);
928: hr_utility.set_location(' p_rec.oipl_id :'||p_rec.oipl_id, 5);
929: hr_utility.set_location(' p_rec.oiplip_id :'||p_rec.oiplip_id, 5);
930: hr_utility.set_location(' p_rec.plip_id :'||p_rec.plip_id, 5);
931:
932: -- set the context ids before insert

Line 929: hr_utility.set_location(' p_rec.oiplip_id :'||p_rec.oiplip_id, 5);

925: hr_utility.set_location(' p_rec.pgm_id :'||p_rec.pgm_id, 5);
926: hr_utility.set_location(' p_rec.pl_id :'||p_rec.pl_id, 5);
927: hr_utility.set_location(' p_rec.opt_id :'||p_rec.opt_id, 5);
928: hr_utility.set_location(' p_rec.oipl_id :'||p_rec.oipl_id, 5);
929: hr_utility.set_location(' p_rec.oiplip_id :'||p_rec.oiplip_id, 5);
930: hr_utility.set_location(' p_rec.plip_id :'||p_rec.plip_id, 5);
931:
932: -- set the context ids before insert
933: --

Line 930: hr_utility.set_location(' p_rec.plip_id :'||p_rec.plip_id, 5);

926: hr_utility.set_location(' p_rec.pl_id :'||p_rec.pl_id, 5);
927: hr_utility.set_location(' p_rec.opt_id :'||p_rec.opt_id, 5);
928: hr_utility.set_location(' p_rec.oipl_id :'||p_rec.oipl_id, 5);
929: hr_utility.set_location(' p_rec.oiplip_id :'||p_rec.oiplip_id, 5);
930: hr_utility.set_location(' p_rec.plip_id :'||p_rec.plip_id, 5);
931:
932: -- set the context ids before insert
933: --
934: if p_rec.pgm_id is not null then

Line 977: hr_utility.set_location(' p_rec.context_pl_id :'||p_rec.context_pl_id, 5);

973: p_rec.context_pl_id := l_plip.pl_id;
974: p_rec.context_pgm_id := l_plip.pgm_id ;
975: end if;
976: --
977: hr_utility.set_location(' p_rec.context_pl_id :'||p_rec.context_pl_id, 5);
978: hr_utility.set_location(' p_rec.context_pgm_id :'||p_rec.context_pgm_id, 5);
979: hr_utility.set_location(' p_rec.context_opt_id :'||p_rec.context_opt_id, 5);
980: --
981: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 978: hr_utility.set_location(' p_rec.context_pgm_id :'||p_rec.context_pgm_id, 5);

974: p_rec.context_pgm_id := l_plip.pgm_id ;
975: end if;
976: --
977: hr_utility.set_location(' p_rec.context_pl_id :'||p_rec.context_pl_id, 5);
978: hr_utility.set_location(' p_rec.context_pgm_id :'||p_rec.context_pgm_id, 5);
979: hr_utility.set_location(' p_rec.context_opt_id :'||p_rec.context_opt_id, 5);
980: --
981: hr_utility.set_location(' Leaving:'||l_proc, 10);
982: End pre_insert;

Line 979: hr_utility.set_location(' p_rec.context_opt_id :'||p_rec.context_opt_id, 5);

975: end if;
976: --
977: hr_utility.set_location(' p_rec.context_pl_id :'||p_rec.context_pl_id, 5);
978: hr_utility.set_location(' p_rec.context_pgm_id :'||p_rec.context_pgm_id, 5);
979: hr_utility.set_location(' p_rec.context_opt_id :'||p_rec.context_opt_id, 5);
980: --
981: hr_utility.set_location(' Leaving:'||l_proc, 10);
982: End pre_insert;
983: --

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

977: hr_utility.set_location(' p_rec.context_pl_id :'||p_rec.context_pl_id, 5);
978: hr_utility.set_location(' p_rec.context_pgm_id :'||p_rec.context_pgm_id, 5);
979: hr_utility.set_location(' p_rec.context_opt_id :'||p_rec.context_opt_id, 5);
980: --
981: hr_utility.set_location(' Leaving:'||l_proc, 10);
982: End pre_insert;
983: --
984: -- ----------------------------------------------------------------------------
985: -- |-----------------------------< post_insert >------------------------------|

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

1022: --
1023: l_proc varchar2(72) := g_package||'post_insert';
1024: --
1025: Begin
1026: hr_utility.set_location('Entering:'||l_proc, 5);
1027:
1028: -- Added for GSP validations
1029: pqh_gsp_ben_validations.abr_validations
1030: ( p_abr_id => p_rec.acty_base_rt_id

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

1194: end;
1195: --
1196: -- End of API User Hook for post_insert.
1197: --
1198: hr_utility.set_location(' Leaving:'||l_proc, 10);
1199: End post_insert;
1200: --
1201: -- ----------------------------------------------------------------------------
1202: -- |-------------------------------< ins_lck >--------------------------------|

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

1250: l_validation_start_date2 date;
1251: l_validation_end_date2 date;
1252: --
1253: Begin
1254: hr_utility.set_location('Entering:'||l_proc, 5);
1255: --
1256: -- Validate the datetrack mode mode getting the validation start
1257: -- and end dates for the specified datetrack operation.
1258: --

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

1340: p_validation_end_date := l_validation_end_date1;
1341: --
1342: end if;
1343: --
1344: hr_utility.set_location(' Leaving:'||l_proc, 10);
1345: --
1346: End ins_lck;
1347: --
1348: -- ----------------------------------------------------------------------------

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

1359: l_validation_start_date date;
1360: l_validation_end_date date;
1361: --
1362: Begin
1363: hr_utility.set_location('Entering:'||l_proc, 5);
1364: --
1365: -- Call the lock operation
1366: --
1367: ins_lck

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

1559: l_rec ben_abr_shd.g_rec_type;
1560: l_proc varchar2(72) := g_package||'ins';
1561: --
1562: Begin
1563: hr_utility.set_location('Entering:'||l_proc, 5);
1564: hr_utility.set_location('total rate before conv in ins '||p_TTL_COMP_LVL_FCTR_ID, 99);
1565: --
1566: -- Call conversion function to turn arguments into the
1567: -- p_rec structure.

Line 1564: hr_utility.set_location('total rate before conv in ins '||p_TTL_COMP_LVL_FCTR_ID, 99);

1560: l_proc varchar2(72) := g_package||'ins';
1561: --
1562: Begin
1563: hr_utility.set_location('Entering:'||l_proc, 5);
1564: hr_utility.set_location('total rate before conv in ins '||p_TTL_COMP_LVL_FCTR_ID, 99);
1565: --
1566: -- Call conversion function to turn arguments into the
1567: -- p_rec structure.
1568: --

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

1720: p_effective_end_date := l_rec.effective_end_date;
1721: p_object_version_number := l_rec.object_version_number;
1722: --
1723: --
1724: hr_utility.set_location(' Leaving:'||l_proc, 10);
1725: End ins;
1726: --
1727: end ben_abr_ins;