APPS.IRC_UTILITIES_PKG dependencies on HR_UTILITY

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

899: where organization_id = l_business_grp_id
900: and org_information_context = 'BG Recruitment';
901: --
902: begin
903: hr_utility.set_location('Entering irc_mark_appl_considered',10);
904: --
905: open c_bg_id;
906: fetch c_bg_id into l_business_grp_id;
907: close c_bg_id;

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

914: open c_assgn_details_row;
915: fetch c_assgn_details_row into l_assgn_details_row;
916: --
917: if(c_assgn_details_row%ROWCOUNT=0) then
918: hr_utility.set_location('Assignment details record does not exist',20);
919: irc_assignment_details_api.create_assignment_details (
920: p_validate => false
921: ,P_EFFECTIVE_DATE => l_effective_date
922: ,p_assignment_id => l_assignment_id

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

928: ,p_effective_start_date => l_effective_start_date
929: ,p_effective_end_date => l_effective_end_date
930: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
931: );
932: hr_utility.set_location('Created new assignment details row',30);
933: else
934: hr_utility.set_location('Assignment details record already exists',40);
935: hr_utility.set_location('p_update_mode::'||p_update_mode,50);
936:

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

930: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
931: );
932: hr_utility.set_location('Created new assignment details row',30);
933: else
934: hr_utility.set_location('Assignment details record already exists',40);
935: hr_utility.set_location('p_update_mode::'||p_update_mode,50);
936:
937: l_object_version_number := l_assgn_details_row.object_version_number;
938: l_assignment_details_id := l_assgn_details_row.assignment_details_id;

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

931: );
932: hr_utility.set_location('Created new assignment details row',30);
933: else
934: hr_utility.set_location('Assignment details record already exists',40);
935: hr_utility.set_location('p_update_mode::'||p_update_mode,50);
936:
937: l_object_version_number := l_assgn_details_row.object_version_number;
938: l_assignment_details_id := l_assgn_details_row.assignment_details_id;
939:

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

950: ,p_details_version => l_details_version
951: ,p_effective_start_date => l_effective_start_date
952: ,p_effective_end_date => l_effective_end_date
953: );
954: hr_utility.set_location('Updated assignment details record',60);
955: end if;
956: close c_assgn_details_row;
957: commit;
958: end if;

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

955: end if;
956: close c_assgn_details_row;
957: commit;
958: end if;
959: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
960: exception
961: when others then
962: hr_utility.set_location('Exception in irc_mark_appl_considered::' || SQLERRM,100);
963: rollback;

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

958: end if;
959: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
960: exception
961: when others then
962: hr_utility.set_location('Exception in irc_mark_appl_considered::' || SQLERRM,100);
963: rollback;
964: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
965: raise;
966: end irc_mark_appl_considered;

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

960: exception
961: when others then
962: hr_utility.set_location('Exception in irc_mark_appl_considered::' || SQLERRM,100);
963: rollback;
964: hr_utility.set_location('Leaving irc_mark_appl_considered',10);
965: raise;
966: end irc_mark_appl_considered;
967: --
968: -- ----------------------------------------------------------------------------