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 GL_PERIOD_STATUSES

Line 978: l_transaction_year gl_period_statuses.period_year%TYPE;

974: p_error_desc OUT NOCOPY VARCHAR2
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

Line 1037: FROM gl_period_statuses

1033: IF (p_error_code = c_SUCCESS) THEN
1034: BEGIN
1035: SELECT period_year
1036: INTO l_transaction_year
1037: FROM gl_period_statuses
1038: WHERE ledger_id = p_ledger_id
1039: AND application_id = p_application_id
1040: AND trunc(p_gl_date) BETWEEN start_date AND end_date
1041: AND adjustment_period_flag='N';

Line 1049: stack_error (l_procedure_name, 'SELECT_GL_PERIOD_STATUSES', p_error_desc);

1045: p_error_code := c_FAILURE;
1046: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1047: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1048: p_error_desc := fnd_message.get;
1049: stack_error (l_procedure_name, 'SELECT_GL_PERIOD_STATUSES', p_error_desc);
1050: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_PERIOD_STATUSES:'||p_error_desc);
1051: END;
1052: END IF;
1053:

Line 1050: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_PERIOD_STATUSES:'||p_error_desc);

1046: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1047: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1048: p_error_desc := fnd_message.get;
1049: stack_error (l_procedure_name, 'SELECT_GL_PERIOD_STATUSES', p_error_desc);
1050: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_PERIOD_STATUSES:'||p_error_desc);
1051: END;
1052: END IF;
1053:
1054: IF (p_error_code = c_SUCCESS) THEN

Line 1388: l_period_year gl_period_statuses.period_year%TYPE;

1384: -- Variable declartions for Dynamic SQL
1385: l_fund_cur_id INTEGER;
1386: l_fund_select VARCHAR2(2000);
1387: l_fund_ret INTEGER;
1388: l_period_year gl_period_statuses.period_year%TYPE;
1389: l_period_num gl_period_statuses.period_num%TYPE;
1390: l_period_name gl_period_statuses.period_name%TYPE;
1391:
1392: BEGIN

Line 1389: l_period_num gl_period_statuses.period_num%TYPE;

1385: l_fund_cur_id INTEGER;
1386: l_fund_select VARCHAR2(2000);
1387: l_fund_ret INTEGER;
1388: l_period_year gl_period_statuses.period_year%TYPE;
1389: l_period_num gl_period_statuses.period_num%TYPE;
1390: l_period_name gl_period_statuses.period_name%TYPE;
1391:
1392: BEGIN
1393: l_procedure_name := g_path_name || l_procedure_name;

Line 1390: l_period_name gl_period_statuses.period_name%TYPE;

1386: l_fund_select VARCHAR2(2000);
1387: l_fund_ret INTEGER;
1388: l_period_year gl_period_statuses.period_year%TYPE;
1389: l_period_num gl_period_statuses.period_num%TYPE;
1390: l_period_name gl_period_statuses.period_name%TYPE;
1391:
1392: BEGIN
1393: l_procedure_name := g_path_name || l_procedure_name;
1394: p_error_code := c_SUCCESS;

Line 1439: FROM gl_period_statuses

1435: period_name
1436: INTO l_period_year,
1437: l_period_num,
1438: l_period_name
1439: FROM gl_period_statuses
1440: WHERE ledger_id = p_ledger_id
1441: AND application_id = C_GL_APPLICATION
1442: AND adjustment_period_flag = 'N'
1443: AND p_gl_date BETWEEN start_date AND end_date;

Line 1452: stack_error (l_procedure_name, 'SELECT_gl_period_statuses', p_error_desc);

1448: WHEN OTHERS THEN
1449: p_error_code := c_FAILURE;
1450: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1451: p_error_desc := fnd_message.get;
1452: stack_error (l_procedure_name, 'SELECT_gl_period_statuses', p_error_desc);
1453: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_gl_period_statuses:'||p_error_desc);
1454: END;
1455: END IF;
1456:

Line 1453: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_gl_period_statuses:'||p_error_desc);

1449: p_error_code := c_FAILURE;
1450: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1451: p_error_desc := fnd_message.get;
1452: stack_error (l_procedure_name, 'SELECT_gl_period_statuses', p_error_desc);
1453: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_gl_period_statuses:'||p_error_desc);
1454: END;
1455: END IF;
1456:
1457: IF (p_error_code = c_SUCCESS AND l_template_id IS NOT NULL) THEN