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

Line 154: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',10);

150: l_person per_all_people_f%rowtype;
151: --
152: /* END OF WWBUG 1975359 */
153: BEGIN
154: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',10);
155: if X_Current_Application_Id = 810
156: then
157: per_people_v7_pkg.check_person_changes(X_person_id
158: ,X_hire_date

Line 161: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',20);

157: per_people_v7_pkg.check_person_changes(X_person_id
158: ,X_hire_date
159: ,X_s_hire_Date
160: ,X_current_application_id );
161: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',20);
162: end if;
163: if X_termination_date is not null
164: and X_S_termination_date is null
165: and X_current_employee_flag = 'Y'

Line 167: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',30);

163: if X_termination_date is not null
164: and X_S_termination_date is null
165: and X_current_employee_flag = 'Y'
166: then
167: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',30);
168: per_people_v7_pkg.check_person_changes(X_person_id
169: ,X_termination_date
170: ,X_Hire_date
171: ,X_current_application_id );

Line 176: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',40);

172: X_effective_end_date := X_termination_date;
173: elsif x_hire_date <> X_s_hire_date then
174: X_effective_start_date := X_hire_date;
175: X_start_date := X_hire_date;
176: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',40);
177: end if;
178: /* BEGIN OF WWBUG 1975359 */
179: open c1;
180: --

Line 185: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',50);

181: fetch c1 into l_party_id;
182: --
183: close c1;
184: /* END OF WWBUG 1975359 */
185: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',50);
186: UPDATE PER_PEOPLE_F
187: SET
188: person_id = X_Person_Id,
189: party_id = l_Party_Id,

Line 307: hr_utility.set_location('per_people_v7_pkg.update_row',55);

303: -- ,p_person_type_id => X_Person_Type_Id
304: -- ,p_datetrack_update_mode=> 'CORRECTION'
305: -- );
306: --
307: hr_utility.set_location('per_people_v7_pkg.update_row',55);
308: -- PTU : End of Changes
309:
310: /* BEGIN OF WWBUG 1975359 */
311: --

Line 316: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',60);

312: open c_person;
313: --
314: fetch c_person into l_person;
315: --
316: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',60);
317: close c_person;
318: --
319: per_hrtca_merge.update_tca_person(p_Rec => l_person);
320: --

Line 321: hr_utility.set_location('update_row - after update',1);

317: close c_person;
318: --
319: per_hrtca_merge.update_tca_person(p_Rec => l_person);
320: --
321: hr_utility.set_location('update_row - after update',1);
322: --
323: /* END OF WWBUG 1975359 */
324: --
325: -- HR/WF Synchronization call

Line 346: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',70);

342: -- phone B.P.
343: --
344: if (l_old_work_telephone is null and
345: x_work_telephone is not null) then
346: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',70);
347: hr_phone_api.create_phone
348: (p_date_from => x_start_date
349: ,p_date_to => null
350: ,p_phone_type => 'W1'

Line 364: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',80);

360: -- If old entry is not null and corrected entry is null then delete the phone.
361: --
362: elsif l_old_work_telephone is not null and x_work_telephone is null then
363: hr_phone_api.delete_phone(FALSE, l_phone_id, l_phn_object_version_number);
364: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',80);
365: --
366: -- If old and corrected entries are both not null then update the row with
367: -- no changes to start and to dates.
368: --

Line 370: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',90);

366: -- If old and corrected entries are both not null then update the row with
367: -- no changes to start and to dates.
368: --
369: elsif l_old_work_telephone is not null and x_work_telephone is not null then
370: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',90);
371: --
372: -- 115.22: only one row is maintained in per_phones.
373: -- when changing the phone, date_to should remain null. This keeps the
374: -- row "open" until the "end of time"

Line 377: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',95);

373: -- when changing the phone, date_to should remain null. This keeps the
374: -- row "open" until the "end of time"
375: if ( l_old_work_telephone <> x_work_telephone) then
376: -- Bug 5554383 : Added IF condition.
377: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',95);
378: hr_phone_api.update_phone
379: (p_phone_id => l_phone_id,
380: p_phone_number => x_work_telephone,
381: p_date_to => null, -- 1020074 x_termination_date,

Line 389: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',100);

385: end if;
386: --
387: -- End of logic for the update of the phones table
388: --
389: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',100);
390: --
391: if X_termination_date is not null
392: and X_S_termination_date is null
393: and X_current_employee_flag = 'Y'

Line 395: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',110);

391: if X_termination_date is not null
392: and X_S_termination_date is null
393: and X_current_employee_flag = 'Y'
394: then
395: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',110);
396: terminate_employment(X_period_of_service_id
397: ,X_person_id
398: ,X_Rowid
399: ,X_Business_group_id

Line 403: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',120);

399: ,X_Business_group_id
400: ,X_termination_date);
401: elsif X_hire_date <> X_s_hire_date
402: then
403: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',120);
404: update_employee_rows(X_period_of_service_id
405: ,X_person_id
406: ,X_hire_date
407: ,X_s_hire_date);

Line 409: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',130);

405: ,X_person_id
406: ,X_hire_date
407: ,X_s_hire_date);
408: end if;
409: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',130);
410: END Update_Row;
411: --
412: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
413: BEGIN

Line 459: hr_utility.set_location('Entering: '||c_proc_name,10);

455: l_person_id per_all_people_f.person_id%TYPE;
456:
457: --
458: begin
459: hr_utility.set_location('Entering: '||c_proc_name,10);
460: hr_utility.trace('p_start_date = '||to_char(p_start_date,'DD-MON-YYYY'));
461:
462: l_person_id := p_person_id;
463: l_period_of_service_id := p_pos_id;

Line 460: hr_utility.trace('p_start_date = '||to_char(p_start_date,'DD-MON-YYYY'));

456:
457: --
458: begin
459: hr_utility.set_location('Entering: '||c_proc_name,10);
460: hr_utility.trace('p_start_date = '||to_char(p_start_date,'DD-MON-YYYY'));
461:
462: l_person_id := p_person_id;
463: l_period_of_service_id := p_pos_id;
464:

Line 711: hr_utility.set_location('Leaving: '||c_proc_name,99);

707: p_person_rec.order_name,
708: p_person_rec.global_name,
709: p_person_rec.local_name);
710:
711: hr_utility.set_location('Leaving: '||c_proc_name,99);
712:
713: end create_EX_EMP;
714: --
715: --

Line 783: g_debug := hr_utility.debug_enabled; -- get debug status

779: --
780: l_c1 c1%rowtype;
781: --
782: begin
783: g_debug := hr_utility.debug_enabled; -- get debug status
784: IF g_debug THEN
785: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
786: END IF;
787:

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

781: --
782: begin
783: g_debug := hr_utility.debug_enabled; -- get debug status
784: IF g_debug THEN
785: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
786: END IF;
787:
788: open period;
789: fetch period into l_dummy_date;

Line 795: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);

791: --
792: -- START WWBUG 1390173 fix
793: --
794: IF g_debug THEN
795: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
796: END IF;
797: open c1;
798: fetch c1 into l_c1;
799: if c1%found then

Line 838: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);

834: -- END WWBUG 1390173 fix
835: --
836: --START HR/WF Synchronization --tpapired
837: IF g_debug THEN
838: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);
839: END IF;
840: per_hrwf_synch.per_pds_wf(
841: p_rec => l_c1,
842: p_date => X_termination_date,

Line 857: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);

853: end;
854: --
855:
856: IF g_debug THEN
857: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);
858: END IF;
859:
860: open assignment;
861: loop

Line 874: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);

870: and effective_end_date = to_date('31-12-4712','DD-MM-YYYY');
871: end;
872: --
873: IF g_debug THEN
874: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);
875: END IF;
876:
877: open ex_status;
878: fetch ex_status into l_person_type_id,l_current_emp_or_apl_flag

Line 1029: hr_utility.set_location('Leaving: '|| g_package || l_proc, 50);

1025: -- );
1026: --
1027: -- PTU : End of Changes
1028: IF g_debug THEN
1029: hr_utility.set_location('Leaving: '|| g_package || l_proc, 50);
1030: END IF;
1031:
1032: end;
1033: --

Line 1096: g_debug := hr_utility.debug_enabled; -- get debug status

1092: --
1093: l_proc varchar2(20) := 'update_employee_rows';
1094: --
1095: BEGIN
1096: g_debug := hr_utility.debug_enabled; -- get debug status
1097: IF g_debug THEN
1098: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1099: END IF;
1100:

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

1094: --
1095: BEGIN
1096: g_debug := hr_utility.debug_enabled; -- get debug status
1097: IF g_debug THEN
1098: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1099: END IF;
1100:
1101: open period;
1102: fetch period into l_dummy_date;

Line 1109: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);

1105: --
1106: -- START WWBUG 1390173 fix
1107: --
1108: IF g_debug THEN
1109: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
1110: END IF;
1111:
1112: open c1;
1113: fetch c1 into l_c1;

Line 1161: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);

1157: when no_data_found then null;
1158: end;
1159: --
1160: IF g_debug THEN
1161: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);
1162: END IF;
1163:
1164: open assignment;
1165: loop

Line 1185: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);

1181: --end if;
1182: end;
1183: --
1184: IF g_debug THEN
1185: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);
1186: END IF;
1187:
1188: open address;
1189: loop

Line 1249: hr_utility.set_location('leaving: '|| g_package || l_proc, 40);

1245: --
1246: end if;
1247: --
1248: IF g_debug THEN
1249: hr_utility.set_location('leaving: '|| g_package || l_proc, 40);
1250: END IF;
1251:
1252:
1253: END update_employee_rows;

Line 1365: g_debug := hr_utility.debug_enabled; -- get debug status

1361: l_date_start date;
1362: l_person_rec per_all_people_f%ROWTYPE;
1363: --
1364: BEGIN
1365: g_debug := hr_utility.debug_enabled; -- get debug status
1366: IF g_debug THEN
1367: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1368: END IF;
1369:

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

1363: --
1364: BEGIN
1365: g_debug := hr_utility.debug_enabled; -- get debug status
1366: IF g_debug THEN
1367: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1368: END IF;
1369:
1370: --
1371: -- 2975471: Ensure new hire date is greater than last termination date

Line 1377: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);

1373: fetch period into l_date_start, l_business_group_id;
1374: close period;
1375:
1376: IF g_debug THEN
1377: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
1378: END IF;
1379:
1380: if l_date_start is not null then
1381: open csr_latestATD(l_date_start);

Line 1387: hr_utility.set_message(800,'HR_6841_EMP_REF_DATE_CHG');

1383: close csr_latestATD;
1384: if (l_atd is not null)
1385: and (X_Hire_date <= l_atd)
1386: then
1387: hr_utility.set_message(800,'HR_6841_EMP_REF_DATE_CHG');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391: --

Line 1388: hr_utility.raise_error;

1384: if (l_atd is not null)
1385: and (X_Hire_date <= l_atd)
1386: then
1387: hr_utility.set_message(800,'HR_6841_EMP_REF_DATE_CHG');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391: --
1392: -- this call is replaced by previous stmts

Line 1399: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);

1395: -- ,p_s_hire_Date => X_S_Hire_Date);
1396: -- end #2975471
1397:
1398: IF g_debug THEN
1399: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);
1400: END IF;
1401:
1402: open ex_emp_rec;
1403: fetch ex_emp_rec into l_dummy_date;

Line 1417: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);

1413: close ex_emp_rec;
1414: --
1415:
1416: IF g_debug THEN
1417: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);
1418: END IF;
1419:
1420: open emp_rec;
1421: fetch emp_rec into l_dummy_num;

Line 1440: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);

1436: close emp_rec;
1437: --
1438:
1439: IF g_debug THEN
1440: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);
1441: END IF;
1442:
1443: if (X_s_hire_date > X_hire_date) then
1444: l_later_date := X_s_hire_date;

Line 1473: hr_utility.set_location('Entering: '|| g_package || l_proc, 50);

1469: and effective_start_date = X_s_hire_date;
1470: --
1471:
1472: IF g_debug THEN
1473: hr_utility.set_location('Entering: '|| g_package || l_proc, 50);
1474: END IF;
1475:
1476:
1477: open address;

Line 1497: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');

1493: else
1494: --
1495: close address;
1496: close is_valid_addr;
1497: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');
1498: hr_utility.raise_error;
1499: --
1500: end if;
1501: end if;

Line 1498: hr_utility.raise_error;

1494: --
1495: close address;
1496: close is_valid_addr;
1497: hr_utility.set_message(801,'HR_6510_PER_PRIMARY_ADDRESS');
1498: hr_utility.raise_error;
1499: --
1500: end if;
1501: end if;
1502: close address;

Line 1506: hr_utility.set_location('Entering: '|| g_package || l_proc, 60);

1502: close address;
1503: --
1504:
1505: IF g_debug THEN
1506: hr_utility.set_location('Entering: '|| g_package || l_proc, 60);
1507: END IF;
1508:
1509: if SQL%ROWCOUNT < 1 then
1510: raise no_data_found;

Line 1521: --hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');

1517: --
1518: -- #2975471
1519: --
1520: if l_atd is not null and ((l_atd + 1) = X_S_Hire_Date) then -- back-to-back hire?
1521: --hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
1522: --hr_utility.raise_error;
1523:
1524: IF g_debug THEN
1525: hr_utility.set_location('Entering: '|| g_package || l_proc, 70);

Line 1522: --hr_utility.raise_error;

1518: -- #2975471
1519: --
1520: if l_atd is not null and ((l_atd + 1) = X_S_Hire_Date) then -- back-to-back hire?
1521: --hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
1522: --hr_utility.raise_error;
1523:
1524: IF g_debug THEN
1525: hr_utility.set_location('Entering: '|| g_package || l_proc, 70);
1526: END IF;

Line 1525: hr_utility.set_location('Entering: '|| g_package || l_proc, 70);

1521: --hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
1522: --hr_utility.raise_error;
1523:
1524: IF g_debug THEN
1525: hr_utility.set_location('Entering: '|| g_package || l_proc, 70);
1526: END IF;
1527:
1528:
1529: open csr_person(l_atd, l_business_group_id);

Line 1555: hr_utility.set_location('Entering: '|| g_package || l_proc, 80);

1551: end if;
1552: --
1553:
1554: IF g_debug THEN
1555: hr_utility.set_location('Entering: '|| g_package || l_proc, 80);
1556: END IF;
1557:
1558: if l_date_start is not null then
1559: --

Line 1570: hr_utility.set_location('Entering: '|| g_package || l_proc, 90);

1566: end if;
1567: --
1568:
1569: IF g_debug THEN
1570: hr_utility.set_location('Entering: '|| g_package || l_proc, 90);
1571: END IF;
1572:
1573: open phones;
1574: fetch phones into l_Phone_Id,l_Work_Telephone,l_Phone_OVN;

Line 1588: hr_utility.set_location('Leaving: '|| g_package || l_proc, 100);

1584: close phones;
1585: --
1586:
1587: IF g_debug THEN
1588: hr_utility.set_location('Leaving: '|| g_package || l_proc, 100);
1589: END IF;
1590:
1591:
1592: End modify_hire_date;

Line 1649: g_debug := hr_utility.debug_enabled; -- get debug status

1645: --
1646:
1647: --changes for bug 5857638 here
1648: begin
1649: g_debug := hr_utility.debug_enabled; -- get debug status
1650: IF g_debug THEN
1651: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1652: END IF;
1653:

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

1647: --changes for bug 5857638 here
1648: begin
1649: g_debug := hr_utility.debug_enabled; -- get debug status
1650: IF g_debug THEN
1651: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1652: END IF;
1653:
1654:
1655: --

Line 1674: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);

1670: --
1671: -- Lock and update the Period of Service row
1672: --
1673: IF g_debug THEN
1674: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
1675: END IF;
1676: open period;
1677: loop
1678: fetch period into l_dummy_date;

Line 1691: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);

1687: --
1688: -- Lock Person rows
1689: --
1690: IF g_debug THEN
1691: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);
1692: END IF;
1693: open person;
1694: loop
1695: ----changes for bug 5857638 here

Line 1699: hr_utility.set_location('Entering : per_people_v7_pkg.cancel termination',25);

1695: ----changes for bug 5857638 here
1696: -- fetch person into l_dummy_date;
1697: fetch person into l_person_record;
1698: if l_person_record.effective_end_date=X_s_termination_date then
1699: hr_utility.set_location('Entering : per_people_v7_pkg.cancel termination',25);
1700: l_EFFECTIVE_START_DATE :=l_person_record.EFFECTIVE_START_DATE;
1701: l_CURRENT_EMP_OR_APL_FLAG :=l_person_record.CURRENT_EMP_OR_APL_FLAG;
1702: l_CURRENT_EMPLOYEE_FLAG :=l_person_record.CURRENT_EMPLOYEE_FLAG;
1703: l_PERSON_TYPE_ID :=l_person_record.PERSON_TYPE_ID;

Line 1713: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);

1709: -- Reverse Date-track change by deleting current row
1710: -- and updating Previous row.
1711: --
1712: IF g_debug THEN
1713: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);
1714: END IF;
1715: delete from per_people_f
1716: --changes for bug 5857638 here
1717: -- where effective_start_date = X_s_termination_date + 1

Line 1722: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);

1718: where effective_end_date = X_s_termination_date
1719: --changes for bug 5857638 here
1720: and person_id = X_person_id;
1721: IF g_debug THEN
1722: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);
1723: END IF;
1724: --
1725: update per_people_f
1726: -- set effective_end_date = hr_general.end_of_time

Line 1782: hr_utility.set_location('Entering: '|| g_package || l_proc, 50);

1778: -- #2287055: modified effective_date and system_person_type
1779: -- parameters value.
1780: --
1781: IF g_debug THEN
1782: hr_utility.set_location('Entering: '|| g_package || l_proc, 50);
1783: END IF;
1784: hr_per_type_usage_internal.cancel_person_type_usage
1785: (p_effective_date => X_s_termination_date+1
1786: ,p_person_id => X_person_id

Line 1793: hr_utility.set_location('Entering: '|| g_package || l_proc, 60);

1789:
1790: -- PTU : End of Changes
1791: --START HR/WF Synchronization --tpapired
1792: IF g_debug THEN
1793: hr_utility.set_location('Entering: '|| g_package || l_proc, 60);
1794: END IF;
1795:
1796: open l_pds_cur;
1797: fetch l_pds_cur into l_pds_rec;

Line 1807: hr_utility.set_location('Leaving: '|| g_package || l_proc, 70);

1803: --
1804: --END HR/WF Synchronization --tpapired
1805: --
1806: IF g_debug THEN
1807: hr_utility.set_location('Leaving: '|| g_package || l_proc, 70);
1808: END IF;
1809: end cancel_termination;
1810: --
1811: procedure rehire(X_Person_Id NUMBER

Line 1888: g_debug := hr_utility.debug_enabled; -- get debug status

1884: --
1885:
1886: --
1887: begin
1888: g_debug := hr_utility.debug_enabled; -- get debug status
1889: IF g_debug THEN
1890: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1891: END IF;
1892:

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

1886: --
1887: begin
1888: g_debug := hr_utility.debug_enabled; -- get debug status
1889: IF g_debug THEN
1890: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1891: END IF;
1892:
1893: open person;
1894: fetch person into per_rec;

Line 1916: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);

1912: (p_person_id => X_Person_Id,
1913: p_hire_date_of_current_pds => X_HIRE_DATE)) then
1914:
1915: IF g_debug THEN
1916: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
1917: END IF;
1918:
1919: UPDATE PER_ALL_PEOPLE_F
1920: SET effective_start_date=X_hire_date,

Line 2044: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);

2040: and effective_end_date;
2041:
2042:
2043: IF g_debug THEN
2044: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);
2045: END IF;
2046:
2047:
2048: IF (type_rec.Current_Employee_Flag IS NOT NULL)

Line 2058: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);

2054: );
2055: END IF;
2056:
2057: IF g_debug THEN
2058: hr_utility.set_location('Entering: '|| g_package || l_proc, 30);
2059: END IF;
2060:
2061:
2062: hr_per_type_usage_internal.maintain_person_type_usage

Line 2074: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);

2070: -- End of Fix for Bug 2438403
2071: else
2072:
2073: IF g_debug THEN
2074: hr_utility.set_location('Entering: '|| g_package || l_proc, 40);
2075: END IF;
2076:
2077: open person;
2078: fetch person into per_rec;

Line 2085: hr_utility.set_location('Entering: '|| g_package || l_proc, 50);

2081: where current of person;
2082: close person;
2083:
2084: IF g_debug THEN
2085: hr_utility.set_location('Entering: '|| g_package || l_proc, 50);
2086: END IF;
2087:
2088:
2089: per_people_v14_pkg.insert_row(l_Rowid

Line 2205: hr_utility.set_location('Entering: '|| g_package || l_proc, 60);

2201: end if; --backtoback
2202: --
2203:
2204: IF g_debug THEN
2205: hr_utility.set_location('Entering: '|| g_package || l_proc, 60);
2206: END IF;
2207:
2208: PER_ASSIGNMENTS_V7_PKG.insert_row(X_Rowid =>l_rowid
2209: ,X_Assignment_Id =>l_ass_id

Line 2300: hr_utility.set_location('Entering: '|| g_package || l_proc, 70);

2296: );
2297: --START HR/WF Synchronization --tpapired
2298:
2299: IF g_debug THEN
2300: hr_utility.set_location('Entering: '|| g_package || l_proc, 70);
2301: END IF;
2302:
2303: open l_pds_cur;
2304: fetch l_pds_cur into l_pds_rec;

Line 2314: hr_utility.set_location('Leaving: '|| g_package || l_proc, 80);

2310: --
2311: --END HR/WF Synchronization --tpapired
2312: --
2313: IF g_debug THEN
2314: hr_utility.set_location('Leaving: '|| g_package || l_proc, 80);
2315: END IF;
2316:
2317:
2318: end;

Line 2360: g_debug := hr_utility.debug_enabled; -- get debug status

2356: l_proc varchar2(25) := 'check_future_person_types';
2357: --
2358:
2359: begin
2360: g_debug := hr_utility.debug_enabled; -- get debug status
2361: IF g_debug THEN
2362: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2363: END IF;
2364:

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

2358:
2359: begin
2360: g_debug := hr_utility.debug_enabled; -- get debug status
2361: IF g_debug THEN
2362: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2363: END IF;
2364:
2365: -- ER FPT
2366: open future_exists;

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

2382: close future_exists;
2383: -- ER FPT
2384:
2385: IF g_debug THEN
2386: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
2387: END IF;
2388:
2389: end;
2390: --

Line 2429: g_debug := hr_utility.debug_enabled; -- get debug status

2425: --
2426:
2427: Begin
2428:
2429: g_debug := hr_utility.debug_enabled; -- get debug status
2430: IF g_debug THEN
2431: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2432: END IF;
2433:

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

2427: Begin
2428:
2429: g_debug := hr_utility.debug_enabled; -- get debug status
2430: IF g_debug THEN
2431: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2432: END IF;
2433:
2434:
2435: if p_current_application_id = 810

Line 2448: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);

2444: close get_future_changes;
2445: else
2446:
2447: IF g_debug THEN
2448: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
2449: END IF;
2450:
2451: open check_person;
2452: fetch check_person into l_dummy;

Line 2465: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);

2461: if p_hire_date > p_s_hire_date
2462: then
2463:
2464: IF g_debug THEN
2465: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);
2466: END IF;
2467:
2468: open check_assignment_changes;
2469: loop

Line 2479: hr_utility.set_location('Leaving: '|| g_package || l_proc, 30);

2475: close check_assignment_changes;
2476: end if;
2477:
2478: IF g_debug THEN
2479: hr_utility.set_location('Leaving: '|| g_package || l_proc, 30);
2480: END IF;
2481:
2482:
2483: end check_person_changes;