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.FII_GL_BUDGET_EXTRACTION dependencies on FII_UTIL

Line 27: FII_UTIL.write_log('Calling procedure: INIT');

23: G_UNASSIGNED_API_ERROR EXCEPTION;
24: BEGIN
25:
26: if g_debug_flag = 'Y' then
27: FII_UTIL.write_log('Calling procedure: INIT');
28: FII_UTIL.write_log('');
29: end if;
30:
31: g_phase := 'Find currency information.';

Line 28: FII_UTIL.write_log('');

24: BEGIN
25:
26: if g_debug_flag = 'Y' then
27: FII_UTIL.write_log('Calling procedure: INIT');
28: FII_UTIL.write_log('');
29: end if;
30:
31: g_phase := 'Find currency information.';
32:

Line 50: FII_UTIL.write_log('User ID: ' || g_fii_user_id || ' Login ID: ' || g_fii_login_id);

46: RAISE G_LOGIN_INFO_NOT_AVABLE;
47: END IF;
48:
49: IF g_debug_flag = 'Y' THEN
50: FII_UTIL.write_log('User ID: ' || g_fii_user_id || ' Login ID: ' || g_fii_login_id);
51: END IF;
52:
53: g_phase := 'Find the unassigned value for user_dim1 and user dim2.';
54:

Line 65: FII_UTIL.write_log('Init: can not get User ID and Login ID, program exits.');

61:
62: EXCEPTION
63: WHEN G_LOGIN_INFO_NOT_AVABLE THEN
64: retcode := 'E';
65: FII_UTIL.write_log('Init: can not get User ID and Login ID, program exits.');
66: raise;
67: WHEN G_UNASSIGNED_API_ERROR THEN
68: retcode := 'E';
69: FII_UTIL.write_log('Init: UNASSIGNED value API errored, program exits.');

Line 69: FII_UTIL.write_log('Init: UNASSIGNED value API errored, program exits.');

65: FII_UTIL.write_log('Init: can not get User ID and Login ID, program exits.');
66: raise;
67: WHEN G_UNASSIGNED_API_ERROR THEN
68: retcode := 'E';
69: FII_UTIL.write_log('Init: UNASSIGNED value API errored, program exits.');
70: raise;
71: WHEN OTHERS THEN
72: retcode := 'E';
73: FII_UTIL.write_log('

Line 73: FII_UTIL.write_log('

69: FII_UTIL.write_log('Init: UNASSIGNED value API errored, program exits.');
70: raise;
71: WHEN OTHERS THEN
72: retcode := 'E';
73: FII_UTIL.write_log('
74: ---------------------------------
75: Error in Procedure: INIT
76: Phase: '||g_phase||'
77: Message: '||sqlerrm);

Line 251: FII_UTIL.write_log('');

247: g_phase := 'Start of main routine in FII_GL_BUDGET_EXTRACTION.';
248: retcode := 'S';
249:
250: if g_debug_flag = 'Y' then
251: FII_UTIL.write_log('');
252: FII_UTIL.write_log(g_phase);
253: end if;
254:
255: ------------------------

Line 252: FII_UTIL.write_log(g_phase);

248: retcode := 'S';
249:
250: if g_debug_flag = 'Y' then
251: FII_UTIL.write_log('');
252: FII_UTIL.write_log(g_phase);
253: end if;
254:
255: ------------------------
256: -- Enable DBMS_OUTPUT --

Line 271: FII_UTIL.write_log(g_phase);

267: ----- FII Budget Source Profile Option must be set to 'GL'
268: ---------------------------------------------------------
269: g_phase := 'Checking the FII Budget Source Profile Option.';
270: if g_debug_flag = 'Y' then
271: FII_UTIL.write_log(g_phase);
272: end if;
273:
274: IF FND_PROFILE.value('FII_BUDGET_SOURCE') <> 'GL' THEN
275: FII_MESSAGE.Write_Log

Line 287: FII_UTIL.write_log(g_phase);

283: --- Truncate temp table -------------------------------------
284: -------------------------------------------------------------
285: g_phase := 'Truncating temp table FII_GL_BUDGET_EXTRACT_T.';
286: if g_debug_flag = 'Y' then
287: FII_UTIL.write_log(g_phase);
288: end if;
289:
290: fii_util.truncate_table('FII_GL_BUDGET_EXTRACT_T', 'FII', l_retcode);
291: IF l_retcode = -1 then

Line 290: fii_util.truncate_table('FII_GL_BUDGET_EXTRACT_T', 'FII', l_retcode);

286: if g_debug_flag = 'Y' then
287: FII_UTIL.write_log(g_phase);
288: end if;
289:
290: fii_util.truncate_table('FII_GL_BUDGET_EXTRACT_T', 'FII', l_retcode);
291: IF l_retcode = -1 then
292: fii_util.write_log('Error in fii_util.truncate_table(''FII_GL_BUDGET_EXTRACT_T'', ''FII'', l_retcode)');
293: raise FIIBUDX_fatal_err;
294: END IF;

Line 292: fii_util.write_log('Error in fii_util.truncate_table(''FII_GL_BUDGET_EXTRACT_T'', ''FII'', l_retcode)');

288: end if;
289:
290: fii_util.truncate_table('FII_GL_BUDGET_EXTRACT_T', 'FII', l_retcode);
291: IF l_retcode = -1 then
292: fii_util.write_log('Error in fii_util.truncate_table(''FII_GL_BUDGET_EXTRACT_T'', ''FII'', l_retcode)');
293: raise FIIBUDX_fatal_err;
294: END IF;
295:
296: ----------------------------------------------------

Line 303: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');

299: g_phase := 'Call program that populates CCC - Mgr mappings temp. table.';
300: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
301:
302: IF l_status = -1 then
303: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
304: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
305: raise NO_DATA_FOUND;
306: END IF;
307:

Line 304: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');

300: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
301:
302: IF l_status = -1 then
303: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
304: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
305: raise NO_DATA_FOUND;
306: END IF;
307:
308:

Line 315: FII_UTIL.write_log('');

311: -------------------------------------------------------------
312: g_phase := 'Extract budgets from gl_balances into temp table FII_GL_BUDGET_EXTRACT_T';
313:
314: if g_debug_flag = 'Y' then
315: FII_UTIL.write_log('');
316: FII_UTIL.write_log(g_phase);
317: FII_UTIL.start_timer;
318: end if;
319:

Line 316: FII_UTIL.write_log(g_phase);

312: g_phase := 'Extract budgets from gl_balances into temp table FII_GL_BUDGET_EXTRACT_T';
313:
314: if g_debug_flag = 'Y' then
315: FII_UTIL.write_log('');
316: FII_UTIL.write_log(g_phase);
317: FII_UTIL.start_timer;
318: end if;
319:
320: INSERT /*+ append parallel(t) */ INTO FII_GL_BUDGET_EXTRACT_T t

Line 317: FII_UTIL.start_timer;

313:
314: if g_debug_flag = 'Y' then
315: FII_UTIL.write_log('');
316: FII_UTIL.write_log(g_phase);
317: FII_UTIL.start_timer;
318: end if;
319:
320: INSERT /*+ append parallel(t) */ INTO FII_GL_BUDGET_EXTRACT_T t
321: (plan_type_code_flag,

Line 421: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');

417: /* l_row_count := SQL%ROWCOUNT; */
418: /* DBMS_OUTPUT.put_line('Inserted ' || TO_CHAR(l_row_count) || ' rows in FII_GL_BUDGET_EXTRACT_T.'); */
419: /* l_row_count := 0; */
420: if g_debug_flag = 'Y' then
421: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');
422: FII_UTIL.stop_timer;
423: FII_UTIL.print_timer('Duration');
424: end if;
425:

Line 422: FII_UTIL.stop_timer;

418: /* DBMS_OUTPUT.put_line('Inserted ' || TO_CHAR(l_row_count) || ' rows in FII_GL_BUDGET_EXTRACT_T.'); */
419: /* l_row_count := 0; */
420: if g_debug_flag = 'Y' then
421: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');
422: FII_UTIL.stop_timer;
423: FII_UTIL.print_timer('Duration');
424: end if;
425:
426: commit;

Line 423: FII_UTIL.print_timer('Duration');

419: /* l_row_count := 0; */
420: if g_debug_flag = 'Y' then
421: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');
422: FII_UTIL.stop_timer;
423: FII_UTIL.print_timer('Duration');
424: end if;
425:
426: commit;
427:

Line 439: FII_UTIL.write_log('');

435: -------------------------------------
436: g_phase := 'Warn user of periods not translated to primary currency.';
437:
438: if g_debug_flag = 'Y' then
439: FII_UTIL.write_log('');
440: FII_UTIL.write_log(g_phase);
441: end if;
442:
443: OPEN miss_per_cur_prim;

Line 440: FII_UTIL.write_log(g_phase);

436: g_phase := 'Warn user of periods not translated to primary currency.';
437:
438: if g_debug_flag = 'Y' then
439: FII_UTIL.write_log('');
440: FII_UTIL.write_log(g_phase);
441: end if;
442:
443: OPEN miss_per_cur_prim;
444: FETCH miss_per_cur_prim INTO miss_per_rec_prim;

Line 448: FII_UTIL.write_output('---------------------------------------------------------------------');

444: FETCH miss_per_cur_prim INTO miss_per_rec_prim;
445:
446: If (miss_per_cur_prim%ROWCOUNT > 0) THEN
447:
448: FII_UTIL.write_output('---------------------------------------------------------------------');
449: FII_MESSAGE.write_output(msg_name => 'FII_CUR1_TRANS_REC',
450: token_num => 0);
451: FII_UTIL.write_output('('||miss_per_rec_prim.ledger_name||
452: ', '||miss_per_rec_prim.budget_name||

Line 451: FII_UTIL.write_output('('||miss_per_rec_prim.ledger_name||

447:
448: FII_UTIL.write_output('---------------------------------------------------------------------');
449: FII_MESSAGE.write_output(msg_name => 'FII_CUR1_TRANS_REC',
450: token_num => 0);
451: FII_UTIL.write_output('('||miss_per_rec_prim.ledger_name||
452: ', '||miss_per_rec_prim.budget_name||
453: ', '||miss_per_rec_prim.period_name||')');
454:
455: /* DBMS_OUTPUT.put_line('---------------------------------------------------------------------'); */

Line 465: FII_UTIL.write_output('('||miss_per_rec_prim.ledger_name||

461:
462: LOOP
463: FETCH miss_per_cur_prim INTO miss_per_rec_prim;
464: EXIT WHEN miss_per_cur_prim%NOTFOUND;
465: FII_UTIL.write_output('('||miss_per_rec_prim.ledger_name||
466: ', '||miss_per_rec_prim.budget_name||
467: ', '||miss_per_rec_prim.period_name||')');
468:
469: /* DBMS_OUTPUT.PUT_LINE('Ledger: '||miss_per_rec_prim.ledger_name|| */

Line 473: FII_UTIL.write_output('---------------------------------------------------------------------');

469: /* DBMS_OUTPUT.PUT_LINE('Ledger: '||miss_per_rec_prim.ledger_name|| */
470: /* ', Budget: '||miss_per_rec_prim.budget_name|| */
471: /* ', Period: '||miss_per_rec_prim.period_name); */
472: END LOOP;
473: FII_UTIL.write_output('---------------------------------------------------------------------');
474: /* DBMS_OUTPUT.put_line('---------------------------------------------------------------------'); */
475:
476: retcode := 'W';
477: END IF;

Line 487: FII_UTIL.write_log('');

483: -------------------------------------
484: g_phase := 'Warn user of periods not translated to secondary currency.';
485:
486: if g_debug_flag = 'Y' then
487: FII_UTIL.write_log('');
488: FII_UTIL.write_log(g_phase);
489: end if;
490:
491: -- Bugfix 6053573

Line 488: FII_UTIL.write_log(g_phase);

484: g_phase := 'Warn user of periods not translated to secondary currency.';
485:
486: if g_debug_flag = 'Y' then
487: FII_UTIL.write_log('');
488: FII_UTIL.write_log(g_phase);
489: end if;
490:
491: -- Bugfix 6053573
492:

Line 500: FII_UTIL.write_output('---------------------------------------------------------------------');

496: FETCH miss_per_cur_sec INTO miss_per_rec_sec;
497:
498: If (miss_per_cur_sec%ROWCOUNT > 0) THEN
499:
500: FII_UTIL.write_output('---------------------------------------------------------------------');
501: FII_MESSAGE.write_output(msg_name => 'FII_CUR2_TRANS_REC',
502: token_num => 0);
503: FII_UTIL.write_output('('||miss_per_rec_sec.ledger_name||
504: ', '||miss_per_rec_sec.budget_name||

Line 503: FII_UTIL.write_output('('||miss_per_rec_sec.ledger_name||

499:
500: FII_UTIL.write_output('---------------------------------------------------------------------');
501: FII_MESSAGE.write_output(msg_name => 'FII_CUR2_TRANS_REC',
502: token_num => 0);
503: FII_UTIL.write_output('('||miss_per_rec_sec.ledger_name||
504: ', '||miss_per_rec_sec.budget_name||
505: ', '||miss_per_rec_sec.period_name||')');
506:
507: /* DBMS_OUTPUT.put_line('---------------------------------------------------------------------'); */

Line 517: FII_UTIL.write_output('('||miss_per_rec_sec.ledger_name||

513:
514: LOOP
515: FETCH miss_per_cur_sec INTO miss_per_rec_sec;
516: EXIT WHEN miss_per_cur_sec%NOTFOUND;
517: FII_UTIL.write_output('('||miss_per_rec_sec.ledger_name||
518: ', '||miss_per_rec_sec.budget_name||
519: ', '||miss_per_rec_sec.period_name||')');
520: /* DBMS_OUTPUT.PUT_LINE('Ledger: '||miss_per_rec_sec.ledger_name|| */
521: /* ', Budget: '||miss_per_rec_sec.budget_name|| */

Line 524: FII_UTIL.write_output('---------------------------------------------------------------------');

520: /* DBMS_OUTPUT.PUT_LINE('Ledger: '||miss_per_rec_sec.ledger_name|| */
521: /* ', Budget: '||miss_per_rec_sec.budget_name|| */
522: /* ', Period: '||miss_per_rec_sec.period_name); */
523: END LOOP;
524: FII_UTIL.write_output('---------------------------------------------------------------------');
525: /* DBMS_OUTPUT.put_line('---------------------------------------------------------------------'); */
526:
527: retcode := 'W';
528: END IF;

Line 538: FII_UTIL.write_log('');

534: -------------------------------------
535: g_phase := 'Warn user of names of any duplicate budgets that have been aggregated.';
536:
537: if g_debug_flag = 'Y' then
538: FII_UTIL.write_log('');
539: FII_UTIL.write_log(g_phase);
540: end if;
541: OPEN dup_cur;
542: FETCH dup_cur INTO dup_rec;

Line 539: FII_UTIL.write_log(g_phase);

535: g_phase := 'Warn user of names of any duplicate budgets that have been aggregated.';
536:
537: if g_debug_flag = 'Y' then
538: FII_UTIL.write_log('');
539: FII_UTIL.write_log(g_phase);
540: end if;
541: OPEN dup_cur;
542: FETCH dup_cur INTO dup_rec;
543:

Line 546: FII_UTIL.write_output('---------------------------------------------------------------------');

542: FETCH dup_cur INTO dup_rec;
543:
544: If (dup_cur%ROWCOUNT > 0) THEN
545:
546: FII_UTIL.write_output('---------------------------------------------------------------------');
547: FII_MESSAGE.write_output(msg_name => 'FII_DUP_REC_AGG_REC',
548: token_num => 0);
549: FII_UTIL.write_output('('||dup_rec.concatenated_segments||
550: ', '||dup_rec.ledger_name||

Line 549: FII_UTIL.write_output('('||dup_rec.concatenated_segments||

545:
546: FII_UTIL.write_output('---------------------------------------------------------------------');
547: FII_MESSAGE.write_output(msg_name => 'FII_DUP_REC_AGG_REC',
548: token_num => 0);
549: FII_UTIL.write_output('('||dup_rec.concatenated_segments||
550: ', '||dup_rec.ledger_name||
551: ', '||dup_rec.budget_name||')');
552:
553: /* DBMS_OUTPUT.put_line('Following is a list of budgets with duplicate code combinations and time periods: */

Line 562: FII_UTIL.write_output('('||dup_rec.concatenated_segments||

558:
559: LOOP
560: FETCH dup_cur INTO dup_rec;
561: EXIT WHEN dup_cur%NOTFOUND;
562: FII_UTIL.write_output('('||dup_rec.concatenated_segments||
563: ', '||dup_rec.ledger_name||
564: ', '||dup_rec.budget_name||')');
565: /* DBMS_OUTPUT.PUT_LINE('Ledger: '||dup_rec.ledger_name|| */
566: /* ', Budget: '||dup_rec.budget_name); */

Line 568: FII_UTIL.write_output('---------------------------------------------------------------------');

564: ', '||dup_rec.budget_name||')');
565: /* DBMS_OUTPUT.PUT_LINE('Ledger: '||dup_rec.ledger_name|| */
566: /* ', Budget: '||dup_rec.budget_name); */
567: END LOOP;
568: FII_UTIL.write_output('---------------------------------------------------------------------');
569: /* DBMS_OUTPUT.put_line('---------------------------------------------------------------------------------'); */
570:
571: retcode := 'W';
572: END IF;

Line 588: FII_UTIL.write_log('');

584: ----------------------------------------------------------------------------
585: g_phase := 'Inserting second time into temp table FII_GL_BUDGET_EXTRACT_T.';
586:
587: if g_debug_flag = 'Y' then
588: FII_UTIL.write_log('');
589: FII_UTIL.write_log(g_phase);
590: FII_UTIL.start_timer;
591: end if;
592:

Line 589: FII_UTIL.write_log(g_phase);

585: g_phase := 'Inserting second time into temp table FII_GL_BUDGET_EXTRACT_T.';
586:
587: if g_debug_flag = 'Y' then
588: FII_UTIL.write_log('');
589: FII_UTIL.write_log(g_phase);
590: FII_UTIL.start_timer;
591: end if;
592:
593: INSERT /*+ append parallel(t) */ INTO FII_GL_BUDGET_EXTRACT_T t

Line 590: FII_UTIL.start_timer;

586:
587: if g_debug_flag = 'Y' then
588: FII_UTIL.write_log('');
589: FII_UTIL.write_log(g_phase);
590: FII_UTIL.start_timer;
591: end if;
592:
593: INSERT /*+ append parallel(t) */ INTO FII_GL_BUDGET_EXTRACT_T t
594: (plan_type_code_flag,

Line 672: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');

668: --It will also have to be added to the delete statement.
669:
670:
671: if g_debug_flag = 'Y' then
672: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');
673: FII_UTIL.stop_timer;
674: FII_UTIL.print_timer('Duration');
675: end if;
676:

Line 673: FII_UTIL.stop_timer;

669:
670:
671: if g_debug_flag = 'Y' then
672: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');
673: FII_UTIL.stop_timer;
674: FII_UTIL.print_timer('Duration');
675: end if;
676:
677: commit;

Line 674: FII_UTIL.print_timer('Duration');

670:
671: if g_debug_flag = 'Y' then
672: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_BUDGET_EXTRACT_T.');
673: FII_UTIL.stop_timer;
674: FII_UTIL.print_timer('Duration');
675: end if;
676:
677: commit;
678:

Line 685: FII_UTIL.write_log('');

681: -------------------------------------------------------------
682: g_phase := 'Rolling Up on time in temp table FII_GL_BUDGET_EXTRACT_T.';
683:
684: if g_debug_flag = 'Y' then
685: FII_UTIL.write_log('');
686: FII_UTIL.write_log(g_phase);
687: FII_UTIL.start_timer;
688: end if;
689:

Line 686: FII_UTIL.write_log(g_phase);

682: g_phase := 'Rolling Up on time in temp table FII_GL_BUDGET_EXTRACT_T.';
683:
684: if g_debug_flag = 'Y' then
685: FII_UTIL.write_log('');
686: FII_UTIL.write_log(g_phase);
687: FII_UTIL.start_timer;
688: end if;
689:
690: INSERT /*+ append parallel(a) */ INTO FII_GL_BUDGET_EXTRACT_T a

Line 687: FII_UTIL.start_timer;

683:
684: if g_debug_flag = 'Y' then
685: FII_UTIL.write_log('');
686: FII_UTIL.write_log(g_phase);
687: FII_UTIL.start_timer;
688: end if;
689:
690: INSERT /*+ append parallel(a) */ INTO FII_GL_BUDGET_EXTRACT_T a
691: (plan_type_code_flag,

Line 746: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' Roll Up rows in FII_GL_BUDGET_EXTRACT_T on time.');

742: period.ent_qtr_id)
743: HAVING period.ent_year_id is not null;
744:
745: if g_debug_flag = 'Y' then
746: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' Roll Up rows in FII_GL_BUDGET_EXTRACT_T on time.');
747: FII_UTIL.stop_timer;
748: FII_UTIL.print_timer('Duration');
749: end if;
750: /* l_row_count := SQL%ROWCOUNT; */

Line 747: FII_UTIL.stop_timer;

743: HAVING period.ent_year_id is not null;
744:
745: if g_debug_flag = 'Y' then
746: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' Roll Up rows in FII_GL_BUDGET_EXTRACT_T on time.');
747: FII_UTIL.stop_timer;
748: FII_UTIL.print_timer('Duration');
749: end if;
750: /* l_row_count := SQL%ROWCOUNT; */
751: /* DBMS_OUTPUT.put_line('Rolled Up ' || TO_CHAR(l_row_count) || ' rows in FII_GL_BUDGET_EXTRACT_T on time.'); */

Line 748: FII_UTIL.print_timer('Duration');

744:
745: if g_debug_flag = 'Y' then
746: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' Roll Up rows in FII_GL_BUDGET_EXTRACT_T on time.');
747: FII_UTIL.stop_timer;
748: FII_UTIL.print_timer('Duration');
749: end if;
750: /* l_row_count := SQL%ROWCOUNT; */
751: /* DBMS_OUTPUT.put_line('Rolled Up ' || TO_CHAR(l_row_count) || ' rows in FII_GL_BUDGET_EXTRACT_T on time.'); */
752: /* l_row_count := 0; */

Line 762: FII_UTIL.write_log('');

758: --------------------------------------------------------------------------
759: g_phase := 'Deleting from fii_budget_base by diffing with temp table.';
760:
761: if g_debug_flag = 'Y' then
762: FII_UTIL.write_log('');
763: FII_UTIL.put_line(g_phase);
764: FII_UTIL.start_timer;
765: end if;
766:

Line 763: FII_UTIL.put_line(g_phase);

759: g_phase := 'Deleting from fii_budget_base by diffing with temp table.';
760:
761: if g_debug_flag = 'Y' then
762: FII_UTIL.write_log('');
763: FII_UTIL.put_line(g_phase);
764: FII_UTIL.start_timer;
765: end if;
766:
767: DELETE FROM fii_budget_base

Line 764: FII_UTIL.start_timer;

760:
761: if g_debug_flag = 'Y' then
762: FII_UTIL.write_log('');
763: FII_UTIL.put_line(g_phase);
764: FII_UTIL.start_timer;
765: end if;
766:
767: DELETE FROM fii_budget_base
768: WHERE (time_id,

Line 821: FII_UTIL.write_log('Deleted ' || SQL%ROWCOUNT || ' rows from fii_budget_base.');

817: WHERE time_id is not null);
818:
819:
820: if g_debug_flag = 'Y' then
821: FII_UTIL.write_log('Deleted ' || SQL%ROWCOUNT || ' rows from fii_budget_base.');
822: FII_UTIL.stop_timer;
823: FII_UTIL.print_timer('Duration');
824: end if;
825: /* l_row_count := SQL%ROWCOUNT; */

Line 822: FII_UTIL.stop_timer;

818:
819:
820: if g_debug_flag = 'Y' then
821: FII_UTIL.write_log('Deleted ' || SQL%ROWCOUNT || ' rows from fii_budget_base.');
822: FII_UTIL.stop_timer;
823: FII_UTIL.print_timer('Duration');
824: end if;
825: /* l_row_count := SQL%ROWCOUNT; */
826: /* DBMS_OUTPUT.put_line('Deleted ' || TO_CHAR(l_row_count) || ' rows from fii_budget_base.'); */

Line 823: FII_UTIL.print_timer('Duration');

819:
820: if g_debug_flag = 'Y' then
821: FII_UTIL.write_log('Deleted ' || SQL%ROWCOUNT || ' rows from fii_budget_base.');
822: FII_UTIL.stop_timer;
823: FII_UTIL.print_timer('Duration');
824: end if;
825: /* l_row_count := SQL%ROWCOUNT; */
826: /* DBMS_OUTPUT.put_line('Deleted ' || TO_CHAR(l_row_count) || ' rows from fii_budget_base.'); */
827: /* l_row_count := 0; */

Line 835: FII_UTIL.write_log('');

831: --------------------------------------------------------------------------
832: g_phase := 'Insert contents of temp table into fii_budget_base.';
833:
834: if g_debug_flag = 'Y' then
835: FII_UTIL.write_log('');
836: FII_UTIL.write_log(g_phase);
837: FII_UTIL.start_timer;
838: end if;
839:

Line 836: FII_UTIL.write_log(g_phase);

832: g_phase := 'Insert contents of temp table into fii_budget_base.';
833:
834: if g_debug_flag = 'Y' then
835: FII_UTIL.write_log('');
836: FII_UTIL.write_log(g_phase);
837: FII_UTIL.start_timer;
838: end if;
839:
840:

Line 837: FII_UTIL.start_timer;

833:
834: if g_debug_flag = 'Y' then
835: FII_UTIL.write_log('');
836: FII_UTIL.write_log(g_phase);
837: FII_UTIL.start_timer;
838: end if;
839:
840:
841: INSERT /*+ append parallel(f) */ INTO fii_budget_base f

Line 920: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_budget_base.');

916: and sec_amount_total = t.sec_amount_g));
917:
918:
919: if g_debug_flag = 'Y' then
920: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_budget_base.');
921: FII_UTIL.stop_timer;
922: FII_UTIL.print_timer('Duration');
923: end if;
924: /* l_row_count := SQL%ROWCOUNT; */

Line 921: FII_UTIL.stop_timer;

917:
918:
919: if g_debug_flag = 'Y' then
920: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_budget_base.');
921: FII_UTIL.stop_timer;
922: FII_UTIL.print_timer('Duration');
923: end if;
924: /* l_row_count := SQL%ROWCOUNT; */
925: /* DBMS_OUTPUT.put_line('Inserted ' || TO_CHAR(l_row_count) || ' rows into fii_budget_base.'); */

Line 922: FII_UTIL.print_timer('Duration');

918:
919: if g_debug_flag = 'Y' then
920: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_budget_base.');
921: FII_UTIL.stop_timer;
922: FII_UTIL.print_timer('Duration');
923: end if;
924: /* l_row_count := SQL%ROWCOUNT; */
925: /* DBMS_OUTPUT.put_line('Inserted ' || TO_CHAR(l_row_count) || ' rows into fii_budget_base.'); */
926: /* l_row_count := 0; */

Line 937: FII_UTIL.write_log('Fatal errors occured during the upload process.');

933: EXCEPTION
934: WHEN FIIBUDX_fatal_err THEN
935: retcode := 'E';
936: Rollback;
937: FII_UTIL.write_log('Fatal errors occured during the upload process.');
938: /* DBMS_OUTPUT.put_line('Fatal errors occured during the upload process.'); */
939:
940: WHEN OTHERS Then
941: retcode := 'E';

Line 944: FII_UTIL.write_output('

940: WHEN OTHERS Then
941: retcode := 'E';
942: Rollback;
943:
944: FII_UTIL.write_output('
945: Error in Function: Main
946: Phase: '|| g_phase || '
947: Message: ' || sqlerrm);
948: