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.PER_COBRA_COV_ENROLLMENTS_PKG dependencies on HR_UTILITY

Line 49: hr_utility.set_location('cce insert_row', 0);

45: --
46: CURSOR C2 IS SELECT per_cobra_cov_enrollments_s.nextval FROM sys.dual;
47: BEGIN
48: --
49: hr_utility.set_location('cce insert_row', 0);
50: --
51: if (X_Cobra_Coverage_Enrollment_Id is NULL) then
52: OPEN C2;
53: FETCH C2 INTO X_Cobra_Coverage_Enrollment_Id;

Line 179: hr_utility.set_location('cce lock_row', 0);

175: /* FOR UPDATE of COBRA_COVERAGE_ENROLLMENT_ID NOWAIT; */
176: Recinfo C%ROWTYPE;
177: BEGIN
178: --
179: hr_utility.set_location('cce lock_row', 0);
180: --
181: OPEN C;
182: FETCH C INTO Recinfo;
183: if (C%NOTFOUND) then

Line 322: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');

318: AND (X_comments IS NULL)))
319: ) then
320: return;
321: else
322: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');
323: hr_utility.raise_error;
324: end if;
325: END Lock_Row;
326: --

Line 323: hr_utility.raise_error;

319: ) then
320: return;
321: else
322: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');
323: hr_utility.raise_error;
324: end if;
325: END Lock_Row;
326: --
327: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 363: hr_utility.set_location('cce update_row', 0);

359: X_Comments VARCHAR2
360: ) IS
361: BEGIN
362: --
363: hr_utility.set_location('cce update_row', 0);
364: --
365: UPDATE per_cobra_cov_enrollments
366: SET
367: business_group_id = X_Business_Group_Id,

Line 410: hr_utility.set_location('cce delete_row', 0);

406: --
407: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
408: BEGIN
409: --
410: hr_utility.set_location('cce delete_row', 0);
411: --
412: DELETE FROM per_cobra_cov_enrollments
413: WHERE rowid = X_Rowid;
414: --

Line 475: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',1);

471: AND cce.contact_relationship_id IS NOT NULL;
472: --
473: BEGIN
474: --
475: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',1);
476: --
477: --
478: -- check to see if contact entered
479: --

Line 486: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',2);

482: --
483: -- Check employee coverage
484: --
485: --
486: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',2);
487: --
488: OPEN employee_coverage;
489: FETCH employee_coverage INTO l_coverage_exists;
490: CLOSE employee_coverage;

Line 492: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',3);

488: OPEN employee_coverage;
489: FETCH employee_coverage INTO l_coverage_exists;
490: CLOSE employee_coverage;
491: --
492: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',3);
493: --
494: ELSE
495: --
496: -- Check contact coverage

Line 499: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',4);

495: --
496: -- Check contact coverage
497: --
498: --
499: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',4);
500: --
501: OPEN contact_coverage;
502: FETCH contact_coverage INTO l_coverage_exists;
503: CLOSE contact_coverage;

Line 505: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',5);

501: OPEN contact_coverage;
502: FETCH contact_coverage INTO l_coverage_exists;
503: CLOSE contact_coverage;
504: --
505: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',5);
506: --
507: END IF;
508: --
509: -- check to see if coverage exists

Line 512: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',6);

508: --
509: -- check to see if coverage exists
510: --
511: --
512: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',6);
513: --
514: IF (l_coverage_exists = 'C')
515: THEN
516: --

Line 520: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',7);

516: --
517: -- error
518: --
519: --
520: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',7);
521: --
522: hr_utility.set_message(801, 'HR_13142_DEP_COV_EXISTS');
523: hr_utility.raise_error;
524: --

Line 522: hr_utility.set_message(801, 'HR_13142_DEP_COV_EXISTS');

518: --
519: --
520: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',7);
521: --
522: hr_utility.set_message(801, 'HR_13142_DEP_COV_EXISTS');
523: hr_utility.raise_error;
524: --
525: ELSIF (l_coverage_exists = 'E')
526: THEN

Line 523: hr_utility.raise_error;

519: --
520: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',7);
521: --
522: hr_utility.set_message(801, 'HR_13142_DEP_COV_EXISTS');
523: hr_utility.raise_error;
524: --
525: ELSIF (l_coverage_exists = 'E')
526: THEN
527: --

Line 528: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',8);

524: --
525: ELSIF (l_coverage_exists = 'E')
526: THEN
527: --
528: hr_utility.set_location('cce.hr_cobra_chk_uinique_enrollment',8);
529: --
530: --
531: -- error
532: --

Line 533: hr_utility.set_message(801, 'HR_13141_COBRA_EMP_COV_EXISTS');

529: --
530: --
531: -- error
532: --
533: hr_utility.set_message(801, 'HR_13141_COBRA_EMP_COV_EXISTS');
534: hr_utility.raise_error;
535: --
536: END IF;
537: --

Line 534: hr_utility.raise_error;

530: --
531: -- error
532: --
533: hr_utility.set_message(801, 'HR_13141_COBRA_EMP_COV_EXISTS');
534: hr_utility.raise_error;
535: --
536: END IF;
537: --
538: END hr_cobra_chk_unique_enrollment;