DBA Data[Home] [Help]

APPS.AHL_FMP_PVT dependencies on FND_LOG

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

3320: FROM AHL_MC_PATH_POSITIONS
3321: WHERE PATH_POSITION_ID = c_path_position_id;
3322:
3323: BEGIN
3324: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3325: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin',
3326: 'At the start of PLSQL function. p_instance_id = ' || p_instance_id ||
3327: ', p_path_position_id = ' || p_path_position_id);
3328: END IF;

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

3321: WHERE PATH_POSITION_ID = c_path_position_id;
3322:
3323: BEGIN
3324: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3325: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin',
3326: 'At the start of PLSQL function. p_instance_id = ' || p_instance_id ||
3327: ', p_path_position_id = ' || p_path_position_id);
3328: END IF;
3329:

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

3373: CLOSE get_last_uc_rec_csr;
3374:
3375: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
3376:
3377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3378: fnd_log.string(fnd_log.level_statement, l_full_name,
3379: 'l_path_tbl.COUNT = ' || l_path_tbl.COUNT);
3380: END IF;
3381: -- Now use the contents of l_path_tbl to create the encoded path

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

3374:
3375: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
3376:
3377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3378: fnd_log.string(fnd_log.level_statement, l_full_name,
3379: 'l_path_tbl.COUNT = ' || l_path_tbl.COUNT);
3380: END IF;
3381: -- Now use the contents of l_path_tbl to create the encoded path
3382: IF (l_path_tbl.COUNT > 0) THEN

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

3393: OPEN get_encoded_path_csr(c_path_position_id => p_path_position_id);
3394: FETCH get_encoded_path_csr INTO l_input_encoded_path;
3395: CLOSE get_encoded_path_csr;
3396:
3397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3398: fnd_log.string(fnd_log.level_statement, l_full_name,
3399: 'l_inst_encoded_path = ' || l_inst_encoded_path ||
3400: ', l_input_encoded_path = ' || l_input_encoded_path);
3401: END IF;

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

3394: FETCH get_encoded_path_csr INTO l_input_encoded_path;
3395: CLOSE get_encoded_path_csr;
3396:
3397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3398: fnd_log.string(fnd_log.level_statement, l_full_name,
3399: 'l_inst_encoded_path = ' || l_inst_encoded_path ||
3400: ', l_input_encoded_path = ' || l_input_encoded_path);
3401: END IF;
3402:

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

3404: IF (l_inst_encoded_path LIKE '%' || l_input_encoded_path) THEN
3405: l_return_value := 'T';
3406: END IF;
3407:
3408: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3409: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end',
3410: 'At the end of PLSQL function. About to return ' || l_return_value);
3411: END IF;
3412: RETURN l_return_value;

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

3405: l_return_value := 'T';
3406: END IF;
3407:
3408: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3409: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end',
3410: 'At the end of PLSQL function. About to return ' || l_return_value);
3411: END IF;
3412: RETURN l_return_value;
3413: END;