[Home] [Help]
487: l_proc_name constant varchar2(150) := g_pkg||'Default_Person_Rec';
488: l_per_rec per_all_people_f%rowtype;
489: begin
490:
491: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
492: /*
493: ==========================================================================
494: g_varchar2 constant varchar2(9) := '$Sys_Def$';
495: g_number constant number := -987123654;
501: --l_per_rec.benefit_group_id := hr_api.g_number;
502: l_per_rec.party_id := hr_api.g_number;
503: l_per_rec.comment_id := hr_api.g_number;
504:
505: Hr_Utility.set_location(l_proc_name, 6);
506:
507: --l_per_rec.date_employee_data_verified := hr_api.g_date;
508: --l_per_rec.date_of_birth := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
533: l_per_rec.sex := hr_api.g_varchar2;
534: l_per_rec.title := hr_api.g_varchar2;
535: l_per_rec.work_telephone := hr_api.g_varchar2;
536:
537: Hr_Utility.set_location(l_proc_name, 7);
538:
539: l_per_rec.attribute_category := hr_api.g_varchar2;
540: l_per_rec.attribute1 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
568: l_per_rec.attribute29 := hr_api.g_varchar2;
569: l_per_rec.attribute30 := hr_api.g_varchar2;
570:
571: Hr_Utility.set_location(l_proc_name, 8);
572:
573: l_per_rec.per_information_category := hr_api.g_varchar2;
574: l_per_rec.per_information1 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
602: l_per_rec.per_information29 := hr_api.g_varchar2;
603: l_per_rec.per_information30 := hr_api.g_varchar2;
604:
605: Hr_Utility.set_location(l_proc_name, 9);
606:
607: l_per_rec.background_check_status := hr_api.g_varchar2;
608: l_per_rec.blood_type := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
637: l_per_rec.global_person_id := hr_api.g_varchar2;
638: l_per_rec.npw_number := hr_api.g_varchar2;
639:
640: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
641: return l_per_rec;
642: exception
643: when others then
644: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
640: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
641: return l_per_rec;
642: exception
643: when others then
644: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
645: raise;
646:
647: end Default_Person_Rec;
648: -- =============================================================================
670: col_name varchar2(150);
671: l_proc_name constant varchar2(150) := g_pkg||'Default_Person_Rec';
672: begin
673:
674: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
675:
676: l_per_rec := Default_Person_Rec;
677:
678: for col_rec in bne_cols (g_interface_code)
803: when 'attribute_category' then
804: l_per_rec.attribute_category := g_per_rec.attribute_category;
805: if l_per_rec.attribute_category is not null then
806: for col_rec1 in bne_cols_no_disp(g_interface_code) loop
807: --hr_utility.trace('$$UPD: attribute_category columns: '|| col_rec1.interface_col_name);
808: case col_rec1.interface_col_name
809: when 'attribute1' then
810: l_per_rec.attribute1 := g_per_rec.attribute1;
811: when 'attribute2' then
875: -- Person Legislative DDF
876: when 'per_information_category' then
877: l_per_rec.per_information_category := g_per_rec.per_information_category;
878: if l_per_rec.per_information_category is not null then
879: --hr_utility.trace('$$UPD: Inside per_information_category: '||l_per_rec.per_information_category);
880: for col_rec1 in bne_cols_no_disp(g_interface_code) loop
881: --hr_utility.trace('$$UPD: per_information_category Columns: '||col_rec1.interface_col_name);
882: case col_rec1.interface_col_name
883: when 'per_information1' then
877: l_per_rec.per_information_category := g_per_rec.per_information_category;
878: if l_per_rec.per_information_category is not null then
879: --hr_utility.trace('$$UPD: Inside per_information_category: '||l_per_rec.per_information_category);
880: for col_rec1 in bne_cols_no_disp(g_interface_code) loop
881: --hr_utility.trace('$$UPD: per_information_category Columns: '||col_rec1.interface_col_name);
882: case col_rec1.interface_col_name
883: when 'per_information1' then
884: l_per_rec.per_information1 := g_per_rec.per_information1;
885: when 'per_information2' then
948: else
949: null;
950: end case;
951: end loop;
952: Hr_Utility.set_location(' Leaving: '||l_proc_name, 80);
953: return l_per_rec;
954:
955: end Get_PerRecord_Values;
956: -- =============================================================================
960: return per_all_assignments_f%rowtype is
961: l_proc_name constant varchar2(150) := g_pkg||'Default_Assignment_Rec';
962: l_asg_rec per_all_assignments_f%rowtype;
963: begin
964: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
965: /*
966: ======================================================================
967: g_varchar2 constant varchar2(9):= '$Sys_Def$';
968: g_number constant number := -987123654;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
985: l_asg_rec.people_group_id := hr_api.g_number;
986: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
987:
988: Hr_Utility.set_location(l_proc_name, 10);
989:
990: l_asg_rec.supervisor_id := hr_api.g_number;
991: l_asg_rec.assignment_number := hr_api.g_varchar2;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1011: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1012: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1013:
1014: Hr_Utility.set_location(l_proc_name, 15);
1015:
1016: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1017: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1047:
1048: Hr_Utility.set_location(l_proc_name, 20);
1049:
1050: l_asg_rec.title := hr_api.g_varchar2;
1051: l_asg_rec.contract_id := hr_api.g_number;
1052: l_asg_rec.establishment_id := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1056: l_asg_rec.employee_category := hr_api.g_varchar2;
1057: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1058:
1059: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1060: return l_asg_rec;
1061: exception
1062: when others then
1063: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1059: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1060: return l_asg_rec;
1061: exception
1062: when others then
1063: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1064: raise;
1065:
1066: end Default_Assignment_Rec;
1067: -- =============================================================================
1088: l_asg_rec per_all_assignments_f%rowtype;
1089: col_name varchar2(150);
1090:
1091: begin
1092: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1093: --$ check if secondary assignment is to be created
1094: -- If yes (i.e. flag is set to 1 ) then initialize to null else to hr_api variable
1095: -- type
1096: if g_sec_asg_flag <> 1 then
1181: when 'p_location_id' then
1182: l_asg_rec.location_id := g_asg_rec.location_id;
1183: -- Assignment User Defined DF
1184: when 'ass_attribute_category' then
1185: -- hr_utility.trace('IN GET_ASGRECORD_VALUES, when ass_att_cat');
1186: l_asg_rec.ass_attribute_category := g_asg_rec.ass_attribute_category;
1187: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute_cat='||l_asg_rec.ass_attribute_category);
1188: if l_asg_rec.ass_attribute_category is not null then
1189: --hr_utility.trace('IN GET_ASGRECORD_VALUES intfcolname'|| col_rec.interface_col_name);
1183: -- Assignment User Defined DF
1184: when 'ass_attribute_category' then
1185: -- hr_utility.trace('IN GET_ASGRECORD_VALUES, when ass_att_cat');
1186: l_asg_rec.ass_attribute_category := g_asg_rec.ass_attribute_category;
1187: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute_cat='||l_asg_rec.ass_attribute_category);
1188: if l_asg_rec.ass_attribute_category is not null then
1189: --hr_utility.trace('IN GET_ASGRECORD_VALUES intfcolname'|| col_rec.interface_col_name);
1190:
1191: -- Added by Dbansal -> Another nested loop to set the values of DFF segments
1185: -- hr_utility.trace('IN GET_ASGRECORD_VALUES, when ass_att_cat');
1186: l_asg_rec.ass_attribute_category := g_asg_rec.ass_attribute_category;
1187: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute_cat='||l_asg_rec.ass_attribute_category);
1188: if l_asg_rec.ass_attribute_category is not null then
1189: --hr_utility.trace('IN GET_ASGRECORD_VALUES intfcolname'|| col_rec.interface_col_name);
1190:
1191: -- Added by Dbansal -> Another nested loop to set the values of DFF segments
1192: for col_rec1 in bne_cols_no_disp(g_interface_code) loop
1193: -- hr_utility.trace('IN GET_ASGRECORD_VALUES Nested:'|| col_rec1.interface_col_name);
1189: --hr_utility.trace('IN GET_ASGRECORD_VALUES intfcolname'|| col_rec.interface_col_name);
1190:
1191: -- Added by Dbansal -> Another nested loop to set the values of DFF segments
1192: for col_rec1 in bne_cols_no_disp(g_interface_code) loop
1193: -- hr_utility.trace('IN GET_ASGRECORD_VALUES Nested:'|| col_rec1.interface_col_name);
1194: case col_rec1.interface_col_name
1195: when 'ass_attribute1' then
1196: l_asg_rec.ass_attribute1 := g_asg_rec.ass_attribute1;
1197: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute1='||l_asg_rec.ass_attribute1);
1193: -- hr_utility.trace('IN GET_ASGRECORD_VALUES Nested:'|| col_rec1.interface_col_name);
1194: case col_rec1.interface_col_name
1195: when 'ass_attribute1' then
1196: l_asg_rec.ass_attribute1 := g_asg_rec.ass_attribute1;
1197: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute1='||l_asg_rec.ass_attribute1);
1198: when 'ass_attribute2' then
1199: l_asg_rec.ass_attribute2 := g_asg_rec.ass_attribute2;
1200: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute2='||l_asg_rec.ass_attribute2);
1201: when 'ass_attribute3' then
1196: l_asg_rec.ass_attribute1 := g_asg_rec.ass_attribute1;
1197: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute1='||l_asg_rec.ass_attribute1);
1198: when 'ass_attribute2' then
1199: l_asg_rec.ass_attribute2 := g_asg_rec.ass_attribute2;
1200: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute2='||l_asg_rec.ass_attribute2);
1201: when 'ass_attribute3' then
1202: l_asg_rec.ass_attribute3 := g_asg_rec.ass_attribute3;
1203: when 'ass_attribute4' then
1204: l_asg_rec.ass_attribute4 := g_asg_rec.ass_attribute4;
1213: when 'ass_attribute9' then
1214: l_asg_rec.ass_attribute9 := g_asg_rec.ass_attribute9;
1215: when 'ass_attribute10' then
1216: l_asg_rec.ass_attribute10 := g_asg_rec.ass_attribute10;
1217: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute10='||l_asg_rec.ass_attribute10);
1218: when 'ass_attribute11' then
1219: l_asg_rec.ass_attribute11 := g_asg_rec.ass_attribute11;
1220: when 'ass_attribute12' then
1221: l_asg_rec.ass_attribute12 := g_asg_rec.ass_attribute12;
1218: when 'ass_attribute11' then
1219: l_asg_rec.ass_attribute11 := g_asg_rec.ass_attribute11;
1220: when 'ass_attribute12' then
1221: l_asg_rec.ass_attribute12 := g_asg_rec.ass_attribute12;
1222: --hr_utility.trace('IN GET_ASGRECORD_VALUES ass_attribute12='||l_asg_rec.ass_attribute12);
1223: when 'ass_attribute13' then
1224: l_asg_rec.ass_attribute13 := g_asg_rec.ass_attribute13;
1225: when 'ass_attribute14' then
1226: l_asg_rec.ass_attribute14 := g_asg_rec.ass_attribute14;
1266: end case;
1267: end loop;
1268:
1269: return l_Asg_rec;
1270: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1271: exception
1272: when others then
1273: Hr_Utility.set_location('Error Leaving: '||l_proc_name, 90);
1274: raise;
1269: return l_Asg_rec;
1270: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1271: exception
1272: when others then
1273: Hr_Utility.set_location('Error Leaving: '||l_proc_name, 90);
1274: raise;
1275:
1276: end Get_AsgRecord_Values;
1277:
1282: return pay_people_groups%rowtype is
1283: l_proc_name constant varchar2(150) := g_pkg||'Default_PpgFlx_Rec';
1284: l_grp_rec pay_people_groups%rowtype;
1285: begin
1286: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1287: /*
1288: ======================================================================
1289: hr_api defaults:
1290: g_varchar2 constant varchar2(9):= '$Sys_Def$';
1293: ======================================================================
1294: */
1295: l_grp_rec.group_name := hr_api.g_varchar2;
1296:
1297: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1298:
1299: l_grp_rec.segment1 := hr_api.g_varchar2;
1300: l_grp_rec.segment2 := hr_api.g_varchar2;
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1329: l_grp_rec.segment29 := hr_api.g_varchar2;
1330: l_grp_rec.segment30 := hr_api.g_varchar2;
1331:
1332: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1333: return l_grp_rec;
1334:
1335: exception
1336: when others then
1334:
1335: exception
1336: when others then
1337: if g_debug then
1338: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1339: end if;
1340: raise;
1341:
1342: end Default_PpgFlx_Rec;
1359: l_grp_rec pay_people_groups%rowtype;
1360: col_name varchar2(150);
1361:
1362: begin
1363: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1364: l_grp_rec := Default_PpgFlx_Rec;
1365: for col_rec in bne_cols (g_interface_code)
1366: loop
1367: --$ Assign global values to the People Group segments
1431: else
1432: null;
1433: end case;
1434: end loop;
1435: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1436: return l_grp_rec;
1437:
1438: exception
1439: when others then
1436: return l_grp_rec;
1437:
1438: exception
1439: when others then
1440: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1441: raise;
1442:
1443: end Get_GrpRecord_Values;
1444:
1449: return hr_soft_coding_keyflex%rowtype is
1450: l_proc_name constant varchar2(150) := g_pkg||'Default_Scflx_Rec';
1451: l_scl_rec hr_soft_coding_keyflex%rowtype;
1452: begin
1453: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1454: /*
1455: ======================================================================
1456: g_varchar2 constant varchar2(9):= '$Sys_Def$';
1457: g_number constant number := -987123654;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1492: l_scl_rec.segment29 := hr_api.g_varchar2;
1493: l_scl_rec.segment30 := hr_api.g_varchar2;
1494:
1495: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1496: return l_scl_rec;
1497: exception
1498: when others then
1499: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1495: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1496: return l_scl_rec;
1497: exception
1498: when others then
1499: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1500: raise;
1501:
1502: end Default_Scflx_Rec;
1503:
1523: l_scl_rec hr_soft_coding_keyflex%rowtype;
1524: col_name varchar2(150);
1525:
1526: begin
1527: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1528: l_scl_rec := Default_Scflx_Rec;
1529:
1530: for col_rec in bne_cols (g_interface_code)
1531: loop
1623: null;
1624: end case;
1625:
1626: end loop;
1627: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1628: return l_scl_rec;
1629:
1630: exception
1631: when others then
1628: return l_scl_rec;
1629:
1630: exception
1631: when others then
1632: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1633: raise;
1634:
1635: end Get_ScflxRecord_Values;
1636: -- =============================================================================
1651: l_dyn_sql_qry varchar2(1000);
1652: l_national_identifier per_all_people_f.national_identifier%type;
1653:
1654: begin
1655: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1656:
1657: if p_web_adi_identifier = 'DP ERROR' and
1658: (substrb(p_national_identifier, 1,
1659: lengthb(p_national_identifier) - 4) = 'XXX-XX-' or
1677: else
1678: l_national_identifier := p_national_identifier;
1679: end if;
1680: if g_debug then
1681: Hr_Utility.set_location(' p_batch_id: '||p_batch_id, 50);
1682: Hr_Utility.set_location(' p_data_pump_batch_line_id: '||p_data_pump_batch_line_id, 50);
1683: Hr_Utility.set_location(' p_web_adi_identifier: '||p_web_adi_identifier, 50);
1684: Hr_Utility.set_location(' l_national_identifier: '||l_national_identifier, 50);
1685: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1678: l_national_identifier := p_national_identifier;
1679: end if;
1680: if g_debug then
1681: Hr_Utility.set_location(' p_batch_id: '||p_batch_id, 50);
1682: Hr_Utility.set_location(' p_data_pump_batch_line_id: '||p_data_pump_batch_line_id, 50);
1683: Hr_Utility.set_location(' p_web_adi_identifier: '||p_web_adi_identifier, 50);
1684: Hr_Utility.set_location(' l_national_identifier: '||l_national_identifier, 50);
1685: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1686: end if;
1679: end if;
1680: if g_debug then
1681: Hr_Utility.set_location(' p_batch_id: '||p_batch_id, 50);
1682: Hr_Utility.set_location(' p_data_pump_batch_line_id: '||p_data_pump_batch_line_id, 50);
1683: Hr_Utility.set_location(' p_web_adi_identifier: '||p_web_adi_identifier, 50);
1684: Hr_Utility.set_location(' l_national_identifier: '||l_national_identifier, 50);
1685: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1686: end if;
1687: return l_national_identifier;
1680: if g_debug then
1681: Hr_Utility.set_location(' p_batch_id: '||p_batch_id, 50);
1682: Hr_Utility.set_location(' p_data_pump_batch_line_id: '||p_data_pump_batch_line_id, 50);
1683: Hr_Utility.set_location(' p_web_adi_identifier: '||p_web_adi_identifier, 50);
1684: Hr_Utility.set_location(' l_national_identifier: '||l_national_identifier, 50);
1685: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1686: end if;
1687: return l_national_identifier;
1688:
1681: Hr_Utility.set_location(' p_batch_id: '||p_batch_id, 50);
1682: Hr_Utility.set_location(' p_data_pump_batch_line_id: '||p_data_pump_batch_line_id, 50);
1683: Hr_Utility.set_location(' p_web_adi_identifier: '||p_web_adi_identifier, 50);
1684: Hr_Utility.set_location(' l_national_identifier: '||l_national_identifier, 50);
1685: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1686: end if;
1687: return l_national_identifier;
1688:
1689: end Get_UnMasked_NI;
1741: l_person_id per_all_people_f.person_id%type;
1742:
1743: l_proc_name constant varchar2(150) := g_pkg||'Chk_NI_Exists';
1744: begin
1745: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1746:
1747: --$ If national identifier is available (for US legislation for e.g.)
1748: -- then use it to check if the person record exists or not
1749: -- else use Combination of person details to check the same
1748: -- then use it to check if the person record exists or not
1749: -- else use Combination of person details to check the same
1750: if p_national_identifier is not null then
1751:
1752: --hr_utility.trace('NATIONAL IDENTIFIER AVAILABLE');
1753:
1754: open csr_chk_ni_exists(c_national_identifier => p_national_identifier
1755: ,c_business_group_id => p_business_group_id
1756: ,c_effective_date => p_effective_date);
1756: ,c_effective_date => p_effective_date);
1757:
1758: fetch csr_chk_ni_exists into l_per_rec;
1759: if csr_chk_ni_exists%found then
1760: --hr_utility.trace('PERSON EXISTS');
1761: g_per_rec.person_id := l_per_rec.person_id;
1762: g_per_rec.business_group_id := l_per_rec.business_group_id;
1763: --g_per_rec.employee_number := l_per_rec.employee_number;
1764: --g_per_rec.applicant_number := l_per_rec.applicant_number;
1772: l_person_id := g_per_rec.person_id;
1773: end if;
1774: close csr_chk_ni_exists;
1775: else
1776: --hr_utility.trace('NATIONAL IDENTIFIER NOT AVAILABLE: USE PERSON DETAILS for UNIQUENESS');
1777: open csr_chk_per_exists (c_business_group_id => p_business_group_id
1778: ,c_effective_date => p_effective_date);
1779: fetch csr_chk_per_exists into l_per_exists;
1780: if csr_chk_per_exists%found then
1778: ,c_effective_date => p_effective_date);
1779: fetch csr_chk_per_exists into l_per_exists;
1780: if csr_chk_per_exists%found then
1781:
1782: --hr_utility.trace('PERSON EXISTS');
1783: g_per_rec.person_id := l_per_exists.person_id;
1784: g_per_rec.business_group_id := l_per_exists.business_group_id;
1785: --g_per_rec.employee_number := l_per_rec.employee_number;
1786: --g_per_rec.applicant_number := l_per_rec.applicant_number;
1795: end if;
1796: close csr_chk_per_exists;
1797: end if;
1798:
1799: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1800: return l_person_id ; --$ l_per_rec.person_id;
1801:
1802: end Chk_NI_Exists;
1803: -- =============================================================================
1813: l_job_name per_jobs.name%type;
1814: l_position_name hr_all_positions_f.name%type;
1815: l_grade_name per_grades.name%type;
1816: begin
1817: hr_utility.set_location('Entering: ' || l_proc_name, 5);
1818: g_wstr_names := null;
1819: -- Get grade name
1820: open csr_grade(g_asg_rec.grade_id
1821: ,g_asg_rec.business_group_id
1821: ,g_asg_rec.business_group_id
1822: ,g_per_rec.start_date);
1823: fetch csr_grade into l_grade_name;
1824: if csr_grade%notfound then
1825: hr_utility.set_location('..Grade Name not found Id: ' ||
1826: g_asg_rec.grade_id, 6);
1827: else
1828: g_wstr_names.grade_name := l_grade_name;
1829: end if;
1833: ,g_asg_rec.business_group_id
1834: ,g_per_rec.start_date);
1835: fetch csr_position into l_position_name;
1836: if csr_position%notfound then
1837: hr_utility.set_location('..Position Name not found Id: ' ||
1838: g_asg_rec.position_id, 7);
1839: else
1840: g_wstr_names.position_name := l_position_name;
1841: end if;
1845: ,g_asg_rec.business_group_id
1846: ,g_per_rec.start_date);
1847: fetch csr_job into l_job_name;
1848: if csr_job%notfound then
1849: hr_utility.set_location('..Job Name not found Id: ' ||
1850: g_asg_rec.job_id, 8);
1851: else
1852: g_wstr_names.job_name := l_job_name;
1853: end if;
1857: ,g_asg_rec.business_group_id
1858: ,g_per_rec.start_date);
1859: fetch csr_payroll into l_payroll_name;
1860: if csr_payroll%notfound then
1861: hr_utility.set_location('..Payroll Name not found Id: ' ||
1862: g_asg_rec.payroll_id, 9);
1863: else
1864: g_wstr_names.payroll_name := l_payroll_name;
1865: end if;
1868: open csr_location(g_asg_rec.location_id
1869: ,g_asg_rec.business_group_id);
1870: fetch csr_location into l_location_code;
1871: if csr_location%notfound then
1872: hr_utility.set_location('..Location Code not found, Id: ' ||
1873: g_asg_rec.location_id, 10);
1874: else
1875: g_wstr_names.location_code := l_location_code;
1876: end if;
1880: ,g_asg_rec.business_group_id
1881: ,g_per_rec.start_date);
1882: fetch csr_organization into l_organization_name;
1883: if csr_organization%notfound then
1884: hr_utility.set_location('..Org Name not found, Id: ' ||
1885: g_asg_rec.organization_id, 11);
1886: else
1887: g_wstr_names.organization_name := l_organization_name;
1888: end if;
1891: open csr_paybasis(g_asg_rec.pay_basis_id
1892: ,g_asg_rec.business_group_id);
1893: fetch csr_paybasis into l_pay_basis_name;
1894: if csr_paybasis%notfound then
1895: hr_utility.set_location('..Org Name not found, Id: ' ||
1896: g_asg_rec.pay_basis_id, 12);
1897: else
1898: g_wstr_names.pay_basis_name := l_pay_basis_name;
1899: end if;
1898: g_wstr_names.pay_basis_name := l_pay_basis_name;
1899: end if;
1900: close csr_paybasis;
1901:
1902: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
1903:
1904: end Get_WrkStrs_Names;
1905: -- =============================================================================
1906: -- ~ EmpAplCwk_NumGen:
1911: ,p_cwk_number in varchar2
1912: ) is
1913: l_proc_name constant varchar2(150):= g_pkg ||'EmpAplCwk_NumGen';
1914: begin
1915: hr_utility.set_location('Entering: ' || l_proc_name, 5);
1916: if g_emp_num_gen <> 'A' then
1917: g_per_rec.employee_number := p_employee_number;
1918: else
1919: g_per_rec.employee_number := null;
1930: else
1931: g_per_rec.npw_number := null;
1932: end if;
1933: if g_debug then
1934: hr_utility.set_location(' p_employee_number : ' || p_employee_number, 6);
1935: hr_utility.set_location(' p_applicant_number: ' || p_applicant_number, 6);
1936: hr_utility.set_location(' p_cwk_number : ' || p_cwk_number, 6);
1937: hr_utility.set_location(' g_emp_num_gen: ' || g_emp_num_gen, 6);
1938: hr_utility.set_location(' g_apl_num_gen: ' || g_apl_num_gen, 6);
1931: g_per_rec.npw_number := null;
1932: end if;
1933: if g_debug then
1934: hr_utility.set_location(' p_employee_number : ' || p_employee_number, 6);
1935: hr_utility.set_location(' p_applicant_number: ' || p_applicant_number, 6);
1936: hr_utility.set_location(' p_cwk_number : ' || p_cwk_number, 6);
1937: hr_utility.set_location(' g_emp_num_gen: ' || g_emp_num_gen, 6);
1938: hr_utility.set_location(' g_apl_num_gen: ' || g_apl_num_gen, 6);
1939: hr_utility.set_location(' g_cwk_num_gen: ' || p_cwk_number, 6);
1932: end if;
1933: if g_debug then
1934: hr_utility.set_location(' p_employee_number : ' || p_employee_number, 6);
1935: hr_utility.set_location(' p_applicant_number: ' || p_applicant_number, 6);
1936: hr_utility.set_location(' p_cwk_number : ' || p_cwk_number, 6);
1937: hr_utility.set_location(' g_emp_num_gen: ' || g_emp_num_gen, 6);
1938: hr_utility.set_location(' g_apl_num_gen: ' || g_apl_num_gen, 6);
1939: hr_utility.set_location(' g_cwk_num_gen: ' || p_cwk_number, 6);
1940: end if;
1933: if g_debug then
1934: hr_utility.set_location(' p_employee_number : ' || p_employee_number, 6);
1935: hr_utility.set_location(' p_applicant_number: ' || p_applicant_number, 6);
1936: hr_utility.set_location(' p_cwk_number : ' || p_cwk_number, 6);
1937: hr_utility.set_location(' g_emp_num_gen: ' || g_emp_num_gen, 6);
1938: hr_utility.set_location(' g_apl_num_gen: ' || g_apl_num_gen, 6);
1939: hr_utility.set_location(' g_cwk_num_gen: ' || p_cwk_number, 6);
1940: end if;
1941:
1934: hr_utility.set_location(' p_employee_number : ' || p_employee_number, 6);
1935: hr_utility.set_location(' p_applicant_number: ' || p_applicant_number, 6);
1936: hr_utility.set_location(' p_cwk_number : ' || p_cwk_number, 6);
1937: hr_utility.set_location(' g_emp_num_gen: ' || g_emp_num_gen, 6);
1938: hr_utility.set_location(' g_apl_num_gen: ' || g_apl_num_gen, 6);
1939: hr_utility.set_location(' g_cwk_num_gen: ' || p_cwk_number, 6);
1940: end if;
1941:
1942: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
1935: hr_utility.set_location(' p_applicant_number: ' || p_applicant_number, 6);
1936: hr_utility.set_location(' p_cwk_number : ' || p_cwk_number, 6);
1937: hr_utility.set_location(' g_emp_num_gen: ' || g_emp_num_gen, 6);
1938: hr_utility.set_location(' g_apl_num_gen: ' || g_apl_num_gen, 6);
1939: hr_utility.set_location(' g_cwk_num_gen: ' || p_cwk_number, 6);
1940: end if;
1941:
1942: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
1943: end EmpAplCwk_NumGen;
1938: hr_utility.set_location(' g_apl_num_gen: ' || g_apl_num_gen, 6);
1939: hr_utility.set_location(' g_cwk_num_gen: ' || p_cwk_number, 6);
1940: end if;
1941:
1942: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
1943: end EmpAplCwk_NumGen;
1944: -- =============================================================================
1945: -- ~ Get_DataTrack_Mode:
1946: -- =============================================================================
1957: l_error_msg varchar2(2000);
1958: l_proc_name constant varchar2(150):= g_pkg ||'Get_DataTrack_Mode';
1959: e_future_chgs_exists exception;
1960: begin
1961: hr_utility.set_location('Entering: ' || l_proc_name, 5);
1962: if g_per_rec.person_id is not null then
1963: open csr_per(c_person_id => g_per_rec.person_id
1964: ,c_business_group_id => g_per_rec.business_group_id
1965: ,c_effective_date => g_per_rec.start_date);
1964: ,c_business_group_id => g_per_rec.business_group_id
1965: ,c_effective_date => g_per_rec.start_date);
1966: fetch csr_per into l_cur_per_rec;
1967: close csr_per;
1968: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
1969:
1970: Dt_Api.Find_DT_Upd_Modes
1971: (p_effective_date => g_per_rec.start_date
1972: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
2000: else
2001: l_datetrack_update_mode := 'CORRECTION';
2002: end if;
2003:
2004: hr_utility.set_location('l_datetrack_update_mode: ' ||
2005: l_datetrack_update_mode, 30);
2006: g_per_rec.object_version_number := l_cur_per_rec.object_version_number;
2007: EmpAplCwk_NumGen
2008: (p_employee_number => nvl(l_cur_per_rec.employee_number,
2012: ,p_cwk_number => nvl(l_cur_per_rec.npw_number,
2013: g_per_rec.npw_number)
2014: );
2015: end if;
2016: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
2017: exception
2018: when e_future_chgs_exists then
2019: l_error_msg :=
2020: 'This person cannot be created/updated in HRMS as the '||
2019: l_error_msg :=
2020: 'This person cannot be created/updated in HRMS as the '||
2021: 'Person has future changes beyond the date: '||g_per_rec.start_date;
2022:
2023: hr_utility.set_location('..Future Update exists for the Student Employee', 90);
2024: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2025: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2026: hr_utility.raise_error;
2027:
2020: 'This person cannot be created/updated in HRMS as the '||
2021: 'Person has future changes beyond the date: '||g_per_rec.start_date;
2022:
2023: hr_utility.set_location('..Future Update exists for the Student Employee', 90);
2024: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2025: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2026: hr_utility.raise_error;
2027:
2028: end Get_DataTrack_Mode;
2021: 'Person has future changes beyond the date: '||g_per_rec.start_date;
2022:
2023: hr_utility.set_location('..Future Update exists for the Student Employee', 90);
2024: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2025: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2026: hr_utility.raise_error;
2027:
2028: end Get_DataTrack_Mode;
2029: -- =============================================================================
2022:
2023: hr_utility.set_location('..Future Update exists for the Student Employee', 90);
2024: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2025: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2026: hr_utility.raise_error;
2027:
2028: end Get_DataTrack_Mode;
2029: -- =============================================================================
2030: -- Chk_Person_InHR:
2092: l_user_person_type per_person_types.user_person_type%TYPE;
2093: l_effective_date date;
2094: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';
2095: begin
2096: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2097: --hr_utility.trace('Inside Chk_Person_InHR');
2098:
2099: open csr_type(g_per_rec.person_type_id);
2100: fetch csr_type into l_pty_rec;
2093: l_effective_date date;
2094: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';
2095: begin
2096: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2097: --hr_utility.trace('Inside Chk_Person_InHR');
2098:
2099: open csr_type(g_per_rec.person_type_id);
2100: fetch csr_type into l_pty_rec;
2101: close csr_type;
2210:
2211: end loop;
2212: end if;
2213:
2214: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2215:
2216: exception
2217: when e_InValid_PerType_Id then
2218: hr_utility.set_message(8303, 'PQP_230492_RIW_INVAL_PER_TYPE');
2214: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2215:
2216: exception
2217: when e_InValid_PerType_Id then
2218: hr_utility.set_message(8303, 'PQP_230492_RIW_INVAL_PER_TYPE');
2219: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2220: hr_utility.raise_error;
2221:
2222: when e_active_empcwk then
2215:
2216: exception
2217: when e_InValid_PerType_Id then
2218: hr_utility.set_message(8303, 'PQP_230492_RIW_INVAL_PER_TYPE');
2219: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2220: hr_utility.raise_error;
2221:
2222: when e_active_empcwk then
2223: hr_utility.set_message(8303, 'PQP_230493_RIW_PERSON_EXISTS');
2216: exception
2217: when e_InValid_PerType_Id then
2218: hr_utility.set_message(8303, 'PQP_230492_RIW_INVAL_PER_TYPE');
2219: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2220: hr_utility.raise_error;
2221:
2222: when e_active_empcwk then
2223: hr_utility.set_message(8303, 'PQP_230493_RIW_PERSON_EXISTS');
2224: hr_utility.set_message_token('TOKEN1',l_user_person_type );
2219: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2220: hr_utility.raise_error;
2221:
2222: when e_active_empcwk then
2223: hr_utility.set_message(8303, 'PQP_230493_RIW_PERSON_EXISTS');
2224: hr_utility.set_message_token('TOKEN1',l_user_person_type );
2225: hr_utility.set_message_token('TOKEN2',l_effective_date );
2226: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2227: hr_utility.raise_error;
2220: hr_utility.raise_error;
2221:
2222: when e_active_empcwk then
2223: hr_utility.set_message(8303, 'PQP_230493_RIW_PERSON_EXISTS');
2224: hr_utility.set_message_token('TOKEN1',l_user_person_type );
2225: hr_utility.set_message_token('TOKEN2',l_effective_date );
2226: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2227: hr_utility.raise_error;
2228:
2221:
2222: when e_active_empcwk then
2223: hr_utility.set_message(8303, 'PQP_230493_RIW_PERSON_EXISTS');
2224: hr_utility.set_message_token('TOKEN1',l_user_person_type );
2225: hr_utility.set_message_token('TOKEN2',l_effective_date );
2226: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2227: hr_utility.raise_error;
2228:
2229: when e_active_apl then
2222: when e_active_empcwk then
2223: hr_utility.set_message(8303, 'PQP_230493_RIW_PERSON_EXISTS');
2224: hr_utility.set_message_token('TOKEN1',l_user_person_type );
2225: hr_utility.set_message_token('TOKEN2',l_effective_date );
2226: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2227: hr_utility.raise_error;
2228:
2229: when e_active_apl then
2230: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2223: hr_utility.set_message(8303, 'PQP_230493_RIW_PERSON_EXISTS');
2224: hr_utility.set_message_token('TOKEN1',l_user_person_type );
2225: hr_utility.set_message_token('TOKEN2',l_effective_date );
2226: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2227: hr_utility.raise_error;
2228:
2229: when e_active_apl then
2230: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2231: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2226: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2227: hr_utility.raise_error;
2228:
2229: when e_active_apl then
2230: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2231: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2232: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2233: hr_utility.raise_error;
2234:
2227: hr_utility.raise_error;
2228:
2229: when e_active_apl then
2230: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2231: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2232: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2233: hr_utility.raise_error;
2234:
2235: when Others then
2228:
2229: when e_active_apl then
2230: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2231: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2232: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2233: hr_utility.raise_error;
2234:
2235: when Others then
2236: hr_utility.set_location('SQLERRM[CODE] :' || SQLCODE,90);
2229: when e_active_apl then
2230: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2231: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2232: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2233: hr_utility.raise_error;
2234:
2235: when Others then
2236: hr_utility.set_location('SQLERRM[CODE] :' || SQLCODE,90);
2237: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2232: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2233: hr_utility.raise_error;
2234:
2235: when Others then
2236: hr_utility.set_location('SQLERRM[CODE] :' || SQLCODE,90);
2237: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2238: raise;
2239:
2240: end Chk_Person_InHR;
2233: hr_utility.raise_error;
2234:
2235: when Others then
2236: hr_utility.set_location('SQLERRM[CODE] :' || SQLCODE,90);
2237: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2238: raise;
2239:
2240: end Chk_Person_InHR;
2241:
2290: l_grp_rec pay_people_groups%rowtype;
2291: l_scl_rec hr_soft_coding_keyflex%rowtype;
2292:
2293: begin
2294: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2295:
2296: l_asg_rec := Get_AsgRecord_Values(g_interface_code);
2297: l_grp_rec := Get_GrpRecord_Values(g_interface_code);
2298: l_scl_rec := Get_ScflxRecord_Values(g_interface_code);
2306: close csr_asg;
2307: raise e_empasg_notfound;
2308: end if;
2309: close csr_asg;
2310: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
2311: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
2312: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
2313: --
2314: -- Check is the People Group Id is passed
2307: raise e_empasg_notfound;
2308: end if;
2309: close csr_asg;
2310: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
2311: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
2312: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
2313: --
2314: -- Check is the People Group Id is passed
2315: --
2308: end if;
2309: close csr_asg;
2310: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
2311: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
2312: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
2313: --
2314: -- Check is the People Group Id is passed
2315: --
2316: open csr_ppg(c_people_grp_id => g_asg_rec.people_group_id);
2328: := l_cur_asg_rec.people_group_id;*/
2329:
2330: end if;
2331: close csr_ppg;
2332: hr_utility.set_location(' people_group_id: ' || g_asg_rec.people_group_id, 30);
2333: --
2334: -- check if the Soft-Coding KFF id is passed
2335: --
2336: open csr_scl(c_scl_kff_id => g_asg_rec.soft_coding_keyflex_id);
2348:
2349: end if;
2350:
2351: close csr_scl;
2352: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2353: g_asg_rec.soft_coding_keyflex_id, 40);
2354: --
2355: -- Get the datetrack mode based on the effective date passed
2356: --
2370: elsif l_dt_upd_override or
2371: l_upd_chg_ins then
2372: --Else USE Correction Mode
2373: l_datetrack_update_mode := 'CORRECTION';
2374: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
2375: else
2376: l_datetrack_update_mode := 'CORRECTION';
2377: end if;
2378: hr_utility.set_location(' l_datetrack_update_mode: ' ||
2374: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
2375: else
2376: l_datetrack_update_mode := 'CORRECTION';
2377: end if;
2378: hr_utility.set_location(' l_datetrack_update_mode: ' ||
2379: l_datetrack_update_mode, 60);
2380:
2381: g_asg_rec.cagr_grade_def_id := nvl(g_asg_rec.cagr_grade_def_id,
2382: l_cur_asg_rec.cagr_grade_def_id);
2550: ,p_effective_start_date => l_UpdEmpAsg_out.effective_start_date
2551: ,p_effective_end_date => l_UpdEmpAsg_out.effective_end_date
2552: );
2553:
2554: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
2555:
2556: exception
2557: when e_empasg_notfound then
2558: l_error_msg :=
2556: exception
2557: when e_empasg_notfound then
2558: l_error_msg :=
2559: 'Applicant Assignment could not be found as of the effective date';
2560: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2561: hr_utility.set_message_token('TOKEN','Applicant' );
2562: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2563: hr_utility.raise_error;
2564:
2557: when e_empasg_notfound then
2558: l_error_msg :=
2559: 'Applicant Assignment could not be found as of the effective date';
2560: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2561: hr_utility.set_message_token('TOKEN','Applicant' );
2562: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2563: hr_utility.raise_error;
2564:
2565: when Others then
2558: l_error_msg :=
2559: 'Applicant Assignment could not be found as of the effective date';
2560: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2561: hr_utility.set_message_token('TOKEN','Applicant' );
2562: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2563: hr_utility.raise_error;
2564:
2565: when Others then
2566: --l_error_msg := SQLERRM;
2559: 'Applicant Assignment could not be found as of the effective date';
2560: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2561: hr_utility.set_message_token('TOKEN','Applicant' );
2562: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2563: hr_utility.raise_error;
2564:
2565: when Others then
2566: --l_error_msg := SQLERRM;
2567: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2563: hr_utility.raise_error;
2564:
2565: when Others then
2566: --l_error_msg := SQLERRM;
2567: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2568: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2569: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2570: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2571: --hr_utility.trace('Error Text = ' ||substr(l_error_msg,1,150));
2564:
2565: when Others then
2566: --l_error_msg := SQLERRM;
2567: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2568: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2569: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2570: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2571: --hr_utility.trace('Error Text = ' ||substr(l_error_msg,1,150));
2572:
2565: when Others then
2566: --l_error_msg := SQLERRM;
2567: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2568: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2569: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2570: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2571: --hr_utility.trace('Error Text = ' ||substr(l_error_msg,1,150));
2572:
2573: hr_utility.raise_error;
2566: --l_error_msg := SQLERRM;
2567: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2568: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2569: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2570: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2571: --hr_utility.trace('Error Text = ' ||substr(l_error_msg,1,150));
2572:
2573: hr_utility.raise_error;
2574:
2567: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2568: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2569: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2570: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2571: --hr_utility.trace('Error Text = ' ||substr(l_error_msg,1,150));
2572:
2573: hr_utility.raise_error;
2574:
2575: end Upd_Applicant_Asg;
2569: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2570: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2571: --hr_utility.trace('Error Text = ' ||substr(l_error_msg,1,150));
2572:
2573: hr_utility.raise_error;
2574:
2575: end Upd_Applicant_Asg;
2576: -- =============================================================================
2577: -- ~ Upd_Contingent_Asg :
2624: l_grp_rec pay_people_groups%rowtype;
2625: l_scl_rec hr_soft_coding_keyflex%rowtype;
2626:
2627: begin
2628: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2629:
2630: l_asg_rec := Get_AsgRecord_Values(g_interface_code);
2631: l_grp_rec := Get_GrpRecord_Values(g_interface_code);
2632: l_scl_rec := Get_ScflxRecord_Values(g_interface_code);
2640: close csr_asg;
2641: raise e_empasg_notfound;
2642: end if;
2643: close csr_asg;
2644: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
2645: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
2646: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
2647: --
2648: -- Check if the People Group Id is passed
2641: raise e_empasg_notfound;
2642: end if;
2643: close csr_asg;
2644: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
2645: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
2646: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
2647: --
2648: -- Check if the People Group Id is passed
2649: --
2642: end if;
2643: close csr_asg;
2644: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
2645: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
2646: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
2647: --
2648: -- Check if the People Group Id is passed
2649: --
2650: open csr_ppg(c_people_grp_id => g_asg_rec.people_group_id);
2662: := l_cur_asg_rec.people_group_id;*/
2663: end if;
2664:
2665: close csr_ppg;
2666: hr_utility.set_location(' people_group_id: ' || g_asg_rec.people_group_id, 30);
2667: --
2668: -- check if the Soft-Coding KFF id is passed
2669: --
2670: open csr_scl(c_scl_kff_id => g_asg_rec.soft_coding_keyflex_id);
2681: := l_cur_asg_rec.soft_coding_keyflex_id; */
2682:
2683: end if;
2684: close csr_scl;
2685: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2686: g_asg_rec.soft_coding_keyflex_id, 40);
2687: --
2688: -- Get the datetrack mode based on the effective date passed
2689: --
2703: elsif l_dt_upd_override or
2704: l_upd_chg_ins then
2705: --Else USE Correction Mode
2706: l_datetrack_update_mode := 'CORRECTION';
2707: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
2708: else
2709: l_datetrack_update_mode := 'CORRECTION';
2710: end if;
2711: hr_utility.set_location(' l_datetrack_update_mode: ' ||
2707: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
2708: else
2709: l_datetrack_update_mode := 'CORRECTION';
2710: end if;
2711: hr_utility.set_location(' l_datetrack_update_mode: ' ||
2712: l_datetrack_update_mode, 60);
2713:
2714: g_asg_rec.cagr_grade_def_id := nvl(g_asg_rec.cagr_grade_def_id,
2715: l_cur_asg_rec.cagr_grade_def_id);
2775: );
2776:
2777:
2778: if g_debug then
2779: hr_utility.set_location(' people_group_id: ' ||
2780: p_asg_crit_out.people_group_id, 70);
2781: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2782: p_asg_crit_out.soft_coding_keyflex_id, 70);
2783: hr_utility.set_location(' group_name: ' ||
2777:
2778: if g_debug then
2779: hr_utility.set_location(' people_group_id: ' ||
2780: p_asg_crit_out.people_group_id, 70);
2781: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2782: p_asg_crit_out.soft_coding_keyflex_id, 70);
2783: hr_utility.set_location(' group_name: ' ||
2784: p_asg_crit_out.group_name, 70);
2785: hr_utility.set_location(' asg_effective_start_date: ' ||
2779: hr_utility.set_location(' people_group_id: ' ||
2780: p_asg_crit_out.people_group_id, 70);
2781: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2782: p_asg_crit_out.soft_coding_keyflex_id, 70);
2783: hr_utility.set_location(' group_name: ' ||
2784: p_asg_crit_out.group_name, 70);
2785: hr_utility.set_location(' asg_effective_start_date: ' ||
2786: p_asg_crit_out.asg_effective_start_date, 70);
2787: end if;
2781: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2782: p_asg_crit_out.soft_coding_keyflex_id, 70);
2783: hr_utility.set_location(' group_name: ' ||
2784: p_asg_crit_out.group_name, 70);
2785: hr_utility.set_location(' asg_effective_start_date: ' ||
2786: p_asg_crit_out.asg_effective_start_date, 70);
2787: end if;
2788: l_datetrack_update_mode := 'CORRECTION';
2789:
2787: end if;
2788: l_datetrack_update_mode := 'CORRECTION';
2789:
2790:
2791: --hr_utility.trace(' Value of l_asg_rec.assignment_id = '||l_asg_rec.assignment_id);
2792: --hr_utility.trace(' Value of g_asg_rec.assignment_id = '||g_asg_rec.assignment_id);
2793:
2794:
2795: HR_Assignment_API.Update_CWK_Asg
2788: l_datetrack_update_mode := 'CORRECTION';
2789:
2790:
2791: --hr_utility.trace(' Value of l_asg_rec.assignment_id = '||l_asg_rec.assignment_id);
2792: --hr_utility.trace(' Value of g_asg_rec.assignment_id = '||g_asg_rec.assignment_id);
2793:
2794:
2795: HR_Assignment_API.Update_CWK_Asg
2796: (p_validate => false
2902: ,p_hourly_salaried_warning => l_UpdEmpAsg_out.hourly_salaried_warning
2903: );
2904:
2905: if g_debug then
2906: hr_utility.set_location(' Asg OVN: ' ||
2907: l_cur_asg_rec.object_version_number, 75);
2908: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2909: p_asg_crit_out.soft_coding_keyflex_id, 75);
2910: hr_utility.set_location(' group_name: ' ||
2904:
2905: if g_debug then
2906: hr_utility.set_location(' Asg OVN: ' ||
2907: l_cur_asg_rec.object_version_number, 75);
2908: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2909: p_asg_crit_out.soft_coding_keyflex_id, 75);
2910: hr_utility.set_location(' group_name: ' ||
2911: l_UpdEmpAsg_out.concatenated_segments, 75);
2912: hr_utility.set_location(' asg_effective_start_date: ' ||
2906: hr_utility.set_location(' Asg OVN: ' ||
2907: l_cur_asg_rec.object_version_number, 75);
2908: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2909: p_asg_crit_out.soft_coding_keyflex_id, 75);
2910: hr_utility.set_location(' group_name: ' ||
2911: l_UpdEmpAsg_out.concatenated_segments, 75);
2912: hr_utility.set_location(' asg_effective_start_date: ' ||
2913: l_UpdEmpAsg_out.effective_start_date, 75);
2914: end if;
2908: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
2909: p_asg_crit_out.soft_coding_keyflex_id, 75);
2910: hr_utility.set_location(' group_name: ' ||
2911: l_UpdEmpAsg_out.concatenated_segments, 75);
2912: hr_utility.set_location(' asg_effective_start_date: ' ||
2913: l_UpdEmpAsg_out.effective_start_date, 75);
2914: end if;
2915:
2916: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
2912: hr_utility.set_location(' asg_effective_start_date: ' ||
2913: l_UpdEmpAsg_out.effective_start_date, 75);
2914: end if;
2915:
2916: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
2917:
2918: exception
2919: when e_empasg_notfound then
2920: l_error_msg :=
2918: exception
2919: when e_empasg_notfound then
2920: l_error_msg :=
2921: 'Contingent Assignment could not be found as of the effective date';
2922: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2923: hr_utility.set_message_token('TOKEN','Contingent' );
2924: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2925: hr_utility.raise_error;
2926:
2919: when e_empasg_notfound then
2920: l_error_msg :=
2921: 'Contingent Assignment could not be found as of the effective date';
2922: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2923: hr_utility.set_message_token('TOKEN','Contingent' );
2924: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2925: hr_utility.raise_error;
2926:
2927: when Others then
2920: l_error_msg :=
2921: 'Contingent Assignment could not be found as of the effective date';
2922: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2923: hr_utility.set_message_token('TOKEN','Contingent' );
2924: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2925: hr_utility.raise_error;
2926:
2927: when Others then
2928: --l_error_msg := SQLERRM;
2921: 'Contingent Assignment could not be found as of the effective date';
2922: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
2923: hr_utility.set_message_token('TOKEN','Contingent' );
2924: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
2925: hr_utility.raise_error;
2926:
2927: when Others then
2928: --l_error_msg := SQLERRM;
2929:
2926:
2927: when Others then
2928: --l_error_msg := SQLERRM;
2929:
2930: --hr_utility.trace(' Upd_Contingent_Asg Error = '||sqlerrm);
2931:
2932: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2933: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2934: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2928: --l_error_msg := SQLERRM;
2929:
2930: --hr_utility.trace(' Upd_Contingent_Asg Error = '||sqlerrm);
2931:
2932: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2933: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2934: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2935: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2936: hr_utility.raise_error;
2929:
2930: --hr_utility.trace(' Upd_Contingent_Asg Error = '||sqlerrm);
2931:
2932: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2933: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2934: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2935: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2936: hr_utility.raise_error;
2937:
2930: --hr_utility.trace(' Upd_Contingent_Asg Error = '||sqlerrm);
2931:
2932: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2933: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2934: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2935: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2936: hr_utility.raise_error;
2937:
2938: end Upd_Contingent_Asg;
2931:
2932: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2933: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2934: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2935: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2936: hr_utility.raise_error;
2937:
2938: end Upd_Contingent_Asg;
2939:
2932: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
2933: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2934: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
2935: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
2936: hr_utility.raise_error;
2937:
2938: end Upd_Contingent_Asg;
2939:
2940: -- =============================================================================
2987: l_asg_rec per_all_assignments_f%rowtype;
2988: l_grp_rec pay_people_groups%rowtype;
2989: l_scl_rec hr_soft_coding_keyflex%rowtype;
2990: begin
2991: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2992:
2993: l_asg_rec := Get_AsgRecord_Values(g_interface_code);
2994: l_grp_rec := Get_GrpRecord_Values(g_interface_code);
2995: l_scl_rec := Get_ScflxRecord_Values(g_interface_code);
3003: close csr_asg;
3004: raise e_empasg_notfound;
3005: end if;
3006: close csr_asg;
3007: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
3008: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
3009: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
3010:
3011: open csr_ppg(c_people_grp_id => g_asg_rec.people_group_id);
3004: raise e_empasg_notfound;
3005: end if;
3006: close csr_asg;
3007: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
3008: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
3009: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
3010:
3011: open csr_ppg(c_people_grp_id => g_asg_rec.people_group_id);
3012: fetch csr_ppg into l_cur_ppl_grp_rec;
3005: end if;
3006: close csr_asg;
3007: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
3008: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.assignment_id, 20);
3009: hr_utility.set_location(' l_cur_asg_rec: ' || g_asg_rec.business_group_id, 20);
3010:
3011: open csr_ppg(c_people_grp_id => g_asg_rec.people_group_id);
3012: fetch csr_ppg into l_cur_ppl_grp_rec;
3013: if csr_ppg%found then
3014: p_asg_crit_out.people_group_id := g_asg_rec.people_group_id;
3015: l_asg_rec.people_group_id := g_asg_rec.people_group_id;
3016: end if;
3017: close csr_ppg;
3018: hr_utility.set_location(' people_group_id: ' || g_asg_rec.people_group_id, 30);
3019:
3020: open csr_scl(c_scl_kff_id => g_asg_rec.soft_coding_keyflex_id);
3021: fetch csr_scl into l_cur_scl_rec;
3022: if csr_scl%found then
3023: p_asg_crit_out.soft_coding_keyflex_id := g_asg_rec.soft_coding_keyflex_id;
3024: l_asg_rec.soft_coding_keyflex_id := g_asg_rec.soft_coding_keyflex_id;
3025: end if;
3026: close csr_scl;
3027: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
3028: g_asg_rec.soft_coding_keyflex_id, 40);
3029:
3030: Dt_Api.Find_DT_Upd_Modes
3031: (p_effective_date => p_effective_date
3042: l_datetrack_update_mode := 'UPDATE';
3043: elsif l_dt_upd_override or
3044: l_upd_chg_ins then
3045: l_datetrack_update_mode := 'CORRECTION' ; --$ 'UPDATE' not possible
3046: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
3047: else
3048: l_datetrack_update_mode := 'CORRECTION';
3049: end if;
3050: hr_utility.set_location(' l_datetrack_update_mode: ' ||
3046: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
3047: else
3048: l_datetrack_update_mode := 'CORRECTION';
3049: end if;
3050: hr_utility.set_location(' l_datetrack_update_mode: ' ||
3051: l_datetrack_update_mode, 60);
3052:
3053: Hr_Assignment_Api.Update_Emp_Asg_Criteria
3054: (p_effective_date => p_effective_date
3115: );
3116:
3117:
3118: if g_debug then
3119: hr_utility.set_location(' people_group_id: ' ||
3120: p_asg_crit_out.people_group_id, 70);
3121: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
3122: p_asg_crit_out.soft_coding_keyflex_id, 70);
3123: hr_utility.set_location(' group_name: ' ||
3117:
3118: if g_debug then
3119: hr_utility.set_location(' people_group_id: ' ||
3120: p_asg_crit_out.people_group_id, 70);
3121: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
3122: p_asg_crit_out.soft_coding_keyflex_id, 70);
3123: hr_utility.set_location(' group_name: ' ||
3124: p_asg_crit_out.group_name, 70);
3125: hr_utility.set_location(' asg_effective_start_date: ' ||
3119: hr_utility.set_location(' people_group_id: ' ||
3120: p_asg_crit_out.people_group_id, 70);
3121: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
3122: p_asg_crit_out.soft_coding_keyflex_id, 70);
3123: hr_utility.set_location(' group_name: ' ||
3124: p_asg_crit_out.group_name, 70);
3125: hr_utility.set_location(' asg_effective_start_date: ' ||
3126: p_asg_crit_out.asg_effective_start_date, 70);
3127: end if;
3121: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
3122: p_asg_crit_out.soft_coding_keyflex_id, 70);
3123: hr_utility.set_location(' group_name: ' ||
3124: p_asg_crit_out.group_name, 70);
3125: hr_utility.set_location(' asg_effective_start_date: ' ||
3126: p_asg_crit_out.asg_effective_start_date, 70);
3127: end if;
3128:
3129: l_datetrack_update_mode := 'CORRECTION';
3133: g_asg_rec.soft_coding_keyflex_id := p_asg_crit_out.soft_coding_keyflex_id;
3134: --
3135: -- Hr_Assignment_Api.Update_Emp_Asg: Use the overloaded update_emp_asg(NEW3)
3136: --
3137: --hr_utility.trace('ass_attribute1 = ' ||l_asg_rec.ass_attribute1);
3138: --hr_utility.trace('ass_attribute2 = ' ||l_asg_rec.ass_attribute2);
3139: --hr_utility.trace('ass_attribute3 = ' ||l_asg_rec.ass_attribute3);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3134: --
3135: -- Hr_Assignment_Api.Update_Emp_Asg: Use the overloaded update_emp_asg(NEW3)
3136: --
3137: --hr_utility.trace('ass_attribute1 = ' ||l_asg_rec.ass_attribute1);
3138: --hr_utility.trace('ass_attribute2 = ' ||l_asg_rec.ass_attribute2);
3139: --hr_utility.trace('ass_attribute3 = ' ||l_asg_rec.ass_attribute3);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3135: -- Hr_Assignment_Api.Update_Emp_Asg: Use the overloaded update_emp_asg(NEW3)
3136: --
3137: --hr_utility.trace('ass_attribute1 = ' ||l_asg_rec.ass_attribute1);
3138: --hr_utility.trace('ass_attribute2 = ' ||l_asg_rec.ass_attribute2);
3139: --hr_utility.trace('ass_attribute3 = ' ||l_asg_rec.ass_attribute3);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3136: --
3137: --hr_utility.trace('ass_attribute1 = ' ||l_asg_rec.ass_attribute1);
3138: --hr_utility.trace('ass_attribute2 = ' ||l_asg_rec.ass_attribute2);
3139: --hr_utility.trace('ass_attribute3 = ' ||l_asg_rec.ass_attribute3);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3137: --hr_utility.trace('ass_attribute1 = ' ||l_asg_rec.ass_attribute1);
3138: --hr_utility.trace('ass_attribute2 = ' ||l_asg_rec.ass_attribute2);
3139: --hr_utility.trace('ass_attribute3 = ' ||l_asg_rec.ass_attribute3);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3138: --hr_utility.trace('ass_attribute2 = ' ||l_asg_rec.ass_attribute2);
3139: --hr_utility.trace('ass_attribute3 = ' ||l_asg_rec.ass_attribute3);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3139: --hr_utility.trace('ass_attribute3 = ' ||l_asg_rec.ass_attribute3);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3140: --hr_utility.trace('ass_attribute4 = ' ||l_asg_rec.ass_attribute4);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3141: --hr_utility.trace('ass_attribute5 = ' ||l_asg_rec.ass_attribute5);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3149: --hr_utility.trace('ass_attribute13 = ' ||l_asg_rec.ass_attribute13);
3142: --hr_utility.trace('ass_attribute6 = ' ||l_asg_rec.ass_attribute6);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3149: --hr_utility.trace('ass_attribute13 = ' ||l_asg_rec.ass_attribute13);
3150: --hr_utility.trace('ass_attribute14 = ' ||l_asg_rec.ass_attribute14);
3143: --hr_utility.trace('ass_attribute7 = ' ||l_asg_rec.ass_attribute7);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3149: --hr_utility.trace('ass_attribute13 = ' ||l_asg_rec.ass_attribute13);
3150: --hr_utility.trace('ass_attribute14 = ' ||l_asg_rec.ass_attribute14);
3151: --hr_utility.trace('ass_attribute15 = ' ||l_asg_rec.ass_attribute15);
3144: --hr_utility.trace('ass_attribute8 = ' ||l_asg_rec.ass_attribute8);
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3149: --hr_utility.trace('ass_attribute13 = ' ||l_asg_rec.ass_attribute13);
3150: --hr_utility.trace('ass_attribute14 = ' ||l_asg_rec.ass_attribute14);
3151: --hr_utility.trace('ass_attribute15 = ' ||l_asg_rec.ass_attribute15);
3152:
3145: --hr_utility.trace('ass_attribute9 = ' ||l_asg_rec.ass_attribute9);
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3149: --hr_utility.trace('ass_attribute13 = ' ||l_asg_rec.ass_attribute13);
3150: --hr_utility.trace('ass_attribute14 = ' ||l_asg_rec.ass_attribute14);
3151: --hr_utility.trace('ass_attribute15 = ' ||l_asg_rec.ass_attribute15);
3152:
3153: Hr_Assignment_Api.Update_Emp_Asg
3146: --hr_utility.trace('ass_attribute10 = ' ||l_asg_rec.ass_attribute10);
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3149: --hr_utility.trace('ass_attribute13 = ' ||l_asg_rec.ass_attribute13);
3150: --hr_utility.trace('ass_attribute14 = ' ||l_asg_rec.ass_attribute14);
3151: --hr_utility.trace('ass_attribute15 = ' ||l_asg_rec.ass_attribute15);
3152:
3153: Hr_Assignment_Api.Update_Emp_Asg
3154: (p_validate => false
3147: --hr_utility.trace('ass_attribute11 = ' ||l_asg_rec.ass_attribute11);
3148: --hr_utility.trace('ass_attribute12 = ' ||l_asg_rec.ass_attribute12);
3149: --hr_utility.trace('ass_attribute13 = ' ||l_asg_rec.ass_attribute13);
3150: --hr_utility.trace('ass_attribute14 = ' ||l_asg_rec.ass_attribute14);
3151: --hr_utility.trace('ass_attribute15 = ' ||l_asg_rec.ass_attribute15);
3152:
3153: Hr_Assignment_Api.Update_Emp_Asg
3154: (p_validate => false
3155: ,p_effective_date => p_effective_date
3260: ,p_hourly_salaried_warning => l_UpdEmpAsg_out.hourly_salaried_warning
3261: ,p_gsp_post_process_warning => l_UpdEmpAsg_out.gsp_post_process_warning
3262: );
3263:
3264: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
3265:
3266: exception
3267: when e_empasg_notfound then
3268: l_error_msg := 'Employee Assignment could not be found as of the effective date';
3266: exception
3267: when e_empasg_notfound then
3268: l_error_msg := 'Employee Assignment could not be found as of the effective date';
3269:
3270: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
3271: hr_utility.set_message_token('TOKEN','Employee' );
3272: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
3273: hr_utility.raise_error;
3274:
3267: when e_empasg_notfound then
3268: l_error_msg := 'Employee Assignment could not be found as of the effective date';
3269:
3270: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
3271: hr_utility.set_message_token('TOKEN','Employee' );
3272: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
3273: hr_utility.raise_error;
3274:
3275: when Others then
3268: l_error_msg := 'Employee Assignment could not be found as of the effective date';
3269:
3270: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
3271: hr_utility.set_message_token('TOKEN','Employee' );
3272: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
3273: hr_utility.raise_error;
3274:
3275: when Others then
3276: --l_error_msg := SQLERRM;
3269:
3270: hr_utility.set_message(8303, 'PQP_230494_RIW_ASSGN_NOT_FOUND');
3271: hr_utility.set_message_token('TOKEN','Employee' );
3272: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
3273: hr_utility.raise_error;
3274:
3275: when Others then
3276: --l_error_msg := SQLERRM;
3277: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
3273: hr_utility.raise_error;
3274:
3275: when Others then
3276: --l_error_msg := SQLERRM;
3277: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
3278: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3279: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3280: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
3281: hr_utility.raise_error;
3274:
3275: when Others then
3276: --l_error_msg := SQLERRM;
3277: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
3278: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3279: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3280: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
3281: hr_utility.raise_error;
3282:
3275: when Others then
3276: --l_error_msg := SQLERRM;
3277: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
3278: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3279: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3280: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
3281: hr_utility.raise_error;
3282:
3283: end Update_Employee_Asg;
3276: --l_error_msg := SQLERRM;
3277: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
3278: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3279: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3280: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
3281: hr_utility.raise_error;
3282:
3283: end Update_Employee_Asg;
3284: -- =============================================================================
3277: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
3278: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3279: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3280: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
3281: hr_utility.raise_error;
3282:
3283: end Update_Employee_Asg;
3284: -- =============================================================================
3285: -- ~ Upd_Batch_Person:
3306: e_future_chgs_exists exception;
3307: l_error_msg varchar2(3000);
3308:
3309: begin
3310: hr_utility.set_location('Entering: ' || l_proc_name, 5);
3311:
3312: l_per_rec := Get_PerRecord_Values(g_interface_code);
3313: if p_datetrack_update_mode is not null then
3314: l_datetrack_update_mode := p_datetrack_update_mode;
3317: ,c_business_group_id => g_per_rec.business_group_id
3318: ,c_effective_date => g_per_rec.start_date);
3319: fetch csr_per into l_cur_per_rec;
3320: close csr_per;
3321: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
3322: Dt_Api.Find_DT_Upd_Modes
3323: (p_effective_date => g_per_rec.start_date
3324: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
3325: ,p_base_key_column => 'PERSON_ID'
3350: else
3351: l_datetrack_update_mode := 'CORRECTION';
3352: end if;
3353: end if;
3354: hr_utility.set_location(' l_datetrack_update_mode: ' ||
3355: l_datetrack_update_mode, 30);
3356:
3357: Hrdpp_Update_Person.Insert_Batch_Lines
3358: (p_batch_id => p_batch_id
3503: ,p_vendor_name => null
3504: ,p_adjusted_svc_date => p_adjusted_svc_date --Added By pkagrawa
3505: );
3506:
3507: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
3508:
3509: exception
3510: when e_future_chgs_exists then
3511: l_error_msg := 'This person cannot be created in HRMS as a Student '||
3510: when e_future_chgs_exists then
3511: l_error_msg := 'This person cannot be created in HRMS as a Student '||
3512: 'Employee due to future changes beyond the date: '||g_per_rec.start_date;
3513:
3514: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
3515: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3516: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3517: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
3518: hr_utility.raise_error;
3511: l_error_msg := 'This person cannot be created in HRMS as a Student '||
3512: 'Employee due to future changes beyond the date: '||g_per_rec.start_date;
3513:
3514: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
3515: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3516: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3517: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
3518: hr_utility.raise_error;
3519:
3512: 'Employee due to future changes beyond the date: '||g_per_rec.start_date;
3513:
3514: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
3515: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3516: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3517: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
3518: hr_utility.raise_error;
3519:
3520: when Others then
3513:
3514: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
3515: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3516: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3517: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
3518: hr_utility.raise_error;
3519:
3520: when Others then
3521: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
3514: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
3515: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3516: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
3517: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
3518: hr_utility.raise_error;
3519:
3520: when Others then
3521: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
3522: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
3517: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
3518: hr_utility.raise_error;
3519:
3520: when Others then
3521: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
3522: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
3523: raise;
3524: end Upd_Batch_Person;
3525: -- =============================================================================
3518: hr_utility.raise_error;
3519:
3520: when Others then
3521: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
3522: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
3523: raise;
3524: end Upd_Batch_Person;
3525: -- =============================================================================
3526: -- InsUpd_Batch_Applicant:
3542: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Batch_Applicant';
3543:
3544: begin
3545:
3546: hr_utility.set_location('Entering: ' || l_proc_name, 5);
3547: hr_utility.set_location('p_action_mode: ' || p_action_mode, 6);
3548:
3549: if p_action_mode = 'CREATE_APPLICANT' then
3550:
3543:
3544: begin
3545:
3546: hr_utility.set_location('Entering: ' || l_proc_name, 5);
3547: hr_utility.set_location('p_action_mode: ' || p_action_mode, 6);
3548:
3549: if p_action_mode = 'CREATE_APPLICANT' then
3550:
3551: Hrdpp_Create_Applicant.Insert_Batch_Lines
3667: ,p_benefit_group => g_benefit_grp_name
3668: );
3669:
3670: end if;
3671: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
3672:
3673: end InsUpd_Batch_Applicant;
3674: -- =============================================================================
3675: -- ~ InsUpd_Batch_ContactPerson:
3686: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Batch_ContactPerson';
3687:
3688: begin
3689:
3690: hr_utility.set_location('Entering: ' || l_proc_name, 5);
3691:
3692: HrDpp_Create_Person.Insert_Batch_Lines
3693: (p_batch_id => p_batch_id
3694: ,p_data_pump_batch_line_id => p_data_pump_batch_line_id
3795: --$ In Batch Lines Benefit Group Name has to be passed instead of ID
3796: ,p_benefit_group => g_benefit_grp_name
3797: ,p_language_code => Userenv('lang')
3798: );
3799: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
3800:
3801: end InsUpd_Batch_ContactPerson;
3802:
3803: -- =============================================================================
3820: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Batch_Employee';
3821:
3822: begin
3823:
3824: hr_utility.set_location('Entering: ' || l_proc_name, 5);
3825: hr_utility.set_location('p_action_mode: ' || p_action_mode, 6);
3826:
3827: if p_action_mode = 'CREATE_EMPLOYEE' then
3828:
3821:
3822: begin
3823:
3824: hr_utility.set_location('Entering: ' || l_proc_name, 5);
3825: hr_utility.set_location('p_action_mode: ' || p_action_mode, 6);
3826:
3827: if p_action_mode = 'CREATE_EMPLOYEE' then
3828:
3829: Hrdpp_Create_Employee.Insert_Batch_Lines
3985: );
3986:
3987: p_user_sequence := p_user_sequence + 1;
3988:
3989: hr_utility.set_location(' Calling : ' ||
3990: 'Hrdpp_Update_Person.Insert_Batch_Lines', 7);
3991:
3992: Upd_Batch_Person
3993: (p_batch_id => p_batch_id
3998: ,p_datetrack_update_mode => 'CORRECTION'
3999: );
4000:
4001: end if;
4002: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
4003:
4004: end InsUpd_Batch_Employee;
4005: -- =============================================================================
4006: -- ~ InsUpd_Batch_Address:
4051: l_error_msg varchar2(2000);
4052:
4053: l_effective_date date;
4054: begin
4055: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4056:
4057: l_effective_date := g_add_rec.date_from;
4058:
4059: if g_add_rec.address_line1 is null and g_add_rec.style is null then
4059: if g_add_rec.address_line1 is null and g_add_rec.style is null then
4060: return;
4061: end if;
4062:
4063: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4064: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4065: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4066: --hr_utility.trace('MSG_AD c_effective_date='||l_effective_date);
4067:
4060: return;
4061: end if;
4062:
4063: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4064: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4065: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4066: --hr_utility.trace('MSG_AD c_effective_date='||l_effective_date);
4067:
4068: l_pradd_ovlapval_override := false;
4061: end if;
4062:
4063: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4064: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4065: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4066: --hr_utility.trace('MSG_AD c_effective_date='||l_effective_date);
4067:
4068: l_pradd_ovlapval_override := false;
4069:
4062:
4063: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4064: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4065: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4066: --hr_utility.trace('MSG_AD c_effective_date='||l_effective_date);
4067:
4068: l_pradd_ovlapval_override := false;
4069:
4070: if Trunc(g_add_rec.date_from) > Trunc(l_cur_add_rec.date_from) then
4067:
4068: l_pradd_ovlapval_override := false;
4069:
4070: if Trunc(g_add_rec.date_from) > Trunc(l_cur_add_rec.date_from) then
4071: hr_utility.set_location(' g_add_rec.date_from: ' ||g_add_rec.date_from, 40);
4072: hr_utility.set_location(' g_add_rec.date_to: ' ||g_add_rec.date_to, 40);
4073:
4074: l_pradd_ovlapval_override := true;
4075: end if;
4068: l_pradd_ovlapval_override := false;
4069:
4070: if Trunc(g_add_rec.date_from) > Trunc(l_cur_add_rec.date_from) then
4071: hr_utility.set_location(' g_add_rec.date_from: ' ||g_add_rec.date_from, 40);
4072: hr_utility.set_location(' g_add_rec.date_to: ' ||g_add_rec.date_to, 40);
4073:
4074: l_pradd_ovlapval_override := true;
4075: end if;
4076:
4083: ,c_primary_flag => g_add_rec.primary_flag);
4084: fetch csr_primary_add into l_cur_add_rec;
4085:
4086: if csr_primary_add%notfound then
4087: hr_utility.set_location(' Primary Address Not found', 20);
4088: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4089:
4090: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4091: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4084: fetch csr_primary_add into l_cur_add_rec;
4085:
4086: if csr_primary_add%notfound then
4087: hr_utility.set_location(' Primary Address Not found', 20);
4088: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4089:
4090: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4091: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4092: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4086: if csr_primary_add%notfound then
4087: hr_utility.set_location(' Primary Address Not found', 20);
4088: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4089:
4090: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4091: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4092: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4093: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4094: if (g_crt_upd = 'C') then
4087: hr_utility.set_location(' Primary Address Not found', 20);
4088: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4089:
4090: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4091: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4092: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4093: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4094: if (g_crt_upd = 'C') then
4095: Hrdpp_Create_Person_Address.Insert_Batch_Lines
4088: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4089:
4090: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4091: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4092: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4093: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4094: if (g_crt_upd = 'C') then
4095: Hrdpp_Create_Person_Address.Insert_Batch_Lines
4096: (p_batch_id => p_batch_id
4089:
4090: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4091: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4092: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4093: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4094: if (g_crt_upd = 'C') then
4095: Hrdpp_Create_Person_Address.Insert_Batch_Lines
4096: (p_batch_id => p_batch_id
4097: ,p_user_sequence => p_user_sequence
4152: else
4153: raise e_crt_add_not_allowed;
4154: end if;
4155: else
4156: hr_utility.set_location(' Primary Address found: ' ||
4157: l_cur_add_rec.address_id, 30);
4158:
4159: if g_add_rec.date_from is null then
4160: g_add_rec.date_from := trunc(l_effective_date);
4159: if g_add_rec.date_from is null then
4160: g_add_rec.date_from := trunc(l_effective_date);
4161: end if;
4162:
4163: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4164: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4165: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4166: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4167:
4160: g_add_rec.date_from := trunc(l_effective_date);
4161: end if;
4162:
4163: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4164: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4165: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4166: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4167:
4168:
4161: end if;
4162:
4163: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4164: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4165: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4166: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4167:
4168:
4169: --hr_utility.trace('MSG_AD 11:'||l_effective_date);
4162:
4163: --hr_utility.trace('MSG_AD l_effective_date:'||l_effective_date);
4164: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4165: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4166: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4167:
4168:
4169: --hr_utility.trace('MSG_AD 11:'||l_effective_date);
4170:
4165: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4166: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4167:
4168:
4169: --hr_utility.trace('MSG_AD 11:'||l_effective_date);
4170:
4171: g_add_rec.address_id := l_cur_add_rec.address_id;
4172: g_add_rec.object_version_number := l_cur_add_rec.object_version_number;
4173: g_add_rec.style := l_cur_add_rec.style;
4171: g_add_rec.address_id := l_cur_add_rec.address_id;
4172: g_add_rec.object_version_number := l_cur_add_rec.object_version_number;
4173: g_add_rec.style := l_cur_add_rec.style;
4174:
4175: --hr_utility.trace('MSG_AD 12:'||l_effective_date);
4176:
4177: --hr_utility.trace('$$_PSG InsUpd_Batch_Address Y p_address_user_key: '||p_address_user_key);
4178:
4179: hr_pump_utils.add_user_key
4173: g_add_rec.style := l_cur_add_rec.style;
4174:
4175: --hr_utility.trace('MSG_AD 12:'||l_effective_date);
4176:
4177: --hr_utility.trace('$$_PSG InsUpd_Batch_Address Y p_address_user_key: '||p_address_user_key);
4178:
4179: hr_pump_utils.add_user_key
4180: (p_user_key_value => p_address_user_key
4181: ,p_unique_key_id => g_add_rec.address_id
4180: (p_user_key_value => p_address_user_key
4181: ,p_unique_key_id => g_add_rec.address_id
4182: );
4183:
4184: hr_utility.set_location(' HrDpp_Update_Person_Address.Insert_Batch_Lines: ' , 51);
4185: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
4186: HrDpp_Update_Person_Address.Insert_Batch_Lines
4187: (p_batch_id => p_batch_id
4188: ,p_user_sequence => p_user_sequence
4235: raise e_upl_not_allowed;
4236: end if;
4237: end if;
4238:
4239: --hr_utility.trace('MSG_AD 13:'||l_effective_date);
4240:
4241: -- end if;
4242: close csr_primary_add;
4243:
4244: -- For Secondary Address
4245:
4246: ELSIF g_add_rec.primary_flag = 'N' Then
4247:
4248: --hr_utility.trace('Testing cursor');
4249: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4250: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4245:
4246: ELSIF g_add_rec.primary_flag = 'N' Then
4247:
4248: --hr_utility.trace('Testing cursor');
4249: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4250: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4253: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4246: ELSIF g_add_rec.primary_flag = 'N' Then
4247:
4248: --hr_utility.trace('Testing cursor');
4249: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4250: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4253: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4254: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4247:
4248: --hr_utility.trace('Testing cursor');
4249: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4250: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4253: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4254: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4255: --hr_utility.trace('c_effective_date :'||l_effective_date);
4248: --hr_utility.trace('Testing cursor');
4249: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4250: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4253: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4254: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4255: --hr_utility.trace('c_effective_date :'||l_effective_date);
4256:
4249: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4250: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4253: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4254: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4255: --hr_utility.trace('c_effective_date :'||l_effective_date);
4256:
4257: open csr_secondary_add (c_person_id => g_add_rec.person_id
4250: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4253: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4254: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4255: --hr_utility.trace('c_effective_date :'||l_effective_date);
4256:
4257: open csr_secondary_add (c_person_id => g_add_rec.person_id
4258: ,c_business_group_id => g_add_rec.business_group_id
4251: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4252: --hr_utility.trace('c_style :'||g_add_rec.style);
4253: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4254: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4255: --hr_utility.trace('c_effective_date :'||l_effective_date);
4256:
4257: open csr_secondary_add (c_person_id => g_add_rec.person_id
4258: ,c_business_group_id => g_add_rec.business_group_id
4259: ,c_primary_flag => g_add_rec.primary_flag
4264:
4265: fetch csr_secondary_add into l_cur_add_rec;
4266:
4267: if csr_secondary_add%notfound then
4268: hr_utility.set_location(' Secondary Address Not found', 40);
4269: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 45);
4270: if (g_crt_upd = 'C') then
4271: Hrdpp_Create_Person_Address.Insert_Batch_Lines
4272: (p_batch_id => p_batch_id
4265: fetch csr_secondary_add into l_cur_add_rec;
4266:
4267: if csr_secondary_add%notfound then
4268: hr_utility.set_location(' Secondary Address Not found', 40);
4269: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 45);
4270: if (g_crt_upd = 'C') then
4271: Hrdpp_Create_Person_Address.Insert_Batch_Lines
4272: (p_batch_id => p_batch_id
4273: ,p_user_sequence => p_user_sequence
4328: else
4329: raise e_crt_add_not_allowed;
4330: end if;
4331: else
4332: hr_utility.set_location(' Secondary Address found: ' ||
4333: l_cur_add_rec.address_id, 50);
4334: if g_add_rec.date_from is null then
4335: g_add_rec.date_from := trunc(l_effective_date);
4336: end if;
4338: g_add_rec.address_id := l_cur_add_rec.address_id;
4339: g_add_rec.object_version_number := l_cur_add_rec.object_version_number;
4340: g_add_rec.style := l_cur_add_rec.style;
4341:
4342: --hr_utility.trace('$$_PSG InsUpd_Batch_Address N p_address_user_key: '||p_address_user_key);
4343:
4344: hr_pump_utils.add_user_key
4345: (p_user_key_value => p_address_user_key
4346: ,p_unique_key_id => g_add_rec.address_id
4345: (p_user_key_value => p_address_user_key
4346: ,p_unique_key_id => g_add_rec.address_id
4347: );
4348:
4349: hr_utility.set_location(' Hrdpp_Create_Person_Address.Insert_Batch_Lines: ' , 51);
4350: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
4351: HrDpp_Update_Person_Address.Insert_Batch_Lines
4352: (p_batch_id => p_batch_id
4353: ,p_user_sequence => p_user_sequence
4402: end if;
4403: close csr_secondary_add;
4404: end if;
4405:
4406: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4407:
4408: exception
4409: when Others then
4410: if csr_primary_add%isopen then
4415: close csr_secondary_add;
4416: end if;
4417:
4418: --l_error_msg := Substr(SQLERRM,1,2000);
4419: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4420: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4421: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4422: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4423: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4416: end if;
4417:
4418: --l_error_msg := Substr(SQLERRM,1,2000);
4419: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4420: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4421: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4422: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4423: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4424: hr_utility.raise_error;
4417:
4418: --l_error_msg := Substr(SQLERRM,1,2000);
4419: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4420: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4421: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4422: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4423: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4424: hr_utility.raise_error;
4425:
4418: --l_error_msg := Substr(SQLERRM,1,2000);
4419: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4420: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4421: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4422: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4423: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4424: hr_utility.raise_error;
4425:
4426: end InsUpd_Batch_Address;
4419: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4420: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4421: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4422: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4423: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4424: hr_utility.raise_error;
4425:
4426: end InsUpd_Batch_Address;
4427:
4420: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4421: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4422: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4423: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4424: hr_utility.raise_error;
4425:
4426: end InsUpd_Batch_Address;
4427:
4428: -- =============================================================================
4472: l_party_id per_people_f.party_id%type;
4473:
4474:
4475: begin
4476: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4477:
4478: if g_add_rec.address_line1 is null and g_add_rec.style is null then
4479: return;
4480: end if;
4478: if g_add_rec.address_line1 is null and g_add_rec.style is null then
4479: return;
4480: end if;
4481:
4482: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4483: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4484: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4485: --hr_utility.trace('MSG_AD c_effective_date='||p_effective_date);
4486:
4479: return;
4480: end if;
4481:
4482: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4483: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4484: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4485: --hr_utility.trace('MSG_AD c_effective_date='||p_effective_date);
4486:
4487:
4480: end if;
4481:
4482: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4483: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4484: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4485: --hr_utility.trace('MSG_AD c_effective_date='||p_effective_date);
4486:
4487:
4488: IF g_add_rec.primary_flag = 'Y' Then
4481:
4482: --hr_utility.trace('MSG_AD c_person_id='||g_add_rec.person_id);
4483: --hr_utility.trace('MSG_AD c_business_group_id='||g_add_rec.business_group_id);
4484: --hr_utility.trace('MSG_AD c_primary_flag='|| g_add_rec.primary_flag);
4485: --hr_utility.trace('MSG_AD c_effective_date='||p_effective_date);
4486:
4487:
4488: IF g_add_rec.primary_flag = 'Y' Then
4489:
4493: ,c_primary_flag => g_add_rec.primary_flag);
4494: fetch csr_primary_add into l_cur_add_rec;
4495:
4496: if csr_primary_add%notfound then
4497: hr_utility.set_location(' Primary Address Not found', 20);
4498: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4499:
4500: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4501: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4494: fetch csr_primary_add into l_cur_add_rec;
4495:
4496: if csr_primary_add%notfound then
4497: hr_utility.set_location(' Primary Address Not found', 20);
4498: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4499:
4500: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4501: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4502: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4496: if csr_primary_add%notfound then
4497: hr_utility.set_location(' Primary Address Not found', 20);
4498: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4499:
4500: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4501: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4502: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4503: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4504: if (g_crt_upd = 'C') then
4497: hr_utility.set_location(' Primary Address Not found', 20);
4498: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4499:
4500: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4501: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4502: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4503: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4504: if (g_crt_upd = 'C') then
4505: Pqp_Hrtca_Integration.Person_Address_Api
4498: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 25);
4499:
4500: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4501: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4502: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4503: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4504: if (g_crt_upd = 'C') then
4505: Pqp_Hrtca_Integration.Person_Address_Api
4506: (p_HR_Address_Rec => g_add_rec
4499:
4500: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4501: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4502: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4503: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4504: if (g_crt_upd = 'C') then
4505: Pqp_Hrtca_Integration.Person_Address_Api
4506: (p_HR_Address_Rec => g_add_rec
4507: ,p_validate => false
4516: else
4517: raise e_crt_add_not_allowed;
4518: end if;
4519: else
4520: hr_utility.set_location(' Primary Address found: ' ||
4521: l_cur_add_rec.address_id, 30);
4522:
4523: if g_add_rec.date_from is null then
4524: g_add_rec.date_from := trunc(p_effective_date);
4523: if g_add_rec.date_from is null then
4524: g_add_rec.date_from := trunc(p_effective_date);
4525: end if;
4526:
4527: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4528: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4529: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4530: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4531:
4524: g_add_rec.date_from := trunc(p_effective_date);
4525: end if;
4526:
4527: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4528: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4529: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4530: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4531:
4532:
4525: end if;
4526:
4527: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4528: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4529: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4530: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4531:
4532:
4533: --hr_utility.trace('MSG_AD 11:'||p_effective_date);
4526:
4527: --hr_utility.trace('MSG_AD p_effective_date:'||p_effective_date);
4528: --hr_utility.trace('MSG_AD primary_flag:'||g_add_rec.primary_flag);
4529: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4530: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4531:
4532:
4533: --hr_utility.trace('MSG_AD 11:'||p_effective_date);
4534:
4529: --hr_utility.trace('MSG_AD address_id:'||g_add_rec.address_id);
4530: --hr_utility.trace('MSG_AD object_version_number:'||g_add_rec.object_version_number);
4531:
4532:
4533: --hr_utility.trace('MSG_AD 11:'||p_effective_date);
4534:
4535: g_add_rec.address_id := l_cur_add_rec.address_id;
4536: g_add_rec.object_version_number := l_cur_add_rec.object_version_number;
4537: g_add_rec.style := l_cur_add_rec.style;
4535: g_add_rec.address_id := l_cur_add_rec.address_id;
4536: g_add_rec.object_version_number := l_cur_add_rec.object_version_number;
4537: g_add_rec.style := l_cur_add_rec.style;
4538:
4539: --hr_utility.trace('MSG_AD 12:'||p_effective_date);
4540: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
4541: Pqp_Hrtca_Integration.Person_Address_Api
4542: (p_HR_Address_Rec => g_add_rec
4543: ,p_validate => false
4551: );
4552: else
4553: raise e_upl_not_allowed;
4554: end if;
4555: --hr_utility.trace('MSG_AD 13:'||p_effective_date);
4556:
4557: end if;
4558: close csr_primary_add;
4559: -- For Secondary Address
4558: close csr_primary_add;
4559: -- For Secondary Address
4560: ELSIF g_add_rec.primary_flag = 'N' Then
4561:
4562: --hr_utility.trace('Testing cursor');
4563: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4564: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4559: -- For Secondary Address
4560: ELSIF g_add_rec.primary_flag = 'N' Then
4561:
4562: --hr_utility.trace('Testing cursor');
4563: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4564: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4567: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4560: ELSIF g_add_rec.primary_flag = 'N' Then
4561:
4562: --hr_utility.trace('Testing cursor');
4563: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4564: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4567: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4568: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4561:
4562: --hr_utility.trace('Testing cursor');
4563: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4564: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4567: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4568: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4569: --hr_utility.trace('c_effective_date :'||p_effective_date);
4562: --hr_utility.trace('Testing cursor');
4563: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4564: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4567: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4568: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4569: --hr_utility.trace('c_effective_date :'||p_effective_date);
4570:
4563: --hr_utility.trace('c_person_id :'||g_add_rec.person_id);
4564: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4567: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4568: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4569: --hr_utility.trace('c_effective_date :'||p_effective_date);
4570:
4571: open csr_secondary_add (c_person_id => g_add_rec.person_id
4564: --hr_utility.trace('c_business_group_id :'||g_add_rec.business_group_id);
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4567: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4568: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4569: --hr_utility.trace('c_effective_date :'||p_effective_date);
4570:
4571: open csr_secondary_add (c_person_id => g_add_rec.person_id
4572: ,c_business_group_id => g_add_rec.business_group_id
4565: --hr_utility.trace('c_primary_flag :'||g_add_rec.primary_flag);
4566: --hr_utility.trace('c_style :'||g_add_rec.style);
4567: --hr_utility.trace('c_address_type :'||g_add_rec.address_type);
4568: --hr_utility.trace('c_date_from :'||g_add_rec.date_from);
4569: --hr_utility.trace('c_effective_date :'||p_effective_date);
4570:
4571: open csr_secondary_add (c_person_id => g_add_rec.person_id
4572: ,c_business_group_id => g_add_rec.business_group_id
4573: ,c_primary_flag => g_add_rec.primary_flag
4578:
4579: fetch csr_secondary_add into l_cur_add_rec;
4580:
4581: if csr_secondary_add%notfound then
4582: hr_utility.set_location(' Secondary Address Not found', 40);
4583: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 45);
4584: if (g_crt_upd = 'C') then
4585: Pqp_Hrtca_Integration.Person_Address_Api
4586: (p_HR_Address_Rec => g_add_rec
4579: fetch csr_secondary_add into l_cur_add_rec;
4580:
4581: if csr_secondary_add%notfound then
4582: hr_utility.set_location(' Secondary Address Not found', 40);
4583: hr_utility.set_location(' Person ID'||g_add_rec.person_id, 45);
4584: if (g_crt_upd = 'C') then
4585: Pqp_Hrtca_Integration.Person_Address_Api
4586: (p_HR_Address_Rec => g_add_rec
4587: ,p_validate => false
4596: else
4597: raise e_crt_add_not_allowed;
4598: end if;
4599: else
4600: hr_utility.set_location(' Secondary Address found: ' ||
4601: l_cur_add_rec.address_id, 50);
4602: if g_add_rec.date_from is null then
4603: g_add_rec.date_from := trunc(p_effective_date);
4604: end if;
4624: end if;
4625: close csr_secondary_add;
4626: end if;
4627:
4628: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4629:
4630: exception
4631: when Others then
4632: if csr_primary_add%isopen then
4637: close csr_secondary_add;
4638: end if;
4639:
4640: --l_error_msg := Substr(SQLERRM,1,2000);
4641: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4642: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4643: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4644: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4645: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4638: end if;
4639:
4640: --l_error_msg := Substr(SQLERRM,1,2000);
4641: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4642: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4643: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4644: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4645: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4646: hr_utility.raise_error;
4639:
4640: --l_error_msg := Substr(SQLERRM,1,2000);
4641: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4642: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4643: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4644: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4645: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4646: hr_utility.raise_error;
4647:
4640: --l_error_msg := Substr(SQLERRM,1,2000);
4641: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4642: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4643: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4644: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4645: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4646: hr_utility.raise_error;
4647:
4648: end InsUpd_Address;
4641: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
4642: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4643: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4644: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4645: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4646: hr_utility.raise_error;
4647:
4648: end InsUpd_Address;
4649: -- =============================================================================
4642: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
4643: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4644: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4645: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4646: hr_utility.raise_error;
4647:
4648: end InsUpd_Address;
4649: -- =============================================================================
4650: -- ~ Upd_Person_Details:
4669: l_error_msg varchar2(3000);
4670: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Person_Details';
4671:
4672: begin
4673: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4674:
4675: l_per_rec := Get_PerRecord_Values(g_interface_code);
4676:
4677: open csr_per(c_person_id => g_per_rec.person_id
4679: ,c_effective_date => p_effective_date);
4680: fetch csr_per into l_cur_per_rec;
4681: close csr_per;
4682:
4683: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
4684:
4685: Dt_Api.Find_DT_Upd_Modes
4686: (p_effective_date => p_effective_date
4687: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
4714: else
4715: l_datetrack_update_mode := 'CORRECTION';
4716: end if;
4717:
4718: hr_utility.set_location(' l_datetrack_update_mode: ' ||
4719: l_datetrack_update_mode, 30);
4720: hr_utility.set_location(' employee_number: ' ||
4721: l_cur_per_rec.employee_number, 30);
4722: hr_utility.set_location(' per ovn: ' ||
4716: end if;
4717:
4718: hr_utility.set_location(' l_datetrack_update_mode: ' ||
4719: l_datetrack_update_mode, 30);
4720: hr_utility.set_location(' employee_number: ' ||
4721: l_cur_per_rec.employee_number, 30);
4722: hr_utility.set_location(' per ovn: ' ||
4723: l_cur_per_rec.object_version_number, 30);
4724:
4718: hr_utility.set_location(' l_datetrack_update_mode: ' ||
4719: l_datetrack_update_mode, 30);
4720: hr_utility.set_location(' employee_number: ' ||
4721: l_cur_per_rec.employee_number, 30);
4722: hr_utility.set_location(' per ovn: ' ||
4723: l_cur_per_rec.object_version_number, 30);
4724:
4725: -- Need to pass the employee number when updating the person
4726: g_per_rec.object_version_number := l_cur_per_rec.object_version_number;
4874: ,p_adjusted_svc_date => p_adjusted_svc_date --Uncommented by pkagrawa
4875: );
4876:
4877: if g_debug then
4878: hr_utility.set_location('..effective_start_date : ' ||
4879: p_updper_api_out.effective_start_date,40);
4880: hr_utility.set_location('..effective_end_date : ' ||
4881: p_updper_api_out.effective_end_date,40);
4882: hr_utility.set_location('..full_name : ' ||
4876:
4877: if g_debug then
4878: hr_utility.set_location('..effective_start_date : ' ||
4879: p_updper_api_out.effective_start_date,40);
4880: hr_utility.set_location('..effective_end_date : ' ||
4881: p_updper_api_out.effective_end_date,40);
4882: hr_utility.set_location('..full_name : ' ||
4883: p_updper_api_out.full_name,40);
4884: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
4878: hr_utility.set_location('..effective_start_date : ' ||
4879: p_updper_api_out.effective_start_date,40);
4880: hr_utility.set_location('..effective_end_date : ' ||
4881: p_updper_api_out.effective_end_date,40);
4882: hr_utility.set_location('..full_name : ' ||
4883: p_updper_api_out.full_name,40);
4884: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
4885: end if;
4886:
4880: hr_utility.set_location('..effective_end_date : ' ||
4881: p_updper_api_out.effective_end_date,40);
4882: hr_utility.set_location('..full_name : ' ||
4883: p_updper_api_out.full_name,40);
4884: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
4885: end if;
4886:
4887: exception
4888: when e_future_chgs_exists then
4888: when e_future_chgs_exists then
4889: l_error_msg := 'This person cannot be created in HRMS as a Student '||
4890: 'Employee due to future changes beyond the date: '||p_effective_date;
4891:
4892: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
4893: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4894: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4895: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4896: hr_utility.raise_error;
4889: l_error_msg := 'This person cannot be created in HRMS as a Student '||
4890: 'Employee due to future changes beyond the date: '||p_effective_date;
4891:
4892: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
4893: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4894: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4895: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4896: hr_utility.raise_error;
4897:
4890: 'Employee due to future changes beyond the date: '||p_effective_date;
4891:
4892: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
4893: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4894: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4895: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4896: hr_utility.raise_error;
4897:
4898: when Others then
4891:
4892: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
4893: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4894: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4895: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4896: hr_utility.raise_error;
4897:
4898: when Others then
4899: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
4892: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
4893: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4894: hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
4895: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4896: hr_utility.raise_error;
4897:
4898: when Others then
4899: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
4900: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4895: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
4896: hr_utility.raise_error;
4897:
4898: when Others then
4899: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
4900: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4901: raise;
4902:
4903: end Upd_Person_Details;
4896: hr_utility.raise_error;
4897:
4898: when Others then
4899: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
4900: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
4901: raise;
4902:
4903: end Upd_Person_Details;
4904: -- =============================================================================
4963: l_unaccepted_asg_del_warning boolean;
4964: l_diff_date number; -- For Hiring applicant on the next day.
4965:
4966: begin
4967: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4968:
4969: g_debug := hr_utility.debug_enabled;
4970: l_effective_date := p_hire_date;
4971:
4965:
4966: begin
4967: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4968:
4969: g_debug := hr_utility.debug_enabled;
4970: l_effective_date := p_hire_date;
4971:
4972: -- Get the person details for the person
4973: open csr_per(c_person_id => g_per_rec.person_id
4974: ,c_business_group_id => g_per_rec.business_group_id
4975: ,c_effective_date => l_effective_date);
4976: fetch csr_per into l_cur_per_rec;
4977: close csr_per;
4978: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
4979:
4980: -- Get the Applicant assignment details
4981: open csr_asg (c_person_id => g_per_rec.person_id
4982: ,c_business_group_id => g_per_rec.business_group_id
4986: fetch csr_asg into l_perasg_rec;
4987: close csr_asg;
4988:
4989: if g_debug then
4990: hr_utility.set_location(' l_perasg_rec.person_id: ' ||
4991: l_perasg_rec.person_id, 30);
4992: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
4993: l_perasg_rec.assignment_id, 30);
4994: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
4988:
4989: if g_debug then
4990: hr_utility.set_location(' l_perasg_rec.person_id: ' ||
4991: l_perasg_rec.person_id, 30);
4992: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
4993: l_perasg_rec.assignment_id, 30);
4994: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
4995: l_perasg_rec.per_ovn, 30);
4996: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
4990: hr_utility.set_location(' l_perasg_rec.person_id: ' ||
4991: l_perasg_rec.person_id, 30);
4992: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
4993: l_perasg_rec.assignment_id, 30);
4994: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
4995: l_perasg_rec.per_ovn, 30);
4996: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
4997: l_perasg_rec.asg_ovn, 30);
4998: hr_utility.set_location(' l_effective_date: ' ||
4992: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
4993: l_perasg_rec.assignment_id, 30);
4994: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
4995: l_perasg_rec.per_ovn, 30);
4996: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
4997: l_perasg_rec.asg_ovn, 30);
4998: hr_utility.set_location(' l_effective_date: ' ||
4999: l_effective_date, 30);
5000: end if;
4994: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
4995: l_perasg_rec.per_ovn, 30);
4996: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
4997: l_perasg_rec.asg_ovn, 30);
4998: hr_utility.set_location(' l_effective_date: ' ||
4999: l_effective_date, 30);
5000: end if;
5001: l_accp_asg_count := 0;
5002: for accp_ags in csr_accepted_asgs
5011: open diff_date (date1 =>l_effective_date
5012: ,date2 => l_perasg_rec.effective_start_date);
5013: fetch diff_date into l_diff_date;
5014:
5015: hr_utility.set_location(' l_diff_date: ' || l_diff_date, 40);
5016:
5017: if l_accp_asg_count < 1 then
5018: -- Means the Applicant Assignment is not accepted, so update the applicant
5019: -- as accepted as of the hire date.
5016:
5017: if l_accp_asg_count < 1 then
5018: -- Means the Applicant Assignment is not accepted, so update the applicant
5019: -- as accepted as of the hire date.
5020: hr_utility.set_location(' Asg Id NOT Accepted : ' || p_assignment_id, 40);
5021: if l_diff_date = 1 then -- Means The Applicant Assignment is to be corrected to
5022: Dt_Api.Find_DT_Upd_Modes -- Accepted.
5023: (p_effective_date => l_perasg_rec.effective_start_date
5024: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
5052: l_datetrack_update_mode := 'CORRECTION';
5053: else
5054: l_datetrack_update_mode := 'CORRECTION';
5055: end if;
5056: hr_utility.set_location(' DT Mode for Update of Appl Asg : ' ||
5057: l_datetrack_update_mode, 50);
5058:
5059: -- Get the Accepted Applicant Status Id
5060: open csr_asg_status (c_leg_code => g_leg_code
5061: ,c_business_group_id => g_per_rec.business_group_id
5062: );
5063: fetch csr_asg_status into l_asg_status_rec;
5064: close csr_asg_status;
5065: hr_utility.set_location(' Accepted Asg Status ID: ' ||
5066: l_asg_status_rec.assignment_status_type_id, 60);
5067:
5068: -- Now accept the Applicant assigment used to hire the person
5069: HR_Assignment_API.Accept_APL_Asg
5077: ,p_effective_start_date => l_appl_asg_start_date
5078: ,p_effective_end_date => l_appl_asg_end_date
5079: );
5080: if g_debug then
5081: hr_utility.set_location(' l_appl_asg_start_date: ' ||
5082: l_appl_asg_start_date, 70);
5083: hr_utility.set_location(' l_appl_asg_end_date: ' ||
5084: l_appl_asg_end_date, 70);
5085: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
5079: );
5080: if g_debug then
5081: hr_utility.set_location(' l_appl_asg_start_date: ' ||
5082: l_appl_asg_start_date, 70);
5083: hr_utility.set_location(' l_appl_asg_end_date: ' ||
5084: l_appl_asg_end_date, 70);
5085: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
5086: l_perasg_rec.asg_ovn, 70);
5087: end if;
5081: hr_utility.set_location(' l_appl_asg_start_date: ' ||
5082: l_appl_asg_start_date, 70);
5083: hr_utility.set_location(' l_appl_asg_end_date: ' ||
5084: l_appl_asg_end_date, 70);
5085: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
5086: l_perasg_rec.asg_ovn, 70);
5087: end if;
5088:
5089: -- Get again the person details for the person
5091: ,c_business_group_id => g_per_rec.business_group_id
5092: ,c_effective_date => l_effective_date);
5093: fetch csr_per into l_cur_per_rec;
5094: close csr_per;
5095: hr_utility.set_location(' per_rec.ovn: ' ||
5096: l_cur_per_rec.object_version_number, 80);
5097: else
5098: hr_utility.set_location(' Asg Id Accepted Already: ' ||
5099: p_assignment_id, 90);
5094: close csr_per;
5095: hr_utility.set_location(' per_rec.ovn: ' ||
5096: l_cur_per_rec.object_version_number, 80);
5097: else
5098: hr_utility.set_location(' Asg Id Accepted Already: ' ||
5099: p_assignment_id, 90);
5100: end if;
5101:
5102: -- Get the count of accepted Applicant Assignments
5154: else
5155: l_datetrack_update_mode := 'CORRECTION';
5156: end if;
5157:
5158: hr_utility.set_location(' l_datetrack_update_mode: ' ||
5159: l_datetrack_update_mode, 100);
5160: g_per_rec.object_version_number := l_cur_per_rec.object_version_number;
5161: if l_tot_appl_asgs = 1 then
5162: -- As the person has only one applicant assignment then hire person so that
5213: fetch csr_per into l_cur_per_rec;
5214: close csr_per;
5215:
5216: if g_debug then
5217: hr_utility.set_location('..effective_start_date : ' ||
5218: p_HireAppapi_out.effective_start_date, 110);
5219: hr_utility.set_location('..effective_end_date : ' ||
5220: p_HireAppapi_out.effective_end_date, 110);
5221: hr_utility.set_location('..Old:object_version_number : ' ||
5215:
5216: if g_debug then
5217: hr_utility.set_location('..effective_start_date : ' ||
5218: p_HireAppapi_out.effective_start_date, 110);
5219: hr_utility.set_location('..effective_end_date : ' ||
5220: p_HireAppapi_out.effective_end_date, 110);
5221: hr_utility.set_location('..Old:object_version_number : ' ||
5222: l_cur_per_rec.object_version_number, 110);
5223: end if;
5217: hr_utility.set_location('..effective_start_date : ' ||
5218: p_HireAppapi_out.effective_start_date, 110);
5219: hr_utility.set_location('..effective_end_date : ' ||
5220: p_HireAppapi_out.effective_end_date, 110);
5221: hr_utility.set_location('..Old:object_version_number : ' ||
5222: l_cur_per_rec.object_version_number, 110);
5223: end if;
5224: l_datetrack_update_mode := 'CORRECTION';
5225: --
5233: ,p_adjusted_svc_date => p_adjusted_svc_date -- Added by pkagrawa
5234: ,p_updper_api_out => l_UpdEmp_Api
5235: );
5236: if g_debug then
5237: hr_utility.set_location('..effective_start_date : ' ||
5238: p_updper_api_out.effective_start_date, 120);
5239: hr_utility.set_location('..effective_end_date : ' ||
5240: p_updper_api_out.effective_end_date, 120);
5241: hr_utility.set_location('..full_name : ' ||
5235: );
5236: if g_debug then
5237: hr_utility.set_location('..effective_start_date : ' ||
5238: p_updper_api_out.effective_start_date, 120);
5239: hr_utility.set_location('..effective_end_date : ' ||
5240: p_updper_api_out.effective_end_date, 120);
5241: hr_utility.set_location('..full_name : ' ||
5242: p_updper_api_out.full_name, 120);
5243: hr_utility.set_location('Leaving: ' || l_proc_name, 120);
5237: hr_utility.set_location('..effective_start_date : ' ||
5238: p_updper_api_out.effective_start_date, 120);
5239: hr_utility.set_location('..effective_end_date : ' ||
5240: p_updper_api_out.effective_end_date, 120);
5241: hr_utility.set_location('..full_name : ' ||
5242: p_updper_api_out.full_name, 120);
5243: hr_utility.set_location('Leaving: ' || l_proc_name, 120);
5244: end if;
5245:
5239: hr_utility.set_location('..effective_end_date : ' ||
5240: p_updper_api_out.effective_end_date, 120);
5241: hr_utility.set_location('..full_name : ' ||
5242: p_updper_api_out.full_name, 120);
5243: hr_utility.set_location('Leaving: ' || l_proc_name, 120);
5244: end if;
5245:
5246: --
5247: -- Address record
5261: if csr_asg_status%isopen then
5262: close csr_asg_status;
5263: end if;
5264: --l_error_msg := Substr(SQLERRM,1,2000);
5265: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
5266: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5267: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5268: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
5269: hr_utility.raise_error;
5262: close csr_asg_status;
5263: end if;
5264: --l_error_msg := Substr(SQLERRM,1,2000);
5265: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
5266: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5267: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5268: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
5269: hr_utility.raise_error;
5270:
5263: end if;
5264: --l_error_msg := Substr(SQLERRM,1,2000);
5265: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
5266: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5267: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5268: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
5269: hr_utility.raise_error;
5270:
5271: end Hire_Applicant_IntoEmp;
5264: --l_error_msg := Substr(SQLERRM,1,2000);
5265: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
5266: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5267: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5268: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
5269: hr_utility.raise_error;
5270:
5271: end Hire_Applicant_IntoEmp;
5272:
5265: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
5266: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5267: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5268: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
5269: hr_utility.raise_error;
5270:
5271: end Hire_Applicant_IntoEmp;
5272:
5273: -- =============================================================================
5306: l_error_msg varchar2(2000);
5307: l_proc_name constant varchar2(150):= g_pkg ||'Hire_Person_IntoEmp';
5308: e_future_chgs_exists exception;
5309: begin
5310: hr_utility.set_location('Entering: ' || l_proc_name, 10);
5311:
5312: open csr_per(c_person_id => g_per_rec.person_id
5313: ,c_business_group_id => g_per_rec.business_group_id
5314: ,c_effective_date => p_hire_date);
5313: ,c_business_group_id => g_per_rec.business_group_id
5314: ,c_effective_date => p_hire_date);
5315: fetch csr_per into l_cur_per_rec;
5316: close csr_per;
5317: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
5318:
5319: Dt_Api.Find_DT_Upd_Modes
5320: (p_effective_date => p_hire_date
5321: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5349: else
5350: l_datetrack_update_mode := 'CORRECTION';
5351: end if;
5352:
5353: hr_utility.set_location('l_datetrack_update_mode: ' ||
5354: l_datetrack_update_mode, 30);
5355: g_per_rec.object_version_number := l_cur_per_rec.object_version_number;
5356:
5357: Hr_Employee_Api.Hire_Into_Job
5384: fetch csr_per into l_cur_per_rec;
5385: close csr_per;
5386:
5387: if g_debug then
5388: hr_utility.set_location('..effective_start_date : ' ||
5389: p_HireToJobapi_out.effective_start_date,40);
5390: hr_utility.set_location('..effective_end_date : ' ||
5391: p_HireToJobapi_out.effective_end_date,40);
5392: hr_utility.set_location('..New:object_version_number : ' ||
5386:
5387: if g_debug then
5388: hr_utility.set_location('..effective_start_date : ' ||
5389: p_HireToJobapi_out.effective_start_date,40);
5390: hr_utility.set_location('..effective_end_date : ' ||
5391: p_HireToJobapi_out.effective_end_date,40);
5392: hr_utility.set_location('..New:object_version_number : ' ||
5393: g_per_rec.object_version_number,40);
5394: hr_utility.set_location('..Old:object_version_number : ' ||
5388: hr_utility.set_location('..effective_start_date : ' ||
5389: p_HireToJobapi_out.effective_start_date,40);
5390: hr_utility.set_location('..effective_end_date : ' ||
5391: p_HireToJobapi_out.effective_end_date,40);
5392: hr_utility.set_location('..New:object_version_number : ' ||
5393: g_per_rec.object_version_number,40);
5394: hr_utility.set_location('..Old:object_version_number : ' ||
5395: l_cur_per_rec.object_version_number,40);
5396: hr_utility.set_location('..New:Assignment Id : ' ||
5390: hr_utility.set_location('..effective_end_date : ' ||
5391: p_HireToJobapi_out.effective_end_date,40);
5392: hr_utility.set_location('..New:object_version_number : ' ||
5393: g_per_rec.object_version_number,40);
5394: hr_utility.set_location('..Old:object_version_number : ' ||
5395: l_cur_per_rec.object_version_number,40);
5396: hr_utility.set_location('..New:Assignment Id : ' ||
5397: p_HireToJobapi_out.assignment_id,40);
5398: end if;
5392: hr_utility.set_location('..New:object_version_number : ' ||
5393: g_per_rec.object_version_number,40);
5394: hr_utility.set_location('..Old:object_version_number : ' ||
5395: l_cur_per_rec.object_version_number,40);
5396: hr_utility.set_location('..New:Assignment Id : ' ||
5397: p_HireToJobapi_out.assignment_id,40);
5398: end if;
5399: l_datetrack_update_mode := 'CORRECTION';
5400:
5405: ,p_adjusted_svc_date => null
5406: ,p_updper_api_out => l_UpdEmp_Api
5407: );
5408: if g_debug then
5409: hr_utility.set_location('..effective_start_date : ' ||
5410: p_updper_api_out.effective_start_date, 50);
5411: hr_utility.set_location('..effective_end_date : ' ||
5412: p_updper_api_out.effective_end_date, 50);
5413: hr_utility.set_location('..full_name : ' ||
5407: );
5408: if g_debug then
5409: hr_utility.set_location('..effective_start_date : ' ||
5410: p_updper_api_out.effective_start_date, 50);
5411: hr_utility.set_location('..effective_end_date : ' ||
5412: p_updper_api_out.effective_end_date, 50);
5413: hr_utility.set_location('..full_name : ' ||
5414: p_updper_api_out.full_name, 50);
5415: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
5409: hr_utility.set_location('..effective_start_date : ' ||
5410: p_updper_api_out.effective_start_date, 50);
5411: hr_utility.set_location('..effective_end_date : ' ||
5412: p_updper_api_out.effective_end_date, 50);
5413: hr_utility.set_location('..full_name : ' ||
5414: p_updper_api_out.full_name, 50);
5415: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
5416: end if;
5417:
5411: hr_utility.set_location('..effective_end_date : ' ||
5412: p_updper_api_out.effective_end_date, 50);
5413: hr_utility.set_location('..full_name : ' ||
5414: p_updper_api_out.full_name, 50);
5415: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
5416: end if;
5417:
5418: exception
5419: when e_future_chgs_exists then
5419: when e_future_chgs_exists then
5420: l_error_msg := 'This person cannot be created/updated in HRMS as the '||
5421: 'Person has future changes beyond the date: '||p_hire_date;
5422:
5423: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5424: hr_utility.set_message(8303, 'PQP_230491_RIW_PER_NOT_CREATED');
5425: hr_utility.set_message_token('TOKEN',p_hire_date );
5426: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5427: hr_utility.raise_error;
5420: l_error_msg := 'This person cannot be created/updated in HRMS as the '||
5421: 'Person has future changes beyond the date: '||p_hire_date;
5422:
5423: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5424: hr_utility.set_message(8303, 'PQP_230491_RIW_PER_NOT_CREATED');
5425: hr_utility.set_message_token('TOKEN',p_hire_date );
5426: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5427: hr_utility.raise_error;
5428:
5421: 'Person has future changes beyond the date: '||p_hire_date;
5422:
5423: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5424: hr_utility.set_message(8303, 'PQP_230491_RIW_PER_NOT_CREATED');
5425: hr_utility.set_message_token('TOKEN',p_hire_date );
5426: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5427: hr_utility.raise_error;
5428:
5429: when Others then
5422:
5423: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5424: hr_utility.set_message(8303, 'PQP_230491_RIW_PER_NOT_CREATED');
5425: hr_utility.set_message_token('TOKEN',p_hire_date );
5426: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5427: hr_utility.raise_error;
5428:
5429: when Others then
5430: if csr_asg%isopen then
5423: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5424: hr_utility.set_message(8303, 'PQP_230491_RIW_PER_NOT_CREATED');
5425: hr_utility.set_message_token('TOKEN',p_hire_date );
5426: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5427: hr_utility.raise_error;
5428:
5429: when Others then
5430: if csr_asg%isopen then
5431: close csr_asg;
5433: if csr_per%isopen then
5434: close csr_per;
5435: end if;
5436: --l_error_msg := Substr(SQLERRM,1,2000);
5437: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
5438: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5439: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5440: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5441: hr_utility.raise_error;
5434: close csr_per;
5435: end if;
5436: --l_error_msg := Substr(SQLERRM,1,2000);
5437: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
5438: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5439: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5440: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5441: hr_utility.raise_error;
5442:
5435: end if;
5436: --l_error_msg := Substr(SQLERRM,1,2000);
5437: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
5438: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5439: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5440: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5441: hr_utility.raise_error;
5442:
5443: end Hire_Person_IntoEmp;
5436: --l_error_msg := Substr(SQLERRM,1,2000);
5437: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
5438: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5439: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5440: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5441: hr_utility.raise_error;
5442:
5443: end Hire_Person_IntoEmp;
5444:
5437: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
5438: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5439: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
5440: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5441: hr_utility.raise_error;
5442:
5443: end Hire_Person_IntoEmp;
5444:
5445: -- =============================================================================
5458:
5459: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Employee';
5460:
5461: begin
5462: hr_utility.set_location('Entering: ' || l_proc_name, 10);
5463:
5464: if p_action_mode = 'CREATE_EMPLOYEE' then
5465:
5466: --hr_utility.trace('Before Call to Hr_Employee_Api.Create_Employee:');
5462: hr_utility.set_location('Entering: ' || l_proc_name, 10);
5463:
5464: if p_action_mode = 'CREATE_EMPLOYEE' then
5465:
5466: --hr_utility.trace('Before Call to Hr_Employee_Api.Create_Employee:');
5467: --hr_utility.trace('p_employee_number=>'|| g_per_rec.employee_number);
5468: --hr_utility.trace('p_assignment_number=>'|| g_asg_rec.assignment_number);
5469:
5470:
5463:
5464: if p_action_mode = 'CREATE_EMPLOYEE' then
5465:
5466: --hr_utility.trace('Before Call to Hr_Employee_Api.Create_Employee:');
5467: --hr_utility.trace('p_employee_number=>'|| g_per_rec.employee_number);
5468: --hr_utility.trace('p_assignment_number=>'|| g_asg_rec.assignment_number);
5469:
5470:
5471: Hr_Employee_Api.Create_Employee
5464: if p_action_mode = 'CREATE_EMPLOYEE' then
5465:
5466: --hr_utility.trace('Before Call to Hr_Employee_Api.Create_Employee:');
5467: --hr_utility.trace('p_employee_number=>'|| g_per_rec.employee_number);
5468: --hr_utility.trace('p_assignment_number=>'|| g_asg_rec.assignment_number);
5469:
5470:
5471: Hr_Employee_Api.Create_Employee
5472: (p_validate => p_validate
5638: g_add_rec.person_id := g_per_rec.person_id;
5639: g_add_rec.date_from := g_per_rec.start_date;
5640: g_add_rec.date_to := null;
5641:
5642: --hr_utility.trace('After Call to Hr_Employee_Api.Create_Employee:');
5643: --hr_utility.trace('p_employee_number=>'|| g_per_rec.employee_number);
5644: --hr_utility.trace('p_assignment_number=>'|| g_asg_rec.assignment_number);
5645: --hr_utility.trace('assignment_sequence =>'|| g_asg_rec.assignment_sequence);
5646:
5639: g_add_rec.date_from := g_per_rec.start_date;
5640: g_add_rec.date_to := null;
5641:
5642: --hr_utility.trace('After Call to Hr_Employee_Api.Create_Employee:');
5643: --hr_utility.trace('p_employee_number=>'|| g_per_rec.employee_number);
5644: --hr_utility.trace('p_assignment_number=>'|| g_asg_rec.assignment_number);
5645: --hr_utility.trace('assignment_sequence =>'|| g_asg_rec.assignment_sequence);
5646:
5647: elsif p_action_mode = 'HIRE_PERSON_INTOEMP' then
5640: g_add_rec.date_to := null;
5641:
5642: --hr_utility.trace('After Call to Hr_Employee_Api.Create_Employee:');
5643: --hr_utility.trace('p_employee_number=>'|| g_per_rec.employee_number);
5644: --hr_utility.trace('p_assignment_number=>'|| g_asg_rec.assignment_number);
5645: --hr_utility.trace('assignment_sequence =>'|| g_asg_rec.assignment_sequence);
5646:
5647: elsif p_action_mode = 'HIRE_PERSON_INTOEMP' then
5648:
5641:
5642: --hr_utility.trace('After Call to Hr_Employee_Api.Create_Employee:');
5643: --hr_utility.trace('p_employee_number=>'|| g_per_rec.employee_number);
5644: --hr_utility.trace('p_assignment_number=>'|| g_asg_rec.assignment_number);
5645: --hr_utility.trace('assignment_sequence =>'|| g_asg_rec.assignment_sequence);
5646:
5647: elsif p_action_mode = 'HIRE_PERSON_INTOEMP' then
5648:
5649: Hire_Person_IntoEmp
5678:
5679: end if;
5680:
5681: if g_debug then
5682: hr_utility.set_location('..person_id : ' ||
5683: p_emp_api_out.person_id,20);
5684: hr_utility.set_location('..assignment_id : ' ||
5685: p_emp_api_out.assignment_id,20);
5686: hr_utility.set_location('..per_object_version_number : ' ||
5680:
5681: if g_debug then
5682: hr_utility.set_location('..person_id : ' ||
5683: p_emp_api_out.person_id,20);
5684: hr_utility.set_location('..assignment_id : ' ||
5685: p_emp_api_out.assignment_id,20);
5686: hr_utility.set_location('..per_object_version_number : ' ||
5687: p_emp_api_out.per_object_version_number,20);
5688: hr_utility.set_location('..asg_object_version_number : ' ||
5682: hr_utility.set_location('..person_id : ' ||
5683: p_emp_api_out.person_id,20);
5684: hr_utility.set_location('..assignment_id : ' ||
5685: p_emp_api_out.assignment_id,20);
5686: hr_utility.set_location('..per_object_version_number : ' ||
5687: p_emp_api_out.per_object_version_number,20);
5688: hr_utility.set_location('..asg_object_version_number : ' ||
5689: p_emp_api_out.asg_object_version_number,20);
5690: hr_utility.set_location('..per_effective_start_date : ' ||
5684: hr_utility.set_location('..assignment_id : ' ||
5685: p_emp_api_out.assignment_id,20);
5686: hr_utility.set_location('..per_object_version_number : ' ||
5687: p_emp_api_out.per_object_version_number,20);
5688: hr_utility.set_location('..asg_object_version_number : ' ||
5689: p_emp_api_out.asg_object_version_number,20);
5690: hr_utility.set_location('..per_effective_start_date : ' ||
5691: p_emp_api_out.per_effective_start_date,20);
5692: hr_utility.set_location('..per_effective_end_date : ' ||
5686: hr_utility.set_location('..per_object_version_number : ' ||
5687: p_emp_api_out.per_object_version_number,20);
5688: hr_utility.set_location('..asg_object_version_number : ' ||
5689: p_emp_api_out.asg_object_version_number,20);
5690: hr_utility.set_location('..per_effective_start_date : ' ||
5691: p_emp_api_out.per_effective_start_date,20);
5692: hr_utility.set_location('..per_effective_end_date : ' ||
5693: p_emp_api_out.per_effective_end_date,20);
5694: hr_utility.set_location('..full_name : ' ||
5688: hr_utility.set_location('..asg_object_version_number : ' ||
5689: p_emp_api_out.asg_object_version_number,20);
5690: hr_utility.set_location('..per_effective_start_date : ' ||
5691: p_emp_api_out.per_effective_start_date,20);
5692: hr_utility.set_location('..per_effective_end_date : ' ||
5693: p_emp_api_out.per_effective_end_date,20);
5694: hr_utility.set_location('..full_name : ' ||
5695: p_emp_api_out.full_name,20);
5696: hr_utility.set_location('..per_comment_id : ' ||
5690: hr_utility.set_location('..per_effective_start_date : ' ||
5691: p_emp_api_out.per_effective_start_date,20);
5692: hr_utility.set_location('..per_effective_end_date : ' ||
5693: p_emp_api_out.per_effective_end_date,20);
5694: hr_utility.set_location('..full_name : ' ||
5695: p_emp_api_out.full_name,20);
5696: hr_utility.set_location('..per_comment_id : ' ||
5697: p_emp_api_out.per_comment_id,20);
5698: hr_utility.set_location('..assignment_sequence : ' ||
5692: hr_utility.set_location('..per_effective_end_date : ' ||
5693: p_emp_api_out.per_effective_end_date,20);
5694: hr_utility.set_location('..full_name : ' ||
5695: p_emp_api_out.full_name,20);
5696: hr_utility.set_location('..per_comment_id : ' ||
5697: p_emp_api_out.per_comment_id,20);
5698: hr_utility.set_location('..assignment_sequence : ' ||
5699: p_emp_api_out.assignment_sequence,20);
5700: hr_utility.set_location('..assignment_number : ' ||
5694: hr_utility.set_location('..full_name : ' ||
5695: p_emp_api_out.full_name,20);
5696: hr_utility.set_location('..per_comment_id : ' ||
5697: p_emp_api_out.per_comment_id,20);
5698: hr_utility.set_location('..assignment_sequence : ' ||
5699: p_emp_api_out.assignment_sequence,20);
5700: hr_utility.set_location('..assignment_number : ' ||
5701: p_emp_api_out.assignment_number,20);
5702: end if;
5696: hr_utility.set_location('..per_comment_id : ' ||
5697: p_emp_api_out.per_comment_id,20);
5698: hr_utility.set_location('..assignment_sequence : ' ||
5699: p_emp_api_out.assignment_sequence,20);
5700: hr_utility.set_location('..assignment_number : ' ||
5701: p_emp_api_out.assignment_number,20);
5702: end if;
5703:
5704: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
5700: hr_utility.set_location('..assignment_number : ' ||
5701: p_emp_api_out.assignment_number,20);
5702: end if;
5703:
5704: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
5705:
5706: exception
5707: when Others then
5708: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
5704: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
5705:
5706: exception
5707: when Others then
5708: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
5709: raise;
5710:
5711: end InsUpd_Employee;
5712:
5739:
5740: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Applicant';
5741:
5742: begin
5743: hr_utility.set_location('Entering: ' || l_proc_name, 10);
5744:
5745: Get_DataTrack_Mode
5746: (p_datetrack_update_mode => l_datetrack_update_mode
5747: );
5747: );
5748:
5749: if p_action_mode ='CREATE_APPLICANT' then
5750:
5751: --hr_utility.trace('Before CREATE_APPLICANT');
5752:
5753: HR_Applicant_API.Create_Applicant
5754: (p_validate => p_validate
5755: ,p_date_received => g_per_rec.start_date
5883: ,p_orig_hire_warning => p_appl_api_out.orig_hire_warning
5884: );
5885:
5886:
5887: --hr_utility.trace('After CREATE_APPLICANT Value of l_application_id'||l_application_id);
5888:
5889: g_asg_rec.application_id := l_application_id; -- Change by pkagrawa
5890: --
5891: -- Person record
6068:
6069: end if;
6070:
6071: if g_debug then
6072: hr_utility.set_location('..person_id : ' ||
6073: p_appl_api_out.person_id,20);
6074: hr_utility.set_location('..assignment_id : ' ||
6075: p_appl_api_out.assignment_id,20);
6076: hr_utility.set_location('..per_object_version_number : ' ||
6070:
6071: if g_debug then
6072: hr_utility.set_location('..person_id : ' ||
6073: p_appl_api_out.person_id,20);
6074: hr_utility.set_location('..assignment_id : ' ||
6075: p_appl_api_out.assignment_id,20);
6076: hr_utility.set_location('..per_object_version_number : ' ||
6077: p_appl_api_out.per_object_version_number,20);
6078: hr_utility.set_location('..asg_object_version_number : ' ||
6072: hr_utility.set_location('..person_id : ' ||
6073: p_appl_api_out.person_id,20);
6074: hr_utility.set_location('..assignment_id : ' ||
6075: p_appl_api_out.assignment_id,20);
6076: hr_utility.set_location('..per_object_version_number : ' ||
6077: p_appl_api_out.per_object_version_number,20);
6078: hr_utility.set_location('..asg_object_version_number : ' ||
6079: p_appl_api_out.asg_object_version_number,20);
6080: hr_utility.set_location('..per_effective_start_date : ' ||
6074: hr_utility.set_location('..assignment_id : ' ||
6075: p_appl_api_out.assignment_id,20);
6076: hr_utility.set_location('..per_object_version_number : ' ||
6077: p_appl_api_out.per_object_version_number,20);
6078: hr_utility.set_location('..asg_object_version_number : ' ||
6079: p_appl_api_out.asg_object_version_number,20);
6080: hr_utility.set_location('..per_effective_start_date : ' ||
6081: p_appl_api_out.per_effective_start_date,20);
6082: hr_utility.set_location('..per_effective_end_date : ' ||
6076: hr_utility.set_location('..per_object_version_number : ' ||
6077: p_appl_api_out.per_object_version_number,20);
6078: hr_utility.set_location('..asg_object_version_number : ' ||
6079: p_appl_api_out.asg_object_version_number,20);
6080: hr_utility.set_location('..per_effective_start_date : ' ||
6081: p_appl_api_out.per_effective_start_date,20);
6082: hr_utility.set_location('..per_effective_end_date : ' ||
6083: p_appl_api_out.per_effective_end_date,20);
6084: hr_utility.set_location('..full_name : ' ||
6078: hr_utility.set_location('..asg_object_version_number : ' ||
6079: p_appl_api_out.asg_object_version_number,20);
6080: hr_utility.set_location('..per_effective_start_date : ' ||
6081: p_appl_api_out.per_effective_start_date,20);
6082: hr_utility.set_location('..per_effective_end_date : ' ||
6083: p_appl_api_out.per_effective_end_date,20);
6084: hr_utility.set_location('..full_name : ' ||
6085: p_appl_api_out.full_name,20);
6086: hr_utility.set_location('..per_comment_id : ' ||
6080: hr_utility.set_location('..per_effective_start_date : ' ||
6081: p_appl_api_out.per_effective_start_date,20);
6082: hr_utility.set_location('..per_effective_end_date : ' ||
6083: p_appl_api_out.per_effective_end_date,20);
6084: hr_utility.set_location('..full_name : ' ||
6085: p_appl_api_out.full_name,20);
6086: hr_utility.set_location('..per_comment_id : ' ||
6087: p_appl_api_out.per_comment_id,20);
6088: hr_utility.set_location('..assignment_sequence : ' ||
6082: hr_utility.set_location('..per_effective_end_date : ' ||
6083: p_appl_api_out.per_effective_end_date,20);
6084: hr_utility.set_location('..full_name : ' ||
6085: p_appl_api_out.full_name,20);
6086: hr_utility.set_location('..per_comment_id : ' ||
6087: p_appl_api_out.per_comment_id,20);
6088: hr_utility.set_location('..assignment_sequence : ' ||
6089: p_appl_api_out.assignment_sequence,20);
6090: hr_utility.set_location('..assignment_number : ' ||
6084: hr_utility.set_location('..full_name : ' ||
6085: p_appl_api_out.full_name,20);
6086: hr_utility.set_location('..per_comment_id : ' ||
6087: p_appl_api_out.per_comment_id,20);
6088: hr_utility.set_location('..assignment_sequence : ' ||
6089: p_appl_api_out.assignment_sequence,20);
6090: hr_utility.set_location('..assignment_number : ' ||
6091: p_appl_api_out.assignment_number,20);
6092: end if;
6086: hr_utility.set_location('..per_comment_id : ' ||
6087: p_appl_api_out.per_comment_id,20);
6088: hr_utility.set_location('..assignment_sequence : ' ||
6089: p_appl_api_out.assignment_sequence,20);
6090: hr_utility.set_location('..assignment_number : ' ||
6091: p_appl_api_out.assignment_number,20);
6092: end if;
6093:
6094: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6090: hr_utility.set_location('..assignment_number : ' ||
6091: p_appl_api_out.assignment_number,20);
6092: end if;
6093:
6094: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6095:
6096: exception
6097: when Others then
6098: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
6094: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6095:
6096: exception
6097: when Others then
6098: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
6099: raise;
6100:
6101: end InsUpd_Applicant;
6102: -- =============================================================================
6116: l_datetrack_update_mode varchar2(150);
6117: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Contingent_Worker';
6118:
6119: begin
6120: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6121:
6122: Get_DataTrack_Mode
6123: (p_datetrack_update_mode => l_datetrack_update_mode
6124: );
6122: Get_DataTrack_Mode
6123: (p_datetrack_update_mode => l_datetrack_update_mode
6124: );
6125:
6126: --hr_utility.trace('Inside InsUpd_Contingent_Worker before CREATE_CWK');
6127: --hr_utility.trace('p_person_type_id'||g_per_rec.person_type_id);
6128:
6129: if p_action_mode ='CREATE_CWK' then
6130:
6123: (p_datetrack_update_mode => l_datetrack_update_mode
6124: );
6125:
6126: --hr_utility.trace('Inside InsUpd_Contingent_Worker before CREATE_CWK');
6127: --hr_utility.trace('p_person_type_id'||g_per_rec.person_type_id);
6128:
6129: if p_action_mode ='CREATE_CWK' then
6130:
6131: HR_Contingent_Worker_API.Create_CWK
6369: g_add_rec.date_to := null;
6370: end if;
6371:
6372: if g_debug then
6373: hr_utility.set_location('..person_id : ' ||
6374: p_cwk_api_out.person_id,20);
6375: hr_utility.set_location('..assignment_id : ' ||
6376: p_cwk_api_out.assignment_id,20);
6377: hr_utility.set_location('..per_object_version_number : ' ||
6371:
6372: if g_debug then
6373: hr_utility.set_location('..person_id : ' ||
6374: p_cwk_api_out.person_id,20);
6375: hr_utility.set_location('..assignment_id : ' ||
6376: p_cwk_api_out.assignment_id,20);
6377: hr_utility.set_location('..per_object_version_number : ' ||
6378: p_cwk_api_out.per_object_version_number,20);
6379: hr_utility.set_location('..asg_object_version_number : ' ||
6373: hr_utility.set_location('..person_id : ' ||
6374: p_cwk_api_out.person_id,20);
6375: hr_utility.set_location('..assignment_id : ' ||
6376: p_cwk_api_out.assignment_id,20);
6377: hr_utility.set_location('..per_object_version_number : ' ||
6378: p_cwk_api_out.per_object_version_number,20);
6379: hr_utility.set_location('..asg_object_version_number : ' ||
6380: p_cwk_api_out.asg_object_version_number,20);
6381: hr_utility.set_location('..per_effective_start_date : ' ||
6375: hr_utility.set_location('..assignment_id : ' ||
6376: p_cwk_api_out.assignment_id,20);
6377: hr_utility.set_location('..per_object_version_number : ' ||
6378: p_cwk_api_out.per_object_version_number,20);
6379: hr_utility.set_location('..asg_object_version_number : ' ||
6380: p_cwk_api_out.asg_object_version_number,20);
6381: hr_utility.set_location('..per_effective_start_date : ' ||
6382: p_cwk_api_out.per_effective_start_date,20);
6383: hr_utility.set_location('..per_effective_end_date : ' ||
6377: hr_utility.set_location('..per_object_version_number : ' ||
6378: p_cwk_api_out.per_object_version_number,20);
6379: hr_utility.set_location('..asg_object_version_number : ' ||
6380: p_cwk_api_out.asg_object_version_number,20);
6381: hr_utility.set_location('..per_effective_start_date : ' ||
6382: p_cwk_api_out.per_effective_start_date,20);
6383: hr_utility.set_location('..per_effective_end_date : ' ||
6384: p_cwk_api_out.per_effective_end_date,20);
6385: hr_utility.set_location('..full_name : ' ||
6379: hr_utility.set_location('..asg_object_version_number : ' ||
6380: p_cwk_api_out.asg_object_version_number,20);
6381: hr_utility.set_location('..per_effective_start_date : ' ||
6382: p_cwk_api_out.per_effective_start_date,20);
6383: hr_utility.set_location('..per_effective_end_date : ' ||
6384: p_cwk_api_out.per_effective_end_date,20);
6385: hr_utility.set_location('..full_name : ' ||
6386: p_cwk_api_out.full_name,20);
6387: hr_utility.set_location('..per_comment_id : ' ||
6381: hr_utility.set_location('..per_effective_start_date : ' ||
6382: p_cwk_api_out.per_effective_start_date,20);
6383: hr_utility.set_location('..per_effective_end_date : ' ||
6384: p_cwk_api_out.per_effective_end_date,20);
6385: hr_utility.set_location('..full_name : ' ||
6386: p_cwk_api_out.full_name,20);
6387: hr_utility.set_location('..per_comment_id : ' ||
6388: p_cwk_api_out.per_comment_id,20);
6389: hr_utility.set_location('..assignment_sequence : ' ||
6383: hr_utility.set_location('..per_effective_end_date : ' ||
6384: p_cwk_api_out.per_effective_end_date,20);
6385: hr_utility.set_location('..full_name : ' ||
6386: p_cwk_api_out.full_name,20);
6387: hr_utility.set_location('..per_comment_id : ' ||
6388: p_cwk_api_out.per_comment_id,20);
6389: hr_utility.set_location('..assignment_sequence : ' ||
6390: p_cwk_api_out.assignment_sequence,20);
6391: hr_utility.set_location('..assignment_number : ' ||
6385: hr_utility.set_location('..full_name : ' ||
6386: p_cwk_api_out.full_name,20);
6387: hr_utility.set_location('..per_comment_id : ' ||
6388: p_cwk_api_out.per_comment_id,20);
6389: hr_utility.set_location('..assignment_sequence : ' ||
6390: p_cwk_api_out.assignment_sequence,20);
6391: hr_utility.set_location('..assignment_number : ' ||
6392: p_cwk_api_out.assignment_number,20);
6393: end if;
6387: hr_utility.set_location('..per_comment_id : ' ||
6388: p_cwk_api_out.per_comment_id,20);
6389: hr_utility.set_location('..assignment_sequence : ' ||
6390: p_cwk_api_out.assignment_sequence,20);
6391: hr_utility.set_location('..assignment_number : ' ||
6392: p_cwk_api_out.assignment_number,20);
6393: end if;
6394:
6395: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6391: hr_utility.set_location('..assignment_number : ' ||
6392: p_cwk_api_out.assignment_number,20);
6393: end if;
6394:
6395: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6396:
6397: exception
6398: when Others then
6399: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
6395: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6396:
6397: exception
6398: when Others then
6399: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
6400: raise;
6401:
6402: end InsUpd_Contingent_Worker;
6403: -- =============================================================================
6412:
6413: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Contact_Person';
6414:
6415: begin
6416: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6417:
6418: Hr_Contact_Api.Create_Person
6419: (p_validate => p_validate
6420: ,p_start_date => g_per_rec.start_date
6539: g_add_rec.date_from := g_per_rec.start_date;
6540: g_add_rec.date_to := null;
6541:
6542: if g_debug then
6543: hr_utility.set_location('..person_id : ' ||
6544: p_contact_api_out.person_id,20);
6545: hr_utility.set_location('..per_object_version_number : ' ||
6546: p_contact_api_out.per_object_version_number,20);
6547: hr_utility.set_location('..per_effective_start_date : ' ||
6541:
6542: if g_debug then
6543: hr_utility.set_location('..person_id : ' ||
6544: p_contact_api_out.person_id,20);
6545: hr_utility.set_location('..per_object_version_number : ' ||
6546: p_contact_api_out.per_object_version_number,20);
6547: hr_utility.set_location('..per_effective_start_date : ' ||
6548: p_contact_api_out.per_effective_start_date,20);
6549: hr_utility.set_location('..per_effective_end_date : ' ||
6543: hr_utility.set_location('..person_id : ' ||
6544: p_contact_api_out.person_id,20);
6545: hr_utility.set_location('..per_object_version_number : ' ||
6546: p_contact_api_out.per_object_version_number,20);
6547: hr_utility.set_location('..per_effective_start_date : ' ||
6548: p_contact_api_out.per_effective_start_date,20);
6549: hr_utility.set_location('..per_effective_end_date : ' ||
6550: p_contact_api_out.per_effective_end_date,20);
6551: hr_utility.set_location('..full_name : ' ||
6545: hr_utility.set_location('..per_object_version_number : ' ||
6546: p_contact_api_out.per_object_version_number,20);
6547: hr_utility.set_location('..per_effective_start_date : ' ||
6548: p_contact_api_out.per_effective_start_date,20);
6549: hr_utility.set_location('..per_effective_end_date : ' ||
6550: p_contact_api_out.per_effective_end_date,20);
6551: hr_utility.set_location('..full_name : ' ||
6552: p_contact_api_out.full_name,20);
6553: hr_utility.set_location('..per_comment_id : ' ||
6547: hr_utility.set_location('..per_effective_start_date : ' ||
6548: p_contact_api_out.per_effective_start_date,20);
6549: hr_utility.set_location('..per_effective_end_date : ' ||
6550: p_contact_api_out.per_effective_end_date,20);
6551: hr_utility.set_location('..full_name : ' ||
6552: p_contact_api_out.full_name,20);
6553: hr_utility.set_location('..per_comment_id : ' ||
6554: p_contact_api_out.per_comment_id,20);
6555: end if;
6549: hr_utility.set_location('..per_effective_end_date : ' ||
6550: p_contact_api_out.per_effective_end_date,20);
6551: hr_utility.set_location('..full_name : ' ||
6552: p_contact_api_out.full_name,20);
6553: hr_utility.set_location('..per_comment_id : ' ||
6554: p_contact_api_out.per_comment_id,20);
6555: end if;
6556:
6557: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6553: hr_utility.set_location('..per_comment_id : ' ||
6554: p_contact_api_out.per_comment_id,20);
6555: end if;
6556:
6557: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6558:
6559: exception
6560: when Others then
6561: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
6557: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
6558:
6559: exception
6560: when Others then
6561: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
6562: raise;
6563:
6564: end InsUpd_Contact_Person;
6565: -- =============================================================================
6576:
6577: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Batch_Employee_Asg';
6578:
6579: begin
6580: hr_utility.set_location('Entering: ' || l_proc_name, 5);
6581:
6582: --$ Update Assignment only if User wants to i.e. he has chosen mandatory column
6583: -- 'Assign Organization' in the layout and entered a value
6584: if (g_asg_rec.organization_id is NULL) then
6581:
6582: --$ Update Assignment only if User wants to i.e. he has chosen mandatory column
6583: -- 'Assign Organization' in the layout and entered a value
6584: if (g_asg_rec.organization_id is NULL) then
6585: Hr_Utility.set_location('Leaving: '||l_proc_name, 6);
6586: return;
6587: end if;
6588:
6589: --$ Upload supervisor id
6697: );
6698:
6699: p_user_sequence := p_user_sequence + 1;
6700:
6701: hr_utility.set_location('..Inserted into Hrdpp_Update_Emp_Asg', 10);
6702:
6703: Hrdpp_Update_Emp_Asg_Criteria.Insert_Batch_Lines
6704: (p_batch_id => p_batch_id
6705: ,p_user_sequence => p_user_sequence
6750: ,P_EMPLOYMENT_CATEGORY => g_asg_rec.assignment_category
6751: ,p_language_code => userenv('LANG')
6752: ,p_con_seg_user_name => null
6753: );
6754: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
6755:
6756: end Upd_Batch_Employee_Asg;
6757: -- =============================================================================
6758: -- Update_Batch_Assignment:
6792: --$
6793: e_sec_asg exception;
6794: l_error_mesg varchar2(2000);
6795: begin
6796: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
6797:
6798: if g_asg_rec.organization_id is null or
6799: --$ Commented the following condition
6800: -- g_asg_rec.assignment_status_type_id is null or
6798: if g_asg_rec.organization_id is null or
6799: --$ Commented the following condition
6800: -- g_asg_rec.assignment_status_type_id is null or
6801: g_asg_rec.assignment_number is null then
6802: Hr_Utility.set_location('Leaving: '||l_proc_name, 6);
6803: return;
6804: end if;
6805:
6806: open csr_asg (c_assignment_number => g_asg_rec.assignment_number
6810: );
6811: fetch csr_asg into l_asg_rec;
6812: if csr_asg%notfound then
6813: close csr_asg;
6814: Hr_Utility.set_location('Leaving: '||l_proc_name, 7);
6815: --$
6816: l_error_mesg := 'Use direct API mode to create secondary assignments';
6817: raise e_sec_asg;
6818: return;
6837: elsif l_dt_upd_override or
6838: l_upd_chg_ins then
6839: --Else USE Correction Mode
6840: l_datetrack_update_mode := 'CORRECTION';
6841: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 8);
6842: else
6843: l_datetrack_update_mode := 'CORRECTION';
6844: end if;
6845: end if;
6868: elsif l_asg_rec.assignment_type ='A' then
6869: null;
6870: end if;
6871:
6872: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
6873:
6874: --$
6875: exception
6876: when e_sec_asg then
6873:
6874: --$
6875: exception
6876: when e_sec_asg then
6877: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
6878: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
6879: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
6880: hr_utility.raise_error;
6881: end Update_Batch_Assignment;
6874: --$
6875: exception
6876: when e_sec_asg then
6877: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
6878: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
6879: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
6880: hr_utility.raise_error;
6881: end Update_Batch_Assignment;
6882:
6875: exception
6876: when e_sec_asg then
6877: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
6878: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
6879: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
6880: hr_utility.raise_error;
6881: end Update_Batch_Assignment;
6882:
6883: -- =============================================================================
6876: when e_sec_asg then
6877: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
6878: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
6879: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
6880: hr_utility.raise_error;
6881: end Update_Batch_Assignment;
6882:
6883: -- =============================================================================
6884: -- DataPump_API_Call: p_data_pump_batch_line_id is used as link_value_id in the
6933: e_hire_applicant exception;
6934: e_apply_for_job exception;
6935: e_cwk exception;
6936: begin
6937: hr_utility.set_location('Entering: ' || l_proc_name, 5);
6938:
6939: l_user_sequence := 1;
6940: --
6941: -- Creating User Keys for Person, Address, Assignment and Contact
6945: DBMS_Utility.get_Hash_Value(g_per_rec.last_name||
6946: g_per_rec.sex||
6947: g_per_rec.first_name,0,1000);
6948:
6949: --hr_utility.trace('p_batch_id: '||p_batch_id);
6950:
6951: l_person_user_key := 'HROSS~PER~'||l_temp;
6952: l_address_user_key := 'HROSS~ADD~'||l_temp;
6953: l_assignment_user_key := 'HROSS~ASG~'||l_temp;
6957: --$ To upload supervisor id use global var
6958: g_supervisor_user_key := 'HROSS~SUP~'||l_temp;
6959:
6960: if g_debug then
6961: hr_utility.set_location(' l_person_user_key: ' || l_person_user_key, 10);
6962: hr_utility.set_location(' l_address_user_key: ' || l_address_user_key, 10);
6963: hr_utility.set_location(' l_assignment_user_key: ' || l_assignment_user_key, 10);
6964: hr_utility.set_location(' l_contact_key: ' || l_contact_key, 10);
6965: hr_utility.set_location(' l_xtra_info_key: ' || l_xtra_info_key, 10);
6958: g_supervisor_user_key := 'HROSS~SUP~'||l_temp;
6959:
6960: if g_debug then
6961: hr_utility.set_location(' l_person_user_key: ' || l_person_user_key, 10);
6962: hr_utility.set_location(' l_address_user_key: ' || l_address_user_key, 10);
6963: hr_utility.set_location(' l_assignment_user_key: ' || l_assignment_user_key, 10);
6964: hr_utility.set_location(' l_contact_key: ' || l_contact_key, 10);
6965: hr_utility.set_location(' l_xtra_info_key: ' || l_xtra_info_key, 10);
6966: end if;
6959:
6960: if g_debug then
6961: hr_utility.set_location(' l_person_user_key: ' || l_person_user_key, 10);
6962: hr_utility.set_location(' l_address_user_key: ' || l_address_user_key, 10);
6963: hr_utility.set_location(' l_assignment_user_key: ' || l_assignment_user_key, 10);
6964: hr_utility.set_location(' l_contact_key: ' || l_contact_key, 10);
6965: hr_utility.set_location(' l_xtra_info_key: ' || l_xtra_info_key, 10);
6966: end if;
6967: --
6960: if g_debug then
6961: hr_utility.set_location(' l_person_user_key: ' || l_person_user_key, 10);
6962: hr_utility.set_location(' l_address_user_key: ' || l_address_user_key, 10);
6963: hr_utility.set_location(' l_assignment_user_key: ' || l_assignment_user_key, 10);
6964: hr_utility.set_location(' l_contact_key: ' || l_contact_key, 10);
6965: hr_utility.set_location(' l_xtra_info_key: ' || l_xtra_info_key, 10);
6966: end if;
6967: --
6968: -- Get the User Person Type for the id passed
6961: hr_utility.set_location(' l_person_user_key: ' || l_person_user_key, 10);
6962: hr_utility.set_location(' l_address_user_key: ' || l_address_user_key, 10);
6963: hr_utility.set_location(' l_assignment_user_key: ' || l_assignment_user_key, 10);
6964: hr_utility.set_location(' l_contact_key: ' || l_contact_key, 10);
6965: hr_utility.set_location(' l_xtra_info_key: ' || l_xtra_info_key, 10);
6966: end if;
6967: --
6968: -- Get the User Person Type for the id passed
6969: --
7001: l_link_value := p_batch_link;
7002: end if;
7003:
7004: if g_debug then
7005: hr_utility.set_location(' l_user_person_type: '|| l_user_person_type, 15);
7006: hr_utility.set_location(' l_link_value: '|| l_link_value, 15);
7007: end if;
7008:
7009: --$ Get the value of "Benefit Group Name" from ID if not null
7002: end if;
7003:
7004: if g_debug then
7005: hr_utility.set_location(' l_user_person_type: '|| l_user_person_type, 15);
7006: hr_utility.set_location(' l_link_value: '|| l_link_value, 15);
7007: end if;
7008:
7009: --$ Get the value of "Benefit Group Name" from ID if not null
7010: if g_per_rec.benefit_group_id is not null then
7038: ,p_Convert_To_CWK => l_Convert_To_CWK
7039: ,p_Per_Exists_InHR => l_Per_Exists_InHR
7040: );
7041: --
7042: --hr_utility.trace(' After Chk_Person_InHR call');
7043: --hr_utility.trace('$$_PSG l_Input_PerType ='||l_Input_PerType);
7044:
7045: Get_DataTrack_Mode
7046: (p_datetrack_update_mode => l_datetrack_update_mode
7039: ,p_Per_Exists_InHR => l_Per_Exists_InHR
7040: );
7041: --
7042: --hr_utility.trace(' After Chk_Person_InHR call');
7043: --hr_utility.trace('$$_PSG l_Input_PerType ='||l_Input_PerType);
7044:
7045: Get_DataTrack_Mode
7046: (p_datetrack_update_mode => l_datetrack_update_mode
7047: );
7046: (p_datetrack_update_mode => l_datetrack_update_mode
7047: );
7048: --
7049: if g_debug then
7050: hr_utility.set_location(' p_batch_id : ' || p_batch_id, 20);
7051: hr_utility.set_location(' l_user_sequence: ' || l_user_sequence, 20);
7052: hr_utility.set_location(' l_link_value : ' || l_link_value, 20);
7053: hr_utility.set_location(' l_datetrack_update_mode: ' || l_datetrack_update_mode, 20);
7054: end if;
7047: );
7048: --
7049: if g_debug then
7050: hr_utility.set_location(' p_batch_id : ' || p_batch_id, 20);
7051: hr_utility.set_location(' l_user_sequence: ' || l_user_sequence, 20);
7052: hr_utility.set_location(' l_link_value : ' || l_link_value, 20);
7053: hr_utility.set_location(' l_datetrack_update_mode: ' || l_datetrack_update_mode, 20);
7054: end if;
7055: --
7048: --
7049: if g_debug then
7050: hr_utility.set_location(' p_batch_id : ' || p_batch_id, 20);
7051: hr_utility.set_location(' l_user_sequence: ' || l_user_sequence, 20);
7052: hr_utility.set_location(' l_link_value : ' || l_link_value, 20);
7053: hr_utility.set_location(' l_datetrack_update_mode: ' || l_datetrack_update_mode, 20);
7054: end if;
7055: --
7056: -- Update existing person
7049: if g_debug then
7050: hr_utility.set_location(' p_batch_id : ' || p_batch_id, 20);
7051: hr_utility.set_location(' l_user_sequence: ' || l_user_sequence, 20);
7052: hr_utility.set_location(' l_link_value : ' || l_link_value, 20);
7053: hr_utility.set_location(' l_datetrack_update_mode: ' || l_datetrack_update_mode, 20);
7054: end if;
7055: --
7056: -- Update existing person
7057: --
7128: else
7129: raise e_crt_per_not_allowed;
7130: end if;
7131: end if;
7132: hr_utility.set_location(l_proc_name, 25);
7133: --
7134:
7135: --hr_utility.trace(' l_action_mode ='||l_action_mode);
7136:
7131: end if;
7132: hr_utility.set_location(l_proc_name, 25);
7133: --
7134:
7135: --hr_utility.trace(' l_action_mode ='||l_action_mode);
7136:
7137: if l_action_mode in ('CREATE_EMPLOYEE',
7138: 'HIRE_INTO_JOB') then
7139: InsUpd_Batch_Employee
7154: end if;
7155: --
7156: -- Insert/Update Person Primary Address
7157: --
7158: hr_utility.set_location(l_proc_name, 30);
7159: l_user_sequence := l_user_sequence + 1;
7160: --
7161: -- Insert/Update Primary Address
7162: --
7169: );
7170: --
7171: -- Update the Employee Assignment
7172: --
7173: hr_utility.set_location(l_proc_name, 35);
7174: l_datetrack_update_mode := 'CORRECTION';
7175: l_user_sequence := l_user_sequence + 1;
7176:
7177: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
7189: end if;
7190: --
7191: -- Creating an Applicant for a Job
7192: --
7193: --hr_utility.trace(' l_Input_PerType ='||l_Input_PerType);
7194:
7195: if l_Input_PerType = 'APL' then
7196: if l_Convert_To_Applicant or
7197: l_Apply_ForJob then
7223: );
7224: --
7225: -- Insert/Update Person Primary Address
7226: --
7227: hr_utility.set_location(l_proc_name, 30);
7228: l_user_sequence := l_user_sequence + 1;
7229:
7230: InsUpd_Batch_Address
7231: (p_batch_id => p_batch_id
7273: raise e_upl_not_allowed;
7274: end if;
7275: end if;
7276:
7277: hr_utility.set_location(l_proc_name, 30);
7278: l_user_sequence := l_user_sequence + 1;
7279: --
7280: -- Insert/Update Primary Address
7281: --
7311: -- Update the Contingent Worker assignment
7312: --
7313: end if;
7314:
7315: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
7316:
7317: exception
7318: when e_hire_applicant then
7319: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7315: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
7316:
7317: exception
7318: when e_hire_applicant then
7319: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7320: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7321: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7322: hr_utility.raise_error;
7323: when e_apply_for_job then
7316:
7317: exception
7318: when e_hire_applicant then
7319: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7320: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7321: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7322: hr_utility.raise_error;
7323: when e_apply_for_job then
7324: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7317: exception
7318: when e_hire_applicant then
7319: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7320: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7321: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7322: hr_utility.raise_error;
7323: when e_apply_for_job then
7324: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7325: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7318: when e_hire_applicant then
7319: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7320: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7321: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7322: hr_utility.raise_error;
7323: when e_apply_for_job then
7324: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7325: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7326: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7320: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7321: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7322: hr_utility.raise_error;
7323: when e_apply_for_job then
7324: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7325: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7326: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7327: hr_utility.raise_error;
7328: when e_cwk then
7321: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7322: hr_utility.raise_error;
7323: when e_apply_for_job then
7324: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7325: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7326: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7327: hr_utility.raise_error;
7328: when e_cwk then
7329: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7322: hr_utility.raise_error;
7323: when e_apply_for_job then
7324: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7325: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7326: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7327: hr_utility.raise_error;
7328: when e_cwk then
7329: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7330: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7323: when e_apply_for_job then
7324: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7325: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7326: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7327: hr_utility.raise_error;
7328: when e_cwk then
7329: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7330: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7331: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7325: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7326: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7327: hr_utility.raise_error;
7328: when e_cwk then
7329: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7330: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7331: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7332: hr_utility.raise_error;
7333: when Others then
7326: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7327: hr_utility.raise_error;
7328: when e_cwk then
7329: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7330: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7331: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7332: hr_utility.raise_error;
7333: when Others then
7334: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7327: hr_utility.raise_error;
7328: when e_cwk then
7329: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7330: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7331: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7332: hr_utility.raise_error;
7333: when Others then
7334: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7335: raise;
7328: when e_cwk then
7329: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7330: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7331: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7332: hr_utility.raise_error;
7333: when Others then
7334: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7335: raise;
7336:
7330: hr_utility.set_message_token('GENERIC_TOKEN',l_error_mesg);
7331: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7332: hr_utility.raise_error;
7333: when Others then
7334: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
7335: raise;
7336:
7337: end DataPump_API_Call;
7338:
7477:
7478: l_pradd_ovlapval_override boolean;
7479:
7480: begin
7481: hr_utility.set_location('Entering: ' || l_proc_name, 10);
7482:
7483: -- Check if operation being corrected was insert or update because of
7484: -- duplicate person id based on the API_MODULE_ID in hr_pump_batch_lines
7485: -- and then set dp_mode flag respectively
8246: end loop;
8247:
8248: close csr_get_api_names;
8249:
8250: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
8251:
8252: exception
8253: when Others then
8254: if csr_get_api_names%isopen then
8253: when Others then
8254: if csr_get_api_names%isopen then
8255: close csr_get_api_names;
8256: end if;
8257: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
8258: raise;
8259:
8260: end HR_DataPumpErr;
8261:
8272:
8273: l_proc_name constant varchar2(150):= g_pkg ||'Create_Person_Contact';
8274:
8275: begin
8276: hr_utility.set_location('Entering: ' || l_proc_name, 10);
8277:
8278: Hr_Contact_Rel_Api.create_contact
8279: (p_start_date => p_effective_date
8280: ,p_business_group_id => g_cnt_rec.business_group_id
8295: ,p_name_combination_warning => p_crt_cntct_out.name_combination_warning
8296: ,p_orig_hire_warning => p_crt_cntct_out.orig_hire_warning
8297: );
8298:
8299: hr_utility.set_location('Leaving: ' || l_proc_name, 20);
8300:
8301: end Create_Person_Contact;
8302: */
8303: -- =============================================================================
8312:
8313: l_cont_object_version_num number;
8314: l_proc_name constant varchar2(150):= g_pkg ||'Update_Person_Contact';
8315: begin
8316: hr_utility.set_location('Entering: ' || l_proc_name, 10);
8317:
8318: open csr_ck_cont_xsts(c_person_id => g_per_rec.person_id
8319: ,c_business_group_id => g_add_rec.business_group_id
8320: ,c_effective_date => g_per_rec.start_date);
8372: );
8373:
8374: end if;
8375:
8376: hr_utility.set_location('Leaving: ' || l_proc_name, 20);
8377:
8378: end Update_Person_Contact;
8379:
8380: -- =============================================================================
8397: l_proc_name constant varchar2(170):= g_pkg ||'Create_DataPump_BatchHeader';
8398: l_reference varchar2(80);
8399:
8400: begin
8401: hr_utility.set_location('Entering: ' || l_proc_name, 10);
8402: select hr_pump_batch_headers_s.nextval
8403: into p_batch_process_id
8404: from dual;
8405: --
8446: ,l_bg_name
8447: --,nvl(l_bg_name,'PQPD115 Business Group') -- remove the NVL()
8448: ,l_reference);
8449:
8450: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
8451:
8452: end Create_DataPump_BatchHeader;
8453: -- =============================================================================
8454: -- Update_Assignment:
8503: l_scl_rec hr_soft_coding_keyflex%rowtype;
8504: l_pty_rec csr_type%rowtype;
8505: l_apl_asg_rec per_all_assignments_f%rowtype;
8506: begin
8507: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
8508:
8509: --$ check already made before making call to this procedure from
8510: --the procedure Direct_API_Call. Also as for "APPLICANT" assignment_number
8511: -- will always be null hence should not be included in the check condition.
8513: /*
8514: if g_asg_rec.organization_id is null or
8515: g_asg_rec.assignment_status_type_id is null or
8516: g_asg_rec.assignment_number is null then
8517: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
8518: return;
8519: end if;
8520: */
8521:
8526: );
8527: fetch csr_asg into l_asg_rec;
8528:
8529:
8530: /*hr_utility.trace('CURSOR : select * from per_all_assignments_f paf
8531: where paf.person_id =' ||p_person_id || 'and paf.assignment_number = ' ||
8532: g_asg_rec.assignment_number || 'and paf.business_group_id = ' || p_business_group_id
8533: || 'and ' || sysdate|| ' between paf.effective_start_date
8534: and paf.effective_end_date' );*/
8887: g_asg_rec.assignment_status_type_id := l_asg_rec.assignment_status_type_id;
8888: end if;
8889: close csr_asg;
8890:
8891: --hr_utility.trace('BEFORE ENTERING Update_Employee_Asg with assntype as E' );
8892:
8893: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
8894: if l_asg_rec.assignment_type ='E' then
8895: Update_Employee_Asg
8896: (p_effective_date => p_effective_date
8897: ,p_asg_crit_out => l_AsgUpdCrit_Api
8898: );
8899:
8900: --hr_utility.trace('AFTER Update_Employee_Asg with assntype as E' );
8901:
8902: elsif l_asg_rec.assignment_type ='C' then
8903: Upd_Contingent_Asg
8904: (p_effective_date => p_effective_date
8913: else
8914: raise e_upl_not_allowed;
8915: end if;
8916:
8917: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
8918:
8919: end Update_Assignment;
8920: -- =============================================================================
8921: -- Direct_API_Call:
8945: l_action_mode varchar2(90);
8946: l_proc_name constant varchar2(150) := g_pkg||'Direct_API_Call';
8947:
8948: begin
8949: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
8950: --
8951: -- If person id is passed check the creating person type with the person
8952: -- type of the person present in HRMS, to select the appropiate action.
8953: --
8950: --
8951: -- If person id is passed check the creating person type with the person
8952: -- type of the person present in HRMS, to select the appropiate action.
8953: --
8954: --hr_utility.trace('Inside Direct_API_Call');
8955:
8956: Chk_Person_InHR
8957: (p_dup_person_id => p_dup_person_id
8958: ,p_dup_party_id => p_dup_party_id
8970: --
8971: -- Creating an Employee
8972: --
8973:
8974: --hr_utility.trace(' l_Input_PerType='||l_Input_PerType);
8975:
8976: if l_Input_PerType = 'EMP' then
8977:
8978: --hr_utility.trace(' Inside PerType=EMP');
8974: --hr_utility.trace(' l_Input_PerType='||l_Input_PerType);
8975:
8976: if l_Input_PerType = 'EMP' then
8977:
8978: --hr_utility.trace(' Inside PerType=EMP');
8979:
8980: if l_hire_Into_Employee then
8981: if (g_crt_upd = 'C') then
8982: l_action_mode := 'HIRE_PERSON_INTOEMP';
8996: raise e_crt_per_not_allowed;
8997: end if;
8998: end if;
8999: --
9000: --hr_utility.trace(' l_action_mode='||l_action_mode);
9001:
9002: if l_action_mode in ('CREATE_EMPLOYEE',
9003: 'HIRE_PERSON_INTOEMP') then
9004: InsUpd_Employee
9055: -- Creating a Contingent Worker
9056: --
9057: if l_Input_PerType = 'CWK' then
9058:
9059: --hr_utility.trace(' Inside PerType=CWK');
9060:
9061: if l_Convert_To_CWK then
9062: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
9063: l_action_mode := 'CONVERT_TO_CWK';
9116:
9117:
9118: if l_Input_PerType = 'APL' then
9119:
9120: --hr_utility.trace(' Inside PerType=APL');
9121:
9122: if l_Convert_To_Applicant or
9123: l_Apply_ForJob then
9124: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
9179: --
9180:
9181: if l_Input_PerType = 'OTHER' then
9182:
9183: --hr_utility.trace('Inside PerType=OTHER');
9184:
9185: if not l_Per_Exists_InHR then
9186: if (g_crt_upd = 'C') then
9187: InsUpd_Contact_Person
9224: --
9225:
9226: if l_Input_PerType = 'UPD_PERSON' then
9227:
9228: --hr_utility.trace(' Inside PerType=UPD_PERSON');
9229: if (g_crt_upd = 'C' or g_crt_upd = 'U') then
9230: Upd_Person_Details
9231: (p_validate => false
9232: ,p_effective_date => p_effective_date
9265: end if;
9266:
9267: end if;
9268:
9269: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
9270:
9271: end Direct_API_Call;
9272:
9273: -- =============================================================================
9312: l_apl_asg_id number;
9313: l_proc_name constant varchar2(150) := g_pkg||'Get_AplAsg_Id';
9314:
9315: begin
9316: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
9317: if p_apl_asg_no is not null then
9318: open csr_asg (c_assignment_number => p_apl_asg_no
9319: ,c_person_id => p_person_id
9320: ,c_business_group_id => p_business_group_id
9345: close csr_asg_n;
9346: return l_apl_asg_id;
9347: end if;
9348:
9349: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
9350:
9351: end Get_AplAsg_Id;
9352: -- =============================================================================
9353: -- ~ InsUpd_PerAsgAdd_Rec:
9768:
9769: begin
9770:
9771: savepoint InsUpd_PerAsgAdd_Rec;
9772: g_debug := hr_utility.debug_enabled;
9773: hr_utility.set_location('Entering: ' || l_proc_name, 5);
9774:
9775: l_migration_allowed := SUBSTR(p_crt_upd,3,1);
9776: l_crt_upd := SUBSTR(p_crt_upd,1,1);
9769: begin
9770:
9771: savepoint InsUpd_PerAsgAdd_Rec;
9772: g_debug := hr_utility.debug_enabled;
9773: hr_utility.set_location('Entering: ' || l_proc_name, 5);
9774:
9775: l_migration_allowed := SUBSTR(p_crt_upd,3,1);
9776: l_crt_upd := SUBSTR(p_crt_upd,1,1);
9777: hr_utility.trace('l_crt_upd ='||l_crt_upd);
9773: hr_utility.set_location('Entering: ' || l_proc_name, 5);
9774:
9775: l_migration_allowed := SUBSTR(p_crt_upd,3,1);
9776: l_crt_upd := SUBSTR(p_crt_upd,1,1);
9777: hr_utility.trace('l_crt_upd ='||l_crt_upd);
9778:
9779: if (l_crt_upd is not null) then
9780: g_crt_upd := l_crt_upd;
9781: end if;
9789: -- People Group KFF and Assignment Soft Coding KFF records.
9790: --
9791:
9792:
9793: --hr_utility.trace_on(null,'TTT');
9794: --hr_utility.trace('employee_category='||p_employee_category);
9795: --hr_utility.trace('p_address_style = ' ||p_address_style);
9796: --hr_utility.trace('P_PRIMARY_FLAG = ' ||P_PRIMARY_FLAG);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9790: --
9791:
9792:
9793: --hr_utility.trace_on(null,'TTT');
9794: --hr_utility.trace('employee_category='||p_employee_category);
9795: --hr_utility.trace('p_address_style = ' ||p_address_style);
9796: --hr_utility.trace('P_PRIMARY_FLAG = ' ||P_PRIMARY_FLAG);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9798:
9791:
9792:
9793: --hr_utility.trace_on(null,'TTT');
9794: --hr_utility.trace('employee_category='||p_employee_category);
9795: --hr_utility.trace('p_address_style = ' ||p_address_style);
9796: --hr_utility.trace('P_PRIMARY_FLAG = ' ||P_PRIMARY_FLAG);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9798:
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9792:
9793: --hr_utility.trace_on(null,'TTT');
9794: --hr_utility.trace('employee_category='||p_employee_category);
9795: --hr_utility.trace('p_address_style = ' ||p_address_style);
9796: --hr_utility.trace('P_PRIMARY_FLAG = ' ||P_PRIMARY_FLAG);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9798:
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9793: --hr_utility.trace_on(null,'TTT');
9794: --hr_utility.trace('employee_category='||p_employee_category);
9795: --hr_utility.trace('p_address_style = ' ||p_address_style);
9796: --hr_utility.trace('P_PRIMARY_FLAG = ' ||P_PRIMARY_FLAG);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9798:
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9795: --hr_utility.trace('p_address_style = ' ||p_address_style);
9796: --hr_utility.trace('P_PRIMARY_FLAG = ' ||P_PRIMARY_FLAG);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9798:
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9796: --hr_utility.trace('P_PRIMARY_FLAG = ' ||P_PRIMARY_FLAG);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9798:
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9797: --hr_utility.trace('P_ADDRESS_DATE_FROM = ' ||P_ADDRESS_DATE_FROM);
9798:
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9798:
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9799: --hr_utility.trace('p_data_pump_flag .....' || p_data_pump_flag);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9800: --hr_utility.trace('p_batch_id .....' || p_batch_id);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9801: --hr_utility.trace('p_user_person_type = ' ||p_user_person_type);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9802: --hr_utility.trace('p_employee_number = ' ||p_employee_number);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9803: --hr_utility.trace('p_assign_organization = ' ||p_assign_organization);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9804: --hr_utility.trace('p_apl_assignment_id = ' ||p_apl_assignment_id);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9805: --hr_utility.trace('p_status = ' ||p_status);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9806: --hr_utility.trace('p_assignment_no = ' ||p_assignment_number);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9807: --hr_utility.trace('p_business_group_id = ' ||p_business_group_id);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9808: --hr_utility.trace('p_interface_code = ' ||p_interface_code);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9809: --hr_utility.trace('p_gre = ' ||p_gre);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9810: --hr_utility.trace('ass_attribute1 = ' ||p_ass_attribute1);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9811: --hr_utility.trace('ass_attribute2 = ' ||p_ass_attribute2);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9812: --hr_utility.trace('ass_attribute3 = ' ||p_ass_attribute3);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9813: --hr_utility.trace('ass_attribute4 = ' ||p_ass_attribute4);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9814: --hr_utility.trace('ass_attribute5 = ' ||p_ass_attribute5);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9815: --hr_utility.trace('ass_attribute6 = ' ||p_ass_attribute6);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9816: --hr_utility.trace('ass_attribute7 = ' ||p_ass_attribute7);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9817: --hr_utility.trace('ass_attribute8 = ' ||p_ass_attribute8);
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9825:
9818: --hr_utility.trace('ass_attribute9 = ' ||p_ass_attribute9);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9825:
9826: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
9819: --hr_utility.trace('ass_attribute10 = ' ||p_ass_attribute10);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9825:
9826: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
9827: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
9820: --hr_utility.trace('ass_attribute11 = ' ||p_ass_attribute11);
9821: --hr_utility.trace('ass_attribute12 = ' ||p_ass_attribute12);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9825:
9826: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
9827: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
9828: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
9822: --hr_utility.trace('ass_attribute13 = ' ||p_ass_attribute13);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9825:
9826: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
9827: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
9828: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
9829:
9830: --hr_utility.trace('Person Type = ' ||p_interface_code);
9823: --hr_utility.trace('ass_attribute14 = ' ||p_ass_attribute14);
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9825:
9826: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
9827: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
9828: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
9829:
9830: --hr_utility.trace('Person Type = ' ||p_interface_code);
9831:
9824: --hr_utility.trace('ass_attribute15 = ' ||p_ass_attribute15);
9825:
9826: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
9827: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
9828: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
9829:
9830: --hr_utility.trace('Person Type = ' ||p_interface_code);
9831:
9832: --hr_utility.trace(' Person id = ' ||P_DUP_PERSON_ID);
9826: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
9827: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
9828: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
9829:
9830: --hr_utility.trace('Person Type = ' ||p_interface_code);
9831:
9832: --hr_utility.trace(' Person id = ' ||P_DUP_PERSON_ID);
9833: --hr_utility.trace(' Party id = ' ||P_DUP_PARTY_ID);
9834:
9828: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
9829:
9830: --hr_utility.trace('Person Type = ' ||p_interface_code);
9831:
9832: --hr_utility.trace(' Person id = ' ||P_DUP_PERSON_ID);
9833: --hr_utility.trace(' Party id = ' ||P_DUP_PARTY_ID);
9834:
9835: --hr_utility.trace(' p_adr_attribute1 = ' ||p_adr_attribute1);
9836: --hr_utility.trace(' p_adr_attribute2 = ' ||p_adr_attribute2);
9829:
9830: --hr_utility.trace('Person Type = ' ||p_interface_code);
9831:
9832: --hr_utility.trace(' Person id = ' ||P_DUP_PERSON_ID);
9833: --hr_utility.trace(' Party id = ' ||P_DUP_PARTY_ID);
9834:
9835: --hr_utility.trace(' p_adr_attribute1 = ' ||p_adr_attribute1);
9836: --hr_utility.trace(' p_adr_attribute2 = ' ||p_adr_attribute2);
9837: --hr_utility.trace(' p_adr_attribute3 = ' ||p_adr_attribute3);
9831:
9832: --hr_utility.trace(' Person id = ' ||P_DUP_PERSON_ID);
9833: --hr_utility.trace(' Party id = ' ||P_DUP_PARTY_ID);
9834:
9835: --hr_utility.trace(' p_adr_attribute1 = ' ||p_adr_attribute1);
9836: --hr_utility.trace(' p_adr_attribute2 = ' ||p_adr_attribute2);
9837: --hr_utility.trace(' p_adr_attribute3 = ' ||p_adr_attribute3);
9838: --hr_utility.trace(' p_adr_attribute_category = ' ||p_adr_attribute_category);
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9832: --hr_utility.trace(' Person id = ' ||P_DUP_PERSON_ID);
9833: --hr_utility.trace(' Party id = ' ||P_DUP_PARTY_ID);
9834:
9835: --hr_utility.trace(' p_adr_attribute1 = ' ||p_adr_attribute1);
9836: --hr_utility.trace(' p_adr_attribute2 = ' ||p_adr_attribute2);
9837: --hr_utility.trace(' p_adr_attribute3 = ' ||p_adr_attribute3);
9838: --hr_utility.trace(' p_adr_attribute_category = ' ||p_adr_attribute_category);
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9840:
9833: --hr_utility.trace(' Party id = ' ||P_DUP_PARTY_ID);
9834:
9835: --hr_utility.trace(' p_adr_attribute1 = ' ||p_adr_attribute1);
9836: --hr_utility.trace(' p_adr_attribute2 = ' ||p_adr_attribute2);
9837: --hr_utility.trace(' p_adr_attribute3 = ' ||p_adr_attribute3);
9838: --hr_utility.trace(' p_adr_attribute_category = ' ||p_adr_attribute_category);
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9840:
9841: --hr_utility.trace(' P_INTERNAL_LOCATION = '||P_INTERNAL_LOCATION);
9834:
9835: --hr_utility.trace(' p_adr_attribute1 = ' ||p_adr_attribute1);
9836: --hr_utility.trace(' p_adr_attribute2 = ' ||p_adr_attribute2);
9837: --hr_utility.trace(' p_adr_attribute3 = ' ||p_adr_attribute3);
9838: --hr_utility.trace(' p_adr_attribute_category = ' ||p_adr_attribute_category);
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9840:
9841: --hr_utility.trace(' P_INTERNAL_LOCATION = '||P_INTERNAL_LOCATION);
9842: --hr_utility.trace(' P_ADJUSTED_SVC_DATE = '||P_ADJUSTED_SVC_DATE);
9835: --hr_utility.trace(' p_adr_attribute1 = ' ||p_adr_attribute1);
9836: --hr_utility.trace(' p_adr_attribute2 = ' ||p_adr_attribute2);
9837: --hr_utility.trace(' p_adr_attribute3 = ' ||p_adr_attribute3);
9838: --hr_utility.trace(' p_adr_attribute_category = ' ||p_adr_attribute_category);
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9840:
9841: --hr_utility.trace(' P_INTERNAL_LOCATION = '||P_INTERNAL_LOCATION);
9842: --hr_utility.trace(' P_ADJUSTED_SVC_DATE = '||P_ADJUSTED_SVC_DATE);
9843: --hr_utility.trace(' P_COUNTRY_OF_BIRTH = '||P_COUNTRY_OF_BIRTH);
9837: --hr_utility.trace(' p_adr_attribute3 = ' ||p_adr_attribute3);
9838: --hr_utility.trace(' p_adr_attribute_category = ' ||p_adr_attribute_category);
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9840:
9841: --hr_utility.trace(' P_INTERNAL_LOCATION = '||P_INTERNAL_LOCATION);
9842: --hr_utility.trace(' P_ADJUSTED_SVC_DATE = '||P_ADJUSTED_SVC_DATE);
9843: --hr_utility.trace(' P_COUNTRY_OF_BIRTH = '||P_COUNTRY_OF_BIRTH);
9844:
9845: hr_utility.set_location(' Initializing records ', 5);
9838: --hr_utility.trace(' p_adr_attribute_category = ' ||p_adr_attribute_category);
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9840:
9841: --hr_utility.trace(' P_INTERNAL_LOCATION = '||P_INTERNAL_LOCATION);
9842: --hr_utility.trace(' P_ADJUSTED_SVC_DATE = '||P_ADJUSTED_SVC_DATE);
9843: --hr_utility.trace(' P_COUNTRY_OF_BIRTH = '||P_COUNTRY_OF_BIRTH);
9844:
9845: hr_utility.set_location(' Initializing records ', 5);
9846: g_per_rec := null; g_grp_rec := null;
9839: --hr_utility.trace(' p_add_information16 = ' ||p_add_information16);
9840:
9841: --hr_utility.trace(' P_INTERNAL_LOCATION = '||P_INTERNAL_LOCATION);
9842: --hr_utility.trace(' P_ADJUSTED_SVC_DATE = '||P_ADJUSTED_SVC_DATE);
9843: --hr_utility.trace(' P_COUNTRY_OF_BIRTH = '||P_COUNTRY_OF_BIRTH);
9844:
9845: hr_utility.set_location(' Initializing records ', 5);
9846: g_per_rec := null; g_grp_rec := null;
9847: g_scl_rec := null; g_asg_rec := null;
9841: --hr_utility.trace(' P_INTERNAL_LOCATION = '||P_INTERNAL_LOCATION);
9842: --hr_utility.trace(' P_ADJUSTED_SVC_DATE = '||P_ADJUSTED_SVC_DATE);
9843: --hr_utility.trace(' P_COUNTRY_OF_BIRTH = '||P_COUNTRY_OF_BIRTH);
9844:
9845: hr_utility.set_location(' Initializing records ', 5);
9846: g_per_rec := null; g_grp_rec := null;
9847: g_scl_rec := null; g_asg_rec := null;
9848: g_add_rec := null; g_phn_rec := null;
9849: g_interface_code := nvl(p_interface_code,'PQP_FLEXIBLE_WEBADI_INTF');
9866: ,g_business_group_id;
9867: close csr_bg_code;
9868:
9869: if g_debug then
9870: hr_utility.set_location(' l_effective_date: '||l_effective_date, 10);
9871: hr_utility.set_location(' g_leg_code : '||g_leg_code, 10);
9872: hr_utility.set_location(' g_emp_num_gen : '||g_emp_num_gen, 10);
9873: hr_utility.set_location(' l_party_number : '||l_party_number, 10);
9874: hr_utility.set_location(' p_business_group_id : '||p_business_group_id, 10);
9867: close csr_bg_code;
9868:
9869: if g_debug then
9870: hr_utility.set_location(' l_effective_date: '||l_effective_date, 10);
9871: hr_utility.set_location(' g_leg_code : '||g_leg_code, 10);
9872: hr_utility.set_location(' g_emp_num_gen : '||g_emp_num_gen, 10);
9873: hr_utility.set_location(' l_party_number : '||l_party_number, 10);
9874: hr_utility.set_location(' p_business_group_id : '||p_business_group_id, 10);
9875: hr_utility.set_location(' p_interface_code : '||p_interface_code, 10);
9868:
9869: if g_debug then
9870: hr_utility.set_location(' l_effective_date: '||l_effective_date, 10);
9871: hr_utility.set_location(' g_leg_code : '||g_leg_code, 10);
9872: hr_utility.set_location(' g_emp_num_gen : '||g_emp_num_gen, 10);
9873: hr_utility.set_location(' l_party_number : '||l_party_number, 10);
9874: hr_utility.set_location(' p_business_group_id : '||p_business_group_id, 10);
9875: hr_utility.set_location(' p_interface_code : '||p_interface_code, 10);
9876:
9869: if g_debug then
9870: hr_utility.set_location(' l_effective_date: '||l_effective_date, 10);
9871: hr_utility.set_location(' g_leg_code : '||g_leg_code, 10);
9872: hr_utility.set_location(' g_emp_num_gen : '||g_emp_num_gen, 10);
9873: hr_utility.set_location(' l_party_number : '||l_party_number, 10);
9874: hr_utility.set_location(' p_business_group_id : '||p_business_group_id, 10);
9875: hr_utility.set_location(' p_interface_code : '||p_interface_code, 10);
9876:
9877: end if;
9870: hr_utility.set_location(' l_effective_date: '||l_effective_date, 10);
9871: hr_utility.set_location(' g_leg_code : '||g_leg_code, 10);
9872: hr_utility.set_location(' g_emp_num_gen : '||g_emp_num_gen, 10);
9873: hr_utility.set_location(' l_party_number : '||l_party_number, 10);
9874: hr_utility.set_location(' p_business_group_id : '||p_business_group_id, 10);
9875: hr_utility.set_location(' p_interface_code : '||p_interface_code, 10);
9876:
9877: end if;
9878: --
9871: hr_utility.set_location(' g_leg_code : '||g_leg_code, 10);
9872: hr_utility.set_location(' g_emp_num_gen : '||g_emp_num_gen, 10);
9873: hr_utility.set_location(' l_party_number : '||l_party_number, 10);
9874: hr_utility.set_location(' p_business_group_id : '||p_business_group_id, 10);
9875: hr_utility.set_location(' p_interface_code : '||p_interface_code, 10);
9876:
9877: end if;
9878: --
9879: -- Get the Un-Masked National Indentifier
9887: );
9888: --
9889: -- Get Party Id corresponding to Party Number is entered
9890: --
9891: hr_utility.set_location('l_party_number '|| l_party_number, 30);
9892: if (l_party_number is not null) then
9893: hr_utility.set_location(' Party number is not null ', 30);
9894: l_sql_qry := 'select party_id
9895: from hz_parties
9889: -- Get Party Id corresponding to Party Number is entered
9890: --
9891: hr_utility.set_location('l_party_number '|| l_party_number, 30);
9892: if (l_party_number is not null) then
9893: hr_utility.set_location(' Party number is not null ', 30);
9894: l_sql_qry := 'select party_id
9895: from hz_parties
9896: where party_number ='||l_party_number;
9897: open csr_get_party_id for l_sql_qry;
9898: fetch csr_get_party_id into l_party_id;
9899: close csr_get_party_id;
9900: end if;
9901:
9902: hr_utility.set_location('l_party_id '|| l_party_id, 50);
9903: hr_utility.set_location('Start of filling person rec ', 50);
9904:
9905: -- ===========================================================================
9906: -- ~ Person Details
9899: close csr_get_party_id;
9900: end if;
9901:
9902: hr_utility.set_location('l_party_id '|| l_party_id, 50);
9903: hr_utility.set_location('Start of filling person rec ', 50);
9904:
9905: -- ===========================================================================
9906: -- ~ Person Details
9907: -- ===========================================================================
9982: g_per_rec.on_military_service := nvl(p_on_military_service,'N');
9983: g_per_rec.internal_location := P_INTERNAL_LOCATION; -- Added by pkagrawa
9984:
9985:
9986: hr_utility.set_location('Person Details assigned to record : g_per_rec ',
9987: 60);
9988: -- ===========================================================================
9989: -- Person DF: Customer defined
9990: -- ===========================================================================
9994:
9995: if p_per_attribute_category is null then
9996: for i in 1..30 loop
9997: if (temp||to_char(i)) is null then
9998: --hr_utility.trace('Check PER_ATT NULL'||(temp||to_char(i)));
9999: null;
10000: else
10001: g_per_rec.attribute_category := 'Global Data Elements';
10002: --hr_utility.trace('Check PER_ATT_CAT NULL - Global Val'||p_per_attribute_category);
9998: --hr_utility.trace('Check PER_ATT NULL'||(temp||to_char(i)));
9999: null;
10000: else
10001: g_per_rec.attribute_category := 'Global Data Elements';
10002: --hr_utility.trace('Check PER_ATT_CAT NULL - Global Val'||p_per_attribute_category);
10003: exit;
10004: end if;
10005: end loop;
10006: end if;
10042: g_per_rec.attribute28 := p_per_attribute28;
10043: g_per_rec.attribute29 := p_per_attribute29;
10044: g_per_rec.attribute30 := p_per_attribute30;
10045: end if;
10046: hr_utility.set_location('Person DF assigned to record :g_per_rec ', 70);
10047:
10048: -- ===========================================================================
10049: -- Person DDF: Different for each legislation
10050: -- ===========================================================================
10086:
10087: end if;
10088: close csr_style;
10089:
10090: hr_utility.set_location('Person DDF assigned to record : '||
10091: p_per_information_category, 80);
10092:
10093: -- ===========================================================================
10094: -- ~ Person Address Record
10127: g_add_rec.add_information20 := p_add_information20;
10128:
10129: end if;
10130:
10131: hr_utility.set_location('Address Style: '||p_address_style, 90);
10132:
10133: -- ===========================================================================
10134: -- Address DF: Customer defined DF
10135: -- ===========================================================================
10139:
10140: if p_adr_attribute_category is null then
10141: for i in 1..20 loop
10142: if (temp||to_char(i)) is null then
10143: --hr_utility.trace('Check ADDR_ATT NULL'||(temp||to_char(i)));
10144: null;
10145: else
10146: g_add_rec.addr_attribute_category := 'Global Data Elements';
10147: --hr_utility.trace('Check ADDR_ATT_CAT NULL - Global Val'||p_adr_attribute_category);
10143: --hr_utility.trace('Check ADDR_ATT NULL'||(temp||to_char(i)));
10144: null;
10145: else
10146: g_add_rec.addr_attribute_category := 'Global Data Elements';
10147: --hr_utility.trace('Check ADDR_ATT_CAT NULL - Global Val'||p_adr_attribute_category);
10148: exit;
10149: end if;
10150: end loop;
10151: end if;
10179: g_add_rec.addr_attribute20 := p_adr_attribute20;
10180:
10181: end if;
10182:
10183: hr_utility.set_location('Address DF category: '||p_adr_attribute_category, 100);
10184:
10185: -- ===========================================================================
10186: -- ~ Person Primary Assignment
10187: -- ===========================================================================
10228: --Added by Dbansal
10229: g_asg_comments := p_asg_comments;
10230:
10231:
10232: --hr_utility.trace('LOCATION_ID = '||g_asg_rec.location_id);
10233: --hr_utility.trace('g_asg_rec.employee_category='||g_asg_rec.employee_category);
10234: --hr_utility.trace('g_asg_rec.assignment_category'||g_asg_rec.assignment_category);
10235: hr_utility.set_location('Primary Assignment details assigned to record', 110);
10236:
10229: g_asg_comments := p_asg_comments;
10230:
10231:
10232: --hr_utility.trace('LOCATION_ID = '||g_asg_rec.location_id);
10233: --hr_utility.trace('g_asg_rec.employee_category='||g_asg_rec.employee_category);
10234: --hr_utility.trace('g_asg_rec.assignment_category'||g_asg_rec.assignment_category);
10235: hr_utility.set_location('Primary Assignment details assigned to record', 110);
10236:
10237: -- ===========================================================================
10230:
10231:
10232: --hr_utility.trace('LOCATION_ID = '||g_asg_rec.location_id);
10233: --hr_utility.trace('g_asg_rec.employee_category='||g_asg_rec.employee_category);
10234: --hr_utility.trace('g_asg_rec.assignment_category'||g_asg_rec.assignment_category);
10235: hr_utility.set_location('Primary Assignment details assigned to record', 110);
10236:
10237: -- ===========================================================================
10238: -- Additional Assignment Details
10231:
10232: --hr_utility.trace('LOCATION_ID = '||g_asg_rec.location_id);
10233: --hr_utility.trace('g_asg_rec.employee_category='||g_asg_rec.employee_category);
10234: --hr_utility.trace('g_asg_rec.assignment_category'||g_asg_rec.assignment_category);
10235: hr_utility.set_location('Primary Assignment details assigned to record', 110);
10236:
10237: -- ===========================================================================
10238: -- Additional Assignment Details
10239: -- ===========================================================================
10243:
10244: if p_ass_attribute_category is null then
10245: for i in 1..30 loop
10246: if (temp||to_char(i)) is null then
10247: --hr_utility.trace('Check ASS_ATT NULL'||(temp||to_char(i)));
10248: null;
10249: else
10250: g_asg_rec.ass_attribute_category := 'Global Data Elements';
10251: --hr_utility.trace('Check ASS_ATT_CAT NULL - Global Val'||p_ass_attribute_category);
10247: --hr_utility.trace('Check ASS_ATT NULL'||(temp||to_char(i)));
10248: null;
10249: else
10250: g_asg_rec.ass_attribute_category := 'Global Data Elements';
10251: --hr_utility.trace('Check ASS_ATT_CAT NULL - Global Val'||p_ass_attribute_category);
10252: exit;
10253: end if;
10254: end loop;
10255: end if;
10294: g_asg_rec.ass_attribute30 := p_ass_attribute30;
10295:
10296: end if;
10297:
10298: hr_utility.set_location('Assignment DF category: '||p_ass_attribute_category, 120);
10299:
10300: -- ===========================================================================
10301: -- ~ Contact Details
10302: -- ===========================================================================
10308: g_cnt_rec.primary_contact_flag := p_primary_contact;
10309: g_cnt_rec.personal_flag := p_personal_flag;
10310:
10311: end if;
10312: hr_utility.set_location('Contact details assigned to record ', 130);
10313:
10314: -- ===========================================================================
10315: -- ~ Person Phones
10316: -- ===========================================================================
10322: g_phn_rec.date_from := p_phone_date_from;
10323: g_phn_rec.date_to := p_phone_date_to;
10324: g_phn_rec.parent_table := 'PER_ALL_PEOPLE_F';
10325: end if;
10326: hr_utility.set_location('Phone Details assigned to record ', 140);
10327:
10328: -- ===========================================================================
10329: -- ~ Soft Coding Keyflex field
10330: -- ===========================================================================
10327:
10328: -- ===========================================================================
10329: -- ~ Soft Coding Keyflex field
10330: -- ===========================================================================
10331: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
10332: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
10333: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
10334:
10335: g_scl_rec.concatenated_segments := p_soft_segments;
10328: -- ===========================================================================
10329: -- ~ Soft Coding Keyflex field
10330: -- ===========================================================================
10331: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
10332: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
10333: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
10334:
10335: g_scl_rec.concatenated_segments := p_soft_segments;
10336: g_scl_rec.segment1 := nvl(p_soft_segment1, p_gre);
10329: -- ~ Soft Coding Keyflex field
10330: -- ===========================================================================
10331: --hr_utility.trace('p_soft_segments = ' ||p_soft_segments);
10332: --hr_utility.trace('p_soft_segment1 = ' ||p_soft_segment1);
10333: --hr_utility.trace('p_soft_segment2 = ' ||p_soft_segment2);
10334:
10335: g_scl_rec.concatenated_segments := p_soft_segments;
10336: g_scl_rec.segment1 := nvl(p_soft_segment1, p_gre);
10337: g_scl_rec.segment2 := p_soft_segment2;
10424: g_scl_rec.segment30 := null;
10425: End;
10426: -------------------------------------------------------------------------
10427:
10428: hr_utility.set_location('Soft Coding KFF segments assigned to record: ' ||
10429: 'g_scl_rec ', 150);
10430: -- ===========================================================================
10431: -- ~ People Group Keyflex
10432: -- ===========================================================================
10462: g_grp_rec.segment28 := p_people_segment28;
10463: g_grp_rec.segment29 := p_people_segment29;
10464: g_grp_rec.segment30 := p_people_segment30;
10465:
10466: hr_utility.set_location('People Grp KFF segments assigned to record: ' ||
10467: 'g_grp_rec ', 160);
10468: hr_utility.trace('l_migration_allowed ='||l_migration_allowed);
10469: --$ If migration allowed only call Chk_NI_Exists. Modification for Applicant Issue.
10470: if l_migration_allowed ='Y' then
10464: g_grp_rec.segment30 := p_people_segment30;
10465:
10466: hr_utility.set_location('People Grp KFF segments assigned to record: ' ||
10467: 'g_grp_rec ', 160);
10468: hr_utility.trace('l_migration_allowed ='||l_migration_allowed);
10469: --$ If migration allowed only call Chk_NI_Exists. Modification for Applicant Issue.
10470: if l_migration_allowed ='Y' then
10471: l_person_id := Chk_NI_Exists
10472: (p_national_identifier => g_per_rec.national_identifier
10484: ,p_business_group_id => p_business_group_id
10485: ,p_effective_date => g_per_rec.start_date
10486: );
10487:
10488: --hr_utility.trace(' l_apl_assignment_id = ' ||l_apl_assignment_id);
10489: if g_asg_rec.assignment_id is null then
10490: g_asg_rec.assignment_id := l_apl_assignment_id;
10491: end if;
10492:
10491: end if;
10492:
10493: if p_data_pump_flag = 'Y' then
10494:
10495: --hr_utility.trace('DataPump_API_Call');
10496:
10497: DataPump_API_Call
10498: (p_data_pump_batch_line_id => p_data_pump_batch_line_id
10499: ,p_batch_id => p_batch_id
10505: --$ Pass Link value in case of updating batch lines
10506: ,p_batch_link => p_batch_link
10507: );
10508: else
10509: --hr_utility.trace('Direct_API_Call');
10510:
10511: Direct_API_Call
10512: (p_dup_person_id => p_dup_person_id
10513: ,p_dup_party_id => p_dup_party_id
10530: if(MSGNAME <> 'CONC-SINGLE PENDING REQUEST' OR MSGAPP<>'FND') then
10531: fnd_message.set_name(MSGAPP, MSGNAME);
10532: end if;
10533:
10534: hr_utility.set_location('Leaving: ' || l_proc_name, 350);
10535:
10536: exception
10537: when e_upl_not_allowed then
10538: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10534: hr_utility.set_location('Leaving: ' || l_proc_name, 350);
10535:
10536: exception
10537: when e_upl_not_allowed then
10538: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10539: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
10540: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10541: hr_utility.raise_error;
10542: when e_crt_per_not_allowed then
10535:
10536: exception
10537: when e_upl_not_allowed then
10538: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10539: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
10540: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10541: hr_utility.raise_error;
10542: when e_crt_per_not_allowed then
10543: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10536: exception
10537: when e_upl_not_allowed then
10538: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10539: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
10540: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10541: hr_utility.raise_error;
10542: when e_crt_per_not_allowed then
10543: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10544: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_per_err_msg);
10537: when e_upl_not_allowed then
10538: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10539: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
10540: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10541: hr_utility.raise_error;
10542: when e_crt_per_not_allowed then
10543: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10544: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_per_err_msg);
10545: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10539: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
10540: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10541: hr_utility.raise_error;
10542: when e_crt_per_not_allowed then
10543: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10544: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_per_err_msg);
10545: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10546: hr_utility.raise_error;
10547: when e_crt_asg_not_allowed then
10540: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10541: hr_utility.raise_error;
10542: when e_crt_per_not_allowed then
10543: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10544: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_per_err_msg);
10545: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10546: hr_utility.raise_error;
10547: when e_crt_asg_not_allowed then
10548: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10541: hr_utility.raise_error;
10542: when e_crt_per_not_allowed then
10543: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10544: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_per_err_msg);
10545: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10546: hr_utility.raise_error;
10547: when e_crt_asg_not_allowed then
10548: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10549: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_asg_err_msg);
10542: when e_crt_per_not_allowed then
10543: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10544: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_per_err_msg);
10545: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10546: hr_utility.raise_error;
10547: when e_crt_asg_not_allowed then
10548: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10549: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_asg_err_msg);
10550: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10544: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_per_err_msg);
10545: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10546: hr_utility.raise_error;
10547: when e_crt_asg_not_allowed then
10548: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10549: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_asg_err_msg);
10550: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10551: hr_utility.raise_error;
10552: when e_crt_add_not_allowed then
10545: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10546: hr_utility.raise_error;
10547: when e_crt_asg_not_allowed then
10548: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10549: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_asg_err_msg);
10550: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10551: hr_utility.raise_error;
10552: when e_crt_add_not_allowed then
10553: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10546: hr_utility.raise_error;
10547: when e_crt_asg_not_allowed then
10548: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10549: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_asg_err_msg);
10550: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10551: hr_utility.raise_error;
10552: when e_crt_add_not_allowed then
10553: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10554: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_add_err_msg);
10547: when e_crt_asg_not_allowed then
10548: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10549: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_asg_err_msg);
10550: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10551: hr_utility.raise_error;
10552: when e_crt_add_not_allowed then
10553: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10554: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_add_err_msg);
10555: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10549: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_asg_err_msg);
10550: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10551: hr_utility.raise_error;
10552: when e_crt_add_not_allowed then
10553: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10554: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_add_err_msg);
10555: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10556: hr_utility.raise_error;
10557: when Others then
10550: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10551: hr_utility.raise_error;
10552: when e_crt_add_not_allowed then
10553: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10554: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_add_err_msg);
10555: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10556: hr_utility.raise_error;
10557: when Others then
10558: -- close chk_party;
10551: hr_utility.raise_error;
10552: when e_crt_add_not_allowed then
10553: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10554: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_add_err_msg);
10555: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10556: hr_utility.raise_error;
10557: when Others then
10558: -- close chk_party;
10559: hr_utility.set_location('sqlerrm' || substr(sqlerrm,1,50), 370);
10552: when e_crt_add_not_allowed then
10553: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10554: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_add_err_msg);
10555: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10556: hr_utility.raise_error;
10557: when Others then
10558: -- close chk_party;
10559: hr_utility.set_location('sqlerrm' || substr(sqlerrm,1,50), 370);
10560: hr_utility.set_location('sqlerrm' || substr(sqlerrm,51,100), 370);
10555: hr_utility.set_location('Leaving: ' || l_proc_name, 370);
10556: hr_utility.raise_error;
10557: when Others then
10558: -- close chk_party;
10559: hr_utility.set_location('sqlerrm' || substr(sqlerrm,1,50), 370);
10560: hr_utility.set_location('sqlerrm' || substr(sqlerrm,51,100), 370);
10561: hr_utility.set_location('sqlerrm' || substr(sqlerrm,101,150), 370);
10562:
10563: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10556: hr_utility.raise_error;
10557: when Others then
10558: -- close chk_party;
10559: hr_utility.set_location('sqlerrm' || substr(sqlerrm,1,50), 370);
10560: hr_utility.set_location('sqlerrm' || substr(sqlerrm,51,100), 370);
10561: hr_utility.set_location('sqlerrm' || substr(sqlerrm,101,150), 370);
10562:
10563: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10564: --hr_utility.set_message_token('GENERIC_TOKEN',substr(sqlerrm,1,50) );
10557: when Others then
10558: -- close chk_party;
10559: hr_utility.set_location('sqlerrm' || substr(sqlerrm,1,50), 370);
10560: hr_utility.set_location('sqlerrm' || substr(sqlerrm,51,100), 370);
10561: hr_utility.set_location('sqlerrm' || substr(sqlerrm,101,150), 370);
10562:
10563: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10564: --hr_utility.set_message_token('GENERIC_TOKEN',substr(sqlerrm,1,50) );
10565:
10559: hr_utility.set_location('sqlerrm' || substr(sqlerrm,1,50), 370);
10560: hr_utility.set_location('sqlerrm' || substr(sqlerrm,51,100), 370);
10561: hr_utility.set_location('sqlerrm' || substr(sqlerrm,101,150), 370);
10562:
10563: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10564: --hr_utility.set_message_token('GENERIC_TOKEN',substr(sqlerrm,1,50) );
10565:
10566: --hr_utility.trace(' Final Error = '||sqlerrm);
10567:
10560: hr_utility.set_location('sqlerrm' || substr(sqlerrm,51,100), 370);
10561: hr_utility.set_location('sqlerrm' || substr(sqlerrm,101,150), 370);
10562:
10563: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10564: --hr_utility.set_message_token('GENERIC_TOKEN',substr(sqlerrm,1,50) );
10565:
10566: --hr_utility.trace(' Final Error = '||sqlerrm);
10567:
10568: rollback to InsUpd_PerAsgAdd_Rec;
10562:
10563: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
10564: --hr_utility.set_message_token('GENERIC_TOKEN',substr(sqlerrm,1,50) );
10565:
10566: --hr_utility.trace(' Final Error = '||sqlerrm);
10567:
10568: rollback to InsUpd_PerAsgAdd_Rec;
10569: hr_utility.raise_error;
10570:
10565:
10566: --hr_utility.trace(' Final Error = '||sqlerrm);
10567:
10568: rollback to InsUpd_PerAsgAdd_Rec;
10569: hr_utility.raise_error;
10570:
10571: end InsUpd_PerAsgAdd_Rec;
10572:
10573: end PQP_PerAsgAdd_RIW;