102: end loop;
103: log(C_STATE_LEVEL, l_module, 'Initialized the seg_codes');
104:
105:
106: fv_utility.log_mesg('Parameters: ');
107: fv_utility.log_mesg('p_ledger_id: '||p_ledger_id);
108: fv_utility.log_mesg('p_flex_low: '||p_flex_low);
109: fv_utility.log_mesg('p_flex_high: '||p_flex_high);
110:
103: log(C_STATE_LEVEL, l_module, 'Initialized the seg_codes');
104:
105:
106: fv_utility.log_mesg('Parameters: ');
107: fv_utility.log_mesg('p_ledger_id: '||p_ledger_id);
108: fv_utility.log_mesg('p_flex_low: '||p_flex_low);
109: fv_utility.log_mesg('p_flex_high: '||p_flex_high);
110:
111: log(C_STATE_LEVEL, l_module, 'p_report_id: '|| p_report_id);
104:
105:
106: fv_utility.log_mesg('Parameters: ');
107: fv_utility.log_mesg('p_ledger_id: '||p_ledger_id);
108: fv_utility.log_mesg('p_flex_low: '||p_flex_low);
109: fv_utility.log_mesg('p_flex_high: '||p_flex_high);
110:
111: log(C_STATE_LEVEL, l_module, 'p_report_id: '|| p_report_id);
112: log(C_STATE_LEVEL, l_module, 'p_attribute_set: '|| p_attribute_set);
105:
106: fv_utility.log_mesg('Parameters: ');
107: fv_utility.log_mesg('p_ledger_id: '||p_ledger_id);
108: fv_utility.log_mesg('p_flex_low: '||p_flex_low);
109: fv_utility.log_mesg('p_flex_high: '||p_flex_high);
110:
111: log(C_STATE_LEVEL, l_module, 'p_report_id: '|| p_report_id);
112: log(C_STATE_LEVEL, l_module, 'p_attribute_set: '|| p_attribute_set);
113: log(C_STATE_LEVEL, l_module, 'p_output_format: '|| p_output_format);
120: SELECT CHART_OF_ACCOUNTS_ID
121: INTO g_coa_id
122: FROM gl_ledgers
123: where ledger_id = g_ledger_id;
124: fv_utility.log_mesg('g_coa_id: '||g_coa_id);
125:
126: /* SELECT period_year, period_num
127: INTO g_period_year, g_period_num
128: FROM gl_period_statuses
129: WHERE application_id = 101
130: AND set_of_books_id = g_ledger_id
131: AND period_name = g_period_name;
132:
133: fv_utility.log_mesg('g_period_year: '||g_period_year);
134: fv_utility.log_mesg('g_period_num: '||g_period_num);
135: */
136:
137: -- Check whether set up done
130: AND set_of_books_id = g_ledger_id
131: AND period_name = g_period_name;
132:
133: fv_utility.log_mesg('g_period_year: '||g_period_year);
134: fv_utility.log_mesg('g_period_num: '||g_period_num);
135: */
136:
137: -- Check whether set up done
138: -- Check if Seed process was run
143:
144: IF l_seed_count=0 THEN
145: g_retcode := -1 ;
146: g_errbuf := ' Please run the Populate Reimbursable Activity Report Definitions Process .' ;
147: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;
148: RETURN ;
149: END IF;
150: -- Check whether Accounts are Defined in the form ,
151: -- Reimbursable Activity Report Definitions .
159: IF l_Acct_count=0 THEN
160: g_retcode := -1 ;
161: g_errbuf := ' Accounts not defined . Please define Accounts in the Reimbursable Activity Report
162: Definitions Form. ' ;
163: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;
164: RETURN ;
165: END IF;
166:
167: ----End of set up check
203: LOOP
204:
205: FETCH agree_cur INTO l_agree_num;
206:
207: fv_utility.log_mesg('Agreement num: '||l_agree_num);
208:
209: EXIT WHEN agree_cur%NOTFOUND;
210: -- call polulate_amount for each column_id
211:
410: p_errbuf := 'Error submitting RX Report ';
411: p_retcode := -1 ;
412: RETURN;
413: ELSE
414: fv_utility.log_mesg('Concurrent Request Id for RX Report - ' ||l_req_id);
415: END IF;
416:
417: l_call_status := Fnd_Concurrent.Wait_For_Request(
418: l_req_id, 20, 0, l_rphase, l_rstatus,
478: g_retcode := 0;
479:
480:
481: -- finding the Account and Balancing segments
482: FV_UTILITY.get_segment_col_names(g_coa_id,
483: g_gl_nat_acc_segment,
484: g_gl_balancing_segment,
485: l_error_code,
486: l_error_message);
528:
529: IF (g_delimiter IS NULL) THEN
530: g_retcode := 2 ;
531: g_errbuf := 'The Flexfield Structure is not found' ;
532: fv_utility.log_mesg(fnd_log.level_error, l_module,g_errbuf) ;
533: END IF;
534:
535: IF (g_retcode = 0) THEN
536: log(C_STATE_LEVEL, l_module, ' delimiter is ' ||g_delimiter);
539: EXCEPTION
540: WHEN OTHERS THEN
541: g_retcode := SQLCODE;
542: g_errbuf := SQLERRM;
543: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;
544: RAISE;
545: END get_segment_details;
546: -----------------------------------------------------------------
547:
578: EXCEPTION
579: WHEN OTHERS THEN
580: g_retcode := SQLCODE;
581: g_errbuf := SQLERRM;
582: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;
583: END Get_Application_Col_Names;
584: ---------------------------------------------------------------------
585: -- ------------------------------------------------------------------
586: -- Procedure Get_Segment_Values
721: EXCEPTION
722: WHEN OTHERS THEN
723: g_retcode := SQLCODE;
724: g_ERRBUF := SQLERRM;
725: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_ERRBUF) ;
726: RAISE;
727: END Get_Segment_Values ;
728: ------------------------------------
729: -- Procedure to poulate the gt table for all the columns
807: EXCEPTION
808: WHEN NO_DATA_FOUND then
809: g_retcode := SQLCODE;
810: g_ERRBUF := SQLERRM;
811: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'Incomplete Report Definition Setup',g_ERRBUF) ;
812: RAISE;
813: END;
814: -- Remove 'glcc.' from g_select
815: SELECT REPLACE(g_select, 'glcc.', '') INTO l_select_mod FROM dual;
850: EXCEPTION
851: WHEN OTHERS THEN
852: g_retcode := SQLCODE;
853: g_ERRBUF := SQLERRM;
854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_l_main_cursor',g_ERRBUF) ;
855: RAISE;
856: END ;
857:
858: BEGIN
860: EXCEPTION
861: WHEN OTHERS THEN
862: g_retcode := SQLCODE;
863: g_ERRBUF := SQLERRM;
864: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_parse_l_main_cursor',g_ERRBUF) ;
865: RAISE;
866: END ;
867:
868: --log(C_STATE_LEVEL, l_module, 'g_period_name: '|| g_period_name );
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: g_retcode := SQLCODE;
1031: g_ERRBUF := SQLERRM;
1032: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_execute_l_main_cursor',g_ERRBUF) ;
1033: RAISE;
1034: END ;
1035:
1036: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.execute' );