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_SLA_UTL_PROCESSING_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 189: l_accounting_seg_num fnd_id_flex_segments.segment_num%TYPE;

185: l_debug_info VARCHAR2(240);
186: l_procedure_name VARCHAR2(100):='.get_bank_account_info';
187: l_bank_rec BankRecType;
188: l_coaid gl_code_combinations.chart_of_accounts_id%TYPE;
189: l_accounting_seg_num fnd_id_flex_segments.segment_num%TYPE;
190: l_result BOOLEAN;
191: l_no_of_segments NUMBER;
192: l_segments fnd_flex_ext.SegmentArray;
193:

Line 248: fnd_id_flex_segments b

244: BEGIN
245: SELECT b.segment_num
246: INTO l_accounting_seg_num
247: FROM fnd_segment_attribute_values a,
248: fnd_id_flex_segments b
249: WHERE a.application_id = b.application_id
250: AND a.id_flex_code = b.id_flex_code
251: AND a.id_flex_num = b.id_flex_num
252: AND a.application_column_name = b.application_column_name

Line 265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);

261: p_error_code := c_FAILURE;
262: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
263: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
264: p_error_desc := fnd_message.get;
265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
269: 'Accounting Segment is not Defined for the COA '||l_coaid);

Line 266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);

262: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
263: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
264: p_error_desc := fnd_message.get;
265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
269: 'Accounting Segment is not Defined for the COA '||l_coaid);
270: p_error_desc := fnd_message.get;

Line 271: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);

267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
269: 'Accounting Segment is not Defined for the COA '||l_coaid);
270: p_error_desc := fnd_message.get;
271: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
272: END;
273: END IF;
274:
275: IF (p_error_code = c_SUCCESS AND l_bank_rec.cash_bank_account_ccid IS NOT NULL) THEN

Line 524: fnd_id_flex_segments b

520: b.application_column_name
521: INTO l_ledger_rec.accounting_seg_num,
522: l_ledger_rec.accounting_seg_name
523: FROM fnd_segment_attribute_values a,
524: fnd_id_flex_segments b
525: WHERE a.application_id = b.application_id
526: AND a.id_flex_code = b.id_flex_code
527: AND a.id_flex_num = b.id_flex_num
528: AND a.application_column_name = b.application_column_name

Line 542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);

538: p_error_code := c_FAILURE;
539: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
540: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
541: p_error_desc := fnd_message.get;
542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
546: 'Accounting Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);

Line 543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);

539: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
540: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
541: p_error_desc := fnd_message.get;
542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
546: 'Accounting Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
547: p_error_desc := fnd_message.get;

Line 548: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);

544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
546: 'Accounting Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
547: p_error_desc := fnd_message.get;
548: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
549: l_ledger_rec.balancing_seg_num := NULL;
550: l_ledger_rec.balancing_seg_name := NULL;
551: END;
552: END IF;

Line 562: fnd_id_flex_segments b

558: b.application_column_name
559: INTO l_ledger_rec.balancing_seg_num,
560: l_ledger_rec.balancing_seg_name
561: FROM fnd_segment_attribute_values a,
562: fnd_id_flex_segments b
563: WHERE a.application_id = b.application_id
564: AND a.id_flex_code = b.id_flex_code
565: AND a.id_flex_num = b.id_flex_num
566: AND a.application_column_name = b.application_column_name

Line 580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);

576: p_error_code := c_FAILURE;
577: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
578: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
579: p_error_desc := fnd_message.get;
580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);
582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||
584: 'Balancing Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);

Line 581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);

577: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
578: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
579: p_error_desc := fnd_message.get;
580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);
582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||
584: 'Balancing Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
585: p_error_desc := fnd_message.get;

Line 586: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);

582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||
584: 'Balancing Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
585: p_error_desc := fnd_message.get;
586: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
587: l_ledger_rec.balancing_seg_num := NULL;
588: l_ledger_rec.balancing_seg_name := NULL;
589: END;
590: END IF;

Line 600: fnd_id_flex_segments b

596: a.fyr_segment_id
597: INTO l_ledger_rec.bfy_segment_num,
598: l_ledger_rec.fyr_segment_id
599: FROM fv_pya_fiscalyear_segment a,
600: fnd_id_flex_segments b
601: WHERE set_of_books_id = p_ledger_id
602: AND a.application_column_name = b.application_column_name
603: AND b.application_id = C_GL_APPLICATION
604: AND b.id_flex_code = C_GL_FLEX_CODE