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

Line 37: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

33: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
34:
35: g_log_level_rec fa_api_types.log_level_rec_type;
36:
37: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
38:
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

35: g_log_level_rec fa_api_types.log_level_rec_type;
36:
37: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
38:
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
43: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

36:
37: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
38:
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
43: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

37: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
38:
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
43: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45:

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

38:
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
43: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45:
46: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_create_pkg.';

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

39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
43: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45:
46: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_create_pkg.';
47:

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

40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
43: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45:
46: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_create_pkg.';
47:
48: --+==========================================================================+

Line 73: fnd_log.string(G_LEVEL_PROCEDURE,

69:
70: BEGIN
71:
72: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
73: fnd_log.string(G_LEVEL_PROCEDURE,
74: G_MODULE_NAME||l_procedure_name||'.begin',
75: 'Beginning of procedure');
76: END IF;
77:

Line 85: fnd_log.string(G_LEVEL_STATEMENT,

81:
82: IF l_first THEN
83:
84: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
85: fnd_log.string(G_LEVEL_STATEMENT,
86: G_MODULE_NAME||l_procedure_name,
87: '>>> DUMP '|| p_package_type ||' = '||p_package_name);
88: END IF;
89:

Line 95: fnd_log.string(G_LEVEL_STATEMENT,

91:
92: END IF;
93:
94: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
95: fnd_log.string(G_LEVEL_STATEMENT,
96: G_MODULE_NAME||l_procedure_name,
97: RPAD(text_rec.line ,10,' ') ||' '||text_rec.text);
98: END IF;
99:

Line 104: fnd_log.string(G_LEVEL_PROCEDURE,

100: END LOOP;
101: END IF;
102:
103: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
104: fnd_log.string(G_LEVEL_PROCEDURE,
105: G_MODULE_NAME||l_procedure_name||'.end',
106: 'End of procedure');
107: END IF;
108:

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

110: WHEN OTHERS THEN
111: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
112: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
113: fnd_message.set_token('ORACLE_ERR',SQLERRM);
114: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
115: END IF;
116: raise;
117:
118: END dump_package;

Line 145: fnd_log.string(G_LEVEL_PROCEDURE,

141:
142: BEGIN
143:
144: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
145: fnd_log.string(G_LEVEL_PROCEDURE,
146: G_MODULE_NAME||l_procedure_name||'.begin',
147: 'Beginning of procedure');
148: END IF;
149:

Line 157: fnd_log.string(G_LEVEL_STATEMENT,

153: IF l_first THEN
154:
155: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
156:
157: fnd_log.string(G_LEVEL_STATEMENT,
158: G_MODULE_NAME||l_procedure_name,
159: '----- COMPILATION FAILS ------');
160:
161: fnd_log.string(G_LEVEL_STATEMENT,

Line 161: fnd_log.string(G_LEVEL_STATEMENT,

157: fnd_log.string(G_LEVEL_STATEMENT,
158: G_MODULE_NAME||l_procedure_name,
159: '----- COMPILATION FAILS ------');
160:
161: fnd_log.string(G_LEVEL_STATEMENT,
162: G_MODULE_NAME||l_procedure_name,
163: 'Additional information = ');
164:
165: fnd_log.string(G_LEVEL_STATEMENT,

Line 165: fnd_log.string(G_LEVEL_STATEMENT,

161: fnd_log.string(G_LEVEL_STATEMENT,
162: G_MODULE_NAME||l_procedure_name,
163: 'Additional information = ');
164:
165: fnd_log.string(G_LEVEL_STATEMENT,
166: G_MODULE_NAME||l_procedure_name,
167: '------------------------------');
168:
169: fnd_log.string(G_LEVEL_STATEMENT,

Line 169: fnd_log.string(G_LEVEL_STATEMENT,

165: fnd_log.string(G_LEVEL_STATEMENT,
166: G_MODULE_NAME||l_procedure_name,
167: '------------------------------');
168:
169: fnd_log.string(G_LEVEL_STATEMENT,
170: G_MODULE_NAME||l_procedure_name,
171: 'Package name = '||p_package_name);
172:
173: fnd_log.string(G_LEVEL_STATEMENT,

Line 173: fnd_log.string(G_LEVEL_STATEMENT,

169: fnd_log.string(G_LEVEL_STATEMENT,
170: G_MODULE_NAME||l_procedure_name,
171: 'Package name = '||p_package_name);
172:
173: fnd_log.string(G_LEVEL_STATEMENT,
174: G_MODULE_NAME||l_procedure_name,
175: RPAD('LINE',10,' ') ||'|' ||' ERROR ');
176:
177: fnd_log.string(G_LEVEL_STATEMENT,

Line 177: fnd_log.string(G_LEVEL_STATEMENT,

173: fnd_log.string(G_LEVEL_STATEMENT,
174: G_MODULE_NAME||l_procedure_name,
175: RPAD('LINE',10,' ') ||'|' ||' ERROR ');
176:
177: fnd_log.string(G_LEVEL_STATEMENT,
178: G_MODULE_NAME||l_procedure_name,
179: LPAD('-',10,'-') ||'|' ||LPAD('-',50,'-'));
180:
181: END IF;

Line 189: fnd_log.string(G_LEVEL_STATEMENT,

185: END IF;
186:
187:
188: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
189: fnd_log.string(G_LEVEL_STATEMENT,
190: G_MODULE_NAME||l_procedure_name,
191: RPAD(error_rec.line,10,' ') ||'| '||error_rec.error);
192: END IF;
193:

Line 197: fnd_log.string(G_LEVEL_PROCEDURE,

193:
194: END LOOP;
195:
196: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
197: fnd_log.string(G_LEVEL_PROCEDURE,
198: G_MODULE_NAME||l_procedure_name||'.end',
199: 'End of procedure');
200: END IF;
201:

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

203: WHEN OTHERS THEN
204: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
205: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
206: fnd_message.set_token('ORACLE_ERR',SQLERRM);
207: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
208: END IF;
209: raise;
210:
211: END get_pkg_errors;

Line 231: fnd_log.string(G_LEVEL_PROCEDURE,

227:
228: BEGIN
229:
230: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
231: fnd_log.string(G_LEVEL_PROCEDURE,
232: G_MODULE_NAME||l_procedure_name||'.begin',
233: 'Beginning of procedure');
234: END IF;
235:

Line 252: fnd_log.string(G_LEVEL_PROCEDURE,

248: l_IsValid := FALSE;
249: END;
250:
251: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
252: fnd_log.string(G_LEVEL_PROCEDURE,
253: G_MODULE_NAME||l_procedure_name||'.end',
254: 'End of procedure');
255: END IF;
256:

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

260: WHEN OTHERS THEN
261: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
262: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
263: fnd_message.set_token('ORACLE_ERR',SQLERRM);
264: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
265: END IF;
266: RETURN FALSE;
267:
268: END GetPackageStatus;

Line 294: fnd_log.string(G_LEVEL_PROCEDURE,

290:
291: BEGIN
292:
293: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
294: fnd_log.string(G_LEVEL_PROCEDURE,
295: G_MODULE_NAME||l_procedure_name||'.begin',
296: 'Beginning of procedure');
297: END IF;
298:

Line 309: fnd_log.string(G_LEVEL_STATEMENT,

305: -- call apps_array_ddl API to create body package
306: --
307:
308: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
309: fnd_log.string(G_LEVEL_STATEMENT,
310: G_MODULE_NAME||l_procedure_name,
311: '-> CALL APPS_ARRAY_DDL.apps_array_ddl API');
312: END IF;
313:

Line 320: fnd_log.string(G_LEVEL_PROCEDURE,

316: ub => l_ub
317: );
318:
319: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
320: fnd_log.string(G_LEVEL_PROCEDURE,
321: G_MODULE_NAME||l_procedure_name||'.end',
322: 'End of procedure');
323: END IF;
324:

Line 331: fnd_log.string(G_LEVEL_STATEMENT,

327: EXCEPTION
328: WHEN package_locked THEN
329:
330: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
331: fnd_log.string(G_LEVEL_STATEMENT,
332: G_MODULE_NAME||l_procedure_name,
333: 'ERROR: Package Locked');
334: END IF;
335:

Line 339: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);

335:
336: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
337: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
338: fnd_message.set_token('PACKAGE_NAME',p_package_name);
339: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
340: END IF;
341:
342: RETURN FALSE;
343:

Line 347: fnd_log.string(G_LEVEL_STATEMENT,

343:
344: WHEN compilation_fails THEN
345:
346: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
347: fnd_log.string(G_LEVEL_STATEMENT,
348: G_MODULE_NAME||l_procedure_name,
349: 'ERROR: Package Compilation Failed');
350: END IF;
351:

Line 355: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);

351:
352: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
353: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
354: fnd_message.set_token('PACKAGE_NAME',p_package_name);
355: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
356: END IF;
357:
358: RETURN FALSE;
359:

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:
367: RETURN FALSE;
368:

Line 392: fnd_log.string(G_LEVEL_PROCEDURE,

388:
389: BEGIN
390:
391: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
392: fnd_log.string(G_LEVEL_PROCEDURE,
393: G_MODULE_NAME||l_procedure_name||'.begin',
394: 'Beginning of procedure');
395: END IF;
396:

Line 399: fnd_log.string(G_LEVEL_STATEMENT,

395: END IF;
396:
397:
398: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
399: fnd_log.string(G_LEVEL_STATEMENT,
400: G_MODULE_NAME||l_procedure_name,
401: 'p_package_text = '||p_package_text);
402: END IF;
403:

Line 405: fnd_log.string(G_LEVEL_STATEMENT,

401: 'p_package_text = '||p_package_text);
402: END IF;
403:
404: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
405: fnd_log.string(G_LEVEL_STATEMENT,
406: G_MODULE_NAME||l_procedure_name,
407: '-> CALL APPS_DDL.apps_ddl API');
408: END IF;
409:

Line 413: fnd_log.string(G_LEVEL_PROCEDURE,

409:
410: APPS_DDL.apps_ddl(ddl_text => p_package_text);
411:
412: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
413: fnd_log.string(G_LEVEL_PROCEDURE,
414: G_MODULE_NAME||l_procedure_name||'.end',
415: 'End of procedure');
416: END IF;
417:

Line 424: fnd_log.string(G_LEVEL_STATEMENT,

420: EXCEPTION
421:
422: WHEN package_locked THEN
423: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
424: fnd_log.string(G_LEVEL_STATEMENT,
425: G_MODULE_NAME||l_procedure_name,
426: 'ERROR: XLA_CMP_PACKAGE_LOCKED');
427: END IF;
428:

Line 432: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);

428:
429: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
430: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
431: fnd_message.set_token('PACKAGE_NAME',p_package_name);
432: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
433: END IF;
434:
435: RETURN FALSE;
436:

Line 446: fnd_log.string(G_LEVEL_STATEMENT,

442: , p_package_type => p_package_type
443: );
444:
445: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
446: fnd_log.string(G_LEVEL_STATEMENT,
447: G_MODULE_NAME||l_procedure_name,
448: 'ERROR: XLA_CMP_COMPILATION_FAILED');
449: END IF;
450:

Line 454: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);

450:
451: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
452: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
453: fnd_message.set_token('PACKAGE_NAME',p_package_name);
454: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
455: END IF;
456:
457: RETURN FALSE;
458:

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

459: WHEN OTHERS THEN
460: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
461: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
462: fnd_message.set_token('ORACLE_ERR',SQLERRM);
463: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
464: END IF;
465:
466: return false;
467:

Line 496: fnd_log.string(G_LEVEL_PROCEDURE,

492:
493: BEGIN
494:
495: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
496: fnd_log.string(G_LEVEL_PROCEDURE,
497: G_MODULE_NAME||l_procedure_name||'.begin',
498: 'Beginning of procedure');
499: END IF;
500:

Line 503: fnd_log.string(G_LEVEL_STATEMENT,

499: END IF;
500:
501:
502: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
503: fnd_log.string(G_LEVEL_STATEMENT,
504: G_MODULE_NAME||l_procedure_name,
505: 'p_package_name = '||p_package_name);
506:
507: END IF;

Line 520: fnd_log.string(G_LEVEL_PROCEDURE,

516: , p_package_text => l_package_text
517: );
518:
519: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
520: fnd_log.string(G_LEVEL_PROCEDURE,
521: G_MODULE_NAME||l_procedure_name||'.end',
522: 'End of procedure');
523: END IF;
524:

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

528: WHEN OTHERS THEN
529: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
530: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
531: fnd_message.set_token('ORACLE_ERR',SQLERRM);
532: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
533: END IF;
534:
535: return false;
536:

Line 560: fnd_log.string(G_LEVEL_PROCEDURE,

556:
557: BEGIN
558:
559: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
560: fnd_log.string(G_LEVEL_PROCEDURE,
561: G_MODULE_NAME||l_procedure_name||'.begin',
562: 'Beginning of procedure');
563: END IF;
564:

Line 567: fnd_log.string(G_LEVEL_STATEMENT,

563: END IF;
564:
565: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
566:
567: fnd_log.string(G_LEVEL_STATEMENT,
568: G_MODULE_NAME||l_procedure_name,
569: 'p_package_name = '||p_package_name);
570:
571: END IF;

Line 597: fnd_log.string(G_LEVEL_STATEMENT,

593: l_created_flag := l_created_flag AND l_IsValid;
594:
595: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
596: IF l_created_flag THEN
597: fnd_log.string(G_LEVEL_STATEMENT,
598: G_MODULE_NAME||l_procedure_name,
599: 'return value. = TRUE');
600: ELSE
601: fnd_log.string(G_LEVEL_STATEMENT,

Line 601: fnd_log.string(G_LEVEL_STATEMENT,

597: fnd_log.string(G_LEVEL_STATEMENT,
598: G_MODULE_NAME||l_procedure_name,
599: 'return value. = TRUE');
600: ELSE
601: fnd_log.string(G_LEVEL_STATEMENT,
602: G_MODULE_NAME||l_procedure_name,
603: 'return value. = FALSE');
604: END IF;
605: END IF;

Line 608: fnd_log.string(G_LEVEL_PROCEDURE,

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

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

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

Line 646: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 658: fnd_log.string(G_LEVEL_STATEMENT,

654: l_sql_stmt := 'BEGIN ' || p_object_owner || '.APPS_DDL.apps_ddl( ddl_text => ''' ||
655: p_ddl_text || ''' );' || ' END;';
656:
657: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
658: fnd_log.string(G_LEVEL_STATEMENT,
659: G_MODULE_NAME||l_procedure_name,
660: l_sql_stmt);
661: END IF;
662:

Line 668: fnd_log.string(G_LEVEL_PROCEDURE,

664:
665: END IF;
666:
667: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
668: fnd_log.string(G_LEVEL_PROCEDURE,
669: G_MODULE_NAME||l_procedure_name||'.end',
670: 'End of procedure');
671: END IF;
672:

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

676: WHEN OTHERS THEN
677: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
678: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
679: fnd_message.set_token('ORACLE_ERR',SQLERRM);
680: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
681: END IF;
682:
683: return false;
684:

Line 706: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 724: fnd_log.string(G_LEVEL_PROCEDURE,

720: ,ub => l_ub
721: );
722:
723: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
724: fnd_log.string(G_LEVEL_PROCEDURE,
725: G_MODULE_NAME||l_procedure_name||'.end',
726: 'End of procedure');
727: END IF;
728:

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

734:
735: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
736: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
737: fnd_message.set_token('ORACLE_ERR',SQLERRM);
738: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
739: END IF;
740:
741: RETURN FALSE;
742:

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

744:
745: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
746: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
747: fnd_message.set_token('ORACLE_ERR',SQLERRM);
748: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
749: END IF;
750:
751: RETURN FALSE;
752:

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

754:
755: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
756: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
757: fnd_message.set_token('ORACLE_ERR',SQLERRM);
758: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
759: END IF;
760:
761: RETURN FALSE;
762:

Line 785: fnd_log.string(G_LEVEL_PROCEDURE,

781:
782: BEGIN
783:
784: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
785: fnd_log.string(G_LEVEL_PROCEDURE,
786: G_MODULE_NAME||l_procedure_name||'.begin',
787: 'Beginning of procedure');
788: END IF;
789:

Line 812: fnd_log.string(G_LEVEL_PROCEDURE,

808: ,ub => l_ub
809: );
810:
811: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
812: fnd_log.string(G_LEVEL_PROCEDURE,
813: G_MODULE_NAME||l_procedure_name||'.end',
814: 'End of procedure');
815: END IF;
816:

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

820: WHEN OTHERS THEN
821: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
822: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
823: fnd_message.set_token('ORACLE_ERR',SQLERRM);
824: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
825: END IF;
826:
827: return false;
828:

Line 858: fnd_log.string(G_LEVEL_PROCEDURE,

854:
855: BEGIN
856:
857: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
858: fnd_log.string(G_LEVEL_PROCEDURE,
859: G_MODULE_NAME||l_procedure_name||'.begin',
860: 'Beginning of procedure');
861: END IF;
862:

Line 867: fnd_log.string(G_LEVEL_STATEMENT,

863: l_return_value := TRUE;
864:
865:
866: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
867: fnd_log.string(G_LEVEL_STATEMENT,
868: G_MODULE_NAME||l_procedure_name,
869: 'DDL text size: ' || LENGTH(p_ddl_text));
870: END IF;
871:

Line 879: fnd_log.string(G_LEVEL_STATEMENT,

875: --drop the already existing one (if it exists)
876: l_additional_sql_stmt :=
877: 'DROP TABLE ' || p_object_owner || '.' || p_object_name;
878: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
879: fnd_log.string(G_LEVEL_STATEMENT,
880: G_MODULE_NAME||l_procedure_name,
881: l_additional_sql_stmt);
882: END IF;
883:

Line 920: fnd_log.string(G_LEVEL_STATEMENT,

916: p_apps_account || '.' || p_object_name ||
917: ' FOR ' || p_object_owner || '.' || p_object_name;
918:
919: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
920: fnd_log.string(G_LEVEL_STATEMENT,
921: G_MODULE_NAME||l_procedure_name,
922: l_additional_sql_stmt);
923: END IF;
924:

Line 941: fnd_log.string(G_LEVEL_STATEMENT,

937: l_additional_sql_stmt :=
938: 'ALTER PACKAGE ' || p_object_name || ' COMPILE ';
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: l_additional_sql_stmt);
944: END IF;
945:

Line 950: fnd_log.string(G_LEVEL_PROCEDURE,

946: EXECUTE IMMEDIATE l_additional_sql_stmt;
947: END IF;
948:
949: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
950: fnd_log.string(G_LEVEL_PROCEDURE,
951: G_MODULE_NAME||l_procedure_name||'.end',
952: 'End of procedure');
953: END IF;
954:

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

958: WHEN le_compilation_fails THEN
959: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
960: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
961: fnd_message.set_token('ORACLE_ERR',SQLERRM);
962: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
963: END IF;
964:
965: -- BMR: need utility like xla_cmp_common_pkg.dump_text here
966:

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

969: WHEN OTHERS THEN
970: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
971: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
972: fnd_message.set_token('ORACLE_ERR',SQLERRM);
973: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
974: END IF;
975:
976: RETURN FALSE;
977: