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

Line 91: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

87:
88: -- TYPES
89: -- globals / constants
90:
91: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
92:
93: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

89: -- globals / constants
90:
91: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
92:
93: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
96: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

90:
91: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
92:
93: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
96: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
98: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

91: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
92:
93: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
96: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
98: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:

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

92:
93: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
96: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
98: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:
100: G_MODULE_NAME CONSTANT VARCHAR2(50):= ''fa.plsql.fa_xla_extract_$EXTRACT_TYPE$_pkg.'';

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

93: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
96: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
98: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:
100: G_MODULE_NAME CONSTANT VARCHAR2(50):= ''fa.plsql.fa_xla_extract_$EXTRACT_TYPE$_pkg.'';
101:

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

94: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
96: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
97: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
98: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99:
100: G_MODULE_NAME CONSTANT VARCHAR2(50):= ''fa.plsql.fa_xla_extract_$EXTRACT_TYPE$_pkg.'';
101:
102:

Line 142: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

138: --+==========================================================================+
139:
140: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
141:
142: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143:
144: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
145: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
146: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

140: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
141:
142: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143:
144: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
145: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
146: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
147: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
148: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

141:
142: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143:
144: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
145: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
146: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
147: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
148: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
149: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

142: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143:
144: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
145: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
146: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
147: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
148: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
149: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
150:

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

143:
144: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
145: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
146: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
147: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
148: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
149: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
150:
151: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_extract_pkg.';

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

144: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
145: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
146: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
147: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
148: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
149: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
150:
151: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_extract_pkg.';
152:

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

145: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
146: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
147: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
148: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
149: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
150:
151: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_extract_pkg.';
152:
153: --+==========================================================================+

Line 182: fnd_log.string(G_LEVEL_PROCEDURE,

178:
179: BEGIN
180:
181: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
182: fnd_log.string(G_LEVEL_PROCEDURE,
183: G_MODULE_NAME||l_procedure_name||'.begin',
184: 'Beginning of procedure');
185: END IF;
186:

Line 188: fnd_log.string(G_LEVEL_STATEMENT,

184: 'Beginning of procedure');
185: END IF;
186:
187: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
188: fnd_log.string(G_LEVEL_STATEMENT,
189: G_MODULE_NAME||l_procedure_name,
190: 'SQL - Select from fnd_user');
191: END IF;
192:

Line 199: fnd_log.string(G_LEVEL_STATEMENT,

195: FROM fnd_user fd
196: WHERE fd.user_id = fnd_global.user_id;
197:
198: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
199: fnd_log.string(G_LEVEL_STATEMENT,
200: G_MODULE_NAME||l_procedure_name,
201: 'User name = ' || l_user_name);
202: END IF;
203:

Line 205: fnd_log.string(G_LEVEL_PROCEDURE,

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

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

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

Line 273: fnd_log.string(G_LEVEL_PROCEDURE,

269:
270: BEGIN
271:
272: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
273: fnd_log.string(G_LEVEL_PROCEDURE,
274: G_MODULE_NAME||l_procedure_name||'.begin',
275: 'Beginning of procedure');
276: END IF;
277:

Line 279: fnd_log.string(G_LEVEL_STATEMENT,

275: 'Beginning of procedure');
276: END IF;
277:
278: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
279: fnd_log.string(G_LEVEL_STATEMENT,
280: G_MODULE_NAME||l_procedure_name,
281: 'p_user_name = '||p_user_name||
282: ' - p_package_name = '||p_package_name);
283: END IF;

Line 305: fnd_log.string(G_LEVEL_PROCEDURE,

301:
302: l_header := REPLACE(l_header,'$history',l_StringValue );
303:
304: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
305: fnd_log.string(G_LEVEL_PROCEDURE,
306: G_MODULE_NAME||l_procedure_name||'.end',
307: 'End of procedure');
308: END IF;
309:

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

313: WHEN OTHERS THEN
314: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
315: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
316: fnd_message.set_token('ORACLE_ERR',SQLERRM);
317: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
318: END IF;
319: raise;
320:
321: END GeneratePkgComment;

Line 356: fnd_log.string(G_LEVEL_PROCEDURE,

352:
353: BEGIN
354:
355: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
356: fnd_log.string(G_LEVEL_PROCEDURE,
357: G_MODULE_NAME||l_procedure_name||'.begin',
358: 'Beginning of procedure');
359: END IF;
360:

Line 362: fnd_log.string(G_LEVEL_STATEMENT,

358: 'Beginning of procedure');
359: END IF;
360:
361: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
362: fnd_log.string(G_LEVEL_STATEMENT,
363: G_MODULE_NAME||l_procedure_name,
364: 'p_user_name = '||p_user_name||
365: ' - p_package_name = '||p_package_name||
366: ' - p_extract_type = '||p_extract_type);

Line 379: fnd_log.string(G_LEVEL_PROCEDURE,

375: , p_package_name => p_package_name
376: ) );
377:
378: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
379: fnd_log.string(G_LEVEL_PROCEDURE,
380: G_MODULE_NAME||l_procedure_name||'.end',
381: 'End of procedure' || length(l_SpecPkg));
382: END IF;
383:

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

388: WHEN OTHERS THEN
389: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
390: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
391: fnd_message.set_token('ORACLE_ERR',SQLERRM);
392: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
393: END IF;
394: raise;
395:
396: END BuildSpecPkg;

Line 420: fnd_log.string(G_LEVEL_PROCEDURE,

416:
417: BEGIN
418:
419: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
420: fnd_log.string(G_LEVEL_PROCEDURE,
421: G_MODULE_NAME||l_procedure_name||'.begin',
422: 'Beginning of procedure');
423: END IF;
424:

Line 426: fnd_log.string(G_LEVEL_STATEMENT,

422: 'Beginning of procedure');
423: END IF;
424:
425: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
426: fnd_log.string(G_LEVEL_STATEMENT,
427: G_MODULE_NAME||l_procedure_name,
428: ' p_extract_type = '||p_extract_type);
429: END IF;
430:

Line 438: fnd_log.string(G_LEVEL_PROCEDURE,

434: , p_extract_type => p_extract_type
435: );
436:
437: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
438: fnd_log.string(G_LEVEL_PROCEDURE,
439: G_MODULE_NAME||l_procedure_name||'.end',
440: 'End of procedure');
441: END IF;
442:

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

447: WHEN OTHERS THEN
448: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
449: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
450: fnd_message.set_token('ORACLE_ERR',SQLERRM);
451: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
452: END IF;
453: return false;
454:
455: END GenerateSpecPackage;

Line 479: fnd_log.string(G_LEVEL_PROCEDURE,

475:
476: BEGIN
477:
478: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
479: fnd_log.string(G_LEVEL_PROCEDURE,
480: G_MODULE_NAME||l_procedure_name||'.begin',
481: 'Beginning of procedure');
482: END IF;
483:

Line 490: fnd_log.string(G_LEVEL_STATEMENT,

486: , p_package => l_Package
487: );
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: ' Compile the specification package in the DATABASE'||
493: ' - length of the package = '||length(l_Package));
494: END IF;

Line 502: fnd_log.string(G_LEVEL_STATEMENT,

498: , p_package_text => l_Package
499: ) AND l_IsCompiled;
500:
501: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
502: fnd_log.string(G_LEVEL_STATEMENT,
503: G_MODULE_NAME||l_procedure_name,
504: 'END of CreateSpecPackage : return = '
505: ||CASE WHEN l_IsCompiled THEN 'TRUE' ELSE 'FALSE' END);
506: END IF;

Line 510: fnd_log.string(G_LEVEL_PROCEDURE,

506: END IF;
507:
508:
509: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
510: fnd_log.string(G_LEVEL_PROCEDURE,
511: G_MODULE_NAME||l_procedure_name||'.end',
512: 'End of procedure');
513: END IF;
514:

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

519: WHEN OTHERS THEN
520: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
521: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
522: fnd_message.set_token('ORACLE_ERR',SQLERRM);
523: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
524: END IF;
525: return FALSE;
526:
527: END CreateSpecPackage;

Line 565: fnd_log.string(G_LEVEL_PROCEDURE,

561:
562: BEGIN
563:
564: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
565: fnd_log.string(G_LEVEL_PROCEDURE,
566: G_MODULE_NAME||l_procedure_name||'.begin',
567: 'Beginning of procedure');
568: END IF;
569:

Line 582: fnd_log.string(G_LEVEL_STATEMENT,

578: -- Generate Header Section
579: --
580:
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: '-> CALL FA_XLA_CMP_HEADER_PKG.GenerateHeaderExtract API');
585: END IF;
586:

Line 606: fnd_log.string(G_LEVEL_STATEMENT,

602: --
603: -- generate line sections
604: --
605: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
606: fnd_log.string(G_LEVEL_STATEMENT,
607: G_MODULE_NAME||l_procedure_name,
608: '-> CALL FA_XLA_CMP_LINES_PKG.GenerateLinesExtract API');
609: END IF;
610:

Line 632: fnd_log.string(G_LEVEL_STATEMENT,

628: --
629: -- generate mls section
630: --
631: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
632: fnd_log.string(G_LEVEL_STATEMENT,
633: G_MODULE_NAME||l_procedure_name,
634: '-> CALL FA_XLA_CMP_LINES_PKG.GenerateMlsExtract API');
635: END IF;
636:

Line 697: fnd_log.string(G_LEVEL_STATEMENT,

693: -- generate main procedure
694: --
695:
696: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
697: fnd_log.string(G_LEVEL_STATEMENT,
698: G_MODULE_NAME||l_procedure_name,
699: '-> CALL FA_XLA_CMP_LOAD_PKG.GenerateLoadExtract API');
700: END IF;
701:

Line 721: fnd_log.string(G_LEVEL_STATEMENT,

717: p_package_body := l_array_body;
718:
719:
720: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
721: fnd_log.string(G_LEVEL_STATEMENT,
722: G_MODULE_NAME||l_procedure_name,
723: 'l_isCompiled = '||CASE WHEN l_IsCompiled
724: THEN 'TRUE'
725: ELSE 'FALSE' END);

Line 729: fnd_log.string(G_LEVEL_PROCEDURE,

725: ELSE 'FALSE' END);
726: END IF;
727:
728: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
729: fnd_log.string(G_LEVEL_PROCEDURE,
730: G_MODULE_NAME||l_procedure_name||'.end',
731: 'End of procedure');
732: END IF;
733:

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

737: WHEN OTHERS THEN
738: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
739: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
740: fnd_message.set_token('ORACLE_ERR',SQLERRM);
741: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
742: END IF;
743: return false;
744:
745: END GeneratePrivateProcedures;

Line 769: fnd_log.string(G_LEVEL_PROCEDURE,

765:
766: BEGIN
767:
768: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
769: fnd_log.string(G_LEVEL_PROCEDURE,
770: G_MODULE_NAME||l_procedure_name||'.begin',
771: 'Beginning of procedure');
772: END IF;
773:

Line 775: fnd_log.string(G_LEVEL_STATEMENT,

771: 'Beginning of procedure');
772: END IF;
773:
774: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
775: fnd_log.string(G_LEVEL_STATEMENT,
776: G_MODULE_NAME||l_procedure_name,
777: 'p_package_name = '||p_package_name||
778: ' - p_extract_type = '||p_extract_type);
779: END IF;

Line 789: fnd_log.string(G_LEVEL_STATEMENT,

785: ,p_package_body => p_package_body);
786:
787:
788: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
789: fnd_log.string(G_LEVEL_STATEMENT,
790: G_MODULE_NAME||l_procedure_name,
791: 'l_isCompiled = '||CASE WHEN l_IsCompiled
792: THEN 'TRUE'
793: ELSE 'FALSE' END);

Line 797: fnd_log.string(G_LEVEL_PROCEDURE,

793: ELSE 'FALSE' END);
794: END IF;
795:
796: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
797: fnd_log.string(G_LEVEL_PROCEDURE,
798: G_MODULE_NAME||l_procedure_name||'.end',
799: 'End of procedure');
800: END IF;
801:

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

805: WHEN OTHERS THEN
806: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
807: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
808: fnd_message.set_token('ORACLE_ERR',SQLERRM);
809: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
810: END IF;
811: return false;
812:
813: END GenerateBody;

Line 840: fnd_log.string(G_LEVEL_PROCEDURE,

836:
837: BEGIN
838:
839: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
840: fnd_log.string(G_LEVEL_PROCEDURE,
841: G_MODULE_NAME||l_procedure_name||'.begin',
842: 'Beginning of procedure');
843: END IF;
844:

Line 846: fnd_log.string(G_LEVEL_STATEMENT,

842: 'Beginning of procedure');
843: END IF;
844:
845: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
846: fnd_log.string(G_LEVEL_STATEMENT,
847: G_MODULE_NAME||l_procedure_name,
848: 'p_extract_type = '||p_extract_type);
849: END IF;
850:

Line 903: fnd_log.string(G_LEVEL_STATEMENT,

899:
900: p_package_body := l_array_pkg;
901:
902: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
903: fnd_log.string(G_LEVEL_STATEMENT,
904: G_MODULE_NAME||l_procedure_name,
905: 'return value (l_IsCompiled) = '||
906: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
907: END IF;

Line 910: fnd_log.string(G_LEVEL_PROCEDURE,

906: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
907: END IF;
908:
909: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
910: fnd_log.string(G_LEVEL_PROCEDURE,
911: G_MODULE_NAME||l_procedure_name||'.end',
912: 'End of procedure');
913: END IF;
914:

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

918: WHEN OTHERS THEN
919: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
920: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
921: fnd_message.set_token('ORACLE_ERR',SQLERRM);
922: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
923: END IF;
924: RETURN FALSE;
925:
926: END GenerateBodyPackage;

Line 953: fnd_log.string(G_LEVEL_PROCEDURE,

949:
950: BEGIN
951:
952: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
953: fnd_log.string(G_LEVEL_PROCEDURE,
954: G_MODULE_NAME||l_procedure_name||'.begin',
955: 'Beginning of procedure');
956: END IF;
957:

Line 971: fnd_log.string(G_LEVEL_STATEMENT,

967: (p_package_name => g_PackageName
968: ,p_package_text => l_Package) AND l_IsCompiled;
969:
970: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
971: fnd_log.string(G_LEVEL_STATEMENT,
972: G_MODULE_NAME||l_procedure_name,
973: 'return value (l_IsCompiled) = '||
974: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
975: END IF;

Line 978: fnd_log.string(G_LEVEL_PROCEDURE,

974: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
975: END IF;
976:
977: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
978: fnd_log.string(G_LEVEL_PROCEDURE,
979: G_MODULE_NAME||l_procedure_name||'.end',
980: 'End of procedure');
981: END IF;
982:

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

986: WHEN OTHERS THEN
987: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
988: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
989: fnd_message.set_token('ORACLE_ERR',SQLERRM);
990: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
991: END IF;
992:
993: return false;
994:

Line 1025: fnd_log.string(G_LEVEL_PROCEDURE,

1021:
1022: BEGIN
1023:
1024: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1025: fnd_log.string(G_LEVEL_PROCEDURE,
1026: G_MODULE_NAME||l_procedure_name||'.begin',
1027: 'Beginning of procedure');
1028: END IF;
1029:

Line 1034: fnd_log.string(G_LEVEL_STATEMENT,

1030: g_UserName := GetUserName;
1031:
1032:
1033: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1034: fnd_log.string(G_LEVEL_STATEMENT,
1035: G_MODULE_NAME||l_procedure_name,
1036: 'entering loop');
1037: END IF;
1038:

Line 1061: fnd_log.string(G_LEVEL_STATEMENT,

1057: g_PackageName := 'FA_XLA_EXTRACT_DEF_PKG';
1058: end if;
1059:
1060: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1061: fnd_log.string(G_LEVEL_STATEMENT,
1062: G_MODULE_NAME||l_procedure_name,
1063: 'l_extract_type = '||l_extract_type ||
1064: ' - g_PackageName = '||g_PackageName);
1065: END IF;

Line 1072: fnd_log.string(G_LEVEL_STATEMENT,

1068: CreateSpecPackage
1069: (p_extract_type => l_extract_type);
1070:
1071: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1072: fnd_log.string(G_LEVEL_STATEMENT,
1073: G_MODULE_NAME||l_procedure_name,
1074: ' FA specification package created = '||
1075: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
1076: END IF;

Line 1084: fnd_log.string(G_LEVEL_STATEMENT,

1080: CreateBodyPackage
1081: (p_extract_type => l_extract_type);
1082:
1083: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1084: fnd_log.string(G_LEVEL_STATEMENT,
1085: G_MODULE_NAME||l_procedure_name,
1086: ' AAD body package created = '||
1087: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
1088: END IF;

Line 1098: fnd_log.string(G_LEVEL_STATEMENT,

1094:
1095: COMMIT;
1096:
1097: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1098: fnd_log.string(G_LEVEL_STATEMENT,
1099: G_MODULE_NAME||l_procedure_name,
1100: 'return value. = '||
1101: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
1102: END IF;

Line 1105: fnd_log.string(G_LEVEL_PROCEDURE,

1101: CASE l_IsCompiled WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END);
1102: END IF;
1103:
1104: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1105: fnd_log.string(G_LEVEL_PROCEDURE,
1106: G_MODULE_NAME||l_procedure_name||'.end',
1107: 'End of procedure');
1108: END IF;
1109:

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

1113: WHEN OTHERS THEN
1114: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1115: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1116: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1117: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1118: END IF;
1119: RETURN FALSE;
1120:
1121: END Compile;