DBA Data[Home] [Help]

APPS.AHL_FMP_PVT dependencies on FND_LOG

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

2577: FROM AHL_MC_PATH_POSITIONS
2578: WHERE PATH_POSITION_ID = c_path_position_id;
2579:
2580: BEGIN
2581: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2582: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin',
2583: 'At the start of PLSQL function. p_instance_id = ' || p_instance_id ||
2584: ', p_path_position_id = ' || p_path_position_id);
2585: END IF;

Line 2582: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin',

2578: WHERE PATH_POSITION_ID = c_path_position_id;
2579:
2580: BEGIN
2581: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2582: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin',
2583: 'At the start of PLSQL function. p_instance_id = ' || p_instance_id ||
2584: ', p_path_position_id = ' || p_path_position_id);
2585: END IF;
2586:

Line 2634: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2630: CLOSE get_last_uc_rec_csr;
2631:
2632: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
2633:
2634: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2635: fnd_log.string(fnd_log.level_statement, l_full_name,
2636: 'l_path_tbl.COUNT = ' || l_path_tbl.COUNT);
2637: END IF;
2638: -- Now use the contents of l_path_tbl to create the encoded path

Line 2635: fnd_log.string(fnd_log.level_statement, l_full_name,

2631:
2632: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
2633:
2634: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2635: fnd_log.string(fnd_log.level_statement, l_full_name,
2636: 'l_path_tbl.COUNT = ' || l_path_tbl.COUNT);
2637: END IF;
2638: -- Now use the contents of l_path_tbl to create the encoded path
2639: IF (l_path_tbl.COUNT > 0) THEN

Line 2654: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2650: OPEN get_encoded_path_csr(c_path_position_id => p_path_position_id);
2651: FETCH get_encoded_path_csr INTO l_input_encoded_path;
2652: CLOSE get_encoded_path_csr;
2653:
2654: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2655: fnd_log.string(fnd_log.level_statement, l_full_name,
2656: 'l_inst_encoded_path = ' || l_inst_encoded_path ||
2657: ', l_input_encoded_path = ' || l_input_encoded_path);
2658: END IF;

Line 2655: fnd_log.string(fnd_log.level_statement, l_full_name,

2651: FETCH get_encoded_path_csr INTO l_input_encoded_path;
2652: CLOSE get_encoded_path_csr;
2653:
2654: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2655: fnd_log.string(fnd_log.level_statement, l_full_name,
2656: 'l_inst_encoded_path = ' || l_inst_encoded_path ||
2657: ', l_input_encoded_path = ' || l_input_encoded_path);
2658: END IF;
2659:

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

2661: IF (l_inst_encoded_path LIKE '%' || l_input_encoded_path) THEN
2662: l_return_value := 'T';
2663: END IF;
2664:
2665: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2666: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end',
2667: 'At the end of PLSQL function. About to return ' || l_return_value);
2668: END IF;
2669: RETURN l_return_value;

Line 2666: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end',

2662: l_return_value := 'T';
2663: END IF;
2664:
2665: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2666: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end',
2667: 'At the end of PLSQL function. About to return ' || l_return_value);
2668: END IF;
2669: RETURN l_return_value;
2670: END;