DBA Data[Home] [Help]

APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on FND_LOG

Line 68: IF(Fnd_Log.level_statement >= Fnd_Log.g_current_runtime_level) THEN

64: BEGIN
65:
66: Fnd_File.PUT_LINE(Fnd_File.LOG, p_message);
67:
68: IF(Fnd_Log.level_statement >= Fnd_Log.g_current_runtime_level) THEN
69: Fnd_Log.string(Fnd_Log.level_statement, 'okl_internal_to_external', p_message);
70: END IF;
71:
72: Okl_Debug_Pub.logmessage(p_message);

Line 69: Fnd_Log.string(Fnd_Log.level_statement, 'okl_internal_to_external', p_message);

65:
66: Fnd_File.PUT_LINE(Fnd_File.LOG, p_message);
67:
68: IF(Fnd_Log.level_statement >= Fnd_Log.g_current_runtime_level) THEN
69: Fnd_Log.string(Fnd_Log.level_statement, 'okl_internal_to_external', p_message);
70: END IF;
71:
72: Okl_Debug_Pub.logmessage(p_message);
73: --dbms_output.put_line(p_message);

Line 174: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

170: --d_esdv_rec Okl_Esd_Pvt.esdv_rec_type;
171:
172: BEGIN
173:
174: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
175: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_internal_to_external'
176: ,'Begin(+)');
177: END IF;
178:

Line 175: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_internal_to_external'

171:
172: BEGIN
173:
174: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
175: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_internal_to_external'
176: ,'Begin(+)');
177: END IF;
178:
179: -- ------------------------

Line 446: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

442: l_xlstl_cnt := 0;
443: l_esdtl_cnt := 0;
444: l_tai_id_cnt := 0;
445:
446: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
447: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_internal_to_external','End(-)');
448: END IF;
449:
450: Okl_Api.END_ACTIVITY (

Line 447: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_internal_to_external','End(-)');

443: l_esdtl_cnt := 0;
444: l_tai_id_cnt := 0;
445:
446: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
447: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_internal_to_external','End(-)');
448: END IF;
449:
450: Okl_Api.END_ACTIVITY (
451: x_msg_count => x_msg_count,

Line 463: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

459:
460: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
461: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
462:
463: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
464: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
465: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
466: END IF;
467:

Line 464: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',

460: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
461: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
462:
463: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
464: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
465: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
466: END IF;
467:
468: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 479: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

475:
476: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
478:
479: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
480: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
481: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
482: END IF;
483:

Line 480: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',

476: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
478:
479: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
480: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
481: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
482: END IF;
483:
484: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 495: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

491:
492: WHEN OTHERS THEN
493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
494:
495: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
496: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
497: 'EXCEPTION :'||'OTHERS');
498: END IF;
499:

Line 496: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',

492: WHEN OTHERS THEN
493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
494:
495: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
496: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
497: 'EXCEPTION :'||'OTHERS');
498: END IF;
499:
500: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 974: IF(Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN

970: x_return_status => l_return_status);
971:
972: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
973:
974: IF(Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
975: Fnd_Log.string(Fnd_Log.level_procedure, 'process_ie_tbl', 'Begin(+)');
976: END IF;
977:
978: -- ------------------------

Line 975: Fnd_Log.string(Fnd_Log.level_procedure, 'process_ie_tbl', 'Begin(+)');

971:
972: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
973:
974: IF(Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
975: Fnd_Log.string(Fnd_Log.level_procedure, 'process_ie_tbl', 'Begin(+)');
976: END IF;
977:
978: -- ------------------------
979: -- Print Input variables

Line 1633: l_level_procedure := fnd_log.level_procedure;

1629:
1630: -- Start of wraper code generated automatically by Debug code generator for Okl_Ext_Sell_Invs_Pub.INSERT_EXT_SELL_INVS
1631: /*
1632: IF(l_debug_enabled = 'Y') THEN
1633: l_level_procedure := fnd_log.level_procedure;
1634: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module, l_level_procedure);
1635: END IF;
1636:
1637: IF(is_debug_procedure_on) THEN

Line 3204: IF(fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

3200: fnd_msg_pub.GET(p_msg_index => i, p_encoded => 'F', p_data => lx_msg_data, p_msg_index_out => l_msg_index_out);
3201:
3202: fnd_file.PUT_LINE(fnd_file.OUTPUT, to_char(i) || ': ' || lx_msg_data);
3203:
3204: IF(fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3205: fnd_log.string(fnd_log.level_exception, 'okl_internal_to_external', to_char(i) || ': ' || lx_msg_data);
3206: END IF;
3207:
3208: END LOOP;

Line 3205: fnd_log.string(fnd_log.level_exception, 'okl_internal_to_external', to_char(i) || ': ' || lx_msg_data);

3201:
3202: fnd_file.PUT_LINE(fnd_file.OUTPUT, to_char(i) || ': ' || lx_msg_data);
3203:
3204: IF(fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3205: fnd_log.string(fnd_log.level_exception, 'okl_internal_to_external', to_char(i) || ': ' || lx_msg_data);
3206: END IF;
3207:
3208: END LOOP;
3209: END IF;

Line 3211: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3207:
3208: END LOOP;
3209: END IF;
3210:
3211: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3212: fnd_log.string(fnd_log.level_procedure, 'okl_internal_to_external', 'End(-)');
3213: END IF;
3214:
3215: ------------------------------------------------------------

Line 3212: fnd_log.string(fnd_log.level_procedure, 'okl_internal_to_external', 'End(-)');

3208: END LOOP;
3209: END IF;
3210:
3211: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3212: fnd_log.string(fnd_log.level_procedure, 'okl_internal_to_external', 'End(-)');
3213: END IF;
3214:
3215: ------------------------------------------------------------
3216: -- End processing

Line 3224: IF(Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN

3220:
3221: EXCEPTION
3222: WHEN OTHERS THEN
3223:
3224: IF(Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
3225: Fnd_Log.string(Fnd_Log.level_exception, 'okl_internal_to_external', 'EXCEPTION :' || 'OTHERS');
3226: END IF;
3227:
3228: print_to_log('*=> Error Message(O1): ' || SQLERRM);

Line 3225: Fnd_Log.string(Fnd_Log.level_exception, 'okl_internal_to_external', 'EXCEPTION :' || 'OTHERS');

3221: EXCEPTION
3222: WHEN OTHERS THEN
3223:
3224: IF(Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
3225: Fnd_Log.string(Fnd_Log.level_exception, 'okl_internal_to_external', 'EXCEPTION :' || 'OTHERS');
3226: END IF;
3227:
3228: print_to_log('*=> Error Message(O1): ' || SQLERRM);
3229:

Line 3733: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

3729: p_msg_index_out => l_msg_index_out);
3730:
3731: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
3732:
3733: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3734: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3735: TO_CHAR(i) || ': ' || lx_msg_data);
3736: END IF;
3737:

Line 3734: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',

3730:
3731: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
3732:
3733: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3734: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3735: TO_CHAR(i) || ': ' || lx_msg_data);
3736: END IF;
3737:
3738: END LOOP;

Line 3780: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

3776: WHERE assigned_process = p_assigned_process;
3777: COMMIT;
3778: END IF;
3779:
3780: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3781: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3782: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3783: END IF;
3784:

Line 3781: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',

3777: COMMIT;
3778: END IF;
3779:
3780: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3781: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3782: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3783: END IF;
3784:
3785: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 3802: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

3798: WHERE assigned_process = p_assigned_process;
3799: COMMIT;
3800: END IF;
3801:
3802: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3803: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3804: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3805: END IF;
3806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 3803: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',

3799: COMMIT;
3800: END IF;
3801:
3802: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3803: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3804: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3805: END IF;
3806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3807: p_api_name => l_api_name,

Line 3823: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

3819: WHERE assigned_process = p_assigned_process;
3820: COMMIT;
3821: END IF;
3822:
3823: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3824: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3825: 'EXCEPTION :'||'OTHERS');
3826: END IF;
3827: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 3824: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',

3820: COMMIT;
3821: END IF;
3822:
3823: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3824: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3825: 'EXCEPTION :'||'OTHERS');
3826: END IF;
3827: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3828: p_api_name => l_api_name,