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 796: l_msg_data fnd_new_messages.message_text%TYPE;

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

Line 812: l_message_name fnd_new_messages.message_name%TYPE;

808: l_overcommitment_flag VARCHAR2(1);
809: l_resolve_con_action_code pa_lookups.meaning%TYPE;
810: l_view_conflicts_link VARCHAR2(2000);
811: l_conf_asgmt_count NUMBER;
812: l_message_name fnd_new_messages.message_name%TYPE;
813: l_view_conf_action_text fnd_new_messages.message_text%TYPE;
814: l_calling_page VARCHAR2(30);
815:
816: TYPE success_failure_count_tbl IS TABLE OF NUMBER

Line 813: l_view_conf_action_text fnd_new_messages.message_text%TYPE;

809: l_resolve_con_action_code pa_lookups.meaning%TYPE;
810: l_view_conflicts_link VARCHAR2(2000);
811: l_conf_asgmt_count NUMBER;
812: l_message_name fnd_new_messages.message_name%TYPE;
813: l_view_conf_action_text fnd_new_messages.message_text%TYPE;
814: l_calling_page VARCHAR2(30);
815:
816: TYPE success_failure_count_tbl IS TABLE OF NUMBER
817: INDEX BY BINARY_INTEGER;

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

1113: l_message_name := 'PA_NOTIFY_IF_CONFLICT';
1114:
1115: BEGIN
1116:
1117: /* 2708879 - Added two conditions for application id and language code for the query from fnd_new_messages below */
1118:
1119: SELECT message_text INTO l_view_conf_action_text
1120: FROM fnd_new_messages
1121: WHERE message_name = l_message_name

Line 1120: FROM fnd_new_messages

1116:
1117: /* 2708879 - Added two conditions for application id and language code for the query from fnd_new_messages below */
1118:
1119: SELECT message_text INTO l_view_conf_action_text
1120: FROM fnd_new_messages
1121: WHERE message_name = l_message_name
1122: and application_id = 275
1123: and language_code = userenv('LANG');
1124:

Line 1317: l_msg_data fnd_new_messages.message_text%TYPE;

1313: l_err_stage VARCHAR2(2000);
1314: l_err_stack VARCHAR2(2000);
1315: l_return_status VARCHAR2(1);
1316: l_msg_count NUMBER;
1317: l_msg_data fnd_new_messages.message_text%TYPE;
1318: l_number_of_resources NUMBER;
1319: l_number_of_assignments NUMBER;
1320: l_number_of_competencies NUMBER;
1321: l_success_assignments_link VARCHAR2(2000);

Line 2528: l_msg_data fnd_new_messages.message_text%TYPE;

2524: l_note_to_all_approvers VARCHAR2(2000);
2525: l_conflict_group_id NUMBER;
2526: l_return_status VARCHAR2(1);
2527: l_msg_count NUMBER;
2528: l_msg_data fnd_new_messages.message_text%TYPE;
2529: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2530: l_document VARCHAR2(32767);
2531: l_project_id pa_projects_all.project_id%TYPE;
2532: l_submitter_user_id NUMBER;

Line 2660: l_msg_data fnd_new_messages.message_text%TYPE;

2656:
2657: l_conflict_group_id NUMBER;
2658: l_return_status VARCHAR2(1);
2659: l_msg_count NUMBER;
2660: l_msg_data fnd_new_messages.message_text%TYPE;
2661:
2662: BEGIN
2663:
2664: --from the View Conflicts page from the notification to the submitter the