DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UTIL_MC_PKG

Line 2083: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_NR_MELCDL_STATUS_CODE', l_mel_cdl_status))

2079: IF (get_ue_details%FOUND)
2080: THEN
2081: l_mel_cdl_status := l_deferral_type||':'||l_approval_code;
2082:
2083: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_NR_MELCDL_STATUS_CODE', l_mel_cdl_status))
2084: THEN
2085: l_mel_cdl_status := 'OPEN';
2086: END IF;
2087: END IF;

Line 2094: AHL_UTIL_MC_PKG.Convert_To_LookupMeaning

2090: IF (p_get_code = FND_API.G_TRUE)
2091: THEN
2092: RETURN l_mel_cdl_status;
2093: ELSE
2094: AHL_UTIL_MC_PKG.Convert_To_LookupMeaning
2095: (
2096: p_lookup_type => 'AHL_NR_MELCDL_STATUS_CODE',
2097: p_lookup_code => l_mel_cdl_status,
2098: x_lookup_meaning => l_mel_cdl_status_mean,

Line 2349: AHL_UTIL_MC_PKG.Convert_To_LookupCode

2345: IF (p_x_nonroutine_rec.log_series_code IS NULL OR p_x_nonroutine_rec.log_series_code = FND_API.G_MISS_CHAR)
2346: THEN
2347: IF (p_x_nonroutine_rec.log_series_meaning IS NOT NULL AND p_x_nonroutine_rec.log_series_meaning <> FND_API.G_MISS_CHAR)
2348: THEN
2349: AHL_UTIL_MC_PKG.Convert_To_LookupCode
2350: (
2351: p_lookup_type => 'AHL_LOG_SERIES_CODE',
2352: p_lookup_meaning => p_x_nonroutine_rec.log_series_meaning,
2353: x_lookup_code => p_x_nonroutine_rec.log_series_code,

Line 2364: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_LOG_SERIES_CODE', p_x_nonroutine_rec.log_series_code))

2360: FND_MSG_PUB.ADD;
2361: END IF;
2362: END IF;
2363: ELSE
2364: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_LOG_SERIES_CODE', p_x_nonroutine_rec.log_series_code))
2365: THEN
2366: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');
2367: -- Log Series is invalid
2368: FND_MSG_PUB.ADD;

Line 2448: AHL_UTIL_MC_PKG.Convert_To_LookupCode

2444: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_MAND');
2445: -- Log Series is mandatory
2446: FND_MSG_PUB.ADD;
2447: ELSE
2448: AHL_UTIL_MC_PKG.Convert_To_LookupCode
2449: (
2450: p_lookup_type => 'AHL_LOG_SERIES_CODE',
2451: p_lookup_meaning => p_x_nonroutine_rec.log_series_meaning,
2452: x_lookup_code => p_x_nonroutine_rec.log_series_code,

Line 2463: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_LOG_SERIES_CODE', p_x_nonroutine_rec.log_series_code))

2459: FND_MSG_PUB.ADD;
2460: END IF;
2461: END IF;
2462: ELSE
2463: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_LOG_SERIES_CODE', p_x_nonroutine_rec.log_series_code))
2464: THEN
2465: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');
2466: -- Log Series is invalid
2467: FND_MSG_PUB.ADD;

Line 2513: AHL_UTIL_MC_PKG.Convert_To_LookupCode

2509: IF (p_x_nonroutine_rec.mel_cdl_type_code IS NULL OR p_x_nonroutine_rec.mel_cdl_type_code = FND_API.G_MISS_CHAR)
2510: THEN
2511: IF (p_x_nonroutine_rec.mel_cdl_type_meaning IS NOT NULL AND p_x_nonroutine_rec.mel_cdl_type_meaning <> FND_API.G_MISS_CHAR)
2512: THEN
2513: AHL_UTIL_MC_PKG.Convert_To_LookupCode
2514: (
2515: p_lookup_type => 'AHL_MEL_CDL_TYPE',
2516: p_lookup_meaning => p_x_nonroutine_rec.mel_cdl_type_meaning,
2517: x_lookup_code => p_x_nonroutine_rec.mel_cdl_type_code,

Line 2528: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_MEL_CDL_TYPE', p_x_nonroutine_rec.mel_cdl_type_code))

2524: FND_MSG_PUB.ADD;
2525: END IF;
2526: END IF;
2527: ELSE
2528: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_MEL_CDL_TYPE', p_x_nonroutine_rec.mel_cdl_type_code))
2529: THEN
2530: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_TYPE_INV');
2531: -- Position ATA is invalid
2532: FND_MSG_PUB.ADD;

Line 2541: AHL_UTIL_MC_PKG.Convert_To_LookupCode

2537: IF (p_x_nonroutine_rec.ata_code IS NULL OR p_x_nonroutine_rec.ata_code = FND_API.G_MISS_CHAR)
2538: THEN
2539: IF (p_x_nonroutine_rec.ata_meaning IS NOT NULL AND p_x_nonroutine_rec.ata_meaning <> FND_API.G_MISS_CHAR)
2540: THEN
2541: AHL_UTIL_MC_PKG.Convert_To_LookupCode
2542: (
2543: p_lookup_type => 'AHL_ATA_CODE',
2544: p_lookup_meaning => p_x_nonroutine_rec.ata_meaning,
2545: x_lookup_code => p_x_nonroutine_rec.ata_code,

Line 2556: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_ATA_CODE', p_x_nonroutine_rec.ata_code))

2552: FND_MSG_PUB.ADD;
2553: END IF;
2554: END IF;
2555: ELSE
2556: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_ATA_CODE', p_x_nonroutine_rec.ata_code))
2557: THEN
2558: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ATA_INV');
2559: -- Position ATA is invalid
2560: FND_MSG_PUB.ADD;