DBA Data[Home] [Help]

APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on FV_PYA_FISCALYEAR_MAP

Line 979: l_bfy_map_year fv_pya_fiscalyear_map.period_year%TYPE;

975: )
976: IS
977: l_procedure_name VARCHAR2(100) := '.get_prior_year_status';
978: l_transaction_year gl_period_statuses.period_year%TYPE;
979: l_bfy_map_year fv_pya_fiscalyear_map.period_year%TYPE;
980: l_ledger_info LedgerRecType;
981:
982: BEGIN
983:

Line 1008: FROM fv_pya_fiscalyear_map

1004: IF (p_error_code = c_SUCCESS) THEN
1005: BEGIN
1006: SELECT period_year
1007: INTO l_bfy_map_year
1008: FROM fv_pya_fiscalyear_map
1009: WHERE set_of_books_id = p_ledger_id
1010: AND fyr_segment_id = l_ledger_info.fyr_segment_id
1011: AND fyr_segment_value = p_bfy_value;
1012: trace(C_STATE_LEVEL, l_procedure_name, 'l_bfy_map_year='||l_bfy_map_year);

Line 1021: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);

1017: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
1018: 'Segment Mapping is missing for the Ledger '||l_ledger_info.ledger_name||'. '||CRLF||
1019: 'Mapping of BFY Year '||p_bfy_value||' is missing.');
1020: p_error_desc := fnd_message.get;
1021: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1022: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1023: WHEN OTHERS THEN
1024: p_error_code := c_FAILURE;
1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 1022: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);

1018: 'Segment Mapping is missing for the Ledger '||l_ledger_info.ledger_name||'. '||CRLF||
1019: 'Mapping of BFY Year '||p_bfy_value||' is missing.');
1020: p_error_desc := fnd_message.get;
1021: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1022: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1023: WHEN OTHERS THEN
1024: p_error_code := c_FAILURE;
1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1026: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

Line 1028: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);

1024: p_error_code := c_FAILURE;
1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1026: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1027: p_error_desc := fnd_message.get;
1028: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1029: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1030: END;
1031: END IF;
1032:

Line 1029: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);

1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1026: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1027: p_error_desc := fnd_message.get;
1028: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1029: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1030: END;
1031: END IF;
1032:
1033: IF (p_error_code = c_SUCCESS) THEN