APPS.PA_MASS_ASGMT_TRX dependencies on FND_NEW_MESSAGES

Line 135: l_err_code fnd_new_messages.message_name%TYPE;

131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;
133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
135: l_err_code fnd_new_messages.message_name%TYPE;
136: l_err_stage VARCHAR2(2000);
137: l_err_stack VARCHAR2(2000);
138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 798: l_msg_data fnd_new_messages.message_text%TYPE;

794: l_err_stage VARCHAR2(2000);
795: l_err_stack VARCHAR2(2000);
796: l_return_status VARCHAR2(1);
797: l_msg_count NUMBER;
798: l_msg_data fnd_new_messages.message_text%TYPE;
799: l_success_assignments_link VARCHAR2(2000);
800: l_failure_assignments_link VARCHAR2(2000);
801: l_assignment_duration NUMBER;
802: l_result VARCHAR2(2000);

Line 814: l_message_name fnd_new_messages.message_name%TYPE;

810: l_overcommitment_flag VARCHAR2(1);
811: l_resolve_con_action_code pa_lookups.meaning%TYPE;
812: l_view_conflicts_link VARCHAR2(2000);
813: l_conf_asgmt_count NUMBER;
814: l_message_name fnd_new_messages.message_name%TYPE;
815: l_view_conf_action_text fnd_new_messages.message_text%TYPE;
816: l_calling_page VARCHAR2(30);
817:
818: ----Added following code for bug 6199871 and 9114634-----------------------

Line 815: l_view_conf_action_text fnd_new_messages.message_text%TYPE;

811: l_resolve_con_action_code pa_lookups.meaning%TYPE;
812: l_view_conflicts_link VARCHAR2(2000);
813: l_conf_asgmt_count NUMBER;
814: l_message_name fnd_new_messages.message_name%TYPE;
815: l_view_conf_action_text fnd_new_messages.message_text%TYPE;
816: l_calling_page VARCHAR2(30);
817:
818: ----Added following code for bug 6199871 and 9114634-----------------------
819: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

Line 1173: /* 2708879 - Added two conditions for application id and language code for the query from fnd_new_messages below */

1169: l_message_name := 'PA_NOTIFY_IF_CONFLICT';
1170:
1171: BEGIN
1172:
1173: /* 2708879 - Added two conditions for application id and language code for the query from fnd_new_messages below */
1174:
1175: SELECT message_text INTO l_view_conf_action_text
1176: FROM fnd_new_messages
1177: WHERE message_name = l_message_name

Line 1176: FROM fnd_new_messages

1172:
1173: /* 2708879 - Added two conditions for application id and language code for the query from fnd_new_messages below */
1174:
1175: SELECT message_text INTO l_view_conf_action_text
1176: FROM fnd_new_messages
1177: WHERE message_name = l_message_name
1178: and application_id = 275
1179: and language_code = userenv('LANG');
1180:

Line 1374: l_msg_data fnd_new_messages.message_text%TYPE;

1370: l_err_stage VARCHAR2(2000);
1371: l_err_stack VARCHAR2(2000);
1372: l_return_status VARCHAR2(1);
1373: l_msg_count NUMBER;
1374: l_msg_data fnd_new_messages.message_text%TYPE;
1375: l_number_of_resources NUMBER;
1376: l_number_of_assignments NUMBER;
1377: l_number_of_competencies NUMBER;
1378: l_success_assignments_link VARCHAR2(2000);

Line 2585: l_msg_data fnd_new_messages.message_text%TYPE;

2581: l_note_to_all_approvers VARCHAR2(2000);
2582: l_conflict_group_id NUMBER;
2583: l_return_status VARCHAR2(1);
2584: l_msg_count NUMBER;
2585: l_msg_data fnd_new_messages.message_text%TYPE;
2586: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2587: l_document VARCHAR2(32767);
2588: l_project_id pa_projects_all.project_id%TYPE;
2589: l_submitter_user_id NUMBER;

Line 2719: l_msg_data fnd_new_messages.message_text%TYPE;

2715:
2716: l_conflict_group_id NUMBER;
2717: l_return_status VARCHAR2(1);
2718: l_msg_count NUMBER;
2719: l_msg_data fnd_new_messages.message_text%TYPE;
2720:
2721: BEGIN
2722:
2723: --from the View Conflicts page from the notification to the submitter the