789: ||msg3.message_text||':'||bl.resource_list_member_name||'; '||msg4.message_text||':'
790: ||bl.txn_currency_code||'; '||msg5.message_text||':'||bl.start_date||'; '
791: ||(substr(bl.other_rejection_msg_data,instr(bl.other_rejection_msg_data,';',-1)+1)))
792: FROM pa_fp_budget_line_rejections_v bl
793: ,fnd_new_messages msg1
794: ,fnd_new_messages msg2
795: ,fnd_new_messages msg3
796: ,fnd_new_messages msg4
797: ,fnd_new_messages msg5
790: ||bl.txn_currency_code||'; '||msg5.message_text||':'||bl.start_date||'; '
791: ||(substr(bl.other_rejection_msg_data,instr(bl.other_rejection_msg_data,';',-1)+1)))
792: FROM pa_fp_budget_line_rejections_v bl
793: ,fnd_new_messages msg1
794: ,fnd_new_messages msg2
795: ,fnd_new_messages msg3
796: ,fnd_new_messages msg4
797: ,fnd_new_messages msg5
798: WHERE bl.budget_version_id = p_budget_version_id
791: ||(substr(bl.other_rejection_msg_data,instr(bl.other_rejection_msg_data,';',-1)+1)))
792: FROM pa_fp_budget_line_rejections_v bl
793: ,fnd_new_messages msg1
794: ,fnd_new_messages msg2
795: ,fnd_new_messages msg3
796: ,fnd_new_messages msg4
797: ,fnd_new_messages msg5
798: WHERE bl.budget_version_id = p_budget_version_id
799: and msg1.message_name = 'PA_FP_PROJ_LABEL'
792: FROM pa_fp_budget_line_rejections_v bl
793: ,fnd_new_messages msg1
794: ,fnd_new_messages msg2
795: ,fnd_new_messages msg3
796: ,fnd_new_messages msg4
797: ,fnd_new_messages msg5
798: WHERE bl.budget_version_id = p_budget_version_id
799: and msg1.message_name = 'PA_FP_PROJ_LABEL'
800: and msg1.application_id = 275
793: ,fnd_new_messages msg1
794: ,fnd_new_messages msg2
795: ,fnd_new_messages msg3
796: ,fnd_new_messages msg4
797: ,fnd_new_messages msg5
798: WHERE bl.budget_version_id = p_budget_version_id
799: and msg1.message_name = 'PA_FP_PROJ_LABEL'
800: and msg1.application_id = 275
801: and msg1.language_code = userenv('LANG')
1086: FUNCTION getMsgtext(p_msg_name IN Varchar2) Return Varchar2 IS
1087:
1088: Cursor getMsgDetails IS
1089: Select substr(msg.message_text,instr(msg.message_text,';',-1)+1) message_text
1090: From fnd_new_messages msg
1091: Where msg.application_id = 275
1092: And msg.message_name = p_msg_name
1093: And msg.language_code = userenv('LANG');
1094: