eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_UTILITIES_PKG dependencies on HR_UTILITY

Line 918: hr_utility.set_location('Entering irc_mark_appl_considered',10);

914: where organization_id = l_business_grp_id
915: and org_information_context = 'BG Recruitment';
916: --
917: begin
918: hr_utility.set_location('Entering irc_mark_appl_considered',10);
919: --
920: open c_bg_id;
921: fetch c_bg_id into l_business_grp_id;
922: close c_bg_id;

Line 933: hr_utility.set_location('Assignment details record does not exist',20);

929: open c_assgn_details_row;
930: fetch c_assgn_details_row into l_assgn_details_row;
931: --
932: if(c_assgn_details_row%ROWCOUNT=0) then
933: hr_utility.set_location('Assignment details record does not exist',20);
934: irc_assignment_details_api.create_assignment_details (
935: p_validate => false
936: ,P_EFFECTIVE_DATE => l_effective_date
937: ,p_assignment_id => l_assignment_id

Line 947: hr_utility.set_location('Created new assignment details row',30);

943: ,p_effective_start_date => l_effective_start_date
944: ,p_effective_end_date => l_effective_end_date
945: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
946: );
947: hr_utility.set_location('Created new assignment details row',30);
948: else
949: hr_utility.set_location('Assignment details record already exists',40);
950: hr_utility.set_location('p_update_mode::'||p_update_mode,50);
951:

Line 949: hr_utility.set_location('Assignment details record already exists',40);

945: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
946: );
947: hr_utility.set_location('Created new assignment details row',30);
948: else
949: hr_utility.set_location('Assignment details record already exists',40);
950: hr_utility.set_location('p_update_mode::'||p_update_mode,50);
951:
952: l_object_version_number := l_assgn_details_row.object_version_number;
953: l_assignment_details_id := l_assgn_details_row.assignment_details_id;

Line 950: hr_utility.set_location('p_update_mode::'||p_update_mode,50);

946: );
947: hr_utility.set_location('Created new assignment details row',30);
948: else
949: hr_utility.set_location('Assignment details record already exists',40);
950: hr_utility.set_location('p_update_mode::'||p_update_mode,50);
951:
952: l_object_version_number := l_assgn_details_row.object_version_number;
953: l_assignment_details_id := l_assgn_details_row.assignment_details_id;
954:

Line 969: hr_utility.set_location('Updated assignment details record',60);

965: ,p_details_version => l_details_version
966: ,p_effective_start_date => l_effective_start_date
967: ,p_effective_end_date => l_effective_end_date
968: );
969: hr_utility.set_location('Updated assignment details record',60);
970: end if;
971: close c_assgn_details_row;
972: commit;
973: end if;

Line 974: hr_utility.set_location('Leaving irc_mark_appl_considered',10);

970: end if;
971: close c_assgn_details_row;
972: commit;
973: end if;
974: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
975: exception
976: when others then
977: hr_utility.set_location('Exception in irc_mark_appl_considered::' || SQLERRM,100);
978: rollback;

Line 977: hr_utility.set_location('Exception in irc_mark_appl_considered::' || SQLERRM,100);

973: end if;
974: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
975: exception
976: when others then
977: hr_utility.set_location('Exception in irc_mark_appl_considered::' || SQLERRM,100);
978: rollback;
979: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
980: raise;
981: end irc_mark_appl_considered;

Line 979: hr_utility.set_location('Leaving irc_mark_appl_considered',10);

975: exception
976: when others then
977: hr_utility.set_location('Exception in irc_mark_appl_considered::' || SQLERRM,100);
978: rollback;
979: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
980: raise;
981: end irc_mark_appl_considered;
982: --
983: -- ----------------------------------------------------------------------------

Line 1162: hr_utility.set_location('Enteringp_addr: '||l_proc, 5);

1158: and sysdate between date_from and nvl(date_to,sysdate);
1159: --
1160: begin
1161: --
1162: hr_utility.set_location('Enteringp_addr: '||l_proc, 5);
1163: --
1164: open C_Assignment_details;
1165: fetch C_Assignment_details into l_person_id_appl,l_business_group_id,l_application_date;
1166: close C_Assignment_details;

Line 1172: hr_utility.set_location('C_Address_id not found: '||l_proc, 6);

1168: open C_Address_id;
1169: fetch C_Address_id into l_addr_id;
1170: if C_Address_id%notfound then
1171: --
1172: hr_utility.set_location('C_Address_id not found: '||l_proc, 6);
1173: open C_Person_id;
1174: fetch C_Person_id into l_person_id;
1175: close C_Person_id;
1176: --

Line 1185: hr_utility.set_location('C_Address_details_Rec not found: '||l_proc, 7);

1181: open C_Address_details_Rec;
1182: fetch C_Address_details_Rec into p_addr;
1183: --
1184: if C_Address_details_Rec%notfound then
1185: hr_utility.set_location('C_Address_details_Rec not found: '||l_proc, 7);
1186: open C_Address_details_Primary;
1187: fetch C_Address_details_Primary into p_addr;
1188: --
1189: if C_Address_details_Primary%found then

Line 1190: hr_utility.set_location('C_Address_details_Primary found: '||l_proc, 8);

1186: open C_Address_details_Primary;
1187: fetch C_Address_details_Primary into p_addr;
1188: --
1189: if C_Address_details_Primary%found then
1190: hr_utility.set_location('C_Address_details_Primary found: '||l_proc, 8);
1191: l_addr_found := true;
1192: end if;
1193: --
1194: close C_Address_details_Primary;

Line 1196: hr_utility.set_location('C_Address_details_Rec found: '||l_proc, 9);

1192: end if;
1193: --
1194: close C_Address_details_Primary;
1195: else
1196: hr_utility.set_location('C_Address_details_Rec found: '||l_proc, 9);
1197: l_addr_found := true;
1198: end if;
1199: --
1200: if l_addr_found then

Line 1201: hr_utility.set_location('Creating the address: '||l_proc, 10);

1197: l_addr_found := true;
1198: end if;
1199: --
1200: if l_addr_found then
1201: hr_utility.set_location('Creating the address: '||l_proc, 10);
1202: --
1203: p_addr.person_id:=l_person_id_appl;
1204: p_addr.primary_flag:='Y';
1205: p_addr.address_id:=null;

Line 1266: hr_utility.set_location('After Creating the address: '||l_proc, 11);

1262: ,P_ADDRESS_ID => p_addr.address_id
1263: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1264: ,P_RETURN_STATUS => l_return_status
1265: );
1266: hr_utility.set_location('After Creating the address: '||l_proc, 11);
1267: end if;
1268: --
1269: close C_Address_details_Rec;
1270: end if;

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

1269: close C_Address_details_Rec;
1270: end if;
1271: --
1272: close C_Address_id;
1273: hr_utility.set_location(' Leaving: ' || l_proc, 50);
1274: --
1275: exception
1276: when others then
1277: hr_utility.set_location(' Exception occured: ' || l_proc, 50);

Line 1277: hr_utility.set_location(' Exception occured: ' || l_proc, 50);

1273: hr_utility.set_location(' Leaving: ' || l_proc, 50);
1274: --
1275: exception
1276: when others then
1277: hr_utility.set_location(' Exception occured: ' || l_proc, 50);
1278: raise;
1279: end copy_candidate_address;
1280: --
1281: --

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

1286: procedure copy_candidate_details
1287: (p_assignment_id in number) is
1288: l_proc varchar2(72) := 'irc_utilities_pkg.copy_candidate_address';
1289: begin
1290: hr_utility.set_location('Entering: '||l_proc, 5);
1291: copy_candidate_address(p_assignment_id);
1292: hr_utility.set_location('Leaving: '||l_proc, 5);
1293: exception
1294: when others then

Line 1292: hr_utility.set_location('Leaving: '||l_proc, 5);

1288: l_proc varchar2(72) := 'irc_utilities_pkg.copy_candidate_address';
1289: begin
1290: hr_utility.set_location('Entering: '||l_proc, 5);
1291: copy_candidate_address(p_assignment_id);
1292: hr_utility.set_location('Leaving: '||l_proc, 5);
1293: exception
1294: when others then
1295: raise;
1296: end copy_candidate_details;

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

1390: l_effective_date DATE;
1391: l_fte_factor NUMBER := NULL;
1392: l_proc varchar2(72) := 'irc_utilities_pkg.get_fte_factor';
1393: BEGIN
1394: hr_utility.set_location('Entering: '||l_proc, 5);
1395: If(NVL(p_assignment_id,0) <> 0 ) then
1396: open csr_orgdetails;
1397: fetch csr_orgdetails into l_asg_hours_per_year
1398: ,l_position_id

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

1407: ,p_business_group_id => l_business_group_id
1408: ,p_effective_date => l_effective_date);
1409: End if;
1410: Return l_fte_factor;
1411: hr_utility.set_location('Leaving: '||l_proc, 10);
1412: END get_fte_factor;
1413: --
1414: -- ----------------------------------------------------------------------------
1415: -- |---------------------< split_to_token >---------------------------------|