DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on FND_NEW_MESSAGES

Line 793: ,fnd_new_messages msg1

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

Line 794: ,fnd_new_messages msg2

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

Line 795: ,fnd_new_messages msg3

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'

Line 796: ,fnd_new_messages msg4

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

Line 797: ,fnd_new_messages msg5

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')

Line 1090: From fnd_new_messages msg

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: