153:
154: BEGIN
155:
156: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
157: fnd_log.string(G_LEVEL_PROCEDURE,
158: G_MODULE_NAME||l_procedure_name||''.begin'',
159: ''Beginning of procedure'');
160: END IF;
161:
615:
616: BEGIN
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||''.begin'',
621: ''Beginning of procedure'');
622: END IF;
623:
804:
805: BEGIN
806:
807: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
808: fnd_log.string(G_LEVEL_PROCEDURE,
809: G_MODULE_NAME||l_procedure_name||''.begin'',
810: ''Beginning of procedure'');
811: END IF;
812:
895: C_PRIVATE_API_3 CONSTANT VARCHAR2(32000) := '
896: --
897:
898: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
899: fnd_log.string(G_LEVEL_PROCEDURE,
900: G_MODULE_NAME||l_procedure_name||''.end'',
901: ''End of procedure'');
902: END IF;
903:
905: WHEN others THEN
906: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
907: fnd_message.set_name(''OFA'',''FA_SHARED_ORACLE_ERR'');
908: fnd_message.set_token(''ORACLE_ERR'',SQLERRM);
909: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
910: END IF;
911: raise;
912:
913: END load_generated_ccids;
931: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
932:
933: g_log_level_rec fa_api_types.log_level_rec_type;
934:
935: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
936:
937: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
938: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
939: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
933: g_log_level_rec fa_api_types.log_level_rec_type;
934:
935: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
936:
937: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
938: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
939: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
940: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
941: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
934:
935: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
936:
937: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
938: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
939: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
940: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
941: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
942: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
935: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
936:
937: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
938: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
939: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
940: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
941: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
942: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
943:
936:
937: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
938: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
939: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
940: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
941: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
942: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
943:
944: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
937: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
938: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
939: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
940: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
941: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
942: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
943:
944: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
945:
938: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
939: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
940: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
941: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
942: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
943:
944: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
945:
946: FUNCTION GenerateCcidExtract
954:
955: BEGIN
956:
957: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
958: fnd_log.string(G_LEVEL_PROCEDURE,
959: G_MODULE_NAME||l_procedure_name||'.begin',
960: 'Beginning of procedure');
961: END IF;
962:
1015: WHEN OTHERS THEN
1016: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1017: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1018: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1019: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1020: END IF;
1021: RETURN FALSE;
1022:
1023: END GenerateCcidExtract;