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.XLA_JE_VALIDATION_PKG dependencies on FND_FLEX_EXT

Line 210: l_seg FND_FLEX_EXT.SegmentArray;

206: -- Bug Number : 10047740
207: --=============================================================================
208: PROCEDURE populate_bsv_suspense_ccid
209: IS
210: l_seg FND_FLEX_EXT.SegmentArray;
211: l_result INTEGER;
212: l_old_ccids t_array_int;
213: l_new_ccids t_array_int;
214: l_num_segments INTEGER;

Line 235: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)

231: ,t.code_combination_id
232: ;
233:
234: CURSOR c_account(p_coa_id INTEGER, p_code_combination_id INTEGER) IS
235: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)
236: FROM dual;
237:
238: CURSOR c_errors IS
239: SELECT entity_id

Line 293: IF ( FND_FLEX_EXT.get_segments(

289:
290: l_old_ccids(i) := l_ccid.code_combination_id;
291: l_bal_seg_values(i) := l_ccid.bal_seg_value;
292:
293: IF ( FND_FLEX_EXT.get_segments(
294: application_short_name => 'SQLGL',
295: key_flex_code => 'GL#',
296: structure_number => g_ledger_coa_id,
297: combination_id => l_ccid.code_combination_id ,

Line 301: trace(p_msg => 'FND_FLEX_EXT.get_segments failed',

297: combination_id => l_ccid.code_combination_id ,
298: n_segments => l_num_segments,
299: segments => l_seg) = FALSE ) THEN
300: IF (C_LEVEL_ERROR >= g_log_level) THEN
301: trace(p_msg => 'FND_FLEX_EXT.get_segments failed',
302: p_module => l_log_module,
303: p_level => C_LEVEL_ERROR);
304: END IF;
305:

Line 314: IF (FND_FLEX_EXT.get_combination_id(

310: FETCH c_seg_number INTO l_bal_seg_number;
311: CLOSE c_seg_number;
312:
313: l_seg(l_bal_seg_number) := l_ccid.bal_seg_value;
314: IF (FND_FLEX_EXT.get_combination_id(
315: application_short_name => 'SQLGL',
316: key_flex_code => 'GL#',
317: structure_number => g_ledger_coa_id,
318: validation_date => l_ccid.accounting_date,

Line 3933: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)

3929: g_err_hdr_ids(g_err_count) := l_err.ae_header_id;
3930: g_err_event_ids(g_err_count) := l_err.event_id;
3931:
3932: -- Check if the balancing segment value is valid for the ledger
3933: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)
3934: INTO l_account
3935: FROM dual;
3936:
3937: -- 4262811---------------------------------------------------------------------------------

Line 4059: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)

4055: g_err_hdr_ids(g_err_count) := l_err.ae_header_id;
4056: g_err_event_ids(g_err_count) := l_err.event_id;
4057:
4058: -- Check if the management segment value is valid for the ledger
4059: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)
4060: INTO l_account
4061: FROM dual;
4062:
4063: OPEN c_coa_structure_name(l_err.ccid_coa_id);

Line 4476: ,fnd_flex_ext.get_segs('SQLGL', 'GL#', t.ccid_coa_id, t.code_combination_id) account

4472: ,t.event_id
4473: ,t.displayed_line_number
4474: ,t.entity_id
4475: ,bud.budget_name
4476: ,fnd_flex_ext.get_segs('SQLGL', 'GL#', t.ccid_coa_id, t.code_combination_id) account
4477: FROM xla_validation_lines_gt t
4478: JOIN gl_budget_versions bud
4479: ON bud.budget_version_id = t.budget_version_id
4480: LEFT OUTER JOIN gl_budget_assignments b

Line 4696: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)

4692: FROM xla_validation_lines_gt
4693: WHERE error_flag = 'Y';
4694:
4695: CURSOR c_account(p_coa_id INTEGER, p_code_combination_id INTEGER) IS
4696: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)
4697: FROM dual;
4698:
4699: CURSOR c_je_source_name(l_lookup_code VARCHAR2) IS
4700: SELECT meaning

Line 5736: l_seg FND_FLEX_EXT.SegmentArray;

5732: l_mgt_seg_val VARCHAR2(30);
5733: l_ref3 VARCHAR2(30);
5734: l_seg_number NUMBER;
5735: l_sus_ccid INTEGER;
5736: l_seg FND_FLEX_EXT.SegmentArray;
5737: l_seg2 FND_FLEX_EXT.SegmentArray;
5738: l_coa_id INTEGER;
5739: l_num_segs INTEGER;
5740: l_result INTEGER := 0;

Line 5737: l_seg2 FND_FLEX_EXT.SegmentArray;

5733: l_ref3 VARCHAR2(30);
5734: l_seg_number NUMBER;
5735: l_sus_ccid INTEGER;
5736: l_seg FND_FLEX_EXT.SegmentArray;
5737: l_seg2 FND_FLEX_EXT.SegmentArray;
5738: l_coa_id INTEGER;
5739: l_num_segs INTEGER;
5740: l_result INTEGER := 0;
5741: l_stmt VARCHAR2(4000);

Line 5816: IF (FND_FLEX_EXT.get_segments(

5812: END;
5813:
5814: IF (l_sus_ccid IS NULL) THEN
5815:
5816: IF (FND_FLEX_EXT.get_segments(
5817: application_short_name => 'SQLGL',
5818: key_flex_code => 'GL#',
5819: structure_number => g_ledger_coa_id,
5820: combination_id => g_sla_ledger_cur_bal_sus_ccid,

Line 5853: IF (FND_FLEX_EXT.get_combination_id(

5849: FETCH c_seg_number INTO l_seg_number;
5850: CLOSE c_seg_number;
5851:
5852: l_seg(l_seg_number) := l_bal.bal_seg_val;
5853: IF (FND_FLEX_EXT.get_combination_id(
5854: application_short_name => 'SQLGL',
5855: key_flex_code => 'GL#',
5856: structure_number => g_ledger_coa_id,
5857: validation_date => l_bal.accounting_date,

Line 6460: l_seg FND_FLEX_EXT.SegmentArray;

6456: l_bal c_bal%ROWTYPE;
6457: l_ref3 VARCHAR2(30);
6458: l_mgt_seg_val VARCHAR2(30);
6459: l_seg_number NUMBER;
6460: l_seg FND_FLEX_EXT.SegmentArray;
6461: l_seg2 FND_FLEX_EXT.SegmentArray;
6462: l_num_segs INTEGER;
6463: l_coa_id INTEGER;
6464: l_stmt VARCHAR2(4000);

Line 6461: l_seg2 FND_FLEX_EXT.SegmentArray;

6457: l_ref3 VARCHAR2(30);
6458: l_mgt_seg_val VARCHAR2(30);
6459: l_seg_number NUMBER;
6460: l_seg FND_FLEX_EXT.SegmentArray;
6461: l_seg2 FND_FLEX_EXT.SegmentArray;
6462: l_num_segs INTEGER;
6463: l_coa_id INTEGER;
6464: l_stmt VARCHAR2(4000);
6465: l_entered_cr NUMBER;

Line 6588: IF (FND_FLEX_EXT.get_segments(

6584: END IF;
6585:
6586: IF (l_rounding_ccid IS NULL) THEN
6587:
6588: IF (FND_FLEX_EXT.get_segments(
6589: application_short_name => 'SQLGL',
6590: key_flex_code => 'GL#',
6591: structure_number => g_ledger_coa_id,
6592: combination_id => g_sla_rounding_ccid,

Line 6626: IF (FND_FLEX_EXT.get_combination_id(

6622: FETCH c_seg_number INTO l_seg_number;
6623: CLOSE c_seg_number;
6624:
6625: l_seg(l_seg_number) := l_bal.bal_seg_val;
6626: IF (FND_FLEX_EXT.get_combination_id(
6627: application_short_name => 'SQLGL',
6628: key_flex_code => 'GL#',
6629: structure_number => g_ledger_coa_id,
6630: validation_date => l_bal.accounting_date,

Line 6769: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_rounding_ccid)

6765:
6766: IF (NVL(l_rounding_ccid,-1) > 0 AND
6767: NVL(l_ref3,'N') NOT IN ( 'N','R') ) THEN
6768:
6769: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_rounding_ccid)
6770: INTO l_account
6771: FROM dual;
6772:
6773: xla_accounting_err_pkg.build_message(

Line 7115: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)

7111: ,p_ae_header_id => l_err.ae_header_id
7112: ,p_ae_line_num => NULL
7113: ,p_accounting_batch_id => NULL);
7114: ELSIF (l_err.error_code = 'FUN_INTRA_CC_NOT_VALID') THEN
7115: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)
7116: INTO l_account
7117: FROM dual;
7118:
7119: xla_accounting_err_pkg.build_message(

Line 7141: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)

7137: ,p_ae_header_id => l_err.ae_header_id
7138: ,p_ae_line_num => NULL
7139: ,p_accounting_batch_id => NULL);
7140: ELSIF (l_err.error_code = 'FUN_INTRA_CC_NOT_ACTIVE') THEN
7141: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)
7142: INTO l_account
7143: FROM dual;
7144:
7145: xla_accounting_err_pkg.build_message(

Line 7896: l_seg FND_FLEX_EXT.SegmentArray;

7892: PROCEDURE populate_missing_ccid
7893: (p_err_count IN OUT NOCOPY INTEGER
7894: ,p_err_hdr_ids IN OUT NOCOPY t_array_int)
7895: IS
7896: l_seg FND_FLEX_EXT.SegmentArray;
7897: l_result INTEGER;
7898: l_ccids t_array_int;
7899: l_reference3s t_array_varchar30;
7900: l_num_segments INTEGER;

Line 7991: IF ( FND_FLEX_EXT.get_segments(

7987: p_module => l_log_module,
7988: p_level => C_LEVEL_EVENT);
7989: END IF;
7990:
7991: IF ( FND_FLEX_EXT.get_segments(
7992: application_short_name => 'SQLGL',
7993: key_flex_code => 'GL#',
7994: structure_number => g_ledger_coa_id,
7995: combination_id => CASE l_ccid.balance_type_code -- 4458381

Line 8001: trace(p_msg => 'FND_FLEX_EXT.get_segments failed',

7997: ELSE g_sla_entered_cur_bal_sus_ccid END,
7998: n_segments => l_num_segments,
7999: segments => l_seg) = FALSE) THEN
8000: IF (C_LEVEL_ERROR >= g_log_level) THEN
8001: trace(p_msg => 'FND_FLEX_EXT.get_segments failed',
8002: p_module => l_log_module,
8003: p_level => C_LEVEL_ERROR);
8004: END IF;
8005:

Line 8015: IF (FND_FLEX_EXT.get_combination_id(

8011: FETCH c_seg_number INTO l_bal_seg_number;
8012: CLOSE c_seg_number;
8013:
8014: l_seg(l_bal_seg_number) := l_ccid.bal_seg_value;
8015: IF (FND_FLEX_EXT.get_combination_id(
8016: application_short_name => 'SQLGL',
8017: key_flex_code => 'GL#',
8018: structure_number => g_ledger_coa_id,
8019: validation_date => l_ccid.accounting_date,