[Home] [Help]
352:
353: IF (SQL%NOTFOUND) THEN
354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
355: THEN
356: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
357: FND_MSG_PUB.add;
358: END IF;
359: RAISE FND_API.g_exc_error;
360: END IF;
474: FETCH c_prtnr_prfls INTO l_partner_profile_id;
475: IF (c_prtnr_prfls%NOTFOUND) THEN
476: CLOSE c_prtnr_prfls;
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
478: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
479: FND_MSG_PUB.add;
480: END IF;
481: RAISE FND_API.g_exc_error;
482: END IF;
498:
499: WHEN PVX_Utility_PVT.resource_locked THEN
500: x_return_status := FND_API.g_ret_sts_error;
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
502: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
503: FND_MSG_PUB.add;
504: END IF;
505:
506: FND_MSG_PUB.count_and_get(
759: AND object_version_number = l_prtnr_prfls_rec.object_version_number;
760:
761: IF (SQL%NOTFOUND) THEN
762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
763: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
764: FND_MSG_PUB.add;
765: END IF;
766: RAISE FND_API.g_exc_error;
767: END IF;
812: );
813:
814: /*
815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_LOGD_RES_ID');
817: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.logged_resource_id) );
818: FND_MSG_PUB.add;
819: END IF;
820: */
813:
814: /*
815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_LOGD_RES_ID');
817: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.logged_resource_id) );
818: FND_MSG_PUB.add;
819: END IF;
820: */
821:
1121: ------------------------ partner_id --------------------------
1122: IF p_prtnr_prfls_rec.partner_id IS NULL THEN
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1124: THEN
1125: FND_MESSAGE.set_name('PV', 'PV_NO_PARTNER_ID');
1126: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1127: FND_MSG_PUB.add;
1128: END IF;
1129:
1122: IF p_prtnr_prfls_rec.partner_id IS NULL THEN
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1124: THEN
1125: FND_MESSAGE.set_name('PV', 'PV_NO_PARTNER_ID');
1126: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1127: FND_MSG_PUB.add;
1128: END IF;
1129:
1130: x_return_status := FND_API.g_ret_sts_error;
1132: ------------------------ cm_id -------------------------------
1133: /*ELSIF p_prtnr_prfls_rec.cm_id IS NULL THEN
1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1135: THEN
1136: FND_MESSAGE.set_name('PV', 'PV_NO_CM_ID');
1137: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.cm_id) );
1138: FND_MSG_PUB.add;
1139: END IF;
1140:
1133: /*ELSIF p_prtnr_prfls_rec.cm_id IS NULL THEN
1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1135: THEN
1136: FND_MESSAGE.set_name('PV', 'PV_NO_CM_ID');
1137: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.cm_id) );
1138: FND_MSG_PUB.add;
1139: END IF;
1140:
1141: x_return_status := FND_API.g_ret_sts_error;
1172: ) = FND_API.g_false
1173: THEN
1174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1175: THEN
1176: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_ID');
1177: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_profile_id) );
1178: FND_MSG_PUB.add;
1179: END IF;
1180: x_return_status := FND_API.g_ret_sts_error;
1173: THEN
1174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1175: THEN
1176: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_ID');
1177: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_profile_id) );
1178: FND_MSG_PUB.add;
1179: END IF;
1180: x_return_status := FND_API.g_ret_sts_error;
1181: RETURN;
1212: ) = FND_API.g_false
1213: THEN
1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1215: THEN
1216: FND_MESSAGE.set_name('PV', 'PV_BAD_PARTNER_ID');
1217: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1218: FND_MSG_PUB.add;
1219: END IF;
1220:
1213: THEN
1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1215: THEN
1216: FND_MESSAGE.set_name('PV', 'PV_BAD_PARTNER_ID');
1217: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1218: FND_MSG_PUB.add;
1219: END IF;
1220:
1221: x_return_status := FND_API.g_ret_sts_error;
1268: IF PVX_Utility_PVT.is_Y_or_N(p_prtnr_prfls_rec.lead_share_appr_flag) = FND_API.g_false
1269: THEN
1270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1271: THEN
1272: FND_MESSAGE.set_name('PV', 'PV_INVALID_FLAG');
1273: FND_MSG_PUB.add;
1274: END IF;
1275:
1276: x_return_status := FND_API.g_ret_sts_error;
1370: */
1371: IF p_complete_rec.cm_id IS NOT NULL THEN
1372: IF p_prtnr_prfls_rec.cm_id IS NULL THEN
1373: --OR p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM
1374: FND_MESSAGE.Set_name('PV','PV_CM_ID_UPDATE_VIOLATION');
1375: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_complete_rec.cm_id));
1376: FND_MSG_PUB.ADD;
1377: x_return_status := FND_API.g_ret_sts_error;
1378: RETURN;
1371: IF p_complete_rec.cm_id IS NOT NULL THEN
1372: IF p_prtnr_prfls_rec.cm_id IS NULL THEN
1373: --OR p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM
1374: FND_MESSAGE.Set_name('PV','PV_CM_ID_UPDATE_VIOLATION');
1375: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_complete_rec.cm_id));
1376: FND_MSG_PUB.ADD;
1377: x_return_status := FND_API.g_ret_sts_error;
1378: RETURN;
1379: END IF;
1461: FETCH c_prtnr_prfls INTO l_prtnr_prfls_rec;
1462: IF c_prtnr_prfls%NOTFOUND THEN
1463: CLOSE c_prtnr_prfls;
1464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1465: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
1466: FND_MSG_PUB.add;
1467: END IF;
1468: RAISE FND_API.g_exc_error;
1469: END IF;