[Home] [Help]
36: --
37: -- 04-Nov-2002 kmotepal Added OSERROR command to fix GSCC warnings for patch 2633080
38: -- 13-Nov-2002 bhroy NOCOPY changes made
39: -- 11-27-2002 bhroy All the default values have been removed, also fixed Bug# 2250056
40: -- 16-JUN-2003 bhroy Modified CSC_CORE_UTILS_PVT.G_APP_SHORTNAME to CS, it was pointed to CSC, messages are in CS
41: -- 26-NOV-2003 bhroy Fixed bug# 2805474, update Start_Date_Active
42: -- 22-DEC-2003 bhroy Fixed bug# 3319977, 3319946, chanegd text messages, removed FND_API.G_MISS_NUM for G_CUSTOMIZED_ID
43: --
44: -- End of Comments
319: -- Validate Environment
320: -- ******************************************************************
321: IF FND_GLOBAL.User_Id IS NULL THEN
322: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
323: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
324: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
325: --FND_MSG_PUB.ADD;
326: END IF;
327: RAISE FND_API.G_EXC_ERROR;
331: -- Invoke validation procedures
332: Validate_csc_relationship_plan(
333: p_init_msg_list => FND_API.G_FALSE,
334: p_validation_level => p_validation_level,
335: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
336: P_CSC_PLAN_HEADERS_B_REC => P_CSC_PLAN_HEADERS_B_REC,
337: P_DESCRIPTION => p_description,
338: P_NAME => p_name,
339: x_return_status => x_return_status,
363:
364: IF ( P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN = 'Y' ) then
365: Validate_ORIGINAL_PLAN_ID(
366: p_init_msg_list => FND_API.G_FALSE,
367: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
368: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
369: p_ORIGINAL_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.ORIGINAL_PLAN_ID,
370: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
371: x_return_status => x_return_status,
374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: raise FND_API.G_EXC_ERROR;
376: END IF;
377: if ( l_party_id_tbl.count = 0 ) then
378: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
379: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
380: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
381: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
382: -- fnd_msg_pub.add;
390: -- OR l_party_id_tbl(i).cust_account_org is not NULL )
391: then
392: -- cannot allow update because parent plan is at account level and this
393: -- operation is trying to customize at party level.
394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);
398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
401: end if;
402: end if;
403: CSC_CUST_PLANS_PVT.Validate_PARTY_ID (
404: P_Init_Msg_List => FND_API.G_TRUE,
405: P_Validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
406: P_PARTY_ID => l_party_id_tbl(i).party_id,
407: x_Return_Status => x_return_status,
408: X_Msg_Count => x_msg_count,
409: X_Msg_Data => x_msg_data );
415:
416: IF ( P_CSC_PLAN_HEADERS_B_REC.USE_FOR_CUST_ACCOUNT = 'Y' ) then
417: CSC_CUST_PLANS_PVT.Validate_CUST_ACC_ORG_ID (
418: P_Init_Msg_List => FND_API.G_TRUE,
419: P_Validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
420: P_PARTY_ID => l_party_id_tbl(i).party_id,
421: P_CUST_ACCOUNT_ID => l_party_id_tbl(i).cust_account_id,
422: -- CUST_ACCOUNT_ORG => l_party_id_tbl(i).cust_account_org,
423: X_Return_Status => x_return_status,
460: if ( p_csc_plan_headers_b_rec.use_for_cust_account = FND_API.G_MISS_CHAR ) then
461: l_ins_plan_headers_b_rec.use_for_cust_account := NULL;
462: end if;
463:
464: if ( p_csc_plan_headers_b_rec.end_user_type = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) then
465: l_ins_plan_headers_b_rec.end_user_type := NULL;
466: end if;
467:
468: if ( p_csc_plan_headers_b_rec.customized_plan = FND_API.G_MISS_CHAR ) then
644: p_data => x_msg_data );
645:
646: EXCEPTION
647: WHEN FND_API.G_EXC_ERROR THEN
648: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME,
650: P_PKG_NAME => G_PKG_NAME,
651: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
652: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
648: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME,
650: P_PKG_NAME => G_PKG_NAME,
651: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
652: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
653: X_MSG_COUNT => X_MSG_COUNT,
654: X_MSG_DATA => X_MSG_DATA,
655: X_RETURN_STATUS => X_RETURN_STATUS);
656: APP_EXCEPTION.RAISE_EXCEPTION;
655: X_RETURN_STATUS => X_RETURN_STATUS);
656: APP_EXCEPTION.RAISE_EXCEPTION;
657:
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
660: P_API_NAME => L_API_NAME,
661: P_PKG_NAME => G_PKG_NAME,
662: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
663: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
659: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
660: P_API_NAME => L_API_NAME,
661: P_PKG_NAME => G_PKG_NAME,
662: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
663: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
664: X_MSG_COUNT => X_MSG_COUNT,
665: X_MSG_DATA => X_MSG_DATA,
666: X_RETURN_STATUS => X_RETURN_STATUS);
667: APP_EXCEPTION.RAISE_EXCEPTION;
666: X_RETURN_STATUS => X_RETURN_STATUS);
667: APP_EXCEPTION.RAISE_EXCEPTION;
668:
669: WHEN OTHERS THEN
670: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
671: P_API_NAME => L_API_NAME,
672: P_PKG_NAME => G_PKG_NAME,
673: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
674: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
669: WHEN OTHERS THEN
670: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
671: P_API_NAME => L_API_NAME,
672: P_PKG_NAME => G_PKG_NAME,
673: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
674: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
675: X_MSG_COUNT => X_MSG_COUNT,
676: X_MSG_DATA => X_MSG_DATA,
677: X_RETURN_STATUS => X_RETURN_STATUS);
670: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
671: P_API_NAME => L_API_NAME,
672: P_PKG_NAME => G_PKG_NAME,
673: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
674: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
675: X_MSG_COUNT => X_MSG_COUNT,
676: X_MSG_DATA => X_MSG_DATA,
677: X_RETURN_STATUS => X_RETURN_STATUS);
678: APP_EXCEPTION.RAISE_EXCEPTION;
909:
910: If ( c_get_csc_plan_headers%NOTFOUND) Then
911: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
912: --THEN
913: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
914: FND_MESSAGE.Set_Token ('INFO', 'csc_relationship_plans', FALSE);
915: -- FND_MSG_PUB.Add;
916: --END IF;
917: Close c_get_csc_plan_headers;
927: If ( P_CSC_PLAN_HEADERS_B_rec.object_version_number <>
928: l_ref_PLAN_HEADER_rec.OBJECT_VERSION_NUMBER ) THEN
929: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
930: --THEN
931: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_RECORD_CHANGED');
932: FND_MESSAGE.Set_Token('INFO', 'csc_relationship_plans', FALSE);
933: -- FND_MSG_PUB.ADD;
934: --END IF;
935: raise FND_API.G_EXC_ERROR;
940: -- of the table handler, because, when submitting the update sql. statement to the SGA,
941: -- we need to pass an identical update statement every time. This saves SGA space and
942: -- increases performance by using shared pool.
943:
944: l_upd_plan_headers_b_rec.original_plan_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_plan_headers_b_rec.original_plan_id, l_ref_plan_header_rec.original_plan_id);
945:
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
942: -- increases performance by using shared pool.
943:
944: l_upd_plan_headers_b_rec.original_plan_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_plan_headers_b_rec.original_plan_id, l_ref_plan_header_rec.original_plan_id);
945:
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
949:
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
944: l_upd_plan_headers_b_rec.original_plan_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_plan_headers_b_rec.original_plan_id, l_ref_plan_header_rec.original_plan_id);
945:
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
949:
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
951:
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
949:
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
951:
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
953:
954: l_upd_plan_headers_b_rec.end_user_type := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.end_user_type, l_ref_plan_header_rec.end_user_type);
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
951:
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
953:
954: l_upd_plan_headers_b_rec.end_user_type := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.end_user_type, l_ref_plan_header_rec.end_user_type);
955:
956: l_upd_plan_headers_b_rec.customized_plan := p_csc_plan_headers_b_rec.customized_plan;
957:
958: l_upd_plan_headers_b_rec.profile_check_id := p_csc_plan_headers_b_rec.profile_check_id;
958: l_upd_plan_headers_b_rec.profile_check_id := p_csc_plan_headers_b_rec.profile_check_id;
959:
960: l_upd_plan_headers_b_rec.relational_operator := p_csc_plan_headers_b_rec.relational_operator;
961:
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
963:
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
960: l_upd_plan_headers_b_rec.relational_operator := p_csc_plan_headers_b_rec.relational_operator;
961:
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
963:
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
963:
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
995:
996: l_upd_plan_headers_b_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute_category, l_ref_plan_header_rec.attribute_category);
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
995:
996: l_upd_plan_headers_b_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute_category, l_ref_plan_header_rec.attribute_category);
997:
998: if ( p_name <> FND_API.G_MISS_CHAR ) then
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
995:
996: l_upd_plan_headers_b_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute_category, l_ref_plan_header_rec.attribute_category);
997:
998: if ( p_name <> FND_API.G_MISS_CHAR ) then
999: l_name := p_name;
1000: end if;
1010: -- Invoke validation procedures
1011: Validate_csc_relationship_plan(
1012: p_init_msg_list => FND_API.G_FALSE,
1013: p_validation_level => p_validation_level,
1014: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1015: P_CSC_PLAN_HEADERS_B_REC => L_UPD_PLAN_HEADERS_B_REC,
1016: P_OLD_PLAN_HEADERS_B_REC => l_ref_plan_header_rec,
1017: P_DESCRIPTION => l_description,
1018: P_NAME => l_name,
1148: p_data => x_msg_data );
1149:
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1153: P_API_NAME => L_API_NAME,
1154: P_PKG_NAME => G_PKG_NAME,
1155: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1156: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1152: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1153: P_API_NAME => L_API_NAME,
1154: P_PKG_NAME => G_PKG_NAME,
1155: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1156: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1157: X_MSG_COUNT => X_MSG_COUNT,
1158: X_MSG_DATA => X_MSG_DATA,
1159: X_RETURN_STATUS => X_RETURN_STATUS);
1160: APP_EXCEPTION.RAISE_EXCEPTION;
1159: X_RETURN_STATUS => X_RETURN_STATUS);
1160: APP_EXCEPTION.RAISE_EXCEPTION;
1161:
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1163: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1164: P_API_NAME => L_API_NAME,
1165: P_PKG_NAME => G_PKG_NAME,
1166: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1167: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1163: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1164: P_API_NAME => L_API_NAME,
1165: P_PKG_NAME => G_PKG_NAME,
1166: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1167: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1168: X_MSG_COUNT => X_MSG_COUNT,
1169: X_MSG_DATA => X_MSG_DATA,
1170: X_RETURN_STATUS => X_RETURN_STATUS);
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1170: X_RETURN_STATUS => X_RETURN_STATUS);
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1172:
1173: WHEN OTHERS THEN
1174: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME,
1176: P_PKG_NAME => G_PKG_NAME,
1177: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1178: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1173: WHEN OTHERS THEN
1174: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME,
1176: P_PKG_NAME => G_PKG_NAME,
1177: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1178: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1179: X_MSG_COUNT => X_MSG_COUNT,
1180: X_MSG_DATA => X_MSG_DATA,
1181: X_RETURN_STATUS => X_RETURN_STATUS);
1174: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME,
1176: P_PKG_NAME => G_PKG_NAME,
1177: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1178: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1179: X_MSG_COUNT => X_MSG_COUNT,
1180: X_MSG_DATA => X_MSG_DATA,
1181: X_RETURN_STATUS => X_RETURN_STATUS);
1182: APP_EXCEPTION.RAISE_EXCEPTION;
1277: p_data => x_msg_data);
1278:
1279: EXCEPTION
1280: WHEN FND_API.G_EXC_ERROR THEN
1281: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1282: P_API_NAME => L_API_NAME,
1283: P_PKG_NAME => G_PKG_NAME,
1284: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1285: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1281: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1282: P_API_NAME => L_API_NAME,
1283: P_PKG_NAME => G_PKG_NAME,
1284: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1285: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1286: X_MSG_COUNT => X_MSG_COUNT,
1287: X_MSG_DATA => X_MSG_DATA,
1288: X_RETURN_STATUS => X_RETURN_STATUS);
1289: APP_EXCEPTION.RAISE_EXCEPTION;
1288: X_RETURN_STATUS => X_RETURN_STATUS);
1289: APP_EXCEPTION.RAISE_EXCEPTION;
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1293: P_API_NAME => L_API_NAME,
1294: P_PKG_NAME => G_PKG_NAME,
1295: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1296: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1292: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1293: P_API_NAME => L_API_NAME,
1294: P_PKG_NAME => G_PKG_NAME,
1295: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1296: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1297: X_MSG_COUNT => X_MSG_COUNT,
1298: X_MSG_DATA => X_MSG_DATA,
1299: X_RETURN_STATUS => X_RETURN_STATUS);
1300: APP_EXCEPTION.RAISE_EXCEPTION;
1299: X_RETURN_STATUS => X_RETURN_STATUS);
1300: APP_EXCEPTION.RAISE_EXCEPTION;
1301:
1302: WHEN OTHERS THEN
1303: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1304: P_API_NAME => L_API_NAME,
1305: P_PKG_NAME => G_PKG_NAME,
1306: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1307: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1302: WHEN OTHERS THEN
1303: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1304: P_API_NAME => L_API_NAME,
1305: P_PKG_NAME => G_PKG_NAME,
1306: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1307: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1308: X_MSG_COUNT => X_MSG_COUNT,
1309: X_MSG_DATA => X_MSG_DATA,
1310: X_RETURN_STATUS => X_RETURN_STATUS);
1303: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1304: P_API_NAME => L_API_NAME,
1305: P_PKG_NAME => G_PKG_NAME,
1306: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1307: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1308: X_MSG_COUNT => X_MSG_COUNT,
1309: X_MSG_DATA => X_MSG_DATA,
1310: X_RETURN_STATUS => X_RETURN_STATUS);
1311: APP_EXCEPTION.RAISE_EXCEPTION;
1339: -- Initialize API return status to SUCCESS
1340: x_return_status := FND_API.G_RET_STS_SUCCESS;
1341:
1342: -- validate NOT NULL column.
1343: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1344: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1345: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1346: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1347: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1341:
1342: -- validate NOT NULL column.
1343: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1344: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1345: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1346: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1347: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1348: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1349: -- fnd_msg_pub.add;
1351: END IF;
1352: end if;
1353:
1354: -- validate for duplicate plan_ids.
1355: IF (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
1356: THEN
1357: open check_dup_plan_id;
1358: fetch check_dup_plan_id into l_plan_id;
1359: if check_dup_plan_id%FOUND then
1356: THEN
1357: open check_dup_plan_id;
1358: fetch check_dup_plan_id into l_plan_id;
1359: if check_dup_plan_id%FOUND then
1360: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1361: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1362: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1363: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_ID');
1364: -- fnd_msg_pub.add;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403:
1404: -- validate NOT NULL column
1405: IF(p_NAME is NULL or p_name = FND_API.G_MISS_CHAR) then
1406: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1407: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1408: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1409: fnd_message.set_token('NULL_PARAM', 'PLAN_NAME');
1410: -- fnd_msg_pub.add;
1412: END IF;
1413:
1414: -- validate for duplicate plan_names.
1415: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1416: if p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE then
1417: l_plan_id := 0;
1418: else
1419: l_plan_id := p_plan_id;
1420: end if;
1422: open check_dup_plan_name;
1423: fetch check_dup_plan_name into l_plan_id;
1424: close check_dup_plan_name;
1425:
1426: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE and l_plan_id <> 0 ) then
1427: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1423: fetch check_dup_plan_name into l_plan_id;
1424: close check_dup_plan_name;
1425:
1426: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE and l_plan_id <> 0 ) then
1427: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1431: -- fnd_msg_pub.add;
1431: -- fnd_msg_pub.add;
1432: fnd_message.set_name ('CSC', 'CSC_RSP_DUPLICATE_NAME');
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: else
1435: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE and
1436: l_plan_id <> p_plan_id ) then -- some other plan exists with this name
1437: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1438: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1439: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: else
1435: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE and
1436: l_plan_id <> p_plan_id ) then -- some other plan exists with this name
1437: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1438: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1439: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1440: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1441: -- fnd_msg_pub.add;
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: -- validate NOT NULL column
1483: IF ( p_original_plan_id is NULL or p_original_plan_id = FND_API.G_MISS_NUM ) THEN
1484: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) OR
1485: ( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
1486: p_customized_plan = 'Y' )
1487: THEN
1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1481:
1482: -- validate NOT NULL column
1483: IF ( p_original_plan_id is NULL or p_original_plan_id = FND_API.G_MISS_NUM ) THEN
1484: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) OR
1485: ( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
1486: p_customized_plan = 'Y' )
1487: THEN
1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1489: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1484: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) OR
1485: ( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
1486: p_customized_plan = 'Y' )
1487: THEN
1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1489: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1490: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1491: fnd_message.set_token('NULL_PARAM', 'ORIGINAL_PLAN_ID');
1492: -- fnd_msg_pub.add;
1498: IF ( p_original_plan_id is not NULL and p_original_plan_id <> FND_API.G_MISS_NUM ) THEN
1499: open chk_original_plan_id;
1500: fetch chk_original_plan_id into l_plan_id;
1501: if ( chk_original_plan_id%notfound ) then
1502: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1503: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1504: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1505: fnd_message.set_token('VALUE', p_original_plan_id);
1506: fnd_message.set_token('PARAMETER', 'ORIGINAL_PLAN_ID');
1547: x_return_status := FND_API.G_RET_STS_SUCCESS;
1548:
1549: -- validate NOT NULL column
1550: IF (p_PLAN_GROUP_CODE is NULL or p_PLAN_GROUP_CODE = FND_API.G_MISS_CHAR) then
1551: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1552: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1553: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1554: fnd_message.set_token('NULL_PARAM', 'PLAN_GROUP_CODE');
1555: -- fnd_msg_pub.add;
1560: fetch group_in_lookup into l_rec_count;
1561: close group_in_lookup;
1562:
1563: if ( l_rec_count = 0 ) then
1564: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1565: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1566: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1567: fnd_message.set_token('VALUE', p_plan_group_code);
1568: fnd_message.set_token('PARAMETER', 'PLAN_GROUP_CODE');
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: -- validate NOT NULL column
1611: IF ( p_use_for_cust_account is NULL or p_use_for_cust_account = FND_API.G_MISS_CHAR ) then
1612: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1613: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1614: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: ELSIF ( p_use_for_cust_account <> 'Y' and p_use_for_cust_account <> 'N' ) then
1619: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1620: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1621: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1622: fnd_message.set_token('VALUE', p_use_for_cust_account);
1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
1622: fnd_message.set_token('VALUE', p_use_for_cust_account);
1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
1624: -- fnd_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then
1627: if ( p_use_for_cust_account <> p_old_use_for_cust_account ) then
1628: -- Check if there are any existing customer-to-plan associations for this particular
1629: -- PLAN_ID. If ther are, then do not allow the update on the column.
1630: open c1;
1632: close c1;
1633: if ( l_rec_count <> 0 ) then
1634: -- Use_for_cust_account cannot be updated. There are existing customers
1635: -- associated to this plan.
1636: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1637: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1638: -- Fixed bug# 3319977
1639: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1640: fnd_message.set_token('UPDATE_PARAM', 'PLAN_LEVEL');
1688: fetch type_in_lookup into l_rec_count;
1689: close type_in_lookup;
1690:
1691: if ( l_rec_count = 0 ) then
1692: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1693: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1694: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1695: fnd_message.set_token('VALUE', p_end_user_type);
1696: fnd_message.set_token('PARAMETER', 'END_USER_TYPE');
1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
1726:
1727: -- validate NOT NULL column
1728: IF( p_CUSTOMIZED_PLAN is NULL or p_customized_plan = FND_API.G_MISS_CHAR ) then
1729: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1730: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1737: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1738: fnd_message.set_token('VALUE', p_customized_plan);
1739: fnd_message.set_token('PARAMETER', 'CUSTOMIZED_PLAN');
1784: x_return_status := FND_API.G_RET_STS_SUCCESS;
1785:
1786: -- validate NOT NULL column
1787: IF(p_PROFILE_CHECK_ID is NULL or p_profile_check_id = FND_API.G_MISS_NUM) then
1788: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1789: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1790: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1791: fnd_message.set_token('NULL_PARAM', 'PROFILE_CHECK_ID');
1792: -- fnd_msg_pub.add;
1790: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1791: fnd_message.set_token('NULL_PARAM', 'PROFILE_CHECK_ID');
1792: -- fnd_msg_pub.add;
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1795: p_profile_check_id <> p_old_profile_check_id ) then
1796: --if ( G_CUST_PLANS_REC_CNT = FND_API.G_MISS_NUM ) then
1797: open c1;
1798: fetch c1 into l_rec_count;
1799: close c1;
1800: --end if;
1801: if ( l_rec_count <> 0 ) then
1802: -- Profile check id cannot be updated. There are customers attached to this plan.
1803: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1804: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1805: -- Fixed bug# 3319977
1806: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1807: fnd_message.set_token('UPDATE_PARAM', 'PROFILE_CHECK_ID');
1810: END IF;
1811:
1812: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1813: -- validate PROFILE_CHECK_ID exists in fnd_lookup_values.
1814: if ( ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1815: p_profile_check_id <> p_old_profile_check_id ) OR
1816: p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE )
1817: then
1818: open id_in_prof_checks;
1812: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1813: -- validate PROFILE_CHECK_ID exists in fnd_lookup_values.
1814: if ( ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1815: p_profile_check_id <> p_old_profile_check_id ) OR
1816: p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE )
1817: then
1818: open id_in_prof_checks;
1819: fetch id_in_prof_checks into l_rec_count;
1820: close id_in_prof_checks;
1820: close id_in_prof_checks;
1821:
1822: if ( l_rec_count = 0 or l_rec_count > 1 ) then
1823: -- Profile check id is not a valid condition id.
1824: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1825: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1826: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1827: fnd_message.set_token('VALUE', p_profile_check_id);
1828: fnd_message.set_token('PARAMETER', 'PROFILE_CHECK_ID');
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;
1868:
1869: -- validate NOT NULL column
1870: --IF(p_CRITERIA_VALUE_LOW is NULL or p_CRITERIA_VALUE_LOW = FND_API.G_MISS_CHAR ) then
1871: --fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1872: --fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1873: --fnd_message.set_token('NULL_PARAM', 'CRITERIA_VALUE_LOW');
1874: -- fnd_msg_pub.add;
1875: --x_return_status := FND_API.G_RET_STS_ERROR;
1872: --fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1873: --fnd_message.set_token('NULL_PARAM', 'CRITERIA_VALUE_LOW');
1874: -- fnd_msg_pub.add;
1875: --x_return_status := FND_API.G_RET_STS_ERROR;
1876: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1877: p_criteria_value_low <> p_old_criteria_value_low ) then
1878: --if ( G_CUST_PLANS_REC_CNT = FND_API.G_MISS_NUM ) then
1879: open c1;
1880: fetch c1 into l_rec_count;
1881: close c1;
1882: --end if;
1883: if ( l_rec_count <> 0 ) then
1884: -- Criteria_value_low cannot be updated. There are customers attached to this plan.
1885: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1886: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1887: -- Fixed bug# 3319977
1888: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1889: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_LOW');
1925:
1926: -- Initialize API return status to SUCCESS
1927: x_return_status := FND_API.G_RET_STS_SUCCESS;
1928:
1929: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1930: nvl(p_criteria_value_high,0) <> nvl(p_old_criteria_value_high,0) ) then
1931: --if ( G_CUST_PLANS_REC_CNT = FND_API.G_MISS_NUM ) then
1932: open c1;
1933: fetch c1 into l_rec_count;
1934: close c1;
1935: --end if;
1936: if ( l_rec_count <> 0 ) then
1937: -- Criteria_value_high cannot be updated. There are customers attached to this plan.
1938: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1939: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1940: -- Fixed bug# 3319977
1941: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1942: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_HIGH');
1980: x_return_status := FND_API.G_RET_STS_SUCCESS;
1981:
1982: -- validate NOT NULL column
1983: IF(p_RELATIONAL_OPERATOR is NULL or p_RELATIONAL_OPERATOR = FND_API.G_MISS_CHAR ) then
1984: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1985: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1986: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1987: fnd_message.set_token('NULL_PARAM', 'RELATIONAL_OPERATOR');
1988: -- fnd_msg_pub.add;
1986: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1987: fnd_message.set_token('NULL_PARAM', 'RELATIONAL_OPERATOR');
1988: -- fnd_msg_pub.add;
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1990: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1991: p_relational_operator <> p_old_relational_operator ) then
1992: --if ( G_CUST_PLANS_REC_CNT = FND_API.G_MISS_NUM ) then
1993: open c1;
1994: fetch c1 into l_rec_count;
1995: close c1;
1996: --end if;
1997: if ( l_rec_count <> 0 ) then
1998: -- Relational_operator cannot be updated. There are customers attached to this plan.
1999: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
2000: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
2001: -- Fixed bug# 3319977
2002: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
2003: fnd_message.set_token('UPDATE_PARAM', 'RELATIONAL_OPERATOR');
2045: THEN
2046: if ( p_criteria_value_low IS NULL AND p_criteria_value_high IS NOT NULL ) then
2047: -- Error in plan criteria. Criteria value low should be specified and criteria
2048: -- value high should not be specified.
2049: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2050: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2051: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2052: fnd_message.set_token('VALUE', p_relational_operator);
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: elsif ( p_criteria_value_low is NULL AND p_criteria_value_high IS NULL ) then
2056: -- Error in plan criteria. Criteria value low should be specified.
2057: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2058: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2059: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2060: fnd_message.set_token('VALUE', p_criteria_value_low);
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2062: x_return_status := FND_API.G_RET_STS_ERROR;
2063: elsif ( p_criteria_value_low IS NOT NULL AND p_criteria_value_high IS NOT NULL ) then
2064: -- Error in plan criteria. Criteria value high should not be specified.
2065: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2066: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2067: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2068: fnd_message.set_token('VALUE', p_criteria_value_high);
2069: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2073: p_relational_operator = 'NOT BETWEEN' )
2074: THEN
2075: if ( p_criteria_value_low IS NULL OR p_criteria_value_high IS NULL ) then
2076: -- Error in plan criteria. Criteria value low and high should be specified.
2077: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2078: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2079: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2080: fnd_message.set_token('VALUE', p_relational_operator);
2081: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: elsif ( p_criteria_value_low > p_criteria_value_high ) then
2084: -- Error in plan criteria. Criteria value low should be less than criteria
2085: -- value high.
2086: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2087: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2088: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2089: fnd_message.set_token('VALUE', p_criteria_value_high);
2090: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2094: p_relational_operator = 'IS NOT NULL' )
2095: THEN
2096: if ( p_criteria_value_low IS NOT NULL OR p_criteria_value_high IS NOT NULL ) then
2097: -- Error in plan criteria. Criteria value low and high should not be specified.
2098: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2099: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2100: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2101: fnd_message.set_token('VALUE', p_relational_operator);
2102: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2135:
2136: -- Initialize API return status to SUCCESS
2137: x_return_status := FND_API.G_RET_STS_SUCCESS;
2138:
2139: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then
2140: open c1;
2141: fetch c1 into l_min_date;
2142: close c1;
2143:
2143:
2144: if ( trunc(p_start_date_active) > trunc(l_min_date) ) then
2145: -- START date cannot be updated to specified value. There are customers who are associated
2146: -- to this plan EARLIER than the specified date. Valid dates are LESS than MIN_DATE;
2147: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2148: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2149: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2150: fnd_message.set_token('VALUE', p_start_date_active);
2151: fnd_message.set_token('PARAMETER', 'START_DATE_ACTIVE');
2188:
2189: -- Initialize API return status to SUCCESS
2190: x_return_status := FND_API.G_RET_STS_SUCCESS;
2191:
2192: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then
2193: open c1;
2194: fetch c1 into l_max_date;
2195: close c1;
2196:
2201: if ( trunc(p_end_date_active) < trunc(l_max_date) ) then
2202: -- DATE_TYPE date cannot be updated to specified value. There are customers who are associated
2203: -- to this plan EARLIER_LATER than the specified date. Valid dates are GREATER_LESSER than
2204: -- MAX_MIN_DATE;
2205: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CSC_RSP_INVALID_DATE_UPDATE');
2206: fnd_message.set_token ('DATE_TYPE', 'End Date Active');
2207: fnd_message.set_token('EARLIER_LATER', 'later');
2208: fnd_message.set_token('GREATER_LESSER', 'greater');
2209: fnd_message.set_token('MAX_MIN_DATE', l_max_date);
2213: /*
2214: if ( trunc(p_end_date_active) < trunc(l_max_date) ) then
2215: -- END date cannot be updated to specified value. There are customers who are associated
2216: -- to this plan LATER than the specified date. Valid dates are GREATER than MAX_DATE;
2217: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2218: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2219: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2220: fnd_message.set_token('VALUE', p_end_date_active);
2221: fnd_message.set_token('PARAMETER', 'END_DATE_ACTIVE');
2325: raise FND_API.G_EXC_ERROR;
2326: END IF;
2327:
2328: -- issue a call to the CORE UTILITIES package to validate the date fields.
2329: CSC_CORE_UTILS_PVT.VALIDATE_DATES(
2330: p_init_msg_list => FND_API.G_FALSE,
2331: p_validation_mode => p_validation_mode,
2332: P_START_DATE => p_csc_plan_headers_b_rec.start_date_active,
2333: P_END_DATE => p_csc_plan_headers_b_rec.end_date_active,