DBA Data[Home] [Help]

APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on FV_UTILITY

Line 106: fv_utility.log_mesg('Parameters: ');

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:

Line 107: fv_utility.log_mesg('p_ledger_id: '||p_ledger_id);

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

Line 108: fv_utility.log_mesg('p_flex_low: '||p_flex_low);

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

Line 109: fv_utility.log_mesg('p_flex_high: '||p_flex_high);

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

Line 124: fv_utility.log_mesg('g_coa_id: '||g_coa_id);

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

Line 133: fv_utility.log_mesg('g_period_year: '||g_period_year);

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

Line 134: fv_utility.log_mesg('g_period_num: '||g_period_num);

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

Line 147: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;

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 .

Line 163: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;

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

Line 207: fv_utility.log_mesg('Agreement num: '||l_agree_num);

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:

Line 414: fv_utility.log_mesg('Concurrent Request Id for RX Report - ' ||l_req_id);

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,

Line 482: FV_UTILITY.get_segment_col_names(g_coa_id,

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

Line 532: fv_utility.log_mesg(fnd_log.level_error, l_module,g_errbuf) ;

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

Line 543: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;

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:

Line 582: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;

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

Line 725: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_ERRBUF) ;

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

Line 811: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'Incomplete Report Definition Setup',g_ERRBUF) ;

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;

Line 854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_l_main_cursor',g_ERRBUF) ;

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

Line 864: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_parse_l_main_cursor',g_ERRBUF) ;

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

Line 1032: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_execute_l_main_cursor',g_ERRBUF) ;

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