DBA Data[Home] [Help]

APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on FV_PYA_FISCALYEAR_SEGMENT

Line 599: FROM fv_pya_fiscalyear_segment a,

595: SELECT b.segment_num,
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

Line 614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);

610: p_error_code := c_FAILURE;
611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
612: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
613: p_error_desc := fnd_message.get;
614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
618: 'BFY Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);

Line 615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);

611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
612: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
613: p_error_desc := fnd_message.get;
614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
618: 'BFY Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
619: p_error_desc := fnd_message.get;

Line 620: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);

616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
618: 'BFY Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
619: p_error_desc := fnd_message.get;
620: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
621: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
622: l_ledger_rec.bfy_segment_num := NULL;
623: l_ledger_rec.fyr_segment_id := NULL;
624: END;

Line 621: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);

617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
618: 'BFY Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
619: p_error_desc := fnd_message.get;
620: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
621: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
622: l_ledger_rec.bfy_segment_num := NULL;
623: l_ledger_rec.fyr_segment_id := NULL;
624: END;
625: END IF;

Line 1415: FROM fv_pya_fiscalyear_segment

1411: IF (p_error_code = c_SUCCESS) THEN
1412: BEGIN
1413: SELECT template_id
1414: INTO l_template_id
1415: FROM fv_pya_fiscalyear_segment
1416: WHERE set_of_books_id = p_ledger_id;
1417: trace(C_STATE_LEVEL, l_procedure_name, 'l_template_id='||l_template_id);
1418: EXCEPTION
1419: WHEN NO_DATA_FOUND THEN

Line 1425: stack_error (l_procedure_name, 'SELECT_fv_pya_fiscalyear_segment', p_error_desc);

1421: WHEN OTHERS THEN
1422: p_error_code := c_FAILURE;
1423: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1424: p_error_desc := fnd_message.get;
1425: stack_error (l_procedure_name, 'SELECT_fv_pya_fiscalyear_segment', p_error_desc);
1426: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_pya_fiscalyear_segment:'||p_error_desc);
1427: END;
1428: END IF;
1429: trace(C_STATE_LEVEL, l_procedure_name, 'l_template_id='||l_template_id);

Line 1426: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_pya_fiscalyear_segment:'||p_error_desc);

1422: p_error_code := c_FAILURE;
1423: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1424: p_error_desc := fnd_message.get;
1425: stack_error (l_procedure_name, 'SELECT_fv_pya_fiscalyear_segment', p_error_desc);
1426: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_pya_fiscalyear_segment:'||p_error_desc);
1427: END;
1428: END IF;
1429: trace(C_STATE_LEVEL, l_procedure_name, 'l_template_id='||l_template_id);
1430: