DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PUB dependencies on AHL_UTIL_MC_PKG

Line 120: IF NOT AHL_UTIL_MC_PKG.VALIDATE_LOOKUP_CODE(P_LOOKUP_TYPE => 'AHL_ITEMGROUP_TYPE',

116: END IF;
117:
118: IF l_item_group_rec.OPERATION_FLAG <> 'D' THEN
119: IF l_item_group_rec.type_code IS NOT NULL THEN
120: IF NOT AHL_UTIL_MC_PKG.VALIDATE_LOOKUP_CODE(P_LOOKUP_TYPE => 'AHL_ITEMGROUP_TYPE',
121: P_LOOKUP_CODE =>l_item_group_rec.type_code) THEN
122: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_INAVLID');
123: FND_MSG_PUB.ADD;
124: END IF;

Line 126: AHL_UTIL_MC_PKG.CONVERT_TO_LOOKUPCODE(

122: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_INAVLID');
123: FND_MSG_PUB.ADD;
124: END IF;
125: ELSIF l_item_group_rec.type_meaning IS NOT NULL THEN
126: AHL_UTIL_MC_PKG.CONVERT_TO_LOOKUPCODE(
127: P_LOOKUP_TYPE => 'AHL_ITEMGROUP_TYPE',
128: P_LOOKUP_MEANING => l_item_group_rec.TYPE_MEANING,
129: X_LOOKUP_CODE => l_item_group_rec.type_code,
130: X_RETURN_VAL => l_return_val);

Line 142: IF NOT AHL_UTIL_MC_PKG.VALIDATE_LOOKUP_CODE(P_LOOKUP_TYPE => 'AHL_ITEMGROUP_STATUS',

138: FND_MSG_PUB.ADD;
139: END IF;
140:
141: IF l_item_group_rec.status_code IS NOT NULL THEN
142: IF NOT AHL_UTIL_MC_PKG.VALIDATE_LOOKUP_CODE(P_LOOKUP_TYPE => 'AHL_ITEMGROUP_STATUS',
143: P_LOOKUP_CODE =>l_item_group_rec.status_code) THEN
144: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STATUS_INAVLID');
145: FND_MSG_PUB.ADD;
146: END IF;

Line 148: AHL_UTIL_MC_PKG.CONVERT_TO_LOOKUPCODE(

144: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STATUS_INAVLID');
145: FND_MSG_PUB.ADD;
146: END IF;
147: ELSIF l_item_group_rec.status_meaning IS NOT NULL THEN
148: AHL_UTIL_MC_PKG.CONVERT_TO_LOOKUPCODE(
149: P_LOOKUP_TYPE => 'AHL_ITEMGROUP_STATUS',
150: P_LOOKUP_MEANING => l_item_group_rec.status_meaning,
151: X_LOOKUP_CODE => l_item_group_rec.status_code,
152: X_RETURN_VAL => l_return_val);

Line 217: AHL_UTIL_MC_PKG.Convert_To_LookupCode('AHL_ITEMGROUP_TYPE',

213: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NULL');
214: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
215: FND_MSG_PUB.ADD;
216: ELSIF l_item_group_rec.TYPE_MEANING IS NOT NULL THEN
217: AHL_UTIL_MC_PKG.Convert_To_LookupCode('AHL_ITEMGROUP_TYPE',
218: l_item_group_rec.TYPE_MEANING,
219: l_lookup_code,
220: l_return_val);
221: IF (l_return_val) THEN

Line 631: AHL_UTIL_MC_PKG.Convert_To_LookupCode('AHL_INTERCHANGE_ITEM_TYPE',

627: THEN
628: -- Check if meaning exists.
629: IF (l_item_assoc_rec.Interchange_type_meaning IS NOT NULL) AND
630: (l_item_assoc_rec.Interchange_type_meaning <> FND_API.G_MISS_CHAR) THEN
631: AHL_UTIL_MC_PKG.Convert_To_LookupCode('AHL_INTERCHANGE_ITEM_TYPE',
632: l_item_assoc_rec.Interchange_type_meaning,
633: l_lookup_code,
634: l_return_val);
635: IF (l_return_val) THEN