DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on FND_NEW_MESSAGES

Line 133: l_error_message_code fnd_new_messages.message_name%TYPE;

129: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
130: l_return_status VARCHAR2(1);
131: /*Added for the bug 3464074*/
132: l_person_name PER_PEOPLE_F.full_name%TYPE;
133: l_error_message_code fnd_new_messages.message_name%TYPE;
134: l_work_type_exixts varchar2(1) := 'N'; --bug#8368384
135:
136: -- start of cursor or work type validation bug 8368384
137: CURSOR c_validate_work_type (p_wrk_typ_id number,p_start_dt Date, p_end_dt Date) IS

Line 601: l_error_message_code fnd_new_messages.message_name%TYPE;

597: l_msg_index_out NUMBER;
598: l_menu_id NUMBER;
599: l_assignment_status_name PA_PROJECT_STATUSES.project_status_name%TYPE;
600: l_job_id NUMBER;
601: l_error_message_code fnd_new_messages.message_name%TYPE;
602: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
603: l_location_country_code pa_locations.country_code%TYPE;
604: l_resource_id pa_resources.resource_id%TYPE;
605: l_msg_count NUMBER;

Line 943: l_error_message_code fnd_new_messages.message_name%TYPE;

939: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
940: l_location_country_code fnd_territories.territory_code%TYPE;
941: l_calendar_id jtf_calendars_b.calendar_id%TYPE;
942: l_return_status VARCHAR2(1);
943: l_error_message_code fnd_new_messages.message_name%TYPE;
944: l_unfilled_assignment_id pa_project_assignments.assignment_id%TYPE;
945: l_resource_type_id NUMBER;
946: l_msg_index_out NUMBER;
947: l_msg_count NUMBER;

Line 2108: l_error_message_code fnd_new_messages.message_name%TYPE;

2104: l_source_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
2105: l_new_open_assignment_tbl PA_ASSIGNMENTS_PUB.Assignment_Tbl_Type;
2106: l_resource_source_id NUMBER;
2107: l_return_status VARCHAR2(1);
2108: l_error_message_code fnd_new_messages.message_name%TYPE;
2109: l_msg_count NUMBER;
2110: l_msg_data VARCHAR2(2000);
2111: l_new_open_asgn_id NUMBER;
2112: l_new_open_asgn_number NUMBER;

Line 4401: l_error_message_code fnd_new_messages.message_name%TYPE;

4397: l_tp_amount_type_desc VARCHAR2(80);
4398: l_msg_count NUMBER;
4399: l_msg_data VARCHAR2(2000);
4400: l_resource_type_id NUMBER;
4401: l_error_message_code fnd_new_messages.message_name%TYPE;
4402: l_msg_index_out NUMBER;
4403: l_valid_flag VARCHAR2(1);
4404: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
4405: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;