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

Line 1: PACKAGE BODY hr_assignment AS

1: PACKAGE BODY hr_assignment AS
2: /* $Header: peassign.pkb 120.11.12010000.5 2008/08/06 09:04:07 ubhat ship $ */
3: /*
4: ******************************************************************
5: * *

Line 23: Name : hr_assignment (BODY)

19: * England. *
20: * *
21: ****************************************************************** */
22: /*
23: Name : hr_assignment (BODY)
24:
25: Description : This package defines procedures required to
26: INSERT, UPDATE and DELETE assignments and all
27: associated tables :

Line 261: the package HR_ASSIGNMENT to implement the

257: procedure.Reverted Back the change done in
258: 115.22 and 115.27 to consider
259: p_new_primary_flag instead of 'N'
260: 115.39 01-Dec-04 jpthomas 4040403 Modified the procedure DEL_REF_INT_DELETE() in
261: the package HR_ASSIGNMENT to implement the
262: DELETE_NEXT_CHANGE and FUTURE_CHANGE for the
263: Assignment Budget Values records.
264: 115.40 27-DEC-04 kramajey 4071460 Modified the check_hours procedure to
265: to enable the proper validation

Line 288: g_package varchar2(33) := ' hr_assignment.';

284: --
285: --
286: -- Package Variables
287: --
288: g_package varchar2(33) := ' hr_assignment.';
289: --
290: ----------------------- gen_probation_end ----------------------------
291: /*
292: NAME

Line 319: hr_utility.set_location('hr_assignment.gen_probation_end',1);

315: v_date_probation_end DATE;
316: --
317: BEGIN
318: --
319: hr_utility.set_location('hr_assignment.gen_probation_end',1);
320: --
321: v_start_date := p_start_date;
322: v_date_probation_end := p_date_probation_end;
323: --

Line 328: hr_utility.set_location('hr_assignment.gen_probation_end',2);

324: IF v_date_probation_end IS NULL THEN
325: --
326: -- generate new default probation end date
327: --
328: hr_utility.set_location('hr_assignment.gen_probation_end',2);
329: --
330: /*------ changes made for bug 5619940 ---- */
331: IF p_probation_period = 0
332: and ( p_probation_unit = 'D'

Line 360: hr_utility.set_location('hr_assignment.gen_probation_end',3);

356: --
357: ELSIF
358: p_assignment_id IS NULL THEN
359: --
360: hr_utility.set_location('hr_assignment.gen_probation_end',3);
361: --
362: -- If the Assignment is a new one
363: -- ensure that the DATE_PROBATION_END is on or after the assignment
364: -- start date

Line 380: hr_utility.set_location('hr_assignment.gen_probation_end',4);

376: -- date for the assignment.
377: --
378: BEGIN
379: --
380: hr_utility.set_location('hr_assignment.gen_probation_end',4);
381: select v_date_probation_end - min(effective_start_date)
382: into check_date
383: from per_assignments_f
384: where assignment_id = p_assignment_id

Line 392: hr_utility.set_location('hr_assignment.gen_probation_end',5);

388: WHEN NO_DATA_FOUND THEN NULL;
389: --
390: END;
391: --
392: hr_utility.set_location('hr_assignment.gen_probation_end',5);
393: --
394: IF check_date < 0 THEN
395: hr_utility.set_message(801,'HR_6150_EMP_ASS_PROB_END');
396: hr_utility.raise_error;

Line 422: hr_utility.set_location('hr_assignment.gen_new_ass_sequence',1);

418: ) is
419: --
420: begin
421: --
422: hr_utility.set_location('hr_assignment.gen_new_ass_sequence',1);
423: select nvl(max(assignment_sequence),0) +1
424: into p_assignment_sequence
425: from per_assignments_f
426: where person_id = p_person_id

Line 513: hr_utility.set_location('hr_assignment.gen_new_ass_number',1);

509: duplicate := 'N';
510: --
511: BEGIN
512: --
513: hr_utility.set_location('hr_assignment.gen_new_ass_number',1);
514: select 'Y'
515: into duplicate
516: from sys.dual
517: where exists

Line 545: hr_utility.set_location('hr_assignment.gen_new_ass_number',2);

541: ass_seq := p_assignment_sequence;
542: --
543: IF p_assignment_number IS NOT NULL THEN
544: --
545: hr_utility.set_location('hr_assignment.gen_new_ass_number',2);
546: IF validate_ass_number(p_assignment_id
547: ,p_business_group_id
548: ,p_assignment_number) THEN
549: NULL;

Line 557: hr_utility.set_location('hr_assignment.gen_new_ass_number',3);

553: END IF;
554: --
555: ELSE
556: --
557: hr_utility.set_location('hr_assignment.gen_new_ass_number',3);
558: WHILE loop_count > 0 LOOP
559: --
560: IF ass_seq = 1 THEN
561: -- p_assignment_number := p_worker_number;

Line 615: hr_utility.set_location('hr_assignment.gen_new_ass_number',4);

611: p_assignment_number := substr(p_worker_number,1,29-length(TO_CHAR(ass_seq)))||'-'||TO_CHAR(ass_seq);
612: -- p_assignment_number := p_worker_number||'-'||TO_CHAR(ass_seq);
613: END IF;
614: --
615: hr_utility.set_location('hr_assignment.gen_new_ass_number',4);
616: IF validate_ass_number(p_assignment_id
617: ,p_business_group_id
618: ,p_assignment_number) THEN
619: EXIT;

Line 627: hr_utility.set_location('hr_assignment.gen_new_ass_number',5);

623: END IF;
624: --
625: END LOOP;
626: --
627: hr_utility.set_location('hr_assignment.gen_new_ass_number',5);
628: IF loop_count = 0 THEN
629: hr_utility.set_message(801,'HR_6148_EMP_ASS_LOOP_OUT');
630: hr_utility.raise_error;
631: END IF;

Line 661: hr_utility.set_location('hr_assignment.check_hours',1);

657: no_of_hours NUMBER;
658: --
659: BEGIN
660: --
661: hr_utility.set_location('hr_assignment.check_hours',1);
662: IF p_frequency = 'D' THEN
663: no_of_hours := 24;
664: ELSIF p_frequency = 'W' THEN
665: no_of_hours := 168;

Line 762: hr_utility.set_location('hr_assignment.check_term',1);

758:
759:
760: BEGIN
761: --
762: hr_utility.set_location('hr_assignment.check_term',1);
763: p_start_date := p_sdate;
764: p_end_date := p_edate;
765: p_new_ass_end_date := null;
766:

Line 784: hr_utility.set_location('hr_assignment.check_term',2);

780: FETCH csr_get_term_dates INTO p_atd
781: ,p_fpd;
782: CLOSE csr_get_term_dates;
783:
784: hr_utility.set_location('hr_assignment.check_term',2);
785:
786: IF p_atd IS NULL THEN null;
787: ELSE
788: --

Line 792: hr_utility.set_location('hr_assignment.check_term',3);

788: --
789: -------------------------------------
790: -- Get the Effective End Date of the Assignment
791: -------------------------------------
792: hr_utility.set_location('hr_assignment.check_term',3);
793: --
794: select max(effective_end_date)
795: into p_ass_end_date
796: from per_assignments_f

Line 806: hr_utility.set_location('hr_assignment.check_term',4);

802: -- If the mode is UPDATE_OVERRIDE and the current status is TERM_ASSIGN
803: -- then compare the session date with the earliest TERM_ASSIGN date
804: -- and store the earliest.
805: -------------------------------------
806: hr_utility.set_location('hr_assignment.check_term',4);
807: --
808: select min(a.effective_start_date)
809: into p_first_term_date
810: from per_assignments_f a

Line 818: hr_utility.set_location('hr_assignment.check_term',5);

814: where s.assignment_status_type_id
815: = a.assignment_status_type_id
816: and s.per_system_status = 'TERM_ASSIGN');
817: --
818: hr_utility.set_location('hr_assignment.check_term',5);
819: IF p_mode = 'UPDATE_OVERRIDE' AND
820: p_current_status = 'TERM_ASSIGN' THEN
821: --
822: IF p_first_term_date IS NULL OR

Line 853: hr_utility.set_location('hr_assignment.check_term',6);

849:
850: IF (p_mode = 'UPDATE_OVERRIDE' or p_mode = 'FUTURE_CHANGE')
851: AND p_start_date < p_atd + 1 THEN
852: --
853: hr_utility.set_location('hr_assignment.check_term',6);
854: --
855: p_flag := 'N';
856: --
857: BEGIN

Line 859: hr_utility.set_location('hr_assignment.check_term',7);

855: p_flag := 'N';
856: --
857: BEGIN
858: --
859: hr_utility.set_location('hr_assignment.check_term',7);
860: --
861: select 'Y'
862: into p_flag
863: from per_assignments_f a

Line 876: hr_utility.set_location('hr_assignment.check_term',8);

872: EXCEPTION
873: WHEN NO_DATA_FOUND THEN NULL;
874: END;
875: --
876: hr_utility.set_location('hr_assignment.check_term',8);
877: IF p_flag = 'Y' THEN
878: hr_utility.set_message(801,'HR_6200_EMP_ASS_TERM_EXISTS');
879: hr_utility.raise_error;
880: END IF;

Line 894: hr_utility.set_location('hr_assignment.check_term',9);

890: -- otherwise
891: -- set the new_assignment_end_date = actual_termination_date
892: ---------------------------------------------------------------
893: IF p_mode = 'UPDATE_OVERRIDE' THEN
894: hr_utility.set_location('hr_assignment.check_term',9);
895: IF p_ass_end_date <= p_atd THEN
896: NULL;
897: ELSE
898: hr_utility.set_location('hr_assignment.check_term',10);

Line 898: hr_utility.set_location('hr_assignment.check_term',10);

894: hr_utility.set_location('hr_assignment.check_term',9);
895: IF p_ass_end_date <= p_atd THEN
896: NULL;
897: ELSE
898: hr_utility.set_location('hr_assignment.check_term',10);
899: IF p_first_term_date <= p_start_date THEN
900: NULL;
901: ELSE
902: p_new_ass_end_date := p_atd;

Line 915: hr_utility.set_location('hr_assignment.check_term',11);

911: -- open the assignment up to the actual term date.
912: ---------------------------------------------------------------
913: ELSIF
914: p_mode = 'FUTURE_CHANGE' THEN
915: hr_utility.set_location('hr_assignment.check_term',11);
916: IF p_first_term_date <= p_start_date THEN
917: p_new_ass_end_date := p_fpd;
918: ELSE
919: p_new_ass_end_date := p_atd;

Line 962: hr_utility.set_location('hr_assignment.check_term',12);

958: -- therefore in this case issue an error.
959: ---------------------------------------------------------------
960: ELSIF
961: p_mode = 'DELETE_NEXT_CHANGE' THEN
962: hr_utility.set_location('hr_assignment.check_term',12);
963: IF p_end_date = p_ass_end_date THEN
964: hr_utility.set_location('hr_assignment.check_term',13);
965: IF p_first_term_date <= p_start_date THEN
966: p_new_ass_end_date := p_fpd;

Line 964: hr_utility.set_location('hr_assignment.check_term',13);

960: ELSIF
961: p_mode = 'DELETE_NEXT_CHANGE' THEN
962: hr_utility.set_location('hr_assignment.check_term',12);
963: IF p_end_date = p_ass_end_date THEN
964: hr_utility.set_location('hr_assignment.check_term',13);
965: IF p_first_term_date <= p_start_date THEN
966: p_new_ass_end_date := p_fpd;
967: ELSE
968: p_new_ass_end_date := p_atd;

Line 976: hr_utility.set_location('hr_assignment.check_term',14);

972: p_flag := 'N';
973: --
974: BEGIN
975: --
976: hr_utility.set_location('hr_assignment.check_term',14);
977: --
978: select 'Y'
979: , a.effective_start_date
980: , a.effective_end_date

Line 997: hr_utility.set_location('hr_assignment.check_term',15);

993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN NULL;
995: END;
996: --
997: hr_utility.set_location('hr_assignment.check_term',15);
998: IF p_flag = 'Y' THEN
999: hr_utility.set_location('hr_assignment.check_term',16);
1000: IF p_next_eff_start_date = p_atd + 1 THEN
1001: hr_utility.set_message(801,'HR_6200_EMP_ASS_TERM_EXISTS');

Line 999: hr_utility.set_location('hr_assignment.check_term',16);

995: END;
996: --
997: hr_utility.set_location('hr_assignment.check_term',15);
998: IF p_flag = 'Y' THEN
999: hr_utility.set_location('hr_assignment.check_term',16);
1000: IF p_next_eff_start_date = p_atd + 1 THEN
1001: hr_utility.set_message(801,'HR_6200_EMP_ASS_TERM_EXISTS');
1002: hr_utility.raise_error;
1003: ELSE

Line 1005: hr_utility.set_location('hr_assignment.check_term',17);

1001: hr_utility.set_message(801,'HR_6200_EMP_ASS_TERM_EXISTS');
1002: hr_utility.raise_error;
1003: ELSE
1004: IF p_first_term_date <= p_start_date THEN
1005: hr_utility.set_location('hr_assignment.check_term',17);
1006: p_new_ass_end_date := p_fpd;
1007: ELSE
1008: IF p_next_eff_end_date = p_ass_end_date THEN
1009: hr_utility.set_location('hr_assignment.check_term',18);

Line 1009: hr_utility.set_location('hr_assignment.check_term',18);

1005: hr_utility.set_location('hr_assignment.check_term',17);
1006: p_new_ass_end_date := p_fpd;
1007: ELSE
1008: IF p_next_eff_end_date = p_ass_end_date THEN
1009: hr_utility.set_location('hr_assignment.check_term',18);
1010: IF p_ass_end_date > p_atd THEN
1011: p_new_ass_end_date := p_atd;
1012: ELSE
1013: NULL;

Line 1030: hr_utility.set_location('hr_assignment.check_term',19);

1026: END IF; -- (p_mode = 'UPDATE_OVERRIDE')
1027: --
1028: END IF; -- (p_atd IS NULL)
1029: --
1030: hr_utility.set_location('hr_assignment.check_term',19);
1031: IF p_new_ass_end_date IS NOT NULL THEN
1032: ------------------------------------------------------------
1033: -- First check whether setting this end date will invalidate
1034: -- any child rows.

Line 1036: hr_assignment.del_ref_int_check

1032: ------------------------------------------------------------
1033: -- First check whether setting this end date will invalidate
1034: -- any child rows.
1035: ------------------------------------------------------------
1036: hr_assignment.del_ref_int_check
1037: ( p_assignment_id
1038: , 'END'
1039: , p_new_ass_end_date);
1040: p_newdate := p_new_ass_end_date;

Line 1078: hr_utility.set_location('hr_assignment.warn_del_term',1);

1074: p_term_found := 'N';
1075: --
1076: begin
1077: --
1078: hr_utility.set_location('hr_assignment.warn_del_term',1);
1079: --
1080: select 'Y'
1081: into p_term_found
1082: from sys.dual

Line 1101: hr_utility.set_location('hr_assignment.warn_del_term',2);

1097: exception
1098: when NO_DATA_FOUND then null;
1099: end;
1100: --
1101: hr_utility.set_location('hr_assignment.warn_del_term',2);
1102: if p_term_found = 'Y' then
1103: raise local_warning;
1104: end if;
1105: --

Line 1140: hr_utility.set_location('hr_assignment.delete_ass_ref_int',1);

1136: --
1137: -- del_flag := 'N';
1138: --
1139: BEGIN
1140: hr_utility.set_location('hr_assignment.delete_ass_ref_int',1);
1141: --
1142: SELECT 'Y'
1143: into del_flag
1144: FROM SYS.DUAL

Line 1156: hr_utility.set_location('hr_assignment.delete_ass_ref_int',2);

1152: WHEN NO_DATA_FOUND THEN NULL;
1153: END;
1154: --
1155: IF del_flag = 'Y' THEN
1156: hr_utility.set_location('hr_assignment.delete_ass_ref_int',2);
1157: --
1158: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
1159: WHERE P.business_group_id + 0 = p_business_group_id
1160: AND P.ASSIGNMENT_ID = p_assignment_id;

Line 1168: hr_utility.set_location('hr_assignment.delete_ass_ref_int',3);

1164: del_flag := 'N';
1165: --
1166: BEGIN
1167: --
1168: hr_utility.set_location('hr_assignment.delete_ass_ref_int',3);
1169: --
1170: SELECT 'Y'
1171: into del_flag
1172: from sys.dual

Line 1184: hr_utility.set_location('hr_assignment.delete_ass_ref_int',4);

1180: WHEN NO_DATA_FOUND THEN NULL;
1181: END;
1182: --
1183: IF del_flag = 'Y' THEN
1184: hr_utility.set_location('hr_assignment.delete_ass_ref_int',4);
1185: --
1186: DELETE FROM PER_SECONDARY_ASS_STATUSES
1187: WHERE business_group_id + 0 = p_business_group_id
1188: AND ASSIGNMENT_ID = p_assignment_id;

Line 1195: hr_utility.set_location('hr_assignment.delete_ass_ref_int',5);

1191: --
1192: del_flag := 'N';
1193: --
1194: BEGIN
1195: hr_utility.set_location('hr_assignment.delete_ass_ref_int',5);
1196: --
1197: SELECT 'Y'
1198: into del_flag
1199: from sys.dual

Line 1211: hr_utility.set_location('hr_assignment.delete_ass_ref_int',6);

1207: WHEN NO_DATA_FOUND THEN NULL;
1208: END;
1209: --
1210: IF del_flag = 'Y' THEN
1211: hr_utility.set_location('hr_assignment.delete_ass_ref_int',6);
1212: --
1213: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F BV
1214: WHERE BV.business_group_id + 0 = p_business_group_id
1215: AND BV.ASSIGNMENT_ID = p_assignment_id;

Line 1244: hr_utility.set_location('hr_assignment.get_act_term_date',1);

1240: --
1241: -------------------------------------------------
1242: -- Retrieve the ACTUAL TERMINATION DATE for the Period of Service
1243: -------------------------------------------------
1244: hr_utility.set_location('hr_assignment.get_act_term_date',1);
1245: --
1246: select actual_termination_date
1247: into p_actual_termination_date
1248: from per_periods_of_service

Line 1303: hr_utility.set_location('hr_assignment.check_future_primary',1);

1299:
1300: --
1301: BEGIN
1302: --
1303: hr_utility.set_location('hr_assignment.check_future_primary',1);
1304: p_start_date := p_sdate;
1305: p_end_date := p_edate;
1306: --
1307: -------------------------------------

Line 1337: hr_utility.set_location('hr_assignment.check_future_primary',2);

1333: -- NEXT_CHANGE - the next row
1334: -- FUTURE_CHANGES and UPDATE_OVERRIDE - All rows in future
1335: -------------------------------------
1336: begin
1337: hr_utility.set_location('hr_assignment.check_future_primary',2);
1338: --
1339: select 'Y'
1340: into p_change_flag
1341: from sys.dual

Line 1362: hr_utility.set_location('hr_assignment.check_future_primary',3);

1358: -- retrieve the earliest occurrence of PRIMARY_FLAG = 'Y'. A new
1359: -- Primary Assignment will be required from this date.
1360: ---------------------------------------
1361: IF p_mode = 'ZAP' AND p_change_flag = 'Y' THEN
1362: hr_utility.set_location('hr_assignment.check_future_primary',3);
1363: --
1364: select min(effective_start_date)
1365: into p_primary_date_from_d
1366: from per_assignments_f

Line 1451: hr_utility.set_location('hr_assignment.check_ass_for_primary',1);

1447:
1448: -------------------------------------
1449: -- Get the Actual Termination Date and Final Process Date
1450: -------------------------------------
1451: hr_utility.set_location('hr_assignment.check_ass_for_primary',1);
1452: --
1453: -- #306211. If ATD was null, then NVL to EOT - 1, instead of EOT. This is
1454: -- because trying to add 1 to EOT (as happens in a number of places below)
1455: -- raises an ORA-1841 error. So use Dec 30 instead of Dec 31.

Line 1465: hr_utility.set_location('hr_assignment.check_ass_for_primary',2);

1461:
1462: -------------------------------------
1463: -- Get the Effective End Date of the Assignment
1464: -------------------------------------
1465: hr_utility.set_location('hr_assignment.check_ass_for_primary',2);
1466: --
1467: select max(effective_end_date)
1468: into p_ass_end_date
1469: from per_assignments_f

Line 1491: hr_utility.set_location('hr_assignment.check_ass_for_primary',3);

1487: ELSE
1488: -------------------------------------
1489: -- Get the Start Date of the First terminated status.
1490: -------------------------------------
1491: hr_utility.set_location('hr_assignment.check_ass_for_primary',3);
1492: --
1493: if l_assignment_type <> 'C' then
1494:
1495: select min(a.effective_start_date)

Line 1505: hr_utility.set_location('hr_assignment.check_ass_for_primary',4);

1501: where s.assignment_status_type_id
1502: = a.assignment_status_type_id
1503: and s.per_system_status = 'TERM_ASSIGN');
1504: --
1505: hr_utility.set_location('hr_assignment.check_ass_for_primary',4);
1506: IF p_first_term_date = p_atd + 1
1507: OR
1508: p_first_term_date IS NULL THEN NULL;
1509: ELSE

Line 1685: hr_utility.set_location('hr_assignment.update_primary',1);

1681: -- back to p_new_primary_flag.
1682: -------------------------------------
1683: --
1684: IF p_mode <> 'ZAP' THEN
1685: hr_utility.set_location('hr_assignment.update_primary',1);
1686: do_primary_update(p_assignment_id
1687: ,p_sdate
1688: ,p_new_primary_flag -- Bug 3584122 'N'-- Bug 2468916 p_new_primary_flag
1689: ,'Y'

Line 1701: hr_utility.set_location('hr_assignment.update_primary',2);

1697: -- Flag has to be set to 'Y' on all the changes on or after the
1698: -- Start Date
1699: -------------------------------------
1700: IF p_assignment_id <> p_new_primary_ass_id THEN
1701: hr_utility.set_location('hr_assignment.update_primary',2);
1702: do_primary_update(p_new_primary_ass_id
1703: ,p_sdate
1704: ,'Y'
1705: ,'N'

Line 1717: hr_utility.set_location('hr_assignment.update_primary',3);

1713: -- P_NEW_PRIMARY_ASS_ID within the period_of_service
1714: -- future changes must have their Primary Flag set to 'N'. It is only
1715: -- necessary to update the ones that are currently 'Y'.
1716: -------------------------------------
1717: hr_utility.set_location('hr_assignment.update_primary',3);
1718: --
1719: FOR ass_rec IN get_future_primary_assignments LOOP
1720: do_primary_update(ass_rec.assignment_id
1721: ,p_sdate

Line 1775: hr_utility.set_location('hr_assignment.do_primary_update',1);

1771: and P_START_DATE < effective_start_date))
1772: for update;
1773: --
1774: BEGIN
1775: hr_utility.set_location('hr_assignment.do_primary_update',1);
1776: p_start_date := p_sdate;
1777: --
1778: -------------------------------------
1779: -- If the Assignment is Current i.e. P_CURRENT_ASS = 'Y' then the form

Line 1812: hr_utility.set_location('hr_assignment.do_primary_update',2);

1808: --
1809: -- See CURSOR select_ass_for_update
1810: ----------------------------------------------------------------------
1811: --
1812: hr_utility.set_location('hr_assignment.do_primary_update',2);
1813: --
1814: FOR ass_rec IN select_ass_for_update LOOP
1815: NULL;
1816: END LOOP;

Line 1821: hr_utility.set_location('hr_assignment.do_primary_update',3);

1817: --
1818: IF p_current_ass = 'Y' THEN
1819: NULL;
1820: ELSE
1821: hr_utility.set_location('hr_assignment.do_primary_update',3);
1822: --
1823: update per_assignments_f
1824: set primary_flag = P_PRIMARY_FLAG
1825: , last_updated_by = P_LAST_UPDATED_BY

Line 1831: hr_utility.set_location('hr_assignment.do_primary_update',4);

1827: , last_update_date = sysdate
1828: where assignment_id = P_ASSIGNMENT_ID
1829: and effective_start_date = P_START_DATE;
1830: --
1831: hr_utility.set_location('hr_assignment.do_primary_update',4);
1832: IF SQL%ROWCOUNT = 1 THEN
1833: NULL;
1834: ELSIF SQL%ROWCOUNT > 1 THEN
1835: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1841: hr_utility.set_location('hr_assignment.do_primary_update',5);

1837: hr_utility.set_message_token('STEP','1');
1838: hr_utility.raise_error;
1839: ELSE
1840: --
1841: hr_utility.set_location('hr_assignment.do_primary_update',5);
1842: --
1843: insert into per_assignments_f
1844: (
1845: ASSIGNMENT_ID

Line 2070: hr_utility.set_location('hr_assignment.do_primary_update',6);

2066: --
2067: IF SQL%ROWCOUNT = 0 THEN
2068: NULL; -- This Assignment Start in the Future
2069: ELSE
2070: hr_utility.set_location('hr_assignment.do_primary_update',6);
2071: --
2072: update per_assignments_f
2073: set effective_start_date = P_START_DATE
2074: , primary_flag = P_PRIMARY_FLAG

Line 2083: hr_utility.set_location('hr_assignment.do_primary_update',7);

2079: and P_START_DATE
2080: between effective_start_date and effective_end_date
2081: and primary_flag <> P_PRIMARY_FLAG;
2082: --
2083: hr_utility.set_location('hr_assignment.do_primary_update',7);
2084: IF SQL%ROWCOUNT <> 1 THEN
2085: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2086: hr_utility.set_message_token('PROCEDURE','DO_PRIMARY_UPDATE');
2087: hr_utility.set_message_token('STEP','3');

Line 2094: hr_utility.set_location('hr_assignment.do_primary_update',8);

2090: END IF; -- (SQL%ROWCOUNT = 0)
2091: END IF; -- (SQL%ROWCOUNT = 1)
2092: END IF; -- (p_current_ass = 'Y')
2093: --
2094: hr_utility.set_location('hr_assignment.do_primary_update',8);
2095: --
2096: update per_assignments_f
2097: set primary_flag = P_PRIMARY_FLAG
2098: , last_updated_by = P_LAST_UPDATED_BY

Line 2221: hr_utility.set_location('hr_assignment.get_new_primary_assignment',1);

2217: BEGIN
2218: --
2219: p_start_date := p_sdate;
2220:
2221: hr_utility.set_location('hr_assignment.get_new_primary_assignment',1);
2222:
2223: --
2224: -- Fetch the desired assignment details.
2225: --

Line 2241: hr_utility.set_location('hr_assignment.get_new_primary_assignment',2);

2237: ,p_fpd;
2238: CLOSE csr_get_term_dates;
2239:
2240: --
2241: hr_utility.set_location('hr_assignment.get_new_primary_assignment',2);
2242: --
2243: ---------------------------------------------------
2244: -- open the cursor and read the first record if one exists
2245: -- If one doesn't exists then ERROR

Line 2249: hr_utility.set_location('hr_assignment.get_new_primary_assignment',3);

2245: -- If one doesn't exists then ERROR
2246: -- Try and read another record
2247: -- If one exists then WARNING (prompt user in Form for which one)
2248: ---------------------------------------------------
2249: hr_utility.set_location('hr_assignment.get_new_primary_assignment',3);
2250: OPEN get_candidate_primary_ass;
2251: --
2252: hr_utility.set_location('hr_assignment.get_new_primary_assignment',4);
2253: FETCH get_candidate_primary_ass INTO p_new_primary_ass_id;

Line 2252: hr_utility.set_location('hr_assignment.get_new_primary_assignment',4);

2248: ---------------------------------------------------
2249: hr_utility.set_location('hr_assignment.get_new_primary_assignment',3);
2250: OPEN get_candidate_primary_ass;
2251: --
2252: hr_utility.set_location('hr_assignment.get_new_primary_assignment',4);
2253: FETCH get_candidate_primary_ass INTO p_new_primary_ass_id;
2254: --
2255: IF get_candidate_primary_ass%NOTFOUND THEN
2256: hr_utility.set_location('hr_assignment.get_new_primary_assignment',5);

Line 2256: hr_utility.set_location('hr_assignment.get_new_primary_assignment',5);

2252: hr_utility.set_location('hr_assignment.get_new_primary_assignment',4);
2253: FETCH get_candidate_primary_ass INTO p_new_primary_ass_id;
2254: --
2255: IF get_candidate_primary_ass%NOTFOUND THEN
2256: hr_utility.set_location('hr_assignment.get_new_primary_assignment',5);
2257: CLOSE get_candidate_primary_ass;
2258: hr_utility.set_message(801,'HR_6384_EMP_ASS_NO_PRIM');
2259: hr_utility.raise_error;
2260: ELSE

Line 2261: hr_utility.set_location('hr_assignment.get_new_primary_assignment',7);

2257: CLOSE get_candidate_primary_ass;
2258: hr_utility.set_message(801,'HR_6384_EMP_ASS_NO_PRIM');
2259: hr_utility.raise_error;
2260: ELSE
2261: hr_utility.set_location('hr_assignment.get_new_primary_assignment',7);
2262: FETCH get_candidate_primary_ass INTO p_new_primary_ass_id;
2263: --
2264: hr_utility.set_location('hr_assignment.get_new_primary_assignment',8);
2265: IF get_candidate_primary_ass%FOUND THEN

Line 2264: hr_utility.set_location('hr_assignment.get_new_primary_assignment',8);

2260: ELSE
2261: hr_utility.set_location('hr_assignment.get_new_primary_assignment',7);
2262: FETCH get_candidate_primary_ass INTO p_new_primary_ass_id;
2263: --
2264: hr_utility.set_location('hr_assignment.get_new_primary_assignment',8);
2265: IF get_candidate_primary_ass%FOUND THEN
2266: raise local_warning;
2267: END IF;
2268: --

Line 2269: hr_utility.set_location('hr_assignment.get_new_primary_assignment',9);

2265: IF get_candidate_primary_ass%FOUND THEN
2266: raise local_warning;
2267: END IF;
2268: --
2269: hr_utility.set_location('hr_assignment.get_new_primary_assignment',9);
2270: CLOSE get_candidate_primary_ass;
2271: END IF;
2272: --
2273: EXCEPTION

Line 2310: hr_utility.set_location('hr_assignment.load_budget_values',1);

2306: ,p_effective_end_date IN DATE) IS
2307:
2308: --
2309: BEGIN
2310: hr_utility.set_location('hr_assignment.load_budget_values',1);
2311: --
2312: /* 25/05/95 Fixed bug 273820 - performance of following statement
2313: NB the business_group_id no longer needs +0 appended to it, this
2314: is because the view per_default_budget_values is in fact returning

Line 2375: HR_ASSIGNMENT_SET_AMENDMENTS

2371: PER_LETTER_REQUEST_LINES
2372: PAY_COST_ALLOCATIONS_F
2373: PER_ASSIGNMENT_EXTRA_INFO
2374: PAY_PERSONAL_PAYMENT_METHODS_F
2375: HR_ASSIGNMENT_SET_AMENDMENTS
2376: PAY_ASSIGNMENT_ACTIONS
2377: PER_COBRA_COV_ENROLLMENTS
2378: PER_COBRA_COVERAGE_BENEFITS_F
2379: OTA_DELEGATE_BOOKINGS (per_ota_predel_validation.ota_predel_asg_validation)

Line 2413: hr_utility.set_location('hr_assignment.del_ref_int_check',0);

2409: p_end_date := p_edate;
2410: --
2411: --
2412: IF p_mode = 'ZAP' THEN
2413: hr_utility.set_location('hr_assignment.del_ref_int_check',0);
2414: p_del_flag := 'N';
2415: --
2416: BEGIN
2417: select 'Y'

Line 2446: hr_utility.set_location('hr_assignment.del_ref_int_check',1);

2442: hr_utility.raise_error;
2443: END IF;
2444: END IF;
2445: --
2446: hr_utility.set_location('hr_assignment.del_ref_int_check',1);
2447: p_del_flag := 'N';
2448: --
2449: BEGIN
2450: select 'Y'

Line 2478: hr_utility.set_location('hr_assignment.del_ref_int_check',2);

2474: /* Took out nocopy the check on letter requests as they are now Auto Deleted
2475: - 2/6/93
2476: */
2477: /*
2478: hr_utility.set_location('hr_assignment.del_ref_int_check',2);
2479: p_del_flag := 'N';
2480: --
2481: BEGIN
2482: select 'Y'

Line 2507: hr_utility.set_location('hr_assignment.del_ref_int_check',3);

2503: END IF;
2504: */
2505: --
2506: --
2507: hr_utility.set_location('hr_assignment.del_ref_int_check',3);
2508: p_del_flag := 'N';
2509: --
2510: BEGIN
2511: select 'Y'

Line 2541: hr_utility.set_location('hr_assignment.del_ref_int_check',5);

2537: -- as per_assignment_extra_info are now deleted along with other
2538: -- assignment related records.
2539: --
2540: --
2541: hr_utility.set_location('hr_assignment.del_ref_int_check',5);
2542: p_del_flag := 'N';
2543: /*
2544: N.B. PER_SECONDARY_ASS_STATUSES rows will now be deleted if they
2545: started after the Assignment End Date - changed 27/5/93.

Line 2571: hr_utility.set_location('hr_assignment.del_ref_int_check',6);

2567: END IF;
2568: */
2569: --
2570: --
2571: hr_utility.set_location('hr_assignment.del_ref_int_check',6);
2572: p_del_flag := 'N';
2573:
2574: /* 2537091: PPMs will be deleted if they started after end date of assignment
2575: changed 04-OCT-2002

Line 2604: hr_utility.set_location('hr_assignment.del_ref_int_check',7);

2600:
2601: */
2602: --
2603: --
2604: hr_utility.set_location('hr_assignment.del_ref_int_check',7);
2605: p_del_flag := 'N';
2606: --
2607: /* BEGIN
2608: select 'Y'

Line 2671: hr_utility.set_location('hr_assignment.del_ref_int_check',8);

2667: --
2668: --
2669: IF p_mode = 'ZAP' THEN
2670: --
2671: hr_utility.set_location('hr_assignment.del_ref_int_check',8);
2672: p_del_flag := 'N';
2673: --
2674: BEGIN
2675: select 'Y'

Line 2680: from hr_assignment_set_amendments asa

2676: into p_del_flag
2677: from sys.dual
2678: where exists (
2679: select null
2680: from hr_assignment_set_amendments asa
2681: where asa.assignment_id = p_assignment_id
2682: and asa.include_or_exclude = 'I'
2683: and not exists (
2684: select null

Line 2685: from hr_assignment_set_amendments asa2

2681: where asa.assignment_id = p_assignment_id
2682: and asa.include_or_exclude = 'I'
2683: and not exists (
2684: select null
2685: from hr_assignment_set_amendments asa2
2686: where asa2.assignment_set_id = asa.assignment_set_id
2687: and asa2.assignment_id <> asa.assignment_id)
2688: );
2689: EXCEPTION

Line 2701: hr_utility.set_location('hr_assignment.del_ref_int_check',9);

2697: END IF;
2698: ------------------------------
2699: -- Cobra Coverage Enrollments
2700: --
2701: hr_utility.set_location('hr_assignment.del_ref_int_check',9);
2702: p_del_flag := 'N';
2703: --
2704: BEGIN
2705: select 'Y'

Line 2730: hr_utility.set_location('hr_assignment.del_ref_int_check',9);

2726: END IF;
2727: ------------------------------
2728: -- Cobra Coverage Benefits
2729: --
2730: hr_utility.set_location('hr_assignment.del_ref_int_check',9);
2731: p_del_flag := 'N';
2732: --
2733: BEGIN
2734: select 'Y'

Line 2764: hr_utility.set_location('hr_assignment.del_ref_int_check',10);

2760: --
2761: ------------------------------
2762: -- OTA_DELEGATE_BOOKINGS
2763: --
2764: hr_utility.set_location('hr_assignment.del_ref_int_check',10);
2765: --
2766: p_del_flag := 'N';
2767: --
2768: BEGIN

Line 2809: hr_utility.set_location('hr_assignment.del_ref_int_check',11);

2805: IF p_mode = 'ZAP' THEN
2806: --
2807: -- OTA_DELEGATE_BOOKINGS
2808:
2809: hr_utility.set_location('hr_assignment.del_ref_int_check',11);
2810: per_ota_predel_validation.ota_predel_asg_validation(P_ASSIGNMENT_ID);
2811: END IF;
2812: ---
2813: END del_ref_int_check;

Line 2824: HR_ASSIGNMENT_SET_AMENDMENTS

2820: Performs Third Party Delete on data that is not checked in
2821: del_ref_in_check. Removes data from the following tables
2822:
2823: For 'ZAP'
2824: HR_ASSIGNMENT_SET_AMENDMENTS
2825: PER_ASSIGNMENT_BUDGET_VALUES_F
2826: PER_SPINAL_POINT_PLACEMENTS_F
2827: PER_PAY_PROPOSALS
2828:

Line 2944: hr_utility.set_location('hr_assignment.del_ref_int_delete',1);

2940: --
2941: --
2942: p_end_date := p_edate;
2943: --
2944: hr_utility.set_location('hr_assignment.del_ref_int_delete',1);
2945: p_del_flag := 'N';
2946: --
2947: BEGIN
2948: --

Line 2991: hr_assignment_internal.delete_first_spp

2987:
2988: if l_min_start_date = p_val_st_date
2989: and p_datetrack_mode = 'DELETE_NEXT_CHANGE' then
2990:
2991: hr_assignment_internal.delete_first_spp
2992: (p_effective_date => p_edate,
2993: p_assignment_id => p_assignment_id,
2994: p_validation_start_date => p_val_st_date,
2995: p_validation_end_date => p_val_end_date,

Line 3004: hr_utility.set_location('hr_assignment.delete_ass_ref_int',2);

3000:
3001: else
3002:
3003: IF p_mode = 'ZAP' THEN
3004: hr_utility.set_location('hr_assignment.delete_ass_ref_int',2);
3005:
3006: l_datetrack_mode := 'ZAP';
3007:
3008: --

Line 3219: hr_utility.set_location('hr_assignment.delete_ass_ref_int',3);

3215:
3216: end if;
3217: close csr_grade_step;
3218:
3219: hr_utility.set_location('hr_assignment.delete_ass_ref_int',3);
3220: --
3221: -- Removed dml and inserted call to api
3222: --
3223: /*

Line 3240: hr_utility.set_location('hr_assignment.delete_ass_ref_int',4);

3236: ELSE
3237: -- If mode is 'END' then do Date Effective Delete
3238: -- from p_end_date.
3239: --
3240: hr_utility.set_location('hr_assignment.delete_ass_ref_int',4);
3241: --
3242: -- Removed dml and using api
3243: --
3244: /*

Line 3281: /*hr_utility.set_location('hr_assignment.delete_ass_ref_int',5);

3277: end if;
3278: close csr_grade_step;
3279:
3280:
3281: /*hr_utility.set_location('hr_assignment.delete_ass_ref_int',5);
3282: UPDATE PER_SPINAL_POINT_PLACEMENTS_F
3283: SET EFFECTIVE_END_DATE = p_end_date
3284: , LAST_UPDATED_BY = p_last_updated_by
3285: , LAST_UPDATE_LOGIN = p_last_update_login

Line 3326: hr_utility.set_location('hr_assignment.del_ref_int_delet',30);

3322: --
3323: IF p_del_flag = 'Y' THEN
3324: --
3325: IF p_mode = 'ZAP' THEN
3326: hr_utility.set_location('hr_assignment.del_ref_int_delet',30);
3327: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3328: WHERE ABV.ASSIGNMENT_ID = p_assignment_id;
3329:
3330: --

Line 3336: hr_utility.set_location('hr_assignment.del_ref_int_delete',40);

3332: IF p_mode = 'END' THEN
3333: -- If mode is 'END' then do Date Effective Delete
3334: -- from p_end_date.
3335: --
3336: hr_utility.set_location('hr_assignment.del_ref_int_delete',40);
3337:
3338: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3339: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3340: AND ABV.EFFECTIVE_START_DATE > p_end_date;

Line 3342: hr_utility.set_location('hr_assignment.del_ref_int_delete',45);

3338: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3339: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3340: AND ABV.EFFECTIVE_START_DATE > p_end_date;
3341: --
3342: hr_utility.set_location('hr_assignment.del_ref_int_delete',45);
3343: UPDATE PER_ASSIGNMENT_BUDGET_VALUES_F
3344: SET EFFECTIVE_END_DATE = p_end_date
3345: , LAST_UPDATED_BY = p_last_updated_by
3346: , LAST_UPDATE_LOGIN = p_last_update_login

Line 3359: hr_utility.set_location('hr_assignment.del_ref_int_delete',46);

3355: -- If mode is 'FUTURE' then do Date Effective Delete for all future records
3356: -- from p_end_date. Further, open the current end dated record. Set the last date
3357: -- of assignment_budget_value record same as the last date of current assignmet.
3358: --
3359: hr_utility.set_location('hr_assignment.del_ref_int_delete',46);
3360: hr_utility.set_location('p_end_date '||p_end_date, 47);
3361:
3362: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3363: WHERE ABV.ASSIGNMENT_ID = p_assignment_id

Line 3367: hr_utility.set_location('hr_assignment.del_ref_int_delete',49);

3363: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3364: AND ABV.EFFECTIVE_START_DATE > p_end_date;
3365: --
3366: hr_utility.set_location(' No of rows deleted '||sql%rowcount,48);
3367: hr_utility.set_location('hr_assignment.del_ref_int_delete',49);
3368:
3369: select effective_end_date into l_ass_end_date
3370: from per_all_assignments_f
3371: where assignment_id = p_assignment_id

Line 3399: hr_utility.set_location('hr_assignment.del_ref_int_delete',5);

3395: --
3396: --
3397:
3398: IF p_mode = 'ZAP' THEN
3399: hr_utility.set_location('hr_assignment.del_ref_int_delete',5);
3400: p_del_flag := 'N';
3401: --
3402: BEGIN
3403: --

Line 3411: FROM HR_ASSIGNMENT_SET_AMENDMENTS

3407: into p_del_flag
3408: FROM SYS.DUAL
3409: WHERE EXISTS
3410: (SELECT NULL
3411: FROM HR_ASSIGNMENT_SET_AMENDMENTS
3412: WHERE ASSIGNMENT_ID = p_assignment_id);
3413: --
3414: EXCEPTION
3415: WHEN NO_DATA_FOUND THEN NULL;

Line 3420: hr_utility.set_location('hr_assignment.delete_ass_ref_int',6);

3416: END;
3417: --
3418: IF p_del_flag = 'Y' THEN
3419: --
3420: hr_utility.set_location('hr_assignment.delete_ass_ref_int',6);
3421: DELETE FROM HR_ASSIGNMENT_SET_AMENDMENTS
3422: WHERE ASSIGNMENT_ID = p_assignment_id;
3423: END IF;
3424: --

Line 3421: DELETE FROM HR_ASSIGNMENT_SET_AMENDMENTS

3417: --
3418: IF p_del_flag = 'Y' THEN
3419: --
3420: hr_utility.set_location('hr_assignment.delete_ass_ref_int',6);
3421: DELETE FROM HR_ASSIGNMENT_SET_AMENDMENTS
3422: WHERE ASSIGNMENT_ID = p_assignment_id;
3423: END IF;
3424: --
3425: --

Line 3427: hr_utility.set_location('hr_assignment.del_ref_int_delete',9);

3423: END IF;
3424: --
3425: --
3426: --
3427: hr_utility.set_location('hr_assignment.del_ref_int_delete',9);
3428: p_del_flag := 'N';
3429: --
3430: BEGIN
3431: --

Line 3446: hr_utility.set_location('hr_assignment.delete_ass_ref_int',10);

3442: END;
3443: --
3444: IF p_del_flag = 'Y' THEN
3445: --
3446: hr_utility.set_location('hr_assignment.delete_ass_ref_int',10);
3447: DELETE FROM PER_SECONDARY_ASS_STATUSES
3448: WHERE ASSIGNMENT_ID = p_assignment_id;
3449: END IF;
3450: --

Line 3452: hr_utility.set_location('hr_assignment.del_ref_int_delete',11);

3448: WHERE ASSIGNMENT_ID = p_assignment_id;
3449: END IF;
3450: --
3451: --
3452: hr_utility.set_location('hr_assignment.del_ref_int_delete',11);
3453: p_del_flag := 'N';
3454: --
3455: BEGIN
3456: --

Line 3471: hr_utility.set_location('hr_assignment.delete_ass_ref_int',12);

3467: END;
3468: --
3469: IF p_del_flag = 'Y' THEN
3470: --
3471: hr_utility.set_location('hr_assignment.delete_ass_ref_int',12);
3472: DELETE FROM PER_PAY_PROPOSALS
3473: WHERE ASSIGNMENT_ID = p_assignment_id;
3474: END IF;
3475: --

Line 3478: hr_utility.set_location('hr_assignment.del_ref_int_delete',11);

3474: END IF;
3475: --
3476: /* This is being changed for Bug# 785427 */
3477:
3478: hr_utility.set_location('hr_assignment.del_ref_int_delete',11);
3479: p_del_flag := 'N';
3480:
3481: BEGIN
3482: select 'Y'

Line 3496: hr_utility.set_location('hr_assignment.delete_ass_ref_int',12);

3492: END;
3493: --
3494: IF p_del_flag = 'Y' THEN
3495: --
3496: hr_utility.set_location('hr_assignment.delete_ass_ref_int',12);
3497: /* If the federal tax record exists then the state, county
3498: and city tax records also exist (due to the defaulting of
3499: tax records). So, delete from all 4 table. In addition, delete
3500: from the table pay_us_asg_reporting as well */

Line 3522: hr_utility.set_location('hr_assignment.del_ref_int_delete',14);

3518: --
3519:
3520: -- 03/18/1998 Bug #642566
3521: -- Remove per_assignment_extra_info records
3522: hr_utility.set_location('hr_assignment.del_ref_int_delete',14);
3523: p_del_flag := 'N';
3524: --
3525: BEGIN
3526: --

Line 3541: hr_utility.set_location('hr_assignment.delete_ass_ref_int',16);

3537: END;
3538: --
3539: IF p_del_flag = 'Y' THEN
3540: --
3541: hr_utility.set_location('hr_assignment.delete_ass_ref_int',16);
3542: DELETE FROM PER_ASSIGNMENT_EXTRA_INFO
3543: WHERE ASSIGNMENT_ID = p_assignment_id;
3544: END IF;
3545: -- 03/18/1998 Change Ends

Line 3651: l_proc VARCHAR(72) := 'hr_assignment.tidy_up_ref_int';

3647: ,p_cost_warning OUT NOCOPY BOOLEAN) IS
3648: --
3649: p_del_flag VARCHAR2(1) := 'N';
3650: l_exists NUMBER := 0;
3651: l_proc VARCHAR(72) := 'hr_assignment.tidy_up_ref_int';
3652: l_effective_start_Date DATE;
3653: l_effective_end_date DATE;
3654: --
3655: -- Retrieve all current Assignment Rate records for the assignment.

Line 3681: hr_utility.set_location('hr_assignment.tidy_up_ref_int',1);

3677: AND p_mode='END';
3678: --
3679: BEGIN
3680: --
3681: hr_utility.set_location('hr_assignment.tidy_up_ref_int',1);
3682: --
3683: p_cost_warning := FALSE;
3684: BEGIN
3685: select 'Y'

Line 3706: hr_utility.set_location('hr_assignment.tidy_up_ref_int',2);

3702: END;
3703: --
3704: IF p_del_flag = 'Y' THEN
3705: --
3706: hr_utility.set_location('hr_assignment.tidy_up_ref_int',2);
3707: --
3708: update per_secondary_ass_statuses
3709: set END_DATE = decode(p_new_end_date,to_date('31/12/4712','DD/MM/YYYY'),
3710: null,p_new_end_date)

Line 3727: hr_utility.set_location('hr_assignment.tidy_up_ref_int',3);

3723: END IF;
3724: --
3725: p_del_flag := 'N';
3726: --
3727: hr_utility.set_location('hr_assignment.tidy_up_ref_int',3);
3728: --
3729: BEGIN
3730: select 'Y'
3731: into p_del_flag

Line 3745: hr_utility.set_location('hr_assignment.tidy_up_ref_int',4);

3741: END;
3742: --
3743: IF p_del_flag = 'Y' THEN
3744: --
3745: hr_utility.set_location('hr_assignment.tidy_up_ref_int',4);
3746: --
3747: delete from per_secondary_ass_statuses
3748: where assignment_id = p_assignment_id
3749: and p_mode = 'END'

Line 3755: hr_utility.set_location('hr_assignment.tidy_up_ref_int',5);

3751: END IF;
3752: --
3753: p_del_flag := 'N';
3754: --
3755: hr_utility.set_location('hr_assignment.tidy_up_ref_int',5);
3756: --
3757: BEGIN
3758: select 'Y'
3759: into p_del_flag

Line 3777: hr_utility.set_location('hr_assignment.tidy_up_ref_int',6);

3773: END;
3774: --
3775: IF p_del_flag = 'Y' THEN
3776: --
3777: hr_utility.set_location('hr_assignment.tidy_up_ref_int',6);
3778:
3779: if p_mode = 'END' then
3780: hr_utility.set_location('hr_assignment.tidy_up_ref_int',7);
3781: update pay_cost_allocations_f

Line 3780: hr_utility.set_location('hr_assignment.tidy_up_ref_int',7);

3776: --
3777: hr_utility.set_location('hr_assignment.tidy_up_ref_int',6);
3778:
3779: if p_mode = 'END' then
3780: hr_utility.set_location('hr_assignment.tidy_up_ref_int',7);
3781: update pay_cost_allocations_f
3782: set effective_end_date = p_new_end_date
3783: , last_updated_by = P_LAST_UPDATED_BY
3784: , last_update_login = P_LAST_UPDATE_LOGIN

Line 3791: hr_utility.set_location('hr_assignment.tidy_up_ref_int',8);

3787: and ((p_mode = 'END'
3788: and p_new_end_date
3789: between effective_start_date and effective_end_date));
3790: elsif p_mode='FUTURE' then
3791: hr_utility.set_location('hr_assignment.tidy_up_ref_int',8);
3792:
3793: /*
3794: ** When dealing with delete FUTURE_CHANGE, only open out
3795: ** the costing record if no future costing record exists.

Line 3806: hr_utility.set_location('hr_assignment.tidy_up_ref_int',9);

3802: where assignment_id = p_assignment_id
3803: and effective_start_date > p_old_end_date;
3804:
3805: if l_exists = 0 then
3806: hr_utility.set_location('hr_assignment.tidy_up_ref_int',9);
3807: update pay_cost_allocations_f
3808: set effective_end_date = p_new_end_date
3809: , last_updated_by = P_LAST_UPDATED_BY
3810: , last_update_login = P_LAST_UPDATE_LOGIN

Line 3816: hr_utility.set_location('hr_assignment.tidy_up_ref_int',10);

3812: where assignment_id = p_assignment_id
3813: and (p_mode = 'FUTURE'
3814: and p_old_end_date = effective_end_date);
3815: else
3816: hr_utility.set_location('hr_assignment.tidy_up_ref_int',10);
3817: p_cost_warning := TRUE;
3818: end if;
3819:
3820: end if;

Line 3839: hr_utility.set_location('hr_assignment.tidy_up_ref_int',15);

3835: hr_utility.set_location(p_new_end_date,11);
3836: hr_utility.set_location(p_mode,12);
3837: hr_utility.set_location(p_old_end_date,13);
3838:
3839: hr_utility.set_location('hr_assignment.tidy_up_ref_int',15);
3840:
3841: p_del_flag := 'N';
3842:
3843: --

Line 3861: hr_utility.set_location('hr_assignment.tidy_up_ref_int',20);

3857: END;
3858: --
3859: IF p_del_flag = 'Y' THEN
3860: --
3861: hr_utility.set_location('hr_assignment.tidy_up_ref_int',20);
3862: --
3863: delete from per_assignment_budget_values_f abv
3864: where abv.assignment_id = p_assignment_id
3865: and p_mode = 'END'

Line 3871: hr_utility.set_location('hr_assignment.tidy_up_ref_int',25);

3867: END IF;
3868:
3869: p_del_flag := 'N';
3870: --
3871: hr_utility.set_location('hr_assignment.tidy_up_ref_int',25);
3872:
3873:
3874: BEGIN
3875: select 'Y'

Line 3891: hr_utility.set_location('hr_assignment.tidy_up_ref_int',30);

3887: END;
3888:
3889: IF p_del_flag = 'Y' THEN
3890: --
3891: hr_utility.set_location('hr_assignment.tidy_up_ref_int',30);
3892: --
3893: update per_assignment_budget_values_f abv
3894: set abv.effective_end_date = p_new_end_date
3895: , abv.last_updated_by = P_LAST_UPDATED_BY

Line 3905: hr_utility.set_location('hr_assignment.tidy_up_ref_int',35);

3901:
3902: END IF;
3903:
3904: --
3905: hr_utility.set_location('hr_assignment.tidy_up_ref_int',35);
3906: --
3907: -- # 2437795
3908: -- Reversing TAX records
3909: --

Line 3912: hr_utility.set_location('hr_assignment.tidy_up_ref_int',42);

3908: -- Reversing TAX records
3909: --
3910: IF p_mode = 'FUTURE' THEN
3911: --
3912: hr_utility.set_location('hr_assignment.tidy_up_ref_int',42);
3913: hr_utility.trace(' **** old end date = '||to_char(p_old_end_date,'dd-mon-yyyy'));
3914: declare
3915: cursor csr_asg is
3916: select max(effective_end_date)

Line 3930: hr_utility.set_location('hr_assignment.tidy_up_ref_int',45);

3926: pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records(p_assignment_id, l_end_date);
3927: end if;
3928: end;
3929: --
3930: hr_utility.set_location('hr_assignment.tidy_up_ref_int',45);
3931: END IF;
3932: -- end #2437795
3933: --
3934: --adhunter added for bug 2537091 04-OCT-02

Line 3937: hr_utility.set_location('hr_assignment.tidy_up_ref_int',50);

3933: --
3934: --adhunter added for bug 2537091 04-OCT-02
3935: --need to handle pay_personal_payment_methods in the same way as the others above.
3936: --
3937: hr_utility.set_location('hr_assignment.tidy_up_ref_int',50);
3938: DECLARE
3939: l_effective_start_date date;
3940: l_effective_end_date date;
3941: --

Line 4261: hr_assignment.check_term).

4257: N.B. Strictly the FPD should also be set in the case when the operation
4258: is removing the assignment END date. However this is complicated
4259: by the fact that under certain circumstances the END date may be
4260: automatically moved to be at the ATD (see
4261: hr_assignment.check_term).
4262:
4263: This is not too problematic because a call to
4264: maintain_entries_asg will end any entries that are left open
4265: incorrectly.

Line 4315: hr_utility.set_location('hr_assignment.test_for_cancel_reterm',1);

4311: date of the current operation then cancellation of entries
4312: will be required
4313: -----------------------------------------------------------------*/
4314: --
4315: hr_utility.set_location('hr_assignment.test_for_cancel_reterm',1);
4316: if p_mode in ('CORRECTION'
4317: ,'UPDATE'
4318: ,'UPDATE_OVERRIDE'
4319: ,'UPDATE_CHANGE_INSERT' )

Line 4419: hr_utility.set_location('hr_assignment.check_for_cobra',1);

4415: l_cobra_term_exists VARCHAR2(1);
4416: local_warning exception;
4417: --
4418: BEGIN
4419: hr_utility.set_location('hr_assignment.check_for_cobra',1);
4420: BEGIN
4421: select 'Y'
4422: into l_cobra_term_exists
4423: from sys.dual

Line 4443: hr_utility.set_location('hr_assignment.check_for_cobra',2);

4439: EXCEPTION
4440: WHEN NO_DATA_FOUND THEN NULL;
4441: END;
4442: --
4443: hr_utility.set_location('hr_assignment.check_for_cobra',2);
4444: if l_cobra_term_exists = 'Y' then
4445: raise local_warning;
4446: end if;
4447: --

Line 4554: hr_utility.set_location('Entering hr_assignment.per_dflt_asg_cost_alloc_ff',25);

4550: where business_group_id = p_business_group_id);
4551: --
4552: begin
4553: --
4554: hr_utility.set_location('Entering hr_assignment.per_dflt_asg_cost_alloc_ff',25);
4555: --
4556: open c_formula_id(l_formula_name, p_business_group_id, p_effective_date);
4557: fetch c_formula_id into l_formula_id;
4558: --

Line 4559: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',26);

4555: --
4556: open c_formula_id(l_formula_name, p_business_group_id, p_effective_date);
4557: fetch c_formula_id into l_formula_id;
4558: --
4559: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',26);
4560: --
4561: if c_formula_id%notfound then
4562: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',27);
4563: close c_formula_id;

Line 4562: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',27);

4558: --
4559: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',26);
4560: --
4561: if c_formula_id%notfound then
4562: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',27);
4563: close c_formula_id;
4564: return 'N';
4565: end if;
4566: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',28);

Line 4566: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',28);

4562: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',27);
4563: close c_formula_id;
4564: return 'N';
4565: end if;
4566: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',28);
4567: close c_formula_id;
4568: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-formula_id :'
4569: || l_formula_id,29);
4570: -- Insert fnd_sessions row

Line 4568: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-formula_id :'

4564: return 'N';
4565: end if;
4566: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',28);
4567: close c_formula_id;
4568: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-formula_id :'
4569: || l_formula_id,29);
4570: -- Insert fnd_sessions row
4571: open c_session_date;
4572: fetch c_session_date into l_session_date;

Line 4573: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);

4569: || l_formula_id,29);
4570: -- Insert fnd_sessions row
4571: open c_session_date;
4572: fetch c_session_date into l_session_date;
4573: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);
4574: if c_session_date%notfound then
4575: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',31);
4576: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values(userenv('sessionid'), trunc(p_effective_date));
4577: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',32);

Line 4575: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',31);

4571: open c_session_date;
4572: fetch c_session_date into l_session_date;
4573: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);
4574: if c_session_date%notfound then
4575: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',31);
4576: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values(userenv('sessionid'), trunc(p_effective_date));
4577: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',32);
4578: end if;
4579: --

Line 4577: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',32);

4573: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);
4574: if c_session_date%notfound then
4575: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',31);
4576: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values(userenv('sessionid'), trunc(p_effective_date));
4577: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',32);
4578: end if;
4579: --
4580: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',33);
4581: -- Initialize the formula

Line 4580: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',33);

4576: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values(userenv('sessionid'), trunc(p_effective_date));
4577: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',32);
4578: end if;
4579: --
4580: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',33);
4581: -- Initialize the formula
4582: ff_exec.init_formula(l_formula_id,p_effective_date, l_inputs, l_outputs);
4583: --
4584: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',34);

Line 4584: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',34);

4580: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',33);
4581: -- Initialize the formula
4582: ff_exec.init_formula(l_formula_id,p_effective_date, l_inputs, l_outputs);
4583: --
4584: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',34);
4585: --
4586: --set the inputs
4587: --
4588: for i in nvl(l_inputs.first,0) .. nvl(l_inputs.last,-1) loop

Line 4600: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',35);

4596: l_inputs(i).value := trunc(p_effective_date);
4597: end if;
4598: end loop;
4599: --
4600: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',35);
4601: --
4602: ff_exec.run_formula(l_inputs, l_outputs);
4603: --
4604: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',36);

Line 4604: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',36);

4600: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',35);
4601: --
4602: ff_exec.run_formula(l_inputs, l_outputs);
4603: --
4604: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',36);
4605: --
4606: for i in nvl(l_outputs.first,0) .. nvl(l_outputs.last,-1) loop
4607: if (l_outputs(i).name = 'USE_FORMULA') then
4608: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,361);

Line 4608: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,361);

4604: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',36);
4605: --
4606: for i in nvl(l_outputs.first,0) .. nvl(l_outputs.last,-1) loop
4607: if (l_outputs(i).name = 'USE_FORMULA') then
4608: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,361);
4609: l_use_formula := nvl(l_outputs(i).value,'N');
4610: if (l_use_formula <> 'Y')then
4611: return 'N';
4612: end if;

Line 4614: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,362);

4610: if (l_use_formula <> 'Y')then
4611: return 'N';
4612: end if;
4613: elsif (substr(l_outputs(i).name,1,26) = 'COST_ALLOCATION_KEYFLEX_ID') then
4614: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,362);
4615: l_rec(to_number(substr(l_outputs(i).name,27))).cost_allocation_keyflex_id := l_outputs(i).value;
4616: elsif (substr(l_outputs(i).name,1,10) = 'PROPORTION') then
4617: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,363);
4618: l_rec(to_number(substr(l_outputs(i).name,11))).PROPORTION := l_outputs(i).value;

Line 4617: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,363);

4613: elsif (substr(l_outputs(i).name,1,26) = 'COST_ALLOCATION_KEYFLEX_ID') then
4614: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,362);
4615: l_rec(to_number(substr(l_outputs(i).name,27))).cost_allocation_keyflex_id := l_outputs(i).value;
4616: elsif (substr(l_outputs(i).name,1,10) = 'PROPORTION') then
4617: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-'|| l_outputs(i).value,363);
4618: l_rec(to_number(substr(l_outputs(i).name,11))).PROPORTION := l_outputs(i).value;
4619: end if;
4620: end loop;
4621: --

Line 4622: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',37);

4618: l_rec(to_number(substr(l_outputs(i).name,11))).PROPORTION := l_outputs(i).value;
4619: end if;
4620: end loop;
4621: --
4622: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',37);
4623: --
4624: if l_use_formula = 'Y' then
4625: for i in nvl(l_rec.first,0) .. nvl(l_rec.last,-1) loop
4626: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff l_rec(i).cost_all_kf_id'

Line 4626: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff l_rec(i).cost_all_kf_id'

4622: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',37);
4623: --
4624: if l_use_formula = 'Y' then
4625: for i in nvl(l_rec.first,0) .. nvl(l_rec.last,-1) loop
4626: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff l_rec(i).cost_all_kf_id'
4627: || l_rec(i).cost_allocation_keyflex_id,381);
4628: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff l_rec(i).proportion'
4629: || l_rec(i).proportion,382);
4630: if (nvl(l_rec(i).cost_allocation_keyflex_id, -1) <> -1) then

Line 4628: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff l_rec(i).proportion'

4624: if l_use_formula = 'Y' then
4625: for i in nvl(l_rec.first,0) .. nvl(l_rec.last,-1) loop
4626: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff l_rec(i).cost_all_kf_id'
4627: || l_rec(i).cost_allocation_keyflex_id,381);
4628: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff l_rec(i).proportion'
4629: || l_rec(i).proportion,382);
4630: if (nvl(l_rec(i).cost_allocation_keyflex_id, -1) <> -1) then
4631: --
4632: --

Line 4633: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_rec(i).proportion:'||l_rec(i).proportion,313);

4629: || l_rec(i).proportion,382);
4630: if (nvl(l_rec(i).cost_allocation_keyflex_id, -1) <> -1) then
4631: --
4632: --
4633: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_rec(i).proportion:'||l_rec(i).proportion,313);
4634: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_rec(i).cost_kf_id:'||l_rec(i).cost_allocation_keyflex_id,314);
4635: --
4636: l_proportion := trunc(l_rec(i).proportion,4);
4637: --

Line 4634: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_rec(i).cost_kf_id:'||l_rec(i).cost_allocation_keyflex_id,314);

4630: if (nvl(l_rec(i).cost_allocation_keyflex_id, -1) <> -1) then
4631: --
4632: --
4633: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_rec(i).proportion:'||l_rec(i).proportion,313);
4634: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_rec(i).cost_kf_id:'||l_rec(i).cost_allocation_keyflex_id,314);
4635: --
4636: l_proportion := trunc(l_rec(i).proportion,4);
4637: --
4638: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion1 :'||l_proportion,315);

Line 4638: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion1 :'||l_proportion,315);

4634: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_rec(i).cost_kf_id:'||l_rec(i).cost_allocation_keyflex_id,314);
4635: --
4636: l_proportion := trunc(l_rec(i).proportion,4);
4637: --
4638: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion1 :'||l_proportion,315);
4639: if l_proportion > 1 then
4640: l_proportion := 1;
4641: end if;
4642: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion2 :'||l_proportion,316);

Line 4642: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion2 :'||l_proportion,316);

4638: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion1 :'||l_proportion,315);
4639: if l_proportion > 1 then
4640: l_proportion := 1;
4641: end if;
4642: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion2 :'||l_proportion,316);
4643: --
4644: if l_proportion > 0 then
4645: for r3 in c_cost_allocation_keyflex(l_rec(i).cost_allocation_keyflex_id) loop
4646: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',39);

Line 4646: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',39);

4642: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff - l_proportion2 :'||l_proportion,316);
4643: --
4644: if l_proportion > 0 then
4645: for r3 in c_cost_allocation_keyflex(l_rec(i).cost_allocation_keyflex_id) loop
4646: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',39);
4647: --
4648: pay_cost_allocation_api.create_cost_allocation(
4649: p_validate =>false ,
4650: p_effective_date =>p_effective_date,

Line 4693: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',391);

4689: p_segment30 =>r3.segment30,
4690: p_concat_segments =>r3.concatenated_segments
4691: );
4692: end loop;
4693: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',391);
4694: --
4695: end if;
4696: --
4697: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',40);

Line 4697: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',40);

4693: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',391);
4694: --
4695: end if;
4696: --
4697: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',40);
4698: --
4699: end if;
4700: --
4701: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',41);

Line 4701: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',41);

4697: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',40);
4698: --
4699: end if;
4700: --
4701: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',41);
4702: --
4703: end loop;
4704: --
4705: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',42);

Line 4705: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',42);

4701: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',41);
4702: --
4703: end loop;
4704: --
4705: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',42);
4706: --
4707: return 'Y';
4708: --
4709: end if;

Line 4711: hr_utility.set_location('Leaving hr_assignment.per_dflt_asg_cost_alloc_ff',43);

4707: return 'Y';
4708: --
4709: end if;
4710: --
4711: hr_utility.set_location('Leaving hr_assignment.per_dflt_asg_cost_alloc_ff',43);
4712: --
4713: return 'N';
4714: --
4715: end;

Line 4837: hr_utility.set_location('hr_assignment.load_assignment_allocation',1);

4833: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4834: );
4835: --
4836: BEGIN
4837: hr_utility.set_location('hr_assignment.load_assignment_allocation',1);
4838: --
4839: if nvl(fnd_profile.value('HR_DEFAULT_ASG_COST_ALLOC'),'N') <> 'Y' then
4840: return;
4841: end if;

Line 4843: hr_utility.set_location('hr_assignment.load_assignment_allocation',2);

4839: if nvl(fnd_profile.value('HR_DEFAULT_ASG_COST_ALLOC'),'N') <> 'Y' then
4840: return;
4841: end if;
4842: --
4843: hr_utility.set_location('hr_assignment.load_assignment_allocation',2);
4844: --
4845: if p_position_id is null then
4846: return;
4847: end if;

Line 4849: hr_utility.set_location('hr_assignment.load_assignment_allocation',3);

4845: if p_position_id is null then
4846: return;
4847: end if;
4848: --
4849: hr_utility.set_location('hr_assignment.load_assignment_allocation',3);
4850: hr_utility.set_location('hr_assignment.load_assignment_allocation - effec date :'|| p_effective_date,3);
4851: hr_utility.set_location('hr_assignment.load_assignment_allocation - p_position_id :'|| p_position_id,3);
4852: hr_utility.set_location('hr_assignment.load_assignment_allocation - assignment_id :'|| p_assignment_id,3);
4853: hr_utility.set_location('hr_assignment.load_assignment_allocation - business_group_id :'|| p_business_group_id,3);

Line 4850: hr_utility.set_location('hr_assignment.load_assignment_allocation - effec date :'|| p_effective_date,3);

4846: return;
4847: end if;
4848: --
4849: hr_utility.set_location('hr_assignment.load_assignment_allocation',3);
4850: hr_utility.set_location('hr_assignment.load_assignment_allocation - effec date :'|| p_effective_date,3);
4851: hr_utility.set_location('hr_assignment.load_assignment_allocation - p_position_id :'|| p_position_id,3);
4852: hr_utility.set_location('hr_assignment.load_assignment_allocation - assignment_id :'|| p_assignment_id,3);
4853: hr_utility.set_location('hr_assignment.load_assignment_allocation - business_group_id :'|| p_business_group_id,3);
4854: --

Line 4851: hr_utility.set_location('hr_assignment.load_assignment_allocation - p_position_id :'|| p_position_id,3);

4847: end if;
4848: --
4849: hr_utility.set_location('hr_assignment.load_assignment_allocation',3);
4850: hr_utility.set_location('hr_assignment.load_assignment_allocation - effec date :'|| p_effective_date,3);
4851: hr_utility.set_location('hr_assignment.load_assignment_allocation - p_position_id :'|| p_position_id,3);
4852: hr_utility.set_location('hr_assignment.load_assignment_allocation - assignment_id :'|| p_assignment_id,3);
4853: hr_utility.set_location('hr_assignment.load_assignment_allocation - business_group_id :'|| p_business_group_id,3);
4854: --
4855: open c_asg_cost_allocations(p_assignment_id);

Line 4852: hr_utility.set_location('hr_assignment.load_assignment_allocation - assignment_id :'|| p_assignment_id,3);

4848: --
4849: hr_utility.set_location('hr_assignment.load_assignment_allocation',3);
4850: hr_utility.set_location('hr_assignment.load_assignment_allocation - effec date :'|| p_effective_date,3);
4851: hr_utility.set_location('hr_assignment.load_assignment_allocation - p_position_id :'|| p_position_id,3);
4852: hr_utility.set_location('hr_assignment.load_assignment_allocation - assignment_id :'|| p_assignment_id,3);
4853: hr_utility.set_location('hr_assignment.load_assignment_allocation - business_group_id :'|| p_business_group_id,3);
4854: --
4855: open c_asg_cost_allocations(p_assignment_id);
4856: fetch c_asg_cost_allocations into l_dummy;

Line 4853: hr_utility.set_location('hr_assignment.load_assignment_allocation - business_group_id :'|| p_business_group_id,3);

4849: hr_utility.set_location('hr_assignment.load_assignment_allocation',3);
4850: hr_utility.set_location('hr_assignment.load_assignment_allocation - effec date :'|| p_effective_date,3);
4851: hr_utility.set_location('hr_assignment.load_assignment_allocation - p_position_id :'|| p_position_id,3);
4852: hr_utility.set_location('hr_assignment.load_assignment_allocation - assignment_id :'|| p_assignment_id,3);
4853: hr_utility.set_location('hr_assignment.load_assignment_allocation - business_group_id :'|| p_business_group_id,3);
4854: --
4855: open c_asg_cost_allocations(p_assignment_id);
4856: fetch c_asg_cost_allocations into l_dummy;
4857: if c_asg_cost_allocations%found then

Line 4858: hr_utility.set_location('hr_assignment.load_assignment_allocation',4);

4854: --
4855: open c_asg_cost_allocations(p_assignment_id);
4856: fetch c_asg_cost_allocations into l_dummy;
4857: if c_asg_cost_allocations%found then
4858: hr_utility.set_location('hr_assignment.load_assignment_allocation',4);
4859: return;
4860: end if;
4861: --
4862: hr_utility.set_location('hr_assignment.load_assignment_allocation',5);

Line 4862: hr_utility.set_location('hr_assignment.load_assignment_allocation',5);

4858: hr_utility.set_location('hr_assignment.load_assignment_allocation',4);
4859: return;
4860: end if;
4861: --
4862: hr_utility.set_location('hr_assignment.load_assignment_allocation',5);
4863: --
4864: if (per_dflt_asg_cost_alloc_ff(p_assignment_id, p_business_group_id, p_position_id, p_effective_date) = 'Y') then
4865: hr_utility.set_location('hr_assignment.load_assignment_allocation',6);
4866: return;

Line 4865: hr_utility.set_location('hr_assignment.load_assignment_allocation',6);

4861: --
4862: hr_utility.set_location('hr_assignment.load_assignment_allocation',5);
4863: --
4864: if (per_dflt_asg_cost_alloc_ff(p_assignment_id, p_business_group_id, p_position_id, p_effective_date) = 'Y') then
4865: hr_utility.set_location('hr_assignment.load_assignment_allocation',6);
4866: return;
4867: end if;
4868: --
4869: hr_utility.set_location('hr_assignment.load_assignment_allocation',7);

Line 4869: hr_utility.set_location('hr_assignment.load_assignment_allocation',7);

4865: hr_utility.set_location('hr_assignment.load_assignment_allocation',6);
4866: return;
4867: end if;
4868: --
4869: hr_utility.set_location('hr_assignment.load_assignment_allocation',7);
4870: --
4871: open c0;
4872: fetch c0 into l_unit1, l_unit2, l_unit3;
4873: close c0;

Line 4875: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit1,8);

4871: open c0;
4872: fetch c0 into l_unit1, l_unit2, l_unit3;
4873: close c0;
4874: --
4875: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit1,8);
4876: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit2,9);
4877: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit3,10);
4878: --
4879: open c2(l_unit1, l_unit2, l_unit3);

Line 4876: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit2,9);

4872: fetch c0 into l_unit1, l_unit2, l_unit3;
4873: close c0;
4874: --
4875: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit1,8);
4876: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit2,9);
4877: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit3,10);
4878: --
4879: open c2(l_unit1, l_unit2, l_unit3);
4880: fetch c2 into l_period_value;

Line 4877: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit3,10);

4873: close c0;
4874: --
4875: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit1,8);
4876: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit2,9);
4877: hr_utility.set_location('hr_assignment.load_assignment_allocation - ' || l_unit3,10);
4878: --
4879: open c2(l_unit1, l_unit2, l_unit3);
4880: fetch c2 into l_period_value;
4881: close c2;

Line 4883: hr_utility.set_location('hr_assignment.load_assignment_allocation - '|| l_period_value,11);

4879: open c2(l_unit1, l_unit2, l_unit3);
4880: fetch c2 into l_period_value;
4881: close c2;
4882: --
4883: hr_utility.set_location('hr_assignment.load_assignment_allocation - '|| l_period_value,11);
4884: --
4885: if nvl(l_period_value,0) <> 0 then
4886: --
4887: hr_utility.set_location('hr_assignment.load_assignment_allocation ',12);

Line 4887: hr_utility.set_location('hr_assignment.load_assignment_allocation ',12);

4883: hr_utility.set_location('hr_assignment.load_assignment_allocation - '|| l_period_value,11);
4884: --
4885: if nvl(l_period_value,0) <> 0 then
4886: --
4887: hr_utility.set_location('hr_assignment.load_assignment_allocation ',12);
4888: --
4889: for r1 in c1(l_unit1, l_unit2, l_unit3) loop
4890: --
4891: hr_utility.set_location('hr_assignment.load_assignment_allocation - '||r1.proportion,13);

Line 4891: hr_utility.set_location('hr_assignment.load_assignment_allocation - '||r1.proportion,13);

4887: hr_utility.set_location('hr_assignment.load_assignment_allocation ',12);
4888: --
4889: for r1 in c1(l_unit1, l_unit2, l_unit3) loop
4890: --
4891: hr_utility.set_location('hr_assignment.load_assignment_allocation - '||r1.proportion,13);
4892: hr_utility.set_location('hr_assignment.load_assignment_allocation - '||r1.cost_allocation_keyflex_id,14);
4893: --
4894: l_proportion := trunc(r1.proportion/l_period_value,4);
4895: --

Line 4892: hr_utility.set_location('hr_assignment.load_assignment_allocation - '||r1.cost_allocation_keyflex_id,14);

4888: --
4889: for r1 in c1(l_unit1, l_unit2, l_unit3) loop
4890: --
4891: hr_utility.set_location('hr_assignment.load_assignment_allocation - '||r1.proportion,13);
4892: hr_utility.set_location('hr_assignment.load_assignment_allocation - '||r1.cost_allocation_keyflex_id,14);
4893: --
4894: l_proportion := trunc(r1.proportion/l_period_value,4);
4895: --
4896: if l_proportion > 1 then

Line 4950: hr_utility.set_location('hr_assignment.load_assignment_allocation ',15);

4946: end loop;
4947: --
4948: end if;
4949: --
4950: hr_utility.set_location('hr_assignment.load_assignment_allocation ',15);
4951: --
4952: end loop;
4953: --
4954: hr_utility.set_location('hr_assignment.load_assignment_allocation ',16);

Line 4954: hr_utility.set_location('hr_assignment.load_assignment_allocation ',16);

4950: hr_utility.set_location('hr_assignment.load_assignment_allocation ',15);
4951: --
4952: end loop;
4953: --
4954: hr_utility.set_location('hr_assignment.load_assignment_allocation ',16);
4955: --
4956: end if;
4957: --
4958: hr_utility.set_location('hr_assignment.load_assignment_allocation ',17);

Line 4958: hr_utility.set_location('hr_assignment.load_assignment_allocation ',17);

4954: hr_utility.set_location('hr_assignment.load_assignment_allocation ',16);
4955: --
4956: end if;
4957: --
4958: hr_utility.set_location('hr_assignment.load_assignment_allocation ',17);
4959: --
4960: END load_assignment_allocation;
4961: -----------------------------------------------------------------------
4962: -- update_assgn_context_value

Line 5041: HR_ASSIGNMENT.get_assgn_dff_value('||p_business_group_id||','||p_person_id||','||p_assignment_id||','||':1,g_rec);

5037: l_sql := '
5038: declare
5039: g_rec per_assignments_v%rowtype;
5040: begin
5041: HR_ASSIGNMENT.get_assgn_dff_value('||p_business_group_id||','||p_person_id||','||p_assignment_id||','||':1,g_rec);
5042: select g_rec.'||l_context_val||' into :2 from dual;
5043: end;';
5044:
5045: EXECUTE IMMEDIATE l_sql using

Line 5350: end hr_assignment;

5346: END get_assgn_dff_value;
5347:
5348: --end for bug 6598795
5349: ---------------------------------------------------------------------------------------
5350: end hr_assignment;