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.HRWSECI dependencies on HRWSECI

Line 1: PACKAGE BODY hrwseci AS

1: PACKAGE BODY hrwseci AS
2: /* $Header: pecobeci.pkb 115.7 1999/11/05 15:04:40 pkm ship $ */
3: --
4: --
5: --

Line 21: l_package VARCHAR2(70) := 'hrwseci.person_disabled';

17: FUNCTION person_disabled (p_person_id IN NUMBER,
18: p_qualifying_start_date IN DATE) RETURN BOOLEAN IS
19: --
20: l_disabled VARCHAR2(30);
21: l_package VARCHAR2(70) := 'hrwseci.person_disabled';
22: --
23: -- This next cursor checks whether a person holds disabled status at the
24: -- start of the qualifying event or within the first sixty days of the
25: -- coverage period.

Line 147: l_package VARCHAR2(70) := 'hrwseci.check_cobra_coverage_period';

143: p_type_code IN VARCHAR2,
144: p_coverage OUT NUMBER,
145: p_coverage_uom OUT VARCHAR2) IS
146: --
147: l_package VARCHAR2(70) := 'hrwseci.check_cobra_coverage_period';
148: --
149: -- This next cursor returns the coverage period for the condition.
150: --
151: CURSOR C1 IS

Line 258: hr_utility.set_location('hrwseci.hr_cobra_chk_event_eligible', 0);

254: OR a.normal_hours IS NULL );
255: --
256: BEGIN
257: --
258: hr_utility.set_location('hrwseci.hr_cobra_chk_event_eligible', 0);
259: --
260: --
261: -- Check to see what event we are testing for.
262: --

Line 378: hr_utility.set_location('hrwseci.hr_cobra_chk_benefits_exist', 0);

374: bc.cobra_flag = 'Y';
375: --
376: BEGIN
377: --
378: hr_utility.set_location('hrwseci.hr_cobra_chk_benefits_exist', 0);
379: --
380: --
381: -- Initialise last eligible date - i.e. to pick out plans
382: -- the employee was eligible for the day before qualifying

Line 438: hr_utility.set_location('hrwseci.hr_get_assignment_info', 0);

434: a.effective_end_date;
435: --
436: BEGIN
437: --
438: hr_utility.set_location('hrwseci.hr_get_assignment_info', 0);
439: --
440: -- get org id
441: --
442: OPEN org_id;

Line 484: hr_utility.set_location('hrwseci.hr_cobra_chk_elect_status', 0);

480: AND ccs.cobra_coverage_status_type = 'ELEC';
481: --
482: BEGIN
483: --
484: hr_utility.set_location('hrwseci.hr_cobra_chk_elect_status', 0);
485: --
486: --
487: -- fetch status
488: --

Line 537: hr_utility.set_location('hrwseci.hr_cobra_get_await_meaning', 0);

533: AND lookup_code = 'AWAIT';
534: --
535: BEGIN
536: --
537: hr_utility.set_location('hrwseci.hr_cobra_get_await_meaning', 0);
538: --
539: --
540: -- get the meaning
541: --

Line 580: hr_utility.set_location('hrwseci.hr_cobra_get_period_type', 0);

576: AND tpt.system_flag = 'Y';
577: --
578: BEGIN
579: --
580: hr_utility.set_location('hrwseci.hr_cobra_get_period_type', 0);
581: --
582: --
583: -- get default period type
584: --

Line 667: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',1);

663: --
664: -- hr_utility.trace_on;
665: --
666: --
667: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',1);
668: --
669: per_cobra_cov_enrollments_pkg.hr_cobra_chk_unique_enrollment (
670: p_cobra_coverage_enrollment_id,
671: p_assignment_id,

Line 679: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',2);

675: --
676: -- Call check benefits exists
677: --
678: --
679: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',2);
680: --
681: hr_cobra_chk_benefits_exist ( p_assignment_id,
682: p_qualifying_date );
683: --

Line 687: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',3);

683: --
684: -- check eligible for event
685: --
686: --
687: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',3);
688: --
689: IF (p_qualifying_event IN ('T', 'RH'))
690: THEN
691: hr_cobra_chk_event_eligible( p_organization_id,

Line 703: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',4);

699: --
700: -- Do insert
701: --
702: --
703: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',4);
704: --
705: per_cobra_cov_enrollments_pkg.insert_row(
706: p_rowid,
707: p_cobra_coverage_enrollment_id,

Line 782: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',7);

778: --
779: --
780: -- create cobra coverage benefits
781: --
782: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',7);
783: --
784: hr_cobra_ins_benefits(p_cobra_coverage_enrollment_id,
785: p_business_group_id,
786: p_assignment_id,

Line 789: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',8);

785: p_business_group_id,
786: p_assignment_id,
787: p_qualifying_date);
788: --
789: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',8);
790: --
791: --
792: -- Calculate amount charged
793: --

Line 796: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',9);

792: -- Calculate amount charged
793: --
794: p_amount_charged := hr_cobra_calc_amt_charged ( p_cobra_coverage_enrollment_id );
795: --
796: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',9);
797: --
798: -- Check to see if need to create payments
799: --
800: IF ( p_first_payment_due_date IS NOT NULL )

Line 846: hr_utility.set_location('hrwseci.hr_cobra_ins_benefits', 0);

842: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
843: --
844: BEGIN
845: --
846: hr_utility.set_location('hrwseci.hr_cobra_ins_benefits', 0);
847: --
848: --
849: -- insert benefits
850: --

Line 953: hr_utility.set_location('hrwseci.hr_cobra_ins_benefits', 0);

949: bc.element_type_id IS NULL
950: );
951: --
952: --
953: hr_utility.set_location('hrwseci.hr_cobra_ins_benefits', 0);
954: --
955: --
956: --
957: END hr_cobra_ins_benefits;

Line 996: hr_utility.set_location('hrwseci.hr_cobra_calc_amt_charged', 0);

992: AND ccb.accept_reject_flag = 'ACC';
993: --
994: BEGIN
995: --
996: hr_utility.set_location('hrwseci.hr_cobra_calc_amt_charged', 0);
997: --
998: --
999: -- get amount charged
1000: --

Line 1055: hr_utility.set_location('hrwseci.hr_cobra_ins_schedule', 0);

1051: FROM dual;
1052: --
1053: BEGIN
1054: --
1055: hr_utility.set_location('hrwseci.hr_cobra_ins_schedule', 0);
1056: --
1057: WHILE (l_count < (p_event_coverage)) LOOP
1058: --
1059: -- get scp id

Line 1220: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 1);

1216: BEGIN
1217: --
1218: -- hr_utility.trace_on;
1219: --
1220: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 1);
1221: --
1222: per_cobra_cov_enrollments_pkg.hr_cobra_chk_unique_enrollment (
1223: p_cobra_coverage_enrollment_id,
1224: p_assignment_id,

Line 1229: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 2);

1225: p_contact_relationship_id,
1226: p_qualifying_event,
1227: p_qualifying_date );
1228: --
1229: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 2);
1230: --
1231: -- do update
1232: --
1233: per_cobra_cov_enrollments_pkg.update_row(

Line 1271: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 3);

1267: --
1268: -- check insert or update status
1269: --
1270: --
1271: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 3);
1272: --
1273: --
1274: -- Check coverage dates
1275: --

Line 1282: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 4);

1278: --
1279: -- check if status of elect exists
1280: --
1281: --
1282: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 4);
1283: --
1284: IF (hr_cobra_chk_elect_status( p_cobra_coverage_enrollment_id ))
1285: THEN
1286: --

Line 1290: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 5);

1286: --
1287: -- error
1288: --
1289: --
1290: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 5);
1291: --
1292: hr_utility.set_message( 801, 'HR_13113_COBRA_MAND_DATES_ELEC');
1293: hr_utility.raise_error;
1294: --

Line 1298: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 6);

1294: --
1295: END IF;
1296: --
1297: END IF;
1298: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 6);
1299: --
1300: --
1301: -- calculate amount charged
1302: --

Line 1305: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 7);

1301: -- calculate amount charged
1302: --
1303: p_amount_charged := hr_cobra_calc_amt_charged( p_cobra_coverage_enrollment_id );
1304: --
1305: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 7);
1306: -- hr_utility.trace(p_amount_charged);
1307: --
1308: --
1309: -- check if need to create payment schedules

Line 1398: hr_utility.set_location('hrwseci.hr_cobra_get_current_status', 0);

1394: AND h.lookup_type = 'US_COBRA_STATUS';
1395: --
1396: BEGIN
1397: --
1398: hr_utility.set_location('hrwseci.hr_cobra_get_current_status', 0);
1399: --
1400: --
1401: -- get latest status info
1402: --

Line 1466: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 1);

1462: BEGIN
1463: --
1464: -- hr_utility.trace_on;
1465: --
1466: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 1);
1467: --
1468: --
1469: -- Call to check status is unique
1470: --

Line 1477: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 2);

1473: p_cobra_coverage_status_id,
1474: p_cobra_coverage_enrollment_id,
1475: p_cobra_coverage_status_type );
1476: --
1477: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 2);
1478: --
1479: --
1480: -- Call to check elect/rej not co-existing
1481: --

Line 1491: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 3);

1487: p_cobra_coverage_status_id,
1488: p_cobra_coverage_status_type );
1489: END IF;
1490: --
1491: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 3);
1492: --
1493: --
1494: -- Call to check status inserted in correct order
1495: --

Line 1503: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 4);

1499: p_cobra_coverage_status_id,
1500: p_cobra_coverage_status_type,
1501: p_effective_date );
1502: --
1503: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 4);
1504: --
1505: --
1506: -- do insert
1507: --

Line 1538: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 5);

1534: p_Attribute19,
1535: p_Attribute20,
1536: p_comments );
1537: --
1538: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 5);
1539: --
1540: --
1541: -- get the current status
1542: --

Line 1550: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 6);

1546: p_current_status_meaning,
1547: p_current_status_date,
1548: p_current_d_status_date );
1549: --
1550: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 6);
1551: --
1552: --
1553: END hr_cobra_do_ccs_insert;
1554: --

Line 1606: hr_utility.set_location('hrwseci.hr_cobra_do_ccs_update', 1);

1602: --
1603: -- hr_utility.trace_on;
1604: --
1605: --
1606: hr_utility.set_location('hrwseci.hr_cobra_do_ccs_update', 1);
1607: --
1608: -- Call to check status is unique
1609: --
1610: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique

Line 1618: hr_utility.set_location('hrwseci.hr_cobra_do_ccs_update', 2);

1614: p_cobra_coverage_status_type );
1615: --
1616: --
1617: --
1618: hr_utility.set_location('hrwseci.hr_cobra_do_ccs_update', 2);
1619: --
1620: -- before inserting new status check that elct/reject to not coexist
1621: --
1622: IF( p_cobra_coverage_status_type IN ('ELEC', 'REJ'))

Line 1625: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 4);

1621: --
1622: IF( p_cobra_coverage_status_type IN ('ELEC', 'REJ'))
1623: THEN
1624: --
1625: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 4);
1626: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej (
1627: p_business_group_id,
1628: p_cobra_coverage_enrollment_id,
1629: p_cobra_coverage_status_id,

Line 1633: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 3);

1629: p_cobra_coverage_status_id,
1630: p_cobra_coverage_status_type );
1631: END IF;
1632: --
1633: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 3);
1634: --
1635: --
1636: -- check status order
1637: --

Line 1649: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 5);

1645: --
1646: -- update status
1647: --
1648: --
1649: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 5);
1650: --
1651: per_cobra_cov_statuses_pkg.update_row(p_rowid,
1652: p_Business_Group_Id,
1653: p_Cobra_Coverage_Enrollment_Id,

Line 1729: hr_utility.set_location('hrwseci.hr_cobra_button_status', 0);

1725: BEGIN
1726: --
1727: -- hr_utility.trace_on;
1728: --
1729: hr_utility.set_location('hrwseci.hr_cobra_button_status', 0);
1730: --
1731: --
1732: -- Call to check status is unique
1733: --

Line 1740: hr_utility.set_location('hrwseci.hr_cobra_button_status', 1);

1736: NULL,
1737: p_cobra_coverage_enrollment_id,
1738: p_status );
1739: --
1740: hr_utility.set_location('hrwseci.hr_cobra_button_status', 1);
1741: --
1742: --
1743: -- Call to check elect/rej not co-existing
1744: --

Line 1754: hr_utility.set_location('hrwseci.hr_cobra_button_status', 2);

1750: NULL,
1751: p_status );
1752: END IF;
1753: --
1754: hr_utility.set_location('hrwseci.hr_cobra_button_status', 2);
1755: --
1756: --
1757: -- Call to check status inserted in correct order
1758: --

Line 1766: hr_utility.set_location('hrwseci.hr_cobra_button_status', 3);

1762: NULL,
1763: p_status,
1764: p_status_date);
1765: --
1766: hr_utility.set_location('hrwseci.hr_cobra_button_status', 3);
1767: --
1768: --
1769: -- do insert
1770: --

Line 1801: hr_utility.set_location('hrwseci.hr_cobra_button_status', 4);

1797: NULL,
1798: NULL,
1799: NULL);
1800: --
1801: hr_utility.set_location('hrwseci.hr_cobra_button_status', 4);
1802: --
1803: --
1804: --
1805: -- get current status

Line 1814: hr_utility.set_location('hrwseci.hr_cobra_button_status', 5);

1810: p_status_meaning,
1811: p_status_date,
1812: p_d_status_date );
1813: --
1814: hr_utility.set_location('hrwseci.hr_cobra_button_status', 5);
1815: --
1816: --
1817: --
1818: END hr_cobra_button_status;

Line 1901: hr_utility.set_location('hrwseci.hr_cobra_chk_dup_pay_due_date', 0);

1897: AND scp.date_due = p_due_date;
1898: --
1899: BEGIN
1900: --
1901: hr_utility.set_location('hrwseci.hr_cobra_chk_dup_pay_due_date', 0);
1902: --
1903: --
1904: -- get duplicate due dates
1905: --

Line 1910: hr_utility.set_location('hrwseci.chk dup pay due date', 1);

1906: OPEN due_date;
1907: FETCH due_date INTO l_duplicate_due_date;
1908: CLOSE due_date;
1909: --
1910: hr_utility.set_location('hrwseci.chk dup pay due date', 1);
1911: --
1912: --
1913: -- chk duplicate due dates
1914: --

Line 1918: hr_utility.set_location('hrwseci.chk dup pay due date', 2);

1914: --
1915: IF (l_duplicate_due_date = 'Y')
1916: THEN
1917: --
1918: hr_utility.set_location('hrwseci.chk dup pay due date', 2);
1919: --
1920: hr_utility.set_message( 801, 'HR_13145_COBRA_DUP_SCHED');
1921: hr_utility.raise_error;
1922: --

Line 1925: hr_utility.set_location('hrwseci.chk dup pay due date', 3);

1921: hr_utility.raise_error;
1922: --
1923: END IF;
1924: --
1925: hr_utility.set_location('hrwseci.chk dup pay due date', 3);
1926: --
1927: --
1928: END hr_cobra_chk_dup_pay_due_date;
1929: --

Line 1966: hr_utility.set_location('hrwseci.do scp insert', 1);

1962: --
1963: -- chekc for duplicate due date
1964: --
1965: --
1966: hr_utility.set_location('hrwseci.do scp insert', 1);
1967: --
1968: hr_cobra_chk_dup_pay_due_date( p_scheduled_cobra_payment_id,
1969: p_cobra_coverage_enrollment_id,
1970: p_due_date );

Line 1972: hr_utility.set_location('hrwseci.do scp insert', 2);

1968: hr_cobra_chk_dup_pay_due_date( p_scheduled_cobra_payment_id,
1969: p_cobra_coverage_enrollment_id,
1970: p_due_date );
1971: --
1972: hr_utility.set_location('hrwseci.do scp insert', 2);
1973: --
1974: --
1975: -- get new scp_id
1976: --

Line 1981: hr_utility.set_location('hrwseci.do scp insert', 3);

1977: OPEN scp_id;
1978: FETCH scp_id INTO p_scheduled_cobra_payment_id;
1979: CLOSE scp_id;
1980: --
1981: hr_utility.set_location('hrwseci.do scp insert', 3);
1982: --
1983: END hr_cobra_do_scp_pre_insert;
1984: --
1985: --

Line 2013: hr_utility.set_location('hrwseci.do scp update', 1);

2009: --
2010: -- chekc for duplicate due date
2011: --
2012: --
2013: hr_utility.set_location('hrwseci.do scp update', 1);
2014: --
2015: hr_cobra_chk_dup_pay_due_date( p_scheduled_cobra_payment_id,
2016: p_cobra_coverage_enrollment_id,
2017: p_due_date );

Line 2113: hr_utility.set_location('hrwseci.cobra def cobra cost', 1);

2109: BEGIN
2110: --
2111: -- get contributions - if any
2112: --
2113: hr_utility.set_location('hrwseci.cobra def cobra cost', 1);
2114: OPEN coverage_amount;
2115: FETCH coverage_amount INTO p_coverage_amount, p_basic_cost;
2116: --
2117: -- check if any coverage

Line 2119: hr_utility.set_location('hrwseci.cobra def cobra cost', 2);

2115: FETCH coverage_amount INTO p_coverage_amount, p_basic_cost;
2116: --
2117: -- check if any coverage
2118: --
2119: hr_utility.set_location('hrwseci.cobra def cobra cost', 2);
2120: IF (coverage_amount%NOTFOUND)
2121: THEN
2122: hr_utility.set_location('hrwseci.cobra def cobra cost', 3);
2123: --

Line 2122: hr_utility.set_location('hrwseci.cobra def cobra cost', 3);

2118: --
2119: hr_utility.set_location('hrwseci.cobra def cobra cost', 2);
2120: IF (coverage_amount%NOTFOUND)
2121: THEN
2122: hr_utility.set_location('hrwseci.cobra def cobra cost', 3);
2123: --
2124: -- default 0.00
2125: --
2126: p_basic_cost := 0;

Line 2132: hr_utility.set_location('hrwseci.cobra def cobra cost', 4);

2128: END IF;
2129: --
2130: CLOSE coverage_amount;
2131: --
2132: hr_utility.set_location('hrwseci.cobra def cobra cost', 4);
2133: --
2134: --
2135: END hr_cobra_default_cobra_cost;
2136: --

Line 2465: hr_utility.set_location('hrwseci.get basic cost', 0);

2461: l_basic_cost NUMBER(15,2) := 0;
2462: --
2463: BEGIN
2464: --
2465: hr_utility.set_location('hrwseci.get basic cost', 0);
2466: --
2467: --
2468: OPEN chk_ee_exists;
2469: FETCH chk_ee_exists INTO l_ees_exist;

Line 2472: hr_utility.set_location('hrwseci.get basic cost', 1);

2468: OPEN chk_ee_exists;
2469: FETCH chk_ee_exists INTO l_ees_exist;
2470: CLOSE chk_ee_exists;
2471: --
2472: hr_utility.set_location('hrwseci.get basic cost', 1);
2473: --
2474: --
2475: IF ( l_ees_exist = 'Y' )
2476: THEN

Line 2478: hr_utility.set_location('hrwseci.get basic cost', 2);

2474: --
2475: IF ( l_ees_exist = 'Y' )
2476: THEN
2477: --
2478: hr_utility.set_location('hrwseci.get basic cost', 2);
2479: --
2480: --
2481: OPEN get_basic_cost_ee;
2482: FETCH get_basic_cost_ee INTO l_basic_cost;

Line 2487: hr_utility.set_location('hrwseci.get basic cost', 3);

2483: CLOSE get_basic_cost_ee;
2484: --
2485: ELSE
2486: --
2487: hr_utility.set_location('hrwseci.get basic cost', 3);
2488: --
2489: --
2490: OPEN get_basic_cost;
2491: FETCH get_basic_cost INTO l_basic_cost;

Line 2498: hr_utility.set_location('hrwseci.get basic cost', 4);

2494: END IF;
2495: --
2496: -- return basic cost
2497: --
2498: hr_utility.set_location('hrwseci.get basic cost', 4);
2499: --
2500: --
2501: RETURN l_basic_cost;
2502: --

Line 2568: p_await_meaning := hrwseci.hr_cobra_get_await_meaning;

2564: p_qualifying_date,
2565: p_organization_id,
2566: p_position_id);
2567: --
2568: p_await_meaning := hrwseci.hr_cobra_get_await_meaning;
2569: p_period_type := hrwseci.hr_cobra_get_period_type;
2570: --
2571: END eci_init_form;
2572: --

Line 2569: p_period_type := hrwseci.hr_cobra_get_period_type;

2565: p_organization_id,
2566: p_position_id);
2567: --
2568: p_await_meaning := hrwseci.hr_cobra_get_await_meaning;
2569: p_period_type := hrwseci.hr_cobra_get_period_type;
2570: --
2571: END eci_init_form;
2572: --
2573: Procedure chk_cobra_dependent_id(p_cobra_dependent_id in number,

Line 3290: END hrwseci;

3286: close c1;
3287: --
3288: end check_date_invalidation;
3289: --
3290: END hrwseci;