[Home] [Help]
254: -- Standard Start of API savepoint
255: SAVEPOINT CREATE_CUST_PLANS_PVT;
256:
257: -- Standard call to check for call compatibility.
258: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
259: p_api_version_number,
260: l_api_name,
261: G_PKG_NAME)
262: THEN
259: p_api_version_number,
260: l_api_name,
261: G_PKG_NAME)
262: THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:
266: -- Initialize message list if p_init_msg_list is set to TRUE.
267: IF FND_API.to_Boolean( p_init_msg_list )
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:
266: -- Initialize message list if p_init_msg_list is set to TRUE.
267: IF FND_API.to_Boolean( p_init_msg_list )
268: THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: -- Initialize API return status to SUCCESS
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: -- ******************************************************************
276: -- Validate Environment
277: -- ******************************************************************
282: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
283: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
284: -- FND_MSG_PUB.ADD;
285: END IF;
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
290: THEN
285: END IF;
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
290: THEN
291: -- Invoke validation procedures
292: Validate_csc_cust_plans(
293: p_init_msg_list => FND_API.G_FALSE,
289: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
290: THEN
291: -- Invoke validation procedures
292: Validate_csc_cust_plans(
293: p_init_msg_list => FND_API.G_FALSE,
294: p_validation_level => p_validation_level,
295: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
296: P_CSC_CUST_PLANS_Rec => P_CSC_CUST_PLANS_Rec,
297: x_return_status => x_return_status,
298: x_msg_count => x_msg_count,
299: x_msg_data => x_msg_data);
300: END IF;
301:
302: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: -- if either start_date_active or end_date_active is passed in as null, then
299: x_msg_data => x_msg_data);
300: END IF;
301:
302: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: -- if either start_date_active or end_date_active is passed in as null, then
307: -- retreive these value from the csc_plan_headers_b table for the given plan_id;
306: -- if either start_date_active or end_date_active is passed in as null, then
307: -- retreive these value from the csc_plan_headers_b table for the given plan_id;
308:
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR
312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
308:
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR
312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
315: IF C1%NOTFOUND THEN
316: --FND_MESSAGE.SET_NAME(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '
397: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
398: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
399:
400: -- Standard check for p_commit
401: IF FND_API.to_Boolean( p_commit )
402: THEN
403: COMMIT WORK;
404: END IF;
405:
408: ( p_count => x_msg_count,
409: p_data => x_msg_data );
410:
411: EXCEPTION
412: WHEN FND_API.G_EXC_ERROR THEN
413: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME,
415: P_PKG_NAME => G_PKG_NAME,
416: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
419: X_MSG_DATA => X_MSG_DATA,
420: X_RETURN_STATUS => X_RETURN_STATUS);
421: APP_EXCEPTION.RAISE_EXCEPTION;
422:
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
425: P_API_NAME => L_API_NAME,
426: P_PKG_NAME => G_PKG_NAME,
427: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
457: P_PLAN_ID IN NUMBER,
458: P_CUST_PLAN_ID IN NUMBER,
459: P_PARTY_ID IN NUMBER,
460: P_CUST_ACCOUNT_ID IN NUMBER,
461: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
462: P_START_DATE_ACTIVE IN DATE,
463: P_END_DATE_ACTIVE IN DATE,
464: P_MANUAL_FLAG IN VARCHAR2,
465: P_PLAN_STATUS_CODE IN VARCHAR2,
594: -- Standard Start of API savepoint
595: SAVEPOINT UPDATE_CUST_PLANS_PVT;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
599: p_api_version_number,
600: l_api_name,
601: G_PKG_NAME)
602: THEN
599: p_api_version_number,
600: l_api_name,
601: G_PKG_NAME)
602: THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean( p_init_msg_list )
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean( p_init_msg_list )
608: THEN
609: FND_MSG_PUB.initialize;
610: END IF;
611:
609: FND_MSG_PUB.initialize;
610: END IF;
611:
612: -- Initialize API return status to SUCCESS
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: CSC_CUST_PLANS_PKG.Lock_Row(
616: p_CUST_PLAN_ID => p_csc_cust_plans_rec.cust_plan_id,
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
667: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
668: FND_MESSAGE.Set_Token ('INFO', 'cust_plans', FALSE);
669: -- FND_MSG_PUB.Add;
670: END IF;
671: raise FND_API.G_EXC_ERROR;
672: END IF;
673: Close C_Get_cust_plans;
674:
675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
724:
725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);
726:
727: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
728: THEN
729: -- Invoke validation procedures
730: Validate_csc_cust_plans(
731: p_init_msg_list => FND_API.G_FALSE,
727: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
728: THEN
729: -- Invoke validation procedures
730: Validate_csc_cust_plans(
731: p_init_msg_list => FND_API.G_FALSE,
732: p_validation_level => p_validation_level,
733: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
734: P_CSC_CUST_PLANS_Rec => L_UPD_CSC_CUST_PLANS_REC,
735: x_return_status => x_return_status,
735: x_return_status => x_return_status,
736: x_msg_count => x_msg_count,
737: x_msg_data => x_msg_data);
738:
739: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742: END IF;
743:
736: x_msg_count => x_msg_count,
737: x_msg_data => x_msg_data);
738:
739: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742: END IF;
743:
744: -- Invoke table handler(CSC_CUST_PLANS_PKG.Update_Row)
812: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
813:
814: --denzb***************************************************/
815: -- Standard check for p_commit
816: IF FND_API.to_Boolean( p_commit )
817: THEN
818: COMMIT WORK;
819: END IF;
820:
823: ( p_count => x_msg_count,
824: p_data => x_msg_data );
825:
826: EXCEPTION
827: WHEN FND_API.G_EXC_ERROR THEN
828: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
829: P_API_NAME => L_API_NAME,
830: P_PKG_NAME => G_PKG_NAME,
831: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
834: X_MSG_DATA => X_MSG_DATA,
835: X_RETURN_STATUS => X_RETURN_STATUS);
836: APP_EXCEPTION.RAISE_EXCEPTION;
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
840: P_API_NAME => L_API_NAME,
841: P_PKG_NAME => G_PKG_NAME,
842: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
879: -- Standard Start of API savepoint
880: SAVEPOINT ENABLE_PLAN_PVT;
881:
882: -- Standard call to check for call compatibility.
883: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
884: p_api_version_number,
885: l_api_name,
886: G_PKG_NAME)
887: THEN
884: p_api_version_number,
885: l_api_name,
886: G_PKG_NAME)
887: THEN
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890:
891: -- Initialize message list if p_init_msg_list is set to TRUE.
892: IF FND_API.to_Boolean( p_init_msg_list )
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890:
891: -- Initialize message list if p_init_msg_list is set to TRUE.
892: IF FND_API.to_Boolean( p_init_msg_list )
893: THEN
894: FND_MSG_PUB.initialize;
895: END IF;
896:
894: FND_MSG_PUB.initialize;
895: END IF;
896:
897: -- Initialize API return status to SUCCESS
898: x_return_status := FND_API.G_RET_STS_SUCCESS;
899:
900:
901: for i in 1..p_party_id_tbl.count
902: loop
903: Update_cust_plans(
904: P_Api_Version_Number => 1.0,
905: P_Init_Msg_List => p_init_msg_list,
906: P_Commit => p_commit,
907: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
908: p_cust_plan_id => NULL,
909: P_PLAN_ID => p_plan_id,
910: P_PARTY_ID => p_party_id_tbl(i).party_id,
911: P_CUST_ACCOUNT_ID => p_party_id_tbl(i).cust_account_id,
916: X_Return_Status => x_return_status,
917: X_Msg_Count => x_msg_count,
918: X_Msg_Data => x_msg_data );
919:
920: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
921: raise FND_API.G_EXC_ERROR;
922: end if;
923: end loop;
924:
917: X_Msg_Count => x_msg_count,
918: X_Msg_Data => x_msg_data );
919:
920: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
921: raise FND_API.G_EXC_ERROR;
922: end if;
923: end loop;
924:
925:
944: end loop;
945: ****************/
946:
947: -- Standard check for p_commit
948: IF FND_API.to_Boolean( p_commit )
949: THEN
950: COMMIT WORK;
951: END IF;
952:
977: -- Standard Start of API savepoint
978: SAVEPOINT DISABLE_PLAN_PVT;
979:
980: -- Standard call to check for call compatibility.
981: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
982: p_api_version_number,
983: l_api_name,
984: G_PKG_NAME)
985: THEN
982: p_api_version_number,
983: l_api_name,
984: G_PKG_NAME)
985: THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988:
989: -- Initialize message list if p_init_msg_list is set to TRUE.
990: IF FND_API.to_Boolean( p_init_msg_list )
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988:
989: -- Initialize message list if p_init_msg_list is set to TRUE.
990: IF FND_API.to_Boolean( p_init_msg_list )
991: THEN
992: FND_MSG_PUB.initialize;
993: END IF;
994:
992: FND_MSG_PUB.initialize;
993: END IF;
994:
995: -- Initialize API return status to SUCCESS
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997:
998: for i in 1..p_party_id_tbl.count
999: loop
1000: Update_cust_plans(
1000: Update_cust_plans(
1001: P_Api_Version_Number => 1.0,
1002: P_Init_Msg_List => p_init_msg_list,
1003: P_Commit => p_commit,
1004: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1005: p_cust_plan_id => NULL,
1006: P_PLAN_ID => p_plan_id,
1007: P_PARTY_ID => p_party_id_tbl(i).party_id,
1008: P_CUST_ACCOUNT_ID => p_party_id_tbl(i).cust_account_id,
1013: X_Return_Status => x_return_status,
1014: X_Msg_Count => x_msg_count,
1015: X_Msg_Data => x_msg_data );
1016:
1017: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1018: raise FND_API.G_EXC_ERROR;
1019: end if;
1020: end loop;
1021:
1014: X_Msg_Count => x_msg_count,
1015: X_Msg_Data => x_msg_data );
1016:
1017: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1018: raise FND_API.G_EXC_ERROR;
1019: end if;
1020: end loop;
1021:
1022: /******* using regular update procedure to take of audit insert
1041: end loop;
1042: ***********/
1043:
1044: -- Standard check for p_commit
1045: IF FND_API.to_Boolean( p_commit )
1046: THEN
1047: COMMIT WORK;
1048: END IF;
1049:
1090: -- Standard Start of API savepoint
1091: SAVEPOINT UPDATE_FOR_CUSTMIZED_PLANS_PVT;
1092:
1093: -- Standard call to check for call compatibility.
1094: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1095: p_api_version_number,
1096: l_api_name,
1097: G_PKG_NAME)
1098: THEN
1095: p_api_version_number,
1096: l_api_name,
1097: G_PKG_NAME)
1098: THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:
1102: -- Initialize message list if p_init_msg_list is set to TRUE.
1103: IF FND_API.to_Boolean( p_init_msg_list )
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:
1102: -- Initialize message list if p_init_msg_list is set to TRUE.
1103: IF FND_API.to_Boolean( p_init_msg_list )
1104: THEN
1105: FND_MSG_PUB.initialize;
1106: END IF;
1107:
1105: FND_MSG_PUB.initialize;
1106: END IF;
1107:
1108: -- Initialize API return status to SUCCESS
1109: x_return_status := FND_API.G_RET_STS_SUCCESS;
1110:
1111: open c1;
1112: fetch c1 into c1rec;
1113:
1114: if ( c1%NOTFOUND ) then
1115: close c1;
1116: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
1117: FND_MESSAGE.Set_Token ('INFO', 'CSC_CUST_PLANS', FALSE);
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise FND_API.G_EXC_ERROR;
1120: END IF;
1121: close c1;
1122:
1115: close c1;
1116: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
1117: FND_MESSAGE.Set_Token ('INFO', 'CSC_CUST_PLANS', FALSE);
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise FND_API.G_EXC_ERROR;
1120: END IF;
1121: close c1;
1122:
1123: CSC_CUST_PLANS_PKG.LOCK_ROW(
1170: p_ATTRIBUTE_CATEGORY => c1rec.ATTRIBUTE_CATEGORY,
1171: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
1172:
1173: -- Standard check for p_commit
1174: IF FND_API.to_Boolean( p_commit )
1175: THEN
1176: COMMIT WORK;
1177: END IF;
1178:
1220: -- Standard Start of API savepoint
1221: SAVEPOINT DELETE_CUST_PLANS_PVT;
1222:
1223: -- Standard call to check for call compatibility.
1224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1225: p_api_version_number,
1226: l_api_name,
1227: G_PKG_NAME)
1228: THEN
1225: p_api_version_number,
1226: l_api_name,
1227: G_PKG_NAME)
1228: THEN
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231:
1232: -- Initialize message list if p_init_msg_list is set to TRUE.
1233: IF FND_API.to_Boolean( p_init_msg_list )
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231:
1232: -- Initialize message list if p_init_msg_list is set to TRUE.
1233: IF FND_API.to_Boolean( p_init_msg_list )
1234: THEN
1235: FND_MSG_PUB.initialize;
1236: END IF;
1237:
1235: FND_MSG_PUB.initialize;
1236: END IF;
1237:
1238: -- Initialize API return status to SUCCESS
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;
1240:
1241: -- Fetch the values of the cust_plans rec to insert into the audit table.
1242: open c1 (p_cust_plan_id);
1243: fetch c1 into c1rec;
1287: p_ATTRIBUTE_CATEGORY => c1rec.ATTRIBUTE_CATEGORY,
1288: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
1289:
1290: -- Standard check for p_commit
1291: IF FND_API.to_Boolean( p_commit )
1292: THEN
1293: COMMIT WORK;
1294: END IF;
1295:
1298: ( p_count => x_msg_count,
1299: p_data => x_msg_data );
1300:
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR 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 => FND_MSG_PUB.G_MSG_LVL_ERROR,
1309: X_MSG_DATA => X_MSG_DATA,
1310: X_RETURN_STATUS => X_RETURN_STATUS);
1311: APP_EXCEPTION.RAISE_EXCEPTION;
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1315: P_API_NAME => L_API_NAME,
1316: P_PKG_NAME => G_PKG_NAME,
1317: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1357: v_where varchar2(300);
1358:
1359: BEGIN
1360: -- Initialize message list if p_init_msg_list is set to TRUE.
1361: IF FND_API.to_Boolean( p_init_msg_list )
1362: THEN
1363: FND_MSG_PUB.initialize;
1364: END IF;
1365:
1363: FND_MSG_PUB.initialize;
1364: END IF;
1365:
1366: -- Initialize API return status to SUCCESS
1367: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
1368:
1369: -- sql_stmt := 'select cust_plan_id from csc_cust_plans where ' || p_where_clause;
1370: -- execute immediate sql_stmt into x_cust_plan_id;
1371:
1419: l_cust_plan_id number;
1420: l_api_name varchar2(30) := 'Validate_Cust_Plan_Id';
1421: BEGIN
1422: -- Initialize message list if p_init_msg_list is set to TRUE.
1423: IF FND_API.to_Boolean( p_init_msg_list )
1424: THEN
1425: FND_MSG_PUB.initialize;
1426: END IF;
1427:
1425: FND_MSG_PUB.initialize;
1426: END IF;
1427:
1428: -- Initialize API return status to SUCCESS
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- validate NOT NULL column.
1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1433: IF(p_CUST_PLAN_ID is NULL or p_CUST_PLAN_ID = FND_API.G_MISS_NUM) then
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- validate NOT NULL column.
1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1433: IF(p_CUST_PLAN_ID is NULL or p_CUST_PLAN_ID = FND_API.G_MISS_NUM) then
1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1435: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');
1437: -- fnd_msg_pub.add;
1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1435: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');
1437: -- fnd_msg_pub.add;
1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439: END IF;
1440: end if;
1441:
1442: -- validate for duplicate plan_ids.
1448: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1449: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1450: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CUST_PLAN_ID');
1451: -- fnd_msg_pub.add;
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: end if;
1454: close check_dup_id;
1455: END IF;
1456:
1479: l_plan_id number;
1480: l_api_name varchar2(30) := 'Validate_Plan_Id';
1481: BEGIN
1482: -- Initialize message list if p_init_msg_list is set to TRUE.
1483: IF FND_API.to_Boolean( p_init_msg_list )
1484: THEN
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487:
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487:
1488: -- Initialize API return status to SUCCESS
1489: x_return_status := FND_API.G_RET_STS_SUCCESS;
1490:
1491: -- validate NOT NULL column
1492: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1488: -- Initialize API return status to SUCCESS
1489: x_return_status := FND_API.G_RET_STS_SUCCESS;
1490:
1491: -- validate NOT NULL column
1492: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1494: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1495: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1496: -- fnd_msg_pub.add;
1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1494: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1495: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1496: -- fnd_msg_pub.add;
1497: x_return_status := FND_API.G_RET_STS_ERROR;
1498: END IF;
1499:
1500: -- validate for valid plan_ids.
1501: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1497: x_return_status := FND_API.G_RET_STS_ERROR;
1498: END IF;
1499:
1500: -- validate for valid plan_ids.
1501: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1502: open c1;
1503: fetch c1 into l_plan_id;
1504: if c1%NOTFOUND then
1505: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1506: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1507: fnd_message.set_token('VALUE', p_plan_id);
1508: fnd_message.set_token('PARAMETER', 'PLAN_ID');
1509: -- fnd_msg_pub.add;
1510: x_return_status := FND_API.G_RET_STS_ERROR;
1511: end if;
1512: close c1;
1513: end if;
1514:
1536: l_party_id NUMBER;
1537: l_api_name varchar2(30) := 'Validate_Party_Id';
1538: BEGIN
1539: -- Initialize message list if p_init_msg_list is set to TRUE.
1540: IF FND_API.to_Boolean( p_init_msg_list )
1541: THEN
1542: FND_MSG_PUB.initialize;
1543: END IF;
1544:
1542: FND_MSG_PUB.initialize;
1543: END IF;
1544:
1545: -- Initialize API return status to SUCCESS
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547:
1548: -- validate NOT NULL column
1549: IF( p_PARTY_ID is NULL or p_party_id = FND_API.G_MISS_NUM ) then
1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1545: -- Initialize API return status to SUCCESS
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547:
1548: -- validate NOT NULL column
1549: IF( p_PARTY_ID is NULL or p_party_id = FND_API.G_MISS_NUM ) then
1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1551: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1552: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
1553: -- fnd_msg_pub.add;
1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1551: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1552: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
1553: -- fnd_msg_pub.add;
1554: x_return_status := FND_API.G_RET_STS_ERROR;
1555: END IF;
1556:
1557: -- validate for valid party_ids.
1558: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1554: x_return_status := FND_API.G_RET_STS_ERROR;
1555: END IF;
1556:
1557: -- validate for valid party_ids.
1558: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1559: open c1;
1560: fetch c1 into l_party_id;
1561: if c1%NOTFOUND then
1562: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1563: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1564: fnd_message.set_token('VALUE', p_party_id);
1565: fnd_message.set_token('PARAMETER', 'PARTY_ID');
1566: -- fnd_msg_pub.add;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: end if;
1569: close c1;
1570: end if;
1571:
1580: /******************************REMOVE ORG_ID 04-10-2000 ************************
1581: Incorparating TCA changes - Removing org_id reference completely
1582:
1583: PROCEDURE Validate_CUST_ACC_ORG_ID (
1584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1585: P_Validation_mode IN VARCHAR2,
1586: P_PARTY_ID IN NUMBER,
1587: P_CUST_ACCOUNT_ID IN NUMBER,
1588: P_CUST_ACCOUNT_ORG IN NUMBER,
1602: l_api_name varchar2(30) := 'Validate_Cust_Acc_Org_Id';
1603:
1604: BEGIN
1605: -- Initialize message list if p_init_msg_list is set to TRUE.
1606: IF FND_API.to_Boolean( p_init_msg_list )
1607: THEN
1608: FND_MSG_PUB.initialize;
1609: END IF;
1610:
1608: FND_MSG_PUB.initialize;
1609: END IF;
1610:
1611: -- Initialize API return status to SUCCESS
1612: x_return_status := FND_API.G_RET_STS_SUCCESS;
1613:
1614: if (p_cust_account_id is NULL or p_cust_account_org is NULL ) THEN
1615: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1616: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1621: else
1622: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ORG');
1623: end if;
1624: -- fnd_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: end if;
1627:
1628: if ( p_cust_account_id is not null and p_cust_account_org is not null ) then
1629: open c1;
1633: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1634: fnd_message.set_token('VALUE', p_cust_account_id ||', '|| p_cust_account_org);
1635: fnd_message.set_token('PARAMETER', 'CUST_ACCOUNT_ID, CUST_ACCOUNT_ORG');
1636: -- fnd_msg_pub.add;
1637: x_return_status := FND_API.G_RET_STS_ERROR;
1638: end if;
1639: close c1;
1640: end if;
1641:
1658: IS
1659: l_api_name varchar2(30) := 'Validate_Manual_Flag';
1660: BEGIN
1661: -- Initialize message list if p_init_msg_list is set to TRUE.
1662: IF FND_API.to_Boolean( p_init_msg_list )
1663: THEN
1664: FND_MSG_PUB.initialize;
1665: END IF;
1666:
1664: FND_MSG_PUB.initialize;
1665: END IF;
1666:
1667: -- Initialize API return status to SUCCESS
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: -- validate NOT NULL column
1671: IF( p_MANUAL_FLAG is NULL or p_MANUAL_FLAG = FND_API.G_MISS_CHAR ) then
1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1667: -- Initialize API return status to SUCCESS
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: -- validate NOT NULL column
1671: IF( p_MANUAL_FLAG is NULL or p_MANUAL_FLAG = FND_API.G_MISS_CHAR ) then
1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1673: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1674: fnd_message.set_token('NULL_PARAM', 'MANUAL_FLAG');
1675: -- fnd_msg_pub.add;
1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1673: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1674: fnd_message.set_token('NULL_PARAM', 'MANUAL_FLAG');
1675: -- fnd_msg_pub.add;
1676: x_return_status := FND_API.G_RET_STS_ERROR;
1677: END IF;
1678:
1679: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1680: if ( p_manual_flag <> 'Y' and p_manual_flag <> 'N' ) then
1675: -- fnd_msg_pub.add;
1676: x_return_status := FND_API.G_RET_STS_ERROR;
1677: END IF;
1678:
1679: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1680: if ( p_manual_flag <> 'Y' and p_manual_flag <> 'N' ) then
1681: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1682: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1683: fnd_message.set_token('VALUE', p_manual_flag);
1682: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1683: fnd_message.set_token('VALUE', p_manual_flag);
1684: fnd_message.set_token('PARAMETER', 'P_MANUAL_FLAG');
1685: -- fnd_msg_pub.add;
1686: x_return_status := FND_API.G_RET_STS_ERROR;
1687: end if;
1688: end if;
1689:
1690: -- Standard call to get message count and if count is 1, get message info.
1714: l_count NUMBER := 0;
1715: l_api_name varchar2(30) := 'Validate_Plan_Status_Code';
1716: BEGIN
1717: -- Initialize message list if p_init_msg_list is set to TRUE.
1718: IF FND_API.to_Boolean( p_init_msg_list )
1719: THEN
1720: FND_MSG_PUB.initialize;
1721: END IF;
1722:
1720: FND_MSG_PUB.initialize;
1721: END IF;
1722:
1723: -- Initialize API return status to SUCCESS
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1726: -- validate NOT NULL column
1727: IF (p_PLAN_STATUS_CODE is NULL or p_PLAN_STATUS_CODE = FND_API.G_MISS_CHAR) then
1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1723: -- Initialize API return status to SUCCESS
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1726: -- validate NOT NULL column
1727: IF (p_PLAN_STATUS_CODE is NULL or p_PLAN_STATUS_CODE = FND_API.G_MISS_CHAR) then
1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1729: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1730: fnd_message.set_token('NULL_PARAM', 'PLAN_STATUS_CODE');
1731: -- fnd_msg_pub.add;
1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1729: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1730: fnd_message.set_token('NULL_PARAM', 'PLAN_STATUS_CODE');
1731: -- fnd_msg_pub.add;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734:
1735: -- validate PLAN_STATUS_CODE exists in fnd_lookup_values.
1736: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734:
1735: -- validate PLAN_STATUS_CODE exists in fnd_lookup_values.
1736: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1737: open group_in_lookup;
1738: fetch group_in_lookup into l_count;
1739: close group_in_lookup;
1740:
1743: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1744: fnd_message.set_token('VALUE', p_plan_status_code);
1745: fnd_message.set_token('PARAMETER', 'P_STATUS_CODE');
1746: -- fnd_msg_pub.add;
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: end if;
1749: end if;
1750:
1751: -- Standard call to get message count and if count is 1, get message info.
1768: IS
1769: l_api_name CONSTANT VARCHAR2(30) := 'Validate_csc_cust_plans';
1770: BEGIN
1771: -- Initialize API return status to SUCCESS
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773:
1774: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1775:
1776: Validate_CUST_PLAN_ID(
1770: BEGIN
1771: -- Initialize API return status to SUCCESS
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773:
1774: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1775:
1776: Validate_CUST_PLAN_ID(
1777: p_init_msg_list => FND_API.G_TRUE,
1778: p_validation_mode => p_validation_mode,
1773:
1774: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1775:
1776: Validate_CUST_PLAN_ID(
1777: p_init_msg_list => FND_API.G_TRUE,
1778: p_validation_mode => p_validation_mode,
1779: p_CUST_PLAN_ID => P_CSC_CUST_PLANS_Rec.CUST_PLAN_ID,
1780: x_return_status => x_return_status,
1781: x_msg_count => x_msg_count,
1779: p_CUST_PLAN_ID => P_CSC_CUST_PLANS_Rec.CUST_PLAN_ID,
1780: x_return_status => x_return_status,
1781: x_msg_count => x_msg_count,
1782: x_msg_data => x_msg_data);
1783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1784: raise FND_API.G_EXC_ERROR;
1785: END IF;
1786:
1787: Validate_PLAN_ID(
1780: x_return_status => x_return_status,
1781: x_msg_count => x_msg_count,
1782: x_msg_data => x_msg_data);
1783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1784: raise FND_API.G_EXC_ERROR;
1785: END IF;
1786:
1787: Validate_PLAN_ID(
1788: p_init_msg_list => FND_API.G_TRUE,
1784: raise FND_API.G_EXC_ERROR;
1785: END IF;
1786:
1787: Validate_PLAN_ID(
1788: p_init_msg_list => FND_API.G_TRUE,
1789: p_validation_mode => p_validation_mode,
1790: p_PLAN_ID => P_CSC_CUST_PLANS_Rec.PLAN_ID,
1791: x_return_status => x_return_status,
1792: x_msg_count => x_msg_count,
1790: p_PLAN_ID => P_CSC_CUST_PLANS_Rec.PLAN_ID,
1791: x_return_status => x_return_status,
1792: x_msg_count => x_msg_count,
1793: x_msg_data => x_msg_data);
1794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1795: raise FND_API.G_EXC_ERROR;
1796: END IF;
1797:
1798: Validate_PARTY_ID(
1791: x_return_status => x_return_status,
1792: x_msg_count => x_msg_count,
1793: x_msg_data => x_msg_data);
1794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1795: raise FND_API.G_EXC_ERROR;
1796: END IF;
1797:
1798: Validate_PARTY_ID(
1799: p_init_msg_list => FND_API.G_TRUE,
1795: raise FND_API.G_EXC_ERROR;
1796: END IF;
1797:
1798: Validate_PARTY_ID(
1799: p_init_msg_list => FND_API.G_TRUE,
1800: p_validation_mode => p_validation_mode,
1801: p_PARTY_ID => P_CSC_CUST_PLANS_Rec.PARTY_ID,
1802: x_return_status => x_return_status,
1803: x_msg_count => x_msg_count,
1801: p_PARTY_ID => P_CSC_CUST_PLANS_Rec.PARTY_ID,
1802: x_return_status => x_return_status,
1803: x_msg_count => x_msg_count,
1804: x_msg_data => x_msg_data);
1805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: raise FND_API.G_EXC_ERROR;
1807: END IF;
1808:
1809: /******************************REMOVE ORG_ID************************
1802: x_return_status => x_return_status,
1803: x_msg_count => x_msg_count,
1804: x_msg_data => x_msg_data);
1805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: raise FND_API.G_EXC_ERROR;
1807: END IF;
1808:
1809: /******************************REMOVE ORG_ID************************
1810: Incorparating TCA changes - Removing org_id reference completely
1809: /******************************REMOVE ORG_ID************************
1810: Incorparating TCA changes - Removing org_id reference completely
1811:
1812: Validate_CUST_ACC_ORG_ID (
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_validation_mode => p_validation_mode,
1815: p_PARTY_ID => P_CSC_CUST_PLANS_Rec.PARTY_ID,
1816: p_CUST_ACCOUNT_ID => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ID,
1817: p_CUST_ACCOUNT_ORG => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ORG,
1817: p_CUST_ACCOUNT_ORG => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ORG,
1818: x_return_status => x_return_status,
1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data);
1821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1822: raise FND_API.G_EXC_ERROR;
1823: END IF;
1824: **********************************************************/
1825:
1818: x_return_status => x_return_status,
1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data);
1821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1822: raise FND_API.G_EXC_ERROR;
1823: END IF;
1824: **********************************************************/
1825:
1826: Validate_MANUAL_FLAG(
1823: END IF;
1824: **********************************************************/
1825:
1826: Validate_MANUAL_FLAG(
1827: p_init_msg_list => FND_API.G_TRUE,
1828: p_validation_mode => p_validation_mode,
1829: p_MANUAL_FLAG => P_CSC_CUST_PLANS_Rec.MANUAL_FLAG,
1830: x_return_status => x_return_status,
1831: x_msg_count => x_msg_count,
1829: p_MANUAL_FLAG => P_CSC_CUST_PLANS_Rec.MANUAL_FLAG,
1830: x_return_status => x_return_status,
1831: x_msg_count => x_msg_count,
1832: x_msg_data => x_msg_data);
1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1834: raise FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: Validate_PLAN_STATUS_CODE(
1830: x_return_status => x_return_status,
1831: x_msg_count => x_msg_count,
1832: x_msg_data => x_msg_data);
1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1834: raise FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: Validate_PLAN_STATUS_CODE(
1838: p_init_msg_list => FND_API.G_TRUE,
1834: raise FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: Validate_PLAN_STATUS_CODE(
1838: p_init_msg_list => FND_API.G_TRUE,
1839: p_validation_mode => p_validation_mode,
1840: p_PLAN_STATUS_CODE => P_CSC_CUST_PLANS_Rec.PLAN_STATUS_CODE,
1841: x_return_status => x_return_status,
1842: x_msg_count => x_msg_count,
1840: p_PLAN_STATUS_CODE => P_CSC_CUST_PLANS_Rec.PLAN_STATUS_CODE,
1841: x_return_status => x_return_status,
1842: x_msg_count => x_msg_count,
1843: x_msg_data => x_msg_data);
1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1845: raise FND_API.G_EXC_ERROR;
1846: END IF;
1847:
1848: /*
1841: x_return_status => x_return_status,
1842: x_msg_count => x_msg_count,
1843: x_msg_data => x_msg_data);
1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1845: raise FND_API.G_EXC_ERROR;
1846: END IF;
1847:
1848: /*
1849: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1846: END IF;
1847:
1848: /*
1849: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1850: p_init_msg_list => FND_API.G_TRUE,
1851: p_validation_mode => p_validation_mode,
1852: P_COLUMN_NAME => 'CREATION_DATE',
1853: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATION_DATE,
1854: x_return_status => x_return_status,
1853: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATION_DATE,
1854: x_return_status => x_return_status,
1855: x_msg_count => x_msg_count,
1856: x_msg_data => x_msg_data);
1857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1858: raise FND_API.G_EXC_ERROR;
1859: END IF;
1860:
1861: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1854: x_return_status => x_return_status,
1855: x_msg_count => x_msg_count,
1856: x_msg_data => x_msg_data);
1857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1858: raise FND_API.G_EXC_ERROR;
1859: END IF;
1860:
1861: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1862: p_init_msg_list => FND_API.G_TRUE,
1858: raise FND_API.G_EXC_ERROR;
1859: END IF;
1860:
1861: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1862: p_init_msg_list => FND_API.G_TRUE,
1863: p_validation_mode => p_validation_mode,
1864: P_COLUMN_NAME => 'LAST_UPDATE_DATE',
1865: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATE_DATE,
1866: x_return_status => x_return_status,
1865: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATE_DATE,
1866: x_return_status => x_return_status,
1867: x_msg_count => x_msg_count,
1868: x_msg_data => x_msg_data);
1869: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1870: raise FND_API.G_EXC_ERROR;
1871: END IF;
1872:
1873: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1866: x_return_status => x_return_status,
1867: x_msg_count => x_msg_count,
1868: x_msg_data => x_msg_data);
1869: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1870: raise FND_API.G_EXC_ERROR;
1871: END IF;
1872:
1873: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1874: p_init_msg_list => FND_API.G_TRUE,
1870: raise FND_API.G_EXC_ERROR;
1871: END IF;
1872:
1873: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1874: p_init_msg_list => FND_API.G_TRUE,
1875: p_validation_mode => p_validation_mode,
1876: P_COLUMN_NAME => 'CREATED_BY',
1877: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATED_BY,
1878: x_return_status => x_return_status,
1877: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATED_BY,
1878: x_return_status => x_return_status,
1879: x_msg_count => x_msg_count,
1880: x_msg_data => x_msg_data);
1881: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1882: raise FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1878: x_return_status => x_return_status,
1879: x_msg_count => x_msg_count,
1880: x_msg_data => x_msg_data);
1881: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1882: raise FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1886: p_init_msg_list => FND_API.G_TRUE,
1882: raise FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1886: p_init_msg_list => FND_API.G_TRUE,
1887: p_validation_mode => p_validation_mode,
1888: P_COLUMN_NAME => 'LAST_UPDATED_BY',
1889: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATED_BY,
1890: x_return_status => x_return_status,
1889: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATED_BY,
1890: x_return_status => x_return_status,
1891: x_msg_count => x_msg_count,
1892: x_msg_data => x_msg_data);
1893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1894: raise FND_API.G_EXC_ERROR;
1895: END IF;
1896:
1897: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1890: x_return_status => x_return_status,
1891: x_msg_count => x_msg_count,
1892: x_msg_data => x_msg_data);
1893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1894: raise FND_API.G_EXC_ERROR;
1895: END IF;
1896:
1897: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1898: p_init_msg_list => FND_API.G_TRUE,
1894: raise FND_API.G_EXC_ERROR;
1895: END IF;
1896:
1897: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1898: p_init_msg_list => FND_API.G_TRUE,
1899: p_validation_mode => p_validation_mode,
1900: P_COLUMN_NAME => 'OBJECT_VERSION_NUMBER',
1901: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.OBJECT_VERSION_NUMBER,
1902: x_return_status => x_return_status,
1901: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.OBJECT_VERSION_NUMBER,
1902: x_return_status => x_return_status,
1903: x_msg_count => x_msg_count,
1904: x_msg_data => x_msg_data);
1905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1906: raise FND_API.G_EXC_ERROR;
1907: END IF;
1908: */
1909: END IF;
1902: x_return_status => x_return_status,
1903: x_msg_count => x_msg_count,
1904: x_msg_data => x_msg_data);
1905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1906: raise FND_API.G_EXC_ERROR;
1907: END IF;
1908: */
1909: END IF;
1910: