APPS.BEN_BATCH_UTILS dependencies on HR_API

Line 154: ,p_cvg_thru_dt in date Default hr_api.g_eot

150: ,p_uom in varchar2 Default NULL
151: ,p_cst_amt in number Default NULL
152: ,p_credit_amt in number Default NULL
153: ,p_cvg_strt_dt in date Default NULL
154: ,p_cvg_thru_dt in date Default hr_api.g_eot
155: ,p_prtt_enrt_rslt_id in number default NULL
156: ,p_effective_date in date
157: ,P_actn_cd in varchar2
158: ,p_suspended in varchar2 default 'N'

Line 370: Procedure ini(p_actn_cd varchar2 default hr_api.g_varchar2) is

366: -- ============================================================================
367: -- <>
368: -- ============================================================================
369: --
370: Procedure ini(p_actn_cd varchar2 default hr_api.g_varchar2) is
371: L_proc varchar2(80) := g_package||'.ini';
372: Begin
373: hr_utility.set_location ('Entering '||l_proc,05);
374: If(p_actn_cd = hr_api.g_varchar2) then

Line 374: If(p_actn_cd = hr_api.g_varchar2) then

370: Procedure ini(p_actn_cd varchar2 default hr_api.g_varchar2) is
371: L_proc varchar2(80) := g_package||'.ini';
372: Begin
373: hr_utility.set_location ('Entering '||l_proc,05);
374: If(p_actn_cd = hr_api.g_varchar2) then
375: ini_comp_obj;
376: ini_person;
377: ini_comp_obj_name;
378: Elsif(upper(substr(p_actn_cd,1,6)) = 'PERSON' ) then

Line 1234: ,p_pgm_id in number default hr_api.g_number

1230: ,p_validate in varchar2
1231: ,p_benefit_action_id in number
1232: ,p_effective_date in date
1233: ,p_business_group_id in number
1234: ,p_pgm_id in number default hr_api.g_number
1235: ,p_pl_id in number default hr_api.g_number
1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number

Line 1235: ,p_pl_id in number default hr_api.g_number

1231: ,p_benefit_action_id in number
1232: ,p_effective_date in date
1233: ,p_business_group_id in number
1234: ,p_pgm_id in number default hr_api.g_number
1235: ,p_pl_id in number default hr_api.g_number
1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number

Line 1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number

1232: ,p_effective_date in date
1233: ,p_business_group_id in number
1234: ,p_pgm_id in number default hr_api.g_number
1235: ,p_pl_id in number default hr_api.g_number
1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number

Line 1237: ,p_person_id in number default hr_api.g_number

1233: ,p_business_group_id in number
1234: ,p_pgm_id in number default hr_api.g_number
1235: ,p_pl_id in number default hr_api.g_number
1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number

Line 1238: ,p_person_type_id in number default hr_api.g_number

1234: ,p_pgm_id in number default hr_api.g_number
1235: ,p_pl_id in number default hr_api.g_number
1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number

Line 1239: ,p_ler_id in number default hr_api.g_number

1235: ,p_pl_id in number default hr_api.g_number
1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number

Line 1240: ,p_organization_id in number default hr_api.g_number

1236: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number

Line 1241: ,p_benfts_grp_id in number default hr_api.g_number

1237: ,p_person_id in number default hr_api.g_number
1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2

Line 1242: ,p_location_id in number default hr_api.g_number

1238: ,p_person_type_id in number default hr_api.g_number
1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2

Line 1243: ,p_legal_entity_id in number default hr_api.g_number

1239: ,p_ler_id in number default hr_api.g_number
1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number

Line 1244: ,p_payroll_id in number default hr_api.g_number

1240: ,p_organization_id in number default hr_api.g_number
1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number

Line 1245: ,p_no_programs in varchar2 default hr_api.g_varchar2

1241: ,p_benfts_grp_id in number default hr_api.g_number
1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number

Line 1246: ,p_no_plans in varchar2 default hr_api.g_varchar2

1242: ,p_location_id in number default hr_api.g_number
1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number

Line 1247: ,p_rptg_grp_id in number default hr_api.g_number

1243: ,p_legal_entity_id in number default hr_api.g_number
1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number

Line 1248: ,p_pl_typ_id in number default hr_api.g_number

1244: ,p_payroll_id in number default hr_api.g_number
1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2

Line 1249: ,p_opt_id in number default hr_api.g_number

1245: ,p_no_programs in varchar2 default hr_api.g_varchar2
1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number

Line 1250: ,p_eligy_prfl_id in number default hr_api.g_number

1246: ,p_no_plans in varchar2 default hr_api.g_varchar2
1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number

Line 1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number

1247: ,p_rptg_grp_id in number default hr_api.g_number
1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number
1255: ,p_enrt_perd_id in number default hr_api.g_number

Line 1252: ,p_mode in varchar2 default hr_api.g_varchar2

1248: ,p_pl_typ_id in number default hr_api.g_number
1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number
1255: ,p_enrt_perd_id in number default hr_api.g_number
1256: ,p_derivable_factors in varchar2 default hr_api.g_varchar2

Line 1253: ,p_person_selection_rule_id in number default hr_api.g_number

1249: ,p_opt_id in number default hr_api.g_number
1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number
1255: ,p_enrt_perd_id in number default hr_api.g_number
1256: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1257: ,p_audit_log in varchar2 default hr_api.g_varchar2

Line 1254: ,p_comp_selection_rule_id in number default hr_api.g_number

1250: ,p_eligy_prfl_id in number default hr_api.g_number
1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number
1255: ,p_enrt_perd_id in number default hr_api.g_number
1256: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1257: ,p_audit_log in varchar2 default hr_api.g_varchar2
1258: ) is

Line 1255: ,p_enrt_perd_id in number default hr_api.g_number

1251: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number
1255: ,p_enrt_perd_id in number default hr_api.g_number
1256: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1257: ,p_audit_log in varchar2 default hr_api.g_varchar2
1258: ) is
1259: l_proc varchar2(80) := g_package||'.print_parameters';

Line 1256: ,p_derivable_factors in varchar2 default hr_api.g_varchar2

1252: ,p_mode in varchar2 default hr_api.g_varchar2
1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number
1255: ,p_enrt_perd_id in number default hr_api.g_number
1256: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1257: ,p_audit_log in varchar2 default hr_api.g_varchar2
1258: ) is
1259: l_proc varchar2(80) := g_package||'.print_parameters';
1260: l_string varchar2(80);

Line 1257: ,p_audit_log in varchar2 default hr_api.g_varchar2

1253: ,p_person_selection_rule_id in number default hr_api.g_number
1254: ,p_comp_selection_rule_id in number default hr_api.g_number
1255: ,p_enrt_perd_id in number default hr_api.g_number
1256: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1257: ,p_audit_log in varchar2 default hr_api.g_varchar2
1258: ) is
1259: l_proc varchar2(80) := g_package||'.print_parameters';
1260: l_string varchar2(80);
1261: l_actn varchar2(80);

Line 1267: if p_mode is not null AND p_mode <> hr_api.g_varchar2

1263: hr_utility.set_location ('Entering '||l_proc,10);
1264: write(p_text => 'Runtime Parameters');
1265: write(p_text => '------------------');
1266: -- bug 5450842
1267: if p_mode is not null AND p_mode <> hr_api.g_varchar2
1268: then
1269: write(p_text => 'Run Mode :' ||
1270: nvl(hr_general.decode_lookup('BEN_BENMNGLE_MD',p_mode),
1271: hr_general.decode_lookup('BEN_BENCLENR_MD',p_mode))); -- 1674123

Line 1281: if (nvl(p_enrt_perd_id, -1) <> hr_api.g_number) then

1277: to_char(p_benefit_action_id));
1278: write(p_text => 'Effective Date :' ||
1279: to_char(p_effective_date,'DD/MM/YYYY'));
1280: write(p_text =>'Business Group ID :' || p_business_group_id);
1281: if (nvl(p_enrt_perd_id, -1) <> hr_api.g_number) then
1282: write(p_text =>'Enrollment period Id :' || p_enrt_perd_id);
1283: end if;
1284: --
1285: l_actn := 'printing p_derivable_factors';

Line 1286: If (nvl(p_derivable_factors,'xxxx') <> hr_api.g_varchar2) then

1282: write(p_text =>'Enrollment period Id :' || p_enrt_perd_id);
1283: end if;
1284: --
1285: l_actn := 'printing p_derivable_factors';
1286: If (nvl(p_derivable_factors,'xxxx') <> hr_api.g_varchar2) then
1287: write(p_text =>'Derivable Factors :'||
1288: hr_general.decode_lookup('YES_NO',p_derivable_factors));
1289: End if;
1290: --

Line 1292: If (nvl(p_pgm_id,-1) <> hr_api.g_number) then

1288: hr_general.decode_lookup('YES_NO',p_derivable_factors));
1289: End if;
1290: --
1291: l_actn := 'Printing p_pgm_id';
1292: If (nvl(p_pgm_id,-1) <> hr_api.g_number) then
1293: write(p_text => 'Program ID :'||
1294: benutils.iftrue
1295: (p_expression => p_pgm_id is null
1296: ,p_true => 'All'

Line 1301: If (nvl(p_pl_id,-1) <> hr_api.g_number) then

1297: ,p_false => p_pgm_id));
1298: End if;
1299: --
1300: l_actn := 'printing p_pl_id...';
1301: If (nvl(p_pl_id,-1) <> hr_api.g_number) then
1302: write(p_text => 'Plan ID :'||
1303: benutils.iftrue
1304: (p_expression => p_pl_id is null
1305: ,p_true => 'All'

Line 1310: If (nvl(p_pl_typ_id,-1) <> hr_api.g_number) then

1306: ,p_false => p_pl_id));
1307: End if;
1308: --
1309: l_actn := 'Printing p_pl_typ_id...';
1310: If (nvl(p_pl_typ_id,-1) <> hr_api.g_number) then
1311: write(p_text => 'Plan Type ID :'||
1312: benutils.iftrue
1313: (p_expression => p_pl_typ_id is null
1314: ,p_true => 'All'

Line 1319: If (nvl(p_opt_id,-1) <> hr_api.g_number) then

1315: ,p_false => p_pl_typ_id));
1316: End if;
1317: --
1318: l_actn := 'Printting p_opt_id... ';
1319: If (nvl(p_opt_id,-1) <> hr_api.g_number) then
1320: write(p_text => 'Option ID :'||
1321: benutils.iftrue
1322: (p_expression => p_opt_id is null
1323: ,p_true => 'All'

Line 1328: If (nvl(p_popl_enrt_typ_cycl_id,-1) <> hr_api.g_number) then

1324: ,p_false => p_opt_id));
1325: End if;
1326: --
1327: l_actn := 'Printting p_popl_enrt_typ_cycl...';
1328: If (nvl(p_popl_enrt_typ_cycl_id,-1) <> hr_api.g_number) then
1329: write(p_text => 'Enrollment Type Cycle :'||
1330: benutils.iftrue
1331: (p_expression => p_popl_enrt_typ_cycl_id is null
1332: ,p_true => 'All'

Line 1337: If (nvl(p_no_programs,'xxxx') <> hr_api.g_varchar2) then

1333: ,p_false => p_popl_enrt_typ_cycl_id));
1334: End if;
1335: --
1336: l_actn := 'Printting p_no_program...';
1337: If (nvl(p_no_programs,'xxxx') <> hr_api.g_varchar2) then
1338: write(p_text => 'Just Plans not in Programs :'||
1339: hr_general.decode_lookup('YES_NO',p_no_programs));
1340: End if;
1341: --

Line 1343: If (nvl(p_no_plans,'xxxx') <> hr_api.g_varchar2) then

1339: hr_general.decode_lookup('YES_NO',p_no_programs));
1340: End if;
1341: --
1342: l_actn := 'Printting p_no_plans...';
1343: If (nvl(p_no_plans,'xxxx') <> hr_api.g_varchar2) then
1344: write(p_text => 'Just Programs :'||
1345: hr_general.decode_lookup('YES_NO',p_no_plans));
1346: End if;
1347: --

Line 1349: If (nvl(p_rptg_grp_id,-1) <> hr_api.g_number) then

1345: hr_general.decode_lookup('YES_NO',p_no_plans));
1346: End if;
1347: --
1348: l_actn := 'Printting p_rptg_grp_id...';
1349: If (nvl(p_rptg_grp_id,-1) <> hr_api.g_number) then
1350: write(p_text => 'Reporting Group :'||
1351: benutils.iftrue
1352: (p_expression => p_rptg_grp_id is null
1353: ,p_true => 'All'

Line 1358: If (nvl(p_eligy_prfl_id,-1) <> hr_api.g_number) then

1354: ,p_false => p_rptg_grp_id));
1355: End if;
1356: --
1357: l_actn := 'Printting p_eligy_prfl_id...';
1358: If (nvl(p_eligy_prfl_id,-1) <> hr_api.g_number) then
1359: write(p_text => 'Eligiblity Profile :'||
1360: benutils.iftrue
1361: (p_expression => p_eligy_prfl_id is null
1362: ,p_true => 'All'

Line 1367: If (nvl(p_vrbl_rt_prfl_id,-1) <> hr_api.g_number) then

1363: ,p_false => p_eligy_prfl_id));
1364: End if;
1365: --
1366: l_actn := 'Printting p_vrbl_rt_prfl_id...';
1367: If (nvl(p_vrbl_rt_prfl_id,-1) <> hr_api.g_number) then
1368: write(p_text => 'Variable Rate Profile :'||
1369: benutils.iftrue
1370: (p_expression => p_vrbl_rt_prfl_id is null
1371: ,p_true => 'All'

Line 1376: If (nvl(p_person_selection_rule_id,-1) <> hr_api.g_number) then

1372: ,p_false => p_vrbl_rt_prfl_id));
1373: End if;
1374: --
1375: l_actn := 'Printting p_person_selection_rule_id...';
1376: If (nvl(p_person_selection_rule_id,-1) <> hr_api.g_number) then
1377: write(p_text => 'Person Selection Rule :'||
1378: benutils.iftrue
1379: (p_expression => p_person_selection_rule_id is null
1380: ,p_true => 'None'

Line 1385: If (nvl(p_person_id,-1) <> hr_api.g_number) then

1381: ,p_false => p_person_selection_rule_id));
1382: End if;
1383: --
1384: l_actn := 'Printting p_person_id...';
1385: If (nvl(p_person_id,-1) <> hr_api.g_number) then
1386: write(p_text => 'Person ID :'||
1387: benutils.iftrue
1388: (p_expression => p_person_id is null
1389: ,p_true => 'None'

Line 1394: If (nvl(p_person_type_id,-1) <> hr_api.g_number) then

1390: ,p_false => p_person_id));
1391: End if;
1392: --
1393: l_actn := 'Printting p_person_type_id...';
1394: If (nvl(p_person_type_id,-1) <> hr_api.g_number) then
1395: write(p_text => 'Person Type ID :'||
1396: benutils.iftrue
1397: (p_expression => p_person_type_id is null
1398: ,p_true => 'None'

Line 1403: If (nvl(p_ler_id,-1) <> hr_api.g_number) then

1399: ,p_false => p_person_type_id));
1400: End if;
1401: --
1402: l_actn := 'Printting p_ler_id...';
1403: If (nvl(p_ler_id,-1) <> hr_api.g_number) then
1404: write(p_text => 'Ler ID :'||
1405: benutils.iftrue
1406: (p_expression => p_ler_id is null
1407: ,p_true => 'None'

Line 1412: If (nvl(p_organization_id,-1) <> hr_api.g_number) then

1408: ,p_false => p_ler_id));
1409: End if;
1410: --
1411: l_actn := 'Printting p_organization_id...';
1412: If (nvl(p_organization_id,-1) <> hr_api.g_number) then
1413: write(p_text => 'Organization ID :'||
1414: benutils.iftrue
1415: (p_expression => p_organization_id is null
1416: ,p_true => 'None'

Line 1421: If (nvl(p_benfts_grp_id,-1) <> hr_api.g_number) then

1417: ,p_false => p_organization_id));
1418: End if;
1419: --
1420: l_actn := 'Printting p_benfts_grp_id...';
1421: If (nvl(p_benfts_grp_id,-1) <> hr_api.g_number) then
1422: write(p_text => 'Benefits Group ID :'||
1423: benutils.iftrue
1424: (p_expression => p_benfts_grp_id is null
1425: ,p_true => 'None'

Line 1430: If (nvl(p_location_id,-1) <> hr_api.g_number) then

1426: ,p_false => p_benfts_grp_id));
1427: End if;
1428: --
1429: l_actn := 'Printting p_location_id...';
1430: If (nvl(p_location_id,-1) <> hr_api.g_number) then
1431: write(p_text => 'Location ID :'||
1432: benutils.iftrue
1433: (p_expression => p_location_id is null
1434: ,p_true => 'None'

Line 1439: If (nvl(p_legal_entity_id,-1) <> hr_api.g_number) then

1435: ,p_false => p_location_id));
1436: End if;
1437: --
1438: l_actn := 'Printting p_legal_entity_id...';
1439: If (nvl(p_legal_entity_id,-1) <> hr_api.g_number) then
1440: write(p_text => 'Legal Entity ID :'||
1441: benutils.iftrue
1442: (p_expression => p_legal_entity_id is null
1443: ,p_true => 'None'

Line 1448: If (nvl(p_payroll_id,-1) <> hr_api.g_number) then

1444: ,p_false => p_legal_entity_id));
1445: End if;
1446: --
1447: l_actn := 'Printting p_payroll_id...';
1448: If (nvl(p_payroll_id,-1) <> hr_api.g_number) then
1449: write(p_text => 'Payroll ID :'||
1450: benutils.iftrue
1451: (p_expression => p_payroll_id is null
1452: ,p_true => 'None'

Line 1457: If (nvl(p_comp_selection_rule_id,-1) <> hr_api.g_number) then

1453: ,p_false => p_payroll_id));
1454: End if;
1455: --
1456: l_actn := 'Printting p_comp_selection_rule_id...';
1457: If (nvl(p_comp_selection_rule_id,-1) <> hr_api.g_number) then
1458: write(p_text => 'Comp Object Selection Rule :'||
1459: benutils.iftrue
1460: (p_expression => p_comp_selection_rule_id is null
1461: ,p_true => 'None'

Line 1466: If (nvl(p_audit_log,'xxxx') <> hr_api.g_varchar2) then

1462: ,p_false => p_comp_selection_rule_id));
1463: End if;
1464: --
1465: l_actn := 'Printting p_audit_log...';
1466: If (nvl(p_audit_log,'xxxx') <> hr_api.g_varchar2) then
1467: write(p_text => 'Audit log flag :'||
1468: hr_general.decode_lookup('YES_NO',p_audit_log));
1469: End if;
1470: hr_utility.set_location ('Leaving '||l_proc,10);

Line 2320: hr_api.mandatory_arg_error

2316: IF (p_base_key_value IS NOT NULL) THEN
2317: IF p_base_table_name IS NULL OR
2318: p_base_key_column IS NULL THEN
2319: -- Mandatory arg checking
2320: hr_api.mandatory_arg_error
2321: (p_api_name => l_proc,
2322: p_argument => 'p_base_table_name',
2323: p_argument_value => p_base_table_name);
2324: --

Line 2325: hr_api.mandatory_arg_error

2321: (p_api_name => l_proc,
2322: p_argument => 'p_base_table_name',
2323: p_argument_value => p_base_table_name);
2324: --
2325: hr_api.mandatory_arg_error
2326: (p_api_name => l_proc,
2327: p_argument => 'p_base_key_column',
2328: p_argument_value => p_base_key_column);
2329: --