DBA Data[Home] [Help]

APPS.FV_FACTS2_DERIVE_BALANCES dependencies on FND_FLEX_APIS

Line 333: --* : fnd_flex_apis.get_segment_column *--

329: --* : g_SUCCESS *--
330: --* Called from : derive_balances *--
331: --* Calls : fv_utility.debug_mesg *--
332: --* : fv_utility.log_mesg *--
333: --* : fnd_flex_apis.get_segment_column *--
334: --* Tables Used : gl_sets_of_books SELECT *--
335: --* : fnd_id_flex_segments SELECT *--
336: --* : gl_period_statuses SELECT *--
337: --* : fv_system_parameters SELECT *--

Line 340: --* : 2. Call fnd_flex_apis.get_segment_column with the chart of accounts *--

336: --* : gl_period_statuses SELECT *--
337: --* : fv_system_parameters SELECT *--
338: --* Logic : 1. Get the chart of accounts id from gl_sets_of_books using the *--
339: --* : set of books id. *--
340: --* : 2. Call fnd_flex_apis.get_segment_column with the chart of accounts *--
341: --* : id and get the GL_ACCOUNT segment name *--
342: --* : 3. From fnd_id_flex_segments using the chart of acconts id and the *--
343: --* : accounting segment name, get the Account value set id *--
344: --* : 4. From gl_period_statuses get the last non adjusting period for the *--

Line 416: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling fnd_flex_apis.get_segment_column');

412: END IF;
413:
414: IF (p_error_code = g_SUCCESS) THEN
415: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
416: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling fnd_flex_apis.get_segment_column');
417: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_application_id ='||l_application_id);
418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_id_flex_code ='||l_id_flex_code);
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_chart_of_accounts_id ='||p_chart_of_accounts_id);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_acct_seg_attr_type ='||l_acct_seg_attr_type);

Line 422: l_retval := fnd_flex_apis.get_segment_column

418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_id_flex_code ='||l_id_flex_code);
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_chart_of_accounts_id ='||p_chart_of_accounts_id);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_acct_seg_attr_type ='||l_acct_seg_attr_type);
421: END IF;
422: l_retval := fnd_flex_apis.get_segment_column
423: (
424: x_application_id => l_application_id,
425: x_id_flex_code => l_id_flex_code,
426: x_id_flex_num => p_chart_of_accounts_id,

Line 436: l_location := l_module_name||'call_fnd_flex_apis.get_segment_column';

432: END IF;
433: IF (NOT l_retval) THEN
434: p_error_code := g_FAILURE;
435: p_error_desc := fnd_message.get;
436: l_location := l_module_name||'call_fnd_flex_apis.get_segment_column';
437: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
438: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
439: END IF;
440: END IF;

Line 444: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling fnd_flex_apis.get_segment_column');

440: END IF;
441:
442: IF (p_error_code = g_SUCCESS) THEN
443: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
444: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling fnd_flex_apis.get_segment_column');
445: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_application_id ='||l_application_id);
446: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_id_flex_code ='||l_id_flex_code);
447: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_chart_of_accounts_id ='||p_chart_of_accounts_id);
448: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_acct_seg_attr_type ='||l_bal_seg_attr_type);

Line 450: l_retval := fnd_flex_apis.get_segment_column

446: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_id_flex_code ='||l_id_flex_code);
447: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_chart_of_accounts_id ='||p_chart_of_accounts_id);
448: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_acct_seg_attr_type ='||l_bal_seg_attr_type);
449: END IF;
450: l_retval := fnd_flex_apis.get_segment_column
451: (
452: x_application_id => l_application_id,
453: x_id_flex_code => l_id_flex_code,
454: x_id_flex_num => p_chart_of_accounts_id,

Line 464: l_location := l_module_name||'call_fnd_flex_apis.get_segment_column';

460: END IF;
461: IF (NOT l_retval) THEN
462: p_error_code := g_FAILURE;
463: p_error_desc := fnd_message.get;
464: l_location := l_module_name||'call_fnd_flex_apis.get_segment_column';
465: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
466: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
467: END IF;
468: END IF;