[Home] [Help]
173: l_proc varchar2(72) := g_package||'.post_budget';
174: l_budget_details_rec pqh_budget_details%ROWTYPE;
175: l_log_context pqh_process_log.log_context%TYPE;
176: l_budget_detail_result varchar2(1);
177: l_message_text fnd_new_messages.message_text%TYPE;
178: l_dummy varchar2(10);
179:
180:
181: CURSOR csr_budget_detail_recs IS
373: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
374: l_gl_je_categories_rec gl_je_categories%ROWTYPE;
375: l_transfer_to_gl_flag varchar2(10);
376: l_message_text pqh_process_log.message_text%TYPE;
377: l_message_text_out fnd_new_messages.message_text%TYPE;
378: l_error_flag varchar2(10) := 'N';
379: l_level number;
380: l_batch_id number;
381: l_batch_context varchar2(2000);
1073: l_accounting_date gl_period_statuses.start_date%TYPE;
1074: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
1075: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1076: l_message_text pqh_process_log.message_text%TYPE;
1077: l_message_text_out fnd_new_messages.message_text%TYPE;
1078: l_count NUMBER;
1079: l_error_flag varchar2(10) := 'N';
1080: l_log_context pqh_process_log.log_context%TYPE;
1081:
5427: 'TRANSACTION USER REJ REASON')
5428: AND l.lookup_code = p_rejection_code
5429: UNION all
5430: SELECT message_text
5431: FROM fnd_new_messages fnd
5432: WHERE language_code = userenv('lang')
5433: AND fnd.message_name = p_rejection_code
5434: AND application_id = 275; -- PA
5435:
5432: WHERE language_code = userenv('lang')
5433: AND fnd.message_name = p_rejection_code
5434: AND application_id = 275; -- PA
5435:
5436: l_message fnd_new_messages.message_text%Type;
5437: begin
5438: open rej_msg;
5439: fetch rej_msg into l_message;
5440: close rej_msg;