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_FACTS_GL_PKG_EXT dependencies on GL_PERIOD_STATUSES

Line 155: --* Tables Used : gl_period_statuses SELECT *--

151: --* Called from : main *--
152: --* Calls : fv_utility.debug_mesg *--
153: --* : fv_utility.log_mesg *--
154: --* : get_fed_system_parameters *--
155: --* Tables Used : gl_period_statuses SELECT *--
156: --* : po_vendors SELECT *--
157: --* : ra_customers SELECT *--
158: --* : fnd_concurrent_programs SELECT *--
159: --* Logic : *--

Line 181: l_period_year gl_period_statuses.period_year%TYPE;

177: l_module_name VARCHAR2(200);
178: l_location VARCHAR2(200);
179: l_customer_attribute fv_system_parameters.factsi_customer_attribute%TYPE;
180: l_vendor_attribute fv_system_parameters.factsi_vendor_attribute%TYPE;
181: l_period_year gl_period_statuses.period_year%TYPE;
182: l_select_stmt VARCHAR2(1024);
183: l_cursor_id INTEGER;
184: l_ignore INTEGER;
185: BEGIN

Line 253: FROM gl_period_statuses gps

249: SELECT gps.period_year,
250: gps.period_num
251: INTO p_period_year,
252: p_from_period_num
253: FROM gl_period_statuses gps
254: WHERE gps.application_id = 101
255: AND gps.ledger_id = p_ledger_id --g_set_of_books_id
256: AND gps.period_name = p_from_period;
257: EXCEPTION

Line 261: l_location := l_module_name||'select_gl_period_statuses1';

257: EXCEPTION
258: WHEN NO_DATA_FOUND THEN
259: p_retcode := g_FAILURE;
260: p_errbuf := 'No From Period found '||p_from_period;
261: l_location := l_module_name||'select_gl_period_statuses1';
262: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
263: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
264: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
265: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 270: l_location := l_module_name||'select_gl_period_statuses1';

266: END IF;
267: WHEN OTHERS THEN
268: p_retcode := g_FAILURE;
269: p_errbuf := SQLERRM;
270: l_location := l_module_name||'select_gl_period_statuses1';
271: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
272: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
274: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 285: FROM gl_period_statuses gps

281: SELECT gps.period_year,
282: gps.period_num
283: INTO l_period_year,
284: p_to_period_num
285: FROM gl_period_statuses gps
286: WHERE gps.application_id = 101
287: AND gps.ledger_id = p_ledger_id --g_set_of_books_id
288: AND gps.period_name = p_to_period;
289: EXCEPTION

Line 293: l_location := l_module_name||'select_gl_period_statuses1';

289: EXCEPTION
290: WHEN NO_DATA_FOUND THEN
291: p_retcode := g_FAILURE;
292: p_errbuf := 'No To Period found '||p_from_period;
293: l_location := l_module_name||'select_gl_period_statuses1';
294: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
295: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
297: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 302: l_location := l_module_name||'select_gl_period_statuses1';

298: END IF;
299: WHEN OTHERS THEN
300: p_retcode := g_FAILURE;
301: p_errbuf := SQLERRM;
302: l_location := l_module_name||'select_gl_period_statuses1';
303: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
304: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 387: l_location := l_module_name||'select_gl_period_statuses1';

383: EXCEPTION
384: WHEN OTHERS THEN
385: p_retcode := g_FAILURE;
386: p_errbuf := SQLERRM;
387: l_location := l_module_name||'select_gl_period_statuses1';
388: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
389: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
391: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 493: l_from_period_num gl_period_statuses.period_num%TYPE;

489: l_location VARCHAR2(200);
490:
491: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
492: l_elimination_id po_vendors.attribute1%TYPE;
493: l_from_period_num gl_period_statuses.period_num%TYPE;
494: l_to_period_num gl_period_statuses.period_num%TYPE;
495: l_period_year gl_period_statuses.period_year%TYPE;
496: l_rows NUMBER := 0;
497: l_tot_rows NUMBER := 0;

Line 494: l_to_period_num gl_period_statuses.period_num%TYPE;

490:
491: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
492: l_elimination_id po_vendors.attribute1%TYPE;
493: l_from_period_num gl_period_statuses.period_num%TYPE;
494: l_to_period_num gl_period_statuses.period_num%TYPE;
495: l_period_year gl_period_statuses.period_year%TYPE;
496: l_rows NUMBER := 0;
497: l_tot_rows NUMBER := 0;
498:

Line 495: l_period_year gl_period_statuses.period_year%TYPE;

491: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
492: l_elimination_id po_vendors.attribute1%TYPE;
493: l_from_period_num gl_period_statuses.period_num%TYPE;
494: l_to_period_num gl_period_statuses.period_num%TYPE;
495: l_period_year gl_period_statuses.period_year%TYPE;
496: l_rows NUMBER := 0;
497: l_tot_rows NUMBER := 0;
498:
499: