eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_BE_UTIL_PKG dependencies on FND_FLEX_EXT

Line 27: l_segarray fnd_flex_ext.segmentarray;

23: l_valid_flag BOOLEAN;
24: l_delim VARCHAR2(10);
25: l_num NUMBER;
26: l_module_name VARCHAR2(1000);
27: l_segarray fnd_flex_ext.segmentarray;
28: i NUMBER;
29: BEGIN
30: l_module_name := 'FV_BE_UTIL_PKG.has_segments_access';
31: l_valid_flag := FALSE;

Line 34: -- fnd_flex_ext.get_combination_id()

30: l_module_name := 'FV_BE_UTIL_PKG.has_segments_access';
31: l_valid_flag := FALSE;
32:
33: -- if p_ccid is null then fetch the ccid using
34: -- fnd_flex_ext.get_combination_id()
35: IF p_ccid IS NULL THEN
36: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'ccid is NULL');
37: l_delim := fnd_flex_ext.get_delimiter(
38: 'SQLGL'

Line 37: l_delim := fnd_flex_ext.get_delimiter(

33: -- if p_ccid is null then fetch the ccid using
34: -- fnd_flex_ext.get_combination_id()
35: IF p_ccid IS NULL THEN
36: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'ccid is NULL');
37: l_delim := fnd_flex_ext.get_delimiter(
38: 'SQLGL'
39: ,'GL#'
40: ,p_coa_id);
41: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'Delimiter ' || l_delim);

Line 43: l_num := fnd_flex_ext.breakup_segments(

39: ,'GL#'
40: ,p_coa_id);
41: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'Delimiter ' || l_delim);
42:
43: l_num := fnd_flex_ext.breakup_segments(
44: p_bud_segments
45: ,l_delim
46: ,l_segarray);
47: IF l_num IS NULL THEN

Line 48: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'fnd_flex_ext.breakup_segments() returned null');

44: p_bud_segments
45: ,l_delim
46: ,l_segarray);
47: IF l_num IS NULL THEN
48: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'fnd_flex_ext.breakup_segments() returned null');
49: END IF;
50:
51: FOR i IN l_segarray.FIRST .. l_segarray.LAST
52: LOOP

Line 57: l_valid_flag := fnd_flex_ext.get_combination_id

53: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name,'l_segarray('||i||') - '||l_segarray(i));
54: END LOOP;
55:
56: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'p_coa_id is ' || p_coa_id);
57: l_valid_flag := fnd_flex_ext.get_combination_id
58: (application_short_name => 'SQLGL'
59: ,key_flex_code => 'GL#'
60: ,structure_number => p_coa_id
61: ,validation_date => SYSDATE

Line 69: 'fnd_flex_ext.get_combination_id() ended with an error');

65: ,data_set => -1
66: );
67: IF l_valid_flag = FALSE THEN
68: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT, l_module_name,
69: 'fnd_flex_ext.get_combination_id() ended with an error');
70: RETURN 'FALSE';
71: ELSE
72: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name,
73: 'The API call fnd_flex_ext.get_combination_id() completed');

Line 73: 'The API call fnd_flex_ext.get_combination_id() completed');

69: 'fnd_flex_ext.get_combination_id() ended with an error');
70: RETURN 'FALSE';
71: ELSE
72: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name,
73: 'The API call fnd_flex_ext.get_combination_id() completed');
74: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'ccid is ' || l_ccid);
75: END IF;
76:
77: -- else we can directly call the API fnd_flex_ext.get_combination_id()

Line 77: -- else we can directly call the API fnd_flex_ext.get_combination_id()

73: 'The API call fnd_flex_ext.get_combination_id() completed');
74: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'ccid is ' || l_ccid);
75: END IF;
76:
77: -- else we can directly call the API fnd_flex_ext.get_combination_id()
78: ELSE
79: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'ccid is not NULL');
80: l_ccid := p_ccid;
81: FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT,l_module_name, 'ccid: '||l_ccid);

Line 98: --fnd_message.debug('fnd_flex_ext.get_combination_id() ended with an error');

94: ELSE
95: RETURN 'FALSE';
96: END IF;
97: --ELSE
98: --fnd_message.debug('fnd_flex_ext.get_combination_id() ended with an error');
99: --FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT, l_module_name,'fnd_flex_ext.get_combination_id() ended with an error');
100: --RETURN 'FALSE';
101: --END IF;
102:

Line 99: --FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT, l_module_name,'fnd_flex_ext.get_combination_id() ended with an error');

95: RETURN 'FALSE';
96: END IF;
97: --ELSE
98: --fnd_message.debug('fnd_flex_ext.get_combination_id() ended with an error');
99: --FV_UTILITY.DEBUG_MESG(G_LEVEL_STATEMENT, l_module_name,'fnd_flex_ext.get_combination_id() ended with an error');
100: --RETURN 'FALSE';
101: --END IF;
102:
103: EXCEPTION when others then

Line 114: p_header_segments fnd_flex_ext.SegmentArray,

110:
111: procedure check_cross_validation ( errbuf OUT NOCOPY varchar2,
112: retcode OUT NOCOPY number,
113: p_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE,
114: p_header_segments fnd_flex_ext.SegmentArray,
115: p_detail_segments fnd_flex_ext.SegmentArray,
116: p_budget_level_id fv_be_trx_hdrs.budget_level_id%TYPE,
117: p_transaction_type_id fv_be_trx_dtls.transaction_type_id%TYPE,
118: p_sub_type fv_be_trx_dtls.sub_type%TYPE,

Line 115: p_detail_segments fnd_flex_ext.SegmentArray,

111: procedure check_cross_validation ( errbuf OUT NOCOPY varchar2,
112: retcode OUT NOCOPY number,
113: p_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE,
114: p_header_segments fnd_flex_ext.SegmentArray,
115: p_detail_segments fnd_flex_ext.SegmentArray,
116: p_budget_level_id fv_be_trx_hdrs.budget_level_id%TYPE,
117: p_transaction_type_id fv_be_trx_dtls.transaction_type_id%TYPE,
118: p_sub_type fv_be_trx_dtls.sub_type%TYPE,
119: p_source fv_be_trx_hdrs.source%TYPE,

Line 131: l_gl_dr_segments fnd_flex_ext.SegmentArray;

127: l_valid_flag BOOLEAN;
128: l_dr_ccid NUMBER(15);
129: l_cr_ccid NUMBER(15);
130:
131: l_gl_dr_segments fnd_flex_ext.SegmentArray;
132: l_gl_cr_segments fnd_flex_ext.SegmentArray;
133:
134: l_dr_account gl_ussgl_account_pairs.dr_account_segment_value%TYPE;
135: l_cr_account gl_ussgl_account_pairs.cr_account_segment_value%TYPE;

Line 132: l_gl_cr_segments fnd_flex_ext.SegmentArray;

128: l_dr_ccid NUMBER(15);
129: l_cr_ccid NUMBER(15);
130:
131: l_gl_dr_segments fnd_flex_ext.SegmentArray;
132: l_gl_cr_segments fnd_flex_ext.SegmentArray;
133:
134: l_dr_account gl_ussgl_account_pairs.dr_account_segment_value%TYPE;
135: l_cr_account gl_ussgl_account_pairs.cr_account_segment_value%TYPE;
136:

Line 227: l_valid_flag := fnd_flex_ext.get_combination_id('SQLGL', 'GL#',

223: l_gl_cr_segments(g_gl_seg_num) := l_dr_account;
224: l_gl_dr_segments(g_gl_seg_num) := l_cr_account;
225: end if;
226:
227: l_valid_flag := fnd_flex_ext.get_combination_id('SQLGL', 'GL#',
228: g_chart_of_accounts_id, SYSDATE, g_n_segments, l_gl_cr_segments,l_cr_ccid);
229: if (not l_valid_flag) then
230: retcode := 2;
231: errbuf := fnd_flex_ext.get_message;

Line 231: errbuf := fnd_flex_ext.get_message;

227: l_valid_flag := fnd_flex_ext.get_combination_id('SQLGL', 'GL#',
228: g_chart_of_accounts_id, SYSDATE, g_n_segments, l_gl_cr_segments,l_cr_ccid);
229: if (not l_valid_flag) then
230: retcode := 2;
231: errbuf := fnd_flex_ext.get_message;
232: return;
233: end if;
234: l_valid_flag := fnd_flex_ext.get_combination_id('SQLGL', 'GL#',
235: g_chart_of_accounts_id, SYSDATE, g_n_segments, l_gl_dr_segments,l_dr_ccid);

Line 234: l_valid_flag := fnd_flex_ext.get_combination_id('SQLGL', 'GL#',

230: retcode := 2;
231: errbuf := fnd_flex_ext.get_message;
232: return;
233: end if;
234: l_valid_flag := fnd_flex_ext.get_combination_id('SQLGL', 'GL#',
235: g_chart_of_accounts_id, SYSDATE, g_n_segments, l_gl_dr_segments,l_dr_ccid);
236: if (not l_valid_flag) then
237: retcode := 2;
238: errbuf := fnd_flex_ext.get_message;

Line 238: errbuf := fnd_flex_ext.get_message;

234: l_valid_flag := fnd_flex_ext.get_combination_id('SQLGL', 'GL#',
235: g_chart_of_accounts_id, SYSDATE, g_n_segments, l_gl_dr_segments,l_dr_ccid);
236: if (not l_valid_flag) then
237: retcode := 2;
238: errbuf := fnd_flex_ext.get_message;
239: return;
240: end if;
241: end loop;
242: close accounts_cur;

Line 257: procedure initialize_gl_segments(p_from_segments IN fnd_flex_ext.SegmentArray,

253:
254: end; --check_cross_validation
255:
256:
257: procedure initialize_gl_segments(p_from_segments IN fnd_flex_ext.SegmentArray,
258: p_to_segments OUT NOCOPY fnd_flex_ext.SegmentArray) is
259:
260: l_module_name VARCHAR2(200) := g_module_name || 'initialize_gl_segments';
261:

Line 258: p_to_segments OUT NOCOPY fnd_flex_ext.SegmentArray) is

254: end; --check_cross_validation
255:
256:
257: procedure initialize_gl_segments(p_from_segments IN fnd_flex_ext.SegmentArray,
258: p_to_segments OUT NOCOPY fnd_flex_ext.SegmentArray) is
259:
260: l_module_name VARCHAR2(200) := g_module_name || 'initialize_gl_segments';
261:
262: cursor flex_fields is