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_STATUSES_PKG dependencies on HR_UTILITY

Line 42: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',1);

38: --
39: CURSOR C2 IS SELECT per_cobra_coverage_statuses_s.nextval FROM sys.dual;
40: BEGIN
41: --
42: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',1);
43: --
44: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',2);
45: --
46: if (X_Cobra_Coverage_Status_Id is NULL) then

Line 44: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',2);

40: BEGIN
41: --
42: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',1);
43: --
44: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',2);
45: --
46: if (X_Cobra_Coverage_Status_Id is NULL) then
47: OPEN C2;
48: FETCH C2 INTO X_Cobra_Coverage_Status_Id;

Line 52: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',3);

48: FETCH C2 INTO X_Cobra_Coverage_Status_Id;
49: CLOSE C2;
50: end if;
51: --
52: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',3);
53: -- hr_utility.trace(X_Cobra_Coverage_Status_Id);
54: --
55: --
56: INSERT INTO per_cobra_coverage_statuses(

Line 53: -- hr_utility.trace(X_Cobra_Coverage_Status_Id);

49: CLOSE C2;
50: end if;
51: --
52: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',3);
53: -- hr_utility.trace(X_Cobra_Coverage_Status_Id);
54: --
55: --
56: INSERT INTO per_cobra_coverage_statuses(
57: cobra_coverage_status_id,

Line 114: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',4);

110: X_Attribute20,
111: X_Comments
112: );
113: --
114: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',4);
115: --
116: --
117: OPEN C;
118: FETCH C INTO X_Rowid;

Line 125: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',5);

121: RAISE NO_DATA_FOUND;
122: end if;
123: CLOSE C;
124: --
125: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',5);
126: --
127: END Insert_Row;
128: --
129: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 166: hr_utility.set_location('per_cobra_cov_statuses_pkg lock_row ccs',0);

162: FOR UPDATE of Cobra_Coverage_Status_Id NOWAIT;
163: Recinfo C%ROWTYPE;
164: BEGIN
165: --
166: hr_utility.set_location('per_cobra_cov_statuses_pkg lock_row ccs',0);
167: --
168: OPEN C;
169: FETCH C INTO Recinfo;
170: if (C%NOTFOUND) then

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

286: AND (X_Comments IS NULL)))
287: ) then
288: return;
289: else
290: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');
291: hr_utility.raise_error;
292: end if;
293: END Lock_Row;
294: --

Line 291: hr_utility.raise_error;

287: ) then
288: return;
289: else
290: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');
291: hr_utility.raise_error;
292: end if;
293: END Lock_Row;
294: --
295: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 325: hr_utility.set_location('per_cobra_cov_statuses_pkg update_row ccs',0);

321: X_Comments VARCHAR2
322: ) IS
323: BEGIN
324: --
325: hr_utility.set_location('per_cobra_cov_statuses_pkg update_row ccs',0);
326: --
327: UPDATE per_cobra_coverage_statuses
328: SET
329: business_group_id = X_Business_Group_Id,

Line 368: hr_utility.set_location('per_cobra_cov_statuses_pkg delete_row',0);

364: --
365: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
366: BEGIN
367: --
368: hr_utility.set_location('per_cobra_cov_statuses_pkg delete_row',0);
369: --
370: DELETE FROM per_cobra_coverage_statuses
371: WHERE rowid = X_Rowid;
372:

Line 414: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',0);

410: OR p_cobra_coverage_status_id IS NULL);
411: --
412: BEGIN
413: --
414: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',0);
415: --
416: --
417: -- get status
418: --

Line 423: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',1);

419: OPEN status;
420: FETCH status INTO l_status_exists;
421: CLOSE status;
422: --
423: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',1);
424: --
425: --
426: -- Check flag
427: --

Line 431: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',2);

427: --
428: IF (l_status_exists = 'Y')
429: THEN
430: --
431: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',2);
432: --
433: -- raise error
434: --
435: hr_utility.set_message(801, 'HR_13143_COBRA_DUP_STATUS');

Line 435: hr_utility.set_message(801, 'HR_13143_COBRA_DUP_STATUS');

431: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',2);
432: --
433: -- raise error
434: --
435: hr_utility.set_message(801, 'HR_13143_COBRA_DUP_STATUS');
436: --
437: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',2.5);
438: --
439: hr_utility.raise_error;

Line 437: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',2.5);

433: -- raise error
434: --
435: hr_utility.set_message(801, 'HR_13143_COBRA_DUP_STATUS');
436: --
437: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',2.5);
438: --
439: hr_utility.raise_error;
440: --
441: END IF;

Line 439: hr_utility.raise_error;

435: hr_utility.set_message(801, 'HR_13143_COBRA_DUP_STATUS');
436: --
437: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',2.5);
438: --
439: hr_utility.raise_error;
440: --
441: END IF;
442: --
443: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',3);

Line 443: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',3);

439: hr_utility.raise_error;
440: --
441: END IF;
442: --
443: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs hr_cobra_chk_status_unique',3);
444: --
445: --
446: END hr_cobra_chk_status_unique;
447: --

Line 497: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 1);

493: AND ccs.effective_date <= p_effective_date;
494: --
495: BEGIN
496: --
497: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 1);
498: --
499: --
500: -- chk terminated
501: --

Line 505: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 2);

501: --
502: IF (p_cobra_coverage_status_type = 'TERM')
503: THEN
504: --
505: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 2);
506: --
507: -- chk elect or reject exist
508: --
509: OPEN elect_or_reject_status;

Line 519: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 3);

515: --
516: ELSIF (p_cobra_coverage_status_type IN ('ELEC', 'REJ'))
517: THEN
518: --
519: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 3);
520: --
521: -- chk notified exists
522: --
523: OPEN notified_status;

Line 537: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 4);

533: --
534: IF (l_status_order_ok = 'N')
535: THEN
536: --
537: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 4);
538: --
539: -- chk which error to raise
540: --
541: IF (p_cobra_coverage_status_type = 'TERM')

Line 544: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 5);

540: --
541: IF (p_cobra_coverage_status_type = 'TERM')
542: THEN
543: --
544: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 5);
545: --
546: -- Elect/Reject before Term error
547: --
548: hr_utility.set_message(801, 'HR_13134_COBRA_CANT_TERM_YET');

Line 548: hr_utility.set_message(801, 'HR_13134_COBRA_CANT_TERM_YET');

544: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 5);
545: --
546: -- Elect/Reject before Term error
547: --
548: hr_utility.set_message(801, 'HR_13134_COBRA_CANT_TERM_YET');
549: hr_utility.raise_error;
550: ELSE
551: --
552: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 6);

Line 549: hr_utility.raise_error;

545: --
546: -- Elect/Reject before Term error
547: --
548: hr_utility.set_message(801, 'HR_13134_COBRA_CANT_TERM_YET');
549: hr_utility.raise_error;
550: ELSE
551: --
552: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 6);
553: --

Line 552: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 6);

548: hr_utility.set_message(801, 'HR_13134_COBRA_CANT_TERM_YET');
549: hr_utility.raise_error;
550: ELSE
551: --
552: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 6);
553: --
554: -- Notify before Elect/Reject error
555: --
556: hr_utility.set_message(801, 'HR_13135_COBRA_CANT_EL_REJ_YET');

Line 556: hr_utility.set_message(801, 'HR_13135_COBRA_CANT_EL_REJ_YET');

552: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 6);
553: --
554: -- Notify before Elect/Reject error
555: --
556: hr_utility.set_message(801, 'HR_13135_COBRA_CANT_EL_REJ_YET');
557: hr_utility.raise_error;
558: END IF;
559: --
560: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 7);

Line 557: hr_utility.raise_error;

553: --
554: -- Notify before Elect/Reject error
555: --
556: hr_utility.set_message(801, 'HR_13135_COBRA_CANT_EL_REJ_YET');
557: hr_utility.raise_error;
558: END IF;
559: --
560: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 7);
561: END IF;

Line 560: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 7);

556: hr_utility.set_message(801, 'HR_13135_COBRA_CANT_EL_REJ_YET');
557: hr_utility.raise_error;
558: END IF;
559: --
560: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk correct order', 7);
561: END IF;
562: END hr_cobra_chk_status_order;
563: --
564: --

Line 601: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 1);

597: 'ELEC');
598: --
599: BEGIN
600: --
601: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 1);
602: --
603: -- check if elect / reject co-exist
604: --
605: OPEN elect_reject;

Line 614: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 2);

610: --
611: IF (l_status_ok = 'N')
612: THEN
613: --
614: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 2);
615: --
616: -- Reject/Elect cannot co-exist error
617: --
618: hr_utility.set_message(801, 'HR_13136_COBRA_EL_REJ_NOT_COEX');

Line 618: hr_utility.set_message(801, 'HR_13136_COBRA_EL_REJ_NOT_COEX');

614: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 2);
615: --
616: -- Reject/Elect cannot co-exist error
617: --
618: hr_utility.set_message(801, 'HR_13136_COBRA_EL_REJ_NOT_COEX');
619: hr_utility.raise_error;
620: END IF;
621: --
622: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 3);

Line 619: hr_utility.raise_error;

615: --
616: -- Reject/Elect cannot co-exist error
617: --
618: hr_utility.set_message(801, 'HR_13136_COBRA_EL_REJ_NOT_COEX');
619: hr_utility.raise_error;
620: END IF;
621: --
622: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 3);
623: --

Line 622: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 3);

618: hr_utility.set_message(801, 'HR_13136_COBRA_EL_REJ_NOT_COEX');
619: hr_utility.raise_error;
620: END IF;
621: --
622: hr_utility.set_location('per_cobra_cov_statuses_pkg ccs pkg - chk elect reject', 3);
623: --
624: --
625: END hr_cobra_chk_status_elect_rej;
626: --