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.FA_DEFERRED_DEPRN_PKG dependencies on FND_LOG

Line 8: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4: ---------------------------------------------------
5: -- Declaration of global variables --
6: ---------------------------------------------------
7:
8: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

6: ---------------------------------------------------
7:
8: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

7:
8: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

8: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:

Line 13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

9:
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:
17: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_deferred_deprn_pkg.';

Line 14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:
17: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_deferred_deprn_pkg.';
18:

Line 15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:
17: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_deferred_deprn_pkg.';
18:
19: g_log_level_rec fa_api_types.log_level_rec_type;

Line 314: fnd_log.string(G_LEVEL_PROCEDURE,

310:
311: begin
312:
313: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
314: fnd_log.string(G_LEVEL_PROCEDURE,
315: G_MODULE_NAME||l_procedure_name||'.begin',
316: 'Beginning of procedure');
317: END IF;
318:

Line 329: fnd_log.string(G_LEVEL_STATEMENT,

325:
326:
327:
328: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
329: fnd_log.string(G_LEVEL_STATEMENT,
330: G_MODULE_NAME||l_procedure_name,
331: 'opening ' || p_mrc_sob_type_code || ' deferred cursor');
332: END IF;
333:

Line 344: fnd_log.string(G_LEVEL_STATEMENT,

340:
341: while (TRUE) loop
342:
343: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
344: fnd_log.string(G_LEVEL_STATEMENT,
345: G_MODULE_NAME||l_procedure_name,
346: 'fetching ' || p_mrc_sob_type_code || ' cursor');
347: END IF;
348:

Line 374: fnd_log.string(G_LEVEL_STATEMENT,

370: LIMIT l_batch_size;
371: end if;
372:
373: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
374: fnd_log.string(G_LEVEL_STATEMENT,
375: G_MODULE_NAME||l_procedure_name,
376: 'rows fetched: ' || to_char(l_asset_id.count));
377: END IF;
378:

Line 382: fnd_log.string(G_LEVEL_STATEMENT,

378:
379: if (l_asset_id.count = 0) then
380:
381: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
382: fnd_log.string(G_LEVEL_STATEMENT,
383: G_MODULE_NAME||l_procedure_name,
384: 'exiting loop');
385: END IF;
386:

Line 392: fnd_log.string(G_LEVEL_STATEMENT,

388: end if;
389:
390:
391: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
392: fnd_log.string(G_LEVEL_STATEMENT,
393: G_MODULE_NAME||l_procedure_name,
394: 'bulk inserting into fa_deferred_deprn*' || p_mrc_sob_type_code);
395: END IF;
396:

Line 471: fnd_log.string(G_LEVEL_STATEMENT,

467:
468: end loop;
469:
470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
471: fnd_log.string(G_LEVEL_STATEMENT,
472: G_MODULE_NAME||l_procedure_name,
473: 'closing ' || p_mrc_sob_type_code || ' deferred cursor');
474: END IF;
475:

Line 490: fnd_log.string(G_LEVEL_STATEMENT,

486:
487: for x in 1..2 loop
488:
489: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
490: fnd_log.string(G_LEVEL_STATEMENT,
491: G_MODULE_NAME||l_procedure_name,
492: 'in ADJ loop, interation #:' || to_char(x));
493: END IF;
494:

Line 512: fnd_log.string(G_LEVEL_STATEMENT,

508:
509: while (TRUE) loop
510:
511: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
512: fnd_log.string(G_LEVEL_STATEMENT,
513: G_MODULE_NAME||l_procedure_name,
514: 'fetching ' || p_mrc_sob_type_code || ' ADJ cursor');
515: END IF;
516:

Line 533: fnd_log.string(G_LEVEL_STATEMENT,

529: LIMIT l_batch_size;
530: end if;
531:
532: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
533: fnd_log.string(G_LEVEL_STATEMENT,
534: G_MODULE_NAME||l_procedure_name,
535: 'rows fetched: ' || to_char(l_asset_id.count));
536: END IF;
537:

Line 541: fnd_log.string(G_LEVEL_STATEMENT,

537:
538: if (l_asset_id.count = 0) then
539:
540: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
541: fnd_log.string(G_LEVEL_STATEMENT,
542: G_MODULE_NAME||l_procedure_name,
543: 'exiting loop');
544: END IF;
545:

Line 553: fnd_log.string(G_LEVEL_STATEMENT,

549: /*
550: for i in 1..l_asset_id.count loop
551:
552: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
553: fnd_log.string(G_LEVEL_STATEMENT,
554: G_MODULE_NAME||l_procedure_name,
555: to_char(l_dist_id(i)) || ': ' ||
556: to_char(l_corp_rsv_adj(i)));
557: END IF;

Line 564: fnd_log.string(G_LEVEL_STATEMENT,

560: */
561:
562:
563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
564: fnd_log.string(G_LEVEL_STATEMENT,
565: G_MODULE_NAME||l_procedure_name,
566: 'bulk updating fa_deferred_deprn for corp adj' || p_mrc_sob_type_code);
567: END IF;
568:

Line 607: fnd_log.string(G_LEVEL_STATEMENT,

603:
604: end loop;
605:
606: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
607: fnd_log.string(G_LEVEL_STATEMENT,
608: G_MODULE_NAME||l_procedure_name,
609: 'closing ' || p_mrc_sob_type_code || ' ADJ cursor');
610: END IF;
611:

Line 621: fnd_log.string(G_LEVEL_PROCEDURE,

617:
618: end loop; -- corp/tax loop
619:
620: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
621: fnd_log.string(G_LEVEL_PROCEDURE,
622: G_MODULE_NAME||l_procedure_name||'.end',
623: 'End of procedure');
624: END IF;
625:

Line 707: fnd_log.string(G_LEVEL_PROCEDURE,

703:
704: begin
705:
706: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
707: fnd_log.string(G_LEVEL_PROCEDURE,
708: G_MODULE_NAME||l_procedure_name||'.begin',
709: 'Beginning of procedure');
710: END IF;
711:

Line 724: fnd_log.string(G_LEVEL_STATEMENT,

720: raise error_found;
721: end if;
722:
723: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
724: fnd_log.string(G_LEVEL_STATEMENT,
725: G_MODULE_NAME||l_procedure_name,
726: 'opening c_deferred_events');
727: END IF;
728:

Line 738: fnd_log.string(G_LEVEL_STATEMENT,

734:
735: loop -- Loop for c_deferred_events
736:
737: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
738: fnd_log.string(G_LEVEL_STATEMENT,
739: G_MODULE_NAME||l_procedure_name,
740: 'bulk fetching c_deferred_events cursor');
741: END IF;
742:

Line 749: fnd_log.string(G_LEVEL_STATEMENT,

745: l_rowid_tbl
746: LIMIT l_batch_size;
747:
748: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
749: fnd_log.string(G_LEVEL_STATEMENT,
750: G_MODULE_NAME||l_procedure_name,
751: 'rows fetched: ' || to_char(l_asset_id_tbl.count));
752: END IF;
753:

Line 756: fnd_log.string(G_LEVEL_STATEMENT,

752: END IF;
753:
754: if l_asset_id_tbl.count = 0 then
755: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
756: fnd_log.string(G_LEVEL_STATEMENT,
757: G_MODULE_NAME||l_procedure_name,
758: 'exiting loop...');
759: END IF;
760:

Line 765: fnd_log.string(G_LEVEL_STATEMENT,

761: exit;
762: end if;
763:
764: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
765: fnd_log.string(G_LEVEL_STATEMENT,
766: G_MODULE_NAME||l_procedure_name,
767: 'calling FA_XLA_EVENTS_PVT.create_bulk_deferred_event for primary');
768: END IF;
769:

Line 785: fnd_log.string(G_LEVEL_STATEMENT,

781: p_calling_fn => l_calling_fn
782: );
783:
784: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
785: fnd_log.string(G_LEVEL_STATEMENT,
786: G_MODULE_NAME||l_procedure_name,
787: 'bulk inserting into fa_deferred_deprn_events');
788: END IF;
789:

Line 808: fnd_log.string(G_LEVEL_STATEMENT,

804: p_tax_period_counter,
805: l_event_id_tbl(l_count));
806:
807: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
808: fnd_log.string(G_LEVEL_STATEMENT,
809: G_MODULE_NAME||l_procedure_name,
810: 'bulk updating fa_deferred_deprn with event ids');
811: END IF;
812:

Line 823: fnd_log.string(G_LEVEL_STATEMENT,

819: AND corp_period_counter = p_corp_period_counter
820: AND tax_period_counter = p_tax_period_counter;
821:
822: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
823: fnd_log.string(G_LEVEL_STATEMENT,
824: G_MODULE_NAME||l_procedure_name,
825: 'bulk updating fa_mc_deferred_deprn with event ids');
826: END IF;
827:

Line 843: fnd_log.string(G_LEVEL_STATEMENT,

839:
840: end loop; --End of loop for c_deferred_events
841:
842: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
843: fnd_log.string(G_LEVEL_STATEMENT,
844: G_MODULE_NAME||l_procedure_name,
845: 'closing c_deferred_events');
846: END IF;
847:

Line 861: fnd_log.string(G_LEVEL_STATEMENT,

857: -- begin at index of 1 not 0 as in apis
858: FOR l_sob_index in 1..l_sob_tbl.count LOOP
859:
860: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
861: fnd_log.string(G_LEVEL_STATEMENT,
862: G_MODULE_NAME||l_procedure_name,
863: 'opening c_mc_deferred_events cursor');
864: END IF;
865:

Line 871: fnd_log.string(G_LEVEL_STATEMENT,

867:
868: loop -- Loop for c_mc_deferred_events
869:
870: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
871: fnd_log.string(G_LEVEL_STATEMENT,
872: G_MODULE_NAME||l_procedure_name,
873: 'fetching c_mc_deferred_events cursor');
874: END IF;
875:

Line 882: fnd_log.string(G_LEVEL_STATEMENT,

878: l_rowid_tbl
879: LIMIT l_batch_size;
880:
881: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
882: fnd_log.string(G_LEVEL_STATEMENT,
883: G_MODULE_NAME||l_procedure_name,
884: 'rows fetched: ' || to_char(l_asset_id_tbl.count));
885: END IF;
886:

Line 889: fnd_log.string(G_LEVEL_STATEMENT,

885: END IF;
886:
887: if (l_asset_id_tbl.count = 0) then
888: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
889: fnd_log.string(G_LEVEL_STATEMENT,
890: G_MODULE_NAME||l_procedure_name,
891: 'exiting loop...');
892: END IF;
893:

Line 898: fnd_log.string(G_LEVEL_STATEMENT,

894: exit;
895: end if;
896:
897: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
898: fnd_log.string(G_LEVEL_STATEMENT,
899: G_MODULE_NAME||l_procedure_name,
900: 'calling FA_XLA_EVENTS_PVT.create_bulk_deferred_event for reporting');
901: END IF;
902:

Line 918: fnd_log.string(G_LEVEL_STATEMENT,

914: p_calling_fn => l_calling_fn
915: );
916:
917: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
918: fnd_log.string(G_LEVEL_STATEMENT,
919: G_MODULE_NAME||l_procedure_name,
920: 'bulk inserting into fa_deferred_deprn_events');
921: END IF;
922:

Line 941: fnd_log.string(G_LEVEL_STATEMENT,

937: p_tax_period_counter,
938: l_event_id_tbl(l_count));
939:
940: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
941: fnd_log.string(G_LEVEL_STATEMENT,
942: G_MODULE_NAME||l_procedure_name,
943: 'bulk updating fa_mc_deferred_deprn with event ids');
944: END IF;
945:

Line 960: fnd_log.string(G_LEVEL_STATEMENT,

956:
957: end loop; --End of loop for c_mc_deferred_events
958:
959: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
960: fnd_log.string(G_LEVEL_STATEMENT,
961: G_MODULE_NAME||l_procedure_name,
962: 'closing c_mc_deferred_events');
963: END IF;
964:

Line 977: fnd_log.string(G_LEVEL_PROCEDURE,

973: raise error_found;
974: end if;
975:
976: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
977: fnd_log.string(G_LEVEL_PROCEDURE,
978: G_MODULE_NAME||l_procedure_name||'.end',
979: 'End of procedure');
980: END IF;
981:

Line 1042: fnd_log.string(G_LEVEL_PROCEDURE,

1038:
1039: BEGIN
1040:
1041: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1042: fnd_log.string(G_LEVEL_PROCEDURE,
1043: G_MODULE_NAME||l_procedure_name||'.begin',
1044: 'Beginning of procedure');
1045: END IF;
1046:

Line 1060: fnd_log.string(G_LEVEL_STATEMENT,

1056: end if;
1057: end if;
1058:
1059: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1060: fnd_log.string(G_LEVEL_STATEMENT,
1061: G_MODULE_NAME||l_procedure_name,
1062: 'fetching period information');
1063: END IF;
1064:

Line 1107: fnd_log.string(G_LEVEL_STATEMENT,

1103: l_deferred_exists_count := 0;
1104: end;
1105:
1106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1107: fnd_log.string(G_LEVEL_STATEMENT,
1108: G_MODULE_NAME||l_procedure_name,
1109: 'l_deferred_exists_count :' || to_char(l_deferred_exists_count));
1110: END IF;
1111:

Line 1129: fnd_log.string(G_LEVEL_STATEMENT,

1125: raise error_found;
1126: end if;
1127:
1128: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1129: fnd_log.string(G_LEVEL_STATEMENT,
1130: G_MODULE_NAME||l_procedure_name,
1131: 'calling deferred_deprn');
1132: END IF;
1133:

Line 1145: fnd_log.string(G_LEVEL_STATEMENT,

1141:
1142: end loop;
1143:
1144: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1145: fnd_log.string(G_LEVEL_STATEMENT,
1146: G_MODULE_NAME||l_procedure_name,
1147: 'calling create_bulk_deferred_events');
1148: END IF;
1149:

Line 1158: fnd_log.string(G_LEVEL_PROCEDURE,

1154: p_tax_period_counter => l_tax_period_counter,
1155: p_corp_period_counter => l_corp_period_counter);
1156:
1157: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1158: fnd_log.string(G_LEVEL_PROCEDURE,
1159: G_MODULE_NAME||l_procedure_name||'.end',
1160: 'End of procedure');
1161: END IF;
1162: