APPS.BEN_BATCH_UTILS dependencies on BENUTILS

Line 26: * 20-JUL-1999 Gperry 115.18 genutils -> benutils package rename.

22: * 13-Jan-1999 Hdang 115.12 Set l_all = 'All'
23: * 03-Mar-1999 Stee 115.13 Removed dbms_output.put_line.
24: * 22-Mar-1999 TMathers 115.16 CHanged -MON- to /MM/
25: * 18-May-1999 jcarpent 115.17 Use trunc not to_char for zero of time.
26: * 20-JUL-1999 Gperry 115.18 genutils -> benutils package rename.
27: * 27-JUL-1999 mhoyes 115.19 - Changed g_report_rec ref it ben_type.
28: * 28-JUL-1999 mhoyes 115.20 - Made oipl_id hashing use > rather than <
29: * 19-Oct-1999 maagrawa 115.21 - Modified procedure write_error_rec to
30: * get correct error code.

Line 36: * p_business_group_id added to benutils.formula

32: * 03-Nov-1999 lmcdonal 115.22 Added non_person_cd to end_process,
33: * write_logfile, create_restart...
34: *
35: * 18-JAN-00 pbodla 115.23 Fixed bug 4146(WWBUG 1120687)
36: * p_business_group_id added to benutils.formula
37: * call.
38: * 04-APR-00 mmogel 115.24 Added tokens to messages to make them
39: * more meaningful to the user
40: * 11-APR-00 gperry 115.25 Added application id to get over FIDO

Line 688: write(p_text => benutils.g_banner_minus);

684: ) is
685: l_proc varchar2(80) := g_package||'.write_logfile';
686: begin
687: hr_utility.set_location ('Entering '||l_proc,10);
688: write(p_text => benutils.g_banner_minus);
689: write(p_text => 'Benefits Statistical Information');
690: write(p_text => benutils.g_banner_minus);
691:
692: if p_non_person_cd is null then

Line 690: write(p_text => benutils.g_banner_minus);

686: begin
687: hr_utility.set_location ('Entering '||l_proc,10);
688: write(p_text => benutils.g_banner_minus);
689: write(p_text => 'Benefits Statistical Information');
690: write(p_text => benutils.g_banner_minus);
691:
692: if p_non_person_cd is null then
693: write(p_text => 'Success persons ' || to_char(p_num_pers_processed));
694: write(p_text => 'Errored persons '|| to_char(p_num_pers_errored));

Line 703: write(p_text => benutils.g_banner_minus);

699: write(p_text => 'Errored premiums '|| to_char(p_num_pers_errored));
700: write(p_text => 'Total premiums Procd '||
701: to_char(p_num_pers_processed+p_num_pers_errored));
702: end if;
703: write(p_text => benutils.g_banner_minus);
704:
705: hr_utility.set_location ('Leaving '||l_proc,99);
706: Exception
707: when others then

Line 729: benutils.write(p_rec => l_rec);

725: hr_utility.set_location ('Entering ' || l_proc,05);
726: l_rec.rep_typ_cd := p_typ_cd;
727: l_rec.text := p_text;
728: l_rec.ERROR_MESSAGE_CODE := p_err_cd;
729: benutils.write(p_rec => l_rec);
730: hr_utility.set_location ('Leaving ' || l_proc,10);
731: End write_rec;
732: --
733: -- ============================================================================

Line 804: benutils.write_table_and_file(p_table => true,

800: ,P_BUSINESS_GROUP_ID => p_business_group_id
801: ,P_OBJECT_VERSION_NUMBER=> l_object_version_number
802: );
803: hr_utility.set_location (l_proc,11);
804: benutils.write_table_and_file(p_table => true,
805: p_file => true);
806: hr_utility.set_location (l_proc,12);
807: commit;
808: hr_utility.set_location ('Leaving ' || l_proc,100);

Line 1185: write(p_text => benutils.g_banner_asterix);

1181: -- Name : John Smith (100) Type : Employee (1) Grp : Benefits Group (1)
1182: -- BG : Freds BG (100) Org : Freds Org(1) GRE : Retiree
1183: -- Loc : HQ (100) Pst : 86727 Pyr : Payroll 3B (1)
1184: --
1185: write(p_text => benutils.g_banner_asterix);
1186: l_output_string := 'Name: '||
1187: rpad(substr(g_cache_person.full_name,1,15),15,' ')||
1188: rpad(benutils.id(p_person_id),8,' ')||
1189: 'Typ: '||

Line 1188: rpad(benutils.id(p_person_id),8,' ')||

1184: --
1185: write(p_text => benutils.g_banner_asterix);
1186: l_output_string := 'Name: '||
1187: rpad(substr(g_cache_person.full_name,1,15),15,' ')||
1188: rpad(benutils.id(p_person_id),8,' ')||
1189: 'Typ: '||
1190: rpad(substr(g_cache_person_types(1).user_person_type,1,15)
1191: ,15,' ') ||
1192: rpad('',8,' ')|| ' Grp: '||

Line 1194: rpad(benutils.id(g_cache_person.benefit_group_id),8,' ');

1190: rpad(substr(g_cache_person_types(1).user_person_type,1,15)
1191: ,15,' ') ||
1192: rpad('',8,' ')|| ' Grp: '||
1193: rpad(substr(g_cache_person.benefit_group,1,15),15,' ')||
1194: rpad(benutils.id(g_cache_person.benefit_group_id),8,' ');
1195: write(p_text => l_output_string);
1196: --
1197: -- loop through the rest of the person_types
1198: --

Line 1207: rpad(benutils.id(p_business_group_id),8,' ')||

1203: write(l_output_string);
1204: End loop;
1205: l_output_string := 'BG: '||
1206: rpad(substr(g_cache_person.bg_name,1,15),15,' ')||
1207: rpad(benutils.id(p_business_group_id),8,' ')||
1208: ' Org: '||
1209: rpad(substr(g_cache_person.org_name,1,15),15,' ')||
1210: rpad(benutils.id(g_cache_person.org_id),8,' ');
1211: --

Line 1210: rpad(benutils.id(g_cache_person.org_id),8,' ');

1206: rpad(substr(g_cache_person.bg_name,1,15),15,' ')||
1207: rpad(benutils.id(p_business_group_id),8,' ')||
1208: ' Org: '||
1209: rpad(substr(g_cache_person.org_name,1,15),15,' ')||
1210: rpad(benutils.id(g_cache_person.org_id),8,' ');
1211: --
1212: -- Need to add GRE
1213: --
1214: write(p_text => l_output_string);

Line 1217: rpad(benutils.id(g_cache_person.location_id),8,' ')||

1213: --
1214: write(p_text => l_output_string);
1215: l_output_string := 'Loc: '||
1216: rpad(substr(g_cache_person.address_line_1,1,15),15,' ')||
1217: rpad(benutils.id(g_cache_person.location_id),8,' ')||
1218: ' Pst: '||
1219: rpad(substr(g_cache_person.postal_code,1,15),15,' ')||
1220: rpad('',8,' ')||
1221: ' Pyr: '||

Line 1223: rpad(benutils.id(g_cache_person.payroll_id),8,' ');

1219: rpad(substr(g_cache_person.postal_code,1,15),15,' ')||
1220: rpad('',8,' ')||
1221: ' Pyr: '||
1222: rpad(substr(g_cache_person.payroll_name,1,15),15,' ')||
1223: rpad(benutils.id(g_cache_person.payroll_id),8,' ');
1224: write(p_text => l_output_string);
1225: hr_utility.set_location ('Leaving '||l_proc,10);
1226: end person_header;
1227: --

Line 1298: benutils.iftrue

1294: --
1295: l_actn := 'Printing p_pgm_id';
1296: If (nvl(p_pgm_id,-1) <> hr_api.g_number) then
1297: write(p_text => 'Program ID :'||
1298: benutils.iftrue
1299: (p_expression => p_pgm_id is null
1300: ,p_true => 'All'
1301: ,p_false => p_pgm_id));
1302: End if;

Line 1307: benutils.iftrue

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

Line 1316: benutils.iftrue

1312: --
1313: l_actn := 'Printing p_pl_typ_id...';
1314: If (nvl(p_pl_typ_id,-1) <> hr_api.g_number) then
1315: write(p_text => 'Plan Type ID :'||
1316: benutils.iftrue
1317: (p_expression => p_pl_typ_id is null
1318: ,p_true => 'All'
1319: ,p_false => p_pl_typ_id));
1320: End if;

Line 1325: benutils.iftrue

1321: --
1322: l_actn := 'Printting p_opt_id... ';
1323: If (nvl(p_opt_id,-1) <> hr_api.g_number) then
1324: write(p_text => 'Option ID :'||
1325: benutils.iftrue
1326: (p_expression => p_opt_id is null
1327: ,p_true => 'All'
1328: ,p_false => p_opt_id));
1329: End if;

Line 1334: benutils.iftrue

1330: --
1331: l_actn := 'Printting p_popl_enrt_typ_cycl...';
1332: If (nvl(p_popl_enrt_typ_cycl_id,-1) <> hr_api.g_number) then
1333: write(p_text => 'Enrollment Type Cycle :'||
1334: benutils.iftrue
1335: (p_expression => p_popl_enrt_typ_cycl_id is null
1336: ,p_true => 'All'
1337: ,p_false => p_popl_enrt_typ_cycl_id));
1338: End if;

Line 1355: benutils.iftrue

1351: --
1352: l_actn := 'Printting p_rptg_grp_id...';
1353: If (nvl(p_rptg_grp_id,-1) <> hr_api.g_number) then
1354: write(p_text => 'Reporting Group :'||
1355: benutils.iftrue
1356: (p_expression => p_rptg_grp_id is null
1357: ,p_true => 'All'
1358: ,p_false => p_rptg_grp_id));
1359: End if;

Line 1364: benutils.iftrue

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

Line 1373: benutils.iftrue

1369: --
1370: l_actn := 'Printting p_vrbl_rt_prfl_id...';
1371: If (nvl(p_vrbl_rt_prfl_id,-1) <> hr_api.g_number) then
1372: write(p_text => 'Variable Rate Profile :'||
1373: benutils.iftrue
1374: (p_expression => p_vrbl_rt_prfl_id is null
1375: ,p_true => 'All'
1376: ,p_false => p_vrbl_rt_prfl_id));
1377: End if;

Line 1382: benutils.iftrue

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

Line 1391: benutils.iftrue

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

Line 1400: benutils.iftrue

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

Line 1409: benutils.iftrue

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

Line 1418: benutils.iftrue

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

Line 1427: benutils.iftrue

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

Line 1436: benutils.iftrue

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

Line 1445: benutils.iftrue

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

Line 1454: benutils.iftrue

1450: --
1451: l_actn := 'Printting p_payroll_id...';
1452: If (nvl(p_payroll_id,-1) <> hr_api.g_number) then
1453: write(p_text => 'Payroll ID :'||
1454: benutils.iftrue
1455: (p_expression => p_payroll_id is null
1456: ,p_true => 'None'
1457: ,p_false => p_payroll_id));
1458: End if;

Line 1463: benutils.iftrue

1459: --
1460: l_actn := 'Printting p_comp_selection_rule_id...';
1461: If (nvl(p_comp_selection_rule_id,-1) <> hr_api.g_number) then
1462: write(p_text => 'Comp Object Selection Rule :'||
1463: benutils.iftrue
1464: (p_expression => p_comp_selection_rule_id is null
1465: ,p_true => 'None'
1466: ,p_false => p_comp_selection_rule_id));
1467: End if;

Line 1556: l_actn := 'Calling benutils.formula procedure...';

1552: end if;
1553: --
1554: -- Call formula initialise routine
1555: --
1556: l_actn := 'Calling benutils.formula procedure...';
1557: l_outputs := benutils.formula
1558: (p_formula_id => p_person_selection_rule_id
1559: ,p_effective_date => p_effective_date
1560: ,p_business_group_id => p_business_group_id

Line 1557: l_outputs := benutils.formula

1553: --
1554: -- Call formula initialise routine
1555: --
1556: l_actn := 'Calling benutils.formula procedure...';
1557: l_outputs := benutils.formula
1558: (p_formula_id => p_person_selection_rule_id
1559: ,p_effective_date => p_effective_date
1560: ,p_business_group_id => p_business_group_id
1561: ,p_assignment_id => l_assignment_id

Line 1568: l_actn := 'Evaluating benutils.formula return...';

1564: ,p_param2 => p_input1
1565: ,p_param2_value => p_input1_value);
1566: l_return := l_outputs(l_outputs.first).value;
1567: --
1568: l_actn := 'Evaluating benutils.formula return...';
1569: --
1570: If upper(l_return) not in ('Y', 'N') then
1571: --
1572: -- Defensive coding for Non Y return

Line 1808: l_msg_error_cd := benutils.get_message_name;

1804: begin
1805: --
1806: l_actn := 'getting error message..';
1807: --
1808: l_msg_error_cd := benutils.get_message_name;
1809: l_msg := fnd_message.get;
1810: --
1811: write(p_text => l_msg);
1812: --

Line 2446: l_actn := 'Calling benutils.formula procedure...';

2442: end if;
2443: --
2444: -- Call formula initialise routine
2445: --
2446: l_actn := 'Calling benutils.formula procedure...';
2447:
2448: if(l_flag) then
2449: l_outputs := benutils.formula
2450: (p_formula_id => p_person_selection_rule_id

Line 2449: l_outputs := benutils.formula

2445: --
2446: l_actn := 'Calling benutils.formula procedure...';
2447:
2448: if(l_flag) then
2449: l_outputs := benutils.formula
2450: (p_formula_id => p_person_selection_rule_id
2451: ,p_effective_date => p_effective_date
2452: ,p_business_group_id => p_business_group_id
2453: ,p_assignment_id => l_assignment_id

Line 2463: l_actn := 'Evaluating benutils.formula return...';

2459: else
2460: p_return := 'N';
2461: end if;
2462: --
2463: l_actn := 'Evaluating benutils.formula return...';
2464: --
2465: If upper(p_return) not in ('Y', 'N') then
2466: Raise value_exception ;
2467: End if;