791:
792: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
795: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
796: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
797: FND_MSG_PUB.ADD;
798: END IF;
799: END IF;
792: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
795: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
796: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
797: FND_MSG_PUB.ADD;
798: END IF;
799: END IF;
800:
824:
825: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
829: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
830: FND_MSG_PUB.ADD;
831: END IF;
832: END IF;
825: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
829: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
830: FND_MSG_PUB.ADD;
831: END IF;
832: END IF;
833:
870: IF (C_Content_Type_Status%NOTFOUND) THEN
871: CLOSE C_Content_Type_Status;
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
874: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
875: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT_TYPE_STATUS', FALSE);
876: FND_MSG_PUB.ADD;
877: END IF;
878: ELSE
871: CLOSE C_Content_Type_Status;
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
874: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
875: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT_TYPE_STATUS', FALSE);
876: FND_MSG_PUB.ADD;
877: END IF;
878: ELSE
879: CLOSE C_Content_Type_Status;
912: IF (C_Get_Appl_Id%NOTFOUND) THEN
913: CLOSE C_Get_Appl_Id;
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
916: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
917: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION SHORT NAME', FALSE);
918: FND_MSG_PUB.ADD;
919: END IF;
920: ELSE
913: CLOSE C_Get_Appl_Id;
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
916: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
917: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION SHORT NAME', FALSE);
918: FND_MSG_PUB.ADD;
919: END IF;
920: ELSE
921: CLOSE C_Get_Appl_Id;
956: IF (C_Get_Appl_Id%NOTFOUND) THEN
957: CLOSE C_Get_Appl_Id;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
961: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION ID', FALSE);
962: FND_MSG_PUB.ADD;
963: END IF;
964: ELSE
957: CLOSE C_Get_Appl_Id;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
961: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION ID', FALSE);
962: FND_MSG_PUB.ADD;
963: END IF;
964: ELSE
965: CLOSE C_Get_Appl_Id;
999: IF (C_CType_Code%NOTFOUND) THEN
1000: CLOSE C_CType_Code;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1003: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1004: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT TYPE CODE', FALSE);
1005: FND_MSG_PUB.ADD;
1006: END IF;
1007: ELSE
1000: CLOSE C_CType_Code;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1003: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1004: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT TYPE CODE', FALSE);
1005: FND_MSG_PUB.ADD;
1006: END IF;
1007: ELSE
1008: CLOSE C_CType_Code;
1044: IF (C_Data_type_Code%NOTFOUND) THEN
1045: CLOSE C_Data_type_Code;
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1048: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1049: FND_MESSAGE.Set_Token('COLUMN', 'DATA_TYPE_CODE', FALSE);
1050: FND_MSG_PUB.ADD;
1051: END IF;
1052: ELSE
1045: CLOSE C_Data_type_Code;
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1048: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1049: FND_MESSAGE.Set_Token('COLUMN', 'DATA_TYPE_CODE', FALSE);
1050: FND_MSG_PUB.ADD;
1051: END IF;
1052: ELSE
1053: CLOSE C_Data_type_Code;
1115: IF (C_content_item_id%NOTFOUND) THEN
1116: CLOSE C_content_item_id;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1120: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1121: FND_MSG_PUB.ADD;
1122: END IF;
1123: ELSE
1116: CLOSE C_content_item_id;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1120: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1121: FND_MSG_PUB.ADD;
1122: END IF;
1123: ELSE
1124: CLOSE C_content_item_id;
1140: IF (C_file_id%NOTFOUND) THEN
1141: CLOSE C_file_id;
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1144: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1145: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1146: FND_MSG_PUB.ADD;
1147: END IF;
1148: ELSE
1141: CLOSE C_file_id;
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1144: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1145: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1146: FND_MSG_PUB.ADD;
1147: END IF;
1148: ELSE
1149: CLOSE C_file_id;
1194:
1195: END IF;
1196:
1197: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1198: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1199: FND_MESSAGE.Set_Token('COLUMN', 'Reference Code', FALSE);
1200: FND_MSG_PUB.ADD;
1201: END IF;
1202:
1195: END IF;
1196:
1197: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1198: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1199: FND_MESSAGE.Set_Token('COLUMN', 'Reference Code', FALSE);
1200: FND_MSG_PUB.ADD;
1201: END IF;
1202:
1203: END Validate_Reference_Code;
1223: -- Max Instance cannot be greater than Min Instances
1224: IF (p_MAX_Instances < 1 OR p_min_instances < 0 OR NVL(p_Max_Instances,p_Min_Instances+1) < p_Min_Instances ) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1227: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1228: FND_MESSAGE.Set_Token('COLUMN','MAX Instances', FALSE);
1229: FND_MSG_PUB.ADD;
1230: END IF;
1231: END IF;
1224: IF (p_MAX_Instances < 1 OR p_min_instances < 0 OR NVL(p_Max_Instances,p_Min_Instances+1) < p_Min_Instances ) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1227: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1228: FND_MESSAGE.Set_Token('COLUMN','MAX Instances', FALSE);
1229: FND_MSG_PUB.ADD;
1230: END IF;
1231: END IF;
1232:
1266: IF (C_jtf_resources%NOTFOUND) THEN
1267: CLOSE C_jtf_resources;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1270: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1271: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE_ID', FALSE);
1272: FND_MSG_PUB.ADD;
1273: END IF;
1274: ELSE
1267: CLOSE C_jtf_resources;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1270: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1271: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE_ID', FALSE);
1272: FND_MSG_PUB.ADD;
1273: END IF;
1274: ELSE
1275: CLOSE C_jtf_resources;