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 HR_UTILITY

Line 44: hr_utility.set_location('Entering '||l_package,10);

40: AND p_qualifying_start_date + 60);
41: --
42: BEGIN
43: --
44: hr_utility.set_location('Entering '||l_package,10);
45: --
46: -- Check if person is disabled within first 60 days of cobra coverage.
47: --
48: OPEN C1;

Line 64: hr_utility.set_location('Leaving '||l_package,10);

60: RETURN FALSE;
61: --
62: END IF;
63: --
64: hr_utility.set_location('Leaving '||l_package,10);
65: --
66: END person_disabled;
67: --
68: Function coverage_exceeded

Line 172: hr_utility.set_location('Entering '||l_package,10);

168: AND EFFECTIVE_END_DATE;
169: --
170: BEGIN
171: --
172: hr_utility.set_location('Entering '||l_package,10);
173: --
174: -- Check Condition Code and whether it returns any coverage
175: -- period and unit of measure.
176: --

Line 183: hr_utility.set_location('Leaving '||l_package,10);

179: FETCH C1 INTO p_coverage, p_coverage_uom;
180: --
181: CLOSE C1;
182: --
183: hr_utility.set_location('Leaving '||l_package,10);
184: --
185: END check_cobra_coverage_period;
186: --
187: -- Name hr_cobra_chk_event_eligible

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 314: hr_utility.set_message(801, 'HR_13110_COBRA_NOT_TERM');

310: -- chk which event and raise error
311: --
312: IF (p_qualifying_event = 'T')
313: THEN
314: hr_utility.set_message(801, 'HR_13110_COBRA_NOT_TERM');
315: hr_utility.raise_error;
316: ELSE
317: hr_utility.set_message(801, 'HR_13111_COBRA_NOT_RDCD_HRS');
318: hr_utility.raise_error;

Line 315: hr_utility.raise_error;

311: --
312: IF (p_qualifying_event = 'T')
313: THEN
314: hr_utility.set_message(801, 'HR_13110_COBRA_NOT_TERM');
315: hr_utility.raise_error;
316: ELSE
317: hr_utility.set_message(801, 'HR_13111_COBRA_NOT_RDCD_HRS');
318: hr_utility.raise_error;
319: END IF;

Line 317: hr_utility.set_message(801, 'HR_13111_COBRA_NOT_RDCD_HRS');

313: THEN
314: hr_utility.set_message(801, 'HR_13110_COBRA_NOT_TERM');
315: hr_utility.raise_error;
316: ELSE
317: hr_utility.set_message(801, 'HR_13111_COBRA_NOT_RDCD_HRS');
318: hr_utility.raise_error;
319: END IF;
320: --
321: END IF;

Line 318: hr_utility.raise_error;

314: hr_utility.set_message(801, 'HR_13110_COBRA_NOT_TERM');
315: hr_utility.raise_error;
316: ELSE
317: hr_utility.set_message(801, 'HR_13111_COBRA_NOT_RDCD_HRS');
318: hr_utility.raise_error;
319: END IF;
320: --
321: END IF;
322: --

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 398: hr_utility.set_message(801, 'HR_13112_COBRA_NO_BEN_EXIST');

394: --
395: IF (l_cobra_benefits_exist = 'N')
396: THEN
397: -- raise error
398: hr_utility.set_message(801, 'HR_13112_COBRA_NO_BEN_EXIST');
399: hr_utility.raise_error;
400: --
401: END IF;
402: END hr_cobra_chk_benefits_exist;

Line 399: hr_utility.raise_error;

395: IF (l_cobra_benefits_exist = 'N')
396: THEN
397: -- raise error
398: hr_utility.set_message(801, 'HR_13112_COBRA_NO_BEN_EXIST');
399: hr_utility.raise_error;
400: --
401: END IF;
402: END hr_cobra_chk_benefits_exist;
403: --

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 664: -- hr_utility.trace_on;

660: BEGIN
661: --
662: --
663: --
664: -- hr_utility.trace_on;
665: --
666: --
667: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',1);
668: --

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 1218: -- hr_utility.trace_on;

1214: -- declare local variables
1215: --
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 (

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 1292: hr_utility.set_message( 801, 'HR_13113_COBRA_MAND_DATES_ELEC');

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: --
1295: END IF;
1296: --

Line 1293: hr_utility.raise_error;

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: --
1295: END IF;
1296: --
1297: END IF;

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 1306: -- hr_utility.trace(p_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
1310: --

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 1464: -- hr_utility.trace_on;

1460: p_session_date DATE ) IS
1461: --
1462: BEGIN
1463: --
1464: -- hr_utility.trace_on;
1465: --
1466: hr_utility.set_location('hrwseci.hr_cobra_do ccs insert', 1);
1467: --
1468: --

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 1603: -- hr_utility.trace_on;

1599: -- declare local variables
1600: --
1601: BEGIN
1602: --
1603: -- hr_utility.trace_on;
1604: --
1605: --
1606: hr_utility.set_location('hrwseci.hr_cobra_do_ccs_update', 1);
1607: --

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 1727: -- hr_utility.trace_on;

1723: p_dummy_id NUMBER(15);
1724: --
1725: BEGIN
1726: --
1727: -- hr_utility.trace_on;
1728: --
1729: hr_utility.set_location('hrwseci.hr_cobra_button_status', 0);
1730: --
1731: --

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 1920: hr_utility.set_message( 801, 'HR_13145_COBRA_DUP_SCHED');

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: --
1923: END IF;
1924: --

Line 1921: hr_utility.raise_error;

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: --
1923: END IF;
1924: --
1925: hr_utility.set_location('hrwseci.chk dup pay due date', 3);

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 1961: -- hr_utility.trace_on;

1957: FROM sys.dual;
1958: --
1959: BEGIN
1960: --
1961: -- hr_utility.trace_on;
1962: --
1963: -- chekc for duplicate due date
1964: --
1965: --

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 2008: -- hr_utility.trace_on;

2004: p_cobra_coverage_enrollment_id NUMBER,
2005: p_due_date DATE ) IS
2006: BEGIN
2007: --
2008: -- hr_utility.trace_on;
2009: --
2010: -- chekc for duplicate due date
2011: --
2012: --

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 2580: hr_utility.set_location('Entering:'||l_proc, 5);

2576: l_proc varchar2(72) := 'chk_cobra_dependent_id';
2577: --
2578: Begin
2579: --
2580: hr_utility.set_location('Entering:'||l_proc, 5);
2581: --
2582: if (p_object_version_number is not null and
2583: p_cobra_dependent_id
2584: <> nvl(g_old_rec.cobra_dependent_id,hr_api.g_number)) then

Line 2588: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');

2584: <> nvl(g_old_rec.cobra_dependent_id,hr_api.g_number)) then
2585: --
2586: -- raise error as PK has changed
2587: --
2588: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');
2589: hr_utility.raise_error;
2590: --
2591: elsif p_object_version_number is null then
2592: --

Line 2589: hr_utility.raise_error;

2585: --
2586: -- raise error as PK has changed
2587: --
2588: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');
2589: hr_utility.raise_error;
2590: --
2591: elsif p_object_version_number is null then
2592: --
2593: -- check if PK is null.

Line 2599: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');

2595: if p_cobra_dependent_id is not null then
2596: --
2597: -- raise error as PK is not null
2598: --
2599: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');
2600: hr_utility.raise_error;
2601: --
2602: end if;
2603: --

Line 2600: hr_utility.raise_error;

2596: --
2597: -- raise error as PK is not null
2598: --
2599: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');
2600: hr_utility.raise_error;
2601: --
2602: end if;
2603: --
2604: end if;

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

2602: end if;
2603: --
2604: end if;
2605: --
2606: hr_utility.set_location(' Leaving:'||l_proc, 10);
2607: --
2608: End chk_cobra_dependent_id;
2609: --
2610: Procedure chk_enrollment_id(p_cobra_dependent_id in number,

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

2631: and cov.coverage_end_date;
2632: --
2633: Begin
2634: --
2635: hr_utility.set_location('Entering:'||l_proc, 5);
2636: --
2637: if p_cobra_coverage_enrollment_id is null then
2638: --
2639: -- raise error as FK is null

Line 2641: hr_utility.set_message(801,'HR_52272_CDP_ENROLL_FK');

2637: if p_cobra_coverage_enrollment_id is null then
2638: --
2639: -- raise error as FK is null
2640: --
2641: hr_utility.set_message(801,'HR_52272_CDP_ENROLL_FK');
2642: hr_utility.raise_error;
2643: --
2644: end if;
2645: --

Line 2642: hr_utility.raise_error;

2638: --
2639: -- raise error as FK is null
2640: --
2641: hr_utility.set_message(801,'HR_52272_CDP_ENROLL_FK');
2642: hr_utility.raise_error;
2643: --
2644: end if;
2645: --
2646: -- Check if the enrollment is still valid as of the validation start

Line 2669: hr_utility.set_message(801,'HR_52273_CDP_DEP_DATES');

2665: --
2666: -- The dates for the covered dependent are outside of the dates of
2667: -- the cobra enrollment event. Raise ERROR.
2668: --
2669: hr_utility.set_message(801,'HR_52273_CDP_DEP_DATES');
2670: hr_utility.raise_error;
2671: --
2672: end if;
2673: --

Line 2670: hr_utility.raise_error;

2666: -- The dates for the covered dependent are outside of the dates of
2667: -- the cobra enrollment event. Raise ERROR.
2668: --
2669: hr_utility.set_message(801,'HR_52273_CDP_DEP_DATES');
2670: hr_utility.raise_error;
2671: --
2672: end if;
2673: --
2674: close c1;

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

2674: close c1;
2675: --
2676: end if;
2677: --
2678: hr_utility.set_location(' Leaving:'||l_proc, 10);
2679: --
2680: End chk_enrollment_id;
2681: --
2682: Procedure chk_contact_relationship_id

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

2694: where cre.contact_relationship_id = p_contact_relationship_id;
2695: --
2696: Begin
2697: --
2698: hr_utility.set_location('Entering:'||l_proc, 5);
2699: --
2700: if p_contact_relationship_id is null then
2701: --
2702: -- raise error as FK is null

Line 2704: hr_utility.set_message(801, 'HR_52274_CDP_INV_CONTACT');

2700: if p_contact_relationship_id is null then
2701: --
2702: -- raise error as FK is null
2703: --
2704: hr_utility.set_message(801, 'HR_52274_CDP_INV_CONTACT');
2705: hr_utility.raise_error;
2706: --
2707: end if;
2708: --

Line 2705: hr_utility.raise_error;

2701: --
2702: -- raise error as FK is null
2703: --
2704: hr_utility.set_message(801, 'HR_52274_CDP_INV_CONTACT');
2705: hr_utility.raise_error;
2706: --
2707: end if;
2708: --
2709: -- Make sure that contact exists in PER_CONTACT_RELATIONSHIPS table

Line 2717: hr_utility.set_message(801, 'HR_52274_CDP_INV_CONTACT');

2713: fetch c1 into l_dummy;
2714: if c1%notfound then
2715: --
2716: close c1;
2717: hr_utility.set_message(801, 'HR_52274_CDP_INV_CONTACT');
2718: hr_utility.raise_error;
2719: --
2720: end if;
2721: --

Line 2718: hr_utility.raise_error;

2714: if c1%notfound then
2715: --
2716: close c1;
2717: hr_utility.set_message(801, 'HR_52274_CDP_INV_CONTACT');
2718: hr_utility.raise_error;
2719: --
2720: end if;
2721: --
2722: close c1;

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

2720: end if;
2721: --
2722: close c1;
2723: --
2724: hr_utility.set_location(' Leaving:'||l_proc, 10);
2725: --
2726: End chk_contact_relationship_id;
2727: --
2728: Procedure chk_overlap (p_cobra_dependent_id in number,

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

2753: and cdp.effective_end_date);
2754: --
2755: Begin
2756: --
2757: hr_utility.set_location('Entering:'||l_proc, 5);
2758: --
2759: -- check whether the new record already exists within the timeframe
2760: -- for the same dependent. A dependent can only be covered once by
2761: -- any enrollment for any particular timeframe.

Line 2769: hr_utility.set_message(801,'HR_52275_CDP_DEP_COVERED');

2765: fetch c1 into l_dummy;
2766: if c1%found then
2767: --
2768: close c1;
2769: hr_utility.set_message(801,'HR_52275_CDP_DEP_COVERED');
2770: hr_utility.raise_error;
2771: --
2772: end if;
2773: --

Line 2770: hr_utility.raise_error;

2766: if c1%found then
2767: --
2768: close c1;
2769: hr_utility.set_message(801,'HR_52275_CDP_DEP_COVERED');
2770: hr_utility.raise_error;
2771: --
2772: end if;
2773: --
2774: close c1;

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

2772: end if;
2773: --
2774: close c1;
2775: --
2776: hr_utility.set_location(' Leaving:'||l_proc, 10);
2777: --
2778: End chk_overlap;
2779: --
2780: Procedure chk_unique_key (p_cobra_dependent_id in number,

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

2794: and cdp.effective_end_date = p_effective_end_date;
2795: --
2796: Begin
2797: --
2798: hr_utility.set_location('Entering:'||l_proc, 5);
2799: --
2800: open c1;
2801: --
2802: fetch c1 into l_dummy;

Line 2806: hr_utility.set_message(801, 'HR_52276_CDP_DEP_UK');

2802: fetch c1 into l_dummy;
2803: if c1%found then
2804: --
2805: close c1;
2806: hr_utility.set_message(801, 'HR_52276_CDP_DEP_UK');
2807: hr_utility.raise_error;
2808: --
2809: end if;
2810: --

Line 2807: hr_utility.raise_error;

2803: if c1%found then
2804: --
2805: close c1;
2806: hr_utility.set_message(801, 'HR_52276_CDP_DEP_UK');
2807: hr_utility.raise_error;
2808: --
2809: end if;
2810: --
2811: close c1;

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

2809: end if;
2810: --
2811: close c1;
2812: --
2813: hr_utility.set_location(' Leaving:'||l_proc, 10);
2814: --
2815: End chk_unique_key;
2816: --
2817: PROCEDURE hr_cobra_do_cdp_insert

Line 3121: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

3117: close lock_cdp;
3118: --
3119: -- The primary key is invalid therefore we must error
3120: --
3121: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
3122: hr_utility.raise_error;
3123: --
3124: end if;
3125: --

Line 3122: hr_utility.raise_error;

3118: --
3119: -- The primary key is invalid therefore we must error
3120: --
3121: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
3122: hr_utility.raise_error;
3123: --
3124: end if;
3125: --
3126: close lock_cdp;

Line 3129: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

3125: --
3126: close lock_cdp;
3127: --
3128: if (p_object_version_number <> g_old_rec.object_version_number) Then
3129: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3130: hr_utility.raise_error;
3131: end if;
3132: --
3133: exception

Line 3130: hr_utility.raise_error;

3126: close lock_cdp;
3127: --
3128: if (p_object_version_number <> g_old_rec.object_version_number) Then
3129: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3130: hr_utility.raise_error;
3131: end if;
3132: --
3133: exception
3134: when hr_api.object_locked then

Line 3139: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

3135: --
3136: -- The object is locked therefore we need to supply a meaningful
3137: -- error message.
3138: --
3139: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
3140: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3141: hr_utility.raise_error;
3142: --
3143: when l_object_invalid then

Line 3140: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');

3136: -- The object is locked therefore we need to supply a meaningful
3137: -- error message.
3138: --
3139: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
3140: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3141: hr_utility.raise_error;
3142: --
3143: when l_object_invalid then
3144: --

Line 3141: hr_utility.raise_error;

3137: -- error message.
3138: --
3139: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
3140: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3141: hr_utility.raise_error;
3142: --
3143: when l_object_invalid then
3144: --
3145: -- The object doesn't exist or is invalid

Line 3147: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

3143: when l_object_invalid then
3144: --
3145: -- The object doesn't exist or is invalid
3146: --
3147: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3148: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3149: hr_utility.raise_error;
3150: --
3151: end hr_cobra_do_cdp_lock;

Line 3148: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');

3144: --
3145: -- The object doesn't exist or is invalid
3146: --
3147: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3148: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3149: hr_utility.raise_error;
3150: --
3151: end hr_cobra_do_cdp_lock;
3152: --

Line 3149: hr_utility.raise_error;

3145: -- The object doesn't exist or is invalid
3146: --
3147: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3148: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3149: hr_utility.raise_error;
3150: --
3151: end hr_cobra_do_cdp_lock;
3152: --
3153: function dependent_born_in_coverage

Line 3281: hr_utility.set_message(801,'HR_52277_CDP_DEP_INVALID');

3277: fetch c1 into l_dummy;
3278: if c1%found then
3279: --
3280: close c1;
3281: hr_utility.set_message(801,'HR_52277_CDP_DEP_INVALID');
3282: hr_utility.raise_error;
3283: --
3284: end if;
3285: --

Line 3282: hr_utility.raise_error;

3278: if c1%found then
3279: --
3280: close c1;
3281: hr_utility.set_message(801,'HR_52277_CDP_DEP_INVALID');
3282: hr_utility.raise_error;
3283: --
3284: end if;
3285: --
3286: close c1;