DBA Data[Home] [Help]

APPS.CSC_PLAN_LINES_PVT dependencies on FND_MESSAGE

Line 219: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');

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;

Line 220: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;

Line 490: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');

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;

Line 491: FND_MESSAGE.Set_Token ('INFO', 'plan_lines', FALSE);

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;

Line 712: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 713: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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

Line 714: fnd_message.set_token('NULL_PARAM', 'LINE_ID');

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

Line 723: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

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;

Line 724: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 725: fnd_message.set_token('DUPLICATE_VAL_PARAM', '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;
729: close check_dup_line_id;

Line 772: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 773: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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:

Line 774: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');

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.

Line 783: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 784: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 785: fnd_message.set_token('VALUE', p_plan_id);

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;

Line 786: fnd_message.set_token('PARAMETER', '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;
790: END IF;

Line 840: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 841: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 842: fnd_message.set_token('NULL_PARAM', 'CONDITION_ID');

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:

Line 852: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 853: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 854: fnd_message.set_token('VALUE', p_condition_id);

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;

Line 855: fnd_message.set_token('PARAMETER', 'CONDITION_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;
859: END IF;

Line 866: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

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;

Line 867: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 868: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CONDITION_ID');

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;