DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on OKL_DEBUG_PUB

Line 960: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

956:
957: -- vsgandhi : 07-Feb-2013
958: -- start
959: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'version_contract';
960: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
961: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
962: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
963: -- end
964:

Line 961: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

957: -- vsgandhi : 07-Feb-2013
958: -- start
959: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'version_contract';
960: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
961: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
962: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
963: -- end
964:
965: BEGIN

Line 962: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

958: -- start
959: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'version_contract';
960: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
961: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
962: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
963: -- end
964:
965: BEGIN
966:

Line 969: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

965: BEGIN
966:
967:
968: IF (is_debug_procedure_on) THEN
969: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
970: END IF;
971:
972: x_return_status := OKC_API.G_RET_STS_SUCCESS;
973: -- Call start_activity to create savepoint, check compatibility

Line 991: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Before the call');

987: -- to OKC declared cvmv record type as process of input
988: migrate_version(p_cvmv_rec,
989: lr_cvmv_rec_type_in);
990: IF (is_debug_statement_on) THEN
991: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Before the call');
992: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.object_version_number := ' || lr_cvmv_rec_type_in.object_version_number);
993: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.major_version := ' || lr_cvmv_rec_type_in.major_version);
994: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.minor_version := ' || lr_cvmv_rec_type_in.minor_version);
995: END IF;

Line 992: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.object_version_number := ' || lr_cvmv_rec_type_in.object_version_number);

988: migrate_version(p_cvmv_rec,
989: lr_cvmv_rec_type_in);
990: IF (is_debug_statement_on) THEN
991: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Before the call');
992: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.object_version_number := ' || lr_cvmv_rec_type_in.object_version_number);
993: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.major_version := ' || lr_cvmv_rec_type_in.major_version);
994: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.minor_version := ' || lr_cvmv_rec_type_in.minor_version);
995: END IF;
996:

Line 993: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.major_version := ' || lr_cvmv_rec_type_in.major_version);

989: lr_cvmv_rec_type_in);
990: IF (is_debug_statement_on) THEN
991: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Before the call');
992: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.object_version_number := ' || lr_cvmv_rec_type_in.object_version_number);
993: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.major_version := ' || lr_cvmv_rec_type_in.major_version);
994: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.minor_version := ' || lr_cvmv_rec_type_in.minor_version);
995: END IF;
996:
997: -- Calling the actual OKC api

Line 994: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.minor_version := ' || lr_cvmv_rec_type_in.minor_version);

990: IF (is_debug_statement_on) THEN
991: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Before the call');
992: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.object_version_number := ' || lr_cvmv_rec_type_in.object_version_number);
993: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.major_version := ' || lr_cvmv_rec_type_in.major_version);
994: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lr_cvmv_rec_type_in.minor_version := ' || lr_cvmv_rec_type_in.minor_version);
995: END IF;
996:
997: -- Calling the actual OKC api
998: OKC_VERSION_PUB.version_contract(p_api_version => p_api_version,

Line 1015: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'After the call');

1011: RAISE OKC_API.G_EXCEPTION_ERROR;
1012: END IF;
1013:
1014: IF (is_debug_statement_on) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'After the call');
1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'object_version_number := ' || lr_cvmv_rec_type_out.object_version_number);
1017: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'major_version := ' || lr_cvmv_rec_type_out.major_version);
1018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'minor_version := ' || lr_cvmv_rec_type_out.minor_version);
1019: END IF;

Line 1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'object_version_number := ' || lr_cvmv_rec_type_out.object_version_number);

1012: END IF;
1013:
1014: IF (is_debug_statement_on) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'After the call');
1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'object_version_number := ' || lr_cvmv_rec_type_out.object_version_number);
1017: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'major_version := ' || lr_cvmv_rec_type_out.major_version);
1018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'minor_version := ' || lr_cvmv_rec_type_out.minor_version);
1019: END IF;
1020:

Line 1017: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'major_version := ' || lr_cvmv_rec_type_out.major_version);

1013:
1014: IF (is_debug_statement_on) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'After the call');
1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'object_version_number := ' || lr_cvmv_rec_type_out.object_version_number);
1017: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'major_version := ' || lr_cvmv_rec_type_out.major_version);
1018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'minor_version := ' || lr_cvmv_rec_type_out.minor_version);
1019: END IF;
1020:
1021: -- Since we are creatieng a wrapper over the okc

Line 1018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'minor_version := ' || lr_cvmv_rec_type_out.minor_version);

1014: IF (is_debug_statement_on) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'After the call');
1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'object_version_number := ' || lr_cvmv_rec_type_out.object_version_number);
1017: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'major_version := ' || lr_cvmv_rec_type_out.major_version);
1018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'minor_version := ' || lr_cvmv_rec_type_out.minor_version);
1019: END IF;
1020:
1021: -- Since we are creatieng a wrapper over the okc
1022: -- we need to migrate from OKC declared cimv record type

Line 1031: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :' || 'Exception error');

1027: x_msg_data );
1028: EXCEPTION
1029: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1030: IF (is_debug_exception_on) THEN
1031: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :' || 'Exception error');
1032: END IF;
1033: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1034: l_api_name,
1035: G_PKG_NAME,

Line 1042: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'Unexpected Error');

1038: x_msg_data,
1039: '_PVT');
1040: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1041: IF (is_debug_exception_on) THEN
1042: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'Unexpected Error');
1043: END IF;
1044: x_return_status :=OKC_API.HANDLE_EXCEPTIONS(
1045: l_api_name,
1046: G_PKG_NAME,

Line 1054: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

1050: '_PVT');
1051: WHEN OTHERS THEN
1052:
1053: IF (is_debug_exception_on) THEN
1054: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1055: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1056: END IF;
1057:
1058: x_return_status :=OKC_API.HANDLE_EXCEPTIONS(