215: IF FND_GLOBAL.User_Id IS NULL
216: THEN
217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
218: THEN
219: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
220: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
221: -- FND_MSG_PUB.ADD;
222: END IF;
223: RAISE FND_API.G_EXC_ERROR;
216: THEN
217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
218: THEN
219: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
220: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
221: -- FND_MSG_PUB.ADD;
222: END IF;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
486: If ( C_Get_plan_lines%NOTFOUND) Then
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
488: THEN
489: Close C_Get_plan_lines;
490: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
491: FND_MESSAGE.Set_Token ('INFO', 'plan_lines', FALSE);
492: -- FND_MSG_PUB.Add;
493: END IF;
494: raise FND_API.G_EXC_ERROR;
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
488: THEN
489: Close C_Get_plan_lines;
490: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
491: FND_MESSAGE.Set_Token ('INFO', 'plan_lines', FALSE);
492: -- FND_MSG_PUB.Add;
493: END IF;
494: raise FND_API.G_EXC_ERROR;
495: END IF;
708:
709: -- validate NOT NULL column for updates
710: IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN
711: if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then
712: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
713: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
714: fnd_message.set_token('NULL_PARAM', 'LINE_ID');
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: end if;
709: -- validate NOT NULL column for updates
710: IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN
711: if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then
712: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
713: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
714: fnd_message.set_token('NULL_PARAM', 'LINE_ID');
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: end if;
717: ELSIF( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
710: IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN
711: if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then
712: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
713: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
714: fnd_message.set_token('NULL_PARAM', 'LINE_ID');
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: end if;
717: ELSIF( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
718: p_line_id is not NULL and p_line_id <> FND_API.G_MISS_NUM ) THEN
719: -- check for duplicate line_ids.
720: open check_dup_line_id;
721: fetch check_dup_line_id into l_line_id;
722: if check_dup_line_id%FOUND then
723: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
724: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
725: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'LINE_ID');
726: -- fnd_msg_pub.add;
727: x_return_status := FND_API.G_RET_STS_ERROR;
720: open check_dup_line_id;
721: fetch check_dup_line_id into l_line_id;
722: if check_dup_line_id%FOUND then
723: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
724: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
725: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'LINE_ID');
726: -- fnd_msg_pub.add;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: end if;
721: fetch check_dup_line_id into l_line_id;
722: if check_dup_line_id%FOUND then
723: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
724: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
725: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'LINE_ID');
726: -- fnd_msg_pub.add;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: end if;
729: close check_dup_line_id;
768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769:
770: -- validate NOT NULL column
771: IF( p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM ) then
772: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
773: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
774: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;
769:
770: -- validate NOT NULL column
771: IF( p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM ) then
772: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
773: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
774: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;
777:
770: -- validate NOT NULL column
771: IF( p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM ) then
772: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
773: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
774: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;
777:
778: -- validate for valid plan_ids.
779: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
780: open c1;
781: fetch c1 into l_plan_id;
782: if c1%NOTFOUND then
783: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
784: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
785: fnd_message.set_token('VALUE', p_plan_id);
786: fnd_message.set_token('PARAMETER', 'PLAN_ID');
787: x_return_status := FND_API.G_RET_STS_ERROR;
780: open c1;
781: fetch c1 into l_plan_id;
782: if c1%NOTFOUND then
783: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
784: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
785: fnd_message.set_token('VALUE', p_plan_id);
786: fnd_message.set_token('PARAMETER', 'PLAN_ID');
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: end if;
781: fetch c1 into l_plan_id;
782: if c1%NOTFOUND then
783: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
784: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
785: fnd_message.set_token('VALUE', p_plan_id);
786: fnd_message.set_token('PARAMETER', 'PLAN_ID');
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: end if;
789: close c1;
782: if c1%NOTFOUND then
783: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
784: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
785: fnd_message.set_token('VALUE', p_plan_id);
786: fnd_message.set_token('PARAMETER', 'PLAN_ID');
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: end if;
789: close c1;
790: END IF;
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:
838: -- validate NOT NULL column
839: IF( p_CONDITION_ID is NULL or p_condition_id = FND_API.G_MISS_NUM ) THEN
840: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
841: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
842: fnd_message.set_token('NULL_PARAM', 'CONDITION_ID');
843: -- fnd_msg_pub.add;
844: x_return_status := FND_API.G_RET_STS_ERROR;
837:
838: -- validate NOT NULL column
839: IF( p_CONDITION_ID is NULL or p_condition_id = FND_API.G_MISS_NUM ) THEN
840: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
841: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
842: fnd_message.set_token('NULL_PARAM', 'CONDITION_ID');
843: -- fnd_msg_pub.add;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: END IF;
838: -- validate NOT NULL column
839: IF( p_CONDITION_ID is NULL or p_condition_id = FND_API.G_MISS_NUM ) THEN
840: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
841: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
842: fnd_message.set_token('NULL_PARAM', 'CONDITION_ID');
843: -- fnd_msg_pub.add;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: END IF;
846:
848: -- validate for valid condition_id.
849: open c1;
850: fetch c1 into l_id;
851: if c1%NOTFOUND then
852: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
853: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
854: fnd_message.set_token('VALUE', p_condition_id);
855: fnd_message.set_token('PARAMETER', 'CONDITION_ID');
856: x_return_status := FND_API.G_RET_STS_ERROR;
849: open c1;
850: fetch c1 into l_id;
851: if c1%NOTFOUND then
852: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
853: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
854: fnd_message.set_token('VALUE', p_condition_id);
855: fnd_message.set_token('PARAMETER', 'CONDITION_ID');
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: end if;
850: fetch c1 into l_id;
851: if c1%NOTFOUND then
852: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
853: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
854: fnd_message.set_token('VALUE', p_condition_id);
855: fnd_message.set_token('PARAMETER', 'CONDITION_ID');
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: end if;
858: close c1;
851: if c1%NOTFOUND then
852: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
853: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
854: fnd_message.set_token('VALUE', p_condition_id);
855: fnd_message.set_token('PARAMETER', 'CONDITION_ID');
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: end if;
858: close c1;
859: END IF;
862: -- validate for duplicate plan_id and condition_id
863: open c2;
864: fetch c2 into l_id;
865: if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND (c2%FOUND) ) then
866: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
867: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
868: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CONDITION_ID');
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: end if;
863: open c2;
864: fetch c2 into l_id;
865: if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND (c2%FOUND) ) then
866: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
867: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
868: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CONDITION_ID');
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: end if;
871: close c2;
864: fetch c2 into l_id;
865: if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND (c2%FOUND) ) then
866: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
867: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
868: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CONDITION_ID');
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: end if;
871: close c2;
872: END IF;