12: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
13: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
14:
15: PROCEDURE Check_lookup_name_Or_Id
16: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
17: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
18: p_meaning IN FND_LOOKUPS.meaning%TYPE,
19: p_check_id_flag IN VARCHAR2,
20: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
13: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
14:
15: PROCEDURE Check_lookup_name_Or_Id
16: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
17: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
18: p_meaning IN FND_LOOKUPS.meaning%TYPE,
19: p_check_id_flag IN VARCHAR2,
20: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
21: x_return_status OUT NOCOPY VARCHAR2)
14:
15: PROCEDURE Check_lookup_name_Or_Id
16: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
17: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
18: p_meaning IN FND_LOOKUPS.meaning%TYPE,
19: p_check_id_flag IN VARCHAR2,
20: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
21: x_return_status OUT NOCOPY VARCHAR2)
22: IS
16: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
17: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
18: p_meaning IN FND_LOOKUPS.meaning%TYPE,
19: p_check_id_flag IN VARCHAR2,
20: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
21: x_return_status OUT NOCOPY VARCHAR2)
22: IS
23: BEGIN
24: IF (p_lookup_code IS NOT NULL) THEN