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 74: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 86: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 96: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 105: fnd_log.string(G_LEVEL_PROCEDURE,

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

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

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

Line 146: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 158: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 162: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 166: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 170: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 174: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 178: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 190: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 198: fnd_log.string(G_LEVEL_PROCEDURE,

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

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

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

Line 232: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 253: fnd_log.string(G_LEVEL_PROCEDURE,

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

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

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

Line 295: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 311: fnd_log.string(G_LEVEL_STATEMENT,

307: --
308:
309:
310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
311: fnd_log.string(G_LEVEL_STATEMENT,
312: G_MODULE_NAME||l_procedure_name,
313: '-> CALL APPS_ARRAY_DDL.apps_array_ddl API');
314: END IF;
315:

Line 322: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 333: fnd_log.string(G_LEVEL_STATEMENT,

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

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

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

Line 349: fnd_log.string(G_LEVEL_STATEMENT,

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

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

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

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

363: WHEN OTHERS THEN
364: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
365: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
366: fnd_message.set_token('ORACLE_ERR',SQLERRM);
367: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
368: END IF;
369:
370: RETURN FALSE;
371:

Line 395: fnd_log.string(G_LEVEL_PROCEDURE,

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

Line 402: fnd_log.string(G_LEVEL_STATEMENT,

398: END IF;
399:
400:
401: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
402: fnd_log.string(G_LEVEL_STATEMENT,
403: G_MODULE_NAME||l_procedure_name,
404: 'p_packgae_text = '||p_package_text);
405: END IF;
406:

Line 408: fnd_log.string(G_LEVEL_STATEMENT,

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

Line 423: fnd_log.string(G_LEVEL_PROCEDURE,

419:
420: */
421:
422: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
423: fnd_log.string(G_LEVEL_PROCEDURE,
424: G_MODULE_NAME||l_procedure_name||'.end',
425: 'End of procedure');
426: END IF;
427:

Line 434: fnd_log.string(G_LEVEL_STATEMENT,

430: EXCEPTION
431:
432: WHEN package_locked THEN
433: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
434: fnd_log.string(G_LEVEL_STATEMENT,
435: G_MODULE_NAME||l_procedure_name,
436: 'ERROR: XLA_CMP_PACKAGE_LOCKED');
437: END IF;
438:

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

438:
439: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
440: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
441: fnd_message.set_token('PACKAGE_NAME',p_package_name);
442: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
443: END IF;
444:
445: RETURN FALSE;
446:

Line 456: fnd_log.string(G_LEVEL_STATEMENT,

452: , p_package_type => p_package_type
453: );
454:
455: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
456: fnd_log.string(G_LEVEL_STATEMENT,
457: G_MODULE_NAME||l_procedure_name,
458: 'ERROR: XLA_CMP_COMPILATION_FAILED');
459: END IF;
460:

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

460:
461: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
462: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
463: fnd_message.set_token('PACKAGE_NAME',p_package_name);
464: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
465: END IF;
466:
467: RETURN FALSE;
468:

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

470: WHEN OTHERS THEN
471: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
472: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
473: fnd_message.set_token('ORACLE_ERR',SQLERRM);
474: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
475: END IF;
476:
477: return false;
478:

Line 507: fnd_log.string(G_LEVEL_PROCEDURE,

503:
504: BEGIN
505:
506: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: fnd_log.string(G_LEVEL_PROCEDURE,
508: G_MODULE_NAME||l_procedure_name||'.begin',
509: 'Beginning of procedure');
510: END IF;
511:

Line 514: fnd_log.string(G_LEVEL_STATEMENT,

510: END IF;
511:
512:
513: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
514: fnd_log.string(G_LEVEL_STATEMENT,
515: G_MODULE_NAME||l_procedure_name,
516: 'p_package_name = '||p_package_name);
517:
518: END IF;

Line 531: fnd_log.string(G_LEVEL_PROCEDURE,

527: , p_package_text => l_package_text
528: );
529:
530: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
531: fnd_log.string(G_LEVEL_PROCEDURE,
532: G_MODULE_NAME||l_procedure_name||'.end',
533: 'End of procedure');
534: END IF;
535:

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

539: WHEN OTHERS THEN
540: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
541: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
542: fnd_message.set_token('ORACLE_ERR',SQLERRM);
543: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
544: END IF;
545:
546: return false;
547:

Line 571: fnd_log.string(G_LEVEL_PROCEDURE,

567:
568: BEGIN
569:
570: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
571: fnd_log.string(G_LEVEL_PROCEDURE,
572: G_MODULE_NAME||l_procedure_name||'.begin',
573: 'Beginning of procedure');
574: END IF;
575:

Line 578: fnd_log.string(G_LEVEL_STATEMENT,

574: END IF;
575:
576: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
577:
578: fnd_log.string(G_LEVEL_STATEMENT,
579: G_MODULE_NAME||l_procedure_name,
580: 'p_package_name = '||p_package_name);
581:
582: END IF;

Line 608: fnd_log.string(G_LEVEL_STATEMENT,

604: l_created_flag := l_created_flag AND l_IsValid;
605:
606: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
607: IF l_created_flag THEN
608: fnd_log.string(G_LEVEL_STATEMENT,
609: G_MODULE_NAME||l_procedure_name,
610: 'return value. = TRUE');
611: ELSE
612: fnd_log.string(G_LEVEL_STATEMENT,

Line 612: fnd_log.string(G_LEVEL_STATEMENT,

608: fnd_log.string(G_LEVEL_STATEMENT,
609: G_MODULE_NAME||l_procedure_name,
610: 'return value. = TRUE');
611: ELSE
612: fnd_log.string(G_LEVEL_STATEMENT,
613: G_MODULE_NAME||l_procedure_name,
614: 'return value. = FALSE');
615: END IF;
616: END IF;

Line 619: fnd_log.string(G_LEVEL_PROCEDURE,

615: END IF;
616: END IF;
617:
618: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
619: fnd_log.string(G_LEVEL_PROCEDURE,
620: G_MODULE_NAME||l_procedure_name||'.end',
621: 'End of procedure');
622: END IF;
623:

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

627: WHEN OTHERS THEN
628: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
629: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
630: fnd_message.set_token('ORACLE_ERR',SQLERRM);
631: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
632: END IF;
633:
634: return false;
635:

Line 657: fnd_log.string(G_LEVEL_PROCEDURE,

653:
654: BEGIN
655:
656: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
657: fnd_log.string(G_LEVEL_PROCEDURE,
658: G_MODULE_NAME||l_procedure_name||'.begin',
659: 'Beginning of procedure');
660: END IF;
661:

Line 669: fnd_log.string(G_LEVEL_STATEMENT,

665: l_sql_stmt := 'BEGIN ' || p_object_owner || '.APPS_DDL.apps_ddl( ddl_text => ''' ||
666: p_ddl_text || ''' );' || ' END;';
667:
668: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
669: fnd_log.string(G_LEVEL_STATEMENT,
670: G_MODULE_NAME||l_procedure_name,
671: l_sql_stmt);
672: END IF;
673:

Line 679: fnd_log.string(G_LEVEL_PROCEDURE,

675:
676: END IF;
677:
678: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
679: fnd_log.string(G_LEVEL_PROCEDURE,
680: G_MODULE_NAME||l_procedure_name||'.end',
681: 'End of procedure');
682: END IF;
683:

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

687: WHEN OTHERS THEN
688: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
689: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
690: fnd_message.set_token('ORACLE_ERR',SQLERRM);
691: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
692: END IF;
693:
694: return false;
695:

Line 717: fnd_log.string(G_LEVEL_PROCEDURE,

713:
714: BEGIN
715:
716: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
717: fnd_log.string(G_LEVEL_PROCEDURE,
718: G_MODULE_NAME||l_procedure_name||'.begin',
719: 'Beginning of procedure');
720: END IF;
721:

Line 736: fnd_log.string(G_LEVEL_PROCEDURE,

732: ,ub => l_ub
733: );
734:
735: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
736: fnd_log.string(G_LEVEL_PROCEDURE,
737: G_MODULE_NAME||l_procedure_name||'.end',
738: 'End of procedure');
739: END IF;
740:

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

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

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

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

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

766:
767: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
768: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
769: fnd_message.set_token('ORACLE_ERR',SQLERRM);
770: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
771: END IF;
772:
773: RETURN FALSE;
774:

Line 797: fnd_log.string(G_LEVEL_PROCEDURE,

793:
794: BEGIN
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||'.begin',
799: 'Beginning of procedure');
800: END IF;
801:

Line 824: fnd_log.string(G_LEVEL_PROCEDURE,

820: ,ub => l_ub
821: );
822:
823: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
824: fnd_log.string(G_LEVEL_PROCEDURE,
825: G_MODULE_NAME||l_procedure_name||'.end',
826: 'End of procedure');
827: END IF;
828:

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

832: WHEN OTHERS THEN
833: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
834: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
835: fnd_message.set_token('ORACLE_ERR',SQLERRM);
836: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
837: END IF;
838:
839: return false;
840:

Line 870: fnd_log.string(G_LEVEL_PROCEDURE,

866:
867: BEGIN
868:
869: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
870: fnd_log.string(G_LEVEL_PROCEDURE,
871: G_MODULE_NAME||l_procedure_name||'.begin',
872: 'Beginning of procedure');
873: END IF;
874:

Line 879: fnd_log.string(G_LEVEL_STATEMENT,

875: l_return_value := TRUE;
876:
877:
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: 'DDL text size: ' || LENGTH(p_ddl_text));
882: END IF;
883:

Line 891: fnd_log.string(G_LEVEL_STATEMENT,

887: --drop the already existing one (if it exists)
888: l_additional_sql_stmt :=
889: 'DROP TABLE ' || p_object_owner || '.' || p_object_name;
890: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
891: fnd_log.string(G_LEVEL_STATEMENT,
892: G_MODULE_NAME||l_procedure_name,
893: l_additional_sql_stmt);
894: END IF;
895:

Line 932: fnd_log.string(G_LEVEL_STATEMENT,

928: p_apps_account || '.' || p_object_name ||
929: ' FOR ' || p_object_owner || '.' || p_object_name;
930:
931: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
932: fnd_log.string(G_LEVEL_STATEMENT,
933: G_MODULE_NAME||l_procedure_name,
934: l_additional_sql_stmt);
935: END IF;
936:

Line 953: fnd_log.string(G_LEVEL_STATEMENT,

949: l_additional_sql_stmt :=
950: 'ALTER PACKAGE ' || p_object_name || ' COMPILE ';
951:
952: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
953: fnd_log.string(G_LEVEL_STATEMENT,
954: G_MODULE_NAME||l_procedure_name,
955: l_additional_sql_stmt);
956: END IF;
957:

Line 962: fnd_log.string(G_LEVEL_PROCEDURE,

958: EXECUTE IMMEDIATE l_additional_sql_stmt;
959: END IF;
960:
961: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
962: fnd_log.string(G_LEVEL_PROCEDURE,
963: G_MODULE_NAME||l_procedure_name||'.end',
964: 'End of procedure');
965: END IF;
966:

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

970: WHEN le_compilation_fails THEN
971: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
972: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
973: fnd_message.set_token('ORACLE_ERR',SQLERRM);
974: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
975: END IF;
976:
977: -- BMR: need utility like xla_cmp_common_pkg.dump_text here
978:

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

981: WHEN OTHERS THEN
982: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
983: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
984: fnd_message.set_token('ORACLE_ERR',SQLERRM);
985: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
986: END IF;
987:
988: RETURN FALSE;
989: