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_XLA_EXTRACT_UTIL_PKG dependencies on FND_LOG

Line 4: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY fa_xla_extract_util_pkg AS
2: /* $Header: FAXLAXUB.pls 120.36.12020000.3 2012/11/30 11:52:10 spooyath ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

2: /* $Header: FAXLAXUB.pls 120.36.12020000.3 2012/11/30 11:52:10 spooyath ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

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

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

5:
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12:
13: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_extract_util_pkg.';

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

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

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

7: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12:
13: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_extract_util_pkg.';
14:
15: ----------------------------------------------------------------------------------

Line 47: fnd_log.string(G_LEVEL_PROCEDURE,

43: begin
44:
45: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
46:
47: fnd_log.string(G_LEVEL_PROCEDURE,
48: G_MODULE_NAME||l_procedure_name||'.begin',
49: 'Beginning of procedure');
50:
51: END IF;

Line 150: fnd_log.string(G_LEVEL_STATEMENT,

146:
147: end if;
148:
149: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
150: fnd_log.string(G_LEVEL_STATEMENT,
151: G_MODULE_NAME||l_procedure_name,
152: 't_entity_code(i): ' || t_entity_code(i));
153: END IF;
154:

Line 168: fnd_log.string(G_LEVEL_STATEMENT,

164: null;
165: end if;
166:
167: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
168: fnd_log.string(G_LEVEL_STATEMENT,
169: G_MODULE_NAME||l_procedure_name,
170: 't_event_type_code(i): ' || t_event_type_code(i));
171: END IF;
172:

Line 204: fnd_log.string(G_LEVEL_PROCEDURE,

200: end loop;
201:
202: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
203:
204: fnd_log.string(G_LEVEL_PROCEDURE,
205: G_MODULE_NAME||l_procedure_name||'.end',
206: 'End of procedure');
207:
208: END IF;

Line 219: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

215:
216: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
217: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
218: fnd_message.set_token('ORACLE_ERR',SQLERRM);
219: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
220: END IF;
221: raise;
222:
223: end check_events;

Line 250: fnd_log.string(G_LEVEL_PROCEDURE,

246: BEGIN
247:
248: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
249:
250: fnd_log.string(G_LEVEL_PROCEDURE,
251: G_MODULE_NAME||l_procedure_name||'.begin',
252: 'Beginning of procedure');
253:
254: END IF;

Line 271: fnd_log.string(G_LEVEL_PROCEDURE,

267: commit;
268:
269: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
270:
271: fnd_log.string(G_LEVEL_PROCEDURE,
272: G_MODULE_NAME||l_procedure_name||'.end',
273: 'End of procedure');
274:
275: END IF;

Line 284: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

280: WHEN OTHERS THEN
281: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
282: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
283: fnd_message.set_token('ORACLE_ERR',SQLERRM);
284: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
285: END IF;
286: RAISE;
287:
288: END lock_assets;

Line 312: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 333: fnd_log.string(G_LEVEL_PROCEDURE,

329: commit;
330:
331: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
332:
333: fnd_log.string(G_LEVEL_PROCEDURE,
334: G_MODULE_NAME||l_procedure_name||'.end',
335: 'End of procedure');
336:
337: END IF;

Line 346: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

342: WHEN OTHERS THEN
343: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
344: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
345: fnd_message.set_token('ORACLE_ERR',SQLERRM);
346: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
347: END IF;
348: RAISE;
349:
350: END unlock_assets;

Line 379: fnd_log.string(G_LEVEL_PROCEDURE,

375: BEGIN
376:
377: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
378:
379: fnd_log.string(G_LEVEL_PROCEDURE,
380: G_MODULE_NAME||l_procedure_name||'.begin',
381: 'Beginning of procedure');
382:
383: END IF;

Line 387: fnd_log.string(G_LEVEL_STATEMENT,

383: END IF;
384:
385: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
386:
387: fnd_log.string(G_LEVEL_STATEMENT,
388: G_MODULE_NAME||l_procedure_name,
389: 'p_book_type_code: ' || p_book_type_code);
390: fnd_log.string(G_LEVEL_STATEMENT,
391: G_MODULE_NAME||l_procedure_name,

Line 390: fnd_log.string(G_LEVEL_STATEMENT,

386:
387: fnd_log.string(G_LEVEL_STATEMENT,
388: G_MODULE_NAME||l_procedure_name,
389: 'p_book_type_code: ' || p_book_type_code);
390: fnd_log.string(G_LEVEL_STATEMENT,
391: G_MODULE_NAME||l_procedure_name,
392: 'p_ledger_id: ' || to_char(p_ledger_id));
393: fnd_log.string(G_LEVEL_STATEMENT,
394: G_MODULE_NAME||l_procedure_name,

Line 393: fnd_log.string(G_LEVEL_STATEMENT,

389: 'p_book_type_code: ' || p_book_type_code);
390: fnd_log.string(G_LEVEL_STATEMENT,
391: G_MODULE_NAME||l_procedure_name,
392: 'p_ledger_id: ' || to_char(p_ledger_id));
393: fnd_log.string(G_LEVEL_STATEMENT,
394: G_MODULE_NAME||l_procedure_name,
395: 'p_process_category: ' || p_process_category);
396:
397: END IF;

Line 518: fnd_log.string(G_LEVEL_STATEMENT,

514:
515: l_trx_count := SQL%ROWCOUNT;
516:
517: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
518: fnd_log.string(G_LEVEL_STATEMENT,
519: G_MODULE_NAME||l_procedure_name,
520: 'Rows inserted into gt for non-accountable - trx: ' || to_char(l_trx_count));
521: END IF;
522:

Line 574: fnd_log.string(G_LEVEL_STATEMENT,

570:
571: l_inter_trx_count := SQL%ROWCOUNT;
572:
573: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
574: fnd_log.string(G_LEVEL_STATEMENT,
575: G_MODULE_NAME||l_procedure_name,
576: 'Rows inserted into gt for non-accountable - intertrx: ' || to_char(l_inter_trx_count));
577: END IF;
578:

Line 582: fnd_log.string(G_LEVEL_STATEMENT,

578:
579: if (l_trx_count <> 0 or
580: l_inter_trx_count <> 0) then
581: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
582: fnd_log.string(G_LEVEL_STATEMENT,
583: G_MODULE_NAME||l_procedure_name,
584: 'calling: ' || 'xla_events_pub_pkg.update_bulk_event_statuses');
585: END IF;
586:

Line 596: fnd_log.string(G_LEVEL_PROCEDURE,

592: commit;
593:
594: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
595:
596: fnd_log.string(G_LEVEL_PROCEDURE,
597: G_MODULE_NAME||l_procedure_name||'.end',
598: 'End of procedure');
599:
600: END IF;

Line 609: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

605: WHEN OTHERS THEN
606: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
607: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
608: fnd_message.set_token('ORACLE_ERR',SQLERRM);
609: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
610: END IF;
611: RAISE;
612:
613: END update_nonaccountable_events;

Line 643: fnd_log.string(G_LEVEL_PROCEDURE,

639: BEGIN
640:
641: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
642:
643: fnd_log.string(G_LEVEL_PROCEDURE,
644: G_MODULE_NAME||l_procedure_name||'.begin',
645: 'Beginning of procedure');
646:
647: END IF;

Line 655: fnd_log.string(G_LEVEL_STATEMENT,

651:
652: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
653:
654: if (G_trx_exists) then
655: fnd_log.string(G_LEVEL_STATEMENT,
656: G_MODULE_NAME||l_procedure_name,
657: 'G_trx_exists: true' );
658: else
659: fnd_log.string(G_LEVEL_STATEMENT,

Line 659: fnd_log.string(G_LEVEL_STATEMENT,

655: fnd_log.string(G_LEVEL_STATEMENT,
656: G_MODULE_NAME||l_procedure_name,
657: 'G_trx_exists: true' );
658: else
659: fnd_log.string(G_LEVEL_STATEMENT,
660: G_MODULE_NAME||l_procedure_name,
661: 'G_trx_exists: false' );
662:
663: end if;

Line 666: fnd_log.string(G_LEVEL_STATEMENT,

662:
663: end if;
664:
665: if (G_inter_trx_exists) then
666: fnd_log.string(G_LEVEL_STATEMENT,
667: G_MODULE_NAME||l_procedure_name,
668: 'G_inter_trx_exists: true' );
669: else
670: fnd_log.string(G_LEVEL_STATEMENT,

Line 670: fnd_log.string(G_LEVEL_STATEMENT,

666: fnd_log.string(G_LEVEL_STATEMENT,
667: G_MODULE_NAME||l_procedure_name,
668: 'G_inter_trx_exists: true' );
669: else
670: fnd_log.string(G_LEVEL_STATEMENT,
671: G_MODULE_NAME||l_procedure_name,
672: 'G_inter_trx_exists: false' );
673:
674: end if;

Line 677: fnd_log.string(G_LEVEL_STATEMENT,

673:
674: end if;
675:
676: if (G_dep_exists) then
677: fnd_log.string(G_LEVEL_STATEMENT,
678: G_MODULE_NAME||l_procedure_name,
679: 'G_dep_exists: true' );
680: else
681: fnd_log.string(G_LEVEL_STATEMENT,

Line 681: fnd_log.string(G_LEVEL_STATEMENT,

677: fnd_log.string(G_LEVEL_STATEMENT,
678: G_MODULE_NAME||l_procedure_name,
679: 'G_dep_exists: true' );
680: else
681: fnd_log.string(G_LEVEL_STATEMENT,
682: G_MODULE_NAME||l_procedure_name,
683: 'G_dep_exists: false' );
684:
685: end if;

Line 688: fnd_log.string(G_LEVEL_STATEMENT,

684:
685: end if;
686:
687: if (G_def_exists) then
688: fnd_log.string(G_LEVEL_STATEMENT,
689: G_MODULE_NAME||l_procedure_name,
690: 'G_def_exists: true' );
691: else
692: fnd_log.string(G_LEVEL_STATEMENT,

Line 692: fnd_log.string(G_LEVEL_STATEMENT,

688: fnd_log.string(G_LEVEL_STATEMENT,
689: G_MODULE_NAME||l_procedure_name,
690: 'G_def_exists: true' );
691: else
692: fnd_log.string(G_LEVEL_STATEMENT,
693: G_MODULE_NAME||l_procedure_name,
694: 'G_def_exists: false' );
695:
696: end if;

Line 699: fnd_log.string(G_LEVEL_STATEMENT,

695:
696: end if;
697:
698: if (G_fin_trx_exists) then
699: fnd_log.string(G_LEVEL_STATEMENT,
700: G_MODULE_NAME||l_procedure_name,
701: 'G_fin_trx_exists: true' );
702: else
703: fnd_log.string(G_LEVEL_STATEMENT,

Line 703: fnd_log.string(G_LEVEL_STATEMENT,

699: fnd_log.string(G_LEVEL_STATEMENT,
700: G_MODULE_NAME||l_procedure_name,
701: 'G_fin_trx_exists: true' );
702: else
703: fnd_log.string(G_LEVEL_STATEMENT,
704: G_MODULE_NAME||l_procedure_name,
705: 'G_fin_trx_exists: false' );
706: end if;
707:

Line 709: fnd_log.string(G_LEVEL_STATEMENT,

705: 'G_fin_trx_exists: false' );
706: end if;
707:
708: if (G_xfr_trx_exists) then
709: fnd_log.string(G_LEVEL_STATEMENT,
710: G_MODULE_NAME||l_procedure_name,
711: 'G_xfr_trx_exists: true' );
712: else
713: fnd_log.string(G_LEVEL_STATEMENT,

Line 713: fnd_log.string(G_LEVEL_STATEMENT,

709: fnd_log.string(G_LEVEL_STATEMENT,
710: G_MODULE_NAME||l_procedure_name,
711: 'G_xfr_trx_exists: true' );
712: else
713: fnd_log.string(G_LEVEL_STATEMENT,
714: G_MODULE_NAME||l_procedure_name,
715: 'G_xfr_trx_exists: false' );
716: end if;
717:

Line 719: fnd_log.string(G_LEVEL_STATEMENT,

715: 'G_xfr_trx_exists: false' );
716: end if;
717:
718: if (G_dist_trx_exists) then
719: fnd_log.string(G_LEVEL_STATEMENT,
720: G_MODULE_NAME||l_procedure_name,
721: 'G_dist_trx_exists: true' );
722: else
723: fnd_log.string(G_LEVEL_STATEMENT,

Line 723: fnd_log.string(G_LEVEL_STATEMENT,

719: fnd_log.string(G_LEVEL_STATEMENT,
720: G_MODULE_NAME||l_procedure_name,
721: 'G_dist_trx_exists: true' );
722: else
723: fnd_log.string(G_LEVEL_STATEMENT,
724: G_MODULE_NAME||l_procedure_name,
725: 'G_dist_trx_exists: false' );
726: end if;
727:

Line 729: fnd_log.string(G_LEVEL_STATEMENT,

725: 'G_dist_trx_exists: false' );
726: end if;
727:
728: if (G_ret_trx_exists) then
729: fnd_log.string(G_LEVEL_STATEMENT,
730: G_MODULE_NAME||l_procedure_name,
731: 'G_ret_trx_exists: true' );
732: else
733: fnd_log.string(G_LEVEL_STATEMENT,

Line 733: fnd_log.string(G_LEVEL_STATEMENT,

729: fnd_log.string(G_LEVEL_STATEMENT,
730: G_MODULE_NAME||l_procedure_name,
731: 'G_ret_trx_exists: true' );
732: else
733: fnd_log.string(G_LEVEL_STATEMENT,
734: G_MODULE_NAME||l_procedure_name,
735: 'G_ret_trx_exists: false' );
736: end if;
737:

Line 739: fnd_log.string(G_LEVEL_STATEMENT,

735: 'G_ret_trx_exists: false' );
736: end if;
737:
738: if (G_res_trx_exists) then
739: fnd_log.string(G_LEVEL_STATEMENT,
740: G_MODULE_NAME||l_procedure_name,
741: 'G_res_trx_exists: true' );
742: else
743: fnd_log.string(G_LEVEL_STATEMENT,

Line 743: fnd_log.string(G_LEVEL_STATEMENT,

739: fnd_log.string(G_LEVEL_STATEMENT,
740: G_MODULE_NAME||l_procedure_name,
741: 'G_res_trx_exists: true' );
742: else
743: fnd_log.string(G_LEVEL_STATEMENT,
744: G_MODULE_NAME||l_procedure_name,
745: 'G_res_trx_exists: false' );
746: end if;
747:

Line 749: fnd_log.string(G_LEVEL_STATEMENT,

745: 'G_res_trx_exists: false' );
746: end if;
747:
748: if (G_deprn_exists) then
749: fnd_log.string(G_LEVEL_STATEMENT,
750: G_MODULE_NAME||l_procedure_name,
751: 'G_deprn_exists: true' );
752: else
753: fnd_log.string(G_LEVEL_STATEMENT,

Line 753: fnd_log.string(G_LEVEL_STATEMENT,

749: fnd_log.string(G_LEVEL_STATEMENT,
750: G_MODULE_NAME||l_procedure_name,
751: 'G_deprn_exists: true' );
752: else
753: fnd_log.string(G_LEVEL_STATEMENT,
754: G_MODULE_NAME||l_procedure_name,
755: 'G_deprn_exists: false' );
756: end if;
757:

Line 759: fnd_log.string(G_LEVEL_STATEMENT,

755: 'G_deprn_exists: false' );
756: end if;
757:
758: if (G_rollback_deprn_exists) then
759: fnd_log.string(G_LEVEL_STATEMENT,
760: G_MODULE_NAME||l_procedure_name,
761: 'G_rollback_deprn_exists: true' );
762: else
763: fnd_log.string(G_LEVEL_STATEMENT,

Line 763: fnd_log.string(G_LEVEL_STATEMENT,

759: fnd_log.string(G_LEVEL_STATEMENT,
760: G_MODULE_NAME||l_procedure_name,
761: 'G_rollback_deprn_exists: true' );
762: else
763: fnd_log.string(G_LEVEL_STATEMENT,
764: G_MODULE_NAME||l_procedure_name,
765: 'G_rollback_deprn_exists: false' );
766: end if;
767:

Line 769: fnd_log.string(G_LEVEL_STATEMENT,

765: 'G_rollback_deprn_exists: false' );
766: end if;
767:
768: if (G_alc_enabled) then
769: fnd_log.string(G_LEVEL_STATEMENT,
770: G_MODULE_NAME||l_procedure_name,
771: 'G_alc_enabled: true' );
772: else
773: fnd_log.string(G_LEVEL_STATEMENT,

Line 773: fnd_log.string(G_LEVEL_STATEMENT,

769: fnd_log.string(G_LEVEL_STATEMENT,
770: G_MODULE_NAME||l_procedure_name,
771: 'G_alc_enabled: true' );
772: else
773: fnd_log.string(G_LEVEL_STATEMENT,
774: G_MODULE_NAME||l_procedure_name,
775: 'G_alc_enabled: false' );
776: end if;
777:

Line 779: fnd_log.string(G_LEVEL_STATEMENT,

775: 'G_alc_enabled: false' );
776: end if;
777:
778: if (G_sorp_enabled) then
779: fnd_log.string(G_LEVEL_STATEMENT,
780: G_MODULE_NAME||l_procedure_name,
781: 'G_sorp_enabled: true' );
782: else
783: fnd_log.string(G_LEVEL_STATEMENT,

Line 783: fnd_log.string(G_LEVEL_STATEMENT,

779: fnd_log.string(G_LEVEL_STATEMENT,
780: G_MODULE_NAME||l_procedure_name,
781: 'G_sorp_enabled: true' );
782: else
783: fnd_log.string(G_LEVEL_STATEMENT,
784: G_MODULE_NAME||l_procedure_name,
785: 'G_sorp_enabled: false' );
786: end if;
787:

Line 806: fnd_log.string(G_LEVEL_PROCEDURE,

802: end if;
803:
804: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
805:
806: fnd_log.string(G_LEVEL_PROCEDURE,
807: G_MODULE_NAME||l_procedure_name||'.end',
808: 'End of procedure');
809:
810: END IF;

Line 817: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

813: WHEN OTHERS THEN
814: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
815: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
816: fnd_message.set_token('ORACLE_ERR',SQLERRM);
817: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
818: END IF;
819: RAISE;
820: END;
821: