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

Line 22: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

18:
19: -- TYPES
20: -- globals / constants
21:
22: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
23:
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

20: -- globals / constants
21:
22: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
23:
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
28: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

21:
22: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
23:
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
28: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

22: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
23:
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
28: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30:

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

23:
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
28: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30:
31: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_extract_trx_pkg.';

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

24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
28: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30:
31: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_extract_trx_pkg.';
32:

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

25: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
28: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30:
31: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_extract_trx_pkg.';
32:
33:

Line 56: fnd_log.string(G_LEVEL_PROCEDURE,

52:
53: BEGIN
54:
55: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
56: fnd_log.string(G_LEVEL_PROCEDURE,
57: G_MODULE_NAME||l_procedure_name||'.begin',
58: 'Beginning of procedure');
59: END IF;
60:

Line 124: fnd_log.string(G_LEVEL_PROCEDURE,

120: nvl(dp.period_close_date, sysdate)
121: AND bc.set_of_books_id = ctlgd.ledger_id ;
122:
123: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
124: fnd_log.string(G_LEVEL_PROCEDURE,
125: G_MODULE_NAME||l_procedure_name,
126: 'Rows inserted into headers: ' || to_char(SQL%ROWCOUNT));
127: END IF;
128:

Line 199: fnd_log.string(G_LEVEL_PROCEDURE,

195: AND mcbc.set_of_books_id = ctlgd.ledger_id
196: AND le.ledger_id = mcbc.set_of_books_id ;
197:
198: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
199: fnd_log.string(G_LEVEL_PROCEDURE,
200: G_MODULE_NAME||l_procedure_name,
201: 'Rows inserted into headers: ' || to_char(SQL%ROWCOUNT));
202: END IF;
203:

Line 210: fnd_log.string(G_LEVEL_PROCEDURE,

206: end if;
207:
208:
209: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
210: fnd_log.string(G_LEVEL_PROCEDURE,
211: G_MODULE_NAME||l_procedure_name||'.end',
212: 'End of procedure');
213: END IF;
214:

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

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

Line 242: fnd_log.string(G_LEVEL_PROCEDURE,

238:
239: BEGIN
240:
241: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
242: fnd_log.string(G_LEVEL_PROCEDURE,
243: G_MODULE_NAME||l_procedure_name||'.begin',
244: 'Beginning of procedure');
245: END IF;
246:

Line 289: fnd_log.string(G_LEVEL_PROCEDURE,

285: nvl(dp.period_close_date, sysdate)
286: AND bc.set_of_books_id = ctlgd.ledger_id ;
287:
288: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
289: fnd_log.string(G_LEVEL_PROCEDURE,
290: G_MODULE_NAME||l_procedure_name,
291: 'Rows inserted into headers: ' || to_char(SQL%ROWCOUNT));
292: END IF;
293:

Line 343: fnd_log.string(G_LEVEL_PROCEDURE,

339: AND mcbc.set_of_books_id = ctlgd.ledger_id
340: AND le.ledger_id = mcbc.set_of_books_id ;
341:
342: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
343: fnd_log.string(G_LEVEL_PROCEDURE,
344: G_MODULE_NAME||l_procedure_name,
345: 'Rows inserted into headers: ' || to_char(SQL%ROWCOUNT));
346: END IF;
347:

Line 354: fnd_log.string(G_LEVEL_PROCEDURE,

350: end if;
351:
352:
353: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
354: fnd_log.string(G_LEVEL_PROCEDURE,
355: G_MODULE_NAME||l_procedure_name||'.end',
356: 'End of procedure');
357: END IF;
358:

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

360: WHEN others THEN
361: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
362: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
363: fnd_message.set_token('ORACLE_ERR',SQLERRM);
364: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
365: END IF;
366: raise;
367:
368: end load_header_data_stg2;

Line 387: fnd_log.string(G_LEVEL_PROCEDURE,

383:
384: BEGIN
385:
386: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
387: fnd_log.string(G_LEVEL_PROCEDURE,
388: G_MODULE_NAME||l_procedure_name||'.begin',
389: 'Beginning of procedure');
390: END IF;
391:

Line 492: fnd_log.string(G_LEVEL_PROCEDURE,

488: AND ad.asset_type in ('CAPITALIZED', 'CIP', 'GROUP')
489: AND th.transaction_header_id = ctlgd.source_id_int_1 ;
490:
491: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
492: fnd_log.string(G_LEVEL_PROCEDURE,
493: G_MODULE_NAME||l_procedure_name,
494: 'Rows inserted into staging main lines: ' || to_char(SQL%ROWCOUNT));
495: END IF;
496:

Line 598: fnd_log.string(G_LEVEL_PROCEDURE,

594: AND ad.asset_type in ('CAPITALIZED', 'CIP', 'GROUP')
595: AND th.member_transaction_header_id = ctlgd.source_id_int_1 ;
596:
597: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
598: fnd_log.string(G_LEVEL_PROCEDURE,
599: G_MODULE_NAME||l_procedure_name,
600: 'Rows inserted into staging group lines: ' || to_char(SQL%ROWCOUNT));
601: END IF;
602:

Line 609: fnd_log.string(G_LEVEL_PROCEDURE,

605: end if;
606:
607:
608: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
609: fnd_log.string(G_LEVEL_PROCEDURE,
610: G_MODULE_NAME||l_procedure_name||'.end',
611: 'End of procedure');
612: END IF;
613:

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

615: WHEN others THEN
616: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
617: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
618: fnd_message.set_token('ORACLE_ERR',SQLERRM);
619: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
620: END IF;
621: raise;
622:
623: end load_line_data_stg1;

Line 642: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 749: fnd_log.string(G_LEVEL_PROCEDURE,

745: AND ad.asset_type in ('CAPITALIZED', 'CIP', 'GROUP')
746: AND th.transaction_header_id = trx.src_transaction_header_id ;
747:
748: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
749: fnd_log.string(G_LEVEL_PROCEDURE,
750: G_MODULE_NAME||l_procedure_name,
751: 'Rows inserted into staging src main lines: ' || to_char(SQL%ROWCOUNT));
752: END IF;
753:

Line 857: fnd_log.string(G_LEVEL_PROCEDURE,

853: AND ad.asset_type in ('CAPITALIZED', 'CIP', 'GROUP')
854: AND th.member_transaction_header_id = trx.src_transaction_header_id ;
855:
856: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
857: fnd_log.string(G_LEVEL_PROCEDURE,
858: G_MODULE_NAME||l_procedure_name,
859: 'Rows inserted into staging src group lines: ' || to_char(SQL%ROWCOUNT));
860: END IF;
861:

Line 963: fnd_log.string(G_LEVEL_PROCEDURE,

959: AND ad.asset_type in ('CAPITALIZED', 'CIP', 'GROUP')
960: AND th.transaction_header_id = trx.dest_transaction_header_id ;
961:
962: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
963: fnd_log.string(G_LEVEL_PROCEDURE,
964: G_MODULE_NAME||l_procedure_name,
965: 'Rows inserted into staging dest main lines: ' || to_char(SQL%ROWCOUNT));
966: END IF;
967:

Line 1071: fnd_log.string(G_LEVEL_PROCEDURE,

1067: AND ad.asset_type in ('CAPITALIZED', 'CIP', 'GROUP')
1068: AND th.member_transaction_header_id = trx.dest_transaction_header_id ;
1069:
1070: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1071: fnd_log.string(G_LEVEL_PROCEDURE,
1072: G_MODULE_NAME||l_procedure_name,
1073: 'Rows inserted into staging dest group lines: ' || to_char(SQL%ROWCOUNT));
1074: END IF;
1075:

Line 1082: fnd_log.string(G_LEVEL_PROCEDURE,

1078: end if;
1079:
1080:
1081: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1082: fnd_log.string(G_LEVEL_PROCEDURE,
1083: G_MODULE_NAME||l_procedure_name||'.end',
1084: 'End of procedure');
1085: END IF;
1086:

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

1088: WHEN others THEN
1089: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1090: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1091: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1092: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1093: END IF;
1094: raise;
1095:
1096: end load_line_data_stg2;

Line 1115: fnd_log.string(G_LEVEL_PROCEDURE,

1111:
1112: BEGIN
1113:
1114: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1115: fnd_log.string(G_LEVEL_PROCEDURE,
1116: G_MODULE_NAME||l_procedure_name||'.begin',
1117: 'Beginning of procedure');
1118: END IF;
1119:

Line 1336: fnd_log.string(G_LEVEL_PROCEDURE,

1332: 'IMPAIRMENT', 'ROLLBACK_IMPAIRMENT')
1333: AND adj.source_line_id = ai.source_line_id(+) ;
1334:
1335: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1336: fnd_log.string(G_LEVEL_PROCEDURE,
1337: G_MODULE_NAME||l_procedure_name,
1338: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
1339: END IF;
1340:

Line 1566: fnd_log.string(G_LEVEL_PROCEDURE,

1562: AND adj.set_of_books_id = bc.set_of_books_id
1563: AND adj.set_of_books_id = ai.set_of_books_id(+) ;
1564:
1565: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1566: fnd_log.string(G_LEVEL_PROCEDURE,
1567: G_MODULE_NAME||l_procedure_name,
1568: 'Rows inserted into alc lines: ' || to_char(SQL%ROWCOUNT));
1569: END IF;
1570:

Line 1577: fnd_log.string(G_LEVEL_PROCEDURE,

1573: end if;
1574:
1575:
1576: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1577: fnd_log.string(G_LEVEL_PROCEDURE,
1578: G_MODULE_NAME||l_procedure_name||'.end',
1579: 'End of procedure');
1580: END IF;
1581:

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

1583: WHEN others THEN
1584: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1585: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1586: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1587: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1588: END IF;
1589: raise;
1590:
1591: end load_line_data_fin1;

Line 1610: fnd_log.string(G_LEVEL_PROCEDURE,

1606:
1607: BEGIN
1608:
1609: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1610: fnd_log.string(G_LEVEL_PROCEDURE,
1611: G_MODULE_NAME||l_procedure_name||'.begin',
1612: 'Beginning of procedure');
1613: END IF;
1614:

Line 1795: fnd_log.string(G_LEVEL_PROCEDURE,

1791: 'RESERVE_TRANSFERS')
1792: AND adj.source_line_id = ai.source_line_id(+) ;
1793:
1794: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1795: fnd_log.string(G_LEVEL_PROCEDURE,
1796: G_MODULE_NAME||l_procedure_name,
1797: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
1798: END IF;
1799:

Line 1989: fnd_log.string(G_LEVEL_PROCEDURE,

1985: AND adj.set_of_books_id = bc.set_of_books_id
1986: AND adj.set_of_books_id = ai.set_of_books_id(+) ;
1987:
1988: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1989: fnd_log.string(G_LEVEL_PROCEDURE,
1990: G_MODULE_NAME||l_procedure_name,
1991: 'Rows inserted into alc lines: ' || to_char(SQL%ROWCOUNT));
1992: END IF;
1993:

Line 2000: fnd_log.string(G_LEVEL_PROCEDURE,

1996: end if;
1997:
1998:
1999: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2000: fnd_log.string(G_LEVEL_PROCEDURE,
2001: G_MODULE_NAME||l_procedure_name||'.end',
2002: 'End of procedure');
2003: END IF;
2004:

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

2006: WHEN others THEN
2007: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2008: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2009: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2010: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2011: END IF;
2012: raise;
2013:
2014: end load_line_data_fin2;

Line 2033: fnd_log.string(G_LEVEL_PROCEDURE,

2029:
2030: BEGIN
2031:
2032: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2033: fnd_log.string(G_LEVEL_PROCEDURE,
2034: G_MODULE_NAME||l_procedure_name||'.begin',
2035: 'Beginning of procedure');
2036: END IF;
2037:

Line 2208: fnd_log.string(G_LEVEL_PROCEDURE,

2204: AND adj.adjustment_amount <> 0
2205: AND stg.event_type_code in ('TRANSFERS', 'CIP_TRANSFERS') ;
2206:
2207: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2208: fnd_log.string(G_LEVEL_PROCEDURE,
2209: G_MODULE_NAME||l_procedure_name,
2210: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
2211: END IF;
2212:

Line 2391: fnd_log.string(G_LEVEL_PROCEDURE,

2387: 'SECONDARY')
2388: AND adj.set_of_books_id = bc.set_of_books_id ;
2389:
2390: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2391: fnd_log.string(G_LEVEL_PROCEDURE,
2392: G_MODULE_NAME||l_procedure_name,
2393: 'Rows inserted into alc lines: ' || to_char(SQL%ROWCOUNT));
2394: END IF;
2395:

Line 2402: fnd_log.string(G_LEVEL_PROCEDURE,

2398: end if;
2399:
2400:
2401: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2402: fnd_log.string(G_LEVEL_PROCEDURE,
2403: G_MODULE_NAME||l_procedure_name||'.end',
2404: 'End of procedure');
2405: END IF;
2406:

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

2408: WHEN others THEN
2409: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2410: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2411: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2412: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2413: END IF;
2414: raise;
2415:
2416: end load_line_data_xfr;

Line 2435: fnd_log.string(G_LEVEL_PROCEDURE,

2431:
2432: BEGIN
2433:
2434: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2435: fnd_log.string(G_LEVEL_PROCEDURE,
2436: G_MODULE_NAME||l_procedure_name||'.begin',
2437: 'Beginning of procedure');
2438: END IF;
2439:

Line 2588: fnd_log.string(G_LEVEL_PROCEDURE,

2584: AND cb.book_type_code = adj.book_type_code
2585: AND adj.source_dest_code = 'SOURCE' ;
2586:
2587: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2588: fnd_log.string(G_LEVEL_PROCEDURE,
2589: G_MODULE_NAME||l_procedure_name,
2590: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
2591: END IF;
2592:

Line 2749: fnd_log.string(G_LEVEL_PROCEDURE,

2745: 'SECONDARY')
2746: AND adj.set_of_books_id = bc.set_of_books_id ;
2747:
2748: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2749: fnd_log.string(G_LEVEL_PROCEDURE,
2750: G_MODULE_NAME||l_procedure_name,
2751: 'Rows inserted into alc lines: ' || to_char(SQL%ROWCOUNT));
2752: END IF;
2753:

Line 2895: fnd_log.string(G_LEVEL_PROCEDURE,

2891: 'UNIT_ADJUSTMENTS', 'CIP_UNIT_ADJUSTMENTS')
2892: AND adj.source_dest_code = 'DEST' ;
2893:
2894: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2895: fnd_log.string(G_LEVEL_PROCEDURE,
2896: G_MODULE_NAME||l_procedure_name,
2897: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
2898: END IF;
2899:

Line 3050: fnd_log.string(G_LEVEL_PROCEDURE,

3046: 'SECONDARY')
3047: AND adj.set_of_books_id = bc.set_of_books_id ;
3048:
3049: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3050: fnd_log.string(G_LEVEL_PROCEDURE,
3051: G_MODULE_NAME||l_procedure_name,
3052: 'Rows inserted into alc lines: ' || to_char(SQL%ROWCOUNT));
3053: END IF;
3054:

Line 3061: fnd_log.string(G_LEVEL_PROCEDURE,

3057: end if;
3058:
3059:
3060: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3061: fnd_log.string(G_LEVEL_PROCEDURE,
3062: G_MODULE_NAME||l_procedure_name||'.end',
3063: 'End of procedure');
3064: END IF;
3065:

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

3067: WHEN others THEN
3068: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3069: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3070: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3071: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3072: END IF;
3073: raise;
3074:
3075: end load_line_data_dist;

Line 3094: fnd_log.string(G_LEVEL_PROCEDURE,

3090:
3091: BEGIN
3092:
3093: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3094: fnd_log.string(G_LEVEL_PROCEDURE,
3095: G_MODULE_NAME||l_procedure_name||'.begin',
3096: 'Beginning of procedure');
3097: END IF;
3098:

Line 3253: fnd_log.string(G_LEVEL_PROCEDURE,

3249: AND stg.event_type_code in ('RETIREMENTS', 'CIP_RETIREMENTS')
3250: AND ret.transaction_header_id_in = stg.member_transaction_header_id ;
3251:
3252: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3253: fnd_log.string(G_LEVEL_PROCEDURE,
3254: G_MODULE_NAME||l_procedure_name,
3255: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
3256: END IF;
3257:

Line 3421: fnd_log.string(G_LEVEL_PROCEDURE,

3417: AND ret.set_of_books_id = bc.set_of_books_id
3418: AND adj.set_of_books_id = bc.set_of_books_id ;
3419:
3420: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3421: fnd_log.string(G_LEVEL_PROCEDURE,
3422: G_MODULE_NAME||l_procedure_name,
3423: 'Rows inserted into alc lines: ' || to_char(SQL%ROWCOUNT));
3424: END IF;
3425:

Line 3432: fnd_log.string(G_LEVEL_PROCEDURE,

3428: end if;
3429:
3430:
3431: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3432: fnd_log.string(G_LEVEL_PROCEDURE,
3433: G_MODULE_NAME||l_procedure_name||'.end',
3434: 'End of procedure');
3435: END IF;
3436:

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

3438: WHEN others THEN
3439: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3440: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3441: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3442: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3443: END IF;
3444: raise;
3445:
3446: end load_line_data_ret;

Line 3465: fnd_log.string(G_LEVEL_PROCEDURE,

3461:
3462: BEGIN
3463:
3464: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3465: fnd_log.string(G_LEVEL_PROCEDURE,
3466: G_MODULE_NAME||l_procedure_name||'.begin',
3467: 'Beginning of procedure');
3468: END IF;
3469:

Line 3624: fnd_log.string(G_LEVEL_PROCEDURE,

3620: AND stg.event_type_code in ('REINSTATEMENTS','CIP_REINSTATEMENTS')
3621: AND ret.transaction_header_id_out = stg.member_transaction_header_id ;
3622:
3623: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3624: fnd_log.string(G_LEVEL_PROCEDURE,
3625: G_MODULE_NAME||l_procedure_name,
3626: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
3627: END IF;
3628:

Line 3792: fnd_log.string(G_LEVEL_PROCEDURE,

3788: AND ret.set_of_books_id = bc.set_of_books_id
3789: AND adj.set_of_books_id = bc.set_of_books_id ;
3790:
3791: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3792: fnd_log.string(G_LEVEL_PROCEDURE,
3793: G_MODULE_NAME||l_procedure_name,
3794: 'Rows inserted into alc lines: ' || to_char(SQL%ROWCOUNT));
3795: END IF;
3796:

Line 3803: fnd_log.string(G_LEVEL_PROCEDURE,

3799: end if;
3800:
3801:
3802: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3803: fnd_log.string(G_LEVEL_PROCEDURE,
3804: G_MODULE_NAME||l_procedure_name||'.end',
3805: 'End of procedure');
3806: END IF;
3807:

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

3809: WHEN others THEN
3810: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3811: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3812: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3813: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3814: END IF;
3815: raise;
3816:
3817: end load_line_data_res;

Line 3835: fnd_log.string(G_LEVEL_PROCEDURE,

3831:
3832: BEGIN
3833:
3834: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3835: fnd_log.string(G_LEVEL_PROCEDURE,
3836: G_MODULE_NAME||l_procedure_name||'.begin',
3837: 'Beginning of procedure');
3838: END IF;
3839:

Line 3843: fnd_log.string(G_LEVEL_PROCEDURE,

3839:
3840: return;
3841:
3842: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3843: fnd_log.string(G_LEVEL_PROCEDURE,
3844: G_MODULE_NAME||l_procedure_name,
3845: 'Rows inserted into mls: ' || to_char(SQL%ROWCOUNT));
3846: END IF;
3847:

Line 3851: fnd_log.string(G_LEVEL_PROCEDURE,

3847:
3848:
3849:
3850: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3851: fnd_log.string(G_LEVEL_PROCEDURE,
3852: G_MODULE_NAME||l_procedure_name||'.end',
3853: 'End of procedure');
3854: END IF;
3855:

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

3857: WHEN others THEN
3858: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3859: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3860: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3861: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3862: END IF;
3863: raise;
3864:
3865: end load_mls_data;

Line 4130: fnd_log.string(G_LEVEL_PROCEDURE,

4126:
4127: BEGIN
4128:
4129: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
4130: fnd_log.string(G_LEVEL_PROCEDURE,
4131: G_MODULE_NAME||l_procedure_name||'.begin',
4132: 'Beginning of procedure');
4133: END IF;
4134:

Line 4271: fnd_log.string(G_LEVEL_PROCEDURE,

4267:
4268: --
4269:
4270: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4271: fnd_log.string(G_LEVEL_PROCEDURE,
4272: G_MODULE_NAME||l_procedure_name||'.end',
4273: 'End of procedure');
4274: END IF;
4275:

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

4277: WHEN others THEN
4278: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4279: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4280: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4281: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4282: END IF;
4283: raise;
4284:
4285: END load_generated_ccids;

Line 4309: fnd_log.string(G_LEVEL_PROCEDURE,

4305:
4306: BEGIN
4307:
4308: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
4309: fnd_log.string(G_LEVEL_PROCEDURE,
4310: G_MODULE_NAME||l_procedure_name||'.begin',
4311: 'Beginning of procedure');
4312: END IF;
4313:

Line 4317: fnd_log.string(G_LEVEL_PROCEDURE,

4313:
4314:
4315: --
4316: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
4317: fnd_log.string(G_LEVEL_PROCEDURE,
4318: G_MODULE_NAME||l_procedure_name||'.end',
4319: 'End of procedure');
4320: END IF;
4321:

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

4323: WHEN others THEN
4324: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
4325: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4326: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4327: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4328: END IF;
4329: raise;
4330:
4331:

Line 4356: fnd_log.string(G_LEVEL_PROCEDURE,

4352:
4353: BEGIN
4354:
4355: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4356: fnd_log.string(G_LEVEL_PROCEDURE,
4357: G_MODULE_NAME||l_procedure_name||'.begin',
4358: 'Beginning of procedure');
4359: END IF;
4360:

Line 4418: fnd_log.string(G_LEVEL_PROCEDURE,

4414:
4415:
4416:
4417: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4418: fnd_log.string(G_LEVEL_PROCEDURE,
4419: G_MODULE_NAME||l_procedure_name||'.end',
4420: 'End of procedure');
4421: END IF;
4422:

Line 4426: FND_LOG.string (G_LEVEL_ERROR,

4422:
4423: EXCEPTION
4424: WHEN error_found THEN
4425: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
4426: FND_LOG.string (G_LEVEL_ERROR,
4427: G_MODULE_NAME||l_procedure_name,
4428: 'ended in error');
4429: END IF;
4430: raise;

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

4432: WHEN others THEN
4433: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4434: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4435: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4436: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4437: END IF;
4438: raise;
4439:
4440: END load_data;